RC_NOTE_HD_VW1

(SQL View)
 Index Back

Note Contact

Note Contact Person for Help Desk

SELECT A.PERSON_ID ,B.NAME ,B.NAME ,B.NAME_AC ,B.LAST_NAME ,B.FIRST_NAME FROM PS_RB_WORKER A ,PS_RD_PERSON_NAME B WHERE A.PERSON_ID = B.PERSON_ID AND A.EMPL_STATUS ='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
4 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name