DW_PERSON_CITIZENSHIP_D

This dimension captures the Person citizenship Information

Details

Module: Global Human Resources

Key Columns

CITIZENSHIP_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CITIZENSHIP_ID NUMBER 38 0 True Person Citizenship Identifier
SOURCE_RECORD_ID NUMBER 38 0 This column is for Oracle Internal use only. Source Record Identifier Uniquely identifies the person citizenships and used as the primary key
DATE_FROM DATE Start date of citizenship
DATE_TO DATE End date of citizenship
PERSON_ID NUMBER 38 0 Person Identifier
LEGISLATION_CODE VARCHAR2 32 Legislation code of the citizenship DW_LEGISLATION_D_TL LEGISLATION_CODE
CITIZENSHIP_STATUS VARCHAR2 32 Status of citizenship DW_CITIZENSHIP_STATUS_D_TL CITIZENSHIP_STATUS