LM_PRQ_PRG_VW (SQL View)	Index Back
Prerequisite Program View Table of Programs modified for use as a prompt for pre-reqs

LM_PRQ_PRG_VW

(SQL View)

Prerequisite Program View

Table of Programs modified for use as a prompt for pre-reqs

SELECT PRG.LM_PRG_ID , PRG.LM_PRG_TYPE , PRG.LM_PRG_CD , PRG.LM_PRG_LONG_NM , OPRLE.OPRID FROM PS_LM_PRG PRG , PS_LM_OPRID_LE_VW OPRLE , PS_LM_PRG_LE PRGLE WHERE %CurrentDateIn BETWEEN PRG.EFFDT AND PRG.LM_END_EFFDT AND OPRLE.LM_LE_ID = PRGLE.LM_LE_ID AND PRG.LM_PRG_ID = PRGLE.LM_PRG_ID AND PRG.EFFDT = PRGLE.EFFDT AND PRG.LM_PRG_STATUS = '10'

Related Language Record: LM_PRQ_PRG_LNG

# 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_PRG_TYPE Character(2) VARCHAR2(2) NOT NULL Program Type
CE=Certification
CU=Curriculum

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

4 LM_PRQ_NAME Character(254) VARCHAR2(254) NOT NULL A field used to show the name of a pre-requisite catalog item/objective

5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

#	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_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
3	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.
4	LM_PRQ_NAME	Character(254)	VARCHAR2(254) NOT NULL	A field used to show the name of a pre-requisite catalog item/objective
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).