LM_STG_PRS_DT

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	LM_EIP_CTRL_ID	Number(10,0)	DECIMAL(10) NOT NULL	EIP Control Id
6	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
7	LM_LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese
8	LM_SEX	Character(1)	VARCHAR2(1) NOT NULL	Sex F=Female M=Male U=Unknown
9	LM_PER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Person Type
10	LM_PER_ORG_EMP	Character(1)	VARCHAR2(1) NOT NULL	Organizational Relationship Employee.
11	LM_PER_ORG_CWR	Character(1)	VARCHAR2(1) NOT NULL	Organizational Relationship Contingent Worker.
12	LM_PER_ORG_POI	Character(1)	VARCHAR2(1) NOT NULL	Organizational Relationship Person of Interest
13	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
14	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
15	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
16	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
17	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
18	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
19	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
20	BASE_LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code Prompt Table: BSLNGCDXLAT