aa408mogre – Assessor's office data loading to owndat & sales
|
The Recorder’s
Interface, AA408MOGRE, is a data conversion program designed to take data
from a flat file and import it into the IAS database for sales reporting.
This program does the following: 1.
Gets the required data from the tape file (id1). 2.
Loads the data into a temp table using sqlloader. 3.
Inserts the data into the OWNDAT and 4.
Prints an audit trail and exceptions, such as records that
were updated or records that were not updateable by the system. An example of
the latter is a record that already exists for a parcel with the same sale
date. |
If no path
is specified, then the report will look in the Start In directory. As with all
400-level reports in IAS, running this report will update the database. The
following changes will occur by running this report: ·
The OWNDAT record for the parcel will be updated. ·
A new sales record will be inserted in the SALES table. Output generated by this program is the exception report
noted above. |
|
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, AA408MOGRE. 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
AA408MOGRE.LIS to create the file in text format. 13. FCU: Formatting code. Keep the default printer setting that is
present when the screen appears. If blank, enter HPLP132. 17. PARAM1 FILENAME: Enter the full path of the input DAT file including the
filename. 18. PARAM2
FILENAME: Enter the full path to the CTL including the filename. |
|
Figure 2. SY 41
(BOTTOM) |
Press
[Submit Job]. The system will notify you when the report is finished
Updated 7/21/2006