Determines a student’s citizenship status in a country. This data is collected at admissions and students can 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#StatusDesc
Country
CountryDescription
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
bgColor
#ABF5D1
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
Notes
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. The corresponding CITIZENSHIP.CITIZENSHIP_STATUS field saves their status.
To find all students whose Native country is Russia, list all students with a CITIZENSHIP_STATUS field = 1 (Native) and a the COUNTRY field = RUS(Code for Russia). Lenora Barnes check if this an appropriate/suggested search topic for this page?.
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
The USA citizenship of the student is stored in the PERS_CITIZENSHIP_STATUS_LDESC. SADM doesn’t contain citizenship status for other countries.