RC_RPRT_BY_VW

(SQL View)
 Index Back

BO ID and Person ID View

View to Fetch BO_ID_CONTACT and PERSON_ID

SELECT A.BO_ID , A.PERSON_ID , A.BO_NAME_DISPLAY , A.BO_NAME_DISP_UPPER , A.EMPLID , A.NAME , A.NAME_AC , A.TITLE , A.FIRST_NAME , A.FIRST_NAME_SRCH , A.LAST_NAME , A.LAST_NAME_SRCH , A.MIDDLE_NAME , A.SEX , A.CONTACT_FLAG FROM PS_RB_PRSN_P_NM_VW A , PS_BO B WHERE A.BO_ID = B.BO_ID AND B.MERGE_STATUS <> 'I'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_REPORTED_BY Number(31,0) DECIMAL(31) NOT NULL Reported By Field. This is used in Case Record to store BO_ID of Reported By Person.
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
4 BO_NAME_DISP_UPPER Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object in Upper
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
8 TITLE Character(35) VARCHAR2(35) NOT NULL Title
9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
10 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
13 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
14 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown
15 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