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

OPTIONS(DIRECT=TRUE)

UNRECOVERABLE LOAD DATA

INFILE	'.LAND.txt'

BADFILE	'LAND.bad'

APPEND

INTO TABLE LAND

(
PROPERX_KEY                        	POSITION(001:013)	INTEGER EXTERNAL NULLIF (PROPERX_KEY=BLANKS),
PROPERX_GRPCD                      	POSITION(014:015)	INTEGER EXTERNAL NULLIF (PROPERX_GRPCD=BLANKS),
PROPERX_DISTRICT                   	POSITION(016:017)	INTEGER EXTERNAL NULLIF (PROPERX_DISTRICT=BLANKS),
LOTTYPE_TYPE_LOT                   	POSITION(018:019)	INTEGER EXTERNAL NULLIF (LOTTYPE_TYPE_LOT=BLANKS),
LOTTYPE_WET_LOT                    	POSITION(020:020)	CHAR,
LOTTYPE_SITE_VALUE                 	POSITION(021:029)	DECIMAL EXTERNAL NULLIF (LOTTYPE_SITE_VALUE=blanks),
PROPERTYPE                         	POSITION(030:030)	CHAR,
PROPER_NBR                         	POSITION(031:032)	CHAR,
O_UNPACKED                         	POSITION(033:062)	CHAR,
PROPER_CODE1                       	POSITION(063:063)	INTEGER EXTERNAL NULLIF (PROPER_CODE1=BLANKS),
PROPER_AMOUNT1                     	POSITION(064:067)	DECIMAL EXTERNAL NULLIF (PROPER_AMOUNT1=blanks),
PROPER_CODE2                       	POSITION(068:068)	INTEGER EXTERNAL NULLIF (PROPER_CODE2=BLANKS),
PROPER_PERCENT2                    	POSITION(069:071)	DECIMAL EXTERNAL ":PROPER_PERCENT2/100",
PROPER_VALUE                       	POSITION(072:080)	DECIMAL EXTERNAL NULLIF (PROPER_VALUE=blanks),
PROPERX_ZONE                       	POSITION(081:084)	CHAR,
PROPER_AGRI_CODE                   	POSITION(085:085)	CHAR,
PROPER_AGRI_YEAR                   	POSITION(086:089)	INTEGER EXTERNAL NULLIF (PROPER_AGRI_YEAR=BLANKS),
PROPER_EXCESS_FLAG                 	POSITION(090:090)	CHAR,
PROPER_EFF_YEAR                    	POSITION(091:094)	INTEGER EXTERNAL NULLIF (PROPER_EFF_YEAR=BLANKS),
PROPER_REAPPRAISAL                 	POSITION(095:103)	DECIMAL EXTERNAL NULLIF (PROPER_REAPPRAISAL=blanks)
)