GEND_EXPR_SRCH(SQL View) |
Index Back |
---|---|
Gender Details SearchGender Expression Search Record |
SELECT A.REG_REGION , A.DESCR50 FROM PS_REG_REGION_TBL A , PS_GENDER_EXPR_HDR B WHERE A.REG_REGION = B.REG_REGION |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | REG_REGION | Character(5) | VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table: REG_REGION_TBL |
2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |