LM_SS_ACT_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
2	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
3	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
4	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
5	LM_ACT_REQ	Character(1)	VARCHAR2(1) NOT NULL	Activity Required N=No Y=Yes Y/N Table Edit
6	LM_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Type of the Enrollment. This field for now will have only one value STDD ADHC=Adhoc PLAN=Planned RSRV=Reserved STDD=Standard
7	LM_STTS	Character(4)	VARCHAR2(4) NOT NULL	Enrollment Status CANC=Dropped COMP=Completed DECL=Denied ENRL=Enrolled INCO=Not Completed INPO=In-Progress MACT=Moved to New Activity NOTS=Not Started PEAP=Pending Approval PEPA=Pending Payment PLAN=Planned PPYA=Payment Approval RQST=Learning Request WAIV=Waived WTLT=Waitlisted
8	LM_ACT_FEE	Number(19,3)	DECIMAL(18,3) NOT NULL	Activity Fee -- The cost to the learner of enrolling in a class
9	LM_COMPL_DT	Date(10)	DATE	The date on which this Enrollment was marked Completed / InComplete
10	LM_GRADE_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	This will uniquely identify the combination of User Label / Grade value.
11	LM_SCORE	Character(30)	VARCHAR2(30) NOT NULL	Score for this Enrollment. Score will be passed by Content Vendor.
12	LM_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
13	LM_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record umber