RFP D-3a Data Dictionary.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- Transportation Security Administration Checkpoint Integrated Logistics Support (ILS) Services
- Solicitation number
- 70T04024R7672N001
About this file
This document is a Request for Proposal (RFP) for the Transportation Security Administration (TSA) Checkpoint Integrated Logistics Support (ILS) Services. The solicitation number is 70T04024R7672N001. The RFP is for commercial items to provide checkpoint maintenance services for TSA. Key details include:
The RFP is requesting proposals due by 11:00am Eastern Daylight time on June 4, 2024. All questions must be submitted by 1:00pm Eastern Daylight time on April 24, 2024. Historical maintenance data, equipment listings, and performance data is available upon request. The RFP does not provide specific details on the scope of work, but states that the services are for commercial items. Offerors are responsible for monitoring the SAM.gov website for any updates or amendments to the solicitation.
View the file
Other files
Show all 49
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 .