Back to Technical Support Document Index

Farm File Layout (database structure)

4x 5x W C FP

Tech Support Addendum #0100c

The "farm" files are standard dBASE III Plus compatible files. Below is a listing of the file structure incorporated in the data files used by the program. As of 7/15/96 every farm will contain at least the following 45 fields.

Type definitions

C = characterN = numericD = date L = logical

#
Field Name
Type
Length
Dec
#
Field Name
Type
Length
Dec
1
APN
C
20
0
23
GARAGE
C
1
0
2
ONR_NAME
C
20
0
24
PHONE
C
10
0
3
FIRST
C
30
0
25
TFR_DATE
D
8
0
4
SALUTATION
C
10
0
26
TFR_VAL
N
9
0
5
SITE_ADD
C
30
0
27
F_P
C
1
0
6
SITE_CITY
C
24
0
28
LENDER
C
20
0
7
SITE_ZIP
C
10
0
29
FIRST_TD
N
9
0
8
MAIL_ADD
C
30
0
30
TYPE_LOAN
C
3
0
9
MAIL_CITY
C
24
0
31
RATE_TYPE
C
3
0
10
MAIL_ZIP
C
10
0
32
SECOND_TD
N
9
0
11
ASSD_VAL
N
9
0
33
TRACT_NUM
C
11
0
12
PCNT_IMP
N
2
0
34
LOT
C
5
0
13
USE_CODE
C
16
0
35
ROUTE
C
6
0
14
ZONING
C
15
0
36
TICKLER
D
8
0
15
YR_BUILT
N
4
0
37
FLAG
L
1
0
16
BLDG_SQFT
N
8
0
38
NOTES
M
10
0
17
NUM_UNITS
N
4
0
39
NUMSTORIES
N
2
0
18
ROOMS
N
2
0
40
LAND_VAL
N
9
0
19
BEDROOMS
N
2
0
41
THOM_BRO
C
10
0
20
BATHROOMS
N
6
2
42
LAST_CONT
D
8
0
21
LOT_SIZE
N
9
0
43
SELLER
C
20
0
22
POOL
C
1
0
44
TRAN_TYPE
C
1
0
23
GARAGE
C
1
0
45
MAIL_ROUTE
C
6
0

NOTE:

Older farms may have any of the following differences

small office, home office, soho, soho software, real estate agent software, realtor software, mortgage broker software, real estate broker, real estate tax data software, tax roll data software, property data software, real estate property software, real estate database management software, real estate listing software, real estate software, real estate management, lending software, lender software, mortgage software, contact management, listing management, cma sofware, cma report software, closing management, escrow management, escrow software, closing software, closing manager, escrow manager, campaign manager, financial calculator, financial software, refinance software, refinancing software, loan qualification software, amortization software, scheduler software, scheduling software, real estate spreadsheet, settlement sheets, bulk mailing, client management, telemarketing software, real estate database software, mls software, multiple listing service software, scheduler, spreadsheet, settlement sheets, INSTANT IMPACT! GOLD, INSTANT IMPACT!, instant impact gold, Information Products, salesimpact, sales impact, the lenders edge, lenders edge, lender's edge, INSTANT IMPACT! GOLD, INSTANT IMPACT!, instant impact gold, Information Products, salesimpact, sales impact, the lenders edge, lenders edge, lender's edge