LM_CERT_PRG_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
4	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
5	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
6	LM_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
7	LM_PRG_STTS	Character(4)	VARCHAR2(4) NOT NULL	Program Reg Status CANC=Dropped COMP=Completed DECL=Decline ENRL=Registered EXPR=Expired INCO=Not Completed INPO=In-Progress PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval REIS=Reissue REVK=Revoked WAIV=Waived WARN=Warning
8	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
9	LM_TARGET_CMPL_DT	Date(10)	DATE	The target date by which the student should complete the course. This field is only applicable for WBT activity and the Learning Period for the WBT activity is Enforced. If the Learning Period is not enforced, this field will hold no value.
10	LM_DP_DT	Date(10)	DATE	Drop Date
11	LM_CERT_DT	Date(10)	DATE	Certification Date
12	LM_EXPR_DT	Date(10)	DATE	Certification Expiration Date is a fixed, preset date when the certification will expire.
13	LM_GRACE_EXPR_DT	Date(10)	DATE	Grace Period Expiration Date
14	LM_RECERT_DT	Date(10)	DATE	Recertification Date
15	LM_RECERT_WRN_DT	Date(10)	DATE	Recertification Warn Date
16	LM_EXPR_WRN_DT	Date(10)	DATE	Expiration Warning Date
17	LM_CERT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Certification ID
18	LM_CERT_EFFDT	Date(10)	DATE	Current Certification Date
19	LM_STTS_CHANGE_DT	Date(10)	DATE	Status Chage Date