LM_TRNGPLN_ITMS

(SQL Table)
Index Back

Training plan items

Training plan items generated for the report run.

  • Related Language Record: LM_TRNGPLN_LNG
  • Parent record: LM_TRN_PLN_RCTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_TRN_PLN_ID Character(30) VARCHAR2(30) NOT NULL Training Plan Id
    2 LM_TRNG_PLN_ITM_ID Number(10,0) DECIMAL(10) NOT NULL Training plan item id for the report
    3 LM_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Item type to identify a training plan item. It can be of type Activity or Learning Request.
    1=Class
    2=Learning Request
    3=Program Registration
    4=Supplemental Learning
    4 LM_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.
    5 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 LM_START_DT Date(10) DATE Start Date
    8 LM_END_DT Date(10) DATE End Date
    9 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID
    10 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    11 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
    12 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.
    13 LM_ACT_HOURS Number(13,2) DECIMAL(12,2) NOT NULL Activity Hours
    14 LM_INTERNAL_OFF Character(30) VARCHAR2(30) NOT NULL Internal/External Offering
    15 LM_VENDOR_DESCR Character(50) VARCHAR2(50) NOT NULL Vendor Description
    16 LM_PRG_ID Number(10,0) DECIMAL(10) NOT NULL Program ID is a unique identifier for curriculum and certification Programs.
    17 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    18 LM_TP_ITM_COST Number(19,3) DECIMAL(18,3) NOT NULL Training Plan Item Cost
    19 LM_EST_SAL_COST Number(19,3) DECIMAL(18,3) NOT NULL Estimated Salary Cost
    20 LM_FROM_LRQ Character(1) VARCHAR2(1) NOT NULL From Learning Request

    Y/N Table Edit

    Default Value: N