D-3a Data Dictionary.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Transportation Security Administration Checkpoint Integrated Logistics Support (ILS) Services
- Solicitation number
- TSA25-04-0338
About this file
This document contains a data dictionary and work order table field definitions for transportation security equipment maintenance activities. It defines over 80 data elements related to asset and metrics reporting, including serial numbers, asset types, manufacturers, locations, warranty status, operational hours and downtime, maintenance work orders, problem and failure codes, parts, and timestamps. The data will be loaded into a database to support maintenance and logistics services for transportation security checkpoint equipment.
The related federal contract opportunity is for Transportation Security Administration Checkpoint Integrated Logistics Support Services. It is a special notice posted on the Federal Business Opportunities website. The solicitation number is TSA25-04-0338. The opportunity involves providing logistics and maintenance support services for security screening equipment used at transportation checkpoints. The required services include corrective and preventative maintenance, as well as parts acquisition and inventory management. The contracting agency is the Department of Homeland Security's Transportation Security Administration.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Questions and Answers.pdf | ||
| Attachment D13 H_H_H - RTM 5May21.pdf | ||
| Part F- Attachment TSE Inventory List.xlsx | XLSX spreadsheet | |
| D-2 Contract Data Requirements Lists (CDRLs).zip | ZIP file | |
| Attachment D7 - TSA ILS SLA Performance Metrics.rtf | RTF text file | |
| D-1 Fed Airport Listing and Airport Operational Hours.xlsx | XLSX spreadsheet | |
| D-2 Data Item Descriptions (DIDs).zip | ZIP file | |
| D-3 TSE Metrics Terms and Definitions and RMA Metrics.docx | DOCX document | |
| Attachment D-12 Cybersecurity and Enterprise Architecture Policy.docx | DOCX document | |
| ILS Checkpoint Draft PWS 12.19.pdf |
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
Asset_and_Metrics
| Asset and Metrics | ||
| Field Name | Description | Data Type |
| ReportPeriod | The reporting month that Metrics and Validations occur, most always listed in the filename. | nvarchar(255) |
| SERIALNUM | OEM assigned serial number, unique to the OEM/Model and identical to that recorded in TSA’s inventory records. | nvarchar(255) |
| ASSETTYPE | Identifies the type of TSE as defined by TSA. (AIT, ASL, AT, ATCT, ATXRAY, EDS, BLS, ETD) | nvarchar(255) |
| TECH | EBSP or PSP | nvarchar(255) |
| MODELNUM | Identifies the type of TSE as defined by TSA. It is a combination of the OEM Product Category and Model | nvarchar(255) |
| OEM | Identifies the manufacturer of the TSE unit as standardized by TSA. | nvarchar(255) |
| STATUS | Identifies the status of the maintenance activity in more detail. | nvarchar(255) |
| AIRPORT | Identifies the location of the TSE unit. For all airport locations, the value should be the standard. 3-character FAA assigned ID. | nvarchar(255) |
| WARRANTYAPPLIES | Indicates whether or not the operational hours reported in this record are for a period during which the TSE unit is under warranty. | Float |
| WARRANTYEXPDATE | The expiration date for the warranty that covers the asset expressed in airport local time. | Datetime |
| Operational Hours | Indicates the number of operational hours the TSE Unit was theoretically available for service during the reporting period. | Float |
| Operational Downtime | The period of time during an airport’s operational hours that TSE is not in a condition to perform its required mission | Float |
| Ao | Operational Availability by Unit as defined in RMA Metrics document. | Float |
| WOCOUNT | Total number of Work Orders. | Float |
| DT_CloseTicket | Downtime using Close Ticket accounting as defined by TSA RMA Metrics documentation. | Float |
| FC_CloseTicket | Failure Count of Close Ticket Work Orders. | Float |
| MDT | Derived Metric for Mean Down Time | Float |
| MTBCF | Derived Metric for Mean Time Between Critical Failure | Float |
| CDT_CloseTicket | Critical Down Time for Close Ticket Accounting | Float |
| CFC_CloseTicket | Critical Failure Count for Close Ticket Accounting | Float |
| MTBF | Derived Metric for Mean Time Between Failure | Float |
| FILENAME | The monthly excel file to be loaded to the database | nvarchar(255) |
| POSTEDDATETIME | The date and time the monthly excel file is actually loaded to the database. | Datetime(255) |
WorkOrder
| WorkOrder Table | ||
| Field Name | Description | Data Type |
| ReportMonth | The reporting month that Metrics and Validations occur, most always listed in the filename. | nvarchar(255) |
| WONUM | Uniquely identifies a particular maintenance event as captured in the MSP’s incident tracking system. Typically refers to the MSP’s work order, service request, trouble ticket, service call, etc. | nvarchar(255) |
| SERIALNUM | OEM assigned serial number, unique to the OEM/Model and identical to that recorded in TSA’s inventory records. | nvarchar(255) |
| MODELNUM | Identifies the type of TSE as defined by TSA. It is a combination of the OEM Product Category and Model | nvarchar(255) |
| ASSETTYPE | Identifies the type of TSE as defined by TSA. Example: AIT, ATXRAY, BLS, EMD, or ETD. | nvarchar(255) |
| OEM | Identifies the Original Equipment Manufacturer of the TSE unit. | nvarchar(255) |
| TECH | ESBP or PSP | nvarchar(255) |
| AIRPORT | Identifies the location of the TSE unit. For all airport locations, the value should be the standard. 3-character FAA assigned ID. | nvarchar(255) |
| WARRANTYAPPLIES | Indicates whether or not the operational hours reported in this record are for a period during which the TSE unit is under warranty. | Float |
| 1 = Under Warranty, 0 = Under Contract | ||
| WARRANTYEXPDATE | The expiration date for the warranty that covers the asset expressed in airport local time | Datetime |
| CM/PM | Identifies the type of maintenance activity as defined in TSA Metrics. CM – Corrective Maintenance, PM = Preventative Maintenance | nvarchar(2) |
| DEPOT | States whether the Maintenance Event (Work Order) was ever in Depot. (YES,NO) | nvarchar(255) |
| TCS | Identifies whether the WO is in TCS status | nvarchar(255) |
| CRITICALITY | Indicates whether or not the maintenance event is deemed critical according to criteria expressed in TSA Metrics. 1=Critical, 0=Not Critical | Float |
| RELEVANCY | Indicates whether or not the maintenance event is deemed relevant according to criteria expressed in TSA Metrics. 1=Relevant, 0=Not Relevant. | Float |
| DESCRIPTION | A detailed explanation of the Work Order. | nvarchar(255) |
| T1 | First recording of the Work Order. Call Center Contacted. | Datetime |
| T9 | TSE Ready for Signoff | Datetime |
| StartTime | Date and time at which the maintenance event was opened, reported in airport/location local time. | Datetime |
| EndTime | Date and time at which the maintenance event was closed, reported in airport/location local time. | Datetime |
| Operational Downtime | The period of time during an airport’s operational hours that TSE is not in a condition to perform its required mission | Float |
| CloseTicket | Accounting as listed by the RMA Metrics documentation. | Float |
| DT_CloseTicket | Down Time for Close Ticket Accounting as listed by the RMA Metrics documentation. | Float |
| PROBLEMCODE | TSA approved FMI code indicating Problem on TSE | nvarchar(255) |
| PROBLEMCODEDESCRIPTION | A detailed explanation of the Problem and Problem Code | nvarchar(255) |
| CAUSECODE | TSA approved FMI code indicating Cause of problem on TSE | nvarchar(255) |
| CAUSECODEDESCRIPTION | A detailed explanation of the Cause and Cause Code | nvarchar(255) |
| FAILURECODE | TSA approved FMI code indicating Failure of problem on TSE | nvarchar(255) |
| FAILURECOMP | A detailed explanation of the Failure and Failure Code | nvarchar(255) |
| REMEDY | TSA approved FMI code indicating Cause of problem on TSE | nvarchar(255) |
| REMEDYDESC | A detailed explanation of the Remedy and Remedy Code | nvarchar(255) |
| ACTIONCODE | TSA approved FMI code indicating Cause of problem on TSE | nvarchar(255) |
| ACTIONCODEDESCRIPTION | A detailed explanation of the Action and Action Code | nvarchar(255) |
| PARTNUMBER | OEM part number ordered for TSE repair. | nvarchar(255) |
| PARTDESCRIPTION | Part description that correlates with the OEM part number. | nvarchar(255) |
| PARTQUANTITY | Quantity of each part number ordered against ticket for repair. | nvarchar(255) |
| OPSTATUS | Identifies the status of the maintenance activity in more detail. | nvarchar(255) |
| STATUS | Identifies the status of the maintenance activity in more detail. (Open, Closed, InDepot, etc.) | nvarchar(255) |
| T2 | Technician Dispatched | Datetime |
| T2TCS | T2 Telephone Customer Support | Datetime |
| T3 | Technician Starts Diagnostics | Datetime |
| T3A | T-Values (A-E) to support any recursions | Datetime |
| T3B | T-Values (A-E) to support any recursions | Datetime |
| T3C | T-Values (A-E) to support any recursions | Datetime |
| T3D | T-Values (A-E) to support any recursions | Datetime |
| T3E | T-Values (A-E) to support any recursions | Datetime |
| T4 | Technician Diagnostics Complete | Datetime |
| T4A | T-Values (A-E) to support any recursions | Datetime |
| T4B | T-Values (A-E) to support any recursions | Datetime |
| T4C | T-Values (A-E) to support any recursions | Datetime |
| T4D | T-Values (A-E) to support any recursions | Datetime |
| T4E | T-Values (A-E) to support any recursions | Datetime |
| T5 | Parts Begin Shipment | Datetime |
| T5A | T-Values (A-E) to support any recursions | Datetime |
| T5B | T-Values (A-E) to support any recursions | Datetime |
| T5C | T-Values (A-E) to support any recursions | Datetime |
File details come from the government source that posted it. Updated .