LM_STG_PRS_NM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	LM_HR_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	EMPLID from the HR System
4	LM_NAME_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Name Type
5	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
6	LM_EIP_CTRL_ID	Number(10,0)	DECIMAL(10) NOT NULL	EIP Control Id
7	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
8	LM_DISPLAY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Display the information flag.
9	LM_EIP_PRCS_STTS	Character(1)	VARCHAR2(1) NOT NULL	EIP Process status 0=Not Processed 1=Validated 2=Invalid Data 3=Loaded Successfully 4=Invalid EmplRcd Number 5=Warning Message
10	COUNTRY_NM_FORMAT	Character(3)	VARCHAR2(3) NOT NULL	Format for Country Prompt Table: COUNTRY_TBL
11	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
12	NAME_INITIALS	Character(6)	VARCHAR2(6) NOT NULL	Name Initials
13	NAME_PREFIX	Character(4)	VARCHAR2(4) NOT NULL	Name Prefix
14	NAME_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Suffix
15	NAME_ROYAL_PREFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Prefix
16	NAME_ROYAL_SUFFIX	Character(15)	VARCHAR2(15) NOT NULL	Name Royal Suffix
17	NAME_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Title
18	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
19	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
20	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name Field
21	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name field
22	MIDDLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Middle Name
23	SECOND_LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Second Last Name
24	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Name
25	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Name
26	PREF_FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Preferred First Name
27	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.
28	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.
29	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.
30	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
31	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
32	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
33	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
34	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
35	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
36	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values
37	BASE_LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code Prompt Table: BSLNGCDXLAT