LM_LRQ_CT_CI_HS (SQL View)	Index Back
Learning Request with CATG/CI This view returns details of learning requests tracking history that have categories and catalog items. The learning request tracking history stores all learning request actions taken for the specific learning request.

LM_LRQ_CT_CI_HS

(SQL View)

Learning Request with CATG/CI

This view returns details of learning requests tracking history that have categories and catalog items. The learning request tracking history stores all learning request actions taken for the specific learning request.

SELECT HST1.LM_LRQ_ID , HST1.SEQNUM , 0 , A.LM_CATG_ID , A.LM_TITLE , C.LM_CS_LONG_NM , A.LM_LRQ_METHOD , A.LM_SEAT_REQ , A.LM_LRQ_STATUS , HST1.LM_LRQ_ACTIONS , HST1.LM_ACT_CHANGE_DT , HST1.LM_PERSON_ID FROM PS_LM_LRN_REQ A , PS_LM_CATG_TBL C , PS_LM_LRQ_TRK_HST HST1 WHERE A.LM_CATG_ID = C.LM_CATG_ID AND HST1.LM_LRQ_ID = A.LM_LRQ_ID UNION SELECT HST2.LM_LRQ_ID , HST2.SEQNUM , A2.LM_CI_ID , 0 , A2.LM_TITLE , C2.LM_CS_LONG_NM , A2.LM_LRQ_METHOD , A2.LM_SEAT_REQ , A2.LM_LRQ_STATUS , HST2.LM_LRQ_ACTIONS , HST2.LM_ACT_CHANGE_DT , HST2.LM_PERSON_ID FROM PS_LM_LRN_REQ A2 , PS_LM_CI_TBL C2 , PS_LM_LRQ_TRK_HST HST2 WHERE HST2.LM_LRQ_ID = A2.LM_LRQ_ID AND A2.LM_CI_ID = C2.LM_CI_ID AND %CurrentDateIn BETWEEN C2.EFFDT AND C2.LM_END_EFFDT AND C2.LM_CI_STATUS = '10'

Related Language Record: LM_LRQ_HS_LANG

# 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

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

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

5 LM_TITLE Character(30) VARCHAR2(30) NOT NULL Field to store title of an object

6 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object

7 LM_LRQ_METHOD Character(1) VARCHAR2(1) NOT NULL Method field in learning request o know if learner prefers self-paced or scheduled learning.
1=No Preference
2=Online
3=Classroom
4=Live Webcast

8 LM_SEAT_REQ Number(10,0) DECIMAL(10) NOT NULL Number of Seat Request

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

10 LM_LRQ_ACTIONS Character(2) VARCHAR2(2) NOT NULL Learning Requests Actions
00=Submitted
01=Assigned
02=New Offered
03=Enrolled
04=Deleted
06=Exists
07=Declined

11 LM_ACT_CHANGE_DT Date(10) DATE Action Change Date

12 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID

#	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
3	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
4	LM_CATG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Category ID - System generated number used to uniquely identify a Category.
5	LM_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Field to store title of an object
6	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
7	LM_LRQ_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Method field in learning request o know if learner prefers self-paced or scheduled learning. 1=No Preference 2=Online 3=Classroom 4=Live Webcast
8	LM_SEAT_REQ	Number(10,0)	DECIMAL(10) NOT NULL	Number of Seat Request
9	LM_LRQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	New Field. Uppercase. Stores current status of learning request. 1=Requested 2=Inactive 3=Offered
10	LM_LRQ_ACTIONS	Character(2)	VARCHAR2(2) NOT NULL	Learning Requests Actions 00=Submitted 01=Assigned 02=New Offered 03=Enrolled 04=Deleted 06=Exists 07=Declined
11	LM_ACT_CHANGE_DT	Date(10)	DATE	Action Change Date
12	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID