Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 6 Next »

System Field Name

CITIZENSHIP_STATUS and COUNTRY

Example:

CITIZENSHIP.CITIZENSHIP_STATUS [Code]

CITIZENSHIP.COUNTRY [Code]

CITIZEN_STS_TBL.DESCR [Description]

COUNTRY_TBL.DESCR [Description]

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

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.

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

Student Admin

Table

CITIZENSHIP

Column

COUNTRY, CITIZENSHIP_STATUS

Student Admin - Foundation/Lookup

Table

CITIZEN_STS_TBL (Status Description); COUNTRY_TBL (Country Description)

Column

COUNTRY.DESCR, CITIZENSHIP_STATUS.DESCR

SADM

Table

Column

 Additional Technical Details

Physical Table(s)

Student Admin:

CITIZENSHIP

Foundation/Lookup:

CITIZEN_STS_TBL (Status Description); COUNTRY_TBL (Country Description)

SADM:

Physical Column

Student Admin:

COUNTRY, CITIZENSHIP_STATUS

Foundation/Lookup:

COUNTRY.DESCR, CITIZENSHIP_STATUS.DESCR

SADM:

  • No labels