EOCM_CAT_HIER_IDEOCM_CATEGORY_IDEOCM_CTGHIER_VW(SQL View) |
Index Back |
|---|
| SELECT A.EOCM_CAT_HIER_ID , B.EOCM_CATEGORY_ID , B.EOCM_CATEGORY_NM , A.EOCM_PARENT_ID , B.EOCM_CATEGORY_CD FROM PS_EOCM_HIERARCHY A , PS_EOCM_CATEGORY B WHERE A.EOCM_CATEGORY_ID = B.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 | EOCM_CATEGORY_ID |
Character(32) | VARCHAR2(32) NOT NULL | Category ID |
| 3 | EOCM_CATEGORY_NM | Character(150) | VARCHAR2(150) NOT NULL | Category Name |
| 4 | EOCM_PARENT_ID | Character(32) | VARCHAR2(32) NOT NULL | Parent Category ID |
| 5 | EOCM_CATEGORY_CD | Character(32) | VARCHAR2(32) NOT NULL | Category Code |