RC_NOTE_HD_VW

(SQL View)
 Index Back

Note Contact

Note Contact Person for Help Desk

SELECT A.PERSON_ID ,%Substring(B.BO_NAME_DISPLAY, 1, 50) ,%Substring(B.BO_NAME_DISPLAY, 1, 50) ,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