EOCM_CATCH_VW

(SQL View)
Index Back

View for hierarchy and cat ver

View for hierarchy and cat ver

SELECT A.SETID ,A.EOCM_CATALOG_ID ,B.EOCM_CAT_VER_ID ,A.EOCM_CAT_HIER_ID FROM PS_EOCM_CATALOG_CH A ,PS_EOCM_CAT_VER B WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND B.EOCM_CATVER_STATUS <> 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
3 EOCM_CAT_VER_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Version Id

Prompt Table: EOCM_CAT_VER_VW

4 EOCM_CAT_HIER_ID Character(32) VARCHAR2(32) NOT NULL Catalog Hierarchy ID

Prompt Table: EOCM_CATEGORY_H