SC734_CLAIM contains tax service claiming information exported from Fiscal Office CAMA system
Visit: Fiscal Office CAMA Data Downloads
Run Report: SC734_CLAIM


--
-- Structure for table `sc734_tmp`
--

CREATE TABLE IF NOT EXISTS `sc734_tmp` (
  `sc734string` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--------------------------------------------------------------

-- UPLOAD SC734_CLAIM.DAT to /home/YourFolderName/SC734_CLAIM.DAT
-- Run SQL query against database using phpMyAdmin
LOAD DATA LOCAL INFILE '/home/[ YourFolderName ]/SC734_CLAIM.DAT' INTO TABLE `sc734_tmp`;

--------------------------------------------------------------

--
-- Structure for table `sc734_claim`
--

CREATE TABLE IF NOT EXISTS `sc734_claim` (
  `MediaCreateDate` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ParcelID` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Owner1` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Owner2` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MailingName1` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MailingAddressLine1` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MailingAddressLine2` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MailingAddressLine3` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `City` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `StateCode` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ZipCode1` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `ZipCode2` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MortgageCompany` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `LegalDescLines123` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PropertyStreetNumber` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PropertyStreetSuffix1` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PropertyStreetDirection` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PropertyStreetName` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PropertyStreetSuffix2` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `PropertyStreetSuffix3` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AppraisedLandValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `AppraisedBuildingValue` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SuggestedDueDate` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `RecordSeperator` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--------------------------------------------------------------

--
-- Insert sc734_tmp to sc734_claim
--

INSERT INTO `sc734_claim` SELECT SUBSTRING(sc734string,1,11), SUBSTRING(sc734string,12,7), SUBSTRING(sc734string,19,40), SUBSTRING(sc734string,59,40), SUBSTRING(sc734string,99,40), SUBSTRING(sc734string,139,40), SUBSTRING(sc734string,179,40), SUBSTRING(sc734string,219,40), SUBSTRING(sc734string,259,40), SUBSTRING(sc734string,299,2), SUBSTRING(sc734string,301,5), SUBSTRING(sc734string,306,4), SUBSTRING(sc734string,310,6), SUBSTRING(sc734string,316,180), SUBSTRING(sc734string,496,8), SUBSTRING(sc734string,504,6), SUBSTRING(sc734string,510,2), SUBSTRING(sc734string,512,28), SUBSTRING(sc734string,540,4), SUBSTRING(sc734string,544,4), SUBSTRING(sc734string,548,11), SUBSTRING(sc734string,559,11), SUBSTRING(sc734string,570,11), SUBSTRING(sc734string,581,1) from `sc734_tmp`;