LM_LGSECADH_LVW

(SQL View)
 Index Back

Learner Group Sec Supp View

Learner Group Security Supplemental View

SELECT DISTINCT A.LM_ADHC_ID , C.LANGUAGE_CD , C.LM_ADHC_TYPE FROM PS_LM_ADHC_TBL A , PS_LM_ADHC_SEC_TBL B , PS_LM_ADHC_LNG_TBL C WHERE A.LM_ADHC_ID = B.LM_ADHC_ID AND B.LM_ADHC_ID = C.LM_ADHC_ID

  • Related Language Record for LM_LGSEC_ADH_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type