Gender and pronoun record in HR.
This HR_GENDER_DAT record keeps track of changes, and the PERSON_GENDER contains a single row of updated info.
| Key | Record.Fieldname | Format | XLAT | Heading Text | Notes |
|---|---|---|---|---|---|
| → | EMPLID - Empl ID | Char11 | ID | ||
| → | ACTION_DT_SS - Termination Date | Date | Term Date | ||
| → | EFFSEQ - Effective Sequence | Num3.0 | Sequence | ||
| 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
| ||
| WF_STATUS - Workflow Status | Char1 | N | WF Status |
| |
| ORIGINATORID - Originator OperID | Char30 | OperID | |||
| TRANSACTION_NAME - Transaction Name | Char25 | Tran Name | |||
| UPD_BY_USERID - Last User ID to Update | Char30 | Updated By | |||
| UPD_DTTM - Last Update Date/Time Stamp | DateTm | Last Update Dat | |||
| MANUAL_UPD_USERID - Manual Update User ID | Char30 | Man Upd User ID | |||
| MANUAL_UPD_DTTM - Manual Update Date/Time Stamp | DateTm | Man Upd DTTM | |||
| SS_STAT_INDICATOR - Self Service Status Indicator | Char1 | N | SS Status Ind |
| |
| SS_WARNING_FLG - Self Service Warning Flag | Char1 | SS Warning Flg | |||
| SS_FUTURE_FLG - Self Service Future Flag | Char1 | SS Future Flg | |||
| APPROVAL_REQUIRED - Approval Process? | Char1 | N | Approval Proc |
|
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-34-54.png (image/png)
image-2023-7-19_12-32-34.png (image/png)
image-2023-7-19_12-31-42.png (image/png)
image-2023-7-19_12-29-14.png (image/png)
image-2023-7-19_12-41-46.png (image/png)
image-2023-7-19_12-42-23.png (image/png)
image-2023-7-19_12-42-58.png (image/png)