LM_LE_LG1_VW

(SQL View)
 Index Back

LG with LE view

Used for showing only the Learner Groups that are specific to the LE that is in the scroll.

SELECT B.LM_ACT_ID , A.LM_LRNR_GROUP_ID , A.LM_LRNR_GRP_DESCR , A.LM_LRNR_GRP_SDESCR , A.LM_OWNER_ID FROM PS_LM_LRNR_GROUPS A , ps_lm_act B , PS_LM_CI_SEC_TBL C , ps_lm_act_le D WHERE B.lm_ci_id = C.lm_ci_id AND B.lm_act_id = D.lm_act_id AND D.lm_le_id = A.lm_le_id AND A.lm_lrnr_group_id = C.lm_lrnr_group_id AND A.LM_LG_TYPE <> 'X' AND A.LM_ACTIVE = 'Y' UNION SELECT DISTINCT G.LM_ACT_ID , F.LM_LRNR_GROUP_ID , F.LM_LRNR_GRP_DESCR , F.LM_LRNR_GRP_SDESCR , F.LM_OWNER_ID FROM PS_LM_LRNR_GROUPS F , ps_lm_act G , PS_LM_CI_SEC_TBL H , ps_lm_act_le I WHERE G.lm_ci_id = H.lm_ci_id AND G.lm_act_id = I.lm_act_id AND I.lm_le_id = F.lm_le_id AND F.LM_ACTIVE = 'Y' AND %NumToChar(F.lm_lrnr_group_id) IN ( SELECT DISTINCT E.lm_criteria_value FROM PS_LM_LRNR_GROUPS A , ps_lm_act B , PS_LM_CI_SEC_TBL C , ps_lm_act_le D , ps_lm_groups_crit E WHERE B.lm_ci_id = C.lm_ci_id AND B.lm_act_id = D.lm_act_id AND D.lm_le_id = A.lm_le_id AND A.lm_lrnr_group_id = C.lm_lrnr_group_id AND A.LM_LG_TYPE = 'X' AND A.lm_lrnr_group_id = E.lm_lrnr_group_id AND B.lm_act_id = G.lm_act_id)

  • Related Language Record: LM_LE_LG1_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    2 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID
    3 LM_LRNR_GRP_DESCR Character(50) VARCHAR2(50) NOT NULL Learner Group Description
    4 LM_LRNR_GRP_SDESCR Character(10) VARCHAR2(10) NOT NULL Learner group - Description
    5 LM_OWNER_ID Number(15,0) DECIMAL(15) NOT NULL Owner ID