RS_EMPLID_UP_VW

(SQL View)
Index Back

SELECT A.EMPLID , B.FIRST_NAME , B.LAST_NAME FROM %Table(RS_EMPLID_TBL) A , %Table(PERS_DATA_EFFDT) B WHERE A.HR = 'Y' AND A.EMPLID=B.EMPLID

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

Prompt Table: RS_MAP_EE_SRCH

2 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name