LM_LRNRQLNR_HST (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_LRNRQLNR_HST

(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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

3 LM_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.

4 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
Prompt Table: LM_PERS_ADTL_VW

5 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

6 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	LM_LRQ_ID	Number(10,0)	DECIMAL(10) NOT NULL	New field for ELM 9.0, stores unique identifier for a single learning request.
4	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID Prompt Table: LM_PERS_ADTL_VW
5	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
6	LM_TRAINING_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Training Class Prompt Table: LM_TRAIN_CLASS