RB_COMP_P_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.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 , B.NAME_AC , A.COMM_METHOD , A.SETID FROM PS_RD_PERSON A , PS_RD_PERSON_NAME B WHERE A.PERSON_ID = B.PERSON_ID AND B.PRIMARY_IND = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PERSON_ID_CONT 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 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
8 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
9 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
10 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
11 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
12 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
13 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
14 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
15 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
16 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
17 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
18 SEX Character(1) VARCHAR2(1) NOT NULL Gender of the person.
F=Female
M=Male
U=Unknown
19 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
20 TITLE Character(35) VARCHAR2(35) NOT NULL Title
21 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
22 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
23 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.