Fla. Admin. Code R. 1S-2.053
(1) General provisions.
(a) This rule establishes file format specifications, timelines and other content requirements for the electronic compilation, transmission, and reporting of:
1. Election results;
2. Precinct-level election results;
3. Voting history; and,
4. Reconciliation between the elections results and voting history.
(2) Definitions. For purposes of this rule:
(3) Election results reporting.
(4) Elections results database export file.
(5) Precinct-level election results reports.
(a) Compilation. For each election as defined in subsection (2):
1. For results unable to be transmitted in XML format, the county shall transmit the tab-delimited text file prescribed in Section 98.0981, F.S. The Division will supply the county with any additional data needed to create the file in this format; or
2. For results able to be transmitted in XML format, the Supervisor shall provide the precinct-level results in the prescribed format; and,
3. The Supervisor shall aggregate and record for each precinct the total number of ballots cast by all voters voting in the election, with subtotals for each candidate and ballot type. If a precinct has a subtotal of one to nine votes, the Supervisor shall report zero votes in all subtotals except in the “Total Votes” group for that precinct.
(6) Voting history activity reports. The requirements for reporting under this subsection only apply in each presidential preference primary election, special election, primary election, and general election.
(c) File specifications.
1. The file shall contain records for only one county for each election.
2. The file shall contain records for all qualified voters who, regardless of the voter’s county of residence or active or inactive registration status at the time the file is created:
a. Voted a regular ballot at a precinct location.
b. Voted at a precinct location using a provisional ballot that was subsequently counted.
c. Voted a regular ballot during the early voting period.
d. Voted during the early voting period using a provisional ballot that was subsequently counted.
e. Voted with a vote-by-mail ballot.
f. Attempted to vote by vote-by-mail ballot but the ballot was not counted.
g. Attempted to vote by provisional ballot but the ballot was not counted in that election.
3. Each file shall be created or converted into a tab-delimited format.
4. File names shall adhere to the following convention:
a. Three character county identifier followed by underscore.
b. Followed by four character file type identifier of ‘VH03’ followed by an underscore.
c. Followed by FVRS election ID followed by an underscore.
d. Followed by Date Created followed by an underscore.
e. Date format is YYYYMMDD.
f. Followed by Time Created – HHMMSS.
g. Followed by ‘.txt’.
5. Numeric data and date information shall be provided as specified in subparagraph 9.
6. Alphanumeric data shall not be enclosed in quotes.
7. The file shall contain a header record as the first row in the file as follows:
| Field Position | Field | Type | Length | Required | Format | Comment | 1 | OperatorID | varchar2 | N | May be blank | |||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | CountyID | varchar2 | 3 | Y | Source of FTP File. Valid County ID, or FVRS or HSMV | |||||||||
| 3 | TargetedCountyID | varchar2 | 3 | Y | Intended Recipient. Valid County ID, or FVRS or HSMV | |||||||||
| 4 | File Creation_Time Stamp | datetime | Y | MM/DD/YYYY HH24:MM:SS | Originating System TimeStamp | |||||||||
| 5 | Source_Address | varchar2 | Y | |||||||||||
| 6 | FVRS County Interface Version | varchar2 | Y | For supporting roll out of new system versions | ||||||||||
| 7 | County_Message_ Identifier | varchar2 | 10 | Y | 10 character field that may be used by the county system to identify a specific FTP File. | |||||||||
| 8 | Test_File | varchar2 | 1 | Y | Y Indicates that the FTP file is a test file and should not update primary database. |
8. The file shall contain a footer record as the last row in the file as follows:
| Field Position | Field | Type | Length | Required | Format | Comment | 1 | TrailerId | varchar2 | 5 | “TRALR” | Fixed string | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | Number of Response Rows | integer | 8 | Non zero integer | Number excludes header and trailer | |||||||||
| 3 | MessageDigest | varchar2 | 128 or 160 bits | Length to be determined | ||||||||||
| 4 | End of Message Marker | varchar2 | 7 | \\ETX\\ |
9. The information in each record of the file shall be in the specified format for each voter who qualified to vote in the presidential preference primary, the primary election or the general election:
| Field Name | Max Length | Valid Codes/ Format | Description | |
|---|---|---|---|---|
| 1 | Record Identifier | 8 | ‘VH03’ | |
| 2 | FVRS Voter ID Number | 10 | Numeric | |
| 3 | FVRS Election ID Number | 10 | Numeric | |
| 4 | Vote Date | MM/DD/YYYY | Date vote was cast | |
| 5 | Vote History Code | 1 | Y = Voted at the Polls A = Voted by Mail E = Voted Early B = Vote-by-Mail Ballot Not Counted P = Provisional Ballot Not Counted F = Provisional Ballot counted as voted at an early voting site Z = Provisional Ballot counted as voted at the polls | |
| 6 | Precinct | 6 | text | |
| 7 | Congressional District | 3 | 999 | |
| 8 | House District | 3 | 999 | |
| 9 | Senate District | 3 | 999 | |
| 10 | County Commission District | 40 | text | |
| 11 | School Board District | 40 | text |
(7) Reconciliation report.
Rulemaking Authority 20.10(3), 97.012(1), 98.0981(5), 102.141(4) and (10) FS. Law Implemented 98.0981, 102.141 FS. History–New 7-1-17. Editorial Note: This rule originated from former 1S-2.043(5), (6) and (7), dated 10-27-10.