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

Copyright © 2019, 2026, Oracle and/or its affiliates.