ZCQ_BT_CLNS_RSLTS
ZCQ_BT_CLNS_RSLTS stores the pair of matching records along with the Group ID
Details
-
Schema: FUSION
-
Object owner: ZCQ
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BT_SUMMARY_ID | NUMBER | 18 | Yes | BT_SUMMARY_ID | |
| LOCATION_ID | NUMBER | 18 | Yes | LOCATION_ID | |
| INTF_LOC_ID | NUMBER | 18 | INTF_LOC_ID | ||
| CLEANSE_MODE | VARCHAR2 | 60 | CLEANSE_MODE | ||
| VERIFIED | VARCHAR2 | 1 | Whether the result produced was classed as verified according to the configuration of the process and the resultant verification code. Valid values are Y or N. | ||
| VERIFICATION_CODE | VARCHAR2 | 200 | Verification code produced by EDQ-AV for the address. Valid values are V,P,U,A,C,R. | ||
| VERIFICATION_DESC | VARCHAR2 | 200 | US English description of the verification code. | ||
| ADDRESS1 | VARCHAR2 | 240 | ADDRESS1 | ||
| ADDRESS2 | VARCHAR2 | 240 | ADDRESS2 | ||
| ADDRESS3 | VARCHAR2 | 240 | ADDRESS3 | ||
| ADDRESS4 | VARCHAR2 | 240 | ADDRESS4 | ||
| CITY | VARCHAR2 | 60 | CITY | ||
| COUNTY | VARCHAR2 | 60 | COUNTY | ||
| STATE | VARCHAR2 | 60 | STATE | ||
| PROVINCE | VARCHAR2 | 60 | PROVINCE | ||
| COUNTRY | VARCHAR2 | 60 | COUNTRY | ||
| COUNTRY_NAME | VARCHAR2 | 200 | Country code returned from EDQ. | ||
| POSTAL_CODE | VARCHAR2 | 60 | POSTAL_CODE | ||
| PROCESS_STATUS_CODE | VARCHAR2 | 60 | PROCESS_STATUS_CODE | ||
| PROCESS_MSG_CODE | VARCHAR2 | 200 | PROCESS_MSG_CODE | ||
| ADDR_ELEMENT_ATTRIBUTE2 | VARCHAR2 | 150 | ADDR_ELEMENT_ATTRIBUTE2 | ||
| ADDR_ELEMENT_ATTRIBUTE3 | VARCHAR2 | 150 | ADDR_ELEMENT_ATTRIBUTE3 | ||
| ADDL_ATTRIBUTE_NUM1 | NUMBER | Additional address information. | |||
| ADDL_ATTRIBUTE_NUM2 | NUMBER | Additional address information. | |||
| ADDL_ATTRIBUTE_NUM3 | NUMBER | Additional address information. | |||
| ADDL_ATTRIBUTE_CHAR1 | VARCHAR2 | 100 | Additional address information. | ||
| ADDL_ATTRIBUTE_CHAR2 | VARCHAR2 | 100 | Additional address information. | ||
| ADDL_ATTRIBUTE_CHAR3 | VARCHAR2 | 100 | Additional address information. | ||
| POSTAL_PLUS4_CODE | VARCHAR2 | 10 | POSTAL_PLUS4_CODE | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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 | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ZCQ_BT_CLNS_RSLTS | zcq_bt_summaries | BT_SUMMARY_ID |