BO_WORKER_VW

(SQL View)
Index Back

BO ID and Worker View

View to Fetch BO_ID_CONTACT and Wroker

SELECT A.BO_ID , %Substring(A.BO_NAME_DISPLAY, 1, 50) , A.EMPLID , A.PERSON_ID , 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.SETID_JOBCODE , 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_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
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 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL SETID_JOBCODE field used in the HCM/ CRM sync Application Messages.
16 JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code or Job Title.