LM_CURR_ACT_LVW

(SQL View)
 Index Back

Learner Activity Rel Lang view

Related Language view of learner's current activities. The related lanugage tables used are: PS_LM_ENRLMT_VW view of table PS_LM_ENRLMT. This uses related language PS_LM_ENRLMT_LANG. Key is LM_ENRLMT_ID PS_LM_CI_VW2 uses related language PS_LM_CI_VW_LNG2 Key is LM_CI_ID PS_LM_ACT_PLN_VW uses related language PS_LM_ACT_PLN_LVW Key is LM_ACT_ID Build sequence numbers for the following views are; LM_OPRID_ID_VW.... 1 LM_ENRLMT_VW ..... 10 LM_ENRLMT_LANG ... N/A LM_CI_VW2 ........ 10 LM_CI_VW_LNG2 .... 10 LM_ACT_PLN_VW .... 60 LM_ACT_PLN_LVW ... 60

SELECT OP1.OPRID , EN1.LM_PERSON_ID , EN1.LM_ENRLMT_ID , ENL1.LANGUAGE_CD , CIL1.LM_CS_LONG_NM , ACL1.LM_DM_LONG_NM FROM PS_LM_OPRID_ID_VW OP1 , PS_LM_ENRLMT_VW EN1 , PS_LM_ENRLMT_LANG ENL1 , PS_LM_CI_VW2 CI1 , PS_LM_CI_VW_LNG2 CIL1 , PS_LM_ACT_PLN_VW AC1 , PS_LM_ACT_PLN_LVW ACL1 WHERE OP1.LM_PERSON_ID = EN1.LM_PERSON_ID AND EN1.LM_CI_ID = CI1.LM_CI_ID AND EN1.LM_ACT_ID = AC1.LM_ACT_ID AND EN1.LM_ENRLMT_ID = ENL1.LM_ENRLMT_ID AND CI1.LM_CI_ID = CIL1.LM_CI_ID AND AC1.LM_ACT_ID = ACL1.LM_ACT_ID AND ENL1.LANGUAGE_CD = CIL1.LANGUAGE_CD AND ENL1.LANGUAGE_CD = ACL1.LANGUAGE_CD UNION SELECT OP2.OPRID , EN2.LM_PERSON_ID , EN2.LM_ENRLMT_ID , ENL2.LANGUAGE_CD , CI2.LM_CS_LONG_NM , ACL2.LM_DM_LONG_NM FROM PS_LM_OPRID_ID_VW OP2 , PS_LM_ENRLMT_VW EN2 , PS_LM_ENRLMT_LANG ENL2 , PS_LM_CI_VW2 CI2 , PS_LM_ACT_PLN_VW AC2 , PS_LM_ACT_PLN_LVW ACL2 WHERE OP2.LM_PERSON_ID = EN2.LM_PERSON_ID AND EN2.LM_CI_ID = CI2.LM_CI_ID AND EN2.LM_ACT_ID = AC2.LM_ACT_ID AND EN2.LM_ENRLMT_ID = ENL2.LM_ENRLMT_ID AND NOT EXISTS ( SELECT CIL2.LM_CI_ID FROM PS_LM_CI_VW_LNG2 CIL2 WHERE CI2.LM_CI_ID = CIL2.LM_CI_ID AND ENL2.LANGUAGE_CD = CIL2.LANGUAGE_CD) AND AC2.LM_ACT_ID = ACL2.LM_ACT_ID AND ENL2.LANGUAGE_CD = ACL2.LANGUAGE_CD UNION SELECT OP3.OPRID , EN3.LM_PERSON_ID , EN3.LM_ENRLMT_ID , ENL3.LANGUAGE_CD , CIL3.LM_CS_LONG_NM , AC3.LM_DM_LONG_NM FROM PS_LM_OPRID_ID_VW OP3 , PS_LM_ENRLMT_VW EN3 , PS_LM_ENRLMT_LANG ENL3 , PS_LM_CI_VW2 CI3 , PS_LM_CI_VW_LNG2 CIL3 , PS_LM_ACT_PLN_VW AC3 WHERE OP3.LM_PERSON_ID = EN3.LM_PERSON_ID AND EN3.LM_CI_ID = CI3.LM_CI_ID AND EN3.LM_ACT_ID = AC3.LM_ACT_ID AND EN3.LM_ENRLMT_ID = ENL3.LM_ENRLMT_ID AND CI3.LM_CI_ID = CIL3.LM_CI_ID AND NOT EXISTS ( SELECT ACL3.LM_ACT_ID FROM PS_LM_ACT_PLN_LVW ACL3 WHERE AC3.LM_ACT_ID = ACL3.LM_ACT_ID AND ENL3.LANGUAGE_CD = ACL3.LANGUAGE_CD) AND ENL3.LANGUAGE_CD = CIL3.LANGUAGE_CD UNION SELECT OP4.OPRID , EN4.LM_PERSON_ID , EN4.LM_ENRLMT_ID , ENL4.LANGUAGE_CD , CI4.LM_CS_LONG_NM , AC4.LM_DM_LONG_NM FROM PS_LM_OPRID_ID_VW OP4 , PS_LM_ENRLMT_VW EN4 , PS_LM_ENRLMT_LANG ENL4 , PS_LM_CI_VW2 CI4 , PS_LM_ACT_PLN_VW AC4 WHERE OP4.LM_PERSON_ID = EN4.LM_PERSON_ID AND EN4.LM_CI_ID = CI4.LM_CI_ID AND EN4.LM_ACT_ID = AC4.LM_ACT_ID AND EN4.LM_ENRLMT_ID = ENL4.LM_ENRLMT_ID AND NOT EXISTS ( SELECT CIL4.LM_CI_ID FROM PS_LM_CI_VW_LNG2 CIL4 WHERE CI4.LM_CI_ID = CIL4.LM_CI_ID AND ENL4.LANGUAGE_CD = CIL4.LANGUAGE_CD) AND NOT EXISTS ( SELECT ACL4.LM_ACT_ID FROM PS_LM_ACT_PLN_LVW ACL4 WHERE AC4.LM_ACT_ID = ACL4.LM_ACT_ID AND ENL4.LANGUAGE_CD = ACL4.LANGUAGE_CD) UNION SELECT OP5.OPRID , EN5.LM_PERSON_ID , EN5.LM_ENRLMT_ID , CIL5.LANGUAGE_CD , CIL5.LM_CS_LONG_NM , ACL5.LM_DM_LONG_NM FROM PS_LM_OPRID_ID_VW OP5 , PS_LM_ENRLMT_VW EN5 , PS_LM_CI_VW2 CI5 , PS_LM_CI_VW_LNG2 CIL5 , PS_LM_ACT_PLN_VW AC5 , PS_LM_ACT_PLN_LVW ACL5 WHERE OP5.LM_PERSON_ID = EN5.LM_PERSON_ID AND EN5.LM_CI_ID = CI5.LM_CI_ID AND EN5.LM_ACT_ID = AC5.LM_ACT_ID AND NOT EXISTS ( SELECT ENL5.LM_ENRLMT_ID FROM PS_LM_ENRLMT_LANG ENL5 WHERE EN5.LM_ENRLMT_ID = ENL5.LM_ENRLMT_ID AND CIL5.LANGUAGE_CD = ENL5.LANGUAGE_CD) AND CI5.LM_CI_ID = CIL5.LM_CI_ID AND AC5.LM_ACT_ID = ACL5.LM_ACT_ID AND CIL5.LANGUAGE_CD = ACL5.LANGUAGE_CD UNION SELECT OP6.OPRID , EN6.LM_PERSON_ID , EN6.LM_ENRLMT_ID , ACL6.LANGUAGE_CD , CI6.LM_CS_LONG_NM , ACL6.LM_DM_LONG_NM FROM PS_LM_OPRID_ID_VW OP6 , PS_LM_ENRLMT_VW EN6 , PS_LM_CI_VW2 CI6 , PS_LM_ACT_PLN_VW AC6 , PS_LM_ACT_PLN_LVW ACL6 WHERE OP6.LM_PERSON_ID = EN6.LM_PERSON_ID AND EN6.LM_CI_ID = CI6.LM_CI_ID AND EN6.LM_ACT_ID = AC6.LM_ACT_ID AND NOT EXISTS ( SELECT ENL6.LM_ENRLMT_ID FROM PS_LM_ENRLMT_LANG ENL6 WHERE EN6.LM_ENRLMT_ID = ENL6.LM_ENRLMT_ID AND ACL6.LANGUAGE_CD = ENL6.LANGUAGE_CD) AND NOT EXISTS ( SELECT CIL6.LM_CI_ID FROM PS_LM_CI_VW_LNG2 CIL6 WHERE CI6.LM_CI_ID = CIL6.LM_CI_ID AND ACL6.LANGUAGE_CD = CIL6.LANGUAGE_CD) AND AC6.LM_ACT_ID = ACL6.LM_ACT_ID UNION SELECT OP7.OPRID , EN7.LM_PERSON_ID , EN7.LM_ENRLMT_ID , CIL7.LANGUAGE_CD , CIL7.LM_CS_LONG_NM , AC7.LM_DM_LONG_NM FROM PS_LM_OPRID_ID_VW OP7 , PS_LM_ENRLMT_VW EN7 , PS_LM_CI_VW2 CI7 , PS_LM_CI_VW_LNG2 CIL7 , PS_LM_ACT_PLN_VW AC7 WHERE OP7.LM_PERSON_ID = EN7.LM_PERSON_ID AND EN7.LM_CI_ID = CI7.LM_CI_ID AND EN7.LM_ACT_ID = AC7.LM_ACT_ID AND NOT EXISTS ( SELECT ENL7.LM_ENRLMT_ID FROM PS_LM_ENRLMT_LANG ENL7 WHERE EN7.LM_ENRLMT_ID = ENL7.LM_ENRLMT_ID AND CIL7.LANGUAGE_CD = ENL7.LANGUAGE_CD) AND CI7.LM_CI_ID = CIL7.LM_CI_ID AND NOT EXISTS ( SELECT ACL7.LM_ACT_ID FROM PS_LM_ACT_PLN_LVW ACL7 WHERE AC7.LM_ACT_ID = ACL7.LM_ACT_ID AND CIL7.LANGUAGE_CD = ACL7.LANGUAGE_CD)

  • Related Language Record for LM_CURR_ACTD_VW LM_CUR_ACTD_VW2 LM_MYLRN_ACT_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_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    3 LM_ENRLMT_ID Number(10,0) DECIMAL(10) NOT NULL Enrollment ID
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    6 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type