DATE : 10/20/98 TIME : 17:45:20 PAGE : 1 DATA DICTIONARY REPORT Schema Listing TABLE/FIELD REF TYPE LENGTH LONG NAME sminor 50 s_prop_subtypes *sminkey STRING 8 sminor_key sminname STRING 30 s_minor_name smin01 STRING 20 s_screen_01 smin02 STRING 20 s_screen_02 smin03 STRING 20 s_screen_03 smin04 STRING 20 s_screen_04 smin05 STRING 20 s_screen_05 smin06 STRING 20 s_screen_06 smin07 STRING 20 s_screen_07 smin08 STRING 20 s_screen_08 smin09 STRING 20 s_screen_09 smin10 STRING 20 s_screen_10 smin11 STRING 20 s_screen_11 smin12 STRING 20 s_screen_12 smin13 STRING 20 s_screen_13 smin14 STRING 20 s_screen_14 smin15 STRING 20 s_screen_15 smin16 STRING 20 s_screen_16 smin17 STRING 20 s_screen_17 smin18 STRING 20 s_screen_18 smin19 STRING 20 s_screen_19 smin20 STRING 20 s_screen_20 smin21 STRING 20 s_screen_21 smin22 STRING 20 s_screen_22 smin23 STRING 20 s_screen_23 smin24 STRING 20 s_screen_24 smin25 STRING 20 s_screen_25 smin26 STRING 20 s_screen_26 smin27 STRING 20 s_screen_27 smin28 STRING 20 s_screen_28 smin29 STRING 20 s_screen_29 smin30 STRING 20 s_screen_30 sminyn STRING 1 smin_yes_no szones 50 s_zoning_codes *szonekey STRING 8 s_zone_code szname STRING 30 s_zone_name staxmap 3000000 staxmap_file *staxkey COMB staxmap_key staxloca slocakey STRING 8 staxmap_location stblock STRING 10 staxmap_block stlot STRING 16 staxmap_lot stfname STRING 35 tax_full_name stxcomp STRING 30 tax_company stxlast STRING 25 tax_last stxfirst STRING 30 tax_first stxaddr STRING 30 tax_mail_address stxcity STRING 22 tax_mail_city stxstate STRING 2 tax_mail_state stxzip STRING 9 tax_mail_zip DATE : 10/20/98 TIME : 17:45:20 PAGE : 2 DATA DICTIONARY REPORT Schema Listing TABLE/FIELD REF TYPE LENGTH LONG NAME stxph1 STRING 20 tax_phone_1 stxph2 STRING 20 tax_phone_2 stxpaddr STRING 30 tax_property stxwidth FLOAT 113 tax_lot_width stxlengt FLOAT 113 tax_lot_length stxlass AMOUNT 10 tax_land_asses stxbass AMOUNT 10 tax_build_asses stxtass AMOUNT 10 tax_total_asses stxsalu STRING 25 tax_salutation stxxcoor AMOUNT 11 tax_x_coordinate stxycoor AMOUNT 11 tax_y_coordinate stxptype sminkey STRING 8 tax_property_typ stxzone szonekey STRING 8 tax_zoning stxlgmem NUMERIC 4 tax_last_general stxdummy STRING 1 tax_for_screen stxacre FLOAT 104 tax_acreage stxttax AMOUNT 7 tax_total_year stxxamt AMOUNT 7 tax_inc_exemptio stxbamt AMOUNT 7 tax_inc_billable stxdum2 STRING 1 staxmap_dum2 stxadlot STRING 20 staxmap_add_lots stenvtit STRING 40 envelope_title stxgflag STRING 1 general_mail_flg stxsflag STRING 1 special_mail_flg stxbldes STRING 15 tax_bld_descript stxlndes STRING 20 tax_land_descrip stxadlt2 STRING 20 staxmap_add_lts2 stxqual STRING 20 staxmap_qualif stxclass STRING 3 staxmap_class stxdbk STRING 5 staxmap_deed_bk stxdpg STRING 5 staxmap_deed_pg stxsaldt DATE current_sale_dte stxslamt AMOUNT 11 current_sale_amt stxpsdt1 DATE past_sale_date1 stxpamt1 AMOUNT 11 past_sale_amnt1 stxpsdt2 DATE past_sale_date2 stxpamt2 AMOUNT 11 past_sale_amnt2 stxpsdt3 DATE past_sale_date3 stxpamt3 AMOUNT 11 past_sale_amnt3 stxpsdt4 DATE past_sale_date4 stxpamt4 AMOUNT 11 past_sale_amnt4 stxpsdt5 DATE past_sale_date5 stxpamt5 AMOUNT 11 past_sale_amnt5 txdbdate DATE last_tape_dbdate stxlastn STRING 25 stxlastn stxfirsn STRING 30 stxfirsn stxpaddn STRING 30 stxpaddn stxstree STRING 30 stxstree stxnumb STRING 20 stxnumb stxstren STRING 30 stxstren stxsalea AMOUNT 11 stxsalea stxsalef NUMERIC 4 stxsalef stxsalec STRING 60 stxsalec DATE : 10/20/98 TIME : 17:45:20 PAGE : 3 DATA DICTIONARY REPORT Schema Listing TABLE/FIELD REF TYPE LENGTH LONG NAME stxsale1 STRING 20 stxsale1 stxsale2 STRING 20 stxsale2 stxsalee STRING 60 stxsalee stxsaleh STRING 80 stxsaleh stxsaleb NUMERIC 4 stxsaleb stxptyp2 STRING 8 stxptype2 stxsalep STRING 30 stxsalep stxsalco STRING 60 stxsalco stxsaldb DATE stxsaldb stxsalde DATE stxsalde slocatyp 1000 slocation_types *slocakey STRING 8 slocation_key slocanam STRING 30 slocation_name slocaamt FLOAT 84 sloca_tax_hundre slocacit STRING 20 slocation_city slocasta STRING 2 slocation_state slocazip STRING 9 slocation_zip sckey ckey STRING 8 sckey scname STRING 40 scname scstate STRING 2 scstate scudate DATE scudate scaddr1 STRING 40 scaddr1 scaddr2 STRING 40 scaddr2 sccity STRING 40 sccity scmstate STRING 2 scmstate sczip STRING 20 sczip scph1 STRING 20 scph1 scph2 STRING 20 scph2 scph3 STRING 20 scph3 scemail STRING 40 scemail schome STRING 60 schome scunits NUMERIC 9 scunits sctlass AMOUNT 11 sctlass sctbass AMOUNT 11 sctbass scttass AMOUNT 11 scttass slocspon STRING 60 slocspon ssponhom STRING 60 ssponhom scfedcod STRING 12 scfedcod sclegdis NUMERIC 4 sclegdis sclegcom STRING 10 scleccom county 100 county *ckey STRING 8 ckey cname STRING 40 cname cstate STRING 2 cstate cudate DATE cudate cass STRING 40 cass caddr1 STRING 40 caddr1 caddr2 STRING 40 caddr2 ccity STRING 40 ccity ccstate STRING 2 ccstate czip STRING 20 czip DATE : 10/20/98 TIME : 17:45:20 PAGE : 4 DATA DICTIONARY REPORT Schema Listing TABLE/FIELD REF TYPE LENGTH LONG NAME cph1 STRING 20 cph1 cph2 STRING 20 cph2 cph3 STRING 20 cph3 cemail STRING 40 cemail chome STRING 60 chome cunits NUMERIC 9 cunits ctlass AMOUNT 11 ctlass ctbass AMOUNT 11 ctbass cttass AMOUNT 11 cttass cspon STRING 60 cspon csponhom STRING 60 csponhom blocks 500000 blocks *bkey COMB bkey bckey ckey STRING 8 bckey bcloc slocakey STRING 8 bcloc bcblock STRING 10 bcblock bunits NUMERIC 9 bunits btlass AMOUNT 11 btlass btbass AMOUNT 11 btbass bttass AMOUNT 11 bttass DATE : 10/20/98 TIME : 17:45:20 PAGE : 5 DATA DICTIONARY REPORT Table List TABLE NUMBER EXPECTED LENGTH ======================================================= blocks 2 500000 82 county 1 100 570 slocatyp 15 1000 644 sminor 5 50 656 staxmap 14 3000000 1192 szones 6 50 54 DATE : 10/20/98 TIME : 17:45:20 PAGE : 6 DATA DICTIONARY REPORT Field List FIELD NUMBER TABLE TYPE LENGTH ================================================================================ bcblock 28 blocks STRING 10 bckey 26 blocks STRING 8 bcloc 27 blocks STRING 8 bkey 25 blocks COMB 26 btbass 31 blocks AMOUNT 11 btlass 30 blocks AMOUNT 11 bttass 32 blocks AMOUNT 11 bunits 29 blocks NUMERIC 9 caddr1 11 county STRING 40 caddr2 12 county STRING 40 cass 10 county STRING 40 ccity 13 county STRING 40 ccstate 14 county STRING 2 cemail 19 county STRING 40 chome 20 county STRING 60 ckey 6 county STRING 8 cname 7 county STRING 40 cph1 16 county STRING 20 cph2 17 county STRING 20 cph3 18 county STRING 20 cspon 52 county STRING 60 csponhom 54 county STRING 60 cstate 8 county STRING 2 ctbass 23 county AMOUNT 11 ctlass 22 county AMOUNT 11 cttass 24 county AMOUNT 11 cudate 9 county DATE cunits 21 county NUMERIC 9 czip 15 county STRING 20 scaddr1 37 slocatyp STRING 40 scaddr2 38 slocatyp STRING 40 sccity 39 slocatyp STRING 40 scemail 45 slocatyp STRING 40 scfedcod 100 slocatyp STRING 12 schome 46 slocatyp STRING 60 sckey 33 slocatyp STRING 8 sclegcom 102 slocatyp STRING 10 sclegdis 101 slocatyp NUMERIC 4 scmstate 40 slocatyp STRING 2 scname 34 slocatyp STRING 40 scph1 42 slocatyp STRING 20 scph2 43 slocatyp STRING 20 scph3 44 slocatyp STRING 20 scstate 35 slocatyp STRING 2 sctbass 49 slocatyp AMOUNT 11 sctlass 48 slocatyp AMOUNT 11 scttass 50 slocatyp AMOUNT 11 DATE : 10/20/98 TIME : 17:45:20 PAGE : 7 DATA DICTIONARY REPORT Field List FIELD NUMBER TABLE TYPE LENGTH ================================================================================ scudate 36 slocatyp DATE scunits 47 slocatyp NUMERIC 9 sczip 41 slocatyp STRING 20 slocaamt 279 slocatyp FLOAT 84 slocacit 302 slocatyp STRING 20 slocakey 251 slocatyp STRING 8 slocanam 252 slocatyp STRING 30 slocasta 303 slocatyp STRING 2 slocazip 304 slocatyp STRING 9 slocspon 53 slocatyp STRING 60 smin01 68 sminor STRING 20 smin02 69 sminor STRING 20 smin03 70 sminor STRING 20 smin04 71 sminor STRING 20 smin05 72 sminor STRING 20 smin06 73 sminor STRING 20 smin07 74 sminor STRING 20 smin08 75 sminor STRING 20 smin09 76 sminor STRING 20 smin10 77 sminor STRING 20 smin11 78 sminor STRING 20 smin12 79 sminor STRING 20 smin13 80 sminor STRING 20 smin14 81 sminor STRING 20 smin15 82 sminor STRING 20 smin16 83 sminor STRING 20 smin17 84 sminor STRING 20 smin18 85 sminor STRING 20 smin19 86 sminor STRING 20 smin20 87 sminor STRING 20 smin21 88 sminor STRING 20 smin22 89 sminor STRING 20 smin23 90 sminor STRING 20 smin24 91 sminor STRING 20 smin25 92 sminor STRING 20 smin26 93 sminor STRING 20 smin27 94 sminor STRING 20 smin28 95 sminor STRING 20 smin29 96 sminor STRING 20 smin30 97 sminor STRING 20 sminkey 64 sminor STRING 8 sminname 67 sminor STRING 30 sminyn 155 sminor STRING 1 ssponhom 55 slocatyp STRING 60 staxkey 222 staxmap COMB 34 staxloca 223 staxmap STRING 8 stblock 224 staxmap STRING 10 DATE : 10/20/98 TIME : 17:45:20 PAGE : 8 DATA DICTIONARY REPORT Field List FIELD NUMBER TABLE TYPE LENGTH ================================================================================ stenvtit 345 staxmap STRING 40 stfname 226 staxmap STRING 35 stlot 225 staxmap STRING 16 stxacre 274 staxmap FLOAT 104 stxaddr 230 staxmap STRING 30 stxadlot 344 staxmap STRING 20 stxadlt2 351 staxmap STRING 20 stxbamt 277 staxmap AMOUNT 7 stxbass 240 staxmap AMOUNT 10 stxbldes 349 staxmap STRING 15 stxcity 231 staxmap STRING 22 stxclass 353 staxmap STRING 3 stxcomp 227 staxmap STRING 30 stxdbk 354 staxmap STRING 5 stxdpg 355 staxmap STRING 5 stxdum2 301 staxmap STRING 1 stxdummy 250 staxmap STRING 1 stxfirsn 2 staxmap STRING 30 stxfirst 229 staxmap STRING 30 stxgflag 346 staxmap STRING 1 stxlass 239 staxmap AMOUNT 10 stxlast 228 staxmap STRING 25 stxlastn 1 staxmap STRING 25 stxlengt 238 staxmap FLOAT 113 stxlgmem 249 staxmap NUMERIC 4 stxlndes 350 staxmap STRING 20 stxnumb 5 staxmap STRING 20 stxpaddn 3 staxmap STRING 30 stxpaddr 236 staxmap STRING 30 stxpamt1 359 staxmap AMOUNT 11 stxpamt2 361 staxmap AMOUNT 11 stxpamt3 363 staxmap AMOUNT 11 stxpamt4 365 staxmap AMOUNT 11 stxpamt5 367 staxmap AMOUNT 11 stxph1 234 staxmap STRING 20 stxph2 235 staxmap STRING 20 stxpsdt1 358 staxmap DATE stxpsdt2 360 staxmap DATE stxpsdt3 362 staxmap DATE stxpsdt4 364 staxmap DATE stxpsdt5 366 staxmap DATE stxptyp2 65 staxmap STRING 8 stxptype 245 staxmap STRING 8 stxqual 352 staxmap STRING 20 stxsalco 103 staxmap STRING 60 stxsaldb 104 staxmap DATE stxsalde 105 staxmap DATE DATE : 10/20/98 TIME : 17:45:20 PAGE : 9 DATA DICTIONARY REPORT Field List FIELD NUMBER TABLE TYPE LENGTH ================================================================================ stxsaldt 356 staxmap DATE stxsale1 59 staxmap STRING 20 stxsale2 60 staxmap STRING 20 stxsalea 56 staxmap AMOUNT 11 stxsaleb 63 staxmap NUMERIC 4 stxsalec 58 staxmap STRING 60 stxsalee 61 staxmap STRING 60 stxsalef 57 staxmap NUMERIC 4 stxsaleh 62 staxmap STRING 80 stxsalep 66 staxmap STRING 30 stxsalu 242 staxmap STRING 25 stxsflag 347 staxmap STRING 1 stxslamt 357 staxmap AMOUNT 11 stxstate 232 staxmap STRING 2 stxstree 4 staxmap STRING 30 stxstren 51 staxmap STRING 30 stxtass 241 staxmap AMOUNT 10 stxttax 275 staxmap AMOUNT 7 stxwidth 237 staxmap FLOAT 113 stxxamt 276 staxmap AMOUNT 7 stxxcoor 243 staxmap AMOUNT 11 stxycoor 244 staxmap AMOUNT 11 stxzip 233 staxmap STRING 9 stxzone 248 staxmap STRING 8 szname 99 szones STRING 30 szonekey 98 szones STRING 8 txdbdate 368 staxmap DATE DATE : 10/20/98 TIME : 17:45:20 PAGE : 10 DATA DICTIONARY REPORT Table Relationships TABLE TABLE FIELD ================================================================= blocks county bckey blocks slocatyp bcloc slocatyp county sckey staxmap slocatyp staxloca staxmap sminor stxptype staxmap szones stxzone