LM_PRG_MLNOT_VW (SQL View)	Index Back
Mandatory Notification view Mandatory Notification view

LM_PRG_MLNOT_VW

(SQL View)

Mandatory Notification view

SELECT A.LM_PRG_ID , B.LM_PERSON_ID , B.LM_EMPL_RCD , A.LM_LRNR_GROUP_ID , A.LM_NOTIF_TYPE , A.LM_NUM_DAYS , A.LM_NOTIF_RECIPIENT ,B.LM_PRG_REG_ID ,B.LM_PRG_STTS ,B.LM_TARGET_CMPL_DT FROM PS_LM_PRG_ML_NOTIF A ,PS_LM_ML_RGSTN_VW B WHERE A.LM_PRG_ID=B.LM_PRG_ID AND B.LM_PRG_STTS IN ('ENRL', 'INPO', 'INCO', 'WTLT', 'PEAP', 'PEPA', 'PPYA') AND A.LM_LRNR_GROUP_ID=B.LM_LRNR_GROUP_ID AND B.LM_LRNR_GROUP_ID<>0 AND EXISTS( SELECT 'X' FROM PS_LM_RGSTN_ML_VW C WHERE C.LM_PERSON_ID=B.LM_PERSON_ID AND C.LM_PRG_ID=B.LM_PRG_ID AND C.LM_LRNR_GROUP_ID=B.LM_LRNR_GROUP_ID) UNION SELECT A.LM_PRG_ID , B.LM_PERSON_ID , B.LM_EMPL_RCD , A.LM_LRNR_GROUP_ID , A.LM_NOTIF_TYPE , A.LM_NUM_DAYS , A.LM_NOTIF_RECIPIENT ,B.LM_PRG_REG_ID ,B.LM_PRG_STTS ,B.LM_TARGET_CMPL_DT FROM PS_LM_PRG_ML_NOTIF A ,PS_LM_ML_RGSTN_VW B WHERE A.LM_PRG_ID=B.LM_PRG_ID AND B.LM_PRG_STTS IN ('ENRL', 'INPO', 'INCO', 'WTLT', 'PEAP', 'PEPA', 'PPYA') AND A.LM_PERSON_ID=B.LM_PERSON_ID AND B.LM_LRNR_GROUP_ID=0 AND B.LM_PERSON_ID<>0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 LM_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record umber

4 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID

5 LM_NOTIF_TYPE Character(1) VARCHAR2(1) NOT NULL Notification Type
A=Approaching Due Date
E=Enrollment
O=Overdue

6 LM_NUM_DAYS Number(3,0) SMALLINT NOT NULL Number of days

7 LM_NOTIF_RECIPIENT Character(1) VARCHAR2(1) NOT NULL Recipient
B=Both Learner and Manager
L=Learner
M=Manager

8 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.

9 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

10 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	LM_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record umber
4	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID
5	LM_NOTIF_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Notification Type A=Approaching Due Date E=Enrollment O=Overdue
6	LM_NUM_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of days
7	LM_NOTIF_RECIPIENT	Character(1)	VARCHAR2(1) NOT NULL	Recipient B=Both Learner and Manager L=Learner M=Manager
8	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.
9	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
10	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.