RELATIONSHIP_VW

(SQL View)
Index Back

Relationship Data View

Use RELATIONSHIP_VW for prompting on RELATIONSHIP_NBR from table RELATIONSHIPS. The initial use of this view is from within the address and address change panels.

Select Emplid, Relationship_Nbr, People_Relation, Guardian_Relations, Name, Address1 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 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
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1