LM_MGR_ADH_LVW2

(SQL View)
 Index Back

Manager Adhoc Learning Lang

Manager Adhoc Learning Language View

SELECT A.LM_PERSON_ID , A.LM_ADHC_LRN_ID , D.LANGUAGE_CD , D.LM_ADHC_TYPE , D.LM_PER_TRN_DESCR , D.LM_PER_TRN_NM FROM PS_LM_ADHC_PER_VW A , PS_LM_PERS_DTL_VW C , PS_LM_ADHC_PELG_VW D WHERE A.LM_PERSON_ID = C.LM_PERSON_ID AND C.LM_ACTIVE='Y' AND A.LM_PERSON_ID = D.LM_PERSON_ID AND A.LM_ADHC_LRN_ID = D.LM_ADHC_LRN_ID

  • Related Language Record for LM_MGR_ADH_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    2 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    5 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.
    6 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.