HR_GEND_DTL_VW(SQL View) |
Index Back |
|---|---|
Gender Details |
| SELECT CUR.EMPLID , NEW.ACTION_DT_SS , NEW.EFFSEQ , %Sql(HR_HT_EMAIL_DATE,NEW.ACTION_DT_SS) , ' ' , NEW.REG_REGION , CUR.REG_REGION , NEW.SEX , CUR.SEX , NEW.BIRTH_SEX , CUR.BIRTH_SEX , NEW.PRONOUN , CUR.PRONOUN , NEW.SEXUAL_ORIENTATION , CUR.SEXUAL_ORIENTATION , NEW.GENDER_IDENTITY , CUR.GENDER_IDENTITY , NEW.WF_STATUS , 'X' , NEW.APPROVAL_REQUIRED FROM PS_HR_GENDER_DAT NEW , PS_GENDER_CURR_VW CUR , PS_HR_GENDER_STA STA WHERE NEW.EMPLID=CUR.EMPLID AND NEW.EMPLID=STA.EMPLID AND STA.SEQNO=1 AND STA.EFFSEQ=NEW.EFFSEQ |
| # | 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 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | REG_REGION_NEW | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 7 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 8 | SEX_NEW | Character(1) | VARCHAR2(1) NOT NULL |
Sex
F=Female M=Male U=Unknown |
| 9 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 10 | BIRTH_SEX_NEW | Character(2) | VARCHAR2(2) NOT NULL | Birth Sex |
| 11 | BIRTH_SEX | Character(2) | VARCHAR2(2) NOT NULL | Birth Sex |
| 12 | PRONOUN_NEW | Character(2) | VARCHAR2(2) NOT NULL | Gender Pronoun |
| 13 | PRONOUN | Character(2) | VARCHAR2(2) NOT NULL | Gender Pronoun |
| 14 | SEXUAL_ORNT_NEW | Character(2) | VARCHAR2(2) NOT NULL | Sexual Orientation |
| 15 | SEXUAL_ORIENTATION | Character(2) | VARCHAR2(2) NOT NULL | Sexual Orientation |
| 16 | GENDER_IDNT_NEW | Character(2) | VARCHAR2(2) NOT NULL | Gender Identity |
| 17 | GENDER_IDENTITY | Character(2) | VARCHAR2(2) NOT NULL | Gender Identity |
| 18 | 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 |
| 19 | DESCR_COMMENTS_HIS | Long Character | CLOB | This field is used in a complex query that shows many descr fields. |
| 20 | 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 |