EOCM_GLOBAL_VW

(SQL View)
Index Back

SELECT C.EOCM_CAT_HIER_ID , A.SETID , A.EOCM_CATEGORY_ID , D.EOCM_CATEGORY_NM , A.EOCM_CATALOG_ID , A.EOCM_OFFER_ID , B.EOCM_OFFER_NM FROM PS_EOCM_OFFER_CAT A , PS_EOCM_OFFER_TBL B , PS_EOCM_HIERARCHY C , PS_EOCM_CATEGORY D WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.EOCM_OFFER_ID = B.EOCM_OFFER_ID AND A.EOCM_CATEGORY_ID = C.EOCM_CATEGORY_ID AND A.EOCM_CATEGORY_ID = D.EOCM_CATEGORY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOCM_CAT_HIER_ID Character(32) VARCHAR2(32) NOT NULL Catalog Hierarchy ID
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 EOCM_CATEGORY_ID Character(32) VARCHAR2(32) NOT NULL Category ID

Prompt Table: EOCM_CATEGORY

4 EOCM_CATEGORY_NM Character(150) VARCHAR2(150) NOT NULL Category Name
5 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
6 EOCM_OFFER_ID Character(32) VARCHAR2(32) NOT NULL Offering ID
7 EOCM_OFFER_NM Character(64) VARCHAR2(64) NOT NULL Offer Name