EOCM_CAT_AET(SQL Table) |
Index Back |
|---|---|
State Record CategorizationState Record Categorization |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | EOCM_ROW_ID | Number(10,0) | DECIMAL(10) NOT NULL | Row ID |
| 5 | EOCM_CATALOG_ID | Character(32) | VARCHAR2(32) NOT NULL | Catalog ID |
| 6 | EOCM_ACCESS_ID | Number(15,0) | DECIMAL(15) NOT NULL | Field for storing the Partner ID |
| 7 | EOCM_TP_VER_ID | Number(3,0) | SMALLINT NOT NULL | trading partner version id |
| 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_ROW_STR | Character(32) | VARCHAR2(32) NOT NULL | |
| 10 | EOCM_OFFER_NUM | Number(11,0) | DECIMAL(11) NOT NULL | Offer Number |
| 11 | EOCM_OFFER_STR | Character(32) | VARCHAR2(32) NOT NULL | |
| 12 | EOCM_OFFER_NM | Character(64) | VARCHAR2(64) NOT NULL | Offer Name |
| 13 | CREATED_DTTM | DateTime(26) | TIMESTAMP | Created Date and time |
| 14 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 15 | EOCM_LOAD_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Load option Incremental/destructive
0=Full Load 1=Incremental Update |
| 16 | EOCM_CATALOG_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Catalog Type
1=Customer Catalog 2=Procurement Catalog 3=Training Catalog |
| 17 | EOCM_RULE_ID | Character(20) | VARCHAR2(20) NOT NULL | Categorization Rule ID |
| 18 | EOCM_TRANSLATE_ID | Character(20) | VARCHAR2(20) NOT NULL | for translate id |
| 19 | EOCM_COUNT | Number(9,0) | DECIMAL(9) NOT NULL | for AE program to get the count of the remaining rows after CZATION |
| 20 | EOCM_RULE_ORDER | Number(3,0) | SMALLINT NOT NULL | Categorization Rule Priority Order |
| 21 | EOCM_CAT_MATCH | Character(1) | VARCHAR2(1) NOT NULL |
Categorization Match choice exact/fuzzy
E=Exact Match F=Fuzzy Match |
| 22 | EOCM_THRESHOLD | Number(3,0) | SMALLINT NOT NULL | Threshold for the fuzzy match |
| 23 | EOCM_TARGET_COL_NM | Character(64) | VARCHAR2(64) NOT NULL | Target Column for Categorization |
| 24 | EOCM_OPERATOR | Character(1) | VARCHAR2(1) NOT NULL |
logical operator for rules
A=AND |
| 25 | EOCM_CAT_MATCH2 | Character(1) | VARCHAR2(1) NOT NULL |
Categorization Match choice exact/fuzzy
E=Exact Match F=Fuzzy Match |
| 26 | EOCM_THRESHOLD2 | Number(3,0) | SMALLINT NOT NULL | Threshold for the fuzzy match |
| 27 | EOCM_TARGET_COL_N2 | Character(64) | VARCHAR2(64) NOT NULL | Target Column for Categorization |
| 28 | EOCM_TARGET_COL | Character(64) | VARCHAR2(64) NOT NULL | Target field for categorization |
| 29 | EOCM_TARGET_COL2 | Character(64) | VARCHAR2(64) NOT NULL | seond column for CZATION |
| 30 | EOCM_SOURCE_CATEG | Character(64) | VARCHAR2(64) NOT NULL | Source category for translation |
| 31 | EOCM_TARGET_CATEG | Character(64) | VARCHAR2(64) NOT NULL | Target Category for translation |
| 32 | EOCM_OFFER_MAPPED | Character(1) | VARCHAR2(1) NOT NULL |
to check whether the catalog offering is mapped
Y/N Table Edit |
| 33 | EOCM_OFFER_GROUP | Character(254) | VARCHAR2(254) NOT NULL | field used in state record for categorization for storing the group by clause based on categorization rules |
| 34 | EOCM_GROUP_WHERE | Character(254) | VARCHAR2(254) NOT NULL | Used in categorization AE program for storing the where clause from the categorization rule |
| 35 | EOCM_ITSJOB | Character(1) | VARCHAR2(1) NOT NULL |
AE Running as a JOB
A=Approval job process C=Complete Load job process L=Load job process N=Not a job process Default Value: N |
| 36 | EOCM_TP_VER_STATE | Character(1) | VARCHAR2(1) NOT NULL |
TP version state (loaded, categorized, etc)
A=Pending Approval B=In Progress C=Categorized D=Error E=Error F=Error K=Error L=Loaded N=Created P=Production S=Staged W=Waiting Review X=Purchasing/Errors Z=Purchasing |