Record Table - RELIEN Real Estate Lien Notice File

The Real Estate Lien Notice File contains data created by the Prepare Lien File program.  The file is used for generating lien letters for Tax Accounts with the Real Estate Account Type.

Notes:

Field Name

Description

Length

Format

TaxAccount (Key)

Tax Account Number

6

STRING

Owner_Name1

Owner Name

35

STRING

Owner_Name2

Owner Name

35

STRING

AddressLine1

Address

25

STRING

AddressLine2

Address

25

STRING

City

City

15

STRING

State

State

2

STRING

ZipCode

Zip Code

10

STRING

TaxDollars

Lien Tax Dollars

6.0

INTEGER

TaxCents

Lien Tax Cents

2.0

INTEGER

Map

Map Number portion of Property ID

3

STRING

LotSubType

Lot Number, Subdivision, and Type portion of Property ID

9

STRING

TaxDollarsCents

Lien Total Tax Amount

6.2

DOUBLE

TotalInterest

Lien Interest Amount

6.2

DOUBLE

GrandTotal

Lien Grand Total

6.2

DOUBLE

Book

Mortgage Book Number

6

STRING

Page

Mortgage Page Number

6

STRING

Resident

Resident Y/N

1

STRING

PropertyType

Property Type

2.0

INTEGER

UseCode

Use Code

2.0

INTEGER

HardwoodAcres

# of Acres of Hardwood

4.2

DOUBLE

SoftwoodAcres

# of Acres of Softwood

4.2

DOUBLE

MixedAcres

# of Acres of Mixed Wood

4.2

DOUBLE

PropertyLocation

Combination of Lot Location Street Number and Lot Location Street Name

30

STRING

DescriptionLine1

Description of Property

25

STRING

Zone

Zone

20

STRING

DescriptionLine2

Description of Property

25

STRING

REKey

Real Estate Key is the Property ID:  Map, Lot Number, Subdivision, Type

12

STRING

MortgageCode

Mortgage Holder Code

3

STRING

MortgageNumber

Mortgage Number

20

STRING

LienYear

Lien Year

2.0

INTEGER

MobHomeDescription

Mobile Description

30

STRING

MobHomeSerialNum

Mobile Serial Number

30

STRING

LienBook

Lien Book Number

6

STRING

LienPage

Lien Page Number

6

STRING

LienDate

Lien Date

DATE

MM/DD/YYYY