OPRIDPrompt Table: EOCM_TPM_USR_VW
SETIDEOCM_CATALOG_IDEOCM_CAT_VER_IDE=Enterprise Catalog User
P=Partner Catalog User
1=Customer Catalog
2=Procurement Catalog
3=Training Catalog
Default Value: 1
N=Step by Step Load
Y=Quick Load
EOCM_WRK_CAT_VW(SQL View) |
Index Back |
|---|---|
User's Catalog ViewReturns the available catalogs for all users. Filter on the user in order to find a specific users catalog. |
| SELECT A.OPRID ,A.SETID ,A.EOCM_CATALOG_ID ,C.EOCM_CAT_VER_ID ,A.EOCM_CAT_USER_TYPE ,B.EOCM_CATALOG_NM ,B.EOCM_CAT_DESCR ,B.EOCM_CATALOG_TYPE ,B.EOCM_CATALOG_DT ,B.EOCM_ROW_NUM ,B.EOCM_OFFER_NUM ,B.EOCM_EXPRESS_CAT ,B.EOCM_QUICK_ITMLOAD ,B.EOCM_MAP_OBJ ,B.EOCM_PSMSTMAP FROM %Table(EOCM_CATLG_USER) A ,%Table(EOCM_CATALOG) B ,%Table(EOCM_CAT_VER) C WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.SETID = C.SETID AND A.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND C.EOCM_CAT_VER_ID = ( SELECT MAX(EOCM_CAT_VER_ID) FROM %Table(EOCM_CAT_VER) D WHERE C.SETID = D.SETID AND C.EOCM_CATALOG_ID = D.EOCM_CATALOG_ID) AND A.EOCM_CAT_USER_TYPE <> 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: EOCM_TPM_USR_VW |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 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_USER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Catalog Management user type
E=Enterprise Catalog User P=Partner Catalog User |
| 6 | EOCM_CATALOG_NM | Character(32) | VARCHAR2(32) NOT NULL | Catalog Name |
| 7 | EOCM_CAT_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Cat description field |
| 8 | EOCM_CATALOG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Catalog Type
1=Customer Catalog 2=Procurement Catalog 3=Training Catalog Default Value: 1 |
| 9 | EOCM_CATALOG_DT | Date(10) | DATE | Catalog Creation Date |
| 10 | EOCM_ROW_NUM | Number(11,0) | DECIMAL(11) NOT NULL | Row Number - This field is used to get the mins, secs as the unique tag for the offer id |
| 11 | EOCM_OFFER_NUM | Number(11,0) | DECIMAL(11) NOT NULL | Offer Number |
| 12 | EOCM_EXPRESS_CAT | Character(1) | VARCHAR2(1) NOT NULL | Express Catalog Flag Type |
| 13 | EOCM_QUICK_ITMLOAD | Character(1) | VARCHAR2(1) NOT NULL |
Quick Item Load Flag
N=Step by Step Load Y=Quick Load |
| 14 | EOCM_MAP_OBJ | Character(15) | VARCHAR2(15) NOT NULL | Catalog Management Map Object |
| 15 | EOCM_PSMSTMAP | Character(1) | VARCHAR2(1) NOT NULL | Use Standard PS Master MAP |