DR489 - Creation of the Florida State Recapitulation Reports

This process will create the tables which will be utilized when printing the DR489AC, EB, PC, AM, DR420 and DR420S reports. The following tables are created: DR489, DR489_construction, DR4891, DR489_annexation, DR489_consval, DR489EB, DR420 and DR489PC.

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, DR489. 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 DR489.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 DR489 INITIAL SIZE: Enter the temp table DR489 Initial Size. (Verify with your DBA) 18. PARAM2 DR489 NEXT SIZE: Enter the temp table DR489 Next Size. (Verify with your DBA) 19. PARAM3 COMMIT COUNT: Enter the maximum number of records to be retrieved, after which the process will commit (or save) the data.

Figure 2. SY 41 (BOTTOM)

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

ERROR LOG MESSAGES:

This report generates an error log to identify any parcels that may have database integrity issues or data errors that could possibly affect the balancing of the report. The following errors are inserted into ERRLOG during the execution of the program and are displayed at the end of the program in the DR489.debug file. An explanation of each potential error is below:

NULL tax district – there is no tax district associated with the parcel on LEGDAT (AA12) for real estate parcels or PPADMN (PP11) for personal property parcels.

NULL LUC – there is no land use code (LUC) associated with the parcel on ASMT (AA13)

Invalid LUC – the land use code (LUC) on ASMT (AA13) is not valid and doesn’t correspond with any category groupings on the DR489PC report

Parcel Out of Balance – the value on ASMT.VALASM1 (AA13 taxable value) does not match the taxable value on Line 27 Column 4 (L27_4) on the DR489AC/AM. Line 27 Column 4 is the taxable value before authority based exemptions are applied. The taxable value (ASMT.VALASM1) is the assessed value (ASMT.VAL20) less the non-authority based exemptions (currently reported in ASMTADD where LINENO = ‘21’). This is the most common error and generally means there are VAL overrides on the ASMT record that are inconsistent (override is on the Values page but not on the Totals page or vice versa).

Note: The taxable value for operating purposes on Line 26 Column 4 (L26_4) is after the authority based exemptions (EXAUTHDET) are applied. If Line 26 Column 4 is out of balance, the accuracy of the EXAUTHDET records should be investigated.

Updated 7/21/2006