This report will be run to create the data in a temporary table in
the iasWorld database that will allow Province IT Personnel to manipulate the
data and create several different reports needed in the Province. This report
will also allow the Province to produce a data extract file consisting of data
from the temporary table.
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, AA150NS. 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 AA150NS.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. 11. ALT ID1Region Code (P,N,S,E,W,C): P-
Province, N- North, S-South, E-East, W-West, C-Center. (If printing for
multiple codes, use a coma to separate.) When a region is entered, the jurisdiction
will be ignored and the report will print all jurisdictions in the region. 13.
FCU: Formatting code. Keep the default printer setting that is
present when the screen appears. If blank, enter HPLP132. 17. PARAM1 OUTPUT (Y/N): N
is default. 18. PARAM2 ROLLTYPE: If blank,
all rolltypes are processed. 19. PARAM3 FINAL (Y/N) Y- Final Primary roll.
N default: 20. PARAM4 BEGINNING YEAR VALUES (Y/N): Y pulls 0 seq rec for taxyr-1 in asmt_all. N user cur = Y from taxyr-1. 21. PARAM5 PATH: Enter Output
path and filename. For example, C:\clt\taxdist.dat. Default is taxdist.dat in
spool folder. |
|
Figure 2. SY 41
(BOTTOM) |
Press
[Submit Job]. The system will notify you when the report is finished.
|
Table/View |
Column/Field |
Description |
Lgth |
Start Position |
End Position |
Temp Table
Field Name |
Comments |
|
COUNTY |
PARENT_JUR |
Region |
8 |
1 |
8 |
REGION |
Where
asmt.jur=county.jur |
|
ASMT |
JUR |
Municipality |
2 |
9 |
10 |
JUR |
|
|
LEGDAT |
TAXDIST |
Taxing District/
Ward |
6 |
11 |
16 |
TAXDIST |
TAXDIST||TAXDIST2 |
|
PARAM |
TAXYR |
Previous Year |
4 |
17 |
20 |
PRIORYR |
This will be
PARAM.TAXYR-1 |
|
PARAM |
TAXYR |
Current Year |
4 |
21 |
24 |
TAXYR |
|
|
ASMT_ALL |
VAL05 |
Previous Leg Code
01 Value |
10 |
25 |
34 |
PREVAL01 |
Where
rolltype=RP and valclass=01 and taxyr = param.taxyr-1 |
|
ASMT_ALL |
VAL08 |
Previous Leg Code
01 Acres |
10 |
35 |
44 |
PREACR01 |
Where
rolltype=RP and valclass=01 and taxyr = param.taxyr-1 |
|
ASMT_ALL |
VAL05 |
Current Leg Code
01 Value |
10 |
45 |
54 |
CURVAL01 |
Where
rolltype=RP and valclass=01 and taxyr = param.taxyr |
|
ASMT_ALL |
VAL08 |
Current Leg Code
01 Acres |
10 |
55 |
64 |
CURACR01 |
Where rolltype=RP
and valclass=02 and taxyr = param.taxyr |
|
ASMT_ALL |
VAL05 |
Preliminary Leg
Code 01 Value |
10 |
65 |
74 |
PRLIMVAL01 |
Where
rolltype=RP and valclass=01 and taxyr = param.taxyr and procname =
PRELIM |
|
ASMT_ALL |
VAL08 |
Preliminary Leg
Code 01 Acres |
10 |
75 |
84 |
PRLIMACR01 |
Where
rolltype=RP and valclass=02 and taxyr = param.taxyr and procname =
PRELIM |
|
ASMT_ALL |
VAL05 |
Previous Leg Code
02 Value |
10 |
85 |
94 |
PREVAL02 |
Where rolltype=RP
and valclass=02 and taxyr = param.taxyr-1 |
|
ASMT_ALL |
VAL08 |
Previous Leg Code
02 Acres |
10 |
95 |
104 |
PREACR02 |
Where
rolltype=RP and valclass=02 and taxyr = param.taxyr-1 |
|
ASMT_ALL |
VAL05 |
Current Leg Code
02 Value |
10 |
105 |
114 |
CURVAL02 |
Where
rolltype=RP and valclass=02 and taxyr = param.taxyr |
|
ASMT_ALL |
VAL08 |
Current Leg Code
02 Acres |
10 |
115 |
124 |
CURACR02 |
Where
rolltype=RP and valclass=02 and taxyr = param.taxyr |
|
ASMT_ALL |
VAL05 |
Preliminary Leg
Code 02 Value |
10 |
125 |
134 |
PRLIMVAL02 |
Where
rolltype=RP and valclass=02 and taxyr = param.taxyr and procname =
PRELIM |
|
ASMT_ALL |
VAL08 |
Preliminary Leg
Code 02 Acres |
10 |
135 |
144 |
PRLIMACR02 |
Where rolltype=RP
and valclass=02 and taxyr = param.taxyr and procname = PRELIM |
|
ASMT_ALL |
VAL05 |
Previous Leg Code
03 Value |
10 |
145 |
154 |
PREVAL03 |
Where
rolltype=RP and valclass=03 and taxyr = param.taxyr-1 |
|
ASMT_ALL |
VAL08 |
Previous Leg Code
03 Acres |
10 |
155 |
164 |
PREACR03 |
Where
rolltype=RP and valclass=03 and taxyr = param.taxyr-1 |
|
ASMT_ALL |
VAL05 |
Current Leg Code
03 Value |
10 |
165 |
174 |
CURVAL03 |
Where
rolltype=RP and valclass=03 and taxyr = param.taxyr |
|
ASMT_ALL |
VAL08 |
Current Leg Code
03 Acres |
10 |
175 |
184 |
CURACR03 |
Where
rolltype=RP and valclass=03 and taxyr = param.taxyr |
|
ASMT_ALL |
VAL05 |
Preliminary Leg
Code 03 Value |
10 |
185 |
194 |
PREVAL03 |
Where rolltype=RP
and valclass=03 and taxyr = param.taxyr and procname = PRELIM |
|
ASMT_ALL |
VAL08 |
Preliminary Leg
Code 03 Acres |
10 |
195 |
204 |
PRLIMACR03 |
Where
rolltype=RP and valclass=03 and taxyr = param.taxyr and procname =
PRELIM |
|
ASMT_ALL |
VAL05 |
Previous Leg Code
21 Value |
10 |
205 |
214 |
PRLIMVAL21 |
Where
rolltype=RP and valclass=21 and taxyr = param.taxyr-1 |
|
ASMT_ALL |
VAL08 |
Previous Leg Code
21 Acres |
10 |
215 |
224 |
PREACR21 |
Where rolltype=RP
and valclass=21 and taxyr = param.taxyr-1 |
|
ASMT_ALL |
VAL05 |
Current Leg Code
21 Value |
10 |
225 |
234 |
CURVAL21 |
Where
rolltype=RP and valclass=21 and taxyr = param.taxyr |
|
A |