LM_SRCH_ACT_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ACT_ID	Number(10,0)	DECIMAL(10) NOT NULL	Activity ID
2	LM_ACT_CD	Character(30)	VARCHAR2(30) NOT NULL	Activity Code
3	LM_ACT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Activity Status 1=Active 2=Inactive 3=Closed 4=Pending 5=Concluded
4	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item
5	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
6	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
7	LM_START_DT	Date(10)	DATE	Start Date
8	LM_END_DT	Date(10)	DATE	End Date
9	LM_DISP_DATES	Character(1)	VARCHAR2(1) NOT NULL	Use Display Dates
10	LM_DISP_START_DT	Date(10)	DATE	Display Start Date
11	LM_DISP_END_DT	Date(10)	DATE	Display End Date
12	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.
13	LM_MAX_ENRLMT	Number(10,0)	DECIMAL(10) NOT NULL	Maximum Enrollment - Maximum number of students that may be enrolled in an activity.
14	LM_NFRC_MAX_ENRLMT	Character(1)	VARCHAR2(1) NOT NULL	Enforce Maximum Enrollment - Enforces the amount indicated as the Maximum Enrollment for an activity. Y/N Table Edit Default Value: N
15	LM_ENRL_TOT	Number(6,0)	INTEGER NOT NULL	Enrollment Total
16	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. Y/N Table Edit Default Value: N
17	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.
18	LM_WTLST_TOT	Number(4,0)	SMALLINT NOT NULL	Stores the total number of learners currently on the waitlist
19	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_ACT_PRCSD_VW
20	LM_APRVL_REQ_EXT	Character(3)	VARCHAR2(3) NOT NULL	Enrollment Admin Approval Required for Non-Employees 10=None 40=Learning Admin 60=Payment Default Value: 10
21	LM_ENRLMT_ADMIN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Enrollment Administrator ID Prompt Table: LM_PERS_NAME_VW
22	LM_NFRC_PRQ	Character(1)	VARCHAR2(1) NOT NULL	Enforce Prerequisites Y/N Table Edit Default Value: N
23	LM_AUTO_ATND	Character(1)	VARCHAR2(1) NOT NULL	Auto Mark Attendance - Indicates Attendance will automatically be marked at the completion of the activity Y/N Table Edit Default Value: N
24	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.
25	LM_AUTO_ASGN_OBJV	Character(1)	VARCHAR2(1) NOT NULL	Auto Assign Objectives Y/N Table Edit Default Value: Y
26	LM_CEU	Number(8,2)	DECIMAL(7,2) NOT NULL	Continuing Education Units
27	LM_LST_ENRL_START	Character(1)	VARCHAR2(1) NOT NULL	Last Enrollment Date = Activity Start Date Y/N Table Edit Default Value: N
28	LM_LST_ENRL_DAYS	Number(3,0)	SMALLINT NOT NULL	Last Enroll Days
29	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 Default Value: 1
30	LM_LST_ENRL_DT	Date(10)	DATE	Last Enroll Date
31	LM_DURN_DAYS	Number(4,0)	SMALLINT NOT NULL	Length of Activity in Days
32	LM_DURN_HRS	Number(3,0)	SMALLINT NOT NULL	Duration - Hours
33	LM_DURN_MINS	Number(3,0)	SMALLINT NOT NULL	Duration - Minutes
34	LM_RESTRICT_TO_PRG	Character(1)	VARCHAR2(1) NOT NULL	Restrict to Programs
35	LM_INT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Price
36	LM_EXT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Price
37	LM_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Training Units - Price
38	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
39	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
40	LM_DM_LONG_NM	Character(200)	VARCHAR2(200) NOT NULL	Long Name - the long name of a Delivery Method Type
41	LM_DM_SHRT_NM	Character(10)	VARCHAR2(10) NOT NULL	Short Name - Short Name of a Delivery Method Type