TRN_STG_ENRCOST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
2	LM_COST_ID	Number(4,0)	SMALLINT NOT NULL	Cost ID
3	LM_RESOURCE_ID	Number(15,0)	DECIMAL(15) NOT NULL	Resource ID
4	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
5	LM_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
8	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
9	COURSE_START_DT	Date(10)	DATE	Course Start Date
10	COURSE_END_DT	Date(10)	DATE	Course End Date
11	COURSE_TITLE	Character(30)	VARCHAR2(30) NOT NULL	Course Title
12	LM_LC_SHRT_NM	Character(10)	VARCHAR2(10) NOT NULL	Session Name
13	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
14	PER_EE_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	PER_EE_COST
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	LM_COST_CTGRY	Character(2)	VARCHAR2(2) NOT NULL	Cost Category (Material, Equipment, Instructor or Facility) 01=Equipment 02=Facility 03=Instructor 04=Material 05=Other 06=Content Cost 07=Vendor
17	CHARGEABLE_SW_FRA	Character(1)	VARCHAR2(1) NOT NULL	Chargeable switch
18	LM_CHARGEABLE_ORG	Number(15,0)	DECIMAL(15) NOT NULL	Chargeable Organization
19	LM_CHARG_HR_SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
20	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
21	CHARGEABLE_CST_FRA	Number(19,3)	DECIMAL(18,3) NOT NULL	Chargeable Cost
22	LM_FINANCED_ORG	Number(15,0)	DECIMAL(15) NOT NULL	Financing Organization
23	LM_ORG_DESCR	Character(50)	VARCHAR2(50) NOT NULL	Customer Description
24	FINANCED_COST_FRA	Number(19,3)	DECIMAL(18,3) NOT NULL	Financed Cost
25	COMPANY_COST_FRA	Number(19,3)	DECIMAL(18,3) NOT NULL	Company Cost
26	LM_VAR_FIELD1	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
27	LM_VAR_FIELD2	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
28	LM_VAR_FIELD3	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
29	LM_VAR_FIELD4	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
30	LM_VAR_FIELD5	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
31	LM_VAR_FIELD6	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
32	LM_VAR_FIELD7	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
33	LM_VAR_FIELD8	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
34	LM_VAR_FIELD9	Character(15)	VARCHAR2(15) NOT NULL	Variable Purpose Field
35	LM_TRAINING_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Training Class Default Value: 9
36	LM_EXTRNL_OFRNG	Character(3)	VARCHAR2(3) NOT NULL	Internal/External Offering - A checkbox allowing the user to select whether the course is Internal or External. 10=Internal 20=External
37	LM_LC_COMP_STTS	Character(4)	VARCHAR2(4) NOT NULL	Learning Component - Completion Status CANC=Dropped COMP=Completed INCO=Not Completed INPO=In-Progress NOAT=Not Attempted
38	LM_CST_TRACK_STTS	Character(1)	VARCHAR2(1) NOT NULL	Student Cost Status 1=Ready to Sent to HR/TA 2=Sent to HR/TA successfully 3=Cancelled 4=Publish Error 5=Processed by HR/TA 6=Processed by HR/TA with Errors 9=New
39	DURATION_TIME	Number(6,1)	DECIMAL(5,1) NOT NULL	Duration Time
40	TIME_SPENT_FRA	Number(6,1)	DECIMAL(5,1) NOT NULL	Time spent at training
41	TRN_DIF_FRA_FLG	Character(1)	VARCHAR2(1) NOT NULL	Field for Training DIF
42	TRN_OUTWRK_FLG_FRA	Character(1)	VARCHAR2(1) NOT NULL	Out of Working Schedule Flag
43	LM_ATT_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Attendance Scheme Value Id. This will identify the combination of User Label / Attendance uniquely
44	LM_PASS_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Passing Scheme Value ID