EOCM_CAT_SCH_VW

(SQL View)
 Index Back

Catalog Management Search Rec

Catalog Management - This view is used as a search record for the catalog component and will list only the latest catalog versions

SELECT A.SETID , A.EOCM_CATALOG_ID , C.OPRID , D.EOCM_CATALOG_NM , A.EOCM_CAT_VER_ID FROM PS_EOCM_CAT_VER A , PS_EOCM_CATLG_USER C , PS_EOCM_CATALOG D WHERE A.EOCM_CAT_VER_ID IN ( SELECT MAX(B.EOCM_CAT_VER_ID) FROM PS_EOCM_CAT_VER B WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID) AND C.SETID = A.SETID AND C.EOCM_CATALOG_ID = A.EOCM_CATALOG_ID AND C.EOCM_CAT_USER_TYPE <> 'P' AND D.SETID = A.SETID AND D.EOCM_CATALOG_ID = A.EOCM_CATALOG_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 EOCM_CATALOG_NM Character(32) VARCHAR2(32) NOT NULL Catalog Name
5 EOCM_CAT_VER_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Version Id