RC_WORKER_VW

(SQL View)
 Index Back

Worker View

This view returns worker name, dept Id, location and job code.

SELECT A.PERSON_ID , B.NAME , A.DEPTID , A.LOCATION , A.JOBCODE FROM %Table(RB_WORKER) A , %Table(RD_PERSON_NAME) B , %Table(RD_PERSON) C WHERE A.PERSON_ID = B.PERSON_ID AND A.PERSON_ID = C.PERSON_ID AND C.EMPLID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Prompt Table: RB_WORKER

2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
4 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
5 JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code or Job Title.