LM_LPLN_DTL_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_LPLN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Plan ID
4	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
5	LM_ADHC_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Learning Id
6	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
7	LM_PRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.
8	LM_ASSIGNED_BY	Number(15,0)	DECIMAL(15) NOT NULL	Assigned By
9	LM_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Priority H=High L=Low M=Medium Default Value: L
10	LM_TARGET_DATE	Date(10)	DATE	Learning Plan Target Date
11	LM_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Required Y/N Table Edit Default Value: N
12	LM_SCHEDULE_ENRLMT	Character(1)	VARCHAR2(1) NOT NULL	Schedule Enrollment Default Value: N
13	LM_SCHED_ENRL_FROM	Date(10)	DATE	Schedule Enrollment Date Range
14	LM_SCHED_ENRL_TO	Date(10)	DATE	Schedule Enrollment Date Range
15	LM_TRNG_REG_CD	Character(30)	VARCHAR2(30) NOT NULL	Training Region Prompt Table: LM_TRNG_REG_TBL