PEOPLE_RELATIONF=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
Default Value: U
Default Value: N
RELATION_HD_SVW(SQL View) |
Index Back |
|---|---|
Relationship Table viewView is based on RELATION_HD_TBL, to have translate long name in the search result |
| SELECT people_relation , xlatlongname , sex , relationship_limit FROM ps_relation_hd_tbl , PSXLATITEM WHERE PSXLATITEM.fieldname = 'PEOPLE_RELATION' AND PSXLATITEM.fieldvalue= ps_relation_hd_tbl.people_relation |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PEOPLE_RELATION |
Character(2) | VARCHAR2(2) NOT NULL | Relationship |
| 2 | AV_RELATIONSHIPS | Character(30) | VARCHAR2(30) NOT NULL | Relationship |
| 3 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec Default Value: U |
| 4 | RELATIONSHIP_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
Limit Relationship
Default Value: N |