Complete List of PeopleSoft ELM 9.1 Tables – PeopleSoft Tutorial
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 Tripathi
 

Apurva is a PeopleSoft consultant and a big advocate of everything PeopleSoft. He is also a technology enthusiast and loves learning and implementing newer and open source technologies. He spends his spare time updating this blog and likes to read books on self help and productivity.

  • Trish Young says:

    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

  • >

    Download Complete List of PeopleTools Tables List. Never Again Google It !