|
SELECT DMTHD.LM_DMTHD_TYPE_ID , DMTHD.LM_CI_ID , DMTHD.LM_DMTHD_ID , DMTHD.EFFDT , DMTHD.LM_END_EFFDT , DMTHD.LM_LANG_CD1 , DMTHD.LM_DM_STATUS , DMTHD.LM_INSTR_ID , DMTHD.LM_ENRLMT_ADMIN_ID , DMTHD.LM_COST , DMTHD.LM_NFRC_MAX_ENRLMT , DMTHD.LM_REG_MTHD , DMTHD.LM_AUTO_CMPL_DURN , DMTHD.LM_AVG_FILL_RT , DMTHD.LM_OFRNG_FREQ , DMTHD.LM_MIN_ENRLMT , DMTHD.LM_MAX_ENRLMT , DMTHD.LM_AUTO_ATND , DMTHD.LM_OWNER_ID , DMTHD.LM_AUTO_OBJV , DMTHD.LM_LRN_PD_DAYS , DMTHD.LM_WRN_PD_DAYS , DMTHD.LM_ENABLE_WTLST , DMTHD.LM_WTLST_CAP , DMTHD.LM_TECH_REQ ,%subrec(LM_PRICING_SBR,DMTHD) , DMTHD.LM_ROW_MAINT_DTTM , DMTHD.LM_FLAT_COST , DMTHD.LM_HRLY_COST FROM PS_LM_DMTHD_TBL DMTHD
|
| # |
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:
%EDITTABLE
|
| 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 |
EFFDT |
Date(10) |
DATE NOT NULL |
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 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
Default Value: ENG
|
| 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_INT_PRICE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Internal Learner - Price
|
| 27 |
LM_EXT_PRICE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
External Learner - Price
|
| 28 |
LM_TRNG_UT |
Number(14,3) |
DECIMAL(13,3) NOT NULL |
Training Units - Price
|
| 29 |
LM_INT_DP_PRICE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Internal Learner - Drop Price
|
| 30 |
LM_EXT_DP_PRICE |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
External Learner - Drop Price
|
| 31 |
LM_DP_TRNG_UT |
Number(14,3) |
DECIMAL(13,3) NOT NULL |
Drop Training Units
|
| 32 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 33 |
LM_ROW_MAINT_DTTM |
DateTime(26) |
TIMESTAMP |
Row Maintainted DateTime
|
| 34 |
LM_FLAT_COST |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Flat cost
|
| 35 |
LM_HRLY_COST |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Hourly Cost
|