This dimension captures the Person citizenship Information
Module: Global Human Resources
CITIZENSHIP_ID
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 | 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, 2023, Oracle and/or its affiliates.