Attachment G - NWSS_DCIPHERE Data Dictionary.xlsx
XLSX spreadsheet 14 KB Posted
- Attached to
- COVID-19 Wastewater Data Testing Federal contract opportunity
- Solicitation number
- 75P00121Q00029
About this file
This document outlines a federal contract opportunity for COVID-19 wastewater data testing services. The Department of Health and Human Services seeks a contractor to assist the Office of the Chief Information Officer in leveraging wastewater data to detect COVID-19 trends in communities and incorporate that information into the HHS Protect Program. Services are required for an initial base period of 12 weeks consisting of Phase 0 and Phase 1. Proposals are due by March 2, 2021 and are to be submitted electronically to the points of contact listed. The solicitation is a total small business set-aside for NAICS code 541380 with a size standard of $16.5 million. The government intends to make an award using lowest price technically acceptable evaluation criteria.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment A. SOO RFP.Amd1.pdf | ||
| Attachment C - Questions and Answers 2.26.21.xlsx | XLSX spreadsheet | |
| Attachment A. SOO RFP.pdf | ||
| Attachment F - FIPS.xlsx | XLSX spreadsheet | |
| Attachment D - Instructions and Evaluations.pdf | ||
| Attachment C - Question and Answer Template.xlsx | XLSX spreadsheet | |
| Attachment B - Quality Management Plan Template.docx | DOCX document | |
| Attachment E - EPA_Wasterwater_Facilities_abr.xlsx | XLSX spreadsheet |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Table Name | Column Name | DataType | Field Length | NOT NULL | Constraint | Description | |
| HHS_WBE_DATA | WWTP_NAME | VARCHAR | 50 | X | PK | This is the name of the wastewater treatment plant the sample is associated with | |
| HHS_WBE_DATA | STATE | VARCHAR | 2 | X | PK | This is the state that the wastewater treatment plant resides in | VARCHAR |
| HHS_WBE_DATA | COUNTY_NAMES | VARCHAR | 50 | This is the county that the wastewater treatment plant resides in | CHAR | ||
| HHS_WBE_DATA | OTHER_JURISDICTION | VARCHAR | 50 | This is the additional jurisdiction the wastewater treatment plant resides in (if applicable) | DATE | ||
| HHS_WBE_DATA | ZIPCODE | VARCHAR | 5 | X | PK | This is the zipcode that the wastewater treatment plant resides in | NUMBER |
| HHS_WBE_DATA | CAPACITY_MGD | VARCHAR | 5 | X | This is the capacity of wastewater at the wastewater treatment plant (in million gallons per day) | ||
| HHS_WBE_DATA | POPULATION_SERVED | NUMBER | 1 | X | This is the population served by the wastewater treatment plant | ||
| HHS_WBE_DATA | INDUSTRIAL_INPUT | NUMBER | 3 | This is the percent of industrial wastewater input into the system | |||
| HHS_WBE_DATA | STORMWATER_INPUT | VARCHAR | 3 | The wastewater collection system is a combined stormwater/wastewater input (Yes/No) | |||
| HHS_WBE_DATA | INFLUENT_EQUILIBRATED | VARCHAR | 3 | Is Influent Equilibrated (Yes/No) | |||
| HHS_WBE_DATA | SEWAGE_TRAVEL_TIME | Number | 3 | Estimated average travel time of wastewater (in hours) | |||
| HHS_WBE_DATA | SAMPLE_COLLECT_DATE | DATE | 10 | X | PK | Date of sample collection | |
| HHS_WBE_DATA | SAMPLE_COLLECT_TIME | TIME | 5 | X | PK | Time of sample collection | |
| HHS_WBE_DATA | FLOW_RATE | NUMBER | 5 | X | Wastewater flow rate observed on day of sample collection (in million gallons per day) | ||
| HHS_WBE_DATA | COLLECTION_WATER_TEMP | NUMBER | 3 | Temperature of wastewater at collection (in degrees C) | |||
| HHS_WBE_DATA | SAMPLE_TYPE | VARCHAR | 25 | X | Type of sample collected (composite, grab) | ||
| HHS_WBE_DATA | COMPOSITE_FREQ | How many aliquats of wastewater were pulled over the 24-hour sample. | |||||
| HHS_WBE_DATA | SAMPLE_MATRIX | VARCHAR | 25 | X | Matrix of sample collected (Raw Wastewater, Treated Wastewater, Biosolid) | ||
| HHS_WBE_DATA | SAMPLE_LOCATION | VARCHAR | 25 | X | Denoted Sample Location | ||
| HHS_WBE_DATA | SAMPLE_LOCATION_SPECIFY | VARCHAR | 25 | Specific Sample Location | |||
| HHS_WBE_DATA | COLLECTION_STORAGE_TIME | TIME | 5 | Storage time after sample collection | |||
| HHS_WBE_DATA | COLLECTION_STORAGE_TEMP | NUMBER | 3 | Temperature of sample storage (in degrees C) | |||
| HHS_WBE_DATA | PRETREATMENT | VARCHAR | 3 | Pretreatment of wastewater (Yes/No) (Case doesn't matter) (Lower case prefered) | |||
| HHS_WBE_DATA | PRETREATMENT_SPECIFY | VARCHAR | 50 | Specific Pretreatment of Wastewater | |||
| HHS_WBE_DATA | CONCENTRATION_METHOD | VARCHAR | 50 | X | Method of Sample Concentration | ||
| HHS_WBE_DATA | EXTRACTION_METHOD | VARCHAR | 50 | X | Method of Sample Extraction | ||
| HHS_WBE_DATA | PRE_CONC_STORAGE_TIME | TIME | 5 | Time of sample storage prior to concentration step | |||
| HHS_WBE_DATA | PRE_CONC_STORAGE_TEMP | NUMBER | 3 | Temperature of sample storage prior to concentration step (in degrees C) | |||
| HHS_WBE_DATA | PRE_EXT_STORAGE_TIME | TIME | 5 | Time of sample storage prior to extraction step | |||
| HHS_WBE_DATA | PRE_EXT_STORAGE_TEMP | NUMBER | 3 | Temperature of sample storage prior to extraction step (in degrees C) | |||
| HHS_WBE_DATA | TOT_CONC_VOL | NUMBER | 10 | Total Volume of Concentrate (in mL) | |||
| HHS_WBE_DATA | EXT_BLANK | VARCHAR | 3 | Was extraction blank used in associated lot? (Yes/No) | |||
| HHS_WBE_DATA | REC_EFF_TARGET_NAME | X | Name of “recovery standard” added to samples | ||||
| HHS_WBE_DATA | REC_EFF_SPIKE_MATRIX | X | Type of sample the “recovery standard” is added to (i.e. wastewater) | ||||
| HHS_WBE_DATA | REC_EFF_SPIKE_CONC | NUMBER | 3 | X | Was “target recovery standard” recovered within the sample within a specified range (based on the CT value) | ||
| HHS_WBE_DATA | PCR_TARGET | VARCHAR | 10 | X | PCR Target Gene | ||
| HHS_WBE_DATA | PCR_TARGET_REF | VARCHAR | 500 | X | Reference of PCR Target Gene | ||
| HHS_WBE_DATA | PCR_TYPE | VARCHAR | 10 | X | Type of PCR Extraction | ||
| HHS_WBE_DATA | LOD_REF | VARCHAR | 500 | X | Limit of Detection Reference | ||
| HHS_WBE_DATA | HUM_FRAC_TARGET_MIC | VARCHAR | 50 | Human Contribution Fraction Target - Biological | |||
| HHS_WBE_DATA | HUM_FRAC_TARGET_MIC_REF | VARCHAR | 500 | Human Contribution Fraction Target - Biological Reference | |||
| HHS_WBE_DATA | HUM_FRAC_TARGET_CHEM | VARCHAR | 50 | Human Contribution Fraction Target - Chemical | |||
| HHS_WBE_DATA | HUM_FRAC_TARGET_CHEM_REF | VARCHAR | 500 | Human Contribution Fraction Target - Chemical Reference | |||
| HHS_WBE_DATA | HUM_FRAC_TARGET_PHYS | VARCHAR | 50 | Human Contribution Fraction Target - Physical | |||
| HHS_WBE_DATA | HUM_FRAC_TARGET_PHYS_REF | VARCHAR | 500 | Human Contribution Fraction Target - Physical Reference | |||
| HHS_WBE_DATA | QUANT_STAN_TYPE | X | RNA (will be RNA for all SARS-CoV-2 assays) | ||||
| HHS_WBE_DATA | STAN_REF | reference for standard (material used – TAQPATH) | |||||
| HHS_WBE_DATA | INHIBITION_METHOD | X | method for determining inhibition (TAQPATH) | ||||
| HHS_WBE_DATA | NUM_NO_TARGET_CONTROL | ||||||
| HHS_WBE_DATA | REPORTING_STATE | X | State that lab assay was ran in | ||||
| HHS_WBE_DATA | PH | NUMBER | 3 | pH of wastewater sample | |||
| HHS_WBE_DATA | CONDUCTIVITY | NUMBER | 5 | Conductivity of wastewater sample | |||
| HHS_WBE_DATA | TSS | NUMBER | 5 | Total suspended solids of wastewater sample | |||
| HHS_WBE_DATA | EQUIV_SEWAGE_AMT | ||||||
| HHS_WBE_DATA | TEST_RESULT_DATE | DATE | 10 | X | Test Result Date | ||
| HHS_WBE_DATA | SARS_COV2_UNITS | VARCHAR | 50 | X | SARS-CoV-2 Concentration Units | ||
| HHS_WBE_DATA | SARS_COV2_AVG_CONC | NUMBER | 10 | X | Average concentration of SARS-CoV-2 gene copies per liter of wastewater | ||
| HHS_WBE_DATA | SARS_COV2_STD_ERROR | NUMBER | 10 | Concentration standard error | |||
| HHS_WBE_DATA | SARS_COV2_CL_95_LO | NUMBER | 10 | Lower 95% confidence interval | |||
| HHS_WBE_DATA | SARS_COV2_CL_95_UP | NUMBER | 10 | Upper 95% confidence interval | |||
| HHS_WBE_DATA | SARS_COV2_BELOW_LOD | VARCHAR | 3 | X | Is SARS-CoV-2 viral level below limit of detection (Yes/No) | ||
| HHS_WBE_DATA | LOD_SEWAGE | NUMBER | 10 | X | Limit of detection | ||
| HHS_WBE_DATA | NTC_AMPLIFY | ||||||
| HHS_WBE_DATA | REC_EFF_PERCENT | NUMBER | 3 | X | Recovery efficiency percentage, not provided - recovery efficiency under our methods is qualitative | ||
| HHS_WBE_DATA | INHIBITION_DETECT | VARCHAR | 3 | X | Inhibition detection (yes/no) | ||
| HHS_WBE_DATA | INHIBITION_ADJUST | VARCHAR | 50 | Correction for inhibition | |||
| HHS_WBE_DATA | HUM_FRAC_MIC_CONC | VARCHAR | 10 | Concentration of Human Contribution Fraction Target - Biological | |||
| HHS_WBE_DATA | HUM_FRAC_MIC_UNIT | VARCHAR | 50 | Units of Concentration of Human Contribution Fraction Target - Biological | |||
| HHS_WBE_DATA | HUM_FRAC_CHEM_CONC | VARCHAR | 10 | Concentration of Human Contribution Fraction Target - Chemical | |||
| HHS_WBE_DATA | HUM_FRAC_CHEM_UNIT | VARCHAR | 50 | Units of Concentration of Human Contribution Fraction Target - Chemical | |||
| HHS_WBE_DATA | HUM_FRAC_PHYS_CONC | VARCHAR | 10 | Concentration of Human Contribution Fraction Target - Physical | |||
| HHS_WBE_DATA | HUM_FRAC_PHYS_UNIT | VARCHAR | 50 | Units of Concentration of Human Contribution Fraction Target - Physical |
File details come from the government source that posted it. Updated .