DW_PERSON_ETHNICITY_D

This dimension captures the Person Ethnicity Information

Details

Module: Global Human Resources

Key Columns

ETHNICITY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ETHNICITY_ID NUMBER 38 0 True Person Enthnicity Identifier    
SOURCE_RECORD_ID NUMBER 38 0   Source Record Identifier Uniquely identifies the Person Ethnicity and used as the primary key    
PERSON_ID NUMBER 38 0   Person Identifier DW_PERSON_D PERSON_ID
LEGISLATION_CODE VARCHAR2 32     Legislation code derived from Legal Entity. DW_LEGISLATION_D_TL LEGISLATION_CODE
ETHNICITY VARCHAR2 32     Ethnicity.Valid for the legislation code DW_ETHNICITY_D_TL ETHNICITY

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