NAMES

(SQL Table)
 Index Back

Person Names

Use NAMES to store all Names that a person has. This is the only record that Names will be stored in.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
DEG=Degree
FR1=Former 1
FR2=Former 2
FR3=Former 3
FR4=Former 4
FR5=Former 5
FR6=Former 6
FTR=Father
MDN=Maiden
MTR=Mother
OTH=Other
PRF=Preferred
PRI=Primary
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Format for Country

Prompt Table: COUNTRY_TBL

5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
7 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.

Prompt Table: NAME_PREFIX_TBL

8 NAME_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Suffix

Prompt Table: NAME_SUFFIX_TBL

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 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
20 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name