MH117OH – HOMESTEAD EXTRACT

 

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

 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 MH117OH.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 HPLL132.

 

Figure 2. SY 41 (BOTTOM)

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

 

REPORT SAMPLE

 

 

SELECT T.DCODE, T.DNAME, '' B8,

  2      H.LOWINC, H.HIGHINC, '' B9,

  3      COUNT(T.PARID) NAPPS, '' B10,

  4      SUM(T.REDVAL) REDVAL, '' B11,

  5      SUM(T.REDTAX) redtax

  6    FROM TEMP_MH117 T, HMSDBKT H

  7   WHERE H.TAXYR = T.TAXYR

  8  AND H.ROLLTYPE = 'MH_OH'  -- ADDED  DLC 01/10/01

  9  AND NVL(T.INCOME,0) BETWEEN H.LOWINC AND H.HIGHINC

 10   GROUP BY T.DCODE, T.DNAME, H.LOWINC, H.HIGHINC;

                                                              PICKAWAY                                                             

MAR-29-2005                                     2004 MANUFACTURED HOMES HOMESTEAD ABSTRACT                                PAGE:    3

03:11 PM                                                                                                                 MH117OH   

JUR :000                                                                                                                            

                                                                                                                                   

DISTRICT                                                                                                                            

                                                   NUMBER OF           REDUCTION IN                REDUCTION IN                    

                       INCOME CLASS               APPLICANTS          TAXABLE VALUE                   TAXES                        

                                                         2                    2,436                      124.76                    

                                                                                                                                    

                                                                                                                                    

P33    WAYNE TWP                                                                                                                   

                         $0    $12,900                   1                    1,508                       86.32                    

                                                                                                                                    

       WAYNE TWP                                                                                                                   

                    $12,901    $18,900                   1                    1,176                       67.34                     

                                                                                                                                   

*****                                                                                                                               

                                                 ---------     --------------------     -----------------------                    

                                                                                                                                    

sum                                                                                                                                

                                                         2                    2,684                      153.66                    

                                                                                                                                   

                                                                                                                                    

                                                                                                                                   

                                                 ---------     --------------------     -----------------------                    

                                                                                                                                   

sum                                                                                                                                 

                                                        45                   57,489                    3,353.26                    

                                                                                                                                    

 

16 rows selected.

 

 

 

SET TERM OFF

SET ECHO OFF

 

 

 

                                                              PICKAWAY                                                              

MAR-29-2005                                     2004 MANUFACTURED HOMES HOMESTEAD ABSTRACT                                PAGE:    1

03:11 PM                                                                                                                 MH117OH   

JUR :000                                                                                                                           

                                                                                                                                   

COUNTY                                                                                                                              

                               NUMBER OF           REDUCTION IN                   REDUCTION IN                                     

   INCOME CLASS               APPLICANTS          TAXABLE VALUE                      TAXES                                          

       $0    $12,900                  27                   35,490                    2,010.28                                      

  $12,901    $18,900                  16                   20,999                    1,233.32                                       

  $18,901    $25,000                   2                    1,000                      109.66                                      

                               ---------     --------------------     -----------------------                                      

sum                                   45                   57,489                    3,353.26                                      

 

Updated 8/15/2006