LM_MGR_ADHC_LVW

(SQL View)
 Index Back

Manager Adhoc Learning Lang

Manager Adhoc Learning Language View

SELECT B.OPRID , B.LM_MANAGER_ID , 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_MGR_SRCH_VW B , PS_LM_PERS_DTL_VW C , PS_LM_ADHC_PELG_VW D WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND 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_ADHC_VW

    • # 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_MANAGER_ID Number(15,0) DECIMAL(15) NOT NULL Manager ID
    3 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    4 LM_ADHC_LRN_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Learning Id
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    7 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.
    8 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.