LM_LRN_REQ_VW

(SQL View)

SELECT LM_LRQ_ID , LM_TITLE , LM_LRQ_STATUS , LM_REQUESTOR_ID , LM_ACT_ID , LM_CI_ID , LM_CATG_ID , LM_LRQ_METHOD , LM_LE_ID , LM_ISELIG_TRN_RPT , LM_ACT_DIF_FLG , LM_TRAINING_CLASS , LM_TRG_PLN_CTGY , LM_HRS_TRACK_STTS FROM PS_LM_LRN_REQ

# 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_TITLE Character(30) VARCHAR2(30) NOT NULL Field to store title of an object

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

4 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor

5 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID

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

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

8 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

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

10 LM_ISELIG_TRN_RPT Character(1) VARCHAR2(1) NOT NULL Is eligible for training plan report

11 LM_ACT_DIF_FLG Character(1) VARCHAR2(1) NOT NULL DIF Enrollment

12 LM_TRAINING_CLASS Character(10) VARCHAR2(10) NOT NULL Training Class

13 LM_TRG_PLN_CTGY Character(10) VARCHAR2(10) NOT NULL Training Plan Category

14 LM_HRS_TRACK2_STTS Character(1) VARCHAR2(1) NOT NULL Hour Tracking Status
0=Select...
1=Pending Review from ELM Admin
2=Approved by ELM Administrator
4=Cancelled

#	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_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Field to store title of an object
3	LM_LRQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	New Field. Uppercase. Stores current status of learning request. 1=Requested 2=Inactive 3=Offered
4	LM_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
5	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
6	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
7	LM_CATG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Category ID - System generated number used to uniquely identify a Category.
8	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
9	LM_LE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Environment ID - System Generated number
10	LM_ISELIG_TRN_RPT	Character(1)	VARCHAR2(1) NOT NULL	Is eligible for training plan report
11	LM_ACT_DIF_FLG	Character(1)	VARCHAR2(1) NOT NULL	DIF Enrollment
12	LM_TRAINING_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Training Class
13	LM_TRG_PLN_CTGY	Character(10)	VARCHAR2(10) NOT NULL	Training Plan Category
14	LM_HRS_TRACK2_STTS	Character(1)	VARCHAR2(1) NOT NULL	Hour Tracking Status 0=Select... 1=Pending Review from ELM Admin 2=Approved by ELM Administrator 4=Cancelled