Skip to main content

Go Search
Home
  
> Frequently Asked Questions > What tables do I need to update in RealWare before working in the future year?  

Frequently Asked Questions: What tables do I need to update in RealWare before working in the future year?

Question

What tables do I need to update in RealWare before working in the future year? 

Answer

There are certain tables in RealWare that we recommend you update at the beginning of each year. These are recommendations only, so update only the tables you think are important to your jurisdiction.
 
This maintenance can be done in either December or January and should be updated to the next year.  For example in Dec 2005 or Jan 2006, the tables should be updated with data for 2007.  Doing this will insert data into the table one year ahead of the current tax year.
The following tables can be copied using Table Maintenance in MassCalc (steps to do this are shown below the list of tables):
tlkpAbstCodeAgLandCost (only if used) - DOR
tlkpComCostLocalMult – CCI
tlkpIncome - COUNTY
tlkpNbhdAdj - COUNTY
tlkpResCostLocalMult - CCI
Steps to copy tables using MassCalc Table Maintenance:

Open the MassCalc Application.
From the Main Menu, click on Table Maintenance.
From the RealWare Lookup Tables screen, click on the Other Valuation Tables tab.
Select the table to copy from the list box on the left side of the screen.
Enter the year to copy to in the field next to the Copy Data to New button
Click the Copy Data to New button. The records have now been copied for the new tax year.
If necessary, edit the data in the table using the bottom half of the screen.
When done, click the Exit icon to return to the MassCalc Main Menu.
The following tables can be copied using Table Maintenance in RWAdmin (steps to do this are shown below the list of tables):
tlkpAbstCode - DOR
tlkpAuthorityFund  - COUNTY
tlkpDistrictAuthorities - COUNTY
tlkpTaxingAuthorities - COUNTY
IMPORTANT NOTE:  In tlkpAbstCode, ‘Exempt’ properties should have a -1 in the Exempt field to identify them as exempt. If they are not exempt, the entry in this field should be 0. Also verify that the Taxroll field is unchecked if the abstract should not go to tax roll or checked if it should be sent to tax roll.
 
Steps to copy tables using RWAdmin Table Maintenance:
Open the RWADMIN module
Move the mouse pointer over Table Maintenance and select the table to copy (either Taxing Authority or Abstract Code)
If you get a message warning you that the rollback segment is offline, click OK.
On the table maintenance screen, click the Copy Tax Year button
Enter the tax year to copy FROM in the Tax Year to process from field
Enter the tax year to copy TO in the Tax year to copy to field
Click the Process button
In the Statistics section of the screen, feedback will be provided showing the number of attempts and the total entries that were copied.  If any, the number of duplicates will also be shown. The number of attempts should match the number of entries copied.
When finished, click OK to close the copy box and return to the table maintenance screen.
Click the Exit icon to close the table maintenance screen.
The following tables can be maintained using RealWare Table Maintenance. Currently, there is no user interface available to copy these tables. You will need to copy new tax year data using either an update query or Find and Replace in Microsoft Access. If you need assistance with this, please contact Customer Support.
tlkpPPLivestock (only if used) - COUNTY
tlkpCondition - CCI
tlkpYearToCalcAge - COUNTY
Currently, there is no user interface available to copy or maintain the following tables. You will need to copy new tax year data using either an update query or Find and Replace in Microsoft Access. If you need assistance with this, please contact Customer Support.
tlkpAcctAdjustments - COUNTY
tlkpAsmntAdjCode (only if used) - COUNTY
tlkpAsmntAdjCodeList (only if used) - COUNTY
tlkpPPLife - DOR
tlkpPPPercentGood - DOR
tlkpPPRollbackfactors - DOR
tlkpPPTypeFactors - DOR
tlkpPPDetailDefaults (only if used) - CCI
tlkpScheduleBoard (only if used) - COUNTY
Again, if you have any questions about this process or need further assistance, please contact Customer Support at CCI.
 

Date Posted

11/19/2007 

Submitted By

 

Subject

CAMA 
Attachments
Created at 11/29/2011 4:58 PM  by David Chapman 
Last modified at 11/29/2011 4:58 PM  by David Chapman