ADM GRAD CITIZENSHIP Table
This is a dimension table used for querying the graduate admissions application data. This table contains the nationality and citizenship status of the applicants as recorded in the admissions system when the decision to the application is made official.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_CITIZENSHIP_KEY |
Graduate Admissions Citizenship Key. Use this field to join the ADM GRAD CITIZENSHIP table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
4 |
CITIZENSHIP_STATUS |
Citizenship status of the applicant. Possible values are: International, Permanent Resident, US Citizen, Unknown. |
VARCHAR2 |
30 |
IS_CITIZEN |
A flag indicating whether the applicant is a U.S. citizen: Y/N |
VARCHAR2 |
1 |
NATIONALITY |
The nationality of the applicant |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |