RQ_EMPL_NAME_VW

(SQL View)
 Index Back

defect Employee name view

Employee Name View for Defects

SELECT B.NAME , A.PERSON_ID , B.LAST_NAME_SRCH , A.EMPLID FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B WHERE A.PERSON_ID = B.PERSON_ID (+) AND A.EMPLID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NAME Character(50) VARCHAR2(50) NOT NULL Name
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID