Content Comparison

Derived using CITIZENSHIP_STATUS and COUNTRY

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.

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 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

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

• The USA citizenship of the student is stored in the PERS_CITIZENSHIP_STATUS_LDESC. SADM doesn’t contain citizenship status for other countries.

• COUNTRY_TBL for full Country names/descriptions.

• CITIZEN_STS_TBL for full status descriptions.