HR_GENDER_DAT - Gender Identity Staging Record

This HR_GENDER_DAT record keeps track of changes, and the PERSON_GENDER contains a single row of updated info. 

Detailed Information

Databases

PeopleSoft Human Resources

Key Record.Fieldname Format XLAT Heading Text Notes
Key EMPLID - Empl ID Char11   ID  
Key ACTION_DT_SS - Termination Date Date   Term Date  
Key EFFSEQ - Effective Sequence Num3.0   Sequence  
  REG_REGION - Regulatory Region Char5   Reg Region  
  SEX - Gender Char1 N Sex

FIELD VALUE  DESCR
        F           Female
       M          Male
       U          Undisclosed
  BIRTH_SEX - Birth Sex Char2   Birth Sex NOT in Use
  PRONOUN - Pronoun Char2   Pronoun 
SCC_PRONOUNS - Preferred Pronouns
FIELD 
VALUE DESCR
 AP      Any pronouns are acceptable
 HE      He/Him/His
 HT      He/They
 NM      Use my name only
 NT      Not in List
 PA      Please Ask
 PN      Prefer not to say
 SH      She/Her/Hers
 ST      She/They
 TH      They/Them/Theirs
 US      Unspecified
 XE      Xe/Xem/Xir
 ZE      Ze/Hir/Hirs
 ZR      Ze/Zir/Zirs
  SEXUAL_ORIENTATION - Sexual Orientation Char2   Orientation  
  GENDER_IDENTITY - Gender Identity Char2   Gender Identity

The entire list is available on GENDER_IDNT_DTL table.

*SCC_GENDER_ID - Gender Ident
FIELD 
VALUE DESCR
 AG      Agender
 DG      Demigender
 GF      Genderfluid
 GQ      Genderqueer
 MA      Man
 NB      Nonbinary
 NT      Not in list
 PN      Prefer not to say
 TG      Transgender
 TM      Trans Man
 TN      Trans Woman
 TS   Two-spirit
 US      Unspecified
 WO      Woman
  WF_STATUS - Workflow Status Char1 N WF Status 
FIELD
VALUE  DESCR
  A    Approved
  C    Cancelled
  D    Denied
  E    Error. Contact Administrator.
  F    Awaiting final approval
  I    In Approval Process
  M    Administrator is Processing
  N    Not Available
  P    Rework
  S    Submitted
  V    Data Saved
  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 
FIELD 
VALUE DESCR
  A   Approved
  B   CI failed - Errors & Warnings
  C   Cancelled
  D   Denied
  E   Errors Encountered
  I   In Approval Process
  M   Administrator Action Required
  S   Success
  W   Warnings Encountered
  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

 Yes/No

 

Submit an Inquiry or Request to DARTS Print Article

Details

Article ID: 158722
Created
Fri 5/10/24 4:24 AM
Modified
Wed 9/11/24 1:20 PM
Applies To
Faculty
Staff
Community

Related Articles (4)

Gender Identity and Pronoun Selection in MaineStreet (Employees and Students)
University of Maine System (UMS) students and employees may select gender identity and pronouns in MaineStreet's Student Information and HR Systems. This article outlines how to make those selections and what options are available to choose from.
Gender Identity and Pronouns Frequently Asked Questions (FAQ)
This article provides detailed answers to frequently asked questions regarding Gender Identity and Pronoun use including how UMS provides support and how to update your records.

Related Services / Offerings (1)

DARTS (UMS Data) Inquiry
Submit an inquiry about UMS Data (except Data Governance)