DW_LEGAL_EMPLOYER_D

This table stores the Legal Employers information

Details

Module:

Key Columns

LEGAL_EMPLOYER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEGAL_EMPLOYER_ID NUMBER 38 0 True Legal Employer Id, Translation in DW_INTERNAL_ORG_D_TL table.
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Uniquely identifies a Legal Employer
STATUS_CODE VARCHAR2 32 Indicates if a Legal Employer is active or inactive. For translation, refer table DW_ACTIVE_INACTIVE_LKP_TL with CODE_TYPE='ACTIVE_INACTIVE' DW_ACTIVE_INACTIVE_LKP_TL ACTIVE_INACTIVE_LKP_CODE
LEGISLATION_CODE VARCHAR2 32 Legislation code derived from Legal Entity, Translation in DW_LEGISLATION_D_TL table.