LM_ACT_CI_ML_VW

(SQL View)
 Index Back

Mandatory Class view

Mandatory class view

SELECT A.LM_ACT_CD , A.LM_ACT_ID , A.LM_CI_ID , A.LM_ACT_STATUS , A.LM_CS_LONG_NM , A.LM_CS_DESCR FROM PS_LM_ACT_CI_VW A WHERE A.LM_ACT_STATUS = '1' AND EXISTS ( SELECT 'X' FROM PS_LM_ACT_ML B WHERE A.LM_ACT_ID=B.LM_ACT_ID AND NOT (LM_LRNR_GROUP_ID=0 AND LM_PERSON_ID=0))

  • Related Language Record: LM_ACT_CIML_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_ACT_CD Character(30) VARCHAR2(30) NOT NULL Activity Code
    2 LM_ACT_ID Number(10,0) DECIMAL(10) NOT NULL Activity ID
    3 LM_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    4 LM_ACT_STATUS Character(1) VARCHAR2(1) NOT NULL Activity Status
    1=Active
    2=Inactive
    3=Closed
    4=Pending
    5=Concluded
    5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    6 LM_CS_DESCR Character(254) VARCHAR2(254) NOT NULL Description - Describes an object with further detail