EOCM_RULE_IDEOCM_RULE_ORDERE=Exact Match
F=Fuzzy Match
Default Value: E
Default Value: 100
Prompt Table: %RECNAME_EDIT
A=AND
E=Exact Match
F=Fuzzy Match
Default Value: E
Prompt Table: %EDITTABLE
EOCM_RULE_OFFER(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCM_RULE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Categorization Rule ID |
| 2 | EOCM_RULE_ORDER |
Number(3,0) | SMALLINT NOT NULL | Categorization Rule Priority Order |
| 3 | EOCM_CAT_MATCH | Character(1) | VARCHAR2(1) NOT NULL |
Categorization Match choice exact/fuzzy
E=Exact Match F=Fuzzy Match Default Value: E |
| 4 | EOCM_THRESHOLD | Number(3,0) | SMALLINT NOT NULL |
Threshold for the fuzzy match
Default Value: 100 |
| 5 | EOCM_TARGET_COL_NM | Character(64) | VARCHAR2(64) NOT NULL |
Target Column for Categorization
Prompt Table: %RECNAME_EDIT |
| 6 | EOCM_OPERATOR | Character(1) | VARCHAR2(1) NOT NULL |
logical operator for rules
A=AND |
| 7 | EOCM_CAT_MATCH2 | Character(1) | VARCHAR2(1) NOT NULL |
Categorization Match choice exact/fuzzy
E=Exact Match F=Fuzzy Match Default Value: E |
| 8 | EOCM_THRESHOLD2 | Number(3,0) | SMALLINT NOT NULL | Threshold for the fuzzy match |
| 9 | EOCM_TARGET_COL_N2 | Character(64) | VARCHAR2(64) NOT NULL |
Target Column for Categorization
Prompt Table: %EDITTABLE |