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

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