Form
Approved OMB
No. 0920-1175 Exp.
Date 04/30/2020
CDC
estimates the average public reporting burden for this collection of
information as 100 hours per response, including the time for
reviewing instructions, searching existing data/information sources,
gathering and maintaining the data/information needed, and
completing and reviewing the collection of information. An agency
may not conduct or sponsor, and a person is not required to respond
to a collection of information unless it displays a currently valid
OMB control number. Send comments regarding this burden estimate or
any other aspect of this collection of information, including
suggestions for reducing this burden to CDC/ATSDR Information
Collection Review Office, 1600 Clifton Road NE, MS D-74, Atlanta,
Georgia 30333; ATTN: PRA (0920-0853).
Radon
Data Dictionary for Aggregate Data Environmental Public Health Tracking |
||||||
Field Name |
Field Description |
Data Type |
Code Scheme |
Legal Values |
Field Length |
Required |
AddressID |
This is a unique ID that can be linked to the address but maintain confidentiality; this number represents an address level record but it is not the address. |
String |
Twenty character value (at a maximum) consisting of numbers or letters that link to a specific address |
nnnnnn…. String of integers and characters |
20 |
Required* (If not submitting the test address) |
BuildingPurposeCode |
The designator that represents the building purpose. |
Text |
R = Residential N = Non-residential/Commercial C = Community Water Supply this is a water sample D = Daycare center P = Daycare center in public school S = School H= Hospital G = Government building CU = Colleges or Universities U = Unknown |
Any of the codes on in Code Scheme column |
2 |
Required |
BuildingTypeCode |
The designator that represents the Type of the building tested; R1 buildings are unattached and R2 buildings are attached.
|
Text |
R1A
= Mobile home |
Any of the codes in the Code Scheme column |
3 |
Optional |
CertifiedContractorIndicator |
Indicator if the con- tractor performing the test is certified or not. |
Integer |
1
= Yes |
0,1 |
1 |
Optional |
CensusTract |
Consists of the 2 digit state FIPS code, the 3 digit county FIPS code and the 6 digit code for the census tract |
String |
nnnn… U = Unknown |
Ex: Census Tract 48201533701 is located in Harris County, Texas. The 48 is the FIPS code for Texas; the 201 is the FIPS code for Harris County; and the 533701 identifies the specific Census Tract. Alpha Numeric so that leading zeroes are not deleted. |
35 |
Optional |
CountyFIPSCode |
County FIPS code over which birth defect cases and underlying birth populations are counted. |
String |
FIPS U = Unknown |
A valid county FIPS code for the state, or ‘U’. |
5 |
Required |
DataIdentifier |
A unique identifier for each batch of Radon Test Results. |
String |
XXXXXXXXX |
Nine-character value consisting of numbers or letters identifying the batch |
9 |
Optional |
DataSourceName |
The data source where the radon test data is retrieved (when pulling from multiple data sources). |
Text |
Name of lab |
Examples are:
|
25 |
Required |
DeviceTypeName |
Name of instrument or equipment used for the Radon test. |
String |
AC = Activated Charcoal Adsorption AT = alpha track ES = Short-term electret EL = Long-term electret CR = continuous radon monitor CW = continuous working level monitor LS = Charcoal Liquid Scintillation WL = Working Level CC = Charcoal Canister GR = Grab Sample – Radon GW = Grab Sample – Working Level RP = Radon Progeny Integrated Sampling Unit (RPISU) O= Other |
Any of the codes in the Code Scheme column |
2 |
Optional |
FloorLevelTested |
The floor level in the building where the Radon test was conducted.
|
String |
B = Basement F1 = 1st floor F2 = 2nd floor F3 = 3rd floor F4 = above the 3rd floor O = Other |
Any of the codes in the Code Scheme column |
2 |
Optional |
FoundationTypeCode |
A designator used to uniquely identify the Foundation Type that facility occupies. |
Text |
B
= Basement |
Any of the codes in the Code Scheme column |
1 |
Optional |
MeasureUnitName |
The code that represents the unit for measuring Radon (pCi/L = picocuries per Liter) Note: look for conversion factor for Working Levels in How-To Guide |
Integer |
Please report only as 1= pCi/L for Radon
|
1 |
1 |
Required |
MeasureValue |
The actual Radon measurement |
Integer |
0 – nnnnnn.n -999=LLD (less than the limit of detection) |
0-100000.5, -999 |
5,1 |
Required |
RealEstateTransactionIndicator |
Indicator of the building being tested for radon due to a Real Estate transaction or not. |
Integer |
1
= Yes |
0, 1 |
1 |
Optional |
ReasonForTest |
The reason the radon test is being conducted. |
Integer |
1=Real Estate Transaction 2=Homeowner’s choice (personal knowledge) 3=Legal requirement 4=Real estate transaction and legal requirement 5=Response to outreach/promotion 6=Post-mitigation test |
Any of the codes in the Code Scheme column |
1 |
Optional |
RowIdentifier |
An identifier for each row of data |
Integer |
1 – nnnn The maximum RowIdentifier should be equal to the number of test results submitted for that year. |
Consecutive numerical identifier for each record in the dataset. |
N/A |
|
StateFIPSCode |
State FIPS code. |
String |
FIPS |
A valid state FIPS code. |
2 |
Not specified in schema |
StreetAddress |
Please send the complete street address or if you cannot for some reason, please create a unique ID that can be linked to the address. |
Text |
Complete street address and unit number (if applicable) where test was taken. |
Ex: 123 Cleveland Street Apt. 56 Philadelphia, PA 12345
|
100 |
Optional |
TestDeviceLocation
|
Specific room in the house where the Radon test was conducted |
Text |
MB
= Master Bedroom |
Any of the codes in the Code Scheme column |
2 |
Optional
|
TestMethodTypeCode
|
Identifier of the type or category of method. |
Integer |
1 = pre-mitigation 2 = post-mitigation 3 = Not collected |
1, 2, 3 |
3 |
Required |
TestResultIdentifier
|
A unique identifier for each lab result, there may be multiple tests per address, this number will be unique for each test |
String |
XXXXXX |
Any number character value (up to 20) that identifies a unique test result |
20 |
Required |
TestStartDate |
The date the test was begun |
Integer |
YYYYMMDD; NC = not collected |
Ex: 20181022 |
8 |
Required |
TestStopDate |
The date the test ended |
Integer |
YYYYMMDD; NC = not collected |
Ex: 20181025 |
8 |
Required |
TestYear |
The year the data are assigned to |
Integer |
YYYY |
Ex: 2018 |
4 |
Required |
File Type | application/vnd.openxmlformats-officedocument.wordprocessingml.document |
Author | Strosnider, Heather (CDC/ONDIEH/NCEH) |
File Modified | 0000-00-00 |
File Created | 2021-01-14 |