LM_LRN_REQ_LNR (SQL Table)	Index Back
Learning Request Learner's TBL Learning Request Learner's Tabel. This table is required for new functionality addded for V9. It is not required to have data for the customers existing system to continue functioning as is. No upgrade for this table is necessary.

LM_LRN_REQ_LNR

(SQL Table)

Learning Request Learner's TBL

Learning Request Learner's Tabel. This table is required for new functionality addded for V9. It is not required to have data for the customers existing system to continue functioning as is. No upgrade for this table is necessary.

Parent record: 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_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
Prompt Table: LM_PERS_ADTL_VW

3 LM_LRQ_LRNR_STTS Character(1) VARCHAR2(1) NOT NULL Learner's status in the learning request '1' Active '2' Deleted
1=Active
2=Deleted

4 LM_TRAINING_CLASS Character(10) VARCHAR2(10) NOT NULL Training Class
Prompt Table: LM_TRAIN_CLASS

#	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_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID Prompt Table: LM_PERS_ADTL_VW
3	LM_LRQ_LRNR_STTS	Character(1)	VARCHAR2(1) NOT NULL	Learner's status in the learning request '1' Active '2' Deleted 1=Active 2=Deleted
4	LM_TRAINING_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Training Class Prompt Table: LM_TRAIN_CLASS