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
| 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.