LM_PRCS_PLN_STG

#	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_ADHC_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Learning Id
4	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
5	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.
6	LM_ASSIGNED_BY	Number(15,0)	DECIMAL(15) NOT NULL	Assigned By
7	LM_PRIORITY	Character(1)	VARCHAR2(1) NOT NULL	Learning Plan Priority H=High L=Low M=Medium
8	LM_TARGET_DATE	Date(10)	DATE	Learning Plan Target Date
9	LM_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Required
10	LM_LPLN_DTL_TITLE	Character(254)	VARCHAR2(254) NOT NULL	This field is used to for the Learning Plan Learners Detail. The title from Enrollments, Program Registrations and Adhoc Enrollments: PS_LM_CI_TBL.LM_CS_LONG_NM PS_LM_PRG.LM_PRG_LONG_NM, PS_LM_ADHC_TBL.LM_PER_TRN_NM are placed on this field for display
11	LM_LPLN_DTL_TYPE	Character(200)	VARCHAR2(200) NOT NULL	This field is used for the Learning Plan Detail Page. The TYPE will be derived values from the following tables: PS_LM_ADHC_TBL.LM_ADHC_TYPE PS_LM_PRG.LM_PRG_TYPE PS_LM_ACT_PLN_VW.LM_DM_LONG_NM
12	LM_LPLN_DTL_STTS	Character(4)	VARCHAR2(4) NOT NULL	The translate values for this field are derived from the translate values of fields: LM_PRG_STTS, LM_ADHC_LRN_STTS, LM_STTS Also note that new value REGR (Registered) is added. This is used for program registation when status is ENRL. View PS_LM_LPLN_PRG_VW transforms status ENRL to REGR CANC=Dropped COMP=Completed DECL=Denied DROP=Dropped ENRL=Enrolled EXPR=Expired INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REGR=Registered REIS=Reissue REVK=Revoked RQST=Learning Request WAIV=Waived WARN=Warning WTLT=Waitlisted
13	LM_ACT_REQ	Character(1)	VARCHAR2(1) NOT NULL	Activity Required N=No Y=Yes
14	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
15	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
16	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
17	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
18	PROCESSED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Used for Leave Donations Batch Process to indicate whether to process a request or not.