| Data element |
Definition |
COMP_ROLE_JOB_CLASS_ID
Indexed - yes
Format - number (12)
May be null? no
|
Uniquely identifies a record in the COMP_ROLE_JOB_CLASS_XREF 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_ROLE_JOB_CLASS_XREF record was loaded to the Data Warehouse.
|
JOB_CLASS
Indexed - yes
Format - varchar (6)
May be null? yes
|
The 6-digit code indicating the job mapped to the role.
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 - yes
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 - yes
Format - timestamp (6)
May be null? no
|
The timestamp on which the record was last updated in the PennWorks application.
|
ROLE_ID
Indexed - yes
Format - number (12)
May be null? yes
|
The unique identifier indicating the role mapped to the job class.indicating the job mapped to the role.
Refer to Comp_Role_Code_Desc in the COMP_ROLE_LOOKUP table to find
the title which currently corresponds to the role.
Values:
Refer to the DWCOMP.COMP_ROLE_LOOKUP table for values.
|
