AA406VAFAI - Sales Extract

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.


Extract File Layout

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

SALE 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