LM_ADH_APR_LVW

(SQL View)
 Index Back

Adhoc Approval View Rel Lang

This view is used for the Mobile Approval for Supplemental Learning Related Language view.

SELECT MLNG.LM_ADHC_LRN_ID , MLNG.LANGUAGE_CD , MLNG.LM_PRVD_BY , MLNG.LM_SUP_BY , MLNG.LM_FRE_FLD_FOUR , MLNG.LM_FRE_FLD_ONE , MLNG.LM_FRE_FLD_THREE , MLNG.LM_FRE_FLD_TWO , MLNG.LM_PER_TRN_NM , MLNG.LM_PER_TRN_DESCR , MLNG.LM_PER_TRN_LOC , MLNG.LM_PER_TRN_INST , TLNG.LM_ADHC_TYPE FROM PS_LM_ADHC_LRN_TBL M , PS_LM_ADHC_LRN_LNG MLNG , PS_LM_ADHC_TBL T , PS_LM_ADHC_LNG_TBL TLNG , PS_LM_ADH_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE M.LM_ADHC_LRN_ID = MLNG.LM_ADHC_LRN_ID AND MLNG.LANGUAGE_CD = TLNG.LANGUAGE_CD AND T.LM_ADHC_ID = M.LM_ADHC_ID AND %CurrentDateIn BETWEEN T.EFFDT AND T.LM_END_EFFDT AND T.LM_ADHC_ID = TLNG.LM_ADHC_ID AND T.EFFDT = TLNG.EFFDT AND M.LM_ADHC_LRN_ID = X.LM_ADHC_LRN_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND D.EOAWSTEP_INSTANCE = S.EOAWSTEP_INSTANCE UNION SELECT MLNG.LM_ADHC_LRN_ID , MLNG.LANGUAGE_CD , MLNG.LM_PRVD_BY , MLNG.LM_SUP_BY , MLNG.LM_FRE_FLD_FOUR , MLNG.LM_FRE_FLD_ONE , MLNG.LM_FRE_FLD_THREE , MLNG.LM_FRE_FLD_TWO , MLNG.LM_PER_TRN_NM , MLNG.LM_PER_TRN_DESCR , MLNG.LM_PER_TRN_LOC , MLNG.LM_PER_TRN_INST , T.LM_ADHC_TYPE FROM PS_LM_ADHC_LRN_TBL M , PS_LM_ADHC_LRN_LNG MLNG , PS_LM_ADHC_TBL T , PS_LM_ADH_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE M.LM_ADHC_LRN_ID = MLNG.LM_ADHC_LRN_ID AND T.LM_ADHC_ID = M.LM_ADHC_ID AND %CurrentDateIn BETWEEN T.EFFDT AND T.LM_END_EFFDT AND M.LM_ADHC_LRN_ID = X.LM_ADHC_LRN_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND D.EOAWSTEP_INSTANCE = S.EOAWSTEP_INSTANCE AND NOT EXISTS ( SELECT 1 FROM PS_LM_ADHC_LNG_TBL TLNG WHERE TLNG.LM_ADHC_ID = T.LM_ADHC_ID AND TLNG.EFFDT = T.EFFDT AND TLNG.LANGUAGE_CD = MLNG.LANGUAGE_CD) UNION SELECT M.LM_ADHC_LRN_ID , TLNG.LANGUAGE_CD , M.LM_PRVD_BY , M.LM_SUP_BY , M.LM_FRE_FLD_FOUR , M.LM_FRE_FLD_ONE , M.LM_FRE_FLD_THREE , M.LM_FRE_FLD_TWO , M.LM_PER_TRN_NM , M.LM_PER_TRN_DESCR , M.LM_PER_TRN_LOC , M.LM_PER_TRN_INST , TLNG.LM_ADHC_TYPE FROM PS_LM_ADHC_LRN_TBL M , PS_LM_ADHC_TBL T , PS_LM_ADHC_LNG_TBL TLNG , PS_LM_ADH_APR_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST D WHERE T.LM_ADHC_ID = M.LM_ADHC_ID AND %CurrentDateIn BETWEEN T.EFFDT AND T.LM_END_EFFDT AND T.LM_ADHC_ID = TLNG.LM_ADHC_ID AND T.EFFDT = TLNG.EFFDT AND M.LM_ADHC_LRN_ID = X.LM_ADHC_LRN_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND D.EOAWSTEP_INSTANCE = S.EOAWSTEP_INSTANCE AND NOT EXISTS ( SELECT 1 FROM PS_LM_ADHC_LRN_LNG MLNG WHERE MLNG.LM_ADHC_LRN_ID = M.LM_ADHC_LRN_ID AND MLNG.LANGUAGE_CD = TLNG.LANGUAGE_CD )

  • Related Language Record for LM_ADH_APR_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_PRVD_BY Character(30) VARCHAR2(30) NOT NULL Provided By
    4 LM_SUP_BY Character(30) VARCHAR2(30) NOT NULL Supervised By
    5 LM_FRE_FLD_FOUR Character(50) VARCHAR2(50) NOT NULL Free Field Four
    6 LM_FRE_FLD_ONE Character(50) VARCHAR2(50) NOT NULL Free Field One
    7 LM_FRE_FLD_THREE Character(50) VARCHAR2(50) NOT NULL Free Field Three
    8 LM_FRE_FLD_TWO Character(50) VARCHAR2(50) NOT NULL Free Field Two
    9 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.
    10 LM_PER_TRN_DESCR Character(254) VARCHAR2(254) NOT NULL Personal Training Comments. This field is used in case of Adhoc training. This field will carry the comments on the Course / Catalog Item training the person took.
    11 LM_PER_TRN_LOC Character(50) VARCHAR2(50) NOT NULL Adhoc Learning Location
    12 LM_PER_TRN_INST Character(50) VARCHAR2(50) NOT NULL Adhoc Learning Institution
    13 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type