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 2 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 student’s citizenship status in a country. This data is collected at admissions.

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.

Synonyms/References

  • [provide any synonyms or useful references]

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.

 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