Penn Computing

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

COMP_INCREASE_ROLE Table - Data Element Index

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



Data element Definition
COMP_INCREASE_ROLE_ID

Indexed - yes
Format - number (12)
May be null? no
Uniquely identifies a record in the COMP_INCREASE_ROLE table.
COMP_PERSON_ROLE_ID

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

Indexed - no
Format - varchar2 (12)
May be null? yes
The Penn ID of the PennWorks user who created the record in the PennWorks Salary Increase Program module.
 
CREATION_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the record was created in the PennWorks Salary Increase Program module.
 
CURRENT_ANNUAL_SALARY

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

Indexed - no
Format - number (9,3)
May be null? yes
The current pay rate for the role. Depending upon the employee type, the pay rate will be a pay period amount or hourly rate.
CURRENT_TERM_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_TERM_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.
EXTRACT_DATE

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

Indexed - yes
Format - varchar2 (4)
May be null? yes
The fiscal year to which this role increase record applies, derived from the related Salary Increase Program batch.
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_BATCH_DESC

Indexed - yes
Format - varchar2 (300)
May be null? yes
Textual description of the related Salary Increase Program batch.
Values:
Refer to the DWADMIN.COMP_INCREASE_BATCH table for values.
INCREASE_BATCH_ID

Indexed - yes
Format - number
May be null? yes
Unique identifier for the related Salary Increase Program batch.
Values:
Refer to the DWADMIN.COMP_INCREASE_BATCH table for values.
JOB_CLASS

Indexed - yes
Format - varchar (6)
May be null? yes
The 6-digit code indicating the job held by the employee. Key to the job classification table where the job attributes are listed. Refer to Job_Title in the JOB_CLASS or JOB_CLASS_GENERAL tables to find the title which currently corresponds to the Job_Class.

Example: 226010 (Associate Professor C-E)


Values:

Refer to the DWADMIN.JOB_CLASS table for values.
JUSTIFICATION

Indexed - no
Format - varchar2 (100)
May be null? yes
An additional textual description for the "Other" justification value that falls outside the Salary Increase Program parameters.
LAST_UPDATED_BY

Indexed - no
Format - varchar2 (12)
May be null? yes
The Penn ID of the PennWorks user who last updated the record in the PennWorks Salary Increase Program module.
 

LAST_UPDATE_DATE

Indexed - no
Format - date (7)
May be null? no

The date on which the record was last updated in the PennWorks Salary Increase Program module.

LAST_UPDATE_TIMESTAMP

Indexed - no
Format - timestamp (6)
May be null? no

The timestamp on which the record was last updated in the PennWorks Salary Increase Program module.
NEW_ANNUAL_SALARY

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

Indexed - no
Format - number (9,3)
May be null? yes
The new pay rate planned for the role. Depending upon the employee type, the pay rate will be a pay period amount or hourly rate.
NEW_TERM_END_DATE

Indexed - no
Format - date (7)
May be null? yes
The new end date planned for the term for which the person holds the role.
PENN_ID

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

The 8-digit identification number assigned to an individual by the 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.

PERCENT_INCREASE

Indexed - no
Format - number (5,2)
May be null? yes
The percent increase that is to be applied to the annual salary or pay rate for this role.
POSITION_NUMBER

Indexed - no
Format - number (7,0)
May be null? yes

The 7-digit number that identifies a position at the University of Pennsylvania. A position is an assignment of a person to perform a specific job in a specific organization that is supported by specific funding source(s). Over time, the person, job classification, organization, and funding sources associated with a position may change. As of this writing (August, 2009), faculty, temporary workers, and student workers do not have a number. In instances where no number is available, the element Position_Number will be zero.

 

PROCESS_DATE

Indexed - no
Format - date (7)
May be null? yes
The date when the planned changes from this Salary Increase Program record the corresponding role record in PennWorks.
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.

COMP_INCREASE_ROLE 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