AA524PANOR – PA Homestead Update

AA524PANOR edits homestead data in an external file, updates PARDAT and ASMT if requested, and produces a report listing invalid data and summarizing the validity of the data.

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

 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 AA524PANOR.LIS to create the file in text format.

 7.    Beginning Date: Date processed to be stored in ASMT (AA13) user date 2. Defaults to current system date.

 13. FCU: Formatting code. Keep the default printer setting that is present when the screen appears. If blank, enter HPLL132.

 17. PARAM1 DATA FILE: Data File used for update. Enter full location path and file name. Example: V:\CLT\IAS4\UPLOAD\HOMESTEAD.TXT

 18. PARAM2 CONTROL FILE: Control file for SQL loader for loading update file. Enter full location path and file name. Example: V:\CLT\IAS4\DAEMON\DT560PANOR.CTL

 19. PARAM3 UPDATE PARAM (F/P):

F - updates ASMT (AA13) and PARDAT (CA12) tables

P - no update trail run produces error summary report only

 20. PARAM4 SQL LOADER NAME: SQL loader executable file. SQLLDR is the default. Other examples: SQLLDR73, SQLLDR80.

Figure 2. SY 41 (BOTTOM)

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

 

OTHER INSTRUCTIONS

1.                  Create SY31/32/41 entries for report with the above mentioned parameters. (If you don’t have a screen to create these entries, have CLT create a SQL script for this entries).

2.                  Copy AA524PANOR.SQL file in IAS4 report directory. (X:\IAS4\reports, where X is the directory where you installed IAS4)

3.                  Copy AA524PANOR.CTL file in any IAS directory (as specified in PARAM2).

4.                  Copy the data file in any IAS directory (as specified in PARAM1).

5.                  The output files will be generated in your Spool file directory. The program may create the following output files, assuming you have specified AA524PANOR.lis in the prtque parameter field:

 

a.      AA524PANOR.lis -- edit file

b.      AA524PANOR.lisLOG -- log file created by SQL Loader.

c.      AA524PANOR.lisBAD -- Bad file created by SQL Loader.

Notes:

This program creates a temporary table named TEMP_AA525PANOR in the current user schema. If you are using a security schema to run IAS4 you must have the create table privileges in this schema. The status field will have values in the following ways.

 

-- Status  Meaning

 

-- 0        Active. Parcel is good to upload,

-- 1        Invalid parid parcel doesn’t exist in ASMT and PARDAT,

-- 2        Miss match owner name,

-- 3        Asmt/Pardat.Luc is TAX

-- 4        Position 23 of parid has E or C,

-- 5        pardat user1 ..4 has values OR asmt.flag3, flag4 AND line 16 AND 17 has data.

 

Updated 8/10/2006