LM_PRSEFDT_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
6	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
7	LM_SEX	Character(1)	VARCHAR2(1) NOT NULL	Sex F=Female M=Male U=Unknown
8	LM_PER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Person Type
9	LM_PER_ORG_EMP	Character(1)	VARCHAR2(1) NOT NULL	Organizational Relationship Employee. Y/N Table Edit Default Value: Y
10	LM_PER_ORG_CWR	Character(1)	VARCHAR2(1) NOT NULL	Organizational Relationship Contingent Worker. Y/N Table Edit Default Value: N
11	LM_PER_ORG_POI	Character(1)	VARCHAR2(1) NOT NULL	Organizational Relationship Person of Interest Y/N Table Edit Default Value: N
12	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
13	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
14	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
15	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid