-- Create Table Statement for 'Skip Tracing Transaction'
DROP TABLE IF EXISTS `SKIP_TRACING_TRANSACTION`;
CREATE TABLE `SKIP_TRACING_TRANSACTION` (
	ID bigint(20) NOT NULL,
	MERCHANT_ACCOUNT_CODE int(11) NOT NULL,
	TRANSACTION_CODE varchar,
	FIRST_NAME varchar,
	LAST_NAME varchar,
	MIDDLE_NAME varchar,
	SUFFIX varchar,
	BIRTH_DATE datetime,
	SOCIAL_SECURITY_NUMBER varchar,
	STREET varchar,
	CITY varchar,
	STATE varchar,
	ZIP_CODE varchar,
	PHONE01 varchar,
	PHONE02 varchar,
	PHONE03 varchar,
	PHONE04 varchar,
	PHONE05 varchar,
	PHONE06 varchar,
	PHONE07 varchar,
	PHONE08 varchar,
	PHONE09 varchar,
	PHONE10 varchar,
	SKIP_TRACE_CL varchar,
	RESPONSE_ADDRESS_FIRST_NAME varchar,
	RESPONSE_ADDRESS_LAST_NAME varchar,
	RESPONSE_ADDRESS_MIDDLE_NAME varchar,
	RESPONSE_ADDRESS_SUFFIX varchar,
	RESPONSE_ADDRESS_STREET varchar,
	RESPONSE_ADDRESS_CITY varchar,
	RESPONSE_ADDRESS_STATE varchar,
	RESPONSE_ADDRESS_ZIP_CODE varchar,
	RESPONSE_PHONE1 varchar,
	RESPONSE_PHONE1_FIRST_NAME varchar,
	RESPONSE_PHONE1_LAST_NAME varchar,
	RESPONSE_PHONE1_MIDDLE_NAME varchar,
	RESPONSE_PHONE1_SUFFIX varchar,
	RESPONSE_PHONE1_DUAL_NAME varchar,
	RESPONSE_PHONE2 varchar,
	RESPONSE_PHONE2_FIRST_NAME varchar,
	RESPONSE_PHONE2_LAST_NAME varchar,
	RESPONSE_PHONE2_MIDDLE_NAME varchar,
	RESPONSE_PHONE2_SUFFIX varchar,
	RESPONSE_PHONE2_DUAL_NAME varchar,
	SUB_BATCH_FK bigint(20),
	BATCH_FK bigint(20),
	CUSTOMER_ACCOUNT_CODE varchar,
	RESPONSE_DEATH_DATE datetime,
	LN_SKIP_TRACING_TRANSACTION_FK bigint(20),
	PRIMARY KEY (ID)
) ENGINE=InnoDB;