RC_CNTCT_A_HD_V

(SQL View)
Index Back

Employee Name

This view returns names of active employees.

SELECT C.NAME , C.NAME_AC , C.NAME_PREFIX , C.FIRST_NAME , C.MIDDLE_NAME , C.LAST_NAME , C.NAME_SUFFIX , A.BO_ID , A.EMPLID FROM PS_RD_PERSON A , PS_RB_WORKER B , PS_RD_PERSON_NAME C , PS_BO_ROLE D WHERE A.PERSON_ID = B.PERSON_ID AND A.PERSON_ID = C.PERSON_ID AND A.BO_ID = D.BO_ID AND D.ROLE_TYPE_ID = 4 AND D.ROLE_START_DT <= %CurrentDateIn AND D.ROLE_END_DT > %CurrentDateIn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 NAME_SEARCH Character(50) VARCHAR2(50) NOT NULL Name
2 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
3 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
8 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID