LM_LRQ_CTCI_SRC (SQL View)	Index Back
LRQ Search CATG/CI This view is used to search the catalog items or category for the learning requests

LM_LRQ_CTCI_SRC

(SQL View)

LRQ Search CATG/CI

This view is used to search the catalog items or category for the learning requests

SELECT A.LM_LRQ_ID , 0 , A.LM_CATG_ID , A.LM_LRQ_STATUS , A.LM_CREATED_DT FROM PS_LM_LRN_REQ A , PS_LM_CATG_VW C WHERE A.LM_CATG_ID = C.LM_CATG_ID AND A.LM_LRQ_STATUS IN ('1', '3') UNION SELECT A2.LM_LRQ_ID , A2.LM_CI_ID , 0 , A2.LM_LRQ_STATUS , A2.LM_CREATED_DT FROM PS_LM_LRN_REQ A2 , PS_LM_CI_VW C2 WHERE A2.LM_CI_ID = C2.LM_CI_ID AND A2.LM_LRQ_STATUS IN ('1', '3')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.

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

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

4 LM_LRQ_STATUS Character(1) VARCHAR2(1) NOT NULL New Field. Uppercase. Stores current status of learning request.
1=Requested
2=Inactive
3=Offered

5 LM_CREATED_DT Date(10) DATE Creation Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_LRQ_ID	Number(10,0)	DECIMAL(10) NOT NULL	New field for ELM 9.0, stores unique identifier for a single learning request.
2	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
3	LM_CATG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Category ID - System generated number used to uniquely identify a Category.
4	LM_LRQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	New Field. Uppercase. Stores current status of learning request. 1=Requested 2=Inactive 3=Offered
5	LM_CREATED_DT	Date(10)	DATE	Creation Date