LM_LRQ_TRHS_MAX (SQL View)	Index Back
LRQ Tracking History Max Seqnm This view extracts the maximum SEQNUM on Learning Request Tracking History

LM_LRQ_TRHS_MAX

(SQL View)

LRQ Tracking History Max Seqnm

This view extracts the maximum SEQNUM on Learning Request Tracking History

SELECT HST.LM_LRQ_ID , HST.SEQNUM , HST.LM_LRQ_ACTIONS , HST.LM_ACT_CHANGE_DT , HST.LM_PERSON_ID FROM PS_LM_LRQ_TRK_HST HST WHERE HST.SEQNUM = ( SELECT MAX(X.SEQNUM) FROM PS_LM_LRQ_TRK_HST X WHERE X.LM_LRQ_ID = HST.LM_LRQ_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

#	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