SETIDEOCM_CATALOG_IDEOCM_ACCESS_IDEOCM_TP_VER_IDEOCM_CAT_HIER_IDPrompt Table: EOCM_CATEGORY_H
EOCM_BRSESTG_VW(SQL View) |
Index Back |
|---|---|
Browse Categories for stage TPBrowse Categories for stage TP |
| SELECT A.SETID ,A.EOCM_CATALOG_ID ,A.EOCM_ACCESS_ID ,C.EOCM_TP_VER_ID ,B.EOCM_CAT_HIER_ID FROM PS_EOCM_CATALOG_TP A ,PS_EOCM_CATALOG_CH B ,PS_EOCM_TP_VER C WHERE A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.SETID = C.SETID AND A.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND A.EOCM_ACCESS_ID = C.EOCM_ACCESS_ID |
| # | 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_ACCESS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Field for storing the Partner ID |
| 4 | EOCM_TP_VER_ID |
Number(3,0) | SMALLINT NOT NULL | trading partner version id |
| 5 | EOCM_CAT_HIER_ID |
Character(32) | VARCHAR2(32) NOT NULL |
Catalog Hierarchy ID
Prompt Table: EOCM_CATEGORY_H |