ZCQ_BT_MT_CAN_INT
ZCQ_BT_MT_CAN_INT is the batch match table that stores the candidate IDs of the driver records submitted in a batch for matching
Details
-
Schema: FUSION
-
Object owner: ZCQ
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
ZCQ_BT_MT_CAN_INT_PK |
BT_SUMMARY_ID, BT_CHUNK_ID, CANDIDATE, ENTITY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BT_SUMMARY_ID | NUMBER | 18 | Yes | Batch Summary Id of Data Quality Batch Match Process | |
| BT_CHUNK_ID | NUMBER | 18 | Yes | Batch Chunk Id of Data Quality Batch Match Process | |
| CANDIDATE | VARCHAR2 | 1 | Yes | Candidate indicator of Data Quality Batch Match Process | |
| ENTITY_ID | NUMBER | 18 | Yes | Batch Entity Id of Data Quality Batch Match Process | |
| SEQ_ID | NUMBER | 18 | Internal sequence id of the row within a chunk. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCQ_BT_MT_CAN_INT_N1 | Non Unique | Default | BT_SUMMARY_ID, BT_CHUNK_ID, SEQ_ID |
| ZCQ_BT_MT_CAN_INT_U1 | Unique | Default | BT_SUMMARY_ID, BT_CHUNK_ID, CANDIDATE, ENTITY_ID |