AA150NS – Tax District Summary

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.

 

Text Box: AA150.lis is the output spool file generated after the report is completed. It appears as the following:











Flat File      : TAXDIST.DAT                                
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            


TAX DISTRICT SUMMARY

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