LM_PRG

#	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: %date
3	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
4	LM_PRG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Program Status 10=Active 20=Inactive 30=Pending Default Value: 30
5	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
6	LM_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Program Code is a user defined field. This field allows duplicates and is not part of the primary key structure.
7	LM_VERSION	Character(30)	VARCHAR2(30) NOT NULL	Program Version
8	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
9	LM_PRG_SHORT_NM	Character(10)	VARCHAR2(10) NOT NULL	Program Short Name
10	LM_PRG_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Program Description
11	LM_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Owner ID Prompt Table: LM_OWNERID_VW
12	LM_COORD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Program Coordinator Prompt Table: LM_INSTR_SRCH
13	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
14	LM_AUTO_ASGN_OBJV	Character(1)	VARCHAR2(1) NOT NULL	Auto Assign Objectives Y/N Table Edit Default Value: N
15	LM_EXTRNL_ID	Number(10,0)	DECIMAL(10) NOT NULL	External ID - This field comes in from an external vendor and/or user and is user defined
16	LM_EXTRNL_INFO	Character(30)	VARCHAR2(30) NOT NULL	External Information - This field is populated by external user/vendor and is user defined.
17	LM_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Vendor ID Prompt Table: LM_VENDORID_VW
18	LM_VNDR_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Vendor Program Code
19	LM_CEU_BASED	Character(1)	VARCHAR2(1) NOT NULL	CEU Based Completion Y/N Table Edit Default Value: N
20	LM_CEU_TOT	Number(13,2)	DECIMAL(12,2) NOT NULL	Total Continuing Education Units
21	LM_CMPL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Completion Type is a flag that determines whether completion period is calculated from a registration date or from the date of the first item completion. 10=Fixed 20=Delayed Default Value: 10
22	LM_CMPL_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Completion Period is the period used to determine the target completion date for the learner. Default Value: 0
23	LM_CMPL_WRN_DAYS	Number(3,0)	SMALLINT NOT NULL	The completion warning period is the number of days in advance of the target completion date, when an email notification will be sent to warn a learner to complete the requirements before time is up.
24	LM_EXPR_DT	Date(10)	DATE	Certification Expiration Date is a fixed, preset date when the certification will expire.
25	LM_EXPR_DAYS	Number(5,0)	INTEGER NOT NULL	This is a validity period used for notifying the learner. This is what is shown to the learner as the number of days that the Certificate is valid for.
26	LM_GRACE_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	This is the number of days after expiration, that the actual expiration takes effect.
27	LM_EXPR_WRN_DAYS	Number(3,0)	SMALLINT NOT NULL	The expiration warning period is the number of days before certification or before re-certification expiration, in which a reminder notification is sent to the learner.
28	LM_RECERT_WRN_DAYS	Number(3,0)	SMALLINT NOT NULL	The recertification warning period is the number of days before re-certification expiration, in which a reminder notification is sent to the learner.
29	LM_RECERT_PD_DAYS	Number(5,0)	INTEGER NOT NULL	The re-certification period is the number of days after certification actually expires, within which the learner must complete the official re-certification path/program to reinstate certification status.
30	LM_CERT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Certification ID Prompt Table: LM_RECERT_VW
31	LM_TARGET_AUD	Character(254)	VARCHAR2(254) NOT NULL	Target Audience
32	LM_INT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Price
33	LM_EXT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Price
34	LM_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Training Units - Price
35	LM_INT_DP_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Drop Price
36	LM_EXT_DP_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Drop Price
37	LM_DP_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Drop Training Units
38	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
39	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
40	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
41	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
42	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
43	LM_PRG_ABST	Long Character	CLOB	Program Abstract
44	LM_REQ_ESIGN_UPD	Character(1)	VARCHAR2(1) NOT NULL	eSignature Y/N Table Edit Default Value: N
45	LM_SPL_APPROVER	Number(15,0)	DECIMAL(15) NOT NULL	Special Approver Prompt Table: LM_PER_NAME_VW
46	LM_CERT_CASCD_EXPR	Character(1)	VARCHAR2(1) NOT NULL	Cascade Expire Certification Y/N Table Edit Default Value: N
47	LM_APRVL_REQ_EXT	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Admin Approval Required for Non-Employees 10=None 40=Learning Admin 60=Payment
48	LM_APRVL_TYPE_REQ	Character(30)	VARCHAR2(30) NOT NULL	Specifies the approval type required to take a given course, refer to the translate values 10=None 20=Standard Default Value: NONE Prompt Table: LM_PRG_PRCSD_VW
49	LM_PAR_BSE_ON_CHD	Character(1)	VARCHAR2(1) NOT NULL	Use on Install Defaults page to set if status of parent is based on child requirements. Y/N Table Edit Default Value: N
50	LM_PRG_AUTO_ENROLL	Character(1)	VARCHAR2(1) NOT NULL	Program Auto Enrollment N=No Y=Yes Y/N Table Edit Default Value: N
51	LM_ENRL_AUTO_REG	Character(1)	VARCHAR2(1) NOT NULL	Course Auto Registration N=No Y=Yes Default Value: N
52	LM_RTI_UPD_DTTM	DateTime(26)	TIMESTAMP	RTI Trigger Date time