Versions Compared

Version Old Version 2 New Version 3
Changes made by

Lenora Barnes

Lenora Barnes

Saved on

Key

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

System Field Name

CITIZENSHIP_STATUS and COUNTRY

Example:

CITIZENSHIP.CITIZENSHIP_STATUS [Code]

CITIZENSHIP.COUNTRY [Code]

CITIZEN_STS_TBL.DESCR [Description]

COUNTRY_TBL.DESCR [Description]

Panel
bgColor#ABF5D1

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 can have multiple rows. Use a combination of the status field and country field.

Values

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

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 in the CITIZENSHIP.COUNTRY field. The corresponding CITIZENSHIP.CITIZENSHIP_STATUS field saves their status.

Synonyms/References

  • [provide any synonyms or useful references]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). Lenora Barnes check if this an appropriate/suggested search topic for this page?

Synonyms/References

  • COUNTRY_TBL for full Country names/descriptions.

  • CITIZEN_STS_TBL for full status descriptions.

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.

...