SCC_SM_NAME_I

(SQL View)
Index Back

Name fields used for Ext S/M

Name fields used to define the External Search/Match response message

SELECT 'P' ,' ' , A.EMPLID ,A.NAME_TYPE ,A.EFFDT ,A.EFF_STATUS ,%subrec(NAMEGBL_NPC_SBR,A) , ' ' FROM PS_HCR_PER_NAME_I A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SM_TYPE Character(1) VARCHAR2(1) NOT NULL Search Match Type: This field identifies the domain of core data to be searched.
A=Applicant
O=Organization
P=Person
2 SCC_UID Character(100) VARCHAR2(100) NOT NULL Universal Hub ID
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: NEW

4 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name

Prompt Table: NAME_TYPE_TBL

5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

7 COUNTRY_NM_FORMAT Character(3) VARCHAR2(3) NOT NULL Supported Name Format Types

Default Value: OPR_DEF_TBL_HR.COUNTRY_NM_FORMAT

Prompt Table: NAME_FORMAT_TBL

8 NAME Character(50) VARCHAR2(50) NOT NULL Name
9 NAME_INITIALS Character(6) VARCHAR2(6) NOT NULL Name Initials
10 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

Prompt Table: HCR_NM_PREFIX_I

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

Prompt Table: HCR_NM_SUFFIX_I

12 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix

Prompt Table: SCC_NMRYLPRF_VW

13 NAME_ROYAL_SUFFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Suffix

Prompt Table: NM_ROYSUFF_GBL

14 NAME_TITLE Character(30) VARCHAR2(30) NOT NULL Title

Prompt Table: TITLE_TBL

15 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
16 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
17 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
18 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
19 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
20 SECOND_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Second Last Name
21 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name
22 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
23 PREF_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL Preferred First Name
24 PARTNER_LAST_NAME Character(30) VARCHAR2(30) NOT NULL The Partner Last Name is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name as their prefered last name.
25 PARTNER_ROY_PREFIX Character(15) VARCHAR2(15) NOT NULL The Partner Royal Prefix is being used by the Netherlands for the employee name formatting, where a person can choose to use the partners last name and prefix as their prefered last name.

Prompt Table: SCC_NMRYLPRF_VW

26 LAST_NAME_PREF_NLD Character(1) VARCHAR2(1) NOT NULL The field Last Name Preference is used in the Netherlands specific for people who are married to indicated their preference regarding the last name, which can be 4 choices based on the own last name and the partners last name.
1=Own Name
2=Name Partner
3=Name Partner + Own Name
4=Own Name + Name Partner

Default Value: 1

27 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
28 NAME_FORMAL Character(60) VARCHAR2(60) NOT NULL Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
29 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.