Gender (Draft)

System Field Name	SEX Example: ETHNIC_GRP_CD/ETHNC_ETHNICITY_CODE [Code] ETHNIC_GRP_TBL.DESCR50 [Description] ETHNIC_GRP_TBL.ETHNIC_GROUP [Group]
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: [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
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