LM_PEN_ADHC_REQ

(SQL View)
 Index Back

Adhoc Pending approval

Adhoc Pending approval view

SELECT F.OPRID , A.LM_ADHC_LRN_ID , A.LM_APPR_ID , A.LM_PERSON_ID , A.LM_PER_TRN_NM , A.LM_ACT_REQ , A.LM_ADHC_ID , B.LM_ADHC_TYPE , C.FIRST_NAME , C.LAST_NAME , A.LM_ACT_FEE , A.CURRENCY_CD , B.LM_ALW_PRICE , C.LM_NAME_DISPLAY FROM PS_LM_ADHC_LRN_VW A , PS_LM_ADHC_TBL B , PS_LM_PERS_DTL_VW C , PS_LM_ADH_APR_XREF X , PS_EOAW_USERINST F , PS_EOAW_STEPINST G WHERE A.LM_ADHC_ID = B.LM_ADHC_ID AND A.LM_PERSON_ID = C.LM_PERSON_ID AND A.LM_ADHC_LRN_STTS IN ('PEAP' ) AND A.LM_ENRL_DT BETWEEN B.EFFDT AND B.LM_END_EFFDT AND X.LM_ADHC_LRN_ID = A.LM_ADHC_LRN_ID AND X.EOAWTHREAD_ID = G.EOAWTHREAD_ID AND X.EOAWPRCS_ID = G.EOAWPRCS_ID AND G.EOAWSTEP_INSTANCE = F.EOAWSTEP_INSTANCE AND F.EOAWSTEP_STATUS ='P'

  • Related Language Record: LM_PEN_ADHC_LVW

    • # 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_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    3 LM_APPR_ID Number(15,0) DECIMAL(15) NOT NULL Approver ID field
    4 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    5 LM_PER_TRN_NM Character(254) VARCHAR2(254) NOT NULL Personal Training Name. This field is used in case of Adhoc training. This field will carry the name of the Course / Catalog Item the person took training.
    6 LM_ACT_REQ Character(1) VARCHAR2(1) NOT NULL Activity Required
    N=No
    Y=Yes
    7 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id
    8 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    9 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field
    10 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field
    11 LM_ACT_FEE Number(19,3) DECIMAL(18,3) NOT NULL Activity Fee -- The cost to the learner of enrolling in a class
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    13 LM_ALW_PRICE Character(1) VARCHAR2(1) NOT NULL Allow Price
    14 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field