OPRIDSETIDPrompt Table: SETID_TBL
EOCM_CATALOG_ID1=Customer Catalog
2=Procurement Catalog
3=Training Catalog
Default Value: 1
C=Current
P=Production
R=Retired
EOCM_USR_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_CATALOG_NM , C.EOCM_CAT_DESCR , C.EOCM_CATALOG_TYPE , C.EOCM_CATALOG_DT , C.EOCM_ROW_NUM , C.EOCM_OFFER_NUM , D.EOCM_CAT_VER_ID , D.EOCM_CATVER_STATUS FROM %Table(EOCM_CATLG_USER) A , %Table(EOCM_CATALOG) C , %Table(EOCM_CAT_VER) D WHERE A.SETID = C.SETID AND A.EOCM_CATALOG_ID = C.EOCM_CATALOG_ID AND C.SETID= D.SETID AND C.EOCM_CATALOG_ID = D.EOCM_CATALOG_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_CATALOG_NM | Character(32) | VARCHAR2(32) NOT NULL | Catalog Name |
| 5 | EOCM_CAT_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Cat description field |
| 6 | EOCM_CATALOG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Catalog Type
1=Customer Catalog 2=Procurement Catalog 3=Training Catalog Default Value: 1 |
| 7 | EOCM_CATALOG_DT | Date(10) | DATE | Catalog Creation Date |
| 8 | 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 |
| 9 | EOCM_OFFER_NUM | Number(11,0) | DECIMAL(11) NOT NULL | Offer Number |
| 10 | EOCM_CAT_VER_ID | Number(10,0) | DECIMAL(10) NOT NULL | Catalog Version Id |
| 11 | EOCM_CATVER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Catalog version Status
C=Current P=Production R=Retired |