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

OPTIONS(DIRECT=TRUE)

UNRECOVERABLE LOAD DATA

INFILE	'.HOMES.txt'

BADFILE	'HOMES.bad'

APPEND

INTO TABLE HOMES

(
HOMES_KEY                          	POSITION(001:013)	INTEGER EXTERNAL NULLIF (HOMES_KEY=BLANKS),
HOMES_GRPCD                        	POSITION(014:015)	INTEGER EXTERNAL NULLIF (HOMES_GRPCD=BLANKS),
HOME_A_NUMBER                      	POSITION(016:017)	INTEGER EXTERNAL NULLIF (HOME_A_NUMBER=BLANKS),
HOME_B_KEY                         	POSITION(018:019)	INTEGER EXTERNAL NULLIF (HOME_B_KEY=BLANKS),
HOME_A_CHANGE_FLAG                 	POSITION(020:020)	CHAR,
HOME_A_SITE_FLAG                   	POSITION(021:021)	CHAR,
HOME_A_SITE_VALUE_CODER            	POSITION(022:025)	CHAR,
HOME_A_SITE_VALUE                  	POSITION(026:034)	DECIMAL EXTERNAL NULLIF (HOME_A_SITE_VALUE=blanks),
HOME_A_CURR_VALUE                  	POSITION(035:043)	DECIMAL EXTERNAL NULLIF (HOME_A_CURR_VALUE=blanks),
HOME_A_XFEA_VALUE                  	POSITION(044:052)	DECIMAL EXTERNAL NULLIF (HOME_A_XFEA_VALUE=blanks),
HOME_A_TOTAL_SQFTG                 	POSITION(053:061)	INTEGER EXTERNAL NULLIF (HOME_A_TOTAL_SQFTG=BLANKS),
HOME_A_BEDROOMS                    	POSITION(062:068)	INTEGER EXTERNAL NULLIF (HOME_A_BEDROOMS=BLANKS),
HOME_A_BATHS                       	POSITION(069:073)	INTEGER EXTERNAL NULLIF (HOME_A_BATHS=BLANKS),
HOME_A_HALF_BATHS                  	POSITION(074:078)	INTEGER EXTERNAL NULLIF (HOME_A_HALF_BATHS=BLANKS),
HOME_A_UNITS                       	POSITION(079:083)	INTEGER EXTERNAL NULLIF (HOME_A_UNITS=BLANKS),
HOME_A_FLOORS                      	POSITION(084:085)	INTEGER EXTERNAL NULLIF (HOME_A_FLOORS=BLANKS),
HOME_B_CHANGE_FLAG                 	POSITION(086:086)	CHAR,
HOME_B_CODE                        	POSITION(087:087)	CHAR,
HOME_B_ADD_SQFTG_FLAG              	POSITION(088:088)	CHAR,
HOME_B_VALUE                       	POSITION(089:097)	INTEGER EXTERNAL NULLIF (HOME_B_VALUE=BLANKS),
HOME_B_ITEMS                       	POSITION(098:102)	DECIMAL EXTERNAL ":HOME_B_ITEMS/100",
HOME_B_SPECIAL                     	POSITION(103:109)	DECIMAL EXTERNAL ":HOME_B_SPECIAL/1000",
HOME_B_TOTAL_SQFTG                 	POSITION(110:118)	INTEGER EXTERNAL NULLIF (HOME_B_TOTAL_SQFTG=BLANKS),
HOME_B_PTS_GRADE                   	POSITION(119:121)	DECIMAL EXTERNAL NULLIF (HOME_B_PTS_GRADE=blanks),
HOME_B_GRADE                       	POSITION(122:124)	DECIMAL EXTERNAL NULLIF (HOME_B_GRADE=blanks),
HOME_B_ADDITION                    	POSITION(125:134)	CHAR,
HOMES_X_DISTRICT                   	POSITION(135:136)	INTEGER EXTERNAL NULLIF (HOMES_X_DISTRICT=BLANKS),
HOME_B_NC_FLAG                     	POSITION(137:137)	CHAR,
HOME_B_NC_NEW                      	POSITION(138:146)	INTEGER EXTERNAL NULLIF (HOME_B_NC_NEW=BLANKS),
HOME_B_NC_ADD                      	POSITION(147:155)	INTEGER EXTERNAL NULLIF (HOME_B_NC_ADD=BLANKS),
HOME_B_NC_DEMO                     	POSITION(156:164)	INTEGER EXTERNAL NULLIF (HOME_B_NC_DEMO=BLANKS),
HOME_B_REAPPRAISAL                 	POSITION(165:173)	INTEGER EXTERNAL NULLIF (HOME_B_REAPPRAISAL=BLANKS)
)