LM_TPLN_LRQL_VW (SQL View)	Index Back
Learners of learning request Learners of learning request

LM_TPLN_LRQL_VW

(SQL View)

Learners of learning request

SELECT A.LM_LRQ_ID , %DatePart(A.LM_ROW_ADDED_DTTM) , B.LM_PERSON_ID , B.LM_TRAINING_CLASS , A.LM_ISELIG_TRN_RPT FROM PS_LM_LRN_REQ A , PS_LM_LRN_REQ_LNR B WHERE A.LM_LRQ_ID = B.LM_LRQ_ID AND B.LM_LRQ_LRNR_STTS = '1'

# 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_ENRL_DT Date(10) DATE Enrollment/Registration Date

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

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

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

#	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_ENRL_DT	Date(10)	DATE	Enrollment/Registration Date
3	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
4	LM_TRAINING_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Training Class
5	LM_ACT_DIF_FLG	Character(1)	VARCHAR2(1) NOT NULL	DIF Enrollment