Gender and pronoun record in HR.
The HR_GENDER_DAT record keeps track of changes, and this PERSON_GENDER contains a single row of updated info.
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| → | EMPLID - Empl ID | Char11 | ID | ||
| REG_REGION - Regulatory Region | Char5 | Reg Region | |||
| SEX - Gender | Char1 | N | Sex |
| |
| BIRTH_SEX - Birth Sex | Char2 | Birth Sex | NOT using | ||
| PRONOUN - Pronoun | Char2 | Pronoun | The entire list is available on GENDER_PRON_DTL table. SELECT * FROM SYSADM.PS_GENDER_PRON_DTL
| ||
| SEXUAL_ORIENTATION - Sexual Orientation | Char2 | Orientation | |||
| GENDER_IDENTITY - Gender Identity | Char2 | Gender Identity | The entire list is available on GENDER_IDNT_DTL table. SELECT * FROM SYSADM.PS_GENDER_IDNT_DTL
| ||
| ASOFDATE - As Of Date | Date | As Of | |||
| SS_STAT_INDICATOR - Self Service Status Indicator | Char1 | N | SS Status Ind |
|
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:
Attachments:
image-2023-7-19_12-29-14.png (image/png)
image-2023-7-19_12-31-42.png (image/png)
image-2023-7-19_12-32-34.png (image/png)
image-2023-7-19_12-34-54.png (image/png)