LM_ACT_CI_LG_VW

(SQL View)
 Index Back

CI/LE View For Activity LE

For selecting Activity LEs made available at the Catalog Item level.

SELECT A.LM_CI_ID , C.EFFDT , B.LM_LE_ID , A.LM_LRNR_GROUP_ID , C.LM_END_EFFDT , B.LM_LRNR_GRP_DESCR , B.LM_ACTIVE , D.LM_LE_LONG_NM FROM PS_LM_CI_SEC_AL_VW A , PS_LM_LG_LE_VW B , PS_LM_CI_ALL_VW C , PS_LM_LE_VW D WHERE A.LM_LRNR_GROUP_ID = B.LM_LRNR_GROUP_ID AND A.LM_CI_ID = C.LM_CI_ID AND A.EFFDT = C.EFFDT AND B.LM_LE_ID = D.LM_LE_ID

  • Related Language Record: LM_ACTCI_LG_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    2 EFFDT Date(10) DATE Effective Date
    3 LM_LE_ID Number(10,0) DECIMAL(10) NOT NULL Learning Environment ID - System Generated number
    4 LM_LRNR_GROUP_ID Number(15,0) DECIMAL(15) NOT NULL Learner Group ID - Business Role/ Student Group ID
    5 LM_END_EFFDT Date(10) DATE The end effective date, automatically maintained, there's a doc on how this works, so read it
    6 LM_LRNR_GRP_DESCR Character(50) VARCHAR2(50) NOT NULL Learner Group Description
    7 LM_ACTIVE Character(1) VARCHAR2(1) NOT NULL Active
    N=Inactive
    Y=Active
    8 LM_LE_LONG_NM Character(60) VARCHAR2(60) NOT NULL Learning Environment Long Name