DW_JOB_LEGISLATION_D stores legislative attributes of jobs.
Module: Global Human Resources
JOB_LEG_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
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 |
#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.