Versions Compared

Version Old Version 3 New Version Current
Changes made by

Lenora Barnes

Lenora Barnes

Saved on

Key

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

Example:

ETHNIC_GRP_CD/ETHNC_ETHNICITY_CODE [Code]

ETHNIC_GRP_TBL.DESCR50 [Description]

ETHNIC_GRP_TBL.ETHNIC_GROUP [Group]

:

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

    System Report Field Name

    SEX

    Panel
    bgColor#ABF5D1

    Definition/Usage

    The student gender collected at time of admission.

    Values

    F - Female

    M - Male

    (new) X - to be determined(new) U - to be determined (unspecified?)Intersex

    U - Unknown

    A full list of all values available for “Sex” can be found in the PSXLATITEM table.

    Panel
    bgColor#ABF5D1

    Example

    Example

    Notes

    • X and U are yet to be definedX and U starting to populate with Fall 2023 ECE students

    Synonyms/References

    • Gender

    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.

    Page Properties
    idstudent_admin

    Student Admin

    Table

    PERSONAL_DATA

    Column

    SEX

    Page Properties
    idfoundation_lookup

    Student Admin - Foundation/Lookup

    Table

    PSXLATITEM

    Column

    PSXLATITEM where FIELDNAME = ‘SEX’

    Page Properties
    idSADM

    SADM

    Table

    CC_PERSONAL_DIM

    Column

    PERS_GENDER, PERS_GENDER_LDESC

    Expand
    titleAdditional Technical Details

    Physical Table(s)

    Student Admin:

    PERSONAL_DATA

    Foundation/Lookup:

    PSXLATITEM

    SADM:

    CC_PERSONAL_DIM

    Physical Column

    Student Admin:

    SEX

    Foundation/Lookup:

    PSXLATITEM where FIELDNAME = ‘SEX’

    SADM:

    PERS_GENDER, PERS_GENDER_LDESC

    ...