LM_AP_HD_PRG_VW (SQL View)	Index Back
Program Reg Approval Header This view is used for the HTML Email Program Registration Approval header.

LM_AP_HD_PRG_VW

(SQL View)

Program Reg Approval Header

This view is used for the HTML Email Program Registration Approval header.

SELECT M.LM_PRG_REG_ID , V.LM_CERT_CASCD_EXPR , V.LM_EXPR_DAYS , V.LM_EXPR_DT , P.LM_HR_EMPLID , ' ' , P.LM_PERSON_ID , V.LM_PRG_CD , V.LM_PRG_DESCR , V.LM_PRG_LONG_NM , V.LM_PRG_TYPE , ' ' , ' ' FROM PS_LM_PRG_REG M , PS_LM_PRG V , PS_LM_PERSON P WHERE M.LM_PRG_ID = V.LM_PRG_ID AND %CurrentDateIn BETWEEN V.EFFDT AND V.LM_END_EFFDT AND M.LM_PERSON_ID = P.LM_PERSON_ID AND EXISTS ( SELECT 1 FROM PS_LM_REG_APR_XREF X WHERE X.LM_PRG_REG_ID = M.LM_PRG_REG_ID)

Related Language Record: LM_AP_HD_PRGLVW

# 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_CERT_CASCD_EXPR Character(1) VARCHAR2(1) NOT NULL Cascade Expire Certification

3 LM_EXPR_DAYS Number(5,0) INTEGER NOT NULL This is a validity period used for notifying the learner. This is what is shown to the learner as the number of days that the Certificate is valid for.

4 LM_EXPR_DT Date(10) DATE Certification Expiration Date is a fixed, preset date when the certification will expire.

5 LM_HR_EMPLID Character(11) VARCHAR2(11) NOT NULL EMPLID from the HR System

6 LM_NAME_TEXT Character(64) VARCHAR2(64) NOT NULL Name Display Text

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

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

9 LM_PRG_DESCR Character(254) VARCHAR2(254) NOT NULL Program Description

10 LM_PRG_LONG_NM Character(200) VARCHAR2(200) NOT NULL Program Long Name

11 LM_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
CE=Certification
CU=Curriculum

12 LM_PRG_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Program Type Descriptions

13 LM_PRG_VALIDITY Character(100) VARCHAR2(100) NOT NULL Program Validity

#	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_CERT_CASCD_EXPR	Character(1)	VARCHAR2(1) NOT NULL	Cascade Expire Certification
3	LM_EXPR_DAYS	Number(5,0)	INTEGER NOT NULL	This is a validity period used for notifying the learner. This is what is shown to the learner as the number of days that the Certificate is valid for.
4	LM_EXPR_DT	Date(10)	DATE	Certification Expiration Date is a fixed, preset date when the certification will expire.
5	LM_HR_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	EMPLID from the HR System
6	LM_NAME_TEXT	Character(64)	VARCHAR2(64) NOT NULL	Name Display Text
7	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
8	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.
9	LM_PRG_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Program Description
10	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
11	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
12	LM_PRG_TYPE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Program Type Descriptions
13	LM_PRG_VALIDITY	Character(100)	VARCHAR2(100) NOT NULL	Program Validity