OPRIDSETIDPrompt Table: SETID_TBL
EOCM_CATALOG_IDEOCM_CAT_VER_IDEOCM_CAT_HIER_IDPrompt Table: EOCM_CATEGORY_H
EOCM_CATEGORY_IDPrompt Table: EOCM_CATEGORY
EOCM_USR_HIR_VW(SQL View) |
Index Back |
|---|---|
User's Catalog Hierarchy ViewReturns the catalog hierarchy/categories available to users. Filter on oprid to find the specific categories for a user. |
| SELECT A.OPRID , A.SETID , A.EOCM_CATALOG_ID , A.EOCM_CAT_VER_ID , B.EOCM_CAT_HIER_ID , D.EOCM_CATEGORY_ID , C.EOCM_CAT_HIER_NM , D.EOCM_PARENT_ID , E.EOCM_CATEGORY_NM , E.EOCM_CATEGORY_CD , E.EOCM_CAT_DESCR FROM %Table(EOCM_USR_CAT_VW) A , %Table(EOCM_CATALOG_CH) B , %Table(EOCM_CATEGORY_H) C , %Table(EOCM_HIERARCHY) D , %Table(EOCM_CATEGORY) E WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND B.EOCM_CAT_HIER_ID = C.EOCM_CAT_HIER_ID AND C.EOCM_CAT_HIER_ID = D.EOCM_CAT_HIER_ID AND D.EOCM_CATEGORY_ID = E.EOCM_CATEGORY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 3 | EOCM_CATALOG_ID |
Character(32) | VARCHAR2(32) NOT NULL | Catalog ID |
| 4 | EOCM_CAT_VER_ID |
Number(10,0) | DECIMAL(10) NOT NULL | Catalog Version Id |
| 5 | EOCM_CAT_HIER_ID |
Character(32) | VARCHAR2(32) NOT NULL |
Catalog Hierarchy ID
Prompt Table: EOCM_CATEGORY_H |
| 6 | EOCM_CATEGORY_ID |
Character(32) | VARCHAR2(32) NOT NULL |
Category ID
Prompt Table: EOCM_CATEGORY |
| 7 | EOCM_CAT_HIER_NM | Character(32) | VARCHAR2(32) NOT NULL | Category Hierarchy Name |
| 8 | EOCM_PARENT_ID | Character(32) | VARCHAR2(32) NOT NULL | Parent Category ID |
| 9 | EOCM_CATEGORY_NM | Character(150) | VARCHAR2(150) NOT NULL | Category Name |
| 10 | EOCM_CATEGORY_CD | Character(32) | VARCHAR2(32) NOT NULL | Category Code |
| 11 | EOCM_CAT_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Cat description field |