PP408 – Batch Program to deactivate/reactivate PP Parcels

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, PP408. 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 PP408.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. 14. WHERE_STMT: Additional where clause used to specify which records to deactivate/reactivate. Can also be Null. But, if entered, should start with fieldname (No AND/OR operator is required in the start) and if multiple fields are being used, AND/OR clause should be used in between fields. Field names being used should be valid fields of the Table. Program does not check for valid fields and if entered wrong, returns an ORACLE error. 17. PARAM1 ROLLTYPE: Enter a valid rolltype. 18. PARAM2 FLAG (D/R): Flag used to indicate [D] - Deactivate / [R] – Reactivate. 19. PARAM3 PPSTAT: Program will process PP11 (PPADMN).Ppstat = 'I'. If left null, all parcels matching the previous conditions will be processed.

Figure 2. SY 41 (BOTTOM)

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

NOTES: This is a database update process. Before running, make sure of a record existing in REPORTS table with the following Parameters:

REPT = 'PP408'

UPDFLG = 'Y'

PLAB1 = 'Rolltype'

PLAB2 = '[D]eact / [R]eact'

PLAB3 = 'Ppstat [I]'

Updated 8/3/2006