LM_TRPLNITM_HST

#	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_TRN_PLN_ID	Character(30)	VARCHAR2(30) NOT NULL	Training Plan Id
4	LM_TRNG_PLN_ITM_ID	Number(10,0)	DECIMAL(10) NOT NULL	Training plan item id for the report
5	LM_ITEM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Item type to identify a training plan item. It can be of type Activity or Learning Request. 1=Class 2=Learning Request 3=Program Registration 4=Supplemental Learning
6	LM_LRQ_ID	Number(10,0)	DECIMAL(10) NOT NULL	New field for ELM 9.0, stores unique identifier for a single learning request.
7	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
8	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
9	LM_START_DT	Date(10)	DATE	Start Date
10	LM_END_DT	Date(10)	DATE	End Date
11	LM_INSTR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Instructor ID
12	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
13	LM_OBJV_ID	Number(10,0)	DECIMAL(10) NOT NULL	Objective ID. System Generated ID Number associated with each Objective.
14	LM_OBJV_DESC	Character(100)	VARCHAR2(100) NOT NULL	Objective description.
15	LM_ACT_HOURS	Number(13,2)	DECIMAL(12,2) NOT NULL	Activity Hours
16	LM_INTERNAL_OFF	Character(30)	VARCHAR2(30) NOT NULL	Internal/External Offering
17	LM_VENDOR_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Vendor Description
18	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
19	LM_ADHC_LRN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Adhoc Learning Id
20	LM_TP_ITM_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Training Plan Item Cost
21	LM_EST_SAL_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Estimated Salary Cost
22	LM_FROM_LRQ	Character(1)	VARCHAR2(1) NOT NULL	From Learning Request Y/N Table Edit Default Value: N