LM_PEN_TRN_RQ_1

(SQL View)
 Index Back

Training Request

Training Requests

SELECT USR.OPRID , ENRL.LM_ENRLMT_ID , CI.LM_CI_ID , CI.EFFDT , DMTYP.LM_DMTHD_TYPE_ID , ENRL.LM_APPR_ID , ENRL.LM_ACT_REQ , ENRL.LM_PERSON_ID , ENRL.LM_ACT_ID , ENRL.LM_ACT_FEE , ENRL.LM_FEE_NO_OF_TUS , ENRL.CURRENCY_CD , ENRL.LM_PYMT_MTHD , CI.LM_CS_LONG_NM , DMTYP.LM_DM_LONG_NM , ACT.LM_START_DT FROM PS_LM_ENRLMT ENRL , PS_LM_ACT ACT , PS_LM_DMTHD_TBL DM , PS_LM_DMTH_TYP_TBL DMTYP , PS_LM_CI_TBL CI , PS_LM_ENR_APR_XREF XREF , PS_EOAW_USERINST USR , PS_EOAW_STEPINST STEP WHERE ENRL.LM_ACT_ID = ACT.LM_ACT_ID AND ENRL.LM_STTS IN ( 'PEAP','PPYA' ) AND CI.LM_CI_ID = ENRL.LM_CI_ID AND DM.LM_DMTHD_ID = ACT.LM_DMTHD_ID AND DM.LM_DMTHD_TYPE_ID = DMTYP.LM_DMTHD_TYPE_ID AND ENRL.LM_ENRL_DT BETWEEN DM.EFFDT AND DM.LM_END_EFFDT AND DM.LM_DM_STATUS = '10' AND DM.LM_CI_ID = ENRL.LM_CI_ID AND ENRL.LM_ENRL_DT BETWEEN CI.EFFDT AND CI.LM_END_EFFDT AND CI.LM_CI_STATUS = '10' AND XREF.LM_ENRLMT_ID = ENRL.LM_ENRLMT_ID AND XREF.EOAWTHREAD_ID = STEP.EOAWTHREAD_ID AND XREF.EOAWPRCS_ID = STEP.EOAWPRCS_ID AND STEP.EOAWSTEP_INSTANCE = USR.EOAWSTEP_INSTANCE AND USR.EOAWSTEP_STATUS = 'P'

  • Related Language Record: LM_PEN_TRN_LG_1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    3 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 LM_DMTHD_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method Type ID - This is a unique identifier for each delivery method type
    6 LM_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field
    7 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes
    8 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    9 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    10 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
    11 LM_FEE_NO_OF_TUS Number(14,3) DECIMAL(13,3) NOT NULL No of Training Units available/used.
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    13 LM_PYMT_MTHD Character(4) VARCHAR2(4) NOT NULL Payment Method. The payment method can be ChargeBack, Training Units
    CASH=Cash
    CHCK=Check
    CHGB=ChargeBack
    CRCD=Credit Card
    NOAP=Not Applicable
    PO=Purchase Order
    SEL=Select...
    TU=Training Units
    14 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    15 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type
    16 LM_START_DT Date(10) DATE Start Date