LM_LPLN_LRN_HST (SQL Table)	Index Back
Learner's Learning Plan This is the Learner's Learning Plan table. - History Table

LM_LPLN_LRN_HST

(SQL Table)

Learner's Learning Plan

This is the Learner's Learning Plan table. - History Table

# 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_LPLN_STATUS Character(1) VARCHAR2(1) NOT NULL Learning Plan Status
A=Active
C=Complete
I=Inactive
Default Value: A

6 LM_LPLN_DEFAULT Character(1) VARCHAR2(1) NOT NULL Learning Plan Default
Y/N Table Edit
Default Value: N

7 LM_COMPL_DATE Date(10) DATE Learning Plan Completion Date

8 LM_ASSIGNED_BY Number(15,0) DECIMAL(15) NOT NULL Assigned By

#	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_LPLN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Status A=Active C=Complete I=Inactive Default Value: A
6	LM_LPLN_DEFAULT	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Default Y/N Table Edit Default Value: N
7	LM_COMPL_DATE	Date(10)	DATE	Learning Plan Completion Date
8	LM_ASSIGNED_BY	Number(15,0)	DECIMAL(15) NOT NULL	Assigned By