Content Comparison

CITIZENSHIP_STATUS and COUNTRY

Example:

CITIZENSHIP.CITIZENSHIP_STATUS [Code]

CITIZENSHIP.COUNTRY [Code]

CITIZEN_STS_TBL.DESCR [Description]

COUNTRY_TBL.DESCR [Description]

Determines a student’s citizenship status in a country. This data is collected at admissions and students can have multiple rows. Use a combination of the status field and country field.

Example:

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

Student Administration

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

• To find all students whose Native country is Russia, list all students with a CITIZENSHIP_STATUS field = 1 (Native) and a COUNTRY field = RUS (Code for Russia).

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.

CC_CITIZENSHIPPERSONAL_DIM

CITIZ_COUNTRYPERS_CITIZENSHIP_STATUS, PERS_CITIZENSHIP_STATUS_LDESC