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   Uniquely identifies a Legal Employer    
STATUS_CODE VARCHAR2 32     Indicates if a Legal Employer is active or inactive. For translation, refer table DW_CODE_VALUES_LKP_TL with CODE_TYPE='ACTIVE_INACTIVE'    
LEGISLATION_CODE VARCHAR2 32     Legislation code derived from Legal Entity, Translation in DW_LEGISLATION_D_TL table.    

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