AV_PEOPL_REL_VW

(SQL View)
Index Back

People Relationship Data View

People Relationship Data View

SELECT A.EMPLID , A.RELATIONSHIP_NBR , A.PEOPLE_RELATION , A.EMPLID_RELATED , B.XLATLONGNAME FROM PS_RELATIONSHIPS A , PSXLATITEM B WHERE B.FIELDNAME='PEOPLE_RELATION' AND A.PEOPLE_RELATION=B.FIELDVALUE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: AV_PEOPLE_SRCH

2 RELATIONSHIP_NBR Number(2,0) SMALLINT NOT NULL Relationship Nbr
3 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship
4 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID
5 AV_RELATIONSHIPS Character(30) VARCHAR2(30) NOT NULL Relationship