LM_ITEM_STTS_VW (SQL View)	Index Back
Program Item Status View This view shows all items that have been completed by a learner for a particular program. It joins in the adhoc learning id from the enrollment table to allow one to determine if the item was completed or waived.

LM_ITEM_STTS_VW

(SQL View)

Program Item Status View

This view shows all items that have been completed by a learner for a particular program. It joins in the adhoc learning id from the enrollment table to allow one to determine if the item was completed or waived.

SELECT A.LM_PRG_REG_ID ,A.LM_SCN_ID ,A.LM_OBJ_ID , A.LM_OBJ_TYPE ,A.LM_ENRLMT_ID ,A.LM_PRG_ID ,A.LM_PERSON_ID ,B.LM_ADHC_LRN_ID ,B.LM_TYPE ,B.LM_STTS ,B.LM_ENRL_DT ,B.LM_COMPL_DT , A.LM_EQUIV_REG_ID , A.LM_EQUIV_OBJ_TYPE , A.LM_NSTPRG_REG_ID FROM PS_LM_PRG_ITEM_ENR A , PS_LM_ENRLMT_VW B WHERE A.LM_ENRLMT_ID = B.LM_ENRLMT_ID

# 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_SCN_ID Number(10,0) DECIMAL(10) NOT NULL Section ID

3 LM_OBJ_ID Number(10,0) DECIMAL(10) NOT NULL Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.

4 LM_OBJ_TYPE Character(3) VARCHAR2(3) NOT NULL Object Type
10=Catalog Item
20=Activity
30=Program

5 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID

6 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

7 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

8 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id

9 LM_TYPE Character(4) VARCHAR2(4) NOT NULL Type of the Enrollment. This field for now will have only one value STDD
ADHC=Adhoc
PLAN=Planned
RSRV=Reserved
STDD=Standard

10 LM_STTS Character(4) VARCHAR2(4) NOT NULL Enrollment Status
CANC=Dropped
COMP=Completed
DECL=Denied
ENRL=Enrolled
INCO=Not Completed
INPO=In-Progress
MACT=Moved to New Activity
NOTS=Not Started
PEAP=Pending Approval
PEPA=Pending Payment
PLAN=Planned
PPYA=Payment Approval
RQST=Learning Request
WAIV=Waived
WTLT=Waitlisted

11 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date

12 LM_COMPL_DT Date(10) DATE The date on which this Enrollment was marked Completed / InComplete

13 LM_EQUIV_REG_ID Number(10,0) DECIMAL(10) NOT NULL Equivalent Rehistration ID

14 LM_EQUIV_OBJ_TYPE Character(3) VARCHAR2(3) NOT NULL Equivalent Object Type
10=Course
20=Program

15 LM_NSTPRG_REG_ID Number(10,0) DECIMAL(10) NOT NULL The Program Registration ID is a unique identifier for a learner's program enrollment.

#	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_SCN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Section ID
3	LM_OBJ_ID	Number(10,0)	DECIMAL(10) NOT NULL	Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID.
4	LM_OBJ_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Object Type 10=Catalog Item 20=Activity 30=Program
5	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
6	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
7	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
8	LM_ADHC_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Learning Id
9	LM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Type of the Enrollment. This field for now will have only one value STDD ADHC=Adhoc PLAN=Planned RSRV=Reserved STDD=Standard
10	LM_STTS	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Status CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted
11	LM_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
12	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
13	LM_EQUIV_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Equivalent Rehistration ID
14	LM_EQUIV_OBJ_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Equivalent Object Type 10=Course 20=Program
15	LM_NSTPRG_REG_ID	Number(10,0)	DECIMAL(10) NOT NULL	The Program Registration ID is a unique identifier for a learner's program enrollment.