Versions Compared

Version Old Version 1 New Version 2
Changes made by

Lenora Barnes

Lenora Barnes

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties
idelement
[list any relevant notes regarding the element that have not already been mentioned in the sections above]

System Field Name

[enter system field name, if applicable; skip for conceptsCITIZENSHIP_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

[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].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

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

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]

...

Expand
titleAdditional 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:

Page Properties
hiddentrue
idreview_tracking

Status

Status
colourYellow
titleIn progress

Signed off by

[enter reviewer]

Date Reviewed

Unfinished Items/Notes

[enter any notes about unfinished items]