LM_LRQ_TRK_HST (SQL Table)	Index Back
Learning Request Tracking Hist Learning Request Tracking History

LM_LRQ_TRK_HST

(SQL Table)

Learning Request Tracking Hist

Learning Request Tracking History

# 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_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

4 LM_ACT_CHANGE_DT Date(10) DATE Action Change Date

5 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_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
4	LM_ACT_CHANGE_DT	Date(10)	DATE	Action Change Date
5	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID