OWNER Control File
Table - Sorted Table - Copybook - Control File - Create Table - Sorted Create Table - Row Size - Back To Table Index

---
---   SQL*Loader Control File For OWNER Table
---   Created on: 23-MAY-2020 3:50 PM
---   Created by: +1Copybook (C)
---

OPTIONS(DIRECT=TRUE)

UNRECOVERABLE LOAD DATA

INFILE	'.OWNER.txt'

BADFILE	'OWNER.bad'

APPEND

INTO TABLE OWNER

(
OWNER_PROP_KEY                     	POSITION(001:015)	INTEGER EXTERNAL NULLIF (OWNER_PROP_KEY=BLANKS),
OWNER_PROP_OWNER_NAME              	POSITION(016:048)	CHAR,
OWNER_PROP_ADDRESS_MAILING1        	POSITION(049:081)	CHAR,
OWNER_PROP_ADDRESS_MAILING2        	POSITION(082:114)	CHAR,
OWNER_PROP_ADDRESS_MAILING3        	POSITION(115:147)	CHAR,
OWNER_PROP_ADDRESS_MAILING4        	POSITION(148:180)	CHAR,
OWNER_PROP_ADDRESS_PROPERTY        	POSITION(181:213)	CHAR,
OWNER_SUBDIVISION_NAME             	POSITION(214:263)	CHAR,
OWNER_PROP_MILLAGE                 	POSITION(264:267)	INTEGER EXTERNAL NULLIF (OWNER_PROP_MILLAGE=BLANKS),
OWNER_PROP_INSPECT_DATE_MONTH      	POSITION(268:269)	INTEGER EXTERNAL NULLIF (OWNER_PROP_INSPECT_DATE_MONTH=BLANKS),
OWNER_PROP_INSPECT_DATE_YEAR       	POSITION(270:273)	INTEGER EXTERNAL NULLIF (OWNER_PROP_INSPECT_DATE_YEAR=BLANKS),
OWNER_PROP_CLUC_CODE               	POSITION(274:277)	CHAR,
OWNER_PROP_SLUC_CODE               	POSITION(278:281)	CHAR,
OWNER_PROP_YEAR_BUILT              	POSITION(282:285)	INTEGER EXTERNAL NULLIF (OWNER_PROP_YEAR_BUILT=BLANKS),
OWNER_PROP_CONDO_UNIT              	POSITION(286:291)	CHAR,
OWNER_PROP_LOT_SIZE                	POSITION(292:306)	CHAR,
OWNER_PROP_CHANGE_DATE             	POSITION(307:314)	INTEGER EXTERNAL NULLIF (OWNER_PROP_CHANGE_DATE=BLANKS),
OWNER_PROP_ASSMT_YEAR              	POSITION(315:318)	INTEGER EXTERNAL NULLIF (OWNER_PROP_ASSMT_YEAR=BLANKS),
OWNER_PROP_LAND_VALUE              	POSITION(319:329)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAND_VALUE=blanks),
OWNER_PROP_BLDG_VALUE              	POSITION(330:340)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_BLDG_VALUE=blanks),
OWNER_PROP_TOTAL_VALUE             	POSITION(341:351)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_TOTAL_VALUE=blanks),
OWNER_PROP_HEX_VALUE               	POSITION(352:358)	INTEGER EXTERNAL NULLIF (OWNER_PROP_HEX_VALUE=BLANKS),
OWNER_PROP_WIDOW_AMOUNT            	POSITION(359:363)	INTEGER EXTERNAL NULLIF (OWNER_PROP_WIDOW_AMOUNT=BLANKS),
OWNER_PROP_VETERAN_AMOUNT          	POSITION(364:368)	INTEGER EXTERNAL NULLIF (OWNER_PROP_VETERAN_AMOUNT=BLANKS),
OWNER_PROP_DISABLED_AMOUNT         	POSITION(369:373)	INTEGER EXTERNAL NULLIF (OWNER_PROP_DISABLED_AMOUNT=BLANKS),
OWNER_PROP_TOTAL_EXEMPT            	POSITION(374:384)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_TOTAL_EXEMPT=blanks),
OWNER_PROP_TOTAL_NONEXEMPT         	POSITION(385:395)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_TOTAL_NONEXEMPT=blanks),
OWNER_PROP_SENIOR_AMOUNT           	POSITION(396:400)	INTEGER EXTERNAL NULLIF (OWNER_PROP_SENIOR_AMOUNT=BLANKS),
OWNER_PROP_COUNTY_NONEXEMPT        	POSITION(401:411)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_COUNTY_NONEXEMPT=blanks),
OWNER_PROP_SCHOOL_EXEMPT           	POSITION(412:422)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_SCHOOL_EXEMPT=blanks),
OWNER_PROP_SCHOOL_NONEXEMPT        	POSITION(423:433)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_SCHOOL_NONEXEMPT=blanks),
OWNER_PROP_LAST_ASSMT_YEAR         	POSITION(434:437)	INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_ASSMT_YEAR=BLANKS),
OWNER_PROP_LAST_LAND_VALUE         	POSITION(438:448)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_LAND_VALUE=blanks),
OWNER_PROP_LAST_BLDG_VALUE         	POSITION(449:459)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_BLDG_VALUE=blanks),
OWNER_PROP_LAST_TOTAL_VALUE        	POSITION(460:470)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_TOTAL_VALUE=blanks),
OWNER_PROP_LAST_HEX_VALUE          	POSITION(471:477)	INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_HEX_VALUE=BLANKS),
OWNER_PROP_LAST_WIDOW_AMOUNT       	POSITION(478:482)	INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_WIDOW_AMOUNT=BLANKS),
OWNER_PROP_LAST_VETERAN_AMOUNT     	POSITION(483:487)	INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_VETERAN_AMOUNT=BLANKS),
OWNER_PROP_LAST_DISABLE_AMOUNT     	POSITION(488:492)	INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_DISABLE_AMOUNT=BLANKS),
OWNER_PROP_LAST_TOTAL_EXEMPT       	POSITION(493:503)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_TOTAL_EXEMPT=blanks),
OWNER_PROP_LAST_TOTAL_NONEX        	POSITION(504:514)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_TOTAL_NONEX=blanks),
OWNER_PROP_LAST_SENIOR_AMOUNT      	POSITION(515:519)	INTEGER EXTERNAL NULLIF (OWNER_PROP_LAST_SENIOR_AMOUNT=BLANKS),
OWNER_PROP_LAST_COUNTY_NONEX       	POSITION(520:530)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_COUNTY_NONEX=blanks),
OWNER_PROP_LAST_SCHOOL_EXEMPT      	POSITION(531:541)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_SCHOOL_EXEMPT=blanks),
OWNER_PROP_LAST_SCHOOL_NONEX       	POSITION(542:552)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_LAST_SCHOOL_NONEX=blanks),
OWNER_PROP_PREV_ASSMT_YEAR         	POSITION(553:556)	INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_ASSMT_YEAR=BLANKS),
OWNER_PROP_PREV_LAND_VALUE         	POSITION(557:567)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_LAND_VALUE=blanks),
OWNER_PROP_PREV_BLDG_VALUE         	POSITION(568:578)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_BLDG_VALUE=blanks),
OWNER_PROP_PREV_TOTAL_VALUE        	POSITION(579:589)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_TOTAL_VALUE=blanks),
OWNER_PROP_PREV_HEX_VALUE          	POSITION(590:596)	INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_HEX_VALUE=BLANKS),
OWNER_PROP_PREV_WIDOW_AMOUNT       	POSITION(597:601)	INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_WIDOW_AMOUNT=BLANKS),
OWNER_PROP_PREV_VETERAN_AMOUNT     	POSITION(602:606)	INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_VETERAN_AMOUNT=BLANKS),
OWNER_PROP_PREV_DISABLE_AMOUNT     	POSITION(607:611)	INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_DISABLE_AMOUNT=BLANKS),
OWNER_PROP_PREV_TOTAL_EXEMPT       	POSITION(612:622)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_TOTAL_EXEMPT=blanks),
OWNER_PROP_PREV_TOTAL_NONEX        	POSITION(623:633)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_TOTAL_NONEX=blanks),
OWNER_PROP_PREV_SENIOR_AMOUNT      	POSITION(634:638)	INTEGER EXTERNAL NULLIF (OWNER_PROP_PREV_SENIOR_AMOUNT=BLANKS),
OWNER_PROP_PREV_COUNTY_NONEX       	POSITION(639:649)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_COUNTY_NONEX=blanks),
OWNER_PROP_PREV_SCHOOL_EXEMPT      	POSITION(650:660)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_SCHOOL_EXEMPT=blanks),
OWNER_PROP_PREV_SCHOOL_NONEX       	POSITION(661:671)	DECIMAL EXTERNAL NULLIF (OWNER_PROP_PREV_SCHOOL_NONEX=blanks),
OWNER_PROP_PRI_ZONE                	POSITION(672:675)	CHAR,
OWNER_PROP_BLDG_SQFTG              	POSITION(676:684)	INTEGER EXTERNAL NULLIF (OWNER_PROP_BLDG_SQFTG=BLANKS),
OWNER_PROP_XFEATURES               	POSITION(685:685)	INTEGER EXTERNAL NULLIF (OWNER_PROP_XFEATURES=BLANKS),
OWNER_PROP_BEDROOM                 	POSITION(686:691)	INTEGER EXTERNAL NULLIF (OWNER_PROP_BEDROOM=BLANKS),
OWNER_PROP_BATH                    	POSITION(692:696)	INTEGER EXTERNAL NULLIF (OWNER_PROP_BATH=BLANKS),
OWNER_WATER_NUMBER                 	POSITION(697:699)	INTEGER EXTERNAL NULLIF (OWNER_WATER_NUMBER=BLANKS),
OWNER_ROAD_NUMBER                  	POSITION(700:702)	INTEGER EXTERNAL NULLIF (OWNER_ROAD_NUMBER=BLANKS),
OWNER_SEWER_NUMBER                 	POSITION(703:705)	INTEGER EXTERNAL NULLIF (OWNER_SEWER_NUMBER=BLANKS),
OWNER_LITE_NUMBER                  	POSITION(706:708)	INTEGER EXTERNAL NULLIF (OWNER_LITE_NUMBER=BLANKS),
OWNER_LAST_SALES_DATE_MONTH        	POSITION(709:710)	INTEGER EXTERNAL NULLIF (OWNER_LAST_SALES_DATE_MONTH=BLANKS),
OWNER_LAST_SALES_DATE_YEAR         	POSITION(711:714)	INTEGER EXTERNAL NULLIF (OWNER_LAST_SALES_DATE_YEAR=BLANKS),
OWNER_LAST_SALES_AMOUNT            	POSITION(715:723)	INTEGER EXTERNAL NULLIF (OWNER_LAST_SALES_AMOUNT=BLANKS),
OWNER_LAST_SALES_TYPE              	POSITION(724:724)	INTEGER EXTERNAL NULLIF (OWNER_LAST_SALES_TYPE=BLANKS),
OWNER_PREV_SALES_DATE_MONTH        	POSITION(725:726)	INTEGER EXTERNAL NULLIF (OWNER_PREV_SALES_DATE_MONTH=BLANKS),
OWNER_PREV_SALES_DATE_YEAR         	POSITION(727:730)	INTEGER EXTERNAL NULLIF (OWNER_PREV_SALES_DATE_YEAR=BLANKS),
OWNER_PREV_SALES_AMOUNT            	POSITION(731:739)	INTEGER EXTERNAL NULLIF (OWNER_PREV_SALES_AMOUNT=BLANKS),
OWNER_PREV_SALES_TYPE              	POSITION(740:740)	INTEGER EXTERNAL NULLIF (OWNER_PREV_SALES_TYPE=BLANKS),
OWNER_SALES3_DATE_MONTH            	POSITION(741:742)	INTEGER EXTERNAL NULLIF (OWNER_SALES3_DATE_MONTH=BLANKS),
OWNER_SALES3_DATE_YEAR             	POSITION(743:746)	INTEGER EXTERNAL NULLIF (OWNER_SALES3_DATE_YEAR=BLANKS),
OWNER_SALES3_AMOUNT                	POSITION(747:755)	INTEGER EXTERNAL NULLIF (OWNER_SALES3_AMOUNT=BLANKS),
OWNER_SALES3_TYPE                  	POSITION(756:756)	INTEGER EXTERNAL NULLIF (OWNER_SALES3_TYPE=BLANKS),
OWNER_PROP_RESIDENT_YEAR           	POSITION(757:760)	INTEGER EXTERNAL NULLIF (OWNER_PROP_RESIDENT_YEAR=BLANKS),
OWNER_CITY_TAX                     	POSITION(761:775)	DECIMAL EXTERNAL ":OWNER_CITY_TAX/100",
OWNER_COUNTY_TAX                   	POSITION(776:790)	DECIMAL EXTERNAL ":OWNER_COUNTY_TAX/100",
OWNER_WASTE_TAX                    	POSITION(791:805)	DECIMAL EXTERNAL ":OWNER_WASTE_TAX/100",
OWNER_WATER_TAX                    	POSITION(806:820)	DECIMAL EXTERNAL ":OWNER_WATER_TAX/100",
OWNER_ROAD_TAX                     	POSITION(821:835)	DECIMAL EXTERNAL ":OWNER_ROAD_TAX/100",
OWNER_SEWER_TAX                    	POSITION(836:850)	DECIMAL EXTERNAL ":OWNER_SEWER_TAX/100",
OWNER_GROSS_TAX                    	POSITION(851:865)	DECIMAL EXTERNAL ":OWNER_GROSS_TAX/100",
OWNER_REFFOLIO_KEY                 	POSITION(866:880)	INTEGER EXTERNAL NULLIF (OWNER_REFFOLIO_KEY=BLANKS),
OWNER_LAKE_BELT_DISTRICT           	POSITION(881:881)	CHAR,
OWNER_CTY_SENIOR_EXEMP             	POSITION(882:886)	INTEGER EXTERNAL NULLIF (OWNER_CTY_SENIOR_EXEMP=BLANKS),
OWNER_LAST_CTY_SENIOR_EXEMP        	POSITION(887:891)	INTEGER EXTERNAL NULLIF (OWNER_LAST_CTY_SENIOR_EXEMP=BLANKS),
OWNER_PREV_CTY_SENIOR_EXEMP        	POSITION(892:896)	INTEGER EXTERNAL NULLIF (OWNER_PREV_CTY_SENIOR_EXEMP=BLANKS),
OWNER_BLIND                        	POSITION(897:901)	INTEGER EXTERNAL NULLIF (OWNER_BLIND=BLANKS),
OWNER_LAST_BLIND                   	POSITION(902:906)	INTEGER EXTERNAL NULLIF (OWNER_LAST_BLIND=BLANKS),
OWNER_PREV_BLIND                   	POSITION(907:911)	INTEGER EXTERNAL NULLIF (OWNER_PREV_BLIND=BLANKS),
OWNER_NO_XFEA_LINES                	POSITION(912:913)	INTEGER EXTERNAL NULLIF (OWNER_NO_XFEA_LINES=BLANKS),
OWNER_NO_LEGAL_LINES               	POSITION(914:915)	INTEGER EXTERNAL NULLIF (OWNER_NO_LEGAL_LINES=BLANKS),
OWNER_BLDG_NUMBER_1                	POSITION(916:917)	INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_1=BLANKS),
OWNER_XFEA_LINE_NO_1               	POSITION(918:919)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_1=BLANKS),
OWNER_XFEA_PRICE_CODE_1            	POSITION(920:922)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_1=BLANKS),
OWNER_XFEA_UNIT_AREA_1             	POSITION(923:931)	DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_1/100",
OWNER_XFEA_ADDED_1                 	POSITION(932:940)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_1=BLANKS),
OWNER_XFEA_DESCR_1                 	POSITION(941:955)	CHAR,
OWNER_FILLER1_1_001                	POSITION(956:956)	CHAR,
OWNER_BLDG_NUMBER_2                	POSITION(957:958)	INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_2=BLANKS),
OWNER_XFEA_LINE_NO_2               	POSITION(959:960)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_2=BLANKS),
OWNER_XFEA_PRICE_CODE_2            	POSITION(961:963)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_2=BLANKS),
OWNER_XFEA_UNIT_AREA_2             	POSITION(964:972)	DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_2/100",
OWNER_XFEA_ADDED_2                 	POSITION(973:981)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_2=BLANKS),
OWNER_XFEA_DESCR_2                 	POSITION(982:996)	CHAR,
OWNER_FILLER1_2_002                	POSITION(997:997)	CHAR,
OWNER_BLDG_NUMBER_3                	POSITION(998:999)	INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_3=BLANKS),
OWNER_XFEA_LINE_NO_3               	POSITION(1000:1001)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_3=BLANKS),
OWNER_XFEA_PRICE_CODE_3            	POSITION(1002:1004)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_3=BLANKS),
OWNER_XFEA_UNIT_AREA_3             	POSITION(1005:1013)	DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_3/100",
OWNER_XFEA_ADDED_3                 	POSITION(1014:1022)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_3=BLANKS),
OWNER_XFEA_DESCR_3                 	POSITION(1023:1037)	CHAR,
OWNER_FILLER1_3_003                	POSITION(1038:1038)	CHAR,
OWNER_BLDG_NUMBER_4                	POSITION(1039:1040)	INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_4=BLANKS),
OWNER_XFEA_LINE_NO_4               	POSITION(1041:1042)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_4=BLANKS),
OWNER_XFEA_PRICE_CODE_4            	POSITION(1043:1045)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_4=BLANKS),
OWNER_XFEA_UNIT_AREA_4             	POSITION(1046:1054)	DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_4/100",
OWNER_XFEA_ADDED_4                 	POSITION(1055:1063)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_4=BLANKS),
OWNER_XFEA_DESCR_4                 	POSITION(1064:1078)	CHAR,
OWNER_FILLER1_4_004                	POSITION(1079:1079)	CHAR,
OWNER_BLDG_NUMBER_5                	POSITION(1080:1081)	INTEGER EXTERNAL NULLIF (OWNER_BLDG_NUMBER_5=BLANKS),
OWNER_XFEA_LINE_NO_5               	POSITION(1082:1083)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_LINE_NO_5=BLANKS),
OWNER_XFEA_PRICE_CODE_5            	POSITION(1084:1086)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_PRICE_CODE_5=BLANKS),
OWNER_XFEA_UNIT_AREA_5             	POSITION(1087:1095)	DECIMAL EXTERNAL ":OWNER_XFEA_UNIT_AREA_5/100",
OWNER_XFEA_ADDED_5                 	POSITION(1096:1104)	INTEGER EXTERNAL NULLIF (OWNER_XFEA_ADDED_5=BLANKS),
OWNER_XFEA_DESCR_5                 	POSITION(1105:1119)	CHAR,
OWNER_FILLER1_5_005                	POSITION(1120:1120)	CHAR,
OWNER_LEGAL_DESCR_1                	POSITION(1121:1153)	CHAR,
OWNER_LEGAL_DESCR_2                	POSITION(1154:1186)	CHAR,
OWNER_LEGAL_DESCR_3                	POSITION(1187:1219)	CHAR,
OWNER_LEGAL_DESCR_4                	POSITION(1220:1252)	CHAR,
OWNER_LEGAL_DESCR_5                	POSITION(1253:1285)	CHAR,
OWNER_FILLER2_006                  	POSITION(1286:1286)	CHAR
)
To Top - Print - copybook.txt

Output Generated By +1Copybook From +1 Software Engineering LLC.
Created on: 23-MAY-2020 03:50 PM