SETIDEOCM_CATALOG_IDEOCM_CAT_VER_IDPrompt Table: EOCM_CAT_VER_VW
EOCM_ACCESS_IDEOCM_CAT_HIER_IDPrompt Table: EOCM_CATEGORY_H
EOCM_BROWSEC_VW(SQL View) |
Index Back |
|---|---|
Browse CategoriesBrowse Categories |
| SELECT A.SETID ,A.EOCM_CATALOG_ID ,C.EOCM_CAT_VER_ID ,A.EOCM_ACCESS_ID ,B.EOCM_CAT_HIER_ID FROM PS_EOCM_ACCESS_TP A ,PS_EOCM_CATALOG_CH B ,PS_EOCM_CAT_VER C WHERE A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND B.SETID = C.SETID AND B.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND C.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_ACCESS_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Field for storing the Partner ID |
| 5 | EOCM_CAT_HIER_ID |
Character(32) | VARCHAR2(32) NOT NULL |
Catalog Hierarchy ID
Prompt Table: EOCM_CATEGORY_H |