TABLE_NAME

COLUMN_NAME

DATA_TYPE

DATA_LENGTH

DATA_PRECISION

DATA_SCALE

NULLABLE

DESCRIPTION

BLDG

Buildings linked to PARCEL table by REID and YEAR_FOR

BLDG

BLDG_PK

NUMBER

22

20

0

Y

Internal unique building identifier

BLDG

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

BLDG

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record

BLDG

BLDG_CARD

NUMBER

22

6

0

Y

sequential index of buildings, each building has a bldg_card number that is unique per parcel

BLDG

BLDG_ADDR

VARCHAR2

100

Y

Physical Address of the building

BLDG

BLDG_DESC

VARCHAR2

100

Y

Description of the building

BLDG

BLDG_TYPE

VARCHAR2

25

Y

Type of the building

BLDG

UNITS

NUMBER

22

6

0

Y

Number of Units (Apts, Condos, etc) per building

BLDG

HEATED_AREA

NUMBER

22

6

0

Y

The total living area of the building including additions and basement and attic

BLDG

STORY_HEIGHT

VARCHAR2

25

Y

Number of stories

BLDG

STYLE

VARCHAR2

25

Y

Style of construction

BLDG

BASEMENT

VARCHAR2

25

Y

Basement finish

BLDG

EXTERIOR

VARCHAR2

25

Y

Exterior finish

BLDG

CONST_TYPE

VARCHAR2

25

Y

Construction type (used on commercial buildings)

BLDG

HEATING

VARCHAR2

25

Y

Type of heating in the building if any

BLDG

AIR_COND

VARCHAR2

25

Y

Type of A/C in the building if any

BLDG

PLUMBING

VARCHAR2

25

Y

Plumbing description

BLDG

YEAR_BUILT

VARCHAR2

4

Y

Year building was built

BLDG

EFF_YEAR

VARCHAR2

4

Y

Year Depreciation is figured from

BLDG

ADDITIONS

VARCHAR2

4

Y

Number of additions

BLDG

REMODELED

VARCHAR2

4

Y

Year bldg was remodeled

BLDG

INT_ADUSTMENTS

VARCHAR2

500

Y

Interior features that affect building value (xml string)

BLDG

OTHER_FEATURES

VARCHAR2

500

Y

Other features that affect building value (xml string)

BLDG

BLDG_VALUE

NUMBER

22

12

0

Y

Base Value of the building

BLDG

GRADE

VARCHAR2

25

Y

Grade factor applied to the building

BLDG

CONDITION

VARCHAR2

25

Y

Condition factor applied to the building

BLDG

MARKET_ADJ_1

VARCHAR2

25

Y

Adjustments due to market.

BLDG

MARKET_ADJ_2

VARCHAR2

25

Y

Adjustments due to market.

BLDG

MARKET_ADJ_3

VARCHAR2

25

Y

Adjustments due to market.

BLDG

ACCRUED_PCNT

VARCHAR2

4

Y

Accrued Adjustment Percent (not currently used)

BLDG

INCOMPLETE_CODE

VARCHAR2

25

Y

Percent of building completed on Jan 01 of Tax Year

BLDG

TOTAL_BLDG_VALUE

NUMBER

22

12

0

Y

Assessed Value of the building

BLDG

ALL_CARDS_VALUE

NUMBER

22

12

0

Y

Total value of all buildings on this parcel except the current card

BLDG

SKETCH

VARCHAR2

300

Y

sketch vectors for building sketch

BLDG

PHOTO_PATH

VARCHAR2

100

Y

Path to building photo

BLDG

PHOTO_DATE

DATE

7

Y

Date building photo was taken

BLDG_MAIN_ADDITION

Table of Main Building and Addition Data.  Main Building is indicated by bma_level = 'M', additions have a sequence number starting at 2. Linked to Bldg table by bldg_card and REID

BLDG_MAIN_ADDITION

BLDGMA_PK

NUMBER

22

20

0

Y

Internal unique identifier

BLDG_MAIN_ADDITION

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

BLDG_MAIN_ADDITION

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record.

BLDG_MAIN_ADDITION

BLDG_CARD

NUMBER

22

6

0

Y

Building Card that this record is linked to

BLDG_MAIN_ADDITION

BMA_LEVEL

VARCHAR2

5

Y

Main or addition sequence.  Main Building is 'M', additions are numbered starting at 2

BLDG_MAIN_ADDITION

STORY

VARCHAR2

50

Y

Story height

BLDG_MAIN_ADDITION

BMA_TYPE

VARCHAR2

50

Y

Type of addition

BLDG_MAIN_ADDITION

CODE

VARCHAR2

25

Y

Internal Code for this addition

BLDG_MAIN_ADDITION

AREA

NUMBER

22

6

0

Y

Area of the addition

BLDG_MAIN_ADDITION

INC

VARCHAR2

25

Y

Not currently used

BLDG_MAIN_ADDITION

SEQ

NUMBER

22

3

0

Y

Sequence for all records per building

BLDG_OTHER_IMPROVEMENT

BLDG_OTHER_IMPROVEMENT

BLDGOI_PK

NUMBER

22

20

0

Y

BLDG_OTHER_IMPROVEMENT

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

BLDG_OTHER_IMPROVEMENT

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record

BLDG_OTHER_IMPROVEMENT

BLDG_CARD

NUMBER

22

6

0

Y

Building Card that this record is linked to

BLDG_OTHER_IMPROVEMENT

UNITS

VARCHAR2

25

Y

Amount of Measurement

BLDG_OTHER_IMPROVEMENT

UNIT_DESCR

VARCHAR2

25

Y

Type of Measurement (square feet, etc.)

BLDG_OTHER_IMPROVEMENT

ITEM

VARCHAR2

50

Y

Description of Improvement

BLDG_OTHER_IMPROVEMENT

CODE

VARCHAR2

25

Y

BLDG_OTHER_IMPROVEMENT

YEAR_BUILT

VARCHAR2

4

Y

Year Improvement was built

BLDG_OTHER_IMPROVEMENT

PCNT_GOOD

VARCHAR2

2

Y

BLDG_OTHER_IMPROVEMENT

INCLUDES

VARCHAR2

25

Y

Not Currently Used

BLDG_OTHER_IMPROVEMENT

OB_VALUE

NUMBER

22

12

0

Y

Value if this is an outbuilding

BLDG_OTHER_IMPROVEMENT

SEQ

NUMBER

22

3

0

Y

Sequence number improvements on a single building on a parcel

DEED

a list of deeds associated with this parcel.

DEED

DEED_PK

NUMBER

22

20

0

Y

Internal unique identifier

DEED

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

DEED

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record

DEED

OWNER_NAME

VARCHAR2

100

Y

Name of Owner on Deed

DEED

STATUS

VARCHAR2

25

Y

Status of the Deed (Current or History)

DEED

STATUS_NUMBER

NUMBER

22

3

0

Y

If Current then 0 otherwise the number increases as you go further back in the Deed history

DEED

DEED_TYPE

VARCHAR2

50

Y

Type of Deed

DEED

OWN_PCNT

VARCHAR2

10

Y

Percent Ownership for this owner

DEED

STAMPS

NUMBER

22

12

2

Y

Revenue Stamps on this Deed

DEED

BOOK

VARCHAR2

10

Y

Deed Book

DEED

PAGE

VARCHAR2

10

Y

Deed Page

DEED

DEED_DATE

DATE

7

Y

Date Deed was recorded

DEED

SEQ

NUMBER

22

3

0

Y

not currently used

IMAGE

Not Currently Used

IMAGE

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

IMAGE

YEAR_FOR

NVARCHAR2

8

Y

Tax Year of this record

IMAGE

BLDG_CARD

NUMBER

22

6

0

Y

IMAGE

IMAGE_PATH

VARCHAR2

255

Y

IMAGE

IMAGE_DATE

DATE

7

Y

IMAGE

IMAGE_SEQ

NUMBER

22

20

0

Y

IMAGE

NOTES

VARCHAR2

255

Y

IMAGE

IMAGE_CLASS

VARCHAR2

20

Y

IMAGE

PRIMARY_IMAGE

VARCHAR2

1

Y

IMAGE

IMAGE_PK

NUMBER

22

10

0

Y

LAND

Not Currently Used…

LAND

LAND_PK

NUMBER

22

20

0

Y

LAND

REID

VARCHAR2

20

Y

LAND

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record

LAND

LAND_CLASS

VARCHAR2

25

Y

LAND

SOIL_CLASS

VARCHAR2

25

Y

LAND

DEEDED_ACRES

NUMBER

22

10

4

Y

LAND

CALCULATED_ACRES

NUMBER

22

10

4

Y

LAND

FARM_USE_YEAR

VARCHAR2

4

Y

LAND

FARM_USE_FLAG

VARCHAR2

25

Y

LAND_LINE

LAND_LINE

LL_PK

NUMBER

22

20

0

Y

LAND_LINE

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

LAND_LINE

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record

LAND_LINE

SCHEDULE

NUMBER

22

6

0

Y

Not Currently Used

LAND_LINE

ETJ

VARCHAR2

10

Y

Not Currently Used

LAND_LINE

ZONING

VARCHAR2

10

Y

Zoning for this Land Line

LAND_LINE

DESCR

VARCHAR2

25

Y

Unit of Measurement Description

LAND_LINE

UNITS

NUMBER

22

15

2

Y

Amount of Measurement

LAND_LINE

RATE

NUMBER

22

12

0

Y

Land Rate Used

LAND_LINE

CONDITION

VARCHAR2

20

Y

Condition percent

LAND_LINE

COND_REASON

VARCHAR2

25

Y

Reason Condition adjustment applied

LAND_LINE

INFLUENCE

VARCHAR2

20

Y

Influence Percent

LAND_LINE

INF_REASON

VARCHAR2

25

Y

Reason Influence adjustment applied

LAND_LINE

LAND_LINE_VALUE

NUMBER

22

12

0

Y

Market Value of Land Line

LAND_LINE

SEQ

NUMBER

22

3

0

Y

Land Line Number

LAND_LINE

SOIL_CLASS

VARCHAR2

20

Y

Soil Class of this Land Line

LAND_LINE

DEF_VALUE

NUMBER

22

15

0

Y

Deferred Value Subtracted from Land Line Value

LAND_LINE

LAND_LINE_DESCRIPTION

VARCHAR2

50

Y

Description of Land Line.

LRASTR_STREET

Not Currently Used…

LRASTR_STREET

LOCID

NUMBER

22

6

0

N

LRASTR_STREET

TXN_CRUSER

VARCHAR2

10

Y

LRASTR_STREET

TXN_USER

VARCHAR2

10

Y

LRASTR_STREET

TXN_CRDATE

DATE

7

Y

LRASTR_STREET

TXN_DATE

DATE

7

Y

LRASTR_STREET

TXN_IDENTIFY

VARCHAR2

30

Y

LRASTR_STREET

COMB_STREET_PK

NUMBER

22

7

0

Y

LRASTR_STREET

STREET_NAME

VARCHAR2

25

N

LRASTR_STREET

DIRECTIONAL_PREFIX

VARCHAR2

2

Y

LRASTR_STREET

DIRECTIONAL_SUFFIX

VARCHAR2

2

Y

LRASTR_STREET

STREET_TYPE

VARCHAR2

4

Y

LRASTR_STREET

UNIQUE_SEQ_NUM

NUMBER

22

1

0

N

LRASTR_STREET

PLAN_JURIS

VARCHAR2

2

N

LRASTR_STREET

STATUS

VARCHAR2

1

Y

LRASTR_STREET

DATE_STREET_ENTERED

DATE

7

N

LRASTR_STREET

NOTES

VARCHAR2

250

Y

LRASTR_STREET

APPLICATION_NUM

NUMBER

22

5

0

Y

LRASTR_STREET

SUBDIVISION_NAME

VARCHAR2

30

Y

LRASTR_STREET

DATE_APPROVED

DATE

7

Y

LRASTR_STREET

APPROVED_BY_OPID

VARCHAR2

3

Y

LRASTR_STREET

ACTUAL_MIN_STREET_NUM

NUMBER

22

6

0

Y

LRASTR_STREET

ACTUAL_MAX_STREET_NUM

NUMBER

22

6

0

Y

LRASTR_STREET

PRIOR_NAME_LOCID

NUMBER

22

6

0

Y

LRASTR_STREET

ZIP_CODE

VARCHAR2

5

Y

LRASTR_STREET

ZIP_EXTENSION

VARCHAR2

4

Y

LRASTR_STREET

NUM_OF_BLDGS

NUMBER

22

7

0

Y

LRASTR_STREET

ALLOWED_MIN_STREET_NUM

NUMBER

22

6

0

Y

LRASTR_STREET

ALLOWED_MAX_STREET_NUM

NUMBER

22

6

0

Y

LRASTR_STREET

INITIALS

VARCHAR2

3

Y

NOTE

NOTE

NOTE_PK

NUMBER

22

20

0

Y

Internal unique identifier

NOTE

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

NOTE

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record

NOTE

BLDG_CARD

NUMBER

22

6

0

Y

Building Card that this record is linked to

NOTE

NOTE_DATE

DATE

7

Y

Date Note was entered

NOTE

LINE

NUMBER

22

3

0

Y

Not currently used

NOTE

NOTES

VARCHAR2

1000

Y

Text of the Note

NOTE

SEQ

NUMBER

22

3

0

Y

incremented sequence number for notes on this Reid

OWNER

OWNER

OWNER_PK

NUMBER

22

20

0

Y

Internal unique identifier

OWNER

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

OWNER

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record

OWNER

LAST_NAME

VARCHAR2

50

Y

Last Name of the Owner

OWNER

FIRST_NAME

VARCHAR2

50

Y

First Name of the Owner

OWNER

MIDDLE_NAME

VARCHAR2

50

Y

Middle Name of the Owner

OWNER

NAME_SUFFIX

VARCHAR2

10

Y

Suffix  of the Owner

OWNER

BUSINESS_NAME

VARCHAR2

100

Y

Business Name if Owner is a business

OWNER

COMPLETE_NAME

VARCHAR2

160

Y

This field will always have an owner name it is either the business name or the concatenation of the individuals name

OWNER

LOCATION_ADDR

VARCHAR2

100

Y

Physical Address of the Parcel

OWNER

CITY

VARCHAR2

50

Y

City the Parcel is located in (if any)

OWNER

PROPERTY_DESCR

VARCHAR2

100

Y

Description of the Property

OWNER

SEQ

NUMBER

22

3

0

Y

Not currently used.

PARCEL

This is the primary table for property data. Most other tables are linked back to this data through the REID and Year_For

PARCEL

PARCEL_PK

NUMBER

22

20

0

Y

Internal unique parcel identifier

PARCEL

REID

VARCHAR2

20

Y

common unique parcel identifier also known as Parcel Number

PARCEL

PIN

VARCHAR2

14

Y

Pin Number of the property

PARCEL

PIN_EXT

VARCHAR2

4

Y

Pin Extension of the property

PARCEL

PIN_MAP

VARCHAR2

4

Y

Pin Map of the property

PARCEL

PIN_BLOCK

VARCHAR2

2

Y

Pin Block of the property

PARCEL

PIN_LOT

VARCHAR2

4

Y

Pin Lot of the property

PARCEL

PROPERTY_DESCR

VARCHAR2

50

Y

Description of the property

PARCEL

LOCATION_ADDR

VARCHAR2

100

Y

Location of the property

PARCEL

OLD_MAP

VARCHAR2

100

Y

Old Map

PARCEL

YEAR_FOR

VARCHAR2

4

Y

Tax Year of this record