RDFCONTACT_SRCH

(SQL View)
 Index Back

Contact Search

This is the Contact Search Record for FSI.

SELECT A.PERSON_ID , B.NAME , B.LAST_NAME_SRCH , B.FIRST_NAME_SRCH , B.PREF_FIRST_NAME , B.FIRST_NAME , B.LAST_NAME , A.TITLE , A.EMPLID , A.SETID , A.BO_ID FROM PS_RD_PERSON A , PS_BO_NAME B WHERE A.BO_ID = B.BO_ID AND A.MARKET = 'FIN'

# 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 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
5 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name
6 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
7 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
8 TITLE Character(35) VARCHAR2(35) NOT NULL Title
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
11 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID