| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 LM_LE_ID |
Number(10,0) |
DECIMAL(10) NOT NULL |
Learning Environment ID - System Generated number
Default Value: 0
|
| 2 |
LM_LRN_PD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Learning Period Days -- Number of days student can access online content.
|
| 3 |
LM_WRN_PD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Warning Period Days
|
| 4 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 5 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 6 |
LM_NFRC_PRQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce Prerequisites
Y/N Table Edit
Default Value: N
|
| 7 |
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
|
| 8 |
LM_LST_DROP_START |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Drop Date = Activity Start Date
Y/N Table Edit
Default Value: N
|
| 9 |
LM_LST_DROP_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Last Drop Days
|
| 10 |
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
Default Value: 1
|
| 11 |
LM_LST_ENRL_START |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Enrollment Date = Activity Start Date
Y/N Table Edit
Default Value: N
|
| 12 |
LM_LST_ENRL_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Last Enroll Days
|
| 13 |
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
|
| 14 |
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
|
| 15 |
LM_OVERBOOK_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Overbook Percent
|
| 16 |
TIMEZONE |
Character(9) |
VARCHAR2(9) NOT NULL |
Time Zone
Prompt Table:
PSTIMEZONE
|
| 17 |
LM_START_TM |
Time(15) |
TIMESTAMP |
Start Time
|
| 18 |
LM_END_TM |
Time(15) |
TIMESTAMP |
End Time
|
| 19 |
LM_ENABLE_CASH |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Cash ?
Y/N Table Edit
Default Value: N
|
| 20 |
LM_ENABLE_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Check?
Y/N Table Edit
Default Value: N
|
| 21 |
LM_ENABLE_CHGBK |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Chargebacks?
Y/N Table Edit
Default Value: N
|
| 22 |
LM_ENABLE_CRCARD |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Credit Card?
Y/N Table Edit
Default Value: N
|
| 23 |
LM_ENABLE_PO |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Purchase Order?
Y/N Table Edit
Default Value: N
|
| 24 |
LM_ENABLE_TU |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Training Units?
Y/N Table Edit
Default Value: N
|
| 25 |
LM_ALLOW_CMPL_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Completion from History
Y/N Table Edit
Default Value: Y
|
| 26 |
LM_LAUNCHABLE_HIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Launchable from History
Y/N Table Edit
Default Value: Y
|
| 27 |
LM_WAIT_THRESHOLD |
Number(10,0) |
DECIMAL(10) NOT NULL |
Waitlist Threshold
|
| 28 |
LM_ENABLE_LRQ |
Character(1) |
VARCHAR2(1) NOT NULL |
New Field. Uppercase. Indicates whether learning requests are active (at various configuration levels).
Y/N Table Edit
|
| 29 |
LM_LRQ_THRESHOLD |
Number(10,0) |
DECIMAL(10) NOT NULL |
New field. Stores the threshold number of learning requests at which point an administrator should be notified of the pending requests.
|
| 30 |
LM_CONCUR_ENROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to Allow Concurrent enrollment or not.
Y/N Table Edit
|
| 31 |
LM_ALLOW_NEST_PRG |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Nested Programs
Y/N Table Edit
|
| 32 |
LM_ALOW_CASCD_EXPR |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Cascading Expirations
Y/N Table Edit
|
| 33 |
LM_REQ_ESIGN_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
eSignature
Y/N Table Edit
|
| 34 |
LM_DFLT_REQUESTOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Requestor
Y/N Table Edit
|
| 35 |
LM_ORGANIZER |
Character(1) |
VARCHAR2(1) NOT NULL |
Catalog Item Organizer
|
| 36 |
LM_ENABLE_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable French Features
Y/N Table Edit
Default Value: N
|
| 37 |
LM_DIF_RMNDR_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Days to wait before sending reminder for DIF requests pending approval
Default Value: 15
|
| 38 |
LM_DIF_FRA_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
DIF Flag
Y/N Table Edit
Default Value: N
|
| 39 |
LM_CERT_GRID |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Certification status
Y/N Table Edit
|
| 40 |
LM_OBJ_GRID |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Objectives Grid
Y/N Table Edit
|
| 41 |
LM_HRLY_COST |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Hourly Cost
|
| 42 |
LM_FLAT_COST |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Flat cost
|
| 43 |
LM_LST_WTLST_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Last waitlist days used to indicate the number of days before or days after the start date in which waitlisted learners may be automatically enrolled in an activity.
|
| 44 |
LM_LST_WTLST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Last waitlist type used to indicate how to derive the last date in which waitlisted learners may be automatically enrolled in an activity. Use days before or days after the start date to determine the last waitlisted enroll date.
1=Before the Start Date
2=After the Start Date
Default Value: 1
|
| 45 |
LM_CNTRCT_INTG |
Character(1) |
VARCHAR2(1) NOT NULL |
To enable Contract Integration with HCM
Y/N Table Edit
Default Value: N
|
| 46 |
LM_SKIP_PRG_RVW_PG |
Character(3) |
VARCHAR2(3) NOT NULL |
Suppress Enrollment Review Information Page?
N=None
R=Suppress Review Information
S=Suppress Review & Confirmation
Default Value: N
|
| 47 |
LM_ENRL_PLANNED |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Enroll in Planned status
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 48 |
LM_SKIP_CLS_RVW_PG |
Character(3) |
VARCHAR2(3) NOT NULL |
Suppress Enrollment Review Information Page?
N=None
R=Suppress Review Information
S=Suppress Review & Confirmation
Default Value: N
|
| 49 |
LM_ENRLMT_REG_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Option for allowing auto registration in programs on course enrollments.
AC=All Programs with Confirm
AP=All Programs
CC=Certifications with Confirm
CE=Certifications Only
CN=Curricula with Confirm
CU=Curricula Only
NO=None
Default Value: NO
|
| 50 |
LM_RNW_PD_DAYS |
Number(3,0) |
SMALLINT NOT NULL |
Renewal period
|
| 51 |
LM_HST_CRD_ALLOW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow historical credit
Y/N Table Edit
Default Value: N
|
| 52 |
LM_ALL_EMPL_INST |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Instance
Y/N Table Edit
Default Value: N
|
| 53 |
LM_HIST_CRD_PRD |
Number(3,0) |
SMALLINT NOT NULL |
Historical credit period days
|