LM_CT_DM_VW (SQL View)	Index Back
Delivery Method Table Allows users to define specific learning activites based on the method of learning.

LM_CT_DM_VW

(SQL View)

Delivery Method Table

Allows users to define specific learning activites based on the method of learning.

SELECT LM_DMTHD_TYPE_ID ,LM_CI_ID ,LM_DMTHD_ID ,EFFDT ,LM_END_EFFDT ,LM_LANG_CD1 ,LM_DM_STATUS ,LM_INSTR_ID ,LM_ENRLMT_ADMIN_ID ,LM_COST ,LM_NFRC_MAX_ENRLMT ,LM_REG_MTHD ,LM_AUTO_CMPL_DURN ,LM_AVG_FILL_RT ,LM_OFRNG_FREQ ,LM_MIN_ENRLMT ,LM_MAX_ENRLMT ,LM_AUTO_ATND ,LM_OWNER_ID ,LM_AUTO_OBJV ,LM_LRN_PD_DAYS ,LM_WRN_PD_DAYS ,LM_ENABLE_WTLST ,LM_WTLST_CAP ,LM_TECH_REQ ,LM_ALLOW_CMPL_HIST ,LM_LAUNCHABLE_HIST ,LM_DURN_DAYS ,LM_DURN_HRS ,LM_DURN_MINS ,LM_INT_PRICE ,LM_EXT_PRICE ,LM_TRNG_UT ,LM_INT_DP_PRICE ,LM_EXT_DP_PRICE , LM_DP_TRNG_UT , CURRENCY_CD , LM_ROW_ADDED_DTTM , LM_ROW_ADDED_OPRID , LM_ROW_MAINT_DTTM , LM_ROW_MAINT_OPRID , LM_WAIT_THRESHOLD , LM_FLAT_COST , LM_HRLY_COST FROM PS_LM_DMTHD_TBL

Related Language Record: LM_CT_DM_VW_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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
Prompt Table: LM_DMTH_TYP_LIS

2 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
Default Value: 0
Prompt Table: LM_CRSE_CODE_VW

3 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
Default Value: 0

4 LM_EFFDT Date(10) DATE Effective Date
Default Value: %date

5 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it

6 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code

7 LM_DM_STATUS Character(3) VARCHAR2(3) NOT NULL Status - Indicates whether a delivery method is active, inactive, or pending.
10=Active
20=Inactive
30=Pending
Default Value: 10

8 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID
Prompt Table: LM_INSTR_PT_VW

9 LM_ENRLMT_ADMIN_ID Number(15,0) DECIMAL(15) NOT NULL Enrollment Administrator ID
Prompt Table: LM_ENRL_ADMN_VW

10 LM_COST Number(19,3) DECIMAL(18,3) NOT NULL Cost

11 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

12 LM_REG_MTHD Character(3) VARCHAR2(3) NOT NULL Registration Method - Drop down list with values of Online or Offline registration.
10=On-line Registration
20=Off-line Registration
Default Value: 10

13 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.
Default Value: 0

14 LM_AVG_FILL_RT Number(10,0) DECIMAL(10) NOT NULL Average Fill Rate - Indicate in this field the average number of learners who participate in the activity.

15 LM_OFRNG_FREQ Character(3) VARCHAR2(3) NOT NULL Offering Frequency - Drop down list with values indicating the frequency that the activity is usually offered.
10=Annually
20=As Required
30=Half - Year
40=Monthly
50=Quarterly
60=Semester
70=Trimester

16 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.

17 LM_MAX_ENRLMT Number(10,0) DECIMAL(10) NOT NULL Maximum Enrollment - Maximum number of students that may be enrolled in an activity.

18 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

19 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID
Prompt Table: LM_OWNERID_VW

20 LM_AUTO_OBJV Character(1) VARCHAR2(1) NOT NULL Yes/No box that asks if the Objectives should be Automatically Assigned.
Y/N Table Edit
Default Value: N

21 LM_LRN_PD_DAYS Number(3,0) SMALLINT NOT NULL Learning Period Days -- Number of days student can access online content.

22 LM_WRN_PD_DAYS Number(3,0) SMALLINT NOT NULL Warning Period Days

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.
Y/N Table Edit

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_TECH_REQ Character(254) VARCHAR2(254) NOT NULL Technical Requirements

26 LM_ALLOW_CMPL_HIST Character(1) VARCHAR2(1) NOT NULL Allow Completion from History
Y/N Table Edit
Default Value: Y

27 LM_LAUNCHABLE_HIST Character(1) VARCHAR2(1) NOT NULL Launchable from History
Y/N Table Edit
Default Value: Y

28 LM_DURN_DAYS Number(4,0) SMALLINT NOT NULL Length of Activity in Days

29 LM_DURN_HRS Number(3,0) SMALLINT NOT NULL Duration - Hours

30 LM_DURN_MINS Number(3,0) SMALLINT NOT NULL Duration - Minutes

31 LM_INT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Price

32 LM_EXT_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Price

33 LM_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Training Units - Price

34 LM_INT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL Internal Learner - Drop Price

35 LM_EXT_DP_PRICE Number(19,3) DECIMAL(18,3) NOT NULL External Learner - Drop Price

36 LM_DP_TRNG_UT Number(14,3) DECIMAL(13,3) NOT NULL Drop Training Units

37 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Prompt Table: CURRENCY_CD_TBL

38 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added

39 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By

40 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime

41 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid

42 LM_WAIT_THRESHOLD Number(10,0) DECIMAL(10) NOT NULL Waitlist Threshold

43 LM_FLAT_COST Number(19,3) DECIMAL(18,3) NOT NULL Flat cost

44 LM_HRLY_COST Number(19,3) DECIMAL(18,3) NOT NULL Hourly Cost

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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 Prompt Table: LM_DMTH_TYP_LIS
2	LM_CI_ID	Number(10,0)	DECIMAL(10) NOT NULL	Catalog Item ID - System Generated ID Number associated with each Catalog Item Default Value: 0 Prompt Table: LM_CRSE_CODE_VW
3	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 Default Value: 0
4	LM_EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	LM_END_EFFDT	Date(10)	DATE	The end effective date, automatically maintained, there's a doc on how this works, so read it
6	LANG_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	LM_DM_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Status - Indicates whether a delivery method is active, inactive, or pending. 10=Active 20=Inactive 30=Pending Default Value: 10
8	LM_INSTR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Instructor ID Prompt Table: LM_INSTR_PT_VW
9	LM_ENRLMT_ADMIN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Enrollment Administrator ID Prompt Table: LM_ENRL_ADMN_VW
10	LM_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Cost
11	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
12	LM_REG_MTHD	Character(3)	VARCHAR2(3) NOT NULL	Registration Method - Drop down list with values of Online or Offline registration. 10=On-line Registration 20=Off-line Registration Default Value: 10
13	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. Default Value: 0
14	LM_AVG_FILL_RT	Number(10,0)	DECIMAL(10) NOT NULL	Average Fill Rate - Indicate in this field the average number of learners who participate in the activity.
15	LM_OFRNG_FREQ	Character(3)	VARCHAR2(3) NOT NULL	Offering Frequency - Drop down list with values indicating the frequency that the activity is usually offered. 10=Annually 20=As Required 30=Half - Year 40=Monthly 50=Quarterly 60=Semester 70=Trimester
16	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.
17	LM_MAX_ENRLMT	Number(10,0)	DECIMAL(10) NOT NULL	Maximum Enrollment - Maximum number of students that may be enrolled in an activity.
18	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
19	LM_OWNER_ID	Number(15,0)	DECIMAL(15) NOT NULL	Owner ID Prompt Table: LM_OWNERID_VW
20	LM_AUTO_OBJV	Character(1)	VARCHAR2(1) NOT NULL	Yes/No box that asks if the Objectives should be Automatically Assigned. Y/N Table Edit Default Value: N
21	LM_LRN_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Learning Period Days -- Number of days student can access online content.
22	LM_WRN_PD_DAYS	Number(3,0)	SMALLINT NOT NULL	Warning Period Days
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. Y/N Table Edit
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_TECH_REQ	Character(254)	VARCHAR2(254) NOT NULL	Technical Requirements
26	LM_ALLOW_CMPL_HIST	Character(1)	VARCHAR2(1) NOT NULL	Allow Completion from History Y/N Table Edit Default Value: Y
27	LM_LAUNCHABLE_HIST	Character(1)	VARCHAR2(1) NOT NULL	Launchable from History Y/N Table Edit Default Value: Y
28	LM_DURN_DAYS	Number(4,0)	SMALLINT NOT NULL	Length of Activity in Days
29	LM_DURN_HRS	Number(3,0)	SMALLINT NOT NULL	Duration - Hours
30	LM_DURN_MINS	Number(3,0)	SMALLINT NOT NULL	Duration - Minutes
31	LM_INT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Price
32	LM_EXT_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Price
33	LM_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Training Units - Price
34	LM_INT_DP_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	Internal Learner - Drop Price
35	LM_EXT_DP_PRICE	Number(19,3)	DECIMAL(18,3) NOT NULL	External Learner - Drop Price
36	LM_DP_TRNG_UT	Number(14,3)	DECIMAL(13,3) NOT NULL	Drop Training Units
37	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
38	LM_ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	Datetime Added
39	LM_ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Added By
40	LM_ROW_MAINT_DTTM	DateTime(26)	TIMESTAMP	Row Maintainted DateTime
41	LM_ROW_MAINT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Maintained Oprid
42	LM_WAIT_THRESHOLD	Number(10,0)	DECIMAL(10) NOT NULL	Waitlist Threshold
43	LM_FLAT_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Flat cost
44	LM_HRLY_COST	Number(19,3)	DECIMAL(18,3) NOT NULL	Hourly Cost