GPAU_RSLT_NM_VW

(SQL View)
 Index Back

GPAU - Employee Names Prompt

GP AUS - Record to prompt for Employee Names

SELECT A.NAME , B.EMPLID FROM PS_PERSON_NAME A , PS_JOB B WHERE A.EMPLID = B.EMPLID AND A.COUNTRY_NM_FORMAT='AUS'

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