Fleet EDS Data Files
Thredd can supply you with daily data reports in the XML file format.
If you need to keep transaction records over time, you must follow the standard business processes in your organisation for maintaining the records.
Sending Schedule
Generated reports are sent once per day, at a precise time that meets your business requirements. You can choose the InitiationTime (scheduled run time), as well as the FromTime and ToTime (cut-off times) for each report. The following table describes each of the time options for the report sending schedule.
|
Time |
Description |
|---|---|
|
InitiationTime |
The time of day you select for Thredd to start the generation of the report. |
|
FromTime |
The earliest time threshold/start interval during the day for timestamp transactions to be included in the report. By default, FromTime = ToTime over a 24h period. |
|
ToTime |
The latest time threshold/end interval during the day for the timestamp transactions to be included in the report. InitiationTime is always >= to the ToTime. |
|
GenerationTime |
The duration of time spent to produce a report, spanning between the InitiationTime and the time when the file for the report has been created. |
|
TransportationTime |
The duration of time spent to copy an available file/report from Thredd's systems to your sFTP folder. |
|
DeliveryTime |
The precise time when the file/report is available in your sFTP folder for pick-up. |
The DeliveryTime depends on the InitiationTime, and both the GenerationTime and TransportationTime (which vary). The number of processed records in the reports/the report sizes will influence all the time categories. However, it will directly influence both the GenerationTime and the TransportationTime.
For example, if a report has an Initiation Time of 3 pm. The GenerationTime is 30 minutes and the TransportationTime is 5 minutes. Then the DeliveryTime is 3:35 pm (3 pm + 30 minutes + 5 minutes).
Visa Clearing Cycles
When setting a report schedule, you should consider Visa's clearing cycles as this determines when you receive transactions with presentment data. Consider the following:
-
Visa provide two clearing files (Domestic and International) each day.
-
For International visa cycles, different timings exist for some regions (for example, Australia and Hong Kong).
-
There is a maximum file size where, for the largest clients, it is possible that more than one Domestic and/or International file will be received on the same day.
-
Visa domestic cycles start at 9 am, while international cycles start at midday. The clearing cycles run seven days a week.
Report Availability
The report files are provided on a push-only basis. After two calendar days, the sFTP files are deleted from the Thredd sFTP server. These are then stored on Thredd's archive server for a limited period.
If you need copies of historical sFTP files, Thredd can regenerate them for you on request.
File Naming Convention
Thredd use the following naming convention for the delivered report files: [THRD]-[PPPP]-[FLEET2.0]-[YYYYMMDDmm-YYYYMMDDmm].[PX](_REG).xml
Where:
-
THRD — Abbreviation for Thredd.
-
[PPPP] – Destination institution that a report is sent to.
-
FLEET2.0 — The report code where, in this case, it is Fleet 2.0.
-
YYYYMMDDHHmm —The start date and time. This is formatted as:
-
YYYY: Year (4 digits)
-
MM: Month (2 digits)
-
DD: Day (2 digits)
-
HH: Hour (2 digits)
-
mm: Minutes (2 digits)
-
- YYYYMMDDHHmm —The end date and time. This is formatted as:
YYYY: Year (4 digits)
MM: Month (2 digits)
DD: Day (2 digits)
HH: Hour (2 digits)
mm: Minutes (2 digits)
-
PX — The Thredd production environment used to generate the report, value of X indicating the exact environment.
-
(_REG) — A conditional suffix added to files/reports that have been manually regenerated.
-
xml The file extension as XML.
And:
-
[] indicates mandatory elements of the file name.
-
() indicates conditional elements of the file name.
Filename Example
THRD-CARDCO-FLEET2.0-2026052415-2026052425.P0_REG.xml
Encryption and Encoding
CSV files are encrypted using the Pretty Good Privacy (PGP) encryption program, which requires the sharing of keys. For details, contact your implementation manager.