This program extracts all data to be
made available for sales requests, to be provided to the Washington Post. It is
run by sale date range. Only parcel sales are selected; element sales are
bypassed.
The program creates a .LST file. The directory path and file name are passed in
as parameters to the program.
NOTE: The specific fields
with permissible entries to be filled in or left blank are listed below.
Ignore fields that are not in the list next to the screens.
|
Figure 1. SY41 (TOP) |
1. Job: Report name should always appear
here. For example, AA406VAFAI. 2. Server Name: Keep the server name
that first appears. 3. Printer_Name: Select
a valid printer or keep the displayed printer if one is present. 4. Jurisdiction: Enter your jurisdiction. 5. Tax Year: Enter the tax year being used to verify parcel sale 6. Spool File Name: Enter AA406VAFAI.LIS to create the file in text format. 7. Beginning Date: Enter beginning sale date for sales to be extracted. 8. Ending Date: Enter ending sale date for sales to be extracted. 13. FCU:
Formatting
code. Keep the default printer setting that is present when the screen
appears. If blank, enter HPLP132. 17. PARAM1 OUTPUT DIRECTORY: Enter drive and directory path for output file. 18. PARAM2 OUTPUT FILE NAME: Enter
file name of output file. 19. PARAM3 HIDE NAME (Y/N): Enter
Y to change owner name to “Name Withheld by Request”. |
|
Figure 2. SY 41
(BOTTOM) |
Press
[Submit Job]. The system will notify you when the report is finished.
|
ID # |
FAIRFAX SALES EXTRACT FILE (orig) |
TABLE NAME |
COLUMN NAME |
DESCRIPTION |
START POSITION |
LENGTH |
DATA TYPE |
|
1 |
REA-COURT-INSTRUMENT-NUMBER |
SALES |
INSTRUNO |
INSTRUMENT NUMBER |
1 |
14 |
A |
|
2 |
REA-COURT-RECORDED-DATE |
SALES |
SALEDT |
RECORDED DATE |
15 |
9 |
D |
|
3 |
REA-COURT-NEW-BOOK |
SALES |
BOOK |
DEED BOOK |
24 |
8 |
A |
|
4 |
REA-COURT-NEW-PAGE |
SALES |
PAGE |
DB PAGE |
32 |
8 |
A |
|
5 |
REA-COURT-GRANTOR1 |
SALES |
OLDOWN |
GRANTOR |
40 |
40 |
A |
|
6 |
REA-COURT-OTHER-GRANTOR (3 OCCUR) |
|
|
|
80 |
|
|
|
7 |
|
|
|
|
80 |
|
|
|
8 |
|
|
|
|
80 |
|
|
|
9 |
REA-COURT-GRANTEE1 |
SALES |
OWN1 |
GRANTEE |
80 |
40 |
A |
|
10 |
REA-COURT-OTHER-GRANTEE (3 OCCUR) |
OWNDAT |
OWN2 |
ADDITIONAL OWNERS |
120 |
40 |
A |
|
11 |
|
OWMLT |
OWN1 |
ADDITIONAL OWNERS |
160 |
40 |
A |
|
12 |
|
OWNMLT |
OWN2 |
ADDITIONAL OWNERS |
200 |
40 |
A |
|
13 |
REA-COURT-ACTION-TYPE |
|
|
|
240 |
|
|
|
14 |
REA-COURT-ACTION-DESC |
|
|
|
240 |
|
|
|
15 |
REA-COURT-INSTRUMENT-TYPE |
SALES |
INSTRTYP |
INSTRUMENT TYPE |
240 |
6 |
A |
|
16 |
REA-COURT-INSTRUMENT-DESC |
AEDIT |
MSG |
DESCRIPTION FOR INSTRTYP |
246 |
40 |
A |
|
17 |
REA-COURT-ORIG-BOOK |
|
|
|
286 |
|
|
|
18 |
REA-COURT-ORIG-PAGE |
|
|
|
286 |
|
|
|
19 |
|
SALES |
PRICE |
|
286 |
10 |
N |
|
20 |
|
SALES |
PARID |
TAX MAP # |
296 |
30 |
A |
|
21 |
|
SALES |
SALEVAL |
VALIDITY CODE |
326 |
2 |
A |
|
22 |
|
SALES |
STEB |
ABSTRACT VERIFY CODE |
328 |
3 |
A |
Updated 7/21/2006