LM_ACTCI_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 , B.LM_LG_TYPE FROM PS_LM_CI_SEC_AL_VW A , PS_LM_LRNR_GROUPS B , PS_LM_CI_ALL_VW C 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

  • Related Language Record: LM_ACTCILG_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_LG_TYPE Character(1) VARCHAR2(1) NOT NULL Used to determine if the Learner Group is created using Criteria, Query or Combine Learner Groups.
    C=Criteria Type
    Q=Query Type
    X=Combine Learner Groups