RC_SOLN_MEM_VW

(SQL View)
 Index Back

View of active workers

prompt table of all active workers whose primary ind is set to Y

SELECT DISTINCT A.PERSON_ID , A.BO_ID , B.FIRST_NAME , B.LAST_NAME , B.BO_NAME_DISPLAY , A.EMPLID , C.EMAIL_ADDR , D.PHONE , E.DEPTID , E.LOCATION , A.TITLE FROM PS_RD_PERSON A , PS_BO_NAME B LEFT OUTER JOIN PS_BO_PWRK_EMAL_VW C ON (B.BO_ID = C.BO_ID) LEFT OUTER JOIN PS_BO_ROLECM_PPHON D ON (B.BO_ID = D.BO_ID) LEFT OUTER JOIN PS_RB_WORKER E ON (B.BO_ID = E.BO_ID AND E.EMPL_STATUS = 'A') WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 EMAIL_ADDR Character(70) VARCHAR2(70) NOT NULL Email address to store the address of email.
8 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
9 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
10 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
11 TITLE Character(35) VARCHAR2(35) NOT NULL Title