HR_GEND_APVL_VW(SQL View) |
Index Back |
|---|---|
Gender Change Approval ViewRecord being used with Workflow Name Change event |
| SELECT CUR.EMPLID , NEW.ACTION_DT_SS , NEW.EFFSEQ , %Sql(HR_HT_EMAIL_DATE,NEW.ACTION_DT_SS) , ' ' , NEW.REG_REGION , NEW.SEX , NEW.BIRTH_SEX , NEW.PRONOUN , NEW.SEXUAL_ORIENTATION , NEW.GENDER_IDENTITY , CUR.NAME_DISPLAY , NEW.WF_STATUS , NEW.APPROVAL_REQUIRED FROM PS_HR_GENDER_DAT NEW , PS_PERSON_NAME CUR WHERE NEW.EMPLID=CUR.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ACTION_DT_SS |
Date(10) | DATE | Termination Date |
| 3 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 4 | DESCR15 | Character(15) | VARCHAR2(15) NOT NULL | Short Description |
| 5 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |
| 6 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 7 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 8 | BIRTH_SEX | Character(2) | VARCHAR2(2) NOT NULL | Birth Sex |
| 9 | PRONOUN | Character(2) | VARCHAR2(2) NOT NULL | Gender Pronoun |
| 10 | SEXUAL_ORIENTATION | Character(2) | VARCHAR2(2) NOT NULL | Sexual Orientation |
| 11 | GENDER_IDENTITY | Character(2) | VARCHAR2(2) NOT NULL | Gender Identity |
| 12 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |
| 13 | WF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Workflow Status
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 |
| 14 | APPROVAL_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL |
Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
N=No Approval Required Y=Approval Required Default Value: N |