LM_LGSEC_ADH_VW

(SQL View)
 Index Back

Learner Group Sec Supp View

Learner Group Security Supplemental View

SELECT DISTINCT A.LM_ADHC_ID , A.LM_ADHC_TYPE , B.LM_LRNR_GROUP_ID FROM PS_LM_ADHC_TBL A , PS_LM_ADHC_SEC_TBL B WHERE A.LM_ADHC_ID = B.LM_ADHC_ID

  • Related Language Record: LM_LGSECADH_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ADHC_ID Number(10,0) DECIMAL(10) NOT NULL Adhoc Id
    2 LM_ADHC_TYPE Character(30) VARCHAR2(30) NOT NULL Type
    3 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID