Attachment C - Data Sources.xlsx
XLSX spreadsheet 16 KB Posted
- Attached to
- DTMO Travel Data Repository Support
- Solicitation number
- H98210DTMOCTIM
- Issued by
-
Defense Human Resources Activity
About this file
This document appears to be an attachment titled "Attachment C - Data Sources.xlsx" that lists various data sources and their characteristics related to a federal travel data repository known as the Commercial Travel Information Management (CTIM) system.
The file provides details on 23 different data sources used to populate the CTIM repository, including information on the data type, frequency, data source description, and the number of files. Key data sources include travel booking data, travel management company data, government travel charge card transactions, DTS voucher data, rental car data, and per diem data. The data is compiled from various government and vendor sources on a regular (often daily or monthly) basis and integrated into the CTIM repository.
This information appears to be related to a pre-solicitation opportunity from the Defense Travel Management Office (DTMO) for a contract to provide database and infrastructure support for the CTIM travel data repository. The Government is seeking interested and capable vendors to potentially provide these services on a sole source basis.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment A - High Level Overview.pptx | PPTX presentation | |
| Attachment B - TMC_Data_Requirement Guide_V6.3.1.1 29MAR2023.pdf | ||
| PWS_DTMO Travel Data Support_DRAFT.docx | DOCX document | |
| Sources Sought CTIM.docx | DOCX document |
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
Sheet1
| # | Name of Data Set | Type | Number of files | Frequency | Data Source | Description |
| 1 | Travel Daily | PNR | Daily |
tc={5D86A357-7478-41F0-B55D-2EC13961F65E}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Every 15 minutes we do a PNR sweep. | Data Vendor | Travel Daily is the near-real time feed of PNR data queued into CTIM directly from the TMC’s PCCs. Pre-trip data – doesn’t capture changes in travel. | ||
| 2 | TMC Monthly | formatted text file | 17+ |
tc={5F30A6EA-5403-49F4-BB14-DEBC96522FE5}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Around 10 files now, this can fluctuate based on the # of TMC's and also updated files for fixes. | Monthly | Contracted TMCs | Formerly known as STATCO, is a monthly report of data for all tickets issued from a TMC during the previous month, compiled from TMC back office systems and provided by the 15th of the following month | ||||
| 3 | Government Travel Charge Card (GTCC) | formatted text file | 4 - five x a week; | ||||
| 5 - Monthly | Daily/Monthly | Citi Bank | Citi provides four daily files (five times a week) sets including every transaction that has posted since the last file for every DOD travel card (IBA and CBA included) | ||||
| 4 | DTS Voucher | formatted text file | 10 | 2x a week | PMO-DTS | Travel voucher data from DTS | |
| 5 | Rental Car | formatted text file | 18 | Monthly/Quarterly | Rental Car vendors | Rental Car vendors participating in DTMO agreement provide transaction level reporting on a monthly or quarterly basis of all Federal car rental transactions | |
| 6 | Contract City Pair | formatted text file | 1 | Yearly/monthly updates | GSA | List of Contract City Pair locations (Air travel) | |
| 7 | GTCC Rental Car | formatted text file | 1 | monthly | GSA | Rental car transactions charged to a Federal Travel card for all Departments minus DoD | |
| 8 | ARC | formatted text file | 1 | monthly | GSA | DoD air flown based on Airline Reservation Corp. data | |
| 9 | Per Diem | formatted text file | 17 | Monthly/Semi Annually | DOS, GSA, DTMO | Data files of authorized per diem rates | |
| 10 | Meals & Quarters | formatted text file | 1 | Quarterly/ad hoc update |
tc={731858F2-3C88-4025-82A2-FC6C8FA5F671}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| 1 file for Meals, 1 file for Quarters. | DTMO | Data on meals and quarters availability at military locations | |||||
| 11 | Lodging Vendor | formatted text file | 1 | Monthly | GSA FEDROOMS | Commercial Lodging data from participating vendors in ILP | |
| 12 | CTIM Master | Updated per schedule | Travel Daily, TMC Monthly, GTCC, vendor data | An integrated repository of validated pre- and post-trip travel data, compiled from Travel Daily, CTO Monthly, Travel Card, DTS and vendor data | |||
| 13 | TMS |
tc={91B3098F-4EA9-4530-A278-EE830167A736}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| New line added. | formatted text file | 1 | Monthly | Oracle - RightNow | Ticket Management System Data |
| 14 | DTMO Passport |
tc={E7325584-0A90-464F-81C5-FC50378C6B37}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| New line added. | SSIS Import | 3 | Daily (every 15 minutes) | SQL Server | Via an SSIS job from SQL Server we import 3 delta files into CTIM. |
| 15 | Dinova |
tc={5C8AA025-6C6E-49C3-9F0A-7824068B1E69}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
New row formatted text file 6 Monthly/Quarterly Dinova Dining files we receive monthly and quarterly:
Monthly: opt in, activity report, participating restaurant, franchise report, rebate report Quarterly: Executive Summary
16 FEMA
tc={1FFAE28F-FFA7-4687-AC7F-5366EF5FB5B1}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| New row | formatted text file | 1 | Monthly | FEMA | Download and pull in FEMA hotel list once/month for reference table updates. |
| 17 | BAH |
tc={A1D4DBE7-9510-4D29-8442-F11819D6AC56}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| New row | formatted text file | 3 | Yearly | BAH | Basic Allowance Housing data loaded into app once/year for calculations |
| 20 | PCTRT |
tc={BE909C44-A1FA-432C-8C76-6DF14AE2F517}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| New row | Updated per schedule | Travel Daily, TMC Monthly, GTCC, vendor data | An integrated repository of validated pre- and post-trip travel data, compiled from Travel Daily, CTO Monthly, Travel Card, DTS and vendor data | ||
| 21 | Compliance Tool |
tc={98AFF29C-7AE2-4276-8791-ED9767DC40EF}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
New row tc={5D86A357-7478-41F0-B55D-2EC13961F65E}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Every 15 minutes we do a PNR sweep.
tc={5F30A6EA-5403-49F4-BB14-DEBC96522FE5}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| Around 10 files now, this can fluctuate based on the # of TMC's and also updated files for fixes. | Updated per schedule | DTS, Travel Card | Data is created based on DTS and Travel Card data which is run after the DTS data is loaded |
| 22 | Currency Rates |
tc={10A81B17-7662-49CA-8642-F7C4E04CDC7A}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
| New row | formatted text file | 1 | Daily | Daily load of Currency Rates |
| 23 | Travel Mart |
tc={10611CAD-A5DA-4344-A6BD-30F782FD6876}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
New row tc={731858F2-3C88-4025-82A2-FC6C8FA5F671}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
1 file for Meals, 1 file for Quarters.
tc={91B3098F-4EA9-4530-A278-EE830167A736}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
New line added.
tc={E7325584-0A90-464F-81C5-FC50378C6B37}: [Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
New line added. Updated per schedule Travel Daily, TMC Monthly, GTCC, vendor data An integrated repository of validated pre- and post-trip travel data, compiled from Travel Daily, CTO Monthly, Travel Card, DTS and vendor data
Data Repository - Major Data Sources
Page &P of &N
File details come from the government source that posted it. Updated .