SCC_CM_NAMES

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_UID	Character(100)	VARCHAR2(100) NOT NULL	Universal Hub ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Prompt Table: NAME_TYPE_TBL
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
6	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
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
9	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix Prompt Table: NAME_PREFIX_TBL
10	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix Prompt Table: NAME_SUFFIX_TBL
11	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix Prompt Table: NM_ROYPREF_GBL
12	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Suffix Prompt Table: NM_ROYSUFF_GBL
13	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title Prompt Table: TITLE_TBL
14	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
15	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
16	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
17	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
18	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
19	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
20	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Name
21	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
22	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
23	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.
24	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: NM_ROYPREF_GBL
25	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
26	NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Display Name - name formatted for Display based on the Country
27	NAME_FORMAL	Character(60)	VARCHAR2(60) NOT NULL	Formal Name - name formatted for Formal Display by COuntry. Normally used in Correspondence.
28	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.
29	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
30	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.