GVT_PERS_DTA_VW

(SQL View)
 Index Back

Rel Disp View of EE Per Data

Simple view of personal data to allow related display of personal data information for multiple emplid on the same or different panel buffer scroll areas.

SELECT DISTINCT A.EMPLID ,B.NAME FROM PS_PER_ORG_ASGN A , PS_PERSON_NAME B WHERE A.PER_ORG = 'EMP' AND A.EMPLID = B.EMPLID

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