LM_PERSON_EFFDT

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