TM_MATCH_RULE
This tables stores matching rules.
Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
MATCHRULE_PK |
MATCH_RULE_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
RECON_TYPE_ID |
NUMBER |
18 |
0 |
No |
Foreign Key to TM_RECON_TYPE |
|
|
MATCH_PROC_ID |
NUMBER |
18 |
0 |
No |
Foreign Key to TM_MATCH_PROC |
|
|
MATCH_RULE_ID |
NUMBER |
18 |
0 |
No |
Primary key |
|
|
TEXT_ID |
NVARCHAR2 |
100 |
No |
Text ID of the match rule |
||
|
NAME |
NVARCHAR2 |
100 |
No |
Name of the match rule |
||
|
DESCRIPTION |
NVARCHAR2 |
2000 |
Yes |
Description of the match rule |
||
|
MATCH_STATUS_ENUM |
NUMBER |
2 |
0 |
No |
0=UNUSED, 1=SUGGESTED, 2=CONFIRMED, 3=SUGGESTED_NO_AMBIGUOUS, 4=CONFIRMED_NO_AMBIGUOUS/ |
|
|
MATCH_RULE_TYPE_ENUM |
NUMBER |
2 |
0 |
No |
0=ONE_TO_ONE, 1=ONE_TO_MANY, 2=MANY_TO_ONE, 3=MANY_TO_MANY, 4=ADJUSTMENT, 5=SUPPORT, 6=ONE_TO_MANY_SUBSET, 7=MANY_TO_ONE_SUBSET. |
|
|
MATCH_RULE_EXEC_TYPE_ENUM |
NUMBER |
2 |
0 |
No |
0=Auto, 1=Manual |
|
|
BATCH_SIZE |
NUMBER |
18 | 0 | No | Indicates the Auto Match batch size for the rule. | |
|
SUBSET_MAX_ITERATION |
NUMBER |
18 | 0 | No | Indicates the subset automatch maximum iteration count for the rule | |
|
OBJECT_VERSION_NUMBER |
NUMBER |
9 |
0 |
Yes |
Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
|
|
CREATED_BY |
NVARCHAR2 |
255 |
No |
Who column. Stores the ID of the user who created this row. |
||
|
UPDATED_BY |
NVARCHAR2 |
255 |
Yes |
Who column. Stores the ID of the user who last updated this row. |
||
|
RULE_ORDER |
NUMBER |
4 |
0 |
No |
Rule execution Order |
|
|
CREATE_DATE |
TIMESTAMP(6) |
No |
Who column. Stores the date when this row was created in the database. |
|||
|
UPDATE_DATE |
TIMESTAMP(6) |
Yes |
Who column. Stores the date when this row was last updated. |
|||
|
FROM_DS_FILTER_ID |
NUMBER |
18 |
0 |
Yes |
Source System filter used for matching |
|
|
TO_DS_FILTER_ID |
NUMBER |
18 |
0 |
Yes |
Sub system filter used for matching |
|
|
SOURCE_TO_ADJUST |
NUMBER |
18 |
0 |
Yes |
The source to adjust if the rule has at least one rule condition with "Match With adjustment" |
|
|
ACTIVE |
NUMBER | 1 | 1 | 0 | No | Indicates whether this rule is activated or not. Value is 1 for Active or 0 for Inactive. Default is 1. |
|
SUBSET_DATA_SOURCE_ENUM |
NUMBER | 1 | 1 | 0 | Yes | Stores the enum for source system (0) or subsystem (1) for Many to Many with subset Automatch rule, for the subset side. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
|
MATCHRULE_PK |
UNIQUE |
MATCH_RULE_ID |
|
UNIQUE_MATCHRULE_IDX001 |
UNIQUE |
MATCH_PROC_ID, SYS_NC00015$ |
Foreign Keys
| Name | Foreign Table | Foreign Key Column |
|---|---|---|
|
TM_MATCH_RULE |
TM_RECON_TYPE |
RECON_TYPE_ID |
|
TM_MATCH_RULE |
TM_MATCH_PROC |
MATCH_PROC_ID |