LM_ACT_PRG1_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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
5	LM_ACT_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Holds the Activity or Program ID.
6	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
7	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
8	LM_ACT_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Holds activity or program code.
9	LM_POP_LRNG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Holds a type indicator of popular learning such as activity or program. 10=Activity 20=Program
10	LM_ACT_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Holds activity or program long name.
11	LM_DM_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - the long name of a Delivery Method Type
12	LM_ENRL_TOT	Number(6,0)	INTEGER NOT NULL	Enrollment Total
13	LM_FIND_MORE_LINK	Character(30)	VARCHAR2(30) NOT NULL	Find More link work field.
14	LM_FND_LRN_ACT_BTN	Character(1)	VARCHAR2(1) NOT NULL	Find Learning Action Button E=Enroll L=Launch P=Plan for Later R=Register S=Select
15	LM_ROW_NBR	Number(6,0)	INTEGER NOT NULL	Holds a the row number in some learning pagelets.