RF_BO_WORKER_VW

(SQL View)
 Index Back

BO ID and Worker View for IP

View to Fetch BO_ID_CONTACT and Wroker in Installed Product

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.DEPTID , B.LOCATION , B.JOBCODE FROM PS_RB_PRSN_P_NM_VW A , PS_RB_WORKER B WHERE A.PERSON_ID = B.PERSON_ID AND B.EMPL_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_ASSET_CONT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
2 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
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 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
12 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
13 JOBCODE Character(15) VARCHAR2(15) NOT NULL Job Code or Job Title.