LM_AP_HD_ADHLVW

(SQL View)
 Index Back

Adhoc Learning Approval Header

This view is used for the HTML Email Supplemental Learning Approval header related language view.

SELECT M.LM_ADHC_LRN_ID , MLNG.LANGUAGE_CD , SLNG.LM_ADHC_TYPE , 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 , MLNG.LM_EU_TYPE FROM PS_LM_ADHC_TBL S , PS_LM_ADHC_LNG_TBL SLNG , PS_LM_ADHC_LRN_TBL M , PS_LM_AD_LRNEU_LVW MLNG , PS_LM_PERSON P WHERE S.LM_ADHC_ID = M.LM_ADHC_ID AND S.LM_ADHC_ID = SLNG.LM_ADHC_ID AND S.EFFDT = SLNG.EFFDT AND SLNG.LANGUAGE_CD = MLNG.LANGUAGE_CD AND M.LM_ADHC_LRN_ID = MLNG.LM_ADHC_LRN_ID AND M.LM_PERSON_ID = P.LM_PERSON_ID AND %CurrentDateIn BETWEEN S.EFFDT AND S.LM_END_EFFDT AND EXISTS ( SELECT 1 FROM PS_LM_ADH_APR_XREF X WHERE X.LM_ADHC_LRN_ID = M.LM_ADHC_LRN_ID) UNION SELECT M.LM_ADHC_LRN_ID , MLNG.LANGUAGE_CD , S.LM_ADHC_TYPE , 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 , MLNG.LM_EU_TYPE FROM PS_LM_ADHC_TBL S , PS_LM_ADHC_LRN_TBL M , PS_LM_AD_LRNEU_LVW MLNG , PS_LM_PERSON P WHERE S.LM_ADHC_ID = M.LM_ADHC_ID AND M.LM_ADHC_LRN_ID = MLNG.LM_ADHC_LRN_ID AND M.LM_PERSON_ID = P.LM_PERSON_ID AND %CurrentDateIn BETWEEN S.EFFDT AND S.LM_END_EFFDT AND EXISTS ( SELECT 1 FROM PS_LM_ADH_APR_XREF X WHERE X.LM_ADHC_LRN_ID = M.LM_ADHC_LRN_ID) AND NOT EXISTS ( SELECT 1 FROM PS_LM_ADHC_LNG_TBL SLNG WHERE S.LM_ADHC_ID = SLNG.LM_ADHC_ID AND S.EFFDT = SLNG.EFFDT AND SLNG.LANGUAGE_CD = MLNG.LANGUAGE_CD ) UNION SELECT M.LM_ADHC_LRN_ID , SLNG.LANGUAGE_CD , SLNG.LM_ADHC_TYPE , 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 , E.LM_EU_TYPE FROM PS_LM_ADHC_TBL S , PS_LM_ADHC_LNG_TBL SLNG , PS_LM_ADHC_LRN_TBL M LEFT OUTER JOIN PS_LM_EU_TBL E ON M.LM_EU_ID = E.LM_EU_ID , PS_LM_PERSON P WHERE S.LM_ADHC_ID = M.LM_ADHC_ID AND S.LM_ADHC_ID = SLNG.LM_ADHC_ID AND S.EFFDT = SLNG.EFFDT AND M.LM_PERSON_ID = P.LM_PERSON_ID AND %CurrentDateIn BETWEEN S.EFFDT AND S.LM_END_EFFDT AND EXISTS ( SELECT 1 FROM PS_LM_ADH_APR_XREF X WHERE X.LM_ADHC_LRN_ID = M.LM_ADHC_LRN_ID) AND NOT EXISTS ( SELECT 1 FROM PS_LM_AD_LRNEU_LVW MLNG WHERE M.LM_ADHC_LRN_ID = MLNG.LM_ADHC_LRN_ID AND SLNG.LANGUAGE_CD = MLNG.LANGUAGE_CD )

  • Related Language Record for LM_AP_HD_ADH_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_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    4 LM_PRVD_BY Character(30) VARCHAR2(30) NOT NULL Provided By
    5 LM_SUP_BY Character(30) VARCHAR2(30) NOT NULL Supervised By
    6 LM_FRE_FLD_FOUR Character(50) VARCHAR2(50) NOT NULL Free Field Four
    7 LM_FRE_FLD_ONE Character(50) VARCHAR2(50) NOT NULL Free Field One
    8 LM_FRE_FLD_THREE Character(50) VARCHAR2(50) NOT NULL Free Field Three
    9 LM_FRE_FLD_TWO Character(50) VARCHAR2(50) NOT NULL Free Field Two
    10 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.
    11 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.
    12 LM_PER_TRN_LOC Character(50) VARCHAR2(50) NOT NULL Adhoc Learning Location
    13 LM_PER_TRN_INST Character(50) VARCHAR2(50) NOT NULL Adhoc Learning Institution
    14 LM_EU_TYPE Character(50) VARCHAR2(50) NOT NULL Education Unit Type