[enter system field name, if applicable; skip for concepts]
Panel
bgColor
#ABF5D1
Example:
ETHNIC_GRP_CD/ETHNC_ETHNICITY_CODE [Code]
ETHNIC_GRP_TBL.DESCR50 [Description]
ETHNIC_GRP_TBL.ETHNIC_GROUP [Group]
Definition/Usage
[describe element]
Values
[list all values and descriptions separated by hyphen, include headings at top (e.g., [Code] - [Description])] OR [list a few examples and descriptions] A full list of all values available for [insert element] can be found [insert table or location].
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]
Example
[provide an example of the element]
Notes
[list any relevant notes regarding the element that have not already been mentioned in the sections above]
Synonyms/References
[provide any synonyms or useful references]
Derived using CITIZENSHIP_STATUS and COUNTRY
Definition/Usage
Determines a student’s citizenship status in a country. This data is collected at admissions and students may have multiple rows. Use a combination of the status field and country field to find a student’s status of citizenship.
Values
Example:
Student abc123 has two rows. Their native country is India but also have a citizenship status of “Alien Temporary” in the United Status.
Student#StatusDescCountryDescription
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
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.
To find all students whose Native country is Russia, list all students with a CITIZENSHIP_STATUS field = 1 (Native) and the COUNTRY field = RUS.
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.
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.