LM_ENRLMT_SRCH

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ENRLMT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Enrollment ID
2	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
3	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code
4	LM_ACT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status 1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded
5	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
6	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
7	LM_CS_SHRT_NM	Character(10)	VARCHAR2(10) NOT NULL	Short Name - Describes the short name of an object
8	LM_CS_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Description - Describes an object with further detail
9	LM_DMTHD_TYPE_ID	Number(10,0)	DECIMAL(10) NOT NULL	Delivery Method Type ID - This is a unique identifier for each delivery method type
10	LM_DMTHD_ID	Number(10,0)	DECIMAL(10) NOT NULL	Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method
11	LM_DM_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - the long name of a Delivery Method Type
12	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
13	LM_START_DT	Date(10)	DATE	Start Date
14	LM_END_DT	Date(10)	DATE	End Date
15	LM_DISP_DATES	Character(1)	VARCHAR2(1) NOT NULL	Use Display Dates
16	LM_DISP_START_DT	Date(10)	DATE	Display Start Date
17	LM_DISP_END_DT	Date(10)	DATE	Display End Date
18	LM_MIN_ENRLMT	Number(10,0)	DECIMAL(10) NOT NULL	Minimum Enrollment - Minimum number of students that are required to be in an activity in order for an activity to be held.
19	LM_MAX_ENRLMT	Number(10,0)	DECIMAL(10) NOT NULL	Maximum Enrollment - Maximum number of students that may be enrolled in an activity.
20	LM_NFRC_MAX_ENRLMT	Character(1)	VARCHAR2(1) NOT NULL	Enforce Maximum Enrollment - Enforces the amount indicated as the Maximum Enrollment for an activity.
21	LM_ENRL_TOT	Number(6,0)	INTEGER NOT NULL	Enrollment Total
22	LM_ENABLE_WTLST	Character(3)	VARCHAR2(3) NOT NULL	Enable Waitlist - A Yes/No field. Selecting the checkbox indicates that learners may be waitlisted for this activity.
23	LM_WTLST_CAP	Number(10,0)	DECIMAL(10) NOT NULL	Waitlist Capacity - Maximum number of students that may enroll and be placed on the waitlist.
24	LM_WTLST_TOT	Number(4,0)	SMALLINT NOT NULL	Stores the total number of learners currently on the waitlist
25	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
26	LM_APRVL_REQ_EXT	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Admin Approval Required for Non-Employees 10=None 40=Learning Admin 60=Payment
27	LM_ENRLMT_ADMIN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Enrollment Administrator ID
28	LM_NFRC_PRQ	Character(1)	VARCHAR2(1) NOT NULL	Enforce Prerequisites
29	LM_AUTO_ATND	Character(1)	VARCHAR2(1) NOT NULL	Auto Mark Attendance - Indicates Attendance will automatically be marked at the completion of the activity
30	LM_AUTO_CMPL_DURN	Number(3,0)	SMALLINT NOT NULL	Auto Completion Duration - Provides the number of days after the conclusion of an activity that triggers the Auto Mark Attendance process to run.
31	LM_AUTO_ASGN_OBJV	Character(1)	VARCHAR2(1) NOT NULL	Auto Assign Objectives
32	LM_CEU	Number(8,2)	DECIMAL(7,2) NOT NULL	Continuing Education Units
33	LM_LST_ENRL_START	Character(1)	VARCHAR2(1) NOT NULL	Last Enrollment Date = Activity Start Date
34	LM_LST_ENRL_DAYS	Number(3,0)	SMALLINT NOT NULL	Last Enroll Days
35	LM_LST_ENRL_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Last Enroll Type: Before or After the start date 1=Before the Start Date 2=After the Start Date
36	LM_LST_ENRL_DT	Date(10)	DATE	Last Enroll Date
37	LM_LST_DROP_START	Character(1)	VARCHAR2(1) NOT NULL	Last Drop Date = Activity Start Date
38	LM_LST_DROP_DAYS	Number(3,0)	SMALLINT NOT NULL	Last Drop Days
39	LM_LST_DROP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Last Drop Type: Before or After the start date 1=Before the Start Date 2=After the Enrollment Date
40	LM_LST_DROP_DT	Date(10)	DATE	Last Drop Date
41	LM_RMNDR_DAYS	Number(3,0)	SMALLINT NOT NULL	Reminder Days
42	LM_RMNDR_DT	Date(10)	DATE	Reminder Date
43	LM_RMNDR_ID	Character(30)	VARCHAR2(30) NOT NULL	Reminder ID
44	LM_ACT_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Activity Owner
45	LM_OVERBOOK_PCT	Number(3,0)	SMALLINT NOT NULL	Overbook Percent
46	LM_MIN_ENRL_DAYS	Number(3,0)	SMALLINT NOT NULL	Minimum Enrollment Days -- Days prior to the start date that the min enrollment should be met
47	LM_LRN_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Learning Period Days -- Number of days student can access online content.
48	LM_WRN_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Warning Period Days
49	LM_INSTR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Instructor ID
50	LM_NFRC_COMP_ORDR	Character(1)	VARCHAR2(1) NOT NULL	Enforce Component Order
51	LM_ACT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Activity Type BLND=Blended SCHD=Scheduled SELF=Self Paced
52	LM_ALLOW_CMPL_HIST	Character(1)	VARCHAR2(1) NOT NULL	Allow Completion from History
53	LM_LAUNCHABLE_HIST	Character(1)	VARCHAR2(1) NOT NULL	Launchable from History
54	LM_DURN_DAYS	Number(4,0)	SMALLINT NOT NULL	Length of Activity in Days
55	LM_DURN_HRS	Number(3,0)	SMALLINT NOT NULL	Duration - Hours
56	LM_DURN_MINS	Number(3,0)	SMALLINT NOT NULL	Duration - Minutes
57	LM_RESTRICT_TO_PRG	Character(1)	VARCHAR2(1) NOT NULL	Restrict to Programs
58	LM_RSRV_SEAT_MAX	Number(10,0)	DECIMAL(10) NOT NULL	Reserved Seats Max Allowed
59	LM_RSRV_SEAT_TOT	Number(10,0)	DECIMAL(10) NOT NULL	Reserved Seat Total
60	LM_CRSE_CODE	Character(30)	VARCHAR2(30) NOT NULL	Course Code - User defined Code
61	LM_INT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Price
62	LM_EXT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Price
63	LM_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Training Units - Price
64	LM_INT_DP_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Drop Price
65	LM_EXT_DP_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Drop Price
66	LM_DP_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Drop Training Units
67	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
68	LM_LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese
69	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
70	LM_TRAINING_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Training Class Default Value: 9 Prompt Table: LM_TRAIN_CLASS
71	LM_ACT_DIF_FLG	Character(1)	VARCHAR2(1) NOT NULL	DIF Enrollment Y/N Table Edit Default Value: N
72	LM_TRG_PLN_CTGY	Character(10)	VARCHAR2(10) NOT NULL	Training Plan Category
73	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
74	LM_HR_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	EMPLID from the HR System