Download:
pdf |
pdfTransmission File Structure
The transmission protocol calls for the required rabies data to be transmitted via an ASCII file using the csv (comma separated values) file structure. A value enclosed within double quotes is
optional; however, any value that contains a comma must be enclosed in double quotes. The data dictionary defined below describes the file and the corresponding values expected by the
receiving application at the CDC. The column name may not be the exact variable in your database but provides a description to help place your corresponding variable into the right location.
Should you require assistance please contact the rabies surveillance coordinator at 404-639-1050 or email at ([email protected]).
Variable
Type
Site ID
Character
Animal ID
Character
Date Collected
Date
Species
Character
Species ID
Length
10
Description
Accepted Values
Site ID assigned by CDC
RAB+Site Code+Number : RABWV01
20
Unique ID for animal tested
Accession number / isolate identification number
10
Date animal collected
(mm/dd/yyyy) : 12/19/2007
20
Type of animal
Animal Species group : e.g. Fox, Bat, Raccoon
Character
25
Species identification of animal
Additional species identification : e.g. Red, E. fuscus
Sex
Character
6
Sex of animal
e.g. M, F, Male, Female
Age
Character
8
Age category of animal
e.g. J, A, Juvenile, Adult
Vaccination Status
Character
7
Was animal vaccinated
e.g. Y, N, Unknown
Surveillance Method
Character
20
Surveillance method of collection
e.g. Public Health, Enhanced, Road kill
Human Exposure
Character
7
Was human exposed
e.g. Y, N, Yes, No, 1, 3
Animal Exposure
Character
7
Was domestic animal exposed
e.g. Y, N, Yes, No, 1, 3
Latitude
Numeric
11
Latitude of animal collection
Decimal degree format : e.g. 32.123456
Longitude
Numeric
11
Longitude of animal collection
Decimal degree format : e.g. -84.123456
Address
Character
35
Address of animal collection
Street Address
City
Character
30
City of animal collection
City
County
Character
30
County of animal collection
County
State
Character
2
State of animal collection
State Abbreviation : e.g. GA, WV, CA
ZIP Code
Character
9
Zip Code of animal collection
Zip Code or Zip Code + 4 : e.g. 30333 or 30333-4018
DFA Result
Character
13
Result of DFA test
e.g. P, N, Positive, Negative
Date DFA
Date
10
Date DFA performed
(mm/dd/yyyy)
DRIT Result
Character
13
Result of DRIT test if performed
e.g. P, N, I, Positive, Negative, Indeterminate
Date DRIT
Date
10
Date DRIT performed
(mm/dd/yyyy)
Variant
Character
40
Virus Variant if positive
e.g. Raccoon, North Central Skunk, SC Skunk, Bat
(mm/dd/yyyy)
Date MAb
Date
10
Date antigenic typing performed
Date Sequenced
Date
10
Date sequenced if done
(mm/dd/yyyy)
Comments
Character
66
Comments
Comments
*Note: Bold variables are required. You may not have all the variables described above. You may leave them Blank or Null, but they must have a position in the transmitted file. Either two double quotes “” or no value
must be between the commas. e.g. “RABCDC01”,”CD001”,”12/19/2007”,”Raccoon”,””,,,,,”Road kill”,,,,,”123 street st”,”anywhere”,……
Example
“RABCDC01”,”CDC01152007”,”01/15/2007”,”Fox”,”Red”,”M”,”J”,”8”,”U”,”Road kill”,”Y”,”N”,”32.123456”,”-84.123456”,”123 Street St”,”Anywhere”,”Fulton”,”GA”,”30333”,”Positive”,”01/16/2007”,””,””,”Raccoon”,”01/17/2007”,
”01/18/2007”,”found with quills in face”
Revision: 01/08/2008
Rabies PHINMS File Format.doc
| File Type | application/pdf |
| File Title | Microsoft Word - Rabies PHIN MS File Format.doc |
| Author | rqb7 |
| File Modified | 2010-03-22 |
| File Created | 2008-02-21 |