Attachment A - High Level Overview.pptx
PPTX presentation 3 MB Posted
- Attached to
- DTMO Travel Data Repository Support
- Solicitation number
- H98210DTMOCTIM
- Issued by
-
Defense Human Resources Activity
About this file
The provided document appears to be a PowerPoint presentation that provides a high-level overview of the Defense Travel Management Office's (DTMO) Commercial Travel Information Management (CTIM) data repository. The presentation covers the CTIM's data sources, process flow, operational statistics, and data management functions.
The related federal contract opportunity is for the DTMO to acquire database and infrastructure contractor support services for the CTIM data repository. The government intends to award this contract on a sole-source basis and is currently conducting market research to identify interested and capable vendors. The key requirements include providing database management, data integration, data quality, and business intelligence support for the CTIM system, which ingests travel data from over 20 sources to support DoD-wide applications, reporting, and performance management.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment C - Data Sources.xlsx | XLSX spreadsheet | |
| 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
CTIM Overview Erik Footland May 28, 2024
Department of Defense | Defense Human Resources Activity
Defense Travel Management Office
Big Picture DTMO Data Components of our Data House CTIM Data Sources (High Level) CTIM Process Flow CTIM…by the numbers Data Operations Travel Daily Overview Questions Agenda
Agenda
Defense Travel Management Office Big Picture DTMO Data External Reporting Performance Management
Commercial Travel Information Management (CTIM)
Produces per diem rate extracts used by:
DTS
Travel systems Other user that travels on government per diem rates Supporting NDAA 2012 Near real time validations of travel vouchers Tracks recovery of over payments Premium Class Travel Greenhouse Gas Emissions AMC airline volume Contract City Pair
GSA TRIP
3,000+ Ad Hoc Reports One-stop shop for travel tools:
Training Knowledge Management (self help) Travel Assistance Center (TAC) Trip Estimating Tools ~21 DTMO Managed Programs ~200 Performance Metrics Travel information database Centralizes over 20 data sources Supports:
DoD-wide applications Congressional reporting DoD & Federal reporting Performance Management Business Intelligence
Operational Management DoD Preferred Lodging Program Dining Program Rental Car Ceiling Rates
Components of our Data House Travel Daily CTIM Master Data Quality BI Tool Travel Card CTO Monthly
DTS
Reference Data
Expanding our analogy a bit:
Our data sources are the four walls of our house, holding everything up Internal walls are reference data Data Quality is the foundation that everything is built on CTIM Master is the roof, what everything else holds up BI Tool is our front door. It’s how we let others into the database
CTIM Data Sources (High Level)
DTS
Per Diem Travel Card Bus Lodging Rental Car Air Other Travel Vouchers (Future)
Allowances TMC PNRs Reference Data
Dining
Additionally: CBA, PCTRT, Metadata/Data Governance, ARC, TMC Contract, CT, Currency Rates, Travel Daily, FEMA Hotels, GSA City Pair, RVAT, TMC Fee, Rail, Passport, CTIM Master Data Sources
CTIM Process Flow
CTIM…by the numbers
17 Terabytes of Data 26+ Data Sources 1300+ Tables 50k+ Columns 42B+ Records 150+ Scripts 10+ External Recurring Reports 50+ BI Metrics 15+ Applications As of: 28MAY24
Data Operations
| Function | Description | Examples |
| Data Collection | Ingest & integrate multiple data sources | DTS Data |
Rental Car Data CTO Data
| Data Architecture Integration | |
| New data source integrations | Preferred Lodging |
Bus Data Travel Card Data Development Develop new tables and logic CT
PCTRT
BI
| Data Maintenance | Monitor for issues, trouble shoot, and resolve | Missing Files from Vendors |
| Business Intelligence Support | Create tables to support BI projects | CT Reports |
Dining KPIs Lodging Metrics
| Infrastructure Support | Technical and testing support for database and supported software | Oracle Upgrade Impact |
| Data Lineage | Data Traceability Matrix | All |
| Data Quality Program | Monitor & address data quality issues | All |
Travel Daily Overview Proprietary code (WorldCue) owned by Crisis24 Ingests Passenger Name Records (PNRs) from Sabre and Worldspan Global Distribution Systems (GDS) Provides near real-time booking and ticketing data Current yearly cost ~ $631.5k Travel Daily size represents 52% of the CTIM database (8.12TB) Future RFI for future work.
$631.5k for current year of Worldcue License & Support Cost breakdown:
$366k Worldcue Annual Subscription $122k PNR Software/GDS Service ($74k) Discount $217.5k Estimated cost for sweeping PNRs (based on volume) This estimate is based on the number of PNRs processed during
Questions image1.png image2.jpeg image3.png image4.jpeg image5.jpeg image6.jpg image60.jpeg image61.png image62.png image63.png image64.jpg image71.png image72.png image73.png image74.png image75.png image76.png image77.svg image65.png image66.png image67.png image68.png image69.png image70.png image78.png
File details come from the government source that posted it. Updated .