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')

# 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