LM_CI_LE_ALL_VW (SQL View)	Index Back
Catalog Item LE View Catalog Item and Learning Environment Relationship View. Shows the Catalog Item, Learning Environment and if the selected Learning Environment is the Primary LE for a particular CI. Returns all the fields in the LM_CI_LE_TBL

LM_CI_LE_ALL_VW

(SQL View)

Catalog Item LE View

Catalog Item and Learning Environment Relationship View. Shows the Catalog Item, Learning Environment and if the selected Learning Environment is the Primary LE for a particular CI. Returns all the fields in the LM_CI_LE_TBL

SELECT LM_CI_ID , EFFDT , LM_LE_ID , LM_PRM_LE FROM PS_LM_CI_LE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

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

4 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_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number
4	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)