Penn Computing

University of Pennsylvania
Penn Computing << go backback
COMP_INCREASE_ROLE_TEMPLATE Table   Tables and Data Elements    Salary Management Home   Data Warehouse Home

COMP_INCREASE_ROLE_TEMPLATE Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.



Data element Definition
BARGAINING_UNIT

Indexed - no
Format - varchar2 (2)
May be null? yes
A 2-position code indicating the bargaining unit associated with the job class.
COMP_PERSON_ROLE_ID

Indexed - yes
Format - number (12)
May be null? no
Uniquely identifies a record in the COMP_PERSON_ROLE table; can be used to determine the role to which the record applies.
 
CURRENT_ANNUAL_SALARY

Indexed - no
Format - number (10,3)
May be null? yes
The current annual salary for the job appointment. A value is only present for applicable job appointments.
CURRENT_END_DATE

Indexed - no
Format - date (7)
May be null? yes
The end date of the term for which the person currently holds the role.
CURRENT_HOURLY_RATE

Indexed - no
Format - number (9,3)
May be null? yes
The current hourly rate for the job appointment. A value is only present for applicable job appointments.
CURRENT_PAY_PERIOD_AMT

Indexed - no
Format - number (9,3)
May be null? yes
The current pay period amount for the job appointment
CURRENT_START_DATE

Indexed - no
Format - date (7)
May be null? yes
The start date of the term for which the person currently holds the role.
EMPLOYEE_GROUP_ID

Indexed - no
Format - number (12)
May be null? yes
The employee group to which the role belongs (e.g., Exempt Salaried Sate, Faculty, Non-Exempt Salaried Staff, Non-Exempty Hourly Staff).
EXTRACT_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the COMP_PERSON_ROLE record was loaded to the Data Warehouse.
 
HOME_CENTER

Indexed - yes
Format - varchar2 (2)
May be null? yes
A 2-digit number used to identify the school or center that owns the employee's record and is responsible for its maintenance. The code set is from the University's General Ledger, and has been in use since July 1, 1996.

Example: 40 (School of Medicine)

Values:
Refer to the DWADMIN.ORG_CODES table, for values where 
Home_Center = Center_Code.
HOME_ORG

Indexed - yes
Format - varchar2 (4)
May be null? yes
The 4-digit number that represents the organization that owns the employee's record and is responsible for its maintenance. An organization is a subdivision of the University created for management purposes. An Organization belongs to only one School or Responsibility Center, and its organization code is unique. (The code set is from the University's General Ledger, and has been in use since July 1, 1996.)

Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)

Values:
Refer to the DWADMIN.ORG_CODES table for values.
INCREASE_ELIGIBLE_EMPLOYEE

Indexed - no
Format - varchar2 (3)
May be null? yes
Indicates (yes/no) whether the employee is eligible for the Salary Increase Program.
INCREASE_ELIGIBLE_ROLE

Indexed - no
Format - varchar2 (3)
May be null? yes
Indicates (yes/no) whether the specific role for the employee is eligible for the Salary Increase Program.
MIN_OF_SAL_GRADE

Indexed - no
Format - number (9,3)
May be null? yes
The minimum salary rate applied to all job classes in the job grade (in which the job class for this role falls) as part of the Salary Increase Program process.
PENN_ID

Indexed - yes
Format - char (8)
May be null? yes

The 8-digit identification number assigned to an individual by Penn Community system. For example: 77777777. No two persons have the same Penn ID. Note that Penn IDs created in and assigned by Penn Community begin at 10000000. Within the Data Warehouse, the numeric range from 00000000-00999999 is used for individuals who do not yet have a Penn ID in Penn Community, to allow for reliable joins between tables using the PENN_ID column. When a Penn ID appears for the individual appear in Penn Community, it will replace the assigned value throughout the Data Warehouse.

ROLE_CENTER

Indexed - yes
Format - varchar2 (2)
May be null? yes
The 2-digit number that represents the school or center in which the person performs the role.. The code set is from the University's General Ledger, and has been in use since July 1, 1996.

Example: 40 (School of Medicine)

Values:
Refer to the DWADMIN.ORG_CODES table, for values where 
Role_Center = Center_Code.
ROLE_ORG

Indexed - yes
Format - varchar2 (4)
May be null? yes
The 4-digit number that represents the organization in which the person performs the role. An organization is a subdivision of the University created for management purposes. An Organization belongs to only one School or Responsibility Center, and its organization code is unique. (The code set is from the University's General Ledger, and has been in use since July 1, 1996.)

Examples: 0104 (CHEMISTRY); 0001 (GEN UNIVERSITY)

Values:

Refer to the DWADMIN.ORG_CODES table for values.
UNDER_MINIMUM

Indexed - no
Format - number (10,3)
May be null? yes
If the current salary rate is less than the minimum for the salary grade, the difference between the minimum for the salary grade and the current salary.
YEARS_IN_ROLE

Indexed - no
Format - number (9,2)
May be null? yes
The number of years the employee has held the particular role.

COMP_INCREASE_ROLE_TEMPLATE Table   Tables and Data Elements    Salary Management Home   Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania