RG_BO_WORKER_VW

(SQL View)
 Index Back

BO ID and Worker View

View to Fetch BO_ID_CONTACT and Wroker

SELECT A.BO_ID , A.PERSON_ID , A.EMPLID , A.NAME , A.TITLE , A.FIRST_NAME , A.LAST_NAME , A.MIDDLE_NAME , A.SEX , A.CONTACT_FLAG , B.SETID_DEPT , B.DEPTID , B.SETID_LOCATION , B.LOCATION , B.JOBCODE FROM PS_RB_PRSN_P_NM_VW A , PS_RB_WORKER B WHERE A.PERSON_ID = B.PERSON_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 TITLE Character(35) VARCHAR2(35) NOT NULL Title
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
8 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
9 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown
10 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role.
E=External Contact
I=Internal Corporate Contact
11 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
12 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
13 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
14 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
15 JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code or Job Title.