Form 55.28 Lab confirmed cases of rabies

Transmission 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 (asi5@cdc.gov).
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