Penn Computing

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

COMP_INCREASE_PAY_ADJUSTMENTS Table - Data Element Index

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



Data element Definition
ADJUSTMENT_DOLLARS

Indexed - no
Format - number (10,3)
May be null? yes
The pay adjustment requested, represented in dollars.
ADJUSTMENT_PERCENT

Indexed - no
Format - number (10,3)
May be null? yes
The pay adjustment requested, represented as a percentage.
 
APPROVAL_TIMESTAMP

Indexed - no
Format - timestamp (6)
May be null? yes
The system timestamp when the approval was given.
APPROVED

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates (Y/N) if the adjustment has been approved at the current tier in the process.
APPROVER_PENN_ID

Indexed - yes
Format - varchar2 (12)
May be null? yes
The Penn ID of the person approving or submitting this adjustment.
COMP_PERSON_ROLE_ID

Indexed - yes
Format - number (12)
May be null? yes
Uniquely identifies the related role record in the COMP_PERSON_ROLE table.
 
CREATED_BY

Indexed - no
Format - varchar2 (12)
May be null? yes
The Penn ID of the user who created the record in the salary modeling application.
CREATION_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the record was created in the salary modeling application.
CURRENT_ANNUAL_SALARY

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

Indexed - no
Format - number (10,3)
May be null? yes
The current hourly rate for the role. A value is only present for applicable roles.
DELEGATED

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates (Y/N) whether the record is pending input from a delegate.
DELEGATION_APPROVER

Indexed - no
Format - number
May be null? yes
The unique system identifier for the parent approver.
DISABLED_DATE

Indexed - no
Format - date (7)
May be null? yes
The date on which the record was disabled (in favor of a later record) or deleted.
EXCLUDED

Indexed - no
Format - varchar2 (1)
May be null? yes
Indicates (Y/N) whether the record is to be excluded from the pool and is not to receive an adjustment.
EXTRACT_DATE

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

Indexed - no
Format - number (10,3)
May be null? yes

Upper bound percentage assigned during the delegation process for faculty roles. If the modeled percentage adjustment is above this value, a justification is required.

Example: 3

FACULTY_MINIMUM_PERCENT

Indexed - no
Format - number (10,3)
May be null? yes

Lower bound percentage assigned during the delegation process for faculty roles. If the modeled percentage adjustment is below this value, a justification is required.

Example: 0

FINAL_APPROVER_PENN_ID

Indexed -yes
Format - varchar2 (8)
May be null? yes
The Penn ID of the final approver for this record, as selected by the school/center administrator.
FISCAL_YEAR_EFFECTIVE

Indexed - no
Format - char (4)
May be null? yes
The fiscal year relevant to this adjustment record.
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_JUSTIFICATION_ID

Indexed - no
Format - number
May be null? yes
Identifies the justification for any pay adjustment that falls outside the parameters specified by the delegator.
Values:
Refer to the DWCOMP.COMP_JUSTIFICATION_LIST table
for values.
INCREASE_JUSTIFICATION_TEXT

Indexed - no
Format - varchar2 (4000)
May be null? yes
An additional textual description for the "Other" justification value that falls outside the parameters specified by the delegator.
INCREASE_PAY_ADJUSTMENTS_ID

Indexed - yes
Format - number
May be null? no
Uniquely identifies a record in the COMP_INCREASE_PAY_ADJUSTMENTS table.
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.

    
LAST_UPDATED_BY

Indexed - no
Format - varchar2 (12)
May be null? yes
The Penn ID of the user who last updated the record in the salary modeling application.
 

LAST_UPDATE_DATE

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

The date on which the record was last updated in the salary modeling application.

LAST_UPDATE_TIMESTAMP

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


The timestamp on which the record was last updated in the salary modeling application.
 
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.

POOL_SIZE_PERCENT

Indexed - no
Format - number (10,3)
May be null? yes
Overall percentage assigned during the delegation process for both staff and faculty.
RESPONSIBLE_CENTER

Indexed - yes
Format - varchar2 (2)
May be null? yes

The 2-digit code representing the school or center currently responsible for this adjustment record.

Example: 40 (School of Medicine)

Values:
Refer to the DWADMIN.ORG_CODES table, for values where 
Role_Center = Center_Code.
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.
STAFF_MAXIMUM_PERCENT

Indexed - no
Format - number (10,3)
May be null? yes

Upper bound percentage assigned during the delegation process for staff roles. If the modeled percentage adjustment is above this value, a justification is required.

Example: 2

STAFF_MINIMUM_PERCENT

Indexed - no
Format - number (10,3)
May be null? yes

Lower bound percentage assigned during the delegation process for staff roles. If the modeled percentage adjustment is below this value, a justification is required.

Example: 0


COMP_INCREASE_PAY_ADJUSTMENTS 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