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 8 Next »

System Field Name

SEX

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?)

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

Example

Notes

  • X and U are yet to be defined

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

Student Admin

Table

PERSONAL_DATA

Column

SEX

Student Admin - Foundation/Lookup

Table

PSXLATITEM

Column

PSXLATITEM where FIELDNAME = ‘SEX’

SADM

Table

CC_PERSONAL_DIM

Column

PERS_GENDER, PERS_GENDER_LDESC

 Additional 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

  • No labels