TM_MASTER_STATISTIC_MMP TABLE
This table contains statistics about matches in Transaction Matching.
Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
TM_MASTER_STATISTIC_MMP_PK |
JOB_ID, RECON_TYPE_ID, RECON_ID, MATCH_PROC_ID, DATA_SOURCE_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
COUNT_CONFIRMED |
NUMBER |
22 |
0 |
Yes |
Number of transactions with match status Confirmed |
|
|
COUNT_CONFIRMED_ADJUST |
NUMBER |
22 |
0 |
Yes |
Number of transactions with match status Confirmed Adjust (single side adjustment) |
|
|
COUNT_NEW |
NUMBER |
22 |
0 |
Yes |
Number of transactions with Unmatched status (match status none) |
|
|
COUNT_SUGGESTED |
NUMBER |
22 |
0 |
Yes |
Number of transactions with match status Suggested |
|
|
COUNT_SUGGESTED_ADJUST |
NUMBER |
22 |
0 |
Yes |
Number of transactions with match status Suggested Adjust (single side adjustment) |
|
|
COUNT_SUPPORTED |
NUMBER |
22 |
0 |
Yes |
Number of transactions with match status Supported |
|
|
COUNT_TOTAL |
NUMBER |
22 |
0 |
Yes |
Total number of transactions |
|
|
DATA_SOURCE_ID |
NUMBER |
22 |
0 |
No |
Data source ID (foreign key to TM_DATASOURCE) |
|
|
JOB_ID |
NUMBER |
22 |
0 |
No |
Job ID of the import job |
|
|
MATCH_PROC_ID |
NUMBER |
22 |
0 |
No |
Always query with MATCH_PROC_ID = -1 |
|
|
OBJECT_VERSION_NUMBER |
NUMBER |
22 |
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. |
|
|
RECON_ID |
NUMBER |
22 |
0 |
No |
Reconciliation ID (foreign key to TM_RECON) |
|
|
RECON_TYPE_ID |
NUMBER |
22 |
0 |
No |
Match type ID (foreign key to TM_RECON_TYPE) |
|
|
SOURCE |
NVARCHAR2 |
40 |
Yes |
This column is not used and its value will be empty. |
||
|
STATUS |
NUMBER |
22 |
0 |
Yes |
Always query with STATUS = 1 |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| TM_MASTER_STAT_DS | NONUNIQUE | DATA_SOURCE_ID |
| TM_MASTER_STAT_RECON | NONUNIQUE | RECON_ID |
| TM_MASTER_STAT_SUMMARIES | NONUNIQUE | RECON_ID, DATA_SOURCE_ID |
| TM_MASTER_STATISTIC_MMP_PK | UNIQUE | JOB_ID, RECON_TYPE_ID, RECON_ID, MATCH_PROC_ID, DATA_SOURCE_ID |