Field Name CMPCD PCT SECKY UNIT CAT DPRTYP DSC LVAL NDYR NR QTY REL RT RTAPIC RTAPRI SECKY ADNFCT CMK CV HSPCT IMPKY IVAL LOCF VALMET AREA CLS COKY OCC PCT RNK SECKY STHT AREA BC BNAM BS CMK CV DPRAMT DPRPCT EDPR EFFA FDPR HC IVAL LOC MSNC NLS PER RCN RCNLD SECFCT
Table Format: Delimited Ascii
Page 1 of 8
Apprentice Information Systems, Inc Description Commercial improvement record code Commercial improvement record percent Commercial improvement record component key Commercial improvement record unit Commercial lump sums record category Commercial lump sums record depreciation type Commercial lump sums record description Commercial lump sums record lump value Commercial lump sums record newly discovered year Commercial lump sums record net rate Commercial lump sums record quantity Commercial lump sums record remaining life Commercial lump sums record rate Commercial lump sums record rate adjusted percent Commercial lump sums record rate adjusted price Commercial lump sums record section key Commercial master record adjustment factor Commercial master record commercial key Commercial master record cost value Commercial master record homestead percent Commercial master record improvement key Commercial master record income value Commercial master record location factor Commercial master record value method Commercial occupancy record area Commercial occupancy record class Commercial occupancy record occupancy key Commercial occupancy record code Commercial occupancy record percent Commercial occupancy record rank Commercial occupancy record section key Commercial occupancy record story height Commercial section record area Commercial section record base cost Commercial section record business name Commercial section record basic structure Commercial section record commercial key Commercial section record cost value Commercial section record depreciation amount Commercial section record depreciation percent Commercial section record economic depreciation Commercial section record effective age Commercial section record functional depreciation Commercial section record heating cooling Commercial section record income value Commercial section record location Commercial section record ms net cost Commercial section record net lump sums Commercial section record perimeter Commercial section record replacement cost new Commercial section record replacement cost new less depreciation Commercial section record section factor Revision: June 2010
Field Name SECKY ST TOACD UNIT WAL YRBLT ELE SECKY STAT DKEY FKEY TYPE BK DKY DTP GRNTE GRNTO PG PNK PR PTP RESV SDT STA STP VAL HSV IHSPCT IMPKY IMPN IMPTP NHV PNK VALMET ACR ADJ DP1 DP100 DP2 DPAV DPPCT FF FFR FR LNDKY LTQ LVAL MTH NDYR PNK QSEC RR
Revision: June 2010
Description Commercial section record section key Commercial section record stories Commercial section record section number Commercial section record units Commercial section record exterior walls Commercial section record year built Commercial structure record element Commercial structure record section key Commercial structure record status Documents record document key Documents record foreign key Documents record document type Deed record book Deed record deed key Deed record deed type Deed record grantee Deed record grantor Deed record page Deed record parcel key Deed record price Deed record parcel type Deed record reset value Deed record sale date Deed record stamps Deed record parcel key Deed record validation Improvement record homestead value Improvement record income homestead percent Improvement record improvement key Improvement record improvement number Improvement record improvement type Improvement record non homestead value Improvement record parcel key Improvement record valuation method Land record acres Land record adjustment Land record depth 1 Land record depth at 100 percent Land record depth 2 Land record depth average Land record depth percent Land record front figure Land record front foot rate Land record front Land record land key Land record lot quantity Land record land value Land record method Land record newly discovered year Land record parcel key Land record quarter section Land record rear
Field Name RT SC SDP SQF UC ACR ASPH BL CG CONC CVK DIRT GRA LAT LGL LGLSDT LLSRC LNG LSC LSKY LT MKTA NBHC OPN OWNNAM PID PN PNK PTP PVK RNG SCHD SCTY SD SDIR SEC SNUM SNUMS SST SSTP SSTR SUN SUS SZ TIM TOPHL TOPRF TRND TWP UTEL UTGA UTPH
Revision: June 2010
Description Land record rate Land record soil code Land record standard depth Land record square feet Land record use code Parcel record acres Parcel record asphalt street Parcel record block Parcel record GG street Parcel record concrete street Parcel record current value key Parcel record dirt street Parcel record gravel street Parcel record latitude Parcel record legal description Parcel record legal scan date Parcel record lat long source Parcel record longitude Parcel record landscaping Parcel record last sale key Parcel record lot Parcel record market area Parcel record neighborhood code Parcel record old parcel number Parcel record owner name Parcel record payer id Parcel record number Parcel record parcel key Parcel record type Parcel record previous value key Parcel record range Parcel record school district Parcel record site city Parcel record subdivision Parcel record site direction Parcel record section Parcel record site number Parcel record site number suffix Parcel record site state Parcel record site street type Parcel record site street Parcel record site unit number Parcel record site unit number suffix Parcel record site zip Parcel record timber Parcel record topography hl Parcel record topography rf Parcel record trend Parcel record township Parcel record electric Parcel record gas Parcel record phone
Description Parcel record sewer Parcel record water Parcel record exempt History record action History record date History record parcel key Reference record reference parcel key Reference record parcel key Reference record parcel reference key Use code record parcel key Use code record use code Additives record factor Additives record item Additives record length Additives record newly discovered year Additives record processed Additives record quantity Additives record residential key Additives record rate Additives record value Additives record width Adjustments item Adjustments quantity Adjustments residential key Adjustments rate Adjustments sequence Adjustments sub item Improvement detail record adjustment factor Improvement detail record partitioned finished basement Improvement detail record unpartitioned finished basement Improvement detail record unfinished basement Improvement detail record additive total Improvement detail record adjusted base price Improvement detail record adjustment to base Improvement detail record additives less depreciation Improvement detail record adjusted value Improvement detail record base cost Improvement detail record base value Improvement detail record depreciation Improvement detail record final value Improvement detail record grade adjustment Improvement detail record grade plus Improvement detail record calculated homestead value Improvement detail record calculated non homestead value Improvement detail record outbuilding yard improvement total Improvement detail record replacement cost new Improvement detail record replacement cost new less depreciation Improvement detail record story adjustment Improvement detail record total area Improvement detail record total value Improvement detail record effective age Improvement detail record future age
Description Improvement detail record floor cover carpet Improvement detail record ceramic Improvement detail record hardwood parquet Improvement detail record hardwood sheathing Improvement detail record linoleum Improvement detail record none Improvement detail record stone Improvement detail record softwood Improvement detail record future grade adjustment Improvement detail record future grade Improvement detail record foundation Improvement detail record fireplace quality Improvement detail record fireplace quantity Improvement detail record fireplace type Improvement detail record floor structure Improvement detail record grade Improvement detail record grade adjustment Improvement detail record heat and air conditioning Improvement detail record heat air conditioned area Improvement detail record homestead Improvement detail record homestead percent Improvement detail record improvement key Improvement detail record ceiling insulation Improvement detail record floor insulation Improvement detail record wall insulation st Improvement detail record living area 1 floor nd Improvement detail record living area 2 floor Improvement detail record location factor Improvement detail record mobile home flat value Improvement detail record mobile home length Improvement detail record mobile home quality Improvement detail record mobile home width Improvement detail record newly discovered year Improvement detail record occupancy Improvement detail record plumbing full Improvement detail record plumbing half Improvement detail record plumbing rough in Improvement detail record plumbing extra Improvement detail record other roof cover name Improvement detail record other roof cover rate Improvement detail record residential key Improvement detail record type Improvement detail record roof cover Improvement detail record arch roof Improvement detail record dormer roof Improvement detail record flat roof Improvement detail record gable roof Improvement detail record gambrel roof Improvement detail record hip roof Improvement detail record mansard roof Improvement detail record shed roof Improvement detail record special wall type
Page 5 of 8
BDE Export Field List
Apprentice Information Systems, Inc
Table Format: Delimited Ascii
Table Name RESDET RESDET RESDET RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB RESOB SID SID SID SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB SUB TXPYR TXPYR TXPYR TXPYR TXPYR TXPYR VAL VAL VAL
Field Name ST WT YRBLT AGE APLOCFCT CMET DPRTYP FL GR HS LNG NDYR OBYI OBYKY PROF QTY REML RESKY RT VAL WID DST IMPA PNK ASPH CG CONC DIRT GRA LSC NAM RNG SDKY SEC TOPHL TOPRF TRND TWP UTEL UTGA UTPH UTSW UTWA ADD1 ADD2 BUSNME CST PYRID ZIP ASYR BY CMET
Revision: June 2010
Description Improvement detail record stories Improvement detail record wall type Improvement detail record year built Outbuilding record age Outbuilding record location factor Outbuilding record calculation method Outbuilding record depreciation type Outbuilding record flat value Outbuilding record grade Outbuilding record homestead Outbuilding record length Outbuilding record newly discovered year Outbuilding record item Outbuilding record key Outbuilding record process flag Outbuilding record quantity Outbuilding record remaining life Outbuilding record residential key Outbuilding record rate Outbuilding record value Outbuilding record width Improvement district record district Improvement district record amount Improvement district record parcel key Subdivision record street asphalt Subdivision record street GG Subdivision record street concrete Subdivision record street dirt Subdivision record street gravel Subdivision record landscaping Subdivision record name Subdivision record range Subdivision record subdivision key Subdivision record section Subdivision record topography HL Subdivision record topography RF Subdivision record trend Subdivision record township Subdivision record utilities electric Subdivision record utilities gas Subdivision record utilities telephone Subdivision record utilities sewer Subdivision record utilities water Taxpayer record Address line 1 Taxpayer record Address line 2 Taxpayer record Name/ Business Name Taxpayer record City & state Taxpayer record payer ID Taxpayer record Zip code Valuation record assessment year Valuation record base year Valuation record calculation method
Page 6 of 8
BDE Export Field List
Apprentice Information Systems, Inc
Table Format: Delimited Ascii
Table Name VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL VAL WASS WASS WASS WASS WASS WASS WASS WASS WASS WASS WASS WASS WASS WELL WELL WELL WELL WELL WELL WELL WELL WELL WELL WINT WINT WINT WINT
Description Valuation record disabled Valuation record homestead Valuation record homestead base value Valuation record homestead cap increase Valuation record homestead effective Valuation record homestead full improvements Valuation record homestead full land Valuation record homestead increase Valuation record homestead ineligible Valuation record homestead new improvements Valuation record homestead new land Valuation record homestead previous value Valuation record non-homestead base value Valuation record non-homestead cap increase Valuation record non-homestead effective Valuation record non-homestead full improvements Valuation record non-homestead full land Valuation record non-homestead increase Valuation record non-homestead ineligible Valuation record non-homestead new improvements Valuation record non-homestead new land Valuation record non-homestead previous value Valuation record over 65 Valuation record parcel key Valuation record key Well asset record resource type Well asset record base production rate Well asset record current production rate Well asset record flatted base value Well asset record flatted current value Well asset record overriding discount Well asset record royalty discount Well asset record use flatted values flag Well asset record comment Well asset record key Well asset record well key Well asset record working discount Well asset record year Well record active flag Well record comment Well record key Well record lease number Well record legal description Well record name Well record operator name Well record production rate (unused) Well record transporter name Well record unit name Well interest record overriding interest Well interest record parcel key Well interest record royalty interest Well interest record well key
Page 7 of 8
BDE Export Field List Table Name WINT WVAL WVAL WVAL WVAL WVAL WVAL WVAL WVAL
Field Name WRKINT LOWB OVRVAL RESTP ROYVAL UPB WRKVAL WVKEY YEAR
Table Format: Delimited Ascii
Page 8 of 8
Apprentice Information Systems, Inc Description Well interest record working interest Well pricing record lower bound Well pricing record overriding interest unit price Well pricing record resource type Well pricing record royalty interest unit price Well pricing record upper bound Well pricing record working interest unit price Well pricing record key Well pricing record year Revision: June 2010
