LM_PRG_PL_VW (SQL View)	Index Back
Popular Learning Programs Gets programs for popular learning pagelets.

LM_PRG_PL_VW

(SQL View)

Popular Learning Programs

Gets programs for popular learning pagelets.

SELECT PRG.LM_PRG_ID , PRG.EFFDT , PRG.LM_PRG_TYPE , REG.LM_PERSON_ID , GRP.LM_PERSON_ID , PRG.LM_PRG_CD FROM PS_LM_PRG PRG , PS_LM_PRG_REG REG , PS_LM_GROUP_PERSON GRP , PS_LM_PRG_SECVERVW PRGS WHERE PRG.LM_PRG_ID = REG.LM_PRG_ID AND PRG.LM_PRG_STATUS = '10' AND REG.LM_PRG_STTS = 'ENRL' AND %CurrentDateIn BETWEEN PRG.EFFDT AND PRG.LM_END_EFFDT AND %NumToChar(GRP.LM_LRNR_GROUP_ID) = PRGS.LM_LRNR_SRCHGRP_ID AND PRG.LM_PRG_ID = PRGS.LM_PRG_ID

# 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 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

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

5 LM_PERSON_ID2 Number(15,0) DECIMAL(15) NOT NULL Second ELM person id needed by view LM_PRG_PL_VW and popular learning pagelets.

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

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
4	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
5	LM_PERSON_ID2	Number(15,0)	DECIMAL(15) NOT NULL	Second ELM person id needed by view LM_PRG_PL_VW and popular learning pagelets.
6	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.