Adams County Assessor File Layouts



MASTER TABLE

Row Length = 449 characters

COLUMN ACCOUNTNO FORMAT A08 (08)

COLUMN AREAID FORMAT A03 (03)

COLUMN PARCELNB FORMAT A13 (13)

COLUMN ACCTTYPE FORMAT A15 (15)

COLUMN STATUS FORMAT A01 (01)

COLUMN BUSINESSNAME FORMAT A100 (100)

COLUMN STREETNO FORMAT A15 (15)

COLUMN STREETPREDIR FORMAT A02 (02)

COLUMN STREETNAME FORMAT A50 (50)

COLUMN STREETSUF FORMAT A04 (04)

COLUMN STREETPOSTDIR FORMAT A02 (02)

COLUMN UNITNAME FORMAT A06 (06)

COLUMN LOCCITY FORMAT A50 (50)

COLUMN LOCZIP FORMAT A10 (10)

COLUMN SUBCODE FORMAT A30 (30)

COLUMN SUBNAME FORMAT A100 (100)

COLUMN BLOCK FORMAT A20 (20)

COLUMN LOT FORMAT A20 (20)

NAME_ADDRESS TABLE

Row Length = 315 characters

COLUMN ACCOUNTNO FORMAT A08 (08)

COLUMN AREAID FORMAT A03 (03)

COLUMN PARCELNB FORMAT A13 (13)

COLUMN PRIMARYOWNER FORMAT A01 (01)

COLUMN OWNERPERCENT FORMAT 99999.99 (08)

COLUMN NAME1 FORMAT A60 (60)

COLUMN NAME2 FORMAT A60 (60)

COLUMN ADDRESS1 FORMAT A50 (50)

COLUMN ADDRESS2 FORMAT A50 (50)

COLUMN CITY FORMAT A50 (50)

COLUMN STATE FORMAT A02 (02)

COLUMN ZIPCODE FORMAT A10 (10)

LEGAL TABLE

Row Length = 2024 characters

COLUMN ACCOUNTNO FORMAT A08 (08)

COLUMN AREAID FORMAT A03 (03)

COLUMN PARCELNB FORMAT A13 (13)

COLUMN LEGALDESCRIPTION FORMAT A2000 (2000)

MOBILE HOME TABLE

Row Length = 296 characters

COLUMN ACCOUNTNO FORMAT A08 (08)

COLUMN AREAID FORMAT A03 (03)

COLUMN PARCELNB FORMAT A13 (13)

COLUMN IMPNO FORMAT 999999 (06)

COLUMN TITLENO FORMAT A30 (30)

COLUMN SERIALNO FORMAT A30 (30)

COLUMN YEAR FORMAT A04 (04)

COLUMN MAKEMODEL FORMAT A30 (30)

COLUMN LENGTH FORMAT 999999 (06)

COLUMN WIDTH FORMAT 999999 (06)

COLUMN SPACE FORMAT A30 (30)

COLUMN SUBCODE FORMAT A30 (30)

COLUMN SUBNAME FORMAT A100 (100)

VALUE TABLE BY ABSTRACT

Row Length = 108 characters

COLUMN ACCOUNTNO FORMAT A08 (08)

COLUMN AREAID FORMAT A03 (03)

COLUMN PARCELNB FORMAT A13 (13)

COLUMN CLASSCD FORMAT A10 (10)

COLUMN ASSESSVAL FORMAT 9999999999999.99 (16)

COLUMN ACTVAL FORMAT 9999999999999.99 (16)

COLUMN ACRES FORMAT 9999999999.999 (14)

COLUMN SQFT FORMAT 9999999999.999 (14)

COLUMN UNITS FORMAT 9999999999.999 (14)

SALES TABLE

Row Length = 263 characters

COLUMN ACCOUNTNO FORMAT A08 (08)

COLUMN AREAID FORMAT A03 (03)

COLUMN PARCELNB FORMAT A13 (13)

COLUMN RECPTNO FORMAT A30 (30)

COLUMN BOOK FORMAT A06 (06)

COLUMN PAGE FORMAT A10 (10)

COLUMN INVEFFECTIVEDT FORMAT A08 (YYYYMMDD) (08)

COLUMN ACCTADJSALEP FORMAT 99999999999999.99 (17)

COLUMN GRANTOR FORMAT A40 (40)

COLUMN GRANTEE FORMAT A40 (40)

COLUMN DOCDT FORMAT A08 (YYYYMMDD) (08)

COLUMN DOCFEE FORMAT 99999999999999.99 (17)

COLUMN SALEDT FORMAT A08 (YYYYMMDD) (08)

COLUMN DEEDCODE FORMAT A10 (10)

COLUMN TDFLAG FORMAT A03 (03)

COLUMN LASTTDDT FORMAT A08 (YYYYMMDD) (08)

COLUMN SALEPRICE FORMAT 99999999999999.99 (17)

COLUMN ADJSALEP FORMAT 99999999999999.99 (17)

CLASS_CODES LOOKUP TABLE FOR VALUE TABLE

Row Length = 67 characters

COLUMN CLASSCD FORMAT A04 (04)

COLUMN CLASSNAME FORMAT A50 (50)

COLUMN CODETYPE FORMAT A01 (01)

COLUMN ASMTRATIO FORMAT 99999.999999 (12)

DOCUMENT_CODES LOOKUP TABLE FOR SALES TABLE

Row Length = 50 characters

COLUMN DOCUMENTCODE FORMAT A10 (10)

COLUMN DOCUMENTCODEDESC FORMAT A40 (40)

TAX AREA TABLE

Row Length = 88 characters

COLUMN TAXYEAR FORMAT A04 (04)

COLUMN AREAID FORMAT A03 (03)

COLUMN AUTHID FORMAT A03 (03)

COLUMN NAME FORMAT A40 (40)

COLUMN MILLLEVY FORMAT 99999.999999 (12)

COLUMN CREDITLEVY FORMAT 99999.999999 (12)

COLUMN TOTALLEVY FORMAT 9999999.999999 (14)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download