LM_LPLN_LRN

(SQL Table)
Index Back

Learner's Learning Plan

This is the Learner's Learning Plan table. A learner can have multiple learning plans.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LM_LPLN_ID Number(10,0) DECIMAL(10) NOT NULL Learning Plan ID
2 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
3 LM_LPLN_STATUS Character(1) VARCHAR2(1) NOT NULL Learning Plan Status
A=Active
C=Complete
I=Inactive

Default Value: A

4 LM_LPLN_DEFAULT Character(1) VARCHAR2(1) NOT NULL Learning Plan Default

Y/N Table Edit

Default Value: N

5 LM_COMPL_DATE Date(10) DATE Learning Plan Completion Date
6 LM_ASSIGNED_BY Number(15,0) DECIMAL(15) NOT NULL Assigned By