LM_ACTCI_LG_LVW

(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 , A.EFFDT , C.LM_LE_ID , A.LM_LRNR_GROUP_ID , B.LANGUAGE_CD , B.LM_LRNR_GRP_DESCR FROM PS_LM_CI_SEC_TBL A , PS_LM_GROUP_LANG B , PS_LM_CI_LE_TBL C WHERE A.LM_LRNR_GROUP_ID = B.LM_LRNR_GROUP_ID AND A.LM_CI_ID = C.LM_CI_ID

  • Related Language Record for LM_ACT_CI_LG_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LM_LRNR_GRP_DESCR Character(50) VARCHAR2(50) NOT NULL Learner Group Description