pp410mostl – PP EXTRACT REPORT

 

This modification is an extract report that will print from the Personal Property Module to allow a third party company to print St. Louis Counties declarations. A total of 4 extracts is produced from the PP410MOSTL report based on parameters defined by STL County. The printable extracts are

the Individual PP, Business, Leased Equipment, Leased Vehicle, and Manufacturer. The report will print the information on the report for Accounts that have a Taxable Value greater than 0. This report will run whenever desired.

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)

Figure 2. SY 41 (BOTTOM)

 1.    Job: Report name should always appear here. For example, PP410MOSTL.

 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 current Tax Year.

 6.   Spool File Name: Enter PP410MOSTL.LIS to create the file in text format.

 9. ID1: Enter the minimum Parcel ID to include in the report or zero to include all parcels.  Enter IDLIST for an IDLIST range.

 10. ID2: If ID1 = minimum Parcel ID, enter the maximum Parcel ID associated with the parcels to include in the report. If ID1 = zero, enter ZZ for all parcels. If ID1 = IDLIST, enter the SETNAME of the IDLIST.

 13. FCU: Formatting code. Enter “PDF” to print in PDF format. Otherwise keep the default printer setting that is present when the screen appears.

 17. PARAM1: DECLARATION (1/2/3/4/5):

         1. Individual Personal Property Declaration.

         2. Leased Vehicle Declaration.

         3. Business Declaration.

         4. Leased Equipment Declaration.

         5. Manufacturer’s Declaration.

Note: Any combination can be used if separated by commas. For example: 1,3.

 18. PARAM2: ENTER FOLDER PATH: Enter the folder for flat files. Default is the spool file.

Press [Submit Job]. The system will notify you when the report is finished.

 

REPORT LAYOUT

INDDEC .DAT file

Field #

Table Name

Column Name

Start Position

Length

Description

1

PPADMN

TAXYR

1

4

Tax Year

2

OWNDATL

PADDR1,PADDR2,PADDR3

5

170

Address 1,2 and 3 of Tax Payer

3

PPADMN

PARID

175

30

Parcel ID

4

PPADMN

TAXDIST

205

5

Tax District

5

 

 

210

1

Check Digit For Scan Line

6

 

 

211

10

Record Count for each PARID

7

PPDET

PPTYPE

221

10

Personal Property Type

8

PPDET

YRMFG

231

4

Year Manufactured

9

PPDET

MAKE

235

20

Make of the Vehicle

10

PPDET

MODEL

255

20

Model of the Vehicle

11

ADDRINDX

ADRPRE,ADRNO,ADRADD, ADRDIR, ADRSTR, ADRSUF, ADRSUF2, CITYNAME, UNITDESC, UNITNO, ZIP1, ZIP2

275

170

Address Information - IF Different than Address 1,2 and 3 of Tax Payer

 

LEVHDEC .DAT file

Field #

Table Name

Column Name

Start Position

Length

Description

1

PPADMN

TAXYR

1

4

Tax Year

2

OWNDATL

PADDR1,PADDR2,PADDR3

5

170

Address 1,2 and 3 of Tax Payer

3

PPADMN

PARID

175

30

Parcel ID

4

PPADMN

TAXDIST

205

5

Tax District

5

 

 

210

1

Check Digit For Scan Line

6

 

 

211

10

Record Count for each PARID

7

PPDET

PPTYPE

221

10

Personal Property Type

8

PPDET

YRMFG

231

4

Year Manufactured

9

PPDET

MAKE

235

20

Make of the Vehicle

10

PPDET

MODEL

255

20

Model of the Vehicle

11

ADDRINDX

ADRPRE,ADRNO,ADRADD, ADRDIR, ADRSTR, ADRSUF, ADRSUF2, CITYNAME, UNITDESC, UNITNO, ZIP1, ZIP2

275

170

Address Information - IF Different than Address 1,2 and 3 of Tax Payer

 

BUSDEC .DAT file

Field #

Table Name

Column Name

Start Position

Length

Description

1

PPADMN

TAXYR

1

4

Tax Year

2

PPADMN

PARID

5

30

Parcel ID

3

PPADMN

TAXDIST

35

5

Tax District

4

PPDET

SUM(APRVAL)

40

15

Sum of Appraised Value where PPTYPE='6' and TAXYR-1