LM_ENR_FRA_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_LC_ID	Number(10,0)	DECIMAL(10) NOT NULL	Learning Component ID - Blended Learning
4	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code
5	LM_ACT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status 1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded
6	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
7	LM_CS_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - Describes the long name of an object
8	LM_CS_SHRT_NM	Character(10)	VARCHAR2(10) NOT NULL	Short Name - Describes the short name of an object
9	LM_CS_DESCR	Character(254)	VARCHAR2(254) NOT NULL	Description - Describes an object with further detail
10	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
11	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
12	LM_DM_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - the long name of a Delivery Method Type
13	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
14	LM_START_DT	Date(10)	DATE	Start Date
15	LM_END_DT	Date(10)	DATE	End Date
16	LM_DISP_DATES	Character(1)	VARCHAR2(1) NOT NULL	Use Display Dates
17	LM_DISP_START_DT	Date(10)	DATE	Display Start Date
18	LM_DISP_END_DT	Date(10)	DATE	Display End Date
19	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.
20	LM_MAX_ENRLMT	Number(10,0)	DECIMAL(10) NOT NULL	Maximum Enrollment - Maximum number of students that may be enrolled in an activity.
21	LM_NFRC_MAX_ENRLMT	Character(1)	VARCHAR2(1) NOT NULL	Enforce Maximum Enrollment - Enforces the amount indicated as the Maximum Enrollment for an activity.
22	LM_ENRL_TOT	Number(6,0)	INTEGER NOT NULL	Enrollment Total
23	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.
24	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.
25	LM_WTLST_TOT	Number(4,0)	SMALLINT NOT NULL	Stores the total number of learners currently on the waitlist
26	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
27	LM_APRVL_REQ_EXT	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Admin Approval Required for Non-Employees 10=None 40=Learning Admin 60=Payment
28	LM_ENRLMT_ADMIN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Enrollment Administrator ID
29	LM_NFRC_PRQ	Character(1)	VARCHAR2(1) NOT NULL	Enforce Prerequisites
30	LM_AUTO_ATND	Character(1)	VARCHAR2(1) NOT NULL	Auto Mark Attendance - Indicates Attendance will automatically be marked at the completion of the activity
31	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.
32	LM_AUTO_ASGN_OBJV	Character(1)	VARCHAR2(1) NOT NULL	Auto Assign Objectives
33	LM_CEU	Number(8,2)	DECIMAL(7,2) NOT NULL	Continuing Education Units
34	LM_LST_ENRL_START	Character(1)	VARCHAR2(1) NOT NULL	Last Enrollment Date = Activity Start Date
35	LM_LST_ENRL_DAYS	Number(3,0)	SMALLINT NOT NULL	Last Enroll Days
36	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
37	LM_LST_ENRL_DT	Date(10)	DATE	Last Enroll Date
38	LM_LST_DROP_START	Character(1)	VARCHAR2(1) NOT NULL	Last Drop Date = Activity Start Date
39	LM_LST_DROP_DAYS	Number(3,0)	SMALLINT NOT NULL	Last Drop Days
40	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
41	LM_LST_DROP_DT	Date(10)	DATE	Last Drop Date
42	LM_RMNDR_DAYS	Number(3,0)	SMALLINT NOT NULL	Reminder Days
43	LM_RMNDR_DT	Date(10)	DATE	Reminder Date
44	LM_RMNDR_ID	Character(30)	VARCHAR2(30) NOT NULL	Reminder ID
45	LM_ACT_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Activity Owner
46	LM_OVERBOOK_PCT	Number(3,0)	SMALLINT NOT NULL	Overbook Percent
47	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
48	LM_LRN_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Learning Period Days -- Number of days student can access online content.
49	LM_WRN_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Warning Period Days
50	LM_INSTR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Instructor ID
51	LM_NFRC_COMP_ORDR	Character(1)	VARCHAR2(1) NOT NULL	Enforce Component Order
52	LM_ACT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Activity Type BLND=Blended SCHD=Scheduled SELF=Self Paced
53	LM_ALLOW_CMPL_HIST	Character(1)	VARCHAR2(1) NOT NULL	Allow Completion from History
54	LM_LAUNCHABLE_HIST	Character(1)	VARCHAR2(1) NOT NULL	Launchable from History
55	LM_DURN_DAYS	Number(4,0)	SMALLINT NOT NULL	Length of Activity in Days
56	LM_DURN_HRS	Number(3,0)	SMALLINT NOT NULL	Duration - Hours
57	LM_DURN_MINS	Number(3,0)	SMALLINT NOT NULL	Duration - Minutes
58	LM_RESTRICT_TO_PRG	Character(1)	VARCHAR2(1) NOT NULL	Restrict to Programs
59	LM_RSRV_SEAT_MAX	Number(10,0)	DECIMAL(10) NOT NULL	Reserved Seats Max Allowed
60	LM_RSRV_SEAT_TOT	Number(10,0)	DECIMAL(10) NOT NULL	Reserved Seat Total
61	LM_CRSE_CODE	Character(30)	VARCHAR2(30) NOT NULL	Course Code - User defined Code
62	LM_INT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Price
63	LM_EXT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Price
64	LM_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Training Units - Price
65	LM_INT_DP_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Drop Price
66	LM_EXT_DP_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Drop Price
67	LM_DP_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Drop Training Units
68	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
69	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
70	LM_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	ELM Person ID
71	LM_TRAINING_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Training Class Default Value: 9 Prompt Table: LM_TRAIN_CLASS
72	LM_ACT_DIF_FLG	Character(1)	VARCHAR2(1) NOT NULL	DIF Enrollment Y/N Table Edit Default Value: N
73	LM_TRG_PLN_CTGY	Character(10)	VARCHAR2(10) NOT NULL	Training Plan Category
74	LM_PASS_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Passing Scheme Value ID
75	LM_ATT_VAL_ID	Number(10,0)	DECIMAL(10) NOT NULL	Attendance Scheme Value Id. This will identify the combination of User Label / Attendance uniquely
76	LM_LC_COMP_STTS	Character(4)	VARCHAR2(4) NOT NULL	Learning Component - Completion Status CANC=Dropped COMP=Completed INCO=Not Completed INPO=In-Progress NOAT=Not Attempted
77	LM_HRS_TRACK_STTS	Character(1)	VARCHAR2(1) NOT NULL	Hour Tracking Status 1=Pending Review from ELM Admin. 2=Approved by ELM Administrator 3=Pending Review from Payroll 4=Cancelled 5=Publish Error 6=Rejected by Payroll Admin 7=Finalized Default Value: 1
78	LM_CST_TRACK_STTS	Character(1)	VARCHAR2(1) NOT NULL	Student Cost Status 1=Ready to Sent to HR/TA 2=Sent to HR/TA successfully 3=Canceled 4=Publish Error 5=Processed by HR/TA 6=Processed by HR/TA with Errors 9=New Default Value: 9
79	LM_LC_DESCR	Long Character	CLOB	Learning Component Description
80	LM_LC_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Learning Component Long Name
81	LM_LC_SHRT_NM	Character(10)	VARCHAR2(10) NOT NULL	Learning Component Short Name
82	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field
83	LM_HR_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	EMPLID from the HR System