RC_CSSUM_CNT_VW

(SQL View)
Index Back

person view

This record is to store primary person view.

SELECT A.PERSON_ID ,B.NAME ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH ,B.PREF_FIRST_NAME ,A.TITLE ,A.EMPLID , A.SETID , A.BO_ID 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 CASE_CONTACT Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts
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 TITLE Character(35) VARCHAR2(35) NOT NULL Title
7 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
8 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
9 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID