LM_PRG_LE_VW (SQL View)	Index Back
Program Primary LE View Program Primary LE View

LM_PRG_LE_VW

(SQL View)

Program Primary LE View

SELECT A.LM_PRG_ID , A.EFFDT , B.LM_LE_ID , A.LM_PRG_STATUS , A.LM_PRG_TYPE , B.LM_PRM_LE FROM PS_LM_PRG A , PS_LM_PRG_LE B WHERE A.LM_PRG_ID = B.LM_PRG_ID AND A.EFFDT = B.EFFDT AND A.LM_PRG_STATUS IN ('10','30') AND B.LM_PRM_LE = 'Y'

# 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 NOT NULL Effective Date
Default Value: %date

3 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number

4 LM_PRG_STATUS Character(2) VARCHAR2(2) NOT NULL Program Status
10=Active
20=Inactive
30=Pending
Default Value: 30

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

6 LM_PRM_LE Character(2) VARCHAR2(2) NOT NULL Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category)

#	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 NOT NULL	Effective Date Default Value: %date
3	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number
4	LM_PRG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Program Status 10=Active 20=Inactive 30=Pending Default Value: 30
5	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
6	LM_PRM_LE	Character(2)	VARCHAR2(2) NOT NULL	Primary Learning Environment - This is a Yes/No field that signifies if the learning environment on the current row is the primary learning environment for the accompanying object (i.e. Catalog Item, Category)