DW_PERSON_CITIZENSHIP_D
This dimension captures the Person citizenship Information
Details
Module: Global Human Resources
Key Columns
CITIZENSHIP_ID
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 |