RC_NOTE_CONT_VW

(SQL View)
 Index Back

Used in Notes for Contact

Used in Notes for Contact to display the department and job.

SELECT A.PERSON_ID , B.NAME , C.JOBCODE , C.DEPTID FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B ,PS_RB_WORKER C WHERE A.PERSON_ID = B.PERSON_ID AND A.PERSON_ID =C.PERSON_ID AND 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 JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code or Job Title.
4 DEPTID Character(15) VARCHAR2(15) NOT NULL Department