AV_P_RELATIO_VW

(SQL View)
Index Back

People Relation

Relate Display view providing the first relationship between two individuals.

SELECT A.EMPLID, A.EMPLID_RELATED, A.PEOPLE_RELATION FROM PS_RELATIONSHIPS A WHERE RELATIONSHIP_NBR IN ( SELECT MIN(A1.RELATIONSHIP_NBR ) FROM PS_RELATIONSHIPS A1 WHERE A1.EMPLID=A.EMPLID AND A1.EMPLID_RELATED= A.EMPLID_RELATED)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 AV_EMPLID Character(11) VARCHAR2(11) NOT NULL EmplID
2 EMPLID_RELATED Character(11) VARCHAR2(11) NOT NULL Related People ID
3 PEOPLE_RELATION Character(2) VARCHAR2(2) NOT NULL Relationship