| Data element |
Definition |
COMP_PERSON_SALARY_ID
Indexed - yes
Format - number (12)
May be null? no
|
Uniquely identifies a record in the COMP_PERSON_SALARY table.
|
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 application.
|
CREATION_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date on which the record was created in the PennWorks application.
|
EXTRACT_DATE
Indexed - no
Format - date (7)
May be null? yes
|
The date on which the COMP_PERSON_SALARY record was loaded to the Data Warehouse.
|
HOME_CENTER
Indexed - yes
Format - varchar (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 - varchar (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.
|
LAST_ACTION_ID
Indexed - no
Format - number (12)
May be null? yes
|
The unique identifier of the last update action performed in the online PennWorks system for the employee/role record.
|
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 application.
|
|
LAST_UPDATE_DATE
Indexed - yes
Format - date (7)
May be null? no
|
The date on which the record was last updated in the PennWorks application.
|
LAST_UPDATE_TIMESTAMP
Indexed - no
Format - timestamp (6)
May be null? no
|
The timestamp on which the record was last updated in the PennWorks application.
|
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.
|
SALARY_AMOUNT
Indexed - no
Format - number (10,3)
May be null? yes |
The amount of salary of the designated salary type, for the individual, for a fiscal year. |
SALARY_END_DATE
Indexed - yes
Format - date (7)
May be null? yes |
The end date as of which the person is or was planned to receive the salary amount. |
SALARY_END_FISCAL_YEAR
Indexed - yes
Format - varchar2 (4)
May be null? yes |
The fiscal year within which the Salary_End_Date falls. |
SALARY_END_YEAR
Indexed - yes
Format - varchar2 (4)
May be null? yes |
The calendar year within which the Salary_End_Date falls. |
SALARY_START_DATE
Indexed - yes
Format - date (7)
May be null? yes |
The beginning date as of which the person is or was planned to receive the salary amount. |
SALARY_START_FISCAL_YEAR
Indexed - yes
Format - varchar2 (4)
May be null? yes |
The fiscal year within which the Salary_Start_Date falls. |
SALARY_START_YEAR
Indexed - yes
Format - varchar2 (4)
May be null? yes |
The calendar year within which the Salary_Start_Date falls. |
SALARY_STATE
Indexed - yes
Format - varchar2 (1)
May be null? yes |
Selected by the user to indicate the record is ready to be processed by the system if/when appropriate. Records with a state value of ‘P’ (projected) will remain in the PennWorks work area only. Users may select to delete records from PennWorks; these rows are retained in in the Data Warehouse for historical purposes with a state of 'X'.
Values:
Refer to the DWADMIN.ROLE_DIST_STATE_LOOKUP
table for values.
|
SALARY_TYPE
Indexed - yes
Format - varchar2 (1)
May be null? yes
|
Identifies the type of compensation.
Values:
Refer to the DWCOMP.COMP_CATEGORY_LOOKUP table for values.
|
