DR590TFL – Generate Tangible 12D8 File

 

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, DR590TFL.

 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 DR590TFL.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 to run the report on a specific list of parcels.

 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. Keep the default printer setting that is present when the screen appears. If blank, enter HPLP132.

 17. PARAM1 CODE (C/S/N):

          Enter the valid code to indicate which code the file should pull:

          N = NAIC code

          S = SIC code

          C = Class or DOR code

 18. PARAM2 TXT FILE NAME:

          Enter the name of the text file that will be created in the process.

 

Figure 2. SY 41 (BOTTOM)

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

 

Input/Output Specifications:

 

1.                  DR590TFL.sql – Preliminary Setup.

 

Input:               Database - PPADMN          PP Administration Data

                                          - OWNDATL       Owner Name and Address Data

                                          - ADDRINDX      Situs Address Information

                                          - ASMT                PP Valuation Data

                                          - PPVAL              Pollution Control - Original Cost Value

                                          - EXCODE          Exemption Type (User 12)

                                          - PARAM             DR590T Parameters

 

Output:            Naptape                                 Database – parcel level 12D8T data.

                        Naptape_totals                      Database – Summary Statistics

 

 

This process will generate the following output files:        

           

            Tapefile         (Text file name in Param2)                      Database – parcel level 12D8T data.

 

Tapefile Totals and Rejected Parcels (Statistics_Rejects_12d8t.TXT) – contains summary statistics of database and parcels rejected due to value size errors (values larger than DOR output specifications).

 

Parcels will be put into the reject file for the following reasons:

 

1.      Total Just Value of FFE, Materials and Supplies is greater than $9,999,999,999 (10 bytes)

2.      Total Just Value of Leasehold Improvements is greater than $9,999,999,999 (10 bytes)

3.      Total Just Value of Pollution Control Devices is greater than $9,999,999,999 (10 bytes)

4.      Total Taxable Value of Pollution Control Devices is greater than $9,999,999,999 (10 bytes)

5.      Total Just Value of Parcel is greater than $9,999,999,999 (10 bytes)

6.      Total Exemption Value is greater than $9,999,999,999 (10 bytes)

7.      Total Taxable Value of Parcel is greater than $9,999,999,999 (10 bytes)

 

Updated 7/21/2006