| Page Properties |
|---|
|
System Report Field Name | Derived using CITIZENSHIP_STATUS and COUNTRY Example: CITIZENSHIP.CITIZENSHIP_STATUS [Code] CITIZENSHIP. COUNTRY [Code] CITIZEN_STS_TBL.DESCR [Description] COUNTRY_TBL.DESCR [Description] | Panel |
|---|
| Example: ETHNIC_GRP_CD/ETHNC_ETHNICITY_CODE [Code] ETHNIC_GRP_TBL.DESCR50 [Description] ETHNIC_GRP_TBL.ETHNIC_GROUP [Group] |
|
|---|
Definition/Usage | Determines a student’s citizenship status in a country. This data is collected at admissions and students may have multiple rows. Use a combination of the status field and country field to find a student’s status of citizenship. |
|---|
Values | Example: Student abc123 has two rows. Their native country is India but also have a citizenship status of “Alien Temporary” in the United Status. Student# Status Desc Country Country Description
abc123 1 Native IND India abc123 4 Alien Temporary USA United States abd222 1 Native USA United States acc321 2 Naturalized USA United States panel |
|---|
| |
|---|
Notes |
|---|
| Example: [Code] - [Description] - [Group] WHITE - White - 1 BLACK - Black/African American - 2 EUROPE - Europe -1 HISP - Hispanic - 3 MIDDEAST - Middle East - 1 ASIAN - Asian - 4 PHILIPP - Philippines - 4 UNKNOWN - Unknown - 6 +more
A full list of all values available for [insert element] can be found [insert table or location]. ETHNIC_GRP_TBL.ETHNIC_GROUP [Group] | Notes | To find a student’s citizenship status in the USA, use the student’s emplid to find USA in the CITIZENSHIP.COUNTRY field. The corresponding CITIZENSHIP.CITIZENSHIP_STATUS field saves their status. |
|---|
Synonyms/References | [provide any synonyms or useful references] Student Administration A student’s Native country will have a 1 in the CITIZENSHIP_STATUS field and their native country will be stored in the CITIZENSHIP.COUNTRY field. To find all students whose Native country is Russia, list all students with a CITIZENSHIP_STATUS field = 1 (Native) and the COUNTRY field = RUS. To find all students who are in the USA as “Alien Temporary”, the CITIZENSHIP_STATUS field = 4 (Alien Temporary) and the COUNTRY field = USA.
SADM |
|---|
Synonyms/References | |
|---|
|
Additional technical details can be found in the following expandable region, including the tables and foundation/lookups for this element in Student Admin and SADM.
| Page Properties |
|---|
|
Student Admin Table | CITIZENSHIP |
|---|
Column | COUNTRY, CITIZENSHIP_STATUS |
|---|
|
| Page Properties |
|---|
|
Student Admin - Foundation/Lookup Table | CITIZEN_STS_TBL (Status Description); COUNTRY_TBL (Country Description) |
|---|
Column | COUNTRY.DESCR, CITIZENSHIP_STATUS.DESCR |
|---|
|
| Page Properties |
|---|
|
SADM Table | CC_PERSONAL_DIM |
|---|
Column | PERS_CITIZENSHIP_STATUS, PERS_CITIZENSHIP_STATUS_LDESC |
|---|
|
| Expand |
|---|
| title | Additional Technical Details |
|---|
|
Physical Table(s) |
|---|
Student Admin: | CITIZENSHIP |
|---|
Foundation/Lookup: | CITIZEN_STS_TBL (Status Description); COUNTRY_TBL (Country Description) |
|---|
SADM: | |
|---|
Physical Column |
|---|
Student Admin: | COUNTRY, CITIZENSHIP_STATUS |
|---|
Foundation/Lookup: | COUNTRY.DESCR, CITIZENSHIP_STATUS.DESCR |
|---|
SADM: | |
|---|
|
...