LM_CMPLWRN_VW (SQL View)	Index Back
completion warning notificatio completion warning notification

LM_CMPLWRN_VW

(SQL View)

completion warning notificatio

completion warning notification

SELECT A.LM_PRG_REG_ID ,A.LM_PRG_ID ,A.LM_PERSON_ID ,B.LM_PRG_CD ,A.LM_ENRL_DT ,B.LM_CMPL_WRN_DAYS ,B.LM_CMPL_PD_DAYS ,A.LM_TARGET_CMPL_DT ,A.LM_CERT_EFFDT FROM PS_LM_PRG_REG A , PS_LM_PRG B WHERE A.LM_PRG_ID=B.LM_PRG_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND A.LM_PRG_STTS IN ('ENRL','INPO','PEAP','PEPA') AND %DateAdd(%CurrentDateIn,B.LM_CMPL_WRN_DAYS) = A.LM_TARGET_CMPL_DT

# 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_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.

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

4 LM_PRG_CD Character(30) VARCHAR2(30) NOT NULL Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.

5 LM_ENRL_DT Date(10) DATE Enrollment/Registration Date

6 LM_CMPL_WRN_DAYS Number(3,0) SMALLINT NOT NULL The completion warning period is the number of days in advance of the target completion date, when an email notification will be sent to warn a learner to complete the requirements before time is up.

7 LM_CMPL_PD_DAYS Number(3,0) SMALLINT NOT NULL Completion Period is the period used to determine the target completion date for the learner.

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

9 LM_CERT_EFFDT Date(10) DATE Current Certification Date

#	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_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
3	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
4	LM_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
5	LM_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
6	LM_CMPL_WRN_DAYS	Number(3,0)	SMALLINT NOT NULL	The completion warning period is the number of days in advance of the target completion date, when an email notification will be sent to warn a learner to complete the requirements before time is up.
7	LM_CMPL_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Completion Period is the period used to determine the target completion date for the learner.
8	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.
9	LM_CERT_EFFDT	Date(10)	DATE	Current Certification Date