LM_TRPLIT_HSTVW

(SQL View)
 Index Back

Training plan items

Training plan items generated for the report run.

SELECT PSARCH_ID , PSARCH_BATCHNUM , LM_TRN_PLN_ID , LM_TRNG_PLN_ITM_ID , LM_LRQ_ID , LM_ITEM_TYPE , LM_ACT_ID , DESCR254 , LM_START_DT , LM_END_DT , LM_INSTR_ID , LM_NAME_DISPLAY , LM_OBJV_ID , LM_OBJV_DESC , LM_ACT_HOURS , LM_INTERNAL_OFF , LM_VENDOR_DESCR FROM PS_LM_TRPLNITM_HST

  • Parent record: LM_TRN_PLN_RCTL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 LM_TRN_PLN_ID Character(30) VARCHAR2(30) NOT NULL Training Plan Id
    4 LM_TRNG_PLN_ITM_ID Number(10,0) DECIMAL(10) NOT NULL Training plan item id for the report
    5 LM_LRQ_ID Number(10,0) DECIMAL(10) NOT NULL New field for ELM 9.0, stores unique identifier for a single learning request.
    6 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
    7 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    9 LM_START_DT Date(10) DATE Start Date
    10 LM_END_DT Date(10) DATE End Date
    11 LM_INSTR_ID Number(15,0) DECIMAL(15) NOT NULL Instructor ID
    12 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field
    13 LM_OBJV_ID Number(10,0) DECIMAL(10) NOT NULL Objective ID. System Generated ID Number associated with each Objective.
    14 LM_OBJV_DESC Character(100) VARCHAR2(100) NOT NULL Objective description.
    15 LM_ACT_HOURS Number(13,2) DECIMAL(12,2) NOT NULL Activity Hours
    16 LM_INTERNAL_OFF Character(30) VARCHAR2(30) NOT NULL Internal/External Offering
    17 LM_VENDOR_DESCR Character(50) VARCHAR2(50) NOT NULL Vendor Description