LM_LRQ_LEID_VW (SQL View)	Index Back
CATG and CI Learning Envr This view is to extract the learning environment for the catalog item or category. It is used for the Learning Requests.

LM_LRQ_LEID_VW

(SQL View)

CATG and CI Learning Envr

This view is to extract the learning environment for the catalog item or category. It is used for the Learning Requests.

SELECT CI.LM_CI_ID , 0 , CI.LM_LE_ID FROM PS_LM_CI_LE_TBL CI WHERE CI.EFFDT = ( SELECT MAX(XCI.EFFDT) FROM PS_LM_CI_LE_TBL XCI WHERE XCI.LM_CI_ID = CI.LM_CI_ID AND XCI.LM_LE_ID = CI.LM_LE_ID AND XCI.EFFDT <= %CurrentDateIn) UNION SELECT 0 , CATG.LM_CATG_ID , CATG.LM_LE_ID FROM PS_LM_CATG_LE_TBL CATG

# 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
Default Value: 0

2 LM_CATG_ID Number(10,0) DECIMAL(10) NOT NULL Category ID - System generated number used to uniquely identify a Category.
Default Value: 0

3 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
Default Value: 0
Prompt Table: LM_CI_LE_VW