LM_NEW_LRN_WRK2

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
3	LM_LRNR_GROUP_ID	Number(15,0)	DECIMAL(15) NOT NULL	Learner Group ID - Business Role/ Student Group ID
4	LM_ACT_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Holds the Activity or Program ID.
5	LM_ACT_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Holds activity or program code.
6	LM_ACT_PRG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Activity or Program Status Y/N Table Edit Default Value: N
7	LM_ACT_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Holds activity or program long name.
8	LM_DM_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - the long name of a Delivery Method Type
9	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
10	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code
11	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
12	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
13	EFFDT_TO	Date(10)	DATE	Effective Date To
14	LM_FIND_MORE_LINK	Character(30)	VARCHAR2(30) NOT NULL	Find More link work field.
15	LM_ROW_NBR	Number(6,0)	INTEGER NOT NULL	Holds a the row number in some learning pagelets.
16	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
17	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
18	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
19	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid