PERS_DTA_EMP_VW

(SQL View)
 Index Back

EE Personal Data View

PERS_DTA_EMP_VW is used to prompt for Employees only (i.e excluding all types of Non-Employee and is used in Recruit Workforce and the Dept_Tbl

SELECT B.EMPLID , B.NAME FROM PS_PERSON_NAME B WHERE B.EMPLID IN ( SELECT EMPLID FROM PS_PER_ORG_INST WHERE PER_ORG = 'EMP')

  • Related Language Record: PERSON_NAME_LNG

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

    Default Value: NEW

    2 NAME Character(50) VARCHAR2(50) NOT NULL Name