LM_CI_LA_SRCH

(SQL View)
 Index Back

Catalog Item Search

Used as the search record for LM_CI_CMP

SELECT A1.OPRID , A1.LM_CI_ID , A1.EFFDT , A1.LM_CRSE_CODE , A1.LM_CS_LONG_NM , A1.LM_CS_SHRT_NM , A1.LM_CI_STATUS FROM PS_LM_CI_LA_CUR_VW A1 UNION SELECT B.OPRID , A.LM_CI_ID , A.EFFDT , A.LM_CRSE_CODE , A.LM_CS_LONG_NM , A.LM_CS_SHRT_NM , A.LM_CI_STATUS FROM PS_LM_CI_TBL A , PS_LM_OPRID_LE_VW B , PS_LM_CI_LE_TBL C WHERE A.LM_CI_ID = C.LM_CI_ID AND A.EFFDT = C.EFFDT AND C.LM_LE_ID = B.LM_LE_ID AND A.EFFDT = ( SELECT MIN(D.EFFDT) FROM PS_LM_CI_TBL D WHERE A.LM_CI_ID = D.LM_CI_ID AND D.EFFDT > %CurrentDateIn) AND NOT EXISTS ( SELECT 1 FROM PS_LM_CI_LA_CUR_VW E WHERE A.LM_CI_ID = E.LM_CI_ID)

  • Related Language Record: LM_CI_LA_SCH_LN

    • # 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_CI_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Item ID - System Generated ID Number associated with each Catalog Item
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 LM_CRSE_CODE Character(30) VARCHAR2(30) NOT NULL Course Code - User defined Code
    5 LM_CS_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - Describes the long name of an object
    6 LM_CS_SHRT_NM Character(10) VARCHAR2(10) NOT NULL Short Name - Describes the short name of an object
    7 LM_CI_STATUS Character(3) VARCHAR2(3) NOT NULL Catalog Item Status - A drop down list with values indicating the current status of the learning activity.
    10=Active
    20=Inactive
    40=Pending