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

LM_MAND_NOTF_VW

(SQL View)

Mandatory Notification view

SELECT A.LM_ACT_ID , B.LM_PERSON_ID , B.LM_EMPL_RCD , B.LM_CI_ID , A.LM_LRNR_GROUP_ID , A.LM_NOTIF_TYPE , A.LM_NUM_DAYS , A.LM_NOTIF_RECIPIENT ,B.LM_ENRLMT_ID ,B.LM_STTS ,B.LM_TARGET_CMPL_DT FROM PS_LM_ACT_ML_NOTIF A ,PS_LM_ML_ENRLMT_VW B WHERE A.LM_ACT_ID=B.LM_ACT_ID AND B.LM_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_PERS_MAN_VW1 C WHERE C.LM_PERSON_ID=B.LM_PERSON_ID AND C.LM_ACT_ID=B.LM_ACT_ID AND C.LM_LRNR_GROUP_ID=B.LM_LRNR_GROUP_ID) UNION SELECT A.LM_ACT_ID , B.LM_PERSON_ID , B.LM_EMPL_RCD , B.LM_CI_ID , A.LM_LRNR_GROUP_ID , A.LM_NOTIF_TYPE , A.LM_NUM_DAYS , A.LM_NOTIF_RECIPIENT ,B.LM_ENRLMT_ID ,B.LM_STTS ,B.LM_TARGET_CMPL_DT FROM PS_LM_ACT_ML_NOTIF A ,PS_LM_ML_ENRLMT_VW B WHERE A.LM_ACT_ID=B.LM_ACT_ID AND B.LM_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_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

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_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

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

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

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

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

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

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_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_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
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_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
5	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID
6	LM_NOTIF_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Notification Type A=Approaching Due Date E=Enrollment O=Overdue
7	LM_NUM_DAYS	Number(3,0)	SMALLINT NOT NULL	Number of days
8	LM_NOTIF_RECIPIENT	Character(1)	VARCHAR2(1) NOT NULL	Recipient B=Both Learner and Manager L=Learner M=Manager
9	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
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_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.