Penn Computing

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

COMP_ROLE_JOB_CLASS_XREF Table - Data Element Index

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



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.
      

COMP_ROLE_JOB_CLASS_XREF 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