RF_WORKER_VW

(SQL View)
 Index Back

Worker View

This view returns ALL persons defined as workers.

SELECT A.PERSON_ID , B.BO_NAME_DISPLAY , B.NAME_AC , B.LAST_NAME , B.FIRST_NAME , A.DEPTID , A.LOCATION , A.JOBCODE FROM PS_RB_WORKER A , PS_RB_PRSN_P_NM_VW B WHERE A.PERSON_ID = B.PERSON_ID AND (A.EMPL_STATUS = 'A' OR A.HR_STATUS = 'A')

# 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 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
3 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
7 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
8 JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code or Job Title.