DW_JOB_LEGISLATION_D

DW_JOB_LEGISLATION_D stores legislative attributes of jobs.

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, JOB_LEG_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
JOB_LEG_ID NUMBER 38 0 True Job legislative ID - unique identifier    
EFFECTIVE_START_DATE DATE     True Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective    
EFFECTIVE_END_DATE DATE     True Date Effective Entity: indicates the date at the end of the date range within which the row is effective    
SOURCE_RECORD_ID VARCHAR2 256     System generated - unique identifier    
JOB_ID NUMBER 38 0   Job Identifier DW_JOB_D JOB_ID
LEGISLATION_CODE VARCHAR2 32     Legislation code derived from legal entity    
INFORMATION_CATEGORY VARCHAR2 32     Developer Descriptive Flexfield: structure definition of the user descriptive flexfield    
INFORMATION1 VARCHAR2 256     Developer Descriptive Flexfield: segment of the developer descriptive flexfield    
INFORMATION2 VARCHAR2 256     Developer Descriptive Flexfield: segment of the developer descriptive flexfield    
INFORMATION3 VARCHAR2 256     Developer Descriptive Flexfield: segment of the developer descriptive flexfield    
INFORMATION4 VARCHAR2 256     Developer Descriptive Flexfield: segment of the developer descriptive flexfield    
INFORMATION5 VARCHAR2 256     Developer Descriptive Flexfield: segment of the developer descriptive flexfield    

Notes

#1 DW_JOB_D_TL is date effective. Along with JOB_ID join on dates.

#2 DW_JOB_FAMILY_D is date effective. Along with JOB_FAMILY_ID join on dates.