13-Exhibit B - HCTRA BOS Upgrade Collections Hearings ICD v5.12.pdf
PDF 3 MB Posted
- Attached to
- RFP - Delinquent Toll Account Recovery and Management Services for the Harris County Toll Road Authority
- Solicitation number
- 26/0027
- Issued by
- Harris County, Texas
About this file
This Interface Control Document (ICD) outlines the technical specifications and operational procedures for the Collections and Hearings system interface between Harris County Toll Road Authority (HCTRA) and a collection agency. The document, version 5.12 dated January 19, 2023, and associated with Contract Number 10/0116 and PO P210470, defines the data exchange protocols, file formats, and system requirements necessary for managing delinquent toll account recovery and hearings processes. The interface utilizes Secure File Transfer Protocol (SFTP) for daily file transfers between HCTRA's Back Office System (BOS) and the collection agency's server. HCTRA transmits three types of outbound files: Placement (Toll Violation Invoice), Payment and Adjustments, and Demographic Outbound files, while receiving four types of inbound files: Demographic Inbound, Pre-Docket, Post-Docket, and Additional Fee files. All file transfers occur once per day, with the document specifying detailed field definitions, file naming conventions, delivery locations, and data exchange procedures. The system supports up to 10,000 records per file for both inbound and outbound transfers.
The document establishes comprehensive technical specifications for file formatting, including XML-based structures for placement and docket files and pipe-delimited formats for demographic and fee files. Escalation fees are detailed across multiple agencies (HCTRA, FBCTRA, and MCTRA) with varying fee schedules applied at different collection stages, ranging from administrative fees of $1.00 to $14.00 at placement through hearing citation fees of $50.00 to $60.00 and litigation-related fees. Case status scenarios are documented for dismissed, rescheduled, and judgment outcomes, with corresponding fee and status reason classifications. The interface includes configuration settings for SFTP server connections, field length specifications, and business rules governing payment statuses, delivery methods, and adjustment categories. No immediate acknowledgment/negative acknowledgment (ACK/NACK) responses are required upon file placement; instead, support personnel from either party contact each other as needed to resolve any file content or format issues.
View the file
Other files
Show all 15
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
| Interface | Control | Document |
| Collections | and | Hearings |
| Version | 5.12 | |
| January | 19, | 2023 |
Contract Number: 10/0116, PO P210470
COPYRIGHT
Copyright © 2019 Electronic Transaction Consultants Corporation. All rights reserved.
The information disclosed herein is CONFIDENTIAL and PROPRIETARY information.
Other than as reproduction or storage is permitted under that certain Agreement between Harris County and ETC, dated November 12, 2012, no part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or any means electronic or mechanical, including photocopying and recording for any purpose without permission, in writing, from ETC.
Document Control
Copyright © 2019 ETC Proprietary and Confidential – All Rights Reserved January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page i
Document History
Date Revision Author Summary of Changes
April 27, 2015 1.1 ETCC Initial Submittal
January 12, 2016 2.0 ETCC Resubmittal
January 19, 2016 3.0 ETCC Resubmittal
March 21, 2016 4.0 ETCC Adding Agency for Placement file
April 14, 2016 5.0 ETCC Update Field Definitions for Placement File
June 15,2016 5.1 ETCC Update Field Definitions for Post Docket File
July 06, 2016 5.2 ETCC Update Post docket for hearing date and time
September 02,2016 5.3 ETCC Updated field definitions for Payments and adjustments to include description.
Added Agency for cases in Pre-docket file.
September 16,2016 5.4 ETCC Added Agency to Eligible for Hearing, Payments and Adjustments, Demographic Outbound File.
September 23, 2016 5.5 ETCC Added list of values for some of fields as per request from Linebarger.
December 06,2016 5.6 ETCC Added company name to Placement file and Payments and Adjustments File.
December 19, 2016 5.7 ETCC Updated field descriptions for Demographic Outbound File
January 13, 2017 5.8 ETCC Added Appendix B – Escalation Fees
January 26, 2017 5.9 ETCC Updated Appendix B – Escalation Fees
February 3, 2017 5.10 ETCC Updated Appendix B – Escalation Fees and added Appendix C – Case Status Reasons
12/13/2017 ETCC Updated section 3.3.2. File Delivery Location, file delivery locations were not previously documented
10/19/2018 5.11 ETCC Modified the xmls and escalation fee table
01/19/2023 5.12 ETCC Modified the Table Structures for increased width
Document Control
Page ii Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Table of Contents
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page iii
Table of Contents
Copyright © 2019 ETCC Proprietary and Confidential – All Rights Reserved Page iv Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
| Table | of | Contents |
| General | .............................................................................................................. | 1 |
Overview
Assumptions
Reference Documents
Issues/Concerns
Acronyms and Abbreviations
Process/Data Flows
Outbound File
Inbound File
System Interfaces
Protocol
Web Service Interfaces
File Transfer Interfaces
Configuration Settings
SFTP Location
System Requirements
Collections and Hearings System Requirements
Business Rules
Escalation Fees
Table of Contents
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page v
Case Status Reasons
Scenarios Rescheduled
Scenarios Dismissed
Scenarios Judgement
Table of Contents
Page vi Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Table of Figures Figure 1: Outbound File Process Flow Figure 2: Inbound File Process Flow Figure 3: Payment and Adjustments Outbound File Format Figure 4: Payment and Adjustments Outbound File Format – With Invoice Fees Figure 5: Pre-Docket Inbound File Format Figure 6: Post-Docket Inbound File Format — Dismissed Figure 6: Post-Docket Inbound File Format — Judgment Figure 7: Post-Docket Inbound File Format — Reschedule
Table of Contents
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page vii
Table of Tables Table 1: Assumptions Table 2: Reference Documents Table 3: Issues/Concerns Table 4: Acronyms and Abbreviations Table 5: Outbound File Process Flow Table 6: Inbound File Process Flow Table 7: Data Exchanges Table 8: File Delivery Locations for File Interfaces Table 9: Placement (TVI) Outbound File Field Descriptions Table 10: Payment and Adjustments Outbound File Field Descriptions Table 11: Hearing Eligibility Outbound File Field Descriptions Table 12: Demographic Inbound File Field Descriptions Table 13: Demographic Outbound File Field Descriptions Table 14: Pre-Docket Inbound File Field Descriptions Table 15: Post-Docket Inbound File Field Descriptions Table 16: Additional Fee Inbound File Field Descriptions Table 17: Configuration Settings Table 18: Collection agency SFTP Server Configuration Settings Table 19: Collections and Hearings Table 20: Business Rules
Table of Contents
Page viii Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 1
General
Overview The purpose of this document is to record the process, business rules, and system interface requirements for the Collections and Hearings Interface. It includes technical details and operational information necessary to ensure proper usage and support for service operation.
The data exchanges are achieved through file-based transfers. The interfaces are as follows:
• An SFTP interface that sends the outbound file to the collections agency.
§ Includes TVI, Payment and Adjustments, and Demographic - Outbound files.
• An SFTP interface that receives the inbound file from the collections agency.
§ Includes Demographic - Inbound, Pre-docket, Post-docket, and Additional Fee files as necessary.
Assumptions The functionality within this document is proposed with the assumptions described in the table below.
Table 1: Assumptions
ID Description
1.2.1 The system shall support up to 10k data for both Inbound and Outbound files. It is assumed that HCTRA BOS and the Collection Agency creates the files that are not to exceed 10K data.
1.2.2 No other communication methods shall be implemented beyond what is defined in the document.
Reference Documents Additional information related to the Collections and Hearings functionality may be found within the following documents:
Table 2: Reference Documents
Document Filename Date
RITE CSC Detailed Design Document
RITE_CSC_DDD_BOS_Upgrade_v1.1_vol5_pt2.docx 4/27/2015
| Interface | Control | Document |
| Collections | and | Hearings |
Page 2 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Issues/Concerns There are no issues or concerns that impact the proposed solution.
Table 3: Issues/Concerns
ID Description Resolution Resolution Date
N/A There are no issues/concerns raised in this document.
N/A N/A
Acronyms and Abbreviations The table below defines acronyms and abbreviations used in Collections and Hearings.
Table 4: Acronyms and Abbreviations
Term Definition
BOS Back Office System
BRD Business Requirements Document
CSC Customer Service Center
DDD Detailed Design Document
DMV Department of Motor Vehicles
HCTRA Harris County Toll Road Authority
SFTP Secure File Transfer Protocol
TVI Toll Violation Invoice
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 3
Process/Data Flows
Outbound File The Outbound File Process Flow includes the tasks and steps listed in the table below.
Table 5: Outbound File Process Flow
Task Description
Build the file The process of the HCTRA BOS building the outbound file for sending to the collections agency.
Upload the file The process of the HCTRA BOS uploading the outbound file to the SFTP location for retrieval.
Process the file The process of the Collection Agency retrieving and processing the file.
| Interface | Control | Document |
| Collections | and | Hearings |
Page 4 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Outbound File Process Flow
The figure below illustrates the process flow for Outbound File.
Figure 1: Outbound File Process Flow
Outbound File Process Flow Explanation
The Outbound File Process Flow is as follows:
F'()*+H-!+./0123+"45+$56/53"+ 7015+"4$8/94+"45+7015+./0125$
(45+7015+./0125$+18#23+"45+70153+ "8+#+2570;52+!K(=+18>#"08;
(45+'8115>"08;+*95;>@+$5#23+ "45+$56/53"+70153+/A18#252+"8+ "45+!K(=+35$B5$+#;2+A$8>53353+
"45C
D;2
!"##ABC'"()*+A(B,)
-."BA//
01O)-."BA//
N5@
F '8115>"08;+*95;>@+4#3+ 033/53+G0"4+"45+$56/53"+
7015H
I '8115>"08;+*95;>@+
>8;"#>"3+F'()*+!/AA8$"+
=5$38;;51+"8+$5381B5+"45+
033/5
J53
O8
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 5
Inbound File The Inbound File Process Flow includes the tasks and steps listed in the table below.
Table 6: Inbound File Process Flow
Task Description
Upload the file The process of the Collection Agency uploading the inbound file to the SFTP location for retrieval.
Process the file The process of the HCTRA BOS retrieving, parsing and processing the file.
| Interface | Control | Document |
| Collections | and | Hearings |
Page 6 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Inbound File Process Flow
The figure below illustrates the process flow for Inbound File.
Figure 2: Inbound File Process Flow
Inbound File Process Flow Explanation
The Inbound File Process Flow is as follows:
"#$%F'(($)*+'H%-.$H)/%01('234% *#$%5$41'H4$%6+($4%*'%2%3$6+H$3%
78"9%(')2*+'H
;F"K-%=>7%5$234%*#$%5$41'H4$% 6+($4%01('23$3%?/%*#$%F'(($)*+'H%
-.$H)/
;F"K-%=>7%1254$4%*#$%6+($4%2H3%
15')$44$4%*#$A
!"##ABC'"()*+A(B,)
-."BA//
01O)-."BA//
B$/
CH3
7*25*
D ;F"K-%=>7%#24%+440$4%N+*#%
*#$%5$41'H4$%6+($F
G
;F"K-%7011'5*%9$54'HH$(%
)'H*2)*4%*#$%F'(($)*+'H4% -.$H)/%*'%5$4'(H$%*#$%
+440$
I$4
J'
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 7
System Interfaces
Protocol The protocol for the exchange of data utilized in the Collections and Hearings ICD is Secure File Transfer Protocol (SFTP) for communication with the Collection Agency regarding the Toll Violation Invoice (TVI), Demographic, Pre-docket, Post-docket, and Additional Fee files.
The table below lists all data exchanges.
Table 7: Data Exchanges
Web Service Interfaces Web services are not used for this interface.
File Transfer Interfaces HCTRA BOS sends TVI files on a daily basis to the Collection Agency and receives Demographic, Pre-docket, Post-docket, and Additional Fee files from the Collection Agency.
Any issues identified during the processing of either the Outbound or Inbound files have either the Collections Agency or the HCTRA BOS support staff contacting each other to resolve the issue.
All system related issues occurring within the HCTRA BOS in regards to this functionality are logged and sent to MOMS for ticket creation and assignment to support personnel.
Data Type Format Push / Pull Method / Protocol Frequency
Placement (TVI) XML HCTRA pushes the file to the vendors SFTP server
SFTP Once per day
Payment and Adjustments
XML HCTRA pushes the file to the vendors SFTP server
SFTP Once per day
Demographic – Inbound
Pipe Delimited
HCTRA pulls the file from the vendors SFTP server
SFTP Once per day
Demographic – Outbound
Pipe Delimited
HCTRA pushes the file to the vendors SFTP server
SFTP Once per day
Hearing Eligibility Pipe Delimited
HCTRA pushes the file to the vendors SFTP server
SFTP Once per day
Pre-docket XML HCTRA pulls the file from the vendors SFTP server
SFTP Once per day
Post-docket XML HCTRA pulls the file from the vendors SFTP server
SFTP Once per day
Additional Fee Pipe Delimited
HCTRA pulls the file from the vendors SFTP server
SFTP Once per day
| Interface | Control | Document |
| Collections | and | Hearings |
Page 8 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
File Naming Conventions
The examples below are the file naming conventions used for the Outbound File and Inbound File.
Placement – Outbound File
HCTRA_TVI_OUT_YYYYMMDDHH24MISS_CA.txt
Example:
HCTRA_TVI_OUT_20160102021030_CA.xml
Payment and Adjustments – Outbound file
HCTRA_PA_OUT_YYYYMMDDHH24MISS_CA.xml
Example:
HCTRA_PA_OUT_20160108020030_CA.txt
Hearings Eligibility – Outbound file
HCTRA_HEARINGS_OUT_YYYYMMDDHH24MISS_CA.txt
Example:
HCTRA_HEARINGS_OUT_20151203192500_CA.txt
Demographic – Inbound File
HCTRA_DEMO_IN_YYYYMMDDHH24MISS_CA.txt
Example:
HCTRA_DEMO_IN_20151207084030_CA.txt
Demographic – Outbound File
HCTRA_DEMO_OUT_YYYYMMDDHH24MISS_CA.txt
Example:
HCTRA_DEMO_OUT_20151104050500_CA.TXT
Pre-docket - Inbound File
HCTRA_PRE_IN_YYYYMMDDHH24MISS_CA.xml
Example:
HCTRA_PRE_IN_20141216143025_CA.txt
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 9
Post-docket - Inbound File
HCTRA_POST_IN_YYYYMMDDHH24MISS_CA.txt
Example:
HCTRA_POST_IN_20141216143025_CA.xml
Additional Fee - Inbound File
HCTRA_FEE_IN_YYYYMMDDHH24MISS_CA.txt
Example:
HCTRA_FEE_IN_20141216143025_CA.txt
File Delivery Location
The table below contains the file delivery locations for each file interface.
Root Directory à /files/rite
Table 8: File Delivery Locations for File Interfaces
Interface Name
Vendor SFTP Directory BOS Inbound Directory BOS Outbound
Directory Archive Directory
PreDocket
/RITE
Files/PreDock et/Outbound
<root directory>/collections/p reDocket/current NA
<root directory>/collections/ preDocket/archive
PostDocket
/RITE
Files/PostDoc ket/Outboun d
<root directory>/collections/p ostDocket/current NA
<root directory>/collections/ postDocket/archive
Additional Fee
/RITE
Files/Addition Fee/Outboun d
<root directory>/collections/a dditionalFee/current NA
<root directory>/collections/ additionalFee/archive
Demographic
/RITE
Files/Demogr aphic/Outbou nd
<root directory>/collections/D emographic/Inbound/cu rrent
<root directory>/collections/D emographic/Outbound/ current
<root directory>/collections/ demographic/<interfac e type>/archive
Placement
/RITE
Files/Inbound
/ NA
<root directory>/collections/p lacement/current
<root directory>/collections/ placement/archive
Payments and Adjustments
/RITE
Files/Inbound
/ NA
<root directory>/collections/a djustment/current
<root directory>/collections/ adjustment/archive
Hearings
/RITE
Files/Inbound
/ NA
<root directory>/collections/e ligibleHearing/current
<root directory>/collections/ eligibleHearing/archive
| Interface | Control | Document |
| Collections | and | Hearings |
Page 10 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
File Delivery Timetable
The File Delivery Timetable is once per day. HCTRA and the Collection Agency need to define the hour in which the files are transferred (TBD later).
Field Definitions
The following sections describe each field in the Outbound and Inbound files.
Placement (TVI) – Outbound File
The table below contains the field descriptions for the Placement (TVI) Outbound file.
Table 9: Placement (TVI) Outbound File Field Descriptions
Description XML Element Type Max Length
Require d Comment
Account Number account id Character 14 Y
Account Original Balance account_original_balanc e
Number 11,2 Y
Account Current Balance account_current_balanc e
Number 11,2 Y invoice invoice Complex NA Y
Invoice Number number Character 14 Y number is an attribute to Invoice element
Invoice Type type Character 3 Y type is an attribute to Invoice element. Can be Toll Violation Invoice/Finger Printing/Manned Booth Hold
Agency agency Character 2 Y agency is an attribute to Invoice element. HC for
HCTRA
FB for FBGPTRA MC for MCTRA
Invoice Date invoice_date Date NA Y YYYY-MM-DD
Vehicle Information vehicle_info Complex NA Y
Plate Number plate_number Character 15 Y
Plate State plate_state Character 3 Y
Plate Type plate_type Character 50 Y
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 11
Description XML Element Type Max Length
Require d Comment
Person Information person_info Complex NA Y
First Name first_name Character 100 N
Middle Initial middle_initial Character 100 N
Last Name last_name Character 100 N
Company Name company_name Character 200 N
License Number license_number Character 15 N
Address Information
Address_info Complex NA Y
Address Type addrType Character 15 Y addrType is an attribute of Address_info
Street Address 1 street_address1 Character 240 Y
Street Address 2 street_address2 Character 240 N
City city Character 240 Y
State state Character 3 Y
Zip zip Character 8 Y
Country country Character 20 Y
Contact information contact_info Complex NA N
Email email Character 100 N
Phone phone Character 10 N
Phone type type Character 10 N type is an attribute of phone element
Transaction txn Complex NA Y
Transaction Number id Number 14 Y id is an attribute of TXN element
Transaction Date & Time txn_date_time Character 21 Y YYYY-MM-DD HH24:MM:SS
Transaction Location txn_location Character 40 Y
Transaction Toll Original Amount Due txn_toll_original_amoun t_due
Number 6,2 Y
Transaction Toll Current Amount Due txn_toll_current_amoun t_due
Number 6,2 Y
Transaction Toll Payment txn_toll_payment Number 6,2 Y
| Interface | Control | Document |
| Collections | and | Hearings |
Page 12 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Description XML Element Type Max Length
Require d Comment
Transaction Toll Adjustment txn_toll_adjustment Number 6,2 Y
Transaction Fee txn_fee Complex NA Y
Transaction Fee Type type Character 25 Y type is an attribute of txn_fee.
Transaction Fee Original Amount Due txn_fee_original_amoun t_due
Number 6,2 Y
Transaction Fee Current Amount Due txn_fee_current_amoun t_due
Number 6,2 Y
Transaction Fee Payment txn_fee_payment Number 6,2 Y
Transaction Fee Adjustment txn_fee_adjustment Number 6,2 Y
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 13
Sample Data <placement_file> <accounts> <account id="2901499"> <account_original_balance>-148.00</account_original_balance> <account_current_balance>-148.00</account_current_balance> <invoice number="011802830114" type="TVI" agency="HC"> <invoice_date>2018-07-31</invoice_date> <vehicle_info> <plate_number>FTP4004</plate_number> <plate_state>TX</plate_state> <plate_type>N/A</plate_type> </vehicle_info> <person_info> <first_name>ISMAELA</first_name> <middle_initial></middle_initial> <last_name>GOSALES</last_name> <company_name> </company_name> <license_number></license_number> <address_info addrType="MAILING"> <street_address1>511 CHIMNEY ROCK</street_address1> <city>HOUSTON</city> <state>TX</state> <zip>77081</zip> <country>USA</country> </address_info> <contact_info> <phone type="HOME PHONE">5552458942</phone> <phone type="WORK PHONE">5553734022</phone> <email>myemail@YAHOO.COM</email> </contact_info> </person_info> <txn id="12421969502"> <txn_date_time>2018-04-20 08:31:26</txn_date_time> <txn_location>SH - SOUTH</txn_location> <txn_toll_original_amount_due>1.75</txn_toll_original_amount_due> <txn_toll_current_amount_due>1.75</txn_toll_current_amount_due> <txn_toll_payment>0.00</txn_toll_payment> <txn_toll_adjustment>0.00</txn_toll_adjustment> <txn_fee type="COUNTY ATTORNEY FEE"> <txn_fee_original_amount_due>1.00</txn_fee_original_amount_due> <txn_fee_current_amount_due>1.00</txn_fee_current_amount_due> <txn_fee_payment>0.00</txn_fee_payment> <txn_fee_adjustment>0.00</txn_fee_adjustment> </txn_fee> <txn_fee type="ADMINISTRATIVE FEE"> <txn_fee_original_amount_due>10.00</txn_fee_original_amount_due> <txn_fee_current_amount_due>10.00</txn_fee_current_amount_due> <txn_fee_payment>0.00</txn_fee_payment> <txn_fee_adjustment>0.00</txn_fee_adjustment> </txn_fee> </txn> <txn id="12423859579"> <txn_date_time>2018-04-20 19:15:25</txn_date_time> <txn_location>WPT - MLP2</txn_location> <txn_toll_original_amount_due>1.75</txn_toll_original_amount_due> <txn_toll_current_amount_due>1.75</txn_toll_current_amount_due> <txn_toll_payment>0.00</txn_toll_payment> <txn_toll_adjustment>0.00</txn_toll_adjustment> <txn_fee type="COUNTY ATTORNEY FEE"> <txn_fee_original_amount_due>1.00</txn_fee_original_amount_due> <txn_fee_current_amount_due>1.00</txn_fee_current_amount_due> <txn_fee_payment>0.00</txn_fee_payment> <txn_fee_adjustment>0.00</txn_fee_adjustment> </txn_fee> <txn_fee type="ADMINISTRATIVE FEE"> <txn_fee_original_amount_due>10.00</txn_fee_original_amount_due> <txn_fee_current_amount_due>10.00</txn_fee_current_amount_due>
| Interface | Control | Document |
| Collections | and | Hearings |
Page 14 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
<txn_fee_payment>0.00</txn_fee_payment> <txn_fee_adjustment>0.00</txn_fee_adjustment> </txn_fee> </txn> <txn id="12424723010"> <txn_date_time>2018-04-21 08:32:16</txn_date_time> <txn_location>SH - SOUTH</txn_location> <txn_toll_original_amount_due>1.75</txn_toll_original_amount_due> <txn_toll_current_amount_due>1.75</txn_toll_current_amount_due> <txn_toll_payment>0.00</txn_toll_payment> <txn_toll_adjustment>0.00</txn_toll_adjustment> <txn_fee type="COUNTY ATTORNEY FEE"> <txn_fee_original_amount_due>1.00</txn_fee_original_amount_due> <txn_fee_current_amount_due>1.00</txn_fee_current_amount_due> <txn_fee_payment>0.00</txn_fee_payment> <txn_fee_adjustment>0.00</txn_fee_adjustment> </txn_fee> <txn_fee type="ADMINISTRATIVE FEE"> <txn_fee_original_amount_due>10.00</txn_fee_original_amount_due> <txn_fee_current_amount_due>10.00</txn_fee_current_amount_due> <txn_fee_payment>0.00</txn_fee_payment> <txn_fee_adjustment>0.00</txn_fee_adjustment> </txn_fee> </txn> <txn id="12424888444"> <txn_date_time>2018-04-21 10:09:11</txn_date_time> <txn_location>KTY EB @ ELDRIDGE</txn_location> <txn_toll_original_amount_due>0.50</txn_toll_original_amount_due> <txn_toll_current_amount_due>0.50</txn_toll_current_amount_due> <txn_toll_payment>0.00</txn_toll_payment> <txn_toll_adjustment>0.00</txn_toll_adjustment> <txn_fee type="COUNTY ATTORNEY FEE"> <txn_fee_original_amount_due>1.00</txn_fee_original_amount_due> <txn_fee_current_amount_due>1.00</txn_fee_current_amount_due> <txn_fee_payment>0.00</txn_fee_payment> <txn_fee_adjustment>0.00</txn_fee_adjustment> </txn_fee> <txn_fee type="ADMINISTRATIVE FEE"> <txn_fee_original_amount_due>10.00</txn_fee_original_amount_due> <txn_fee_current_amount_due>10.00</txn_fee_current_amount_due> <txn_fee_payment>0.00</txn_fee_payment> <txn_fee_adjustment>0.00</txn_fee_adjustment> </txn_fee> </txn> </invoice> </account> </accounts> </placement_file>
Payment and Adjustments Outbound File
The table below contains the field descriptions for the Payment and Adjustments Outbound File.
Table 10: Payment and Adjustments Outbound File Field Descriptions
Description XML Element Type Max Length
Require d Comment
Accounts accounts Complex NA Y
Account Account Complex NA Y
Account Number id Character 14 Y ID is the attribute of account
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 15
Description XML Element Type Max Length
Require d Comment invoice invoice Complex NA Y
Agency Agency Character 2 Y Agency is an attribute to Invoice element
Invoice Number number Character 14 Y number is an attribute to Invoice element
Vehicle Information vehicle_info Complex NA Y
Plate Number plate_number Character 15 Y
Plate State plate_state Character 3 Y
Plate Type plate_type Character 3 Y
Person Information person_info Complex NA Y
First Name first_name Character 100 N
Middle Initial middle_initial Character 100 N
Last Name last_name Character 100 N
Company Name
Company_name Character 200 N
Address Information
Address_info Complex NA Y
Address Type addrType Character 15 Y addrType is an attribute of Address_info
Street Address 1 street_address1 Character 240 Y
Street Address 2 street_address2 Character 240 N
City city Character 240 Y
State state Character 3 Y
Zip zip Character 8 Y
Country country Character 20 Y
Contact information contact_info Complex NA N
Email email Character 100 N
Phone phone Character 10 N
Phone type type Character 10 N type is an attribute of phone element List of values-
• HOME PHONE
• WORK PHONE
• FAX
• CELL PHONE
| Interface | Control | Document |
| Collections | and | Hearings |
Page 16 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Description XML Element Type Max Length
Require d Comment
Payments payments Complex N/A
Payment payment Complex N/A
Delivery Method delivery_mode Character 20 Y attribute of payment List of values-
• PHONE
• WALK-IN
• LOCKBOX
• COLLECTION
AGENCY
• WEBSITE
• IVR
• AUTOCHARGE
Payment Date payment_date Date NA Y attribute of payment
Payment ID payment_id Number 14 Y attribute of payment
Payment Status payment_status Character 20 Y attribute of payment
• APPLIED
• BOUNCED
• BOUNCED BANK
ACC
• CHARGEBACK
• DECLINED
• FAILED
• OPEN
• PENDING
• VOID
• VOID FAILED
• VOID NOT
REQUIRED
• HANGING
PAYMENTS
Payment categories posting_categories Complex N/A NA
Type of Payment posting_categoriy Complex N/A NA
Type of Payment name Character 50 Y name is an attribute of posting_category Type of payment List of values -
• PAYMENT
APPLICATION
• PAYMENT REVERSAL
(There might be more added in future)
Items Items complex N/A
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 17
Description XML Element Type Max Length
Require d Comment
Invoice Fee Amount
Inv_fee Number 6,2 N
Invoice Fee Name
Name character 50 N Name is an attribute of complex type inv_fee
Transaction Txn Complex Type
N/A NA
Toll Transaction
ID
id Number 14 N Attribute of txn
Toll Transaction
Txn_toll Number 6,2 N
Transaction Fee Amount
Txn_fee Number 6,2 N
Transaction Fee Name
Name Character 50 N Name is an attribute of complex type txn_fee
Adjustments adjustments Complex N/A
Type of Adjustment posting_category Complex N/A
Name of Adjustment name Character 50 Y name is an attribute of posting_category Type of adjustment List of values -
• TOLL ADJUSTMENT
• EXCUSE CHARGES
• UNASSIGN TOLL
CHARGES
UNDO EXCUSE CHARGES
(There might be more added in future)
Items Items complex N/A
Invoice Fee Amount
Inv_fee Number 5,2 N
Invoice Fee Name
Name character 50 N Name is an attribute of complex type inv_fee
Transaction Txn Complex N/A NA
Toll Transaction
ID
id Number 14 N Attribute of txn
Toll Transaction
Txn_toll Number 6,2 N
Transaction Fee Amount
Txn_fee Number 6,2 N
Additional additional Complex N/A
Type of additional posting_category Complex N/A
| Interface | Control | Document |
| Collections | and | Hearings |
Page 18 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Description XML Element Type Max Length
Require d Comment
Name of additional fee name Character 50 Y name is an attribute of posting_category
Items Items complex N/A
Invoice Fee Amount
Inv_fee Number 6,2 N
Invoice Fee Name
Name character 50 N Name is an attribute of complex type inv_fee List of values -
• INVOICE LEVEL FEE
CHARGES
• TOLL LEVEL FEE
CHARGES
Transaction Txn Complex N/A NA
Toll Transaction
ID
id Number 14 N Attribute of txn
Toll Transaction
Txn_toll Number 6,2 N
Transaction Fee Amount
Txn_fee Number 6,2 N
Transaction F ee Name
Name Character 50 N Name is an attribute of complex type txn_fee
Payment and Adjustments Outbound File Format
This section gives the payment and adjustments outbound file format with an example. The example is XML-based.
<adjustment_file> <accounts> <account id="2252"> <invoice agency=”HC” number="12064"> <vehicle_info> <plate_numer>TEST60</plate_numer> <plate_state>TX</plate_state> <plate_type>N/A</plate_type> </vehicle_info> <person_info> <first_name>GORDON</first_name> <middle_initial>KAYE</middle_initial> <last_name>NELSON</last_name> <address_info addrType="MAILING"> <city>RICHARDSON</city> <state>TX</state> <country>USA</country> <street_address1>1705 N PLANO RD</street_address1> <street_address2> </street_address2> <zip>75081</zip> </address_info> <contact_info> <phone type="HOME PHONE">555-567-6651</phone> <email>HCTRA@DEVEXCHANGE.LOCAL</email> </contact_info>
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 19
</person_info> <payments> <payment delivery_mode="MAIL" payment_date="2016-01-07 15:50:31.0" payment_id="1957" payment_status="APPLIED"/> <posting_categories> <posting_category name="PAYMENT APPLICATION"> <items> <txn id="67745"> <txn_fee name="COUNTY ATTORNEY FEE">1</txn_fee> <txn_fee name="COLLECTION FEES">2</txn_fee> </txn> <txn id="67747"> <txn_fee name="COUNTY ATTORNEY FEE">1</txn_fee> <txn_fee name="COLLECTION FEES">13</txn_fee> </txn> <txn id="67748"> <txn_fee name="COUNTY ATTORNEY FEE">1</txn_fee> <txn_fee name="COLLECTION FEES">2</txn_fee> </txn> </items> </posting_category> </posting_categories> </payments> </invoice> </account> </accounts> </adjustment_file>
Figure 3: Payment and Adjustments Outbound File Format
<adjustment_file> <accounts> <account id="3252"> <invoice agency=”HC” number="22064"> <vehicle_info> <plate_numer>TEST70</plate_numer> <plate_state>TX</plate_state> <plate_type>N/A</plate_type> </vehicle_info> <person_info> <first_name>GORDON</first_name> <middle_initial>KAYE</middle_initial> <last_name>NELSON</last_name> <address_info addrType="MAILING"> <city>RICHARDSON</city> <state>TX</state> <country>USA</country> <street_address1>1705 N PLANO RD</street_address1> <street_address2> </street_address2> <zip>75081</zip> </address_info> <contact_info> <phone type="HOME PHONE">555-567-6651</phone> <email>HCTRA@DEVEXCHANGE.LOCAL</email> </contact_info> </person_info> <payments> <payment delivery_mode="MAIL" payment_date="2016-01-07 15:50:31.0" payment_id="1957" payment_status="APPLIED"/> <posting_categories> <posting_category name="PAYMENT APPLICATION"> <items>
<inv_fee name="COUNTY HEARING FEE">50.00</inv_fee> <txn id="67745"> <txn_fee name="COUNTY ATTORNEY FEE">1</txn_fee> <txn_fee name="COLLECTION FEES">2</txn_fee>
| Interface | Control | Document |
| Collections | and | Hearings |
Page 20 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
</txn> <txn id="67747"> <txn_fee name="COUNTY ATTORNEY FEE">1</txn_fee> <txn_fee name="COLLECTION FEES">13</txn_fee> </txn> <txn id="67748"> <txn_fee name="COUNTY ATTORNEY FEE">1</txn_fee> <txn_fee name="COLLECTION FEES">2</txn_fee> </txn> </items> </posting_category> </posting_categories> </payments> </invoice> </account>
Figure 4: Payment and Adjustments Outbound File Format – With Invoice Fees
Hearing Eligibility – Outbound File
The table below contains the field descriptions for the Hearing Eligibility Outbound file.
Table 11: Hearing Eligibility Outbound File Field Descriptions
Field Description Data Type Length Comments
Account ID Char 14 A1
Invoice Number Char 14 A2
Agency Char 2 A3
Hearing Eligibility Outbound File Format
This section gives the Hearing Eligibility Outbound file format with an example.
Each field in the hearing eligibility outbound file is separated by the “|” char, which is the field delimiter.
Name: HCTRA_HEARINGS_OUT_YYYYMMDDHH24MISS_CA.txt
A1|A2|A3| Where:
A1 = Account ID A2 = Invoice Number A3= Agency
Example:
600918540|01180413610|HC|
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 21
Demographic – Inbound/Outbound File
Demographic Inbound File
The table below contains the field descriptions for the Demographic Inbound File.
Table 12: Demographic Inbound File Field Descriptions
Field Description Data Type Length Comments
Account ID Number 14 F1
Invoice Number Char 14 F2
First Name Char 240 F3
Middle Initial Char 240 F4
Last Name Char 240 F5
Plate Number Char 15 F6
Plate State Char 3 F7
Plate Type Char 3 F8
Source Char 6 F9 “Manual”
Address line1 Char 240 F10
Address line2 Char 240 F11
City Char 240 F12
State Char 3 F13
Country Char 20 F14
Zip Code Number 8 F15
Zip Code+4 Number 4 F16
Home Phone Char 12 F17 Formatted NNN-NNN-NNNN
Work Phone Char 12 F18 Formatted NNN-NNN-NNNN
Mobile Phone Char 12 F19 Formatted NNN-NNN-NNNN
Email Address Char 100 F20
Reissue Flag Char 1 F21
Demographic Inbound File Format
This section gives the demographic inbound file format with an example.
Each field in the Demographic inbound file is separated by the “|” char, which is the field delimiter.
| Interface | Control | Document |
| Collections | and | Hearings |
Page 22 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Name: HCTRA_DEMO_IN_20151207084030_CA.txt
F1|F2|F3|F4|F5|F6|F7|F8|F9|F10|F11|F12|F13|F14|F15|F16|F17|F18|F19|F20|F21
Where:
F1 = Account ID F2 = Invoice Number F3 = First Name F4 = Middle Initial F5 = Last Name F6 = Plate Number F7 = Plate State F8 = Plate Type F9 = Source F10 = Address line1 F11 = Address line2 F12 = City F13 = State F14 = Country F15 = Zip Code F16 = Zip Code+4 F17 = Home Phone F18 = Work Phone F19 = Mobile Phone F20 = Email Address F21 = Reissue Flag
Example:
861105221|12345|Doe|K|Jane|BGG123|TX|R|Manual|1705 N Plano Rd||Richardson|TX|USA|75081|9992|555- 451-1122|555-451-1122|555-451-1122|jd@email.com|Y|
Demographic Outbound File
The table below contains the field descriptions for the Demographic Outbound File.
Table 13: Demographic Outbound File Field Descriptions
Field Description Data Type Length Comments
Account ID Number 14 F1
Invoice Number Char 14 F2
First Name Char 240 F3
Middle Initial Char 240 F4
Last Name Char 240 F5
Plate Number Char 15 F6
Plate State Char 3 F7
Plate Type Char 2 F8
Address line1 Char 240 F9
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 23
Field Description Data Type Length Comments
Address line2 Char 240 F10
City Char 240 F11
State Char 3 F12
Country Char 20 F13
Zip Code Number 8 F14
Zip Code+4 Number 4 F15
Home Phone Char 12 F16 Formatted NNN-NNN-NNNN
Work Phone Char 12 F17 Formatted NNN-NNN-NNNN
Mobile Phone Char 12 F18 Formatted NNN-NNN-NNNN
Email Address Char 100 F19
Agency Char 2 F20
Demographic Outbound File Format
This section gives the demographic outbound file format with an example.
Each field in the demographic outbound file is separated by the “|” char, which is the field delimiter.
Name: HCTRA_DEMO_OUT_20151104050500_CA.TXT
F1|F2|F3|F4|F5|F6|F7|F8|F9|F10|F11|F12|F13|F14|F15|F16|F17|F18|F19|F20
F1 = Account ID F2 = Invoice Number F3 = First Name F4 = Middle Initial F5 = Last Name F6 = Plate Number F7 = Plate State F8 = Plate Type F9 = Address line1 F10 = Address line2 F11 = City F12 = State F13 = Country F14 = Zip Code F15 = Zip Code+4 F16 = Home Phone F17 = Work Phone F18 = Mobile Phone F19 = Email Address F20 = Agency
| Interface | Control | Document |
| Collections | and | Hearings |
Page 24 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Example:
2481|19003|MAI||NGUYEN|THH8888|LA|PASSENGER|911 E CAMPBELL||RICHARDSON|TX|USA|75081||214-
555-0000|||HCTRA@DEVEXCHANGE.LOCAL|HC
Pre-Docket Inbound File
The table below contains the field descriptions for the Pre-Docket Inbound File.
Table 14: Pre-Docket Inbound File Field Descriptions
Description XML Element Type Max
Lengt h
Require d Comment
Pre Docket pre_docket Complex N/A Y
Accounts accounts Complex N/A Y
Account account Complex N/A Y
Account Number id Character 14 Y Id is an attribute of complex type account
Cases cases Complex N/A Y
Case Number case_number Complex N/A Y
Case Number id Character 50 Y Id is an attribute of complex type case_number
Agency agency Character 14 Y HCTRA
FBCTRA
MCTRA
Hearing Date hearing_date Character 10 Y
Hearing Time hearing_time Character 8 Y
Hearing Location hearing_location Character 50 Y
Plate Number plate_number Character 15 Y
Plate State plate_state Character 2 Y
Plate Type plate_type Character 10 Y
Invoices invoices Complex N/A Y
Invoice invoice Complex N/A Y
Invoice Number Number Character 14 Y Number is an attribute of complex type Invoice
Invoice Type Type Character 3 Y type is an attribute of complex type Invoice
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 25
Description XML Element Type Max
Lengt h
Require d Comment
Additional Fee additional_fee Complex N/A N
Fee fee Number 6.2 N
Fee Type type Character 25 N type is an attribute of complex type fee
Pre-Docket Inbound File Format
This section gives the pre-docket inbound file format with an example.
XML Example:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <pre_docket> <accounts> <account id="183"> <cases> <case_number id="20" agency=”HCTRA”> <hearing_date>11/25/2014</hearing_date> <hearing_time>10:30 am</hearing_time> <hearing_location>Harris County Prairie St</hearing_location> <plate_number>THA654</plate_number> <plate_state>TX</plate_state> <plate_type>PAS</plate_type> <invoices> <invoice type="TVI" number="011210946662"> <additional_fee> <fee type="3P CITATION FEE">50.00</fee> </additional_fee> </invoice> <invoice type="TVI" number="011210233517" /> <invoice type="TVI" number="011210537983" /> </invoices> </case_number>
</cases> </account> <account id="186"> <cases> <case_number id="21" agency=”HCTRA”> <hearing_date>11/25/2014</hearing_date> <hearing_time>10:30 am</hearing_time> <hearing_location>Harris County Prairie St</hearing_location> <plate_number>THA654</plate_number> <plate_state>TX</plate_state> <plate_type>PAS</plate_type> <invoices> <invoice type="TVI" number="011211084861"> <additional_fee> <fee type="COUNTY HEARING FEE">4.00</fee> </additional_fee> </invoice> </invoices> </case_number> </cases> </account>
</pre_docket>
| Interface | Control | Document |
| Collections | and | Hearings |
Page 26 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Figure 5: Pre-Docket Inbound File Format
Post-Docket Inbound File
The table below contains the field descriptions for the Post-Docket Inbound File.
Table 15: Post-Docket Inbound File Field Descriptions
Description XML Element Type Max Length
Require d Comment
Pre Docket pre_docket Complex N/A Y
Accounts accounts Complex N/A Y
Account account Complex N/A Y
Account Number id Character 14 Y Id is an attribute of complex type account
Case Number case_number Complex N/A Y
Case Number id Character 50 Y Id is an attribute of complex type case_number
Plate Number plate_number Character 15 Y
Plate State plate_state Character 3 Y
Plate Type plate_type Character 10 Y
Hearing Status hearing Status Complex N/A Y
Hearing Status id Character 30 Y Id is an attribute of complex type Hearing Status
Hearing Status Reason hearing_status_reason Character 30
Hearing Date hearing_date Character 10 N
Hearing Time hearing_time Character 8 N
Judgement Date judgement_date Character 10 N
Judgement Time judgement_time Character 8 N
Invoices Invoices Complex N/A N
Invoice Invoice Complex N/A N
Invoice Number number Character 14 Y Number is an attribute of complex type Invoice
Invoice Type type Character 3 Y type is an attribute of complex type Invoice
Additional Fee additional fee Complex N/A N
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 27
Description XML Element Type Max Length
Require d Comment
Fee fee Number 6.2 N
Fee Type type Character 20 N type is an attribute of complex type fee
Dismissal dismissal Complex N/A N
Fee fee Number 6.2 N
Fee Type type Character 20 N type is an attribute of complex type fee
Transaction txn Complex NA N
Transaction Number id Number 14 N id is an attribute of txn element
Toll toll Number 6.2 N Amount of the toll being excused, Fee fee Number 6.2 N
Fee Type type Character 20 N type is an attribute of complex type fee
Post-Docket Inbound File Format
This section gives the post-docket inbound file format with examples. Examples are XML based.
The sample below shows a Post –Docket Inbound File Format Dismissed.
<accounts> <account id="2004961530"> <case_number id="N17268"> <plate_number>AN48596</plate_number> <plate_state>TX</plate_state> <plate_type>N/A</plate_type> <hearing_status id="dismissed"> <hearing_status_reason>paid in full</hearing_status_reason> </hearing_status> </case_number> </account>
</post_docket>
| Interface | Control | Document |
| Collections | and | Hearings |
Page 28 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Figure 6: Post-Docket Inbound File Format — Dismissed
The sample below shows a Post –Docket Inbound File Format Judgment.
<account id="2003419027"> <case_number id="P20028"> <plate_number>BH9G029</plate_number> <plate_state>TX</plate_state> <plate_type>N/A</plate_type> <hearing_status id="judgement"> <hearing_status_reason>did not appear</hearing_status_reason> <judgement_date>08/28/2018</judgement_date> <judgement_time>01:30 pm</judgement_time> </hearing_status> <invoices> <invoice number="011211602890" type="TVI"> <additional_fee> <fee type="COUNTY HEARING FEE">60.00</fee> <fee type="3P HEARING FEE">50.00</fee> <fee type="COUNTY FINE 1">500.00</fee> </additional_fee> </invoice> <invoice number="011415486118" type="TVI" /> <invoice number="011415494622" type="TVI" /> <invoice number="011416159177" type="TVI" /> <invoice number="011519050916" type="TVI" /> <invoice number="011519048774" type="TVI" /> </invoices> </case_number> </account> </accounts>
Figure 6: Post-Docket Inbound File Format — Judgment
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 29
The sample below shows a Post –Docket Inbound File Format Rescheduled.
<account id="2006036707"> <case_number id="P25195"> <plate_number>HVP7269</plate_number> <plate_state>TX</plate_state> <plate_type>N/A</plate_type> <hearing_status id="reschedule"> <hearing_status_reason>Agency Request</hearing_status_reason> <hearing_date>10/18/2018</hearing_date> <hearing_time>01:30 pm</hearing_time> <hearing_location>Harris County Prairie St</hearing_location> </hearing_status> </case_number> </account> </accounts>
Figure 7: Post-Docket Inbound File Format — Reschedule
Additional Fee Inbound File
The table below contains the field descriptions for the Additional Fee Inbound File.
Table 16: Additional Fee Inbound File Field Descriptions
Field Description Data Type Length Comments
Account ID Number 14 A1
Invoice Number Cha 14 A2
Fee Type Char 40 A3
Amount Char 6.2 A4
Additional Fee Inbound File Format
This section gives the additional fee inbound file format with an example.
Each field in the additional fee inbound file is separated by the “|” char, which is the field delimiter.
Name: HCTRA_FEE_IN_YYYYMMDDHH24MISS_CA.txt
A1|A2|A3|A4
A1 = AccountID A2 = Invoice Number
| Interface | Control | Document |
| Collections | and | Hearings |
Page 30 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
A3 = Fee Type A4 = Amount
Example:
2003252411|011211081267|FIRM ATTORNEY FEES INTEREST|466.46
Ack/Nack
The Input and Output files do not have an ACK/NACK response immediately after file placement on the shared SFTP server. If necessary HCTRA BOS Support Personnel or the Collection Agency Support Personnel contact each other as necessary with any issues or concerns regarding input/output file content or format.
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 31
Configuration Settings
SFTP Location The table below contains the configuration setting values for the HCTRA SFTP server.
Table 17: Configuration Settings
Server Name IP Address Username Password bos-sftp.hctra.pri 10.40.236.36 sftp_bos DBA Group has the password
The table below contains the configuration settings for the Collection agency SFTP Server.
Table 18: Collection agency SFTP Server Configuration Settings
DMV Server Name IP Address Username Password
Bos-sftp-linebarger.hctra.pri
N/A FF_Harris_County_TX_TRA DBA Group has the password
| Interface | Control | Document |
| Collections | and | Hearings |
Page 32 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
System Requirements
Collections and Hearings System Requirements The table below lists all the system requirements for the Collections and Hearings interface.
Table 19: Collections and Hearings
Requirement ID Description RTM #
NA NA NA
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 33
Business Rules The table below lists all the business rules for this interface.
Table 20: Business Rules
RTM # Description
NA NA
| Interface | Control | Document |
| Collections | and | Hearings |
Page 34 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
Escalation Fees Agency Invoice
Type Escalation State Fee Name Fee Amount File Name Active
HCTRA TVI TVI COUNTY ATTORNEY FEE 1.00 Placement Outbound Y HCTRA TVI TVI ADMINISTRATIVE FEE 10.00 Placement Outbound Y HCTRA MBH MANNED BOOTH COUNTY ATTORNEY FEE 1.00 Placement Outbound Y HCTRA MBH MANNED BOOTH ADMINISTRATIVE FEE 10.00 Placement Outbound Y HCTRA FP FINGERPRINTING COUNTY ATTORNEY FEE 1.00 Placement Outbound Y HCTRA FP FINGERPRINTING ADMINISTRATIVE FEE 10.00 Placement Outbound Y HCTRA TVI COLLECTIONS COUNTY ATTORNEY LETTER FEE 9.00 Placement Outbound N HCTRA TVI COLLECTIONS COLLECTION FEES 14.00 Placement Outbound Y
HCTRA TVI HEARING 3P CITATION FEE 50.00 PRE_DOCKET Y
HCTRA TVI ADJUDICATION COUNTY ATTORNEY OFFICE FEE 1.00 POST_DOCKET N
HCTRA TVI ADJUDICATION COUNTY FINE 2 1.00 POST_DOCKET Y
HCTRA TVI ADJUDICATION COUNTY FINE 1 1.00 POST_DOCKET Y
HCTRA TVI ADJUDICATION COUNTY HEARING FEE 60.00 POST_DOCKET Y
HCTRA TVI ADJUDICATION 3P HEARING FEE 50.00 POST_DOCKET Y
HCTRA TVI LITIGATION COUNTY SERVICE FEE 1.00 ADDITIONAL_FEE Y
HCTRA TVI LITIGATION FIRM MEDIATION FEE 1.00 ADDITIONAL_FEE Y
HCTRA TVI LITIGATION COUNTY MEDIATION FEE 1.00 ADDITIONAL_FEE Y
HCTRA TVI LITIGATION FIRM ATTORNEY FEES INTEREST 1.00 ADDITIONAL_FEE Y
HCTRA TVI LITIGATION FIRM FILING FEES 1.00 ADDITIONAL_FEE Y
HCTRA TVI LITIGATION COUNTY ATTORNEY FEES INTEREST 1.00 ADDITIONAL_FEE Y
HCTRA TVI LITIGATION COUNTY ATTORNEY OFFICE FEE 1.00 ADDITIONAL_FEE N
FBCTRA TVI TVI ADMINISTRATIVE FEE 5.00 Placement Outbound Y FBCTRA FP FINGERPRINTING ADMINISTRATIVE FEE 5.00 Placement Outbound Y FBCTRA TVI COLLECTIONS COLLECTION FEES 14.00 Placement Outbound Y
FBCTRA TVI HEARING 3P CITATION FEE 50.00 PRE_DOCKET Y
FBCTRA TVI ADJUDICATION COUNTY ATTORNEY OFFICE FEE 1.00 POST_DOCKET N
FBCTRA TVI ADJUDICATION COUNTY FINE 2 1.00 POST_DOCKET Y
FBCTRA TVI ADJUDICATION COUNTY FINE 1 1.00 POST_DOCKET Y
FBCTRA TVI ADJUDICATION COUNTY HEARING FEE 60.00 POST_DOCKET Y
FBCTRA TVI ADJUDICATION 3P HEARING FEE 50.00 POST_DOCKET Y
FBCTRA TVI LITIGATION COUNTY ATTORNEY OFFICE FEE 0.00 ADDITIONAL_FEE N
FBCTRA TVI LITIGATION FIRM MEDIATION FEE 1.00 ADDITIONAL_FEE Y
FBCTRA TVI LITIGATION FIRM FILING FEES 1.00 ADDITIONAL_FEE Y
FBCTRA TVI LITIGATION FIRM ATTORNEY FEES INTEREST 1.00 ADDITIONAL_FEE Y
FBCTRA TVI LITIGATION COUNTY ATTORNEY FEES INTEREST 1.00 ADDITIONAL_FEE Y
FBCTRA TVI LITIGATION COUNTY SERVICE FEE 1.00 ADDITIONAL_FEE Y
FBCTRA TVI LITIGATION COUNTY MEDIATION FEE 1.00 ADDITIONAL_FEE Y
MCTRA TVI TVI COUNTY ATTORNEY FEE 0.00 Placement Outbound Y MCTRA TVI TVI AGENCY ADMINISTRATIVE FEE 1.00 Placement Outbound Y MCTRA TVI TVI ADMINISTRATIVE FEE 10.00 Placement Outbound Y MCTRA FP FINGERPRINTING AGENCY ADMINISTRATIVE FEE 1.00 Placement Outbound Y MCTRA FP FINGERPRINTING ADMINISTRATIVE FEE 10.00 Placement Outbound Y
| Interface | Control | Document |
| Collections | and | Hearings |
January 19, 2023 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx Page 35
MCTRA FP FINGERPRINTING COUNTY ATTORNEY FEE 0.00 Placement Outbound Y MCTRA TVI COLLECTIONS COLLECTION FEES 14.00 Placement Outbound Y
MCTRA TVI HEARING 3P CITATION FEE 50.00 PRE_DOCKET Y
MCTRA TVI ADJUDICATION COUNTY FINE 1 1.00 POST_DOCKET Y
MCTRA TVI ADJUDICATION COUNTY FINE 2 1.00 POST_DOCKET Y
MCTRA TVI ADJUDICATION COUNTY ATTORNEY OFFICE FEE 1.00 POST_DOCKET N
MCTRA TVI ADJUDICATION COUNTY HEARING FEE 60.00 POST_DOCKET Y
MCTRA TVI ADJUDICATION 3P HEARING FEE 50.00 POST_DOCKET Y
MCTRA TVI LITIGATION FIRM FILING FEES 1.00 ADDITIONAL_FEE Y
MCTRA TVI LITIGATION FIRM MEDIATION FEE 1.00 ADDITIONAL_FEE Y
MCTRA TVI LITIGATION COUNTY SERVICE FEE 1.00 ADDITIONAL_FEE Y
MCTRA TVI LITIGATION COUNTY ATTORNEY FEES INTEREST 1.00 ADDITIONAL_FEE Y
MCTRA TVI LITIGATION COUNTY MEDIATION FEE 1.00 ADDITIONAL_FEE Y
MCTRA TVI LITIGATION FIRM ATTORNEY FEES INTEREST 1.00 ADDITIONAL_FEE Y
| Interface | Control | Document |
| Collections | and | Hearings |
Page 36 Exhibit X - HCTRA_BOS_Upgrade_CollectionsHearings_ICD_v5.12.docx January 19, 2023
| Case | Status | Reasons |
| Scenarios | Rescheduled |
Scenarios Dismissed
!"#$%&'"'(# )**+'+,-".%/"'"%+-%012% &3#'$4%)5'+,- 67$8"'+,-".%#'$7#%9:8+,8%',%:,#'%/,5;$'< &=,8'%/$#58+7'+,- %2,-L%/$#58+7'+,- !""#$%&'()&*+&H" -#%".%+/%0'(1+&("#(/""#$%&'($&*+&H" 2&3(4&/$.%5(1/"&(/%1(".6& !5&%0'()&*+&H" -#%".%+/%0'(1+&("#(!5&%0'($&*+&H" 2&3(4&/$.%5(1/"&(/%1(".6& !00#+%"(7#81&$()&*+&H" -#%".%+/%0'(1+&("#(!00#+%"(7#81&$($&*+&H" 2&3(4&/$.%5(1/"&(/%1(".6& 9/'6&%"(98/%(0$&/"&1 9/'6&%"(98/%(0$&/"&1 2&3(4&/$.%5(1/"&(/%1(".6&
?$#5=$*(.$%=$"8+-L% @,8%&'"'$*%*"'$%"-*%
'+4$
?$#5=$*(.$*
!"#$%&'"'(# &)#'$*%+,'-./ 01$2"'-./"3%#'$1#%452-.2%'.%5.#'%6.,7$'8 &9.2'%6$#,2-1'-./ %:./;%6$#,2-1'-./
!"#$%F'(()( '(()(F*+HF-)F!"#$%F !"/,$3%,"#$<%$=,(#$%9$"2-/;%
./0*F01F2+33 "30H1-F4/0*F/5)+1-F)6H*F01F7+33 !"/,$3%!"#$ 2+33F./85H1-F/4430H*
./85H1-F.3/1F9)543H-H* ./85H1-F.3/1F9)543H-H* !"/,$3%!"#$ ./85H1-F.3/1F"(H/-H*
:)3* "30H1-F4();0*H*F<033F)7F=/3HF7)(F;H>093H !"/,$3%!"#$ ?1/==0@1F#(/1=/9-0)1=AB61H(=>04F*/-HF9>/1@HC MEFF'(()( '(()(F01FMEFF017)(5/-0)1F4();0*H*FGF6()1@F4/-()1 !"/,$3%!"#$ ?1/==0@1F#(/1=/9-0)1=AB61H(=>04F*/-HF9>/1@HC .3/-HF")((H9-0)1 H()1@F309H1=HF43/-HF0*H1-070H* !"/,$3%!"#$ M0=4+-HI.3/-HF")((H9-0)1 :-)3H1FFH>093HF$H4)==H==H* FH>093HF6/=F1)-F01F930H1-F4)==H==0)1 !"/,$3%!"#$ M0=4+-HIF?1/==0@1F#(/1=/9-0)1= .H(FM0;)(9HFMH9(HH "30H1-F4();0*H*F4())7F)7FM0;)(9HFMH9(HH !"/,$3%!"#$ M0=4+-HIF?1/==0@1F#(/1=/9-0)1=
'5H(@H198FFH>093H FH>093HF0=F/F'5H(@H198FFH>093H !"/,$3%!"#$ 2+33FHJ9+=/3
%9-0;HFE030-/(8 "30H1-F6/=F/F5H5<H(F)7F5030-/(8F%9-0;HF*+-8 !"/,$3%!"#$ 2+33FHJ9+=/3
:H--3H5H1-F./0* "30H1-F4/0*F/@(HH*F=H--3H5H1-F/5)+1- !"/,$3%!"#$ 2+33F'J9+=/3
MH9H/=H* "30H1-F0=F*H9H/=H* !"/,$3%!"#$ 2+33F'J9+=/3
O/1L(+4-98 "30H1-F>/=F*H93/(H*F</1L(+4-98 !"/,$3%!"#$ 2+33F'J9+=/3
!"#$%&'"'(#%L$"#./
6-#*-##$?
6-#*-##$?
6-#*-##$?
| Interface | Control | Document |
| Collections | and | Hearings |
January 19,…
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .