HRS_PERSON_IDHRS_APP_PRN_VW(SQL View) |
Index Back |
|---|---|
Gender Pronoun DetailsGender Pronoun Details |
| SELECT APP.HRS_PERSON_ID , APP.REG_REGION , APP.PRONOUN , PRN.HRS_DESCR FROM PS_HRS_APPLICANT APP , PS_HRS_GEND_PRN_VW PRN WHERE (APP.REG_REGION = PRN.REG_REGION AND APP.PRONOUN = PRN.PRONOUN) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL | Regulatory Region |
| 3 | PRONOUN | Character(2) | VARCHAR2(2) NOT NULL | Gender Pronoun |
| 4 | HRS_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |