EMPLIDPrompt Table: PEOPLE_SRCH
RELATIONSHIP_NBRLG=Legal Guardian
NA=Not Applicable
OT=Other
PG=Parent Guardian
SG=Self Guardian
XG=Primary Guardian
REL_CONTACT_VW(SQL View) |
Index Back |
|---|---|
Relationship contact viewREL_CONTACT_VW view is used to prompt all the persons that have a relationship with the specific person., |
| select emplid ,relationship_nbr ,people_relation ,Name ,guardian_relations ,contact_thru from PS_RELATIONSHIPS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | RELATIONSHIP_NBR |
Number(2,0) | SMALLINT NOT NULL | Relationship Nbr |
| 3 | PEOPLE_RELATION | Character(2) | VARCHAR2(2) NOT NULL | Relationship |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 5 | GUARDIAN_RELATIONS | Character(2) | VARCHAR2(2) NOT NULL |
Guardian Relationship
LG=Legal Guardian NA=Not Applicable OT=Other PG=Parent Guardian SG=Self Guardian XG=Primary Guardian |
| 6 | CONTACT_THRU | Number(2,0) | SMALLINT NOT NULL | Contact Thru |