SC720_DELQ contains the most current delinquent information exported from the Fiscal Office CAMA system

---

Visit: Fiscal Office CAMA Data Downloads

---

Run Report: SC720_DELQ

---

--
-- Table structure for table `sc720_tmp`
--

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

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

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

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

--
-- Table structure for table `sc720_delq`
--

CREATE TABLE IF NOT EXISTS `sc720_delq` (
  `MediaCreateDate` varchar(45) DEFAULT NULL,
  `ParcelID` varchar(45) DEFAULT NULL,
  `OwnerName` varchar(45) DEFAULT NULL,
  `OwnerAddress` varchar(45) DEFAULT NULL,
  `OwnerCity` varchar(45) DEFAULT NULL,
  `OwnerState` varchar(45) DEFAULT NULL,
  `OwnerZip1` varchar(45) DEFAULT NULL,
  `OwnerZip2` varchar(45) DEFAULT NULL,
  `TaxBillMailStreet` varchar(45) DEFAULT NULL,
  `TaxBillCity` varchar(45) DEFAULT NULL,
  `TaxBillState` varchar(45) DEFAULT NULL,
  `TaxBillZip1` varchar(45) DEFAULT NULL,
  `TaxBillZip2` varchar(45) DEFAULT NULL,
  `PropertyStreet` varchar(45) DEFAULT NULL,
  `LandUseCode` varchar(45) DEFAULT NULL,
  `CertifiedDelqYear` varchar(45) DEFAULT NULL,
  `LegalDescription1` varchar(45) DEFAULT NULL,
  `LegalDescription2` varchar(45) DEFAULT NULL,
  `LegalDescription3` varchar(45) DEFAULT NULL,
  `RealEstateDelqAmount` varchar(45) DEFAULT NULL,
  `TaxableValue` varchar(45) DEFAULT NULL,
  `DistrictNumber` varchar(45) DEFAULT NULL,
  `DistrictName` varchar(45) DEFAULT NULL,
  `InternalUseOnly` varchar(45) DEFAULT NULL,
  `RecordSeperator` varchar(45) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Insert sc720_tmp to sc720_DELQ
--

INSERT INTO `sc720_delq` SELECT SUBSTRING(sc720string,1,11), SUBSTRING(sc720string,12,7), SUBSTRING(sc720string,19,40), SUBSTRING(sc720string,59,40), SUBSTRING(sc720string,99,20), SUBSTRING(sc720string,119,5), SUBSTRING(sc720string,124,5), SUBSTRING(sc720string,129,4), SUBSTRING(sc720string,133,40), SUBSTRING(sc720string,173,20), SUBSTRING(sc720string,193,5), SUBSTRING(sc720string,198,5), SUBSTRING(sc720string,203,4), SUBSTRING(sc720string,207,40), SUBSTRING(sc720string,247,3), SUBSTRING(sc720string,250,4), SUBSTRING(sc720string,254,40), SUBSTRING(sc720string,294,40), SUBSTRING(sc720string,334,40), SUBSTRING(sc720string,374,12), SUBSTRING(sc720string,386,11), SUBSTRING(sc720string,397,2), SUBSTRING(sc720string,399,20), SUBSTRING(sc720string,419,6), SUBSTRING(sc720string,425) from `sc720_tmp`;