Versions Compared

Version Old Version 10 New Version 11
Changes made by

Sylvia King

Lenora Barnes

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties
idelement

CITIZENSHIP_STATUS and COUNTRY

Example:

CITIZENSHIP.CITIZENSHIP_STATUS [Code]

CITIZENSHIP.COUNTRY [Code]

CITIZEN_STS_TBL.DESCR [Description]

COUNTRY_TBL.DESCR [Description]

System Field Name

Definition/Usage

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.

Values

Example:Student 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

Notes

Student Administration

  • To find a student’s citizenship status in the USA, use the student’s emplid to find USA 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).

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

Synonyms/References

  • COUNTRY_TBL for full Country names/descriptions.

  • CITIZEN_STS_TBL for full status descriptions.

...