PEOPLE_RELATIONPrompt Table: RELATION_HD_TBL
PEOPLE_RELATE_RCPPrompt Table: XL_RELATION_VW
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
Default Value: U
RELATIN_RCP_TBL(SQL Table) |
Index Back |
|---|---|
Reciprocal Relation TableSetup table for storing Reciprocal Relationships. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PEOPLE_RELATION |
Character(2) | VARCHAR2(2) NOT NULL |
Relationship
Prompt Table: RELATION_HD_TBL |
| 2 | PEOPLE_RELATE_RCP |
Character(2) | VARCHAR2(2) NOT NULL |
Reciprocal Relation
Prompt Table: XL_RELATION_VW |
| 3 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec Default Value: U |