LM_IN_DFLT_TBL(SQL Table) |
Index Back |
|---|---|
Install Default TableAll the defaults for install |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_LRN_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | Learning Period Days -- Number of days student can access online content. |
| 2 | LM_WRN_PD_DAYS | Number(3,0) | SMALLINT NOT NULL | Warning Period Days |
| 3 | LM_NFRC_PRQ | Character(1) | VARCHAR2(1) NOT NULL |
Enforce Prerequisites
Y/N Table Edit Default Value: N |
| 4 | 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 |
| 5 | LM_NEW_USER_LE | Number(10,0) | DECIMAL(10) NOT NULL |
Default Learning Environment for new user
Prompt Table: LM_LE_VW |
| 6 | LM_LST_DROP_DAYS | Number(3,0) | SMALLINT NOT NULL | Last Drop Days |
| 7 | LM_LST_ENRL_DAYS | Number(3,0) | SMALLINT NOT NULL | Last Enroll Days |
| 8 | 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 |
| 9 | LM_OVERBOOK_PCT | Number(3,0) | SMALLINT NOT NULL | Overbook Percent |
| 10 | LM_COMPETENCY_PCT | Number(3,0) | SMALLINT NOT NULL | Competency Proficiency Percentile. Represents a cutoff point based on a Learner's competency proficiency above which the competency should not be loaded into ELM because it represents a strength, not a need for learning. |
| 11 | LM_ILT_ATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
This is one of the labels defined in the Attendance Schemes. This default is used by the Auto Attendance Batch job while marking Enrollments as Attended for Concluded Activities.Attendance Schemes are setup at the System Level. A user can customize these labels against various Attendance Statuses.
Prompt Table: LM_I_ATT_SCH_VW |
| 12 | LM_WBT_ATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
This is one of the labels defined in the Attendance Schemes. This default is used by the Auto Attendance Batch job while marking Enrollments as Attended for those Enrollments whose target date has passed or the WBT is Concluded (whichever comes earlier).Attendance Schemes are setup at the System Level. A user can customize these labels against various Attendance Statuses.
Prompt Table: LM_W_ATT_SCH_VW |
| 13 | LM_WBT_NATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
This is one of the labels defined in the Attendance Schemes. This default is used by the Auto Attendance Batch job while marking Enrollments as Not Attended for those Enrollments whose target date has passed or the WBT is Concluded (whichever comes earlier).Attendance Schemes are setup at the System Level. A user can customize these labels against various Attendance Statuses.
Prompt Table: LM_NATT_SCH_VW |
| 14 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 15 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 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_MGR_ACCESS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Manager Access Type
2=By Supervisor ID 3=By Department Manager ID 4=By Reports To Position 5=By Supervisor or Reports To |
| 20 | LM_CNTCT_US | Character(254) | VARCHAR2(254) NOT NULL | Contact Us Email Address |
| 21 | LM_ENABLE_CASH | Character(1) | VARCHAR2(1) NOT NULL |
Enable Cash ?
Y/N Table Edit Default Value: N |
| 22 | LM_ENABLE_CHECK | Character(1) | VARCHAR2(1) NOT NULL |
Enable Check?
Y/N Table Edit Default Value: N |
| 23 | LM_ENABLE_CHGBK | Character(1) | VARCHAR2(1) NOT NULL |
Enable Chargebacks?
Y/N Table Edit Default Value: N |
| 24 | LM_ENABLE_CRCARD | Character(1) | VARCHAR2(1) NOT NULL |
Enable Credit Card?
Y/N Table Edit Default Value: N |
| 25 | LM_ENABLE_PO | Character(1) | VARCHAR2(1) NOT NULL |
Enable Purchase Order?
Y/N Table Edit Default Value: N |
| 26 | LM_ENABLE_TU | Character(1) | VARCHAR2(1) NOT NULL |
Enable Training Units?
Y/N Table Edit Default Value: N |
| 27 | LM_PO_CHARTFLD_TYP | Character(18) | VARCHAR2(18) NOT NULL |
ChartField Type...One of 16 ChartFields.
Prompt Table: LM_CF_NAMES_VW |
| 28 | LM_TU_CHARTFLD_TYP | Character(18) | VARCHAR2(18) NOT NULL |
ChartField Type...One of 16 ChartFields.
Prompt Table: LM_CF_NAMES_VW |
| 29 | LM_CR_CARD_MANUAL | Character(1) | VARCHAR2(1) NOT NULL |
Manual Credit Card Processing set up option.
Y/N Table Edit Default Value: N |
| 30 | LM_ENRL_GRP_MAX | Number(3,0) | SMALLINT NOT NULL | Used for Group Enrollments - LM_IN_DFLT_TBL |
| 31 | LM_ENR_UPD_ALLOW | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Updates Allowed
Y/N Table Edit Default Value: Y |
| 32 | LM_COMBO_EDIT | Character(4) | VARCHAR2(4) NOT NULL |
Combination edit
NONE=No Combo Edit SYNC=Synchronous Edit Default Value: NONE |
| 33 | LM_ASG_NATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
This is one of the labels defined in the Attendance Schemes. This default is used by the Auto Attendance Batch job while marking Enrollments as Not Attended for those Enrollments. A user can customize these labels against various Attendance Statuses.
Prompt Table: LM_NATT_SCH_VW |
| 34 | LM_LWC_NATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
This is one of the labels defined in the Attendance Schemes. This default is used by the Auto Attendance Batch job while marking Enrollments as Not Attended for those Enrollments. A user can customize these labels against various Attendance Statuses.
Prompt Table: LM_NATT_SCH_VW |
| 35 | LM_SRY_NATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
This is one of the labels defined in the Attendance Schemes. This default is used by the Auto Attendance Batch job while marking Enrollments as Not Attended for those Enrollments. A user can customize these labels against various Attendance Statuses.
Prompt Table: LM_NATT_SCH_VW |
| 36 | LM_TES_NATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
This is one of the labels defined in the Attendance Schemes. This default is used by the Auto Attendance Batch job while marking Enrollments as Not Attended for those Enrollments. A user can customize these labels against various Attendance Statuses.
Prompt Table: LM_NATT_SCH_VW |
| 37 | LM_ASG_ATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
Assignment Attended Scheme
Prompt Table: LM_W_ATT_SCH_VW |
| 38 | LM_LWC_ATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
LWC Attended Scheme
Prompt Table: LM_W_ATT_SCH_VW |
| 39 | LM_SRY_ATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
Survey Attended Status
Prompt Table: LM_W_ATT_SCH_VW |
| 40 | LM_TES_ATT_SCHEME | Number(10,0) | DECIMAL(10) NOT NULL |
Test Attended Scheme
Prompt Table: LM_W_ATT_SCH_VW |
| 41 | LM_LST_DROP_START | Character(1) | VARCHAR2(1) NOT NULL |
Last Drop Date = Activity Start Date
Y/N Table Edit Default Value: N |
| 42 | 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 |
| 43 | LM_LST_ENRL_START | Character(1) | VARCHAR2(1) NOT NULL |
Last Enrollment Date = Activity Start Date
Y/N Table Edit Default Value: N |
| 44 | 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 |
| 45 | LM_ALLOW_CMPL_HIST | Character(1) | VARCHAR2(1) NOT NULL |
Allow Completion from History
Y/N Table Edit Default Value: Y |
| 46 | LM_LAUNCHABLE_HIST | Character(1) | VARCHAR2(1) NOT NULL |
Launchable from History
Y/N Table Edit Default Value: Y |
| 47 | LM_ASG_ENR_DFLT | Number(10,0) | DECIMAL(10) NOT NULL |
Initial Attendance
Prompt Table: LM_U_ATT_SCH_VW |
| 48 | LM_ILT_ENR_DFLT | Number(10,0) | DECIMAL(10) NOT NULL |
Initial Attendance
Prompt Table: LM_U_ATT_SCH_VW |
| 49 | LM_LWC_ENR_DFLT | Number(10,0) | DECIMAL(10) NOT NULL |
Initial Attendance
Prompt Table: LM_U_ATT_SCH_VW |
| 50 | LM_SRY_ENR_DFLT | Number(10,0) | DECIMAL(10) NOT NULL |
Initial Attendance
Prompt Table: LM_U_ATT_SCH_VW |
| 51 | LM_TES_ENR_DFLT | Number(10,0) | DECIMAL(10) NOT NULL |
Initial Attendance
Prompt Table: LM_U_ATT_SCH_VW |
| 52 | LM_WBT_ENR_DFLT | Number(10,0) | DECIMAL(10) NOT NULL |
Initial Attendance
Prompt Table: LM_U_ATT_SCH_VW |
| 53 | LM_OBJV_GRP_MAX | Number(3,0) | SMALLINT NOT NULL | Used for Group Enrollments - LM_IN_DFLT_TBL |
| 54 | LM_CRSE_CD_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Options for allowing or restricting duplicate course code in Catalog Item.
A=Allowed L=Restricted by LE R=Restricted Default Value: R |
| 55 | LM_ACT_CD_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Option for allowing or restricting duplicate Activity Code in Activity.
A=Allowed L=Restricted by LE R=Restricted Default Value: A |
| 56 | LM_PRG_CD_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Option for allowing or restricting duplicate Program Code in Curricullum and/or Certification.
A=Allowed L=Restricted by LE R=Restricted Default Value: A |
| 57 | LM_DEF_ORG_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Default Department ID
Prompt Table: LM_DEPT_SRCH_VW |
| 58 | LM_WAIT_THRESHOLD | Number(10,0) | DECIMAL(10) NOT NULL | Waitlist Threshold |
| 59 | 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 |
| 60 | 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. |
| 61 | LM_CONCUR_ENROLL | Character(1) | VARCHAR2(1) NOT NULL |
Flag to Allow Concurrent enrollment or not.
Y/N Table Edit |
| 62 | LM_ALLOW_NEST_PRG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Nested Programs
Y/N Table Edit |
| 63 | LM_PAR_BSE_ON_CHD | Character(1) | VARCHAR2(1) NOT NULL |
Use on Install Defaults page to set if status of parent is based on child requirements.
Y/N Table Edit Default Value: N |
| 64 | LM_ALOW_CASCD_EXPR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Cascading Expirations
Y/N Table Edit |
| 65 | LM_CERT_AUD_STSCHG | Character(1) | VARCHAR2(1) NOT NULL |
Audit Certification Status Cha
Y/N Table Edit |
| 66 | LM_REQ_ESIGN_UPD | Character(1) | VARCHAR2(1) NOT NULL |
eSignature
Y/N Table Edit |
| 67 | LM_DFLT_REQUESTOR | Character(1) | VARCHAR2(1) NOT NULL |
Default Requestor
Y/N Table Edit |
| 68 | LM_ENBLE_ACT_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Enable Activity enrollment approvals
Y/N Table Edit |
| 69 | LM_ENBLE_ADH_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Enable supplemental learning approvals
Y/N Table Edit |
| 70 | LM_ENBLE_REG_APRVL | Character(1) | VARCHAR2(1) NOT NULL |
Enable program registration approvals
Y/N Table Edit |
| 71 | LM_CERT_GRID | Character(1) | VARCHAR2(1) NOT NULL |
Display Certification status
Y/N Table Edit |
| 72 | LM_OBJ_GRID | Character(1) | VARCHAR2(1) NOT NULL |
Display Objectives Grid
Y/N Table Edit |
| 73 | LM_PRMPT_DROP_VAL | Number(3,0) | SMALLINT NOT NULL | Drop Down Value Count |
| 74 | LM_HRLY_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Hourly Cost |
| 75 | LM_FLAT_COST | Number(19,3) | DECIMAL(18,3) NOT NULL | Flat cost |
| 76 | LM_CAL_AUTO_MARK | Character(1) | VARCHAR2(1) NOT NULL |
Auto Mark Calendar
Y/N Table Edit Default Value: Y |
| 77 | LM_SRCH_ROW_MAX | Number(10,0) | DECIMAL(10) NOT NULL |
Search Row Maximum
Default Value: 300 |
| 78 | LM_IN_ADD_LC | Character(1) | VARCHAR2(1) NOT NULL |
If set, indicates that Learning Components may be added to activities with enrolled learners. Learning components may be added to activities that have no learners in completed enrollment status.
Default Value: N |
| 79 | LM_MAX_ROWS_SCROLL | Number(5,0) | INTEGER NOT NULL |
Maximum Rows Displayed
Default Value: 5 |
| 80 | LM_POP_LRNG_ROWS | Number(5,0) | INTEGER NOT NULL |
Holds a number usually used to determine the number of rows to displayed in tables or grids.
Default Value: 5 |
| 81 | LM_NEW_LRN_ROWS | Number(2,0) | SMALLINT NOT NULL |
Holds a number usually used to determine the number of rows to displayed in tables or grids.
Default Value: 5 |
| 82 | LM_MAX_ROWS | Number(5,0) | INTEGER NOT NULL |
Maximum Rows Displayed
Default Value: 5 |
| 83 | LM_RTG_RT_REVW_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Ratings and Reviews
N=None R=Ratings Only V=Ratings and Reviews Default Value: V |
| 84 | LM_RTG_FLAG_COUNT | Number(10,0) | DECIMAL(10) NOT NULL |
Flag(s)
Default Value: 1 |
| 85 | LM_RTG_CD_LEARNING | Character(30) | VARCHAR2(30) NOT NULL | Store the Ratings Code for Activity |
| 86 | LM_MAX_ROWS_RETRVD | Number(5,0) | INTEGER NOT NULL |
Install Defaults for HR Dashboard Learning Pagelets
Default Value: 300 |
| 87 | LM_LPLN_WARNING | Number(5,0) | INTEGER NOT NULL |
Install Defaults
Default Value: 30 |
| 88 | LM_OBJ_WARNING | Number(5,0) | INTEGER NOT NULL |
Install Defaults
Default Value: 30 |
| 89 | LM_CCI_MERCHANT | Character(16) | VARCHAR2(16) NOT NULL |
Credit Card Merchant
Prompt Table: EOEC_CCI_INSTAL |
| 90 | LM_VIEW_CAL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Display View Calendar Link
Y/N Table Edit Default Value: Y |
| 91 | LM_PRG_ENRL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Option for allowing or restricting Auto Enrollment for various Program types (Certifications/Curriculum).
A=All Program Types C=Certifications Only N=None R=Curriculum Only Default Value: N |
| 92 | LM_SCHED_ENRLMT_FL | Character(1) | VARCHAR2(1) NOT NULL | Allow Schedule Enrollment Setup Option. Used in LM_IN_DFLT_ENRLMT page |
| 93 | LM_ADHC_GRP_ENROLL | Character(1) | VARCHAR2(1) NOT NULL |
Supplemental Group Enrollment
Y/N Table Edit Default Value: N |
| 94 | LM_MULTI_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Multiple Selection
Y/N Table Edit Default Value: N |
| 95 | LM_CLNDR_INTG | Character(1) | VARCHAR2(1) NOT NULL |
To select Calander Integration type
F=File I=Outlook N=None Default Value: N |
| 96 | LM_AUTO_ENRLMT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Auto enrollment due to HCM status or job changes |
| 97 | LM_DISP_PHOTO_SS | Character(1) | VARCHAR2(1) NOT NULL |
Display Photo on Self Service
Y/N Table Edit Default Value: Y |
| 98 | LM_SYNC_PHOTO_HR | Character(1) | VARCHAR2(1) NOT NULL |
Sync Photo from HR
Y/N Table Edit Default Value: N |
| 99 | LM_RSTCT_VW_LRN_LE | Character(1) | VARCHAR2(1) NOT NULL |
If set, indicates that the 'View All Learning' is restricted by the Current Learning Environment of the Administrator.
Default Value: N |
| 100 | LM_MGR_GRP_MAX | Number(3,0) | SMALLINT NOT NULL |
Used for Group Enrollments - LM_IN_DFLT_TBL
Default Value: 10 |
| 101 | LM_EVAL_CMP_REG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Nested Programs
Y/N Table Edit Default Value: N |
| 102 | LM_ALLOW_EMPTY_POS | Character(1) | VARCHAR2(1) NOT NULL |
Checkbox for Allow Empty Positions in Install deafaults page
Y/N Table Edit Default Value: N |
| 103 | LM_USE_LPLN | Character(1) | VARCHAR2(1) NOT NULL |
checkbox for 'Use Learning Plans'
Y/N Table Edit Default Value: Y |
| 104 | LM_LRNG_DUE_IN | Character(1) | VARCHAR2(1) NOT NULL |
Field created for Fluid Defaults page under Install Defaults.
M=Month W=Week Default Value: W |
| 105 | LM_FROM_DT | Date(10) | DATE | From Date |
| 106 | LM_TO_DT | Date(10) | DATE | To Date |
| 107 | LM_FILE_SIZE | Number(12,0) | DECIMAL(12) NOT NULL | File size limit |
| 108 | LM_KIB_DATA_DUR | Character(2) | VARCHAR2(2) NOT NULL |
Enrollment and registration duration to be considered for indexing data for Insights dashboard
1=1 Year 2=2 Years 3=3 Years 4=4 Years 5=5 Years Default Value: 1 |
| 109 | LM_ALLOW_DROP | Character(1) | VARCHAR2(1) NOT NULL |
Allow Managers To Drop
N=No Y=Yes Default Value: N |
| 110 | NOTIF_DFLT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Specify if email address from User Profile or Learner Personal Information should be used.
H=Learner Personal Information P=User Profile Default Value: P |
| 111 | LM_CERT_STTS_RSN | Character(1) | VARCHAR2(1) NOT NULL |
Display Status Reason
Y/N Table Edit Default Value: N |