LM_PRG_REL_VW

#	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	Effective Date Default Value: %date
3	LM_PRG_REL_ID	Number(10,0)	DECIMAL(10) NOT NULL	New Field to hold to hold the nested relationship Program ID. Clone of Program ID /** Bug #33233658 **/
4	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
5	LM_PRG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Program Status 10=Active 20=Inactive 30=Pending
6	LM_PRG_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Program Type CE=Certification CU=Curriculum
7	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.
8	LM_VERSION	Character(30)	VARCHAR2(30) NOT NULL	Program Version
9	LM_PRG_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Program Long Name
10	LM_PRG_SHORT_NM	Character(10)	VARCHAR2(10) NOT NULL	Program Short Name
11	LM_PRG_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Program Description
12	LM_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Owner ID
13	LM_COORD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Program Coordinator
14	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
15	LM_AUTO_ASGN_OBJV	Character(1)	VARCHAR2(1) NOT NULL	Auto Assign Objectives
16	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
17	LM_EXTRNL_INFO	Character(30)	VARCHAR2(30) NOT NULL	External Information - This field is populated by external user/vendor and is user defined.
18	LM_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Vendor ID
19	LM_VNDR_PRG_CD	Character(30)	VARCHAR2(30) NOT NULL	Vendor Program Code
20	LM_CEU_BASED	Character(1)	VARCHAR2(1) NOT NULL	CEU Based Completion
21	LM_CEU_TOT	Number(13,2)	DECIMAL(12,2) NOT NULL	Total Continuing Education Units
22	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
23	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.
24	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.
25	LM_EXPR_DT	Date(10)	DATE	Certification Expiration Date is a fixed, preset date when the certification will expire.
26	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.
27	LM_GRACE_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	This is the number of days after expiration, that the actual expiration takes effect.
28	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.
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
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_PRG_ABST	Long Character	CLOB	Program Abstract
40	LM_SPL_APPROVER	Number(15,0)	DECIMAL(15) NOT NULL	Special Approver
41	LM_REQ_ESIGN_UPD	Character(1)	VARCHAR2(1) NOT NULL	eSignature
42	LM_APRVL_REQ_EXT	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Admin Approval Required for Non-Employees 10=None 40=Learning Admin 60=Payment
43	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
44	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.
45	LM_CERT_CASCD_EXPR	Character(1)	VARCHAR2(1) NOT NULL	Cascade Expire Certification
46	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.
47	LM_PRG_AUTO_ENROLL	Character(1)	VARCHAR2(1) NOT NULL	Program Auto Enrollment N=No Y=Yes