RB_PRSN_NM_VW

(SQL View)
 Index Back

Person

The Fields SETID and CONTACT_ID have been added to maintain the cross reference with PS FDM.

SELECT A.PERSON_ID , A.BO_ID , B.FIRST_NAME , B.LAST_NAME , B.MIDDLE_NAME , B.NAME , B.BO_NAME , B.BO_NAME_DISPLAY , B.NAME_AC , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.PREF_FIRST_NAME , B.NAME_INITIALS , B.NAME_PREFIX , B.NAME_SUFFIX , B.NAME_ROYAL_PREFIX , B.NAME_ROYAL_SUFFIX , B.NAME_TITLE , B.SECOND_LAST_NAME , A.EMPLID , A.SEX , A.CONTACT_FLAG , A.TITLE , A.COMM_METHOD , A.SETID FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

Default Value: NEXT

2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object
8 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
9 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
10 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
11 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
12 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
13 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
14 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
15 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
16 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
17 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
18 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
19 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
20 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
21 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown
22 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
23 TITLE Character(35) VARCHAR2(35) NOT NULL Title
24 COMM_METHOD Character(1) VARCHAR2(1) NOT NULL The person's preferred method of communication.
C=Call
E=Email Only
F=Fax
I=XML only
M=Standard Mail
P=Email & Print
R=XML & Print
S=SMS
25 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.