EOCM_RULE_IDEOCM_RULE_ORDERE=Exact Match
F=Fuzzy Match
Default Value: E
Default Value: 100
Prompt Table: %RECNAME_EDIT2
EOCM_RULE_CAT(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_EDIT2 |