RBF_SRTY_PER_VW

(SQL View)
 Index Back

Person View

A view to RD_PERSON. Used in RBF_SRTY_MATRIX as prompt table for the field of BUS_CONTACT_ID

SELECT A.BO_ID , A.PERSON_ID , A.SETID , B.FIRST_NAME , B.LAST_NAME , B.MIDDLE_NAME ,B.NAME , B.BO_NAME_DISPLAY , A.MARKET FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUS_CONTACT_ID Number(31,0) DECIMAL(31) NOT NULL Business Contact Id
2 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID
3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Prompt Table: SP_SETID_NONVW

4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
7 BUS_NAME Character(50) VARCHAR2(50) NOT NULL Business Contact Name
8 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
9 MARKET Character(3) VARCHAR2(3) NOT NULL Market