Gender and pronouns record in Campus Solutions
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| → | EMPLID - Empl ID | Char11 | ID | ||
| → | EFFDT - Effective Date | Date | Eff Date | ||
| SCC_BIRTH_GENDER - Birth Gender | Char1 | N | Birth Gender |
| |
| SCC_GENDER_ID - Gender Identity | Char2 | N | Gender Identity | The current list of values can be found on PSXLATITEM table. select * from SYSADM.psxlatitem where fieldname='SCC_GENDER_ID';
| |
| SCC_GENDER_ID_OTH - Other Gender Identity | Char120 | Other Identity | |||
| SCC_SEXUAL_ORT - Sexual Orientation | Char2 | N | Sexual Orientn |
| |
| SCC_SEXUAL_ORT_OTH - Other Sexual Orientation | Char120 | Other Orientn | |||
| SCC_PRONOUNS - Preferred Pronouns | Char2 | N | Pronouns | The current list of values can be found on PSXLATITEM table. select * from SYSADM.psxlatitem where fieldname=''SCC_PRONOUNS';
| |
| SCC_PRONOUNS_OTH - Other Preferred Pronouns | Char120 | Other Pronouns | |||
| SCC_BIO_ATTRB_1 - Biographical Attribute 1 | Char2 | N | Attribute 1 |
| |
| SCC_BIO_ATTRB_2 - Biographical Attribute 2 | Char2 | N | Attribute 2 | ||
| SCC_BIO_ATTRB_3 - Biographical Attribute 3 | Char2 | N | Attribute 3 | ||
| SCC_BIO_ATTRB_4 - Biographical Attribute 4 | Char2 | N | Attribute 4 | ||
| SCC_BIO_ATTRB_5 - Biographical Attribute 5 | Char2 | N | Attribute 5 | ||
| SCC_BIO_ATTRB_6 - Biographical Attribute 6 | Char2 | N | Attribute 6 | ||
| SCC_BIO_ATTRB_7 - Biographical Attribute 7 | Char2 | N | Attribute 7 | ||
| SCC_BIO_ATTRB_8 - Biographical Attribute 8 | Char2 | N | Attribute 8 | ||
| SCC_BIO_ATTRB_9 - Biographical Attribute 9 | Char2 | N | Attribute 9 | ||
| LASTUPDDTTM - Last Update Date/Time | DateTm | Last Upd DtTm | |||
| LASTUPDOPRID - by | Char30 | by |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.
Related page:
HR side of tables:
Attachments:
image2022-6-1_15-54-36.png (image/png)
image-2023-7-19_12-12-12.png (image/png)
image-2023-7-19_12-12-48.png (image/png)
image-2023-7-19_12-13-17.png (image/png)
image-2023-7-19_12-13-51.png (image/png)
image-2023-7-19_12-14-21.png (image/png)