HR_NAME_DAT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Type of Name Default Value: PRI Prompt Table: NAME_TYPE_TBL
3	ACTION_DT_SS	Date(10)	DATE	Termination Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Supported Name Format Types Prompt Table: NAME_FORMAT_TBL
6	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name
7	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
8	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	MIDDLE_NAME
9	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
10	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix Prompt Table: NAME_PREFIX_TBL
11	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix Prompt Table: NAME_SUFFIX_TBL
12	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
13	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Name Title Prompt Table: TITLE_TBL
14	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix Prompt Table: NM_ROYPREF_GBL
15	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name - Royal Suffix Prompt Table: NM_ROYSUFF_GBL
16	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
17	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.
18	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
19	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
20	PREF_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred Last Name
21	PREF_MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred Middle Name
22	PREF_SEC_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred Second Last Name
23	PREF_NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Preferred Name Prefix Prompt Table: NAME_PREFIX_TBL
24	PREF_NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Preferred Name Suffix Prompt Table: NAME_SUFFIX_TBL
25	PREF_NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Preferred Name Title Prompt Table: TITLE_TBL
26	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
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_FORMAL_PSF	Character(60)	VARCHAR2(60) NOT NULL	Preferred Name (PS FORMAT)
30	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
31	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
32	MIDDLE_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Middle Name uppercase search field
33	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
34	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
35	PARTN_LAST_NM_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Uppercase version of partner last name to improve performance on searches.
36	PREF_FIRST_NM_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
37	PREF_LAST_NM_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Uppercase version of preferred last name to improve performance on searches.
38	PREF_MIDL_NM_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Uppercase version of preferred middle name to improve performance on searches.
39	PREF_LAST_SEC_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Uppercase version of preferred second last name to improve performance on searches.
40	NAME_DISPLAY_SRCH	Character(50)	VARCHAR2(50) NOT NULL	Uppercase version of Name to improve performance on searches.
41	NAME_FORMAL_SRCH	Character(60)	VARCHAR2(60) NOT NULL	Uppercase version of formal name to improve performance on searches.
42	WF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Workflow Status A=Approved C=Cancelled D=Denied E=Error. Contact Administrator. F=Awaiting final approval I=In Approval Process M=Administrator is Processing N=Not Available P=Rework S=Submitted V=Data Saved
43	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
44	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
45	UPD_BY_USERID	Character(30)	VARCHAR2(30) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements
46	UPD_DTTM	DateTime(26)	TIMESTAMP	Used on "_DAT" records for 8.3 Workflow Enhancements
47	MANUAL_UPD_USERID	Character(30)	VARCHAR2(30) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements
48	MANUAL_UPD_DTTM	DateTime(26)	TIMESTAMP	Used on "_DAT" records for 8.3 Workflow Enhancements
49	SS_STAT_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements A=Approved B=CI failed - Errors & Warnings C=Cancelled D=Denied E=Errors Encountered I=In Approval Process M=Administrator Action Required S=Success W=Warnings Encountered Default Value: I
50	SS_WARNING_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements Y/N Table Edit Default Value: N
51	SS_FUTURE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Used on "_DAT" records for 8.3 Workflow Enhancements Y/N Table Edit Default Value: N
52	APPROVAL_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page. N=No Approval Required Y=Approval Required Default Value: N
53	NAME_GROUP_FLG	Character(1)	VARCHAR2(1) NOT NULL	Indicates which name group a name field is used in: D - Display F - Formal D=Display Name Group F=Formal Name Group