PERSON_IDF=Female
M=Male
U=Unknown
RD_PER_GENDER(SQL View) |
Index Back |
|---|---|
Person-GenderPerson-Gender used in SES query for person search |
| SELECT A.PERSON_ID ,A.SEX , B.XLATLONGNAME FROM (PS_RD_PERSON A LEFT OUTER JOIN PSXLATITEM B ON B.FIELDVALUE= A.SEX AND B.FIELDNAME='SEX' ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PERSON_ID |
Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 2 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender of the person.
F=Female M=Male U=Unknown |
| 3 | GENDER30 | Character(30) | VARCHAR2(30) NOT NULL | CDH INTERFACE TABLE FIELD - GENDER 30 CHAR |