User Tools

Site Tools


thebeaglecollector

Using The Beagle With WinCollect

The Beagle is a powerful tool for extracting data from applications, as long as you know what data you wish to locate and where to look for it. With that in mind, the below is a list of the report sources from which data can be extracted and what each is best used for:

  • vwQRActiveProperty - This report source mimics searches on the Property tab in WinCollect where “Search History” is unchecked. This typically returns only parcels for the Current tax year as well as any unpaid delinquents. This returns only basic Property level details.
  • vwQRActivePropertyTaxes - This is the same as vwQRActiveProperty, but includes Tax detail instead of just Property detail. Use this when you want to look for the existence of specific Tax types or Districts.
  • vwQRCorrection - This report source will return Correction information as well as the associated Tax and Property information related to it.
  • vwQRMailLog - This report source returns data from the Email Log, including CURRENT Taxpayer information, which may or may not match the Taxpayer information at the time the document was mailed.
  • vwQRProperty - This report source mimics searches on the Property tab in WinCollect where “Search History” is checked. Note this will return all parcels, even those paid for years, so you will typically only use it when you want to explicitly look at history. This returns only Property level details for those parcels.
  • vwQRPropertyTaxes - This is the same as vwQRProperty, but includes Tax detail instead of just Property detail. Use this when you want to look for the existence of specific Tax types or Districts. Note that since this returns all Tax types for all Property, even those paid for years, results can get large and slow very quickly.
  • vwQRReceipts - This report source will return Receipt information.
  • vwQRRefunds - This report source will return Refund information as well as the associated Receipt information.
  • vwQRRelatedItems - This report source will return information from the Related Items tab for Property and Taxpayers. Because each record could be linking either Taxpayer or Property to one or the other type, the fields were named generically as ChildField1 through ChildField3 and ParentField1 through ParentField3. The contents of the three fields will be:
    • Property - Parcel, Book, Tax Year
    • Taxpayer - TPID, Taxpayer Name, Address 1
  • vwQRSecurityLog - This report source will return entries from the Security Log. Note that until mid-2009, the LogType field did not exist, so the Comments will be the best source of information prior to that point. If you wish to filter by LogType, the types are as follows:
    • CORR - Corrections
    • PROP - Property
    • RCPT - Receipts
    • TPID - Taxpayer
  • vwQRTaxpayer - This report source will return all Taxpayers in the database.
  • vwQRTaxpayerBalance - This report source contains Taxpayer information as well as a total balance due from Active Property. This emulates the results from the Taxpayer search screen where “Taxpayers With Property” is checked.
  • vwQRTransactions - This report source will return ALL transactions from ALL parcels, regardless of how old they are. While a great resource for looking at detail transactions, the query and returned results can get large and slow very quickly.
  • vwQRTransactionsActiveProperty - The same as vwQRTransactions, but limited to Active Property parcels, namely either Current year parcels or unpaid Delinquents.
  • vwQRUserSecurity - This report source will return the results of the User Security lookup table, allowing you to report on what functions users have access to.

A note on Delinquent amounts due in report sources such as vwQRProperty, etc.: For Delinquent Personal, the costs, fees, etc., are static and will match what WinCollect shows. For Delinquent Real Estate, the costs and fees are static, but the Interest is dynamic. Since there is not a way to pass to The Beagle an Interest Date to use, the default upon install is 10 days in the future. If there is a different number of days in the future you would like to use to calculate interest for these extracts, please contact Apprentice Information Systems Customer Support, and we will be happy to adjust it for you.

Wincollect
Final Settlement

Other Wikis

Cloud Words

thebeaglecollector.txt · Last modified: 2017/04/21 13:58 (external edit)