SETIDEOCM_CATALOG_IDEOCM_CATEGORY_IDEOCM_CATEG_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID ,A.EOCM_CATALOG_ID ,B.EOCM_CATEGORY_ID ,C.EOCM_CATEGORY_NM FROM PS_EOCM_CATALOG_CH A ,PS_EOCM_HIERARCHY B ,PS_EOCM_CATEGORY C WHERE A.EOCM_CAT_HIER_ID = B.EOCM_CAT_HIER_ID AND B.EOCM_CATEGORY_ID = C.EOCM_CATEGORY_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_CATEGORY_ID |
Character(32) | VARCHAR2(32) NOT NULL | Category ID |
| 4 | EOCM_CATEGORY_NM | Character(150) | VARCHAR2(150) NOT NULL | Category Name |