Complete List of PeopleSoft ELM 9.1 Tables

by Apurva T. on August 12, 2013

in PeopleSoft Basics

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
Also Read:  Difference between PeopleSoft Cloud Architecture and PeopleSoft Cloud Manager

{ 1 comment… read it below or add one }

Trish Young May 28, 2015 at 9:55 am

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

Reply

Cancel reply

Leave a Comment

Previous post:

Next post: