RA_SAEMPL_LVW

(SQL View)
Index Back

Employee view

Employee View - search prompt related language record

SELECT A.EMPLID , B.FIRST_NAME , B.LAST_NAME FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND A.EMPLID<>' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name