| Variable Label |
Access Database Variable Name |
Description |
Stored Variable Type (Numeric, Character)-Stored in ACCESS |
Variable Length |
| CDCID |
CDCID |
ID created for internal CDC use |
Numberic |
|
| Patient_ID |
Patient_ID |
Patient's ID |
Character or Numeric based on reporting lab |
|
| Reporting Lab |
ReportingLab |
Lab reporting to CDC |
Character |
20 |
| Report Date |
ReportDate |
|
Numeric/Date format note: stored as DateTime19 in accessDB, but converted to DATE9 in SAS code |
8 |
| Age |
Age |
can be reported in months or years |
Numeric |
8 |
| Age Type |
Age_Type |
Months or Years |
Numeric |
8 |
|
[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Variable Changed from Gender to Sex
Gender |
[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Variable changed from Gender to Sex
Gender |
[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Male, Female or Undetermined to remain compliant.
Male or Female |
Numeric |
8 |
| State of Residence |
State_Residence |
State of Residence for patient, if unknown defaults to state where tested unless tested at CDC then it defaults to state that submitted the specimen. This variable uses the state FIPS numeric code |
Numeric |
8 |
| Spec_ID |
Spec_ID |
specimen ID |
Character or Numeric based on reporting lab |
|
| Spec_Sent |
Spec_Sent |
Indicates if speciment was sent elsewhere for typing |
Character or Numeric based on reporting lab |
|
| Specimen Source |
SpecimenType |
specimen type according to list provided on report sheet |
Numeric |
8 |
| Specimen Source Specified |
SpecType_Spec |
if specimen type is not listed, other can be filled in |
Character |
50 |
| Specimen Collection Date |
Collection_date |
date of specimen collection |
Date note: stored as DateTime19 in accessDB, but converted to DATE9 in SAS code |
8 |
| Primary Specimen or Culture Isolate |
IsolateType |
Indicates if the typing was performed using an original specimen or a culture isolate |
Numeric |
8 |
| Number of AdV detected |
Num_AdvDet |
Number of adenoviruses detected in a single specimen. Patients may be coinfected with more than one type of adenovirus. |
Numeric |
8 |
| Adenovirus 1: AdV Species (A-F) |
AdSpecies1 |
Species typed by GenMark will have either B/E or C. |
Numeric |
8 |
| Adenovirus 1: AdV Type |
AdvType1 |
Specimens that only have species determination by GenMark will have 0 as their adenovirus type |
Numeric |
8 |
| Adenovirus 2: AdVSpecies |
AdSpecies2 |
|
Numeric |
8 |
| Adenovirus 2: AdVSpecies |
AdvType2 |
|
Numeric |
8 |
| HAdV Species/Type determined by |
TypingMethod |
indicates typing method. See codebook for options. |
Numeric |
8 |
| Typed Determined by Other (please specify) |
Typing_Other |
|
Character |
255 |
| Coinfection detected |
CoinfectionYN |
Yes, No, Unknown |
numeric |
8 |
| Coinfection detected Specify |
Coinfect_Specify |
can indicate which other pathogens were detected, specific bacteria, virus, or other |
Character |
150 |
| Fatal |
Fatal |
Yes, No, Unknown |
Numeric |
8 |
| Hospitalized |
Hosp |
Yes, No, Unknown |
Numeric |
8 |
| Outbreak |
OutbreakYN |
Yes, No, Unknown |
Numeric |
8 |
| Outbreak Type |
OutbreakType |
see CodeBook for options, indicates setting of outbreak. |
Numeric |
8 |
| Outbreak Type Specify |
OutbreakType_Spec |
if setting of outbreak isn't listed, the reporter can specify |
character |
200 |
| Comments/Other |
Other |
other comments that the reporter may wish to add. |
Character |
255 |
| Not on form, ACCCESS DB only |
ID |
automatically assigned by access DB, auto number |
Numeric |
8 |
| Not on form, ACCCESS DB only |
NATRSid |
Assigned by data entry person and used to differentiate database source |
Numeric |
8 |
| Specimen |
|
| 1 |
Primary |
| 2 |
Culture Isolate |
|
|
|
[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Changed from Gender to Sex
Reply:
Changed from Gender to sex.
Gender |
|
| 1 |
Male |
| 2 |
Female |
| 9 |
[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Comment:
Changed from unknown to undetermined
Unknown |
|
|
| adenovirus source |
|
| 1 |
Primary Specimen |
| 2 |
Culture Isolate |
| 8 |
Other (specify) _______ |
| 9 |
Unknown |
| 3 |
DNA |
|
|
| outbreakType |
|
| 1 |
Hospital |
| 2 |
School |
| 3 |
Daycare |
| 4 |
Long Term Care Facility |
| 5 |
Military |
| 8 |
Other (specify) _______ |
| 9 |
Unknown |
|
|
| Specimen Type |
|
| 1 |
NP/OP swab |
| 2 |
NP/OP wash |
| 3 |
Sputum |
| 4 |
Tracheal Aspirate |
| 5 |
Bronchoalveolar Lavage |
| 6 |
Pleural Fluid |
| 7 |
Ocular Swab |
| 10 |
Stool |
| 11 |
Tissue(Specify)__________ |
| 8 |
Other(Specify)_________________ |
| 9 |
Unknown |
|
|
| TypeDeterminedBy |
|
| 1 |
Sequencing Hexon Gene |
| 2 |
Sequencing Fiber Gene |
| 3 |
Next Gen Sequencing |
| 4 |
Sequencing Other |
| 5 |
Real time PCR |
| 6 |
Commercial Molecular Assay (ie. GenMark) |
| 7 |
Serum Neutralization |
| 8 |
Other(Specify)_________________ |
| 9 |
Unknown |
|
|
| Species |
|
| 1 |
A |
| 2 |
B |
| 3 |
C |
| 4 |
D |
| 5 |
E |
| 6 |
F |
| 7 |
B/C |
|
|
| AdVType |
|
| 99 |
Unknown |
| 0 |
Undetermined/GenMark Species Identification Only |
|
|
| AgeType |
|
| 1 |
Months |
| 2 |
years |