GovTech/AutoAgent
State provides tax roll
eGov imports and maintains tax roll into suite
eGov suite is always maintaining current and delinquent bills and balances
Tracking payments and balances throughout the calendar year
Escrow companies (Wells Fargo, Loretta, Corelogic etc) send bulk payment for multiple bills at a time beginning in late October/ early November
GovTech/AutoAgent provide escrow companies a service to lookup an amount that is currently due for the parcels they are responsible for
Escrow companies are than able to create payment files in the eGov format through the portals. Coincide with ACH/wire or a check
Payment file indicates the bills that the lump payment is covering and the amount applied to each bill.
How eGov Delivers the Information
AutoAgent
There is a suite command (./egov suite:propertytax:generate:auto_agent_file_export) that generates a file to be uploaded to AutoAgent
This file includes information about all current tax year bills as well as any delinquent prior year bills that still have a balance
The file that stores this command is located
app/Commands/PropertyTax/AutoAgentFileExportCommand.php
Govtech
There is a suite command (./egov suite:propertytax:generate:govtech_file_export) that generates a file to be uploaded to GovTech
This file includes information about all current tax year bills as well as any delinquent prior year bills that still have a balance
The file that stores this command is located
app/Commands/PropertyTax/GovTechFileExportCommand.php
How AutoAgent/GovTech provide payment information to eGov
Both AA/GT create a payment file from the bills chosen by the escrow company for payment
The payment file is a fixed width flat file
Full specs on the payment file can be found here - [enter link]
There are two payment file specs. (full requirements doc - https://catalisgov.atlassian.net/browse/EGOVD-5635 )
Legacy file format - from 2012 - supports 7 digit bill numbers
Revised 2019 file format - supports 10 digit bill numbers
The eGov suite is told that it is a 10 digit format by including a header line which state “eGov payment 10 digit”
How to import a payment file
In the eGov suite go to the ‘Property Tax’ tab → under the ‘import/export’ heading select the ‘import file’ option
There will be a drop down, select ‘Mortgage File’. There is a second option that says ‘Mortgage File - multiple checks’ that does NOT work
Steps to test file script is correct
Create a non temporary site in the staging tool
In this example, you name the site 7330 in Jefferson
ssh stage1
docker exec -it 7330 /bin/bash
./egov suite:propertytax:generate:govtech_file_export
IF not testing FTP, if testing FTP, use step 6
chmod 777 tmp/govtech_export_08012020.csv && mv -iv tmp/govtech_export_08012020.csv public/govtech_export_08012020.csv
attach ‘public/govtech_export_08012020.csv’ to the end of your staging link, and you will download the file.
curl -T tmp/govtech_export_08012020.csv ftp://ftp.govtechtaxpro.com/tn_jefferson/ --user egovftp:SqprtbzT
NOTE the file name will be the day the file is created, be sure to update the commands accordingly. Also in the FTP step, be sure to change the county name to what ever county you are loading the file for.