1
Complete List of PeopleSoft ELM 9.1 Tables
Here is the complete list of PeopleSoft ELM 9.1 tables along with brief description.
| Recname |
| LM_ACCTG_LN – ELM Account Line |
| LM_ACMDTN_TBL – Accommodation Setup Table |
| LM_ACT – Activity Table |
| LM_ACT_ATCH – Activity Attachments |
| LM_ACT_ATCH_VW – Activity Attachment View |
| LM_ACT_CI_UI_VW – Activity CI UI View |
| LM_ACT_CI_VW – Activity CI View |
| LM_ACT_CI_VW3 – Activity CI View |
| LM_ACT_COST – Activity Cost Table |
| LM_ACT_LE – Activity LE Table |
| LM_ACT_LE_VW – Activity LE View |
| LM_ACT_MTRL – Activity Material Table |
| LM_ACT_NOTE – Activity Notes Table |
| LM_ACT_NOTES_VW – Activity Notes View |
| LM_ACT_ROUTES – Activity Routes |
| LM_ACT_SEC – Activity Security Table |
| LM_ADHC_CNTR – Adhoc ID counter table |
| LM_ADHC_EQV_TBL – Adhoc Equiv Learning Table |
| LM_ADHC_LE_TBL – Adhoc LE Table |
| LM_ADHC_LRN_TBL – Adhoc Learning Table |
| LM_ADHC_SEC_TBL – Adhoc Security Table |
| LM_ADHC_TBL – Adhoc Setup Table |
| LM_AICC_CRS – AICC |
| LM_ATTRIBS – Attributes of Learner |
| LM_ATT_ALL_VW – Attendance Scheme |
| LM_ATT_SCH – Attendance Scheme |
| LM_ATT_SCH_VAL – Attendance Scheme |
| LM_BO001_1_VW – General Ledger Report view 1 |
| LM_BO001_2_VW – General Ledger Report view 2 |
| LM_BO001_LG1_VW – General Ledger Report view 1 |
| LM_BO001_LG2_VW – General Ledger Report view 2 |
| LM_BO001_LG3_VW – For GL Detail report |
| LM_BO001_LG4_VW – General Ledger Report view 2 |
| LM_BO001_UN1_VW – General Ledger Report view 1 |
| LM_BO001_UN2_VW – General Ledger Report view 2 |
| LM_BO001_UN3_VW – For GL Detail report |
| LM_BO001_UN4_VW – General Ledger Report view 2 |
| LM_BO002_1_VW – Payment Update Report view 1 |
| LM_BO002_2_VW – Payment Update Report view 2 |
| LM_BO002_3_VW – Payment Update Report view 3 |
| LM_BO002_4_VW – Payment Update Report view 4 |
| LM_BO002_5_VW – Payment Update Report view 5 |
| LM_BO002_6_VW – Payment Update Report view 6 |
| LM_BO002_LG1_VW – Payment Update Report view 1 |
| LM_BO002_LG2_VW – Payment Update Report view 2 |
| LM_BO002_LG3_VW – Payment Update Report view 3 |
| LM_BO002_LG4_VW – Payment Update Report view 4 |
| LM_BO002_LG5_VW – Payment Update Report view 5 |
| LM_BO002_LG6_VW – Payment Update Report view 6 |
| LM_BO002_UN1_VW – Payment Update Report view 1 |
| LM_BO002_UN2_VW – Payment Update Report view 2 |
| LM_BO002_UN3_VW – Payment Update Report view 3 |
| LM_BO002_UN4_VW – Payment Update Report view 4 |
| LM_BO002_UN5_VW – Payment Update Report view 5 |
| LM_BO002_UN6_VW – Payment Update Report view 6 |
| LM_BO003_LG1_VW – For External Payment Report |
| LM_BO003_LG2_VW – For External Payment Report |
| LM_BO003_LG3_VW – For External Payment Report |
| LM_BO003_LG4_VW – For External Payment Report |
| LM_BO003_UN1_VW – For External Payment Report |
| LM_BO003_UN2_VW – For External Payment Report |
| LM_BO003_UN3_VW – For External Payment Report |
| LM_BO003_UN4_VW – For External Payment Report |
| LM_BO004_LG1_VW – For TU Usage |
| LM_BO004_LG2_VW – For TU Usage report |
| LM_BO004_UN1_VW – For TU Usage |
| LM_BO004_UN2_VW – For TU Usage report |
| LM_BO005_LG1_VW – For TU Expiration Report |
| LM_BO005_LG2_VW – For TU Expiration Report |
| LM_BO005_UN1_VW – For TU Expiration Report |
| LM_BO005_UN2_VW – For TU Expiration Report |
| LM_BO006_LG1_VW – For Payment Pending Report |
| LM_BO006_LG2_VW – For Payment Pending report |
| LM_BO006_UN1_VW – For Payment Pending Report |
| LM_BO006_UN2_VW – For Payment Pending report |
| LM_BO007_LG1_VW – For PO Usage Report |
| LM_BO007_LG2_VW – For PO Usage Report |
| LM_BO007_UN1_VW – For PO Usage Report |
| LM_BO007_UN2_VW – For PO Usage Report |
| LM_BO008_LG1_VW – For PO Balance Report |
| LM_BO008_LG2_VW – For PO Balance Report |
| LM_BO008_UN1_VW – For PO Balance Report |
| LM_BO008_UN2_VW – For PO Balance Report |
| LM_BO_COUNTERS – Biz Objects Counters |
| LM_BUS_UNIT_GL – GL Business Unit |
| LM_BUS_UNIT_TBL – HR Business Unit |
| LM_CATG_CI_TBL – Category/Catalog Item Rel Tbl |
| LM_CATG_LE_TBL – Category – LE Relationship TBL |
| LM_CATG_REL_TBL – Category Relationship Table |
| LM_CATG_SEC_TBL – Category Security Table |
| LM_CATG_TBL – Category Table |
| LM_CERT_HIST_VW – Learner Certification History |
| LM_CERT_PRG_VW – Learner Cert Status View |
| LM_CERT_SCN_VW – Learner Cert Status View |
| LM_CF_ACCOUNT – GL Accounts |
| LM_CF_ALTACCT – Alternate Account |
| LM_CF_BUD_REF – Budget Reference Table |
| LM_CF_BU_DFLT – Business Unit Chartfields |
| LM_CF_CLASS – Class Chart Fields |
| LM_CF_FIELD1 – Chartfield1 |
| LM_CF_FIELD2 – Chartfield2 |
| LM_CF_FIELD3 – Chartfield3 |
| LM_CF_FUND – Fund Table |
| LM_CF_NAMES – Chart Field Names |
| LM_CF_OPER_UNIT – Operating Unit |
| LM_CF_PRODUCT – Product Chart Field values |
| LM_CF_PROGRAM – Program Chart Field values |
| LM_CF_PROJECT – Project Chart Field |
| LM_CHGBK_INFO – ChargeBack Info |
| LM_CI_ATT_TBL – Catalog Item/ Attachments |
| LM_CI_EQUIV_TBL – Catalog Item/Equivalency Tbl |
| LM_CI_LE_RPT_VW – View for Enrollment Reports |
| LM_CI_LE_TBL – CI LE Relationship table |
| LM_CI_NOTES_TBL – Catalog Item – Notes Tbl |
| LM_CI_OBJV_TBL – Catalog Item/Objectives Rel |
| LM_CI_PRQ_TBL – Prereq Tbl |
| LM_CI_REC_TBL – Catalog Item/ Recommended Tbl |
| LM_CI_SEC_TBL – Catalog Item Security Tbl |
| LM_CI_TBL – Catalog Item Table |
| LM_CI_US – Catalog Item Tbl – US Specific |
| LM_CI_VW – Catalog Item Ext View |
| LM_CI_VW_LNG – Catalog Item Ext View Language |
| LM_CM_PURP_TYPE – Purpose Type Definition |
| LM_CNTCT_ROLEVW – Contact Role View |
| LM_CRS_LONG – AICC CRS long |
| LM_CS_COUNTER – Counter Table |
| LM_CURR_JOB_VW – Person Attribute Data |
| LM_DEPT_VW – Departments |
| LM_DIF_PRINT – DIF Balance Report |
| LM_DMTHD_TBL – Delivery Method Table |
| LM_DMTHD_VW – Delivery Method Ext View |
| LM_DMTHD_VW3 – Delivery Method Ext View |
| LM_DMTH_TYP_TBL – Delivery Method Type Table |
| LM_ED_ASS_DTL – Result Table – Edu Assessment |
| LM_ED_SUM_SPL – Sum Table – Edu Assessment |
| LM_ENPYMT_VW – Enrollment Payment |
| LM_ENRLMT – Enrollment |
| LM_ENRLMT_CNTR – Enrollments Counter Table |
| LM_ENRLMT_PYMT – Enrollment Payment |
| LM_ENRLMT_VW – Enrollment |
| LM_ENRL_MASS_DT – Mass Enrlmt Details |
| LM_ENRL_MASS_RQ – Mass Enrollment Req Record |
| LM_ENRL_MAS_PAY – Mass Enrollment Payments Rec |
| LM_ENRMT_PO_TBL – Purchase Order(Method of Pymt) |
| LM_ENRMT_PO_VW |
| LM_ENRMT_RPT_VW – View for enrollment reports |
| LM_ENR_BL_VW – Enrollment BL View |
| LM_ENR_LC_BL_VW – Learning Comp status View |
| LM_ENR_LC_TBL – Learning Component – Enrlmt |
| LM_EQP_ATCH – Equipment Attachments |
| LM_EQP_LE – Equipment LE Table |
| LM_EQP_LE_VW – Equipment LE View |
| LM_EQP_TBL – Equipment Setup table |
| LM_EQP_TYPE – Equipment Type Setup |
| LM_EQP_TYPE_VW – Equipment Type View |
| LM_EQP_VW – Equipment View |
| LM_EVALS – LM_Evaluations |
| LM_EXCEPTIONS – LM Exceptions |
| LM_FCLTY_ATCH – Facility Attachments Table |
| LM_FCLTY_CNTCT – Facility Contact Table |
| LM_FCLTY_EQP – Facility Equipment Table |
| LM_FCLTY_EQP_VW – Facility Equipment View |
| LM_FCLTY_LE – Facility LE Table |
| LM_FCLTY_TBL – Facility Setup Table |
| LM_GRD_SCH – Grade Schemes |
| LM_GRD_SCH_VAL – Grade Schemes |
| LM_GRD_SCH_VW – Grade Schemes |
| LM_GROUPS_CRIT – Learner Groups Criteria |
| LM_GROUP_PERSON – Learner Group to Person |
| LM_HLDAY_DT – Holiday Date Table |
| LM_HLDAY_DT_VW – Holiday Date View |
| LM_HLDAY_SCHED – Holiday Schedule |
| LM_HLDAY_VW – Holiday Schedule View |
| LM_HR_COMP_VW – View of LM_HR_COMP_TBL. |
| LM_HR_EVALS – LM_Evaluations |
| LM_INSTR – Instructor Table |
| LM_INSTR_ATCH – Instructor Attachments |
| LM_INSTR_FCLTY – Instructor Facility Preference |
| LM_INSTR_LE – Instructor LE Table |
| LM_INSTR_LE_VW – Instructor LE View |
| LM_INSTR_QUAL – Instructor Qualified to Teach |
| LM_INSTR_ROLEVW – Contact Role View |
| LM_IN_DFLT_TBL – Install Default Table |
| LM_JOBCODE_TBL – Job Code Table |
| LM_JRNLGEN_TMPL – Journal Template |
| LM_KWRD_CI_TBL – Keyword – Catalog Item Rel Tbl |
| LM_KWRD_TBL – Keyword Table |
| LM_KWRD_TYP_TBL – Keyword Type Table |
| LM_LC – Learning Component |
| LM_LC_ASGN – Assignment Learning Component |
| LM_LC_ASGN_URL – Stores Assignment URL |
| LM_LC_CMPL_VW – Completion View |
| LM_LC_LVW – Learning Component LView |
| LM_LC_LWC – Webcast Learning Component |
| LM_LC_TEST – Test Learning Component |
| LM_LC_TYPE_TBL – Learning Component Types |
| LM_LC_VW – Learning Component View |
| LM_LEBL_COUNTER – Blended Learning Counter |
| LM_LELW_COUNT – Webcast Counter Table |
| LM_LELW_ENR_BAT – Enrollment Batch Table |
| LM_LELW_LOG – WebCast Error Log |
| LM_LELW_PWD_TBL – Vendor Person Table |
| LM_LELW_SCACHE – Webcast Session Cache |
| LM_LELW_SES_BAT – Webcast Session Batch Table |
| LM_LELW_XSLT – Webcast-Vendor XSLT Table |
| LM_LEL_FILES – L&T File data |
| LM_LEL_SETUP – L and Track Setup |
| LM_LE_DFLT_TBL – Learning Environment Defaults |
| LM_LE_TBL – Learning Environment |
| LM_LE_VW – Learning Environment View |
| LM_LRNR_ATTRIBS – Learner Attributes |
| LM_LRNR_CERT – Learner Certification table |
| LM_LRNR_COMP – Learner Objectives |
| LM_LRNR_GROUPS – Learner Groups |
| LM_LRNR_OBJV – Learner Objectives |
| LM_LRNR_OBJV_HR – Learner Objectives |
| LM_LRNR_TUPL_IT – Training Unit Pool Item |
| LM_LRQ_TRK_HST – Learning Request Tracking Hist |
| LM_LWC_SES – Webcast Session |
| LM_LWC_URL – Webcast component |
| LM_MASS_CNTR – Mass Enrlmt Counter Table |
| LM_MOP_CTR_TBL – TU and PO counter table |
| LM_MOP_OWNR_TBL – Method of Payment Owner |
| LM_MSGSEQ_ASYNC – Message Sequence Log Table |
| LM_MTRL_LE – Material LE Table |
| LM_MTRL_TBL – Material Table |
| LM_MTRL_TYPE – Material Type Table |
| LM_MTRL_TYPE_VW – Material Type View |
| LM_NAME_TYPE – Name Type |
| LM_NOTIF_BATCH |
| LM_NOTIF_PARMS – Notif Bind Parms |
| LM_NOTIF_TRANS |
| LM_OBJV_COUNTER – Counter Table for Objectives |
| LM_OBJV_DTL – Objectives Detail |
| LM_OBJV_EXT_SRC – Objectives External Source Tbl |
| LM_OBJV_EXT_STP – Objective External Srce Setup |
| LM_OBJV_TBL – Objectives Table |
| LM_OPRID_LE_VW – OPRID Learning Environment |
| LM_ORGANIZATION – Organization information |
| LM_ORG_ADDR – Organization Address |
| LM_ORG_CHARTFLD – Organization Chartfields |
| LM_ORG_EMAIL – Organization Email |
| LM_ORG_LE_VW – Organization LE View |
| LM_ORG_PHONE – Organization Phone |
| LM_ORG_PO_VW – ORG/TU view |
| LM_ORG_PYT_DEFS – Payment Defaults for Org. |
| LM_ORG_VW – Organization View |
| LM_PASS_SCH – Passing Scheme |
| LM_PASS_SCH_VAL – Passing Scheme |
| LM_PERSON – ELM Learner |
| LM_PERSON_ADDR – Person Address |
| LM_PERSON_ADMIN – Admininistrator’s Learning Env |
| LM_PERSON_ATTRB – Person Attribute Data |
| LM_PERSON_EFFDT – Person EFFDT |
| LM_PERSON_EMAIL – Person Email |
| LM_PERSON_JOB – Person Job Data |
| LM_PERSON_LANGS – Person Languages |
| LM_PERSON_NAME – Person Names |
| LM_PERSON_OPRID – Person OPRID |
| LM_PERSON_PHONE – Person Phone |
| LM_PERS_ADDR_VW – Person Address View |
| LM_PERS_DTL_VW – Person Details View |
| LM_PERS_NAME_VW – Person Names |
| LM_PER_NAME_VW – Person Name view |
| LM_POSITION – Position Table |
| LM_PO_ORG_SR_VW – PO Org search view |
| LM_PO_ORG_VW – PO search view |
| LM_PO_OWNER_VW – Purchase Order(Method of Pymt) |
| LM_PRG – Program Details |
| LM_PRG_ATCH – Program Attachments |
| LM_PRG_ATCH_VW – Program Attachments View |
| LM_PRG_CATG – Program Categories |
| LM_PRG_CD_VW – Program Code View |
| LM_PRG_COUNTER – Program Counter Table |
| LM_PRG_DTL_VW – Prog Progress Search View |
| LM_PRG_ENRL_VW – Enrollment for Program |
| LM_PRG_ITEM – Program Items |
| LM_PRG_ITEM_ENR – Program Reg Item Table |
| LM_PRG_ITNM_VW – Program Item Name View |
| LM_PRG_KWRD – Program Keywords |
| LM_PRG_KWRD_TBL – Keyword Table |
| LM_PRG_LE – Program Learning Environments |
| LM_PRG_NOTE – Program Notes |
| LM_PRG_NOTE_VW – Program Notes View |
| LM_PRG_OBJV – Program Objectives |
| LM_PRG_OBJVERVW – Program Objectives |
| LM_PRG_PRQ – Program Prerequisites |
| LM_PRG_REC – Program Recommended Pre Req’s |
| LM_PRG_REG – Program Reg Table |
| LM_PRG_REG_LANG – Registration Related Language |
| LM_PRG_ROST_VW – View For Program Roster |
| LM_PRG_SCN – Program Section |
| LM_PRG_SCN_VW – Program Section |
| LM_PRG_SEC – Program Security |
| LM_PRG_VW – Program View |
| LM_PRG_VW3 – Program View |
| LM_PRICING_TYPE – Vendor Pricing Type |
| LM_PROD_TYPE – Vendor Product Type |
| LM_PRQ_PRG_VW – Prerequisite Program View |
| LM_PRQ_RPT_LNG1 – For Prereq |
| LM_PRQ_RPT_LNG2 – For Prereq |
| LM_PRQ_RPT_LNG3 – For Prereq |
| LM_PRQ_RPT_LNG4 – For Prereq |
| LM_PRQ_RPT_LNG5 – For Prereq |
| LM_PRQ_RPT_LNG6 – For Prereq |
| LM_PRQ_RPT_UN_1 – For Prereq |
| LM_PRQ_RPT_UN_2 – For Pre Req |
| LM_PRQ_RPT_UN_3 – For Pre Req |
| LM_PRQ_RPT_UN_4 – For Pre Req |
| LM_PRQ_RPT_UN_5 – For Pre Req |
| LM_PRQ_RPT_UN_6 – For Prereq |
| LM_PRSN_OPRD_VW – Person OPRID |
| LM_PTRN_EQP – Session Equipment Table |
| LM_PTRN_INSTR – Session Pattern Instructor |
| LM_PYMT_INFO – Payment Description |
| LM_RCNTL_CNTNT – L & T Runcontrol |
| LM_RCNTL_STDNT – L & T Runcontrol |
| LM_REBUILD_LG – LG Id scheduled to rebuild. |
| LM_RECERTPRG_VW – Learner Recertification View |
| LM_REC_PRG_VW – Recommended Programs |
| LM_REG_AUD_VW – Registration Audit View |
| LM_RM_COUNTER – RM Counter Table |
| LM_ROLE_COMPS – Competencies of Role |
| LM_ROLE_TBL – Role Table |
| LM_ROOM_ACMDTN – Room Accomodation Table |
| LM_ROOM_ATCH – Facility Room Attachments |
| LM_ROOM_EQP – Room Equipment Table |
| LM_ROOM_LE – Room LE Table |
| LM_ROOM_TBL – Room Table |
| LM_ROOM_TYPE – Room Type Setup Table |
| LM_ROOM_TYPE_VW – Room Type View |
| LM_RPTUN_LCATG1 – LMCATGREL Report query |
| LM_RPTUN_LCATG2 – LMCATGREL Report query |
| LM_RPTUN_LCATG3 – LMCATGREl Report query |
| LM_RPT_UN_CATG – LMCATGREl Report query |
| LM_RPT_UN_CATG1 – LMCATGREL Report query |
| LM_RPT_UN_LCATG – LMCATGREl Report query |
| LM_RTNG_MDL_TBL – Rating Model for Reviews |
| LM_RUNCTL_ACT – Process Activity Notifications |
| LM_RUNCTL_CR – Run Control Curriculum Record |
| LM_RUNCTL_FI – ELM FI Run Control |
| LM_RUN_ACTPROG – Activity Progress report |
| LM_RUN_CATG_RPT – Learning Component Report |
| LM_RUN_CNTL_CM – LM Run Control |
| LM_RVW_RTNG_TBL – Performance Review Ratings |
| LM_SCO_DETAIL – SCO details |
| LM_SCO_LONG – SCO long |
| LM_SCO_METADATA |
| LM_SES – Session Table |
| LM_SES_EQP – Session Equipment Table |
| LM_SES_EQP_VW – Session Equipment View |
| LM_SES_FCLTY_VW – Session Room View |
| LM_SES_INSTR – Session Instructor Table |
| LM_SES_INSTR_VW – Session Instructor View |
| LM_SES_LE_VW – Session LE View |
| LM_SES_PTRN – Session Pattern Table |
| LM_SES_ROOM_VW – Session Facility View |
| LM_STATS_UN3_VW – Union for LM_STATS rep |
| LM_STATS_UN4_VW – Union for LM_STATS rep |
| LM_STATUS_RUN – LM Run Control |
| LM_STG_PRS – ELM Learner |
| LM_STG_PRS_ADDR – Person Address |
| LM_STG_PRS_ATT – Person Attribute Data |
| LM_STG_PRS_DT – Person EFFDT |
| LM_STG_PRS_EML – Person Email |
| LM_STG_PRS_JOB – Person Job Data |
| LM_STG_PRS_NM – Person Names |
| LM_STG_PRS_PHN – Person Phone |
| LM_SUBLEDGER – ELM Subledger |
| LM_SUBLEDGER_ID – ELM Sub Ledger ID |
| LM_SUBLEDGER_VW – Sub-Ledger Inquiry View |
| LM_SUBLEDG_UPDT – Sub-ledger Update Options |
| LM_TMPL_DTL – Session Template Detail Table |
| LM_TMPL_EQP – Template Equipment Table |
| LM_TMPL_HDR – Session Template Header Table |
| LM_TMPL_INSTR – Template Instructor Table |
| LM_TMPL_LE – Template LE Table |
| LM_TPLAN_OBJ_VW – Objectives in a training plan |
| LM_TPLAN_ORG_VW – Training Plan View |
| LM_TPLNITM_ATTR – Training Plan Item attributes |
| LM_TPLNITM_LRNR – Training Plan Item Learner |
| LM_TRACK_LONG – Tracking table long |
| LM_TRACK_STUDNT – Student Tracking in e-Learning |
| LM_TRNGPLN_ITMS – Training plan items |
| LM_TRN_PLN_RCTL – Training plan report record |
| LM_TUPL_ITM_TBL – Training Unit Pool Item |
| LM_TUPL_ITM_VW – Training Unit Pool Item |
| LM_TUPOOL_VW – TU Pool |
| LM_TU_ORG_VW – TUs owned by Org view |
| LM_TU_OWNER_VW – TU OwnerID |
| LM_TU_POOL_TBL – Training Unit (Method of Pymt) |
| LM_TU_POOL_VW – Training Unit (Method of Pymt) |
| LM_UNITS – Vendor Units |
| LM_VENDOR – Vendor Definition |
| LM_VENDOR_ADDR – Vendor Address |
| LM_VENDOR_EMAIL – Vendor Email |
| LM_VENDOR_PHONE – Vendor Phone |
| LM_VENDOR_PROD – Vendor Products definition |
Apurva,
I am a functional person using ELM 9.2 Image 008. Could you please share a list of the ELM tables for this version?
Thank you
Trish