HR_GENDER_DAT - Gender Identity Staging Record

Body

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