TM_TRANS_<DATA_SOURCE_ID>
For each data source, one table is created dynamically to store the data. TM_DATA_SOURCE.DYNAMIC_TABLE_NAME indicates the name of the table for the given datasource. The table name follows the format TM_TRANS_<DATA_SOURCE_ID> (for example, TM_TRANS_1024). The table will be available only if the match type is approved successfully.
Details
Object type: TABLE
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
TRANS_ID |
NUMBER |
18 |
0 |
No |
Unique transaction ID. |
|
|
RECON_ID |
NUMBER |
18 |
0 |
Yes |
Primary key to TM_RECON |
|
|
JOB_ID |
NUMBER |
18 |
0 |
Yes |
Import Job ID |
|
|
ALERT_ID |
NUMBER |
18 |
0 |
Yes |
Alert ID of the alert associated with a transaction. |
|
|
MATCH_ID |
NUMBER |
18 |
0 |
Yes |
Match Id |
|
|
MATCH_STATUS_ENUM |
NUMBER |
2 |
0 |
Yes |
Match status (same as TM_MATCH MATCH_STATUS_ENUM) |
|
|
EXPORT_JOURNAL_STATUS |
NUMBER |
18 |
0 |
Yes |
Export journal status: 0= closed, Null=open |
|
|
EXPORT_JOURNAL_JOB_ID |
NUMBER |
18 |
0 |
Yes |
Export Journal Job ID |
|
|
IS_EDITED_TRANS |
NUMBER |
1 |
0 |
Yes |
Is transaction edited: 1=Yes |
|
|
C_<DATA_SOURCE_ATTRIBUTE_ID> |
Other user defined attributes in the data source. TM_DATA_SOURCE_ATTRIB.DATA_SOURCE_ATTRIB_ID is used to form the name of this column. Column name follows the format C_<DATA_SOURCE_ATTRIBUTE_ID> (for example, C_20512. Will be available only if the match type is approved successfully. |
|||||
| LAST_ACTION | VARCHAR2 | 300 | Yes |
Last action performed on the transaction |
||
| LAST_UPDATED_BY | NVARCHAR2 | 300 | Yes |
Name of the user who last updated the transaction |
||
| LAST_UPDATED_ON | TIMESTAMP | 6 | Yes |
Date and time when the transaction was last updated |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
|
TM_TRANS_<DATA_SOURCE_ID>_PK |
UNIQUE |
TRANS_ID |
|
TM_TRANS_<DATA_SOURCE_ID>_AD |
NONUNIQUE |
C_<DATA_SOURCE_ATTRIB_ID> (for balancing attribute) |
|
TM_TRANS_<DATA_SOURCE_ID>_MATCH |
NONUNIQUE |
MATCH_ID, 1 |
|
TM_TRANS_<DATA_SOURCE_ID>_RECON |
NONUNIQUE |
RECON_ID |
|
TM_TRANS_<DATA_SOURCE_ID>_EXPORT_JOB |
NONUNIQUE |
EXPORT_JOURNAL_JOB_ID |
|
TM_TRANS_<DATA_SOURCE_ID>_IMPORT_JOB |
NONUNIQUE |
JOB_ID |
|
TM_TRANS_<DATA_SOURCE_ID>_MATCH_STATUS |
NONUNIQUE |
MATCH_STATUS_ENUM, 1 |
|
TM_TRANS_<DATA_SOURCE_ID>_SUMMARIES_U1 |
NONUNIQUE |
RECON_ID, C_<DATA_SOURCE_ATTRIB_ID> (for balancing attribute) |
|
TM_TRANS_<DATA_SOURCE_ID>_MATCH_STAT_IDX |
NONUNIQUE |
RECON_ID, MATCH_STATUS_ENUM |