LM_PRG_ITEM

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_PRG_ID	Number(10,0)	DECIMAL(10) NOT NULL	Program ID is a unique identifier for curriculum and certification Programs.
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: LM_PRG_SCN.EFFDT
3	LM_SCN_ID	Number(10,0)	DECIMAL(10) NOT NULL	Section ID Default Value: 0
4	LM_OBJ_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Object Type 10=Catalog Item 20=Activity 30=Program Default Value: 10
5	LM_OBJ_ID	Number(10,0)	DECIMAL(10) NOT NULL	Object ID - This value is relies upon the Object Type. The Object ID will either be the Catalog Item ID or the Learning Objective ID. Prompt Table: %EDITTABLE
6	LM_ORDER	Number(4,0)	SMALLINT NOT NULL	Order of Completion
7	LM_HIST_CREDIT	Character(1)	VARCHAR2(1) NOT NULL	Allow Historical Credit Y/N Table Edit Default Value: N
8	LM_REQ	Character(1)	VARCHAR2(1) NOT NULL	Item Required Y/N Table Edit Default Value: N
9	LM_HISTCREDIT_DAYS	Number(5,0)	INTEGER NOT NULL	Historical Credit Days
10	LM_ALLOW_WAIVER	Character(1)	VARCHAR2(1) NOT NULL	Allow Waiver Credit is a flag to determine whether learners can get ad-hoc credit for any items in a program. Y/N Table Edit Default Value: N
11	LM_AUDIENCE	Character(2)	VARCHAR2(2) NOT NULL	Audience 10=Learner 20=Instructor 30=Manager Default Value: 10
12	LM_WAITING_PD	Number(3,0)	SMALLINT NOT NULL	Waiting Period
13	LM_ALLOW_EQUIV	Character(1)	VARCHAR2(1) NOT NULL	Allow Equivalency Y/N Table Edit Default Value: N
14	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
15	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
16	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
17	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid