RB_NEW_PRSN_VW

(SQL View)
 Index Back

SELECT A.PERSON_ID , B.NAME_TYPE , %subrec(NAMEGBL_SBR, B) 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 PERSON_ID_NEW Character(15) VARCHAR2(15) NOT NULL New Person ID
2 NAME_TYPE Character(15) VARCHAR2(15) NOT NULL Business Object Name Type

Prompt Table: BO_PER_NM_TYP_V

3 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL This is the country name format field.

Prompt Table: COUNTRY_TBL

4 NAME Character(50) VARCHAR2(50) NOT NULL Name
5 NAME_AC Character(50) VARCHAR2(50) NOT NULL Name (Alternate Character)
6 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
8 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix
9 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
10 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix
11 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title
12 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
13 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
14 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
15 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
16 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL Middle Name
17 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
18 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
19 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL PREF_FIRST_NAME field is used to identify the employees preferred first name