DW_JOB_LEGISLATION_D

DW_JOB_LEGISLATION_D stores legislative attributes of jobs.

Details

Module: Global Human Resources

Key Columns

EFFECTIVE_END_DATE, JOB_LEG_ID, EFFECTIVE_START_DATE

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 This column is for Oracle Internal use only. 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.