The primary purpose of the proposed rule is to codify current practices and procedures that have arisen out of implementing state law requirements of certain voting and elections related data. The collection, reporting and public availability of the ...  

  •  

    DEPARTMENT OF STATE
    Division of Elections

    RULE NO: RULE TITLE
    1S-2.043: Electronic File Reporting Relating to Absentee Ballot Requests Information, Voting Activity, and Election Results
    PURPOSE AND EFFECT: The primary purpose of the proposed rule is to codify current practices and procedures that have arisen out of implementing state law requirements of certain voting and elections related data. The collection, reporting and public availability of the data are mandated by provisions by provisions adopted in 2005 (Ch. 2005-277 and 2005-278, Laws of Florida), in 2007 (Ch. 2007-30, Laws of Florida, and in 2008 (Ch. 2008-95, Laws of Florida) and involve primarily data collected, compiled and transmitted by the Supervisors of Elections to the Division of Elections. The proposed rule establishes uniform file format specifications, timelines for collection and transfer of data, and other content requirements for compilation, transmission and reporting or availability of absentee ballot request information, early voting activity, precinct-level election results, official results export data, and voting history activity. The proposed rule incorporates only one form by reference (DS-DE #70) which is an application form that must be completed only by statutorily authorized persons or entities who want to obtain otherwise publicly exempt voter absentee ballot request information.
    SUMMARY: The proposed rule establishes procedures and deadlines for the electronic format, collection, transfer and reporting of data relating to election results, voter activity and voting history.
    SUMMARY OF STATEMENT OF ESTIMATED REGULATORY COSTS: No Statement of Estimated Regulatory Cost was prepared.
    Any person who wishes to provide information regarding a statement of estimated regulatory costs, or provide a proposal for a lower cost regulatory alternative must do so in writing within 21 days of this notice.
    SPECIFIC AUTHORITY: 20.10(3), 97.012(1), 98.0981(5), 101.62(3), 101.657(2), 102.141(10) FS.
    LAW IMPLEMENTED: 98.0981, 101.62, 101.657, 102.141 FS.
    A HEARING WILL BE HELD AT THE DATE, TIME AND PLACE SHOWN BELOW:
    DATE AND TIME: November 9, 2009, 1:30 p.m.
    PLACE: Room 307, R. A. Gray Building, 500 S. Bronough Street, Tallahassee, Florida 32399-0250
    Pursuant to the provisions of the Americans with Disabilities Act, any person requiring special accommodations to participate in this workshop/meeting is asked to advise the agency at least 5 days before the workshop/meeting by contacting: Amber Barrett, Division of Elections, Department of State, R. A. Gray Building, 500 S. Bronough Street, Tallahassee, Florida 32399-0250; telephone: (850)245-6224; anbarrett@dos.state.fl.us. If you are hearing or speech impaired, please contact the agency using the Florida Relay Service, 1(800)955-8771 (TDD) or 1(800)955-8770 (Voice). If you are hearing or speech impaired, please contact the agency using the Florida Relay Service, 1(800)955-8771 (TDD) or 1(800)955-8770 (Voice).
    THE PERSON TO BE CONTACTED REGARDING THE PROPOSED RULE IS: Maria Matthews, Assistant General Counsel, Office of General Counsel, Florida Department of State, R. A. Gray Building, 500 S. Bronough Street, Tallahassee, Florida 32399-0250; telephone: (850)245-6536; e-mail: mimatthews@dos.state.fl.us

    THE FULL TEXT OF THE PROPOSED RULE IS:

    1S-2.043 Electronic Reporting Relating to Absentee Ballot Request Information, Voting Activity, and Election Results.

    (1) General applicable provisions. This rule establishes file format specifications, timelines and other content requirements for the electronic compilation, transmission and reporting of absentee ballot request information, early voting activity, precinct-level election results, official results export data, and voting history activity. The Supervisors of Elections shall ensure that the files required under this rule transmit successfully and timely to the Division of Elections.

    (2) Definitions. For purposes of this rule:

    (a) “FVRS” refers to the Florida Voter Registration System.

    (b) “Supervisor” refers to the county Supervisor of Elections.

    (c) “Division” refers to the Division of Elections.

    (d) “Election”, except as otherwise expressly stated, means primary and general elections (held in even-numbered years), presidential preference primary elections, and special elections held pursuant to Section 100.101, F.S. This rule does not apply for municipal, local referendum, special district, or independent district elections.

    (3) Absentee ballot request information files.

    (a) Compilation. For each election as defined in subsection (2), the Supervisor shall compile daily an electronic file that contains information related to receiving and processing absentee ballot requests. Each day’s file shall be a complete replacement of the previous day’s file. The Supervisor shall create a separate file for each election.

    (b) File Transmission. The Supervisor shall transmit to the Division the electronic file compiled under paragraph (a) no later than noon Eastern Standard Time of the day after the day being reported. The file shall be sent daily beginning the first day absentee ballots are mailed in that county for the upcoming election or 35 days before a primary election or 45 days before a general election, whichever is earlier. The last file shall be sent 10 day after the election. The daily file shall be sent even if there is no new information to report. The file shall be in the format specified in paragraph (c).

    (c) File specifications.

    1. Each file shall be created or converted into a tab-delimited text file.

    2. Quotes shall not be used to enclose alphanumeric data.

    3. For each record of a registered voter, the address included shall be the address to which the voter has requested the ballot to be delivered. However, if the requested mailing address is the same as the residential address, such addresses and the precinct location must be redacted in the file for those registered voters whose addresses are protected from public disclosure as requested under Section 119.071(4)(d), F.S.

    4. Each record in the file must contain the following information in the specified format:

    Table 1

    Absentee Ballot Request Information File Layout

    Data Element Name

     

    TranRead

    Data Format Rules

    RecordType

    AbStat

    Y

    “AbStat”

    CountyId

    County providing summary

     

    Char(3)

    Use FVRS county codes

    FVRSVoterIdNumber

    FVRS Voter Id Number

    Y

    Numeric (10)

    FVRSElectionNumber

    FVRS Election identifier

    Y

    Numeric (10)

    ElectionDate

    Date of the election

    Y

    MM/DD/YYYY

    ElectionName

    Name of Election

    Y

    Char(35)

    LastAbsRecordChangeDate

    Date the absentee summary record was last updated

    Y

    MM/DD/YYYY

    AbsenteeRequestStatus

     

    Y

    Char(1)

    C: Cancelled

    E: Voter Error

    M: Mailed

    R: Requested

    U: Returned Undeliverable

    V: Voted

    AbsReqDate

     

    Y

    MM/DD/YYYY

    AbsDelivery Date

     

     

    MM/DD/YYYY

    AbsReturnDate

     

     

    MM/DD/YYYY

    AbsReqCanceledDate

     

     

    MM/DD/YYYY

    AbsMilitary

     

     

    Char(1) Y, N

    AbsOverseasFlag

     

     

    Char(1) Y, N

    AbsMilitary Dependent

     

     

    Char(1) Y, N

    Precinct

     

     

    Char (6)

    Abs Party

     

     

    Char (3)

    Voter Name

     

     

    Char (99)

    AbsReqMailingAddressLine 1

     

     

    Char (40)

    AbsReqMailingAddressLine 2

     

     

    Char (40)

    AbsReqMailingAddressLine 3

     

     

    Char (40)

    AbsReqMailingAddress City

     

     

    Char (40)

    AbsReqMailingAddress State

     

     

    Char (2)

    AbsReqMailingAddressZip

     

     

    Char (15)

    AbsReqMailingAddressCountry

     

     

    Char (40)

    (d) Public access.

    1. Persons or entities authorized under Section 101.62, F.S., may access absentee ballot request information from the Supervisor pursuant to his or her established procedures or from the Division as specified in subparagraph 2.

    2. The Division shall post on its website (http://election.dos.state.fl.us) links to the daily county files of absentee ballot request information as directly received from the Supervisor. In order to access this information, a person or entity authorized under Section 101.62, F.S., must first submit form DS DE #70, entitled “Access Application for Absentee Ballot Request Information” (eff. __/___). The Division shall then assign a username and password. Authorization for access is only valid for one general election cycle. All passwords for access expire at the end of the calendar year in which requested and the request for access must be renewed annually. Form DS DE #70 is incorporated by reference and is available by contacting the Florida Department of State, Division of Elections, R. A. Gray Building, 500 South Bronough Street, Tallahassee, Florida 32399-0250, (850)245-6200, or by access to the Division website at: http://election.dos.state.fl.us.

    3. An individual voter requesting access to his or her personal absentee ballot request information must obtain such information directly from the Supervisor of his or her county of residence.

    (4) Early voting history files.

    (a) Compilation. For each election as defined in subsection (2), the Supervisor shall compile electronic files that contain early voting activity as follows:

    1. Early voting summary file. This file shall contain, in accordance with the specifications in paragraph (c), early voting summary information that consists of the total number of voters casting a ballot at each early voting location processed up to the close of business for each day. The file shall also include a complete status summary from the point of the file creation to the close of the business for the day being reported.

    2. Early voting voters list file. This file shall contain in accordance with specifications in paragraph (c), a list of the individual voters who cast a ballot during the early voting period for the election up through the last day being reported.

    (b) File transmission. The Supervisor shall transmit to the Division the electronic files in paragraph (a) no later than noon Eastern Standard Time of the day after the day that is being reported. The files shall be sent daily even if there is no new information or activity to report. The first file transmission shall occur the day after the early voting period begins and the last file transmission shall occur the day after the early voting period ends for that respective election in that county.

    (c) File specifications.

    1. Early voting summary file:

    a. Each file shall be created or converted into a tab-delimited text file.

    b. Alphanumeric data shall not be enclosed in quotes.

    c. The file shall contain a record for location and date for which votes were cast early for a given election.

    d. Each record in the file must contain the following information in the specified format:

    Table 2

    Early Voting Summary File Layout

    Data Element Name

     

    TranRead

    Data Format Rules

    RecordType

    Etots

    Y

    “Etots”

    CountyId

    County providing summary

     

    Char(3)

    Use FVRS county codes

    FVRSElectionNumber

    FVRS Election identifier

    Y

    Numeric

    ElectionDate

    Date of the election

    Y

    MM/DD/YYYY

    ElectionName

    Name of Election

    Y

    Char(35)

    Location

    Location of early voting

    Y

    Char(35)

    DateOfSummary

     

    Y

    MM/DD/YYYY

    TotalEarlyVotes

     

    Y

    Numeric

    2. Early voting voters list file:

    a. The file shall be created or converted into in a tab-delimited text file format.

    b. Alphanumeric data shall not be enclosed in quotes.

    c. Each record in the file must contain the following information in the specified format for each voter who is recorded as having voted early by the time the file is prepared:

    Table 3

    Early Voting Voters List File Layout

    Data Element Name

     

    TranReqd

    Data Format Rules

    RecordType

    EVtrs

    Y

    “EVtrs”

    CountyId

    County providing summary

     

    Char(3)

    Use FVRS county codes

    FvrsElectionNumber

    Fvrs Election identifier

    Y

    Numeric

    ElectionDate

    Date of the Election

    Y

    MM/DD/YYYY

    ElectionName

    Name of Election

    Y

    Char(35)

    FvrsVoterIdNumber

     

    Y

    Numeric

    VoterName

     

    Y

    Char(60)

    EVPrecinct

     

     

    Char(6)

    EVParty

     

     

    Char (3)

    Location

    Location of Early Voting

    Y

    Char(35)

    DateofEarlyVote

    Date voter cast ballot

    Y

    MM/DD/YYYY

    (d) Public access. In addition to these files being made available to the public by the Supervisor pursuant to Section 101.62, F.S., the Division shall post to its (http://election.dos.state.fl.us) a public access link on its website to these files as directly received from the Supervisors.

    (5) Official results database export files. For each election as defined in subsection (2), the Supervisor shall:

    (a) Use the file export function to create a file that includes the official results from the database of the county’s voting system used in the election.

    (b) File with the Florida Department of State’s Division of Elections’ a copy of the official results export file for the applicable election by transmitting the file at the same time that the official results of the election are certified.

    (6) Precinct-level election results reports.

    (a) Compilation. After each presidential preference primary election, special election and general election only, the Supervisor shall aggregate and record for each precinct the total number of ballots cast by all voters voting in the election. The Supervisor shall compile separately within those reports the precinct-level election results for the primary or special primary election preceding the general or special election, as applicable.

    (b) Transmission. The Supervisor shall submit electronically precinct-level election results, including summary results to the Division no later than noon Eastern Standard Time of the 45th day after the applicable election cycle.

    (c) File specifications. The files containing the precinct-level election results shall be created in accordance with the applicable file specifications for either of the following two methodologies:

    1. Manual method.

    a. The precinct level results file shall be created or converted into a tab-delimited text file.

    b. Alphanumeric data shall not be enclosed in quotes.

    c. The row immediately before the first data record shall contain the column names of the data elements that make up the data records. There should be one header record followed by multiple data records.

    Table 4

    Precinct-Level Election Results Header Layout

    Data Element Name

     

    Data Format Rules

    County Name

    County providing summary

    Char(3)

    Election Number

    Election identifier

    Numeric

    Election Date

    Date of the election

    MM/DD/YYYY

    Election Name

    Name of Election

    Char(35)

    Record header

    Column names

    Tab-delimited

     

    d. Each data record in the file must contain the following information in the specified format.

     

    Table 5

    Precinct-Level Election Results Data Record Footer Layout

    Data Element Name

     

    Data Format Rules

    Precinct Code

    County precinct identifier

    Char (6)

    Precinct Location

    Precinct location name

    Alphanumeric

    Contest Name

    Contest title

    Numeric

    Candidate/Retention/Issue Name

    Candidate name/retention or issue identifier for approval or rejection

    Char (35)

    Candidate Party

    Major, Minor or No Party Affiliation

    Char (3)

    Undervote Total

    Undervote total

    Numeric

    Overvote Total

    Overvote total

    Numeric

    Write-in Total

    Write-in total

    Numeric

    Vote Total

    Vote total

    Numeric

    2. File export method. In accordance with the specifications for the applicable voting system, the precinct-level election results created by the file export function shall include precinct-level election results from the voting system database used in the election.

    (7) Voting history activity reports.

    (a) Compilation. After a general election only, each Supervisor shall compile an electronic file that includes voting history activity information on each of the individual voters who were qualified to vote for the primary or the general election, and who cast a ballot in the primary or general election.

    (b) Transmission. The Supervisor shall transmit electronically to the Division complete voting history no later than 45 days after the general election. The files shall be transmitted to the specified voting history subdirectory under each county’s existing transfer directory using secure file transfer protocol (SFTP).

    (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: voted at a precinct location, voted during the early voting period, voted by absentee ballot, attempted to vote by absentee ballot but the ballot was not counted or attempted to vote by provisional ballot but the ballot was not counted in that election for that county regardless of the voter’s county of residence or active or inactive registration status at the time the file is created.

    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 MMDDYYYY.

    f. Followed by Time Created – HHMMSS.

    g. Followed by ‘.txt’.

    5. Numeric data and date information shall be provided as specified in subparagraph 11.

    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:

    Table 6

    Voting History Header Record Layout

    Field Position

    Field

    Type

    Length

    Required

    Format

    Comment

    1

    File Indicator

    varchar2

    2

    Y

    VH

    Specifies the file type

    2

    County ID

    varchar2

    3

    Y

     

    Identifies the source of the input data.

    4

    File Creation Timestamp

    varchar2

    19

    Y

    MM/DD/YYYY

    HH24:MM:SS

    Timestamp for beginning of file creation process

    8. The file shall contain a footer record as the last row in the file as follows:

    Table 7

    Voting History Footer Record Layout

    Field Position

    Field

    Type

    Length

    Required

    Format

    Comment

    1

    Transaction Code

    varchar2

    4

    Y

    ‘TRALR’

    Specifies the data layout for the current line

    3

    Record Count

    integer

    8

    Y

    99999999

    Number of voting history records contained within the file.

    9. Each record in the file must contain the following information, in the specified format, for each voter who qualified to vote in the presidential preference primary, the primary election or the general election:

    Table 8

    Voter’s Voting History Record

     

    Field Name

    Max Length

    Valid Codes/ Format

    Description

    1

    Record Identifier

    4

    ‘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 = Absentee Voted

    E = Voted Early

    B = Absentee Ballot Not Counted

    P = Provisional Ballot Not Counted

    Provisional ballots cast that are subsequently counted as recorded as Y

    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

     

     

    (d) Access. The Division shall post within 60 days a public access link to the legislative report on the Division’s website at: http://election.dos.state.fl.us. that also includes the file layout and codes. Such report shall also be made available upon request.

    Rulemaking Authority 20.10(3), 97.012(1), 98.0981(5), 101.62(3), 101.657(2), 102.141(10) FS. Law Implemented 98.0981, 101.62, 101.657, 102.141 FS. History–New________.

     

    NAME OF PERSON ORIGINATING PROPOSED RULE: Donald L. Palmer, Director of the Division of Elections

    NAME OF AGENCY HEAD WHO APPROVED THE PROPOSED RULE: Secretary of State Kurt S. Browning

    DATE PROPOSED RULE APPROVED BY AGENCY HEAD: October 5, 2009

    DATE NOTICE OF PROPOSED RULE DEVELOPMENT PUBLISHED IN FAW: August 14, 2009

Document Information

Comments Open:
10/16/2009
Summary:
The proposed rule establishes procedures and deadlines for the electronic format, collection, transfer and reporting of data relating to election results, voter activity and voting history.
Purpose:
The primary purpose of the proposed rule is to codify current practices and procedures that have arisen out of implementing state law requirements of certain voting and elections related data. The collection, reporting and public availability of the data are mandated by provisions by provisions adopted in 2005 (Ch. 2005-277 and 2005-278, Laws of Florida), in 2007 (Ch. 2007-30, Laws of Florida, and in 2008 (Ch. 2008-95, Laws of Florida) and involve primarily data collected, compiled and ...
Rulemaking Authority:
20.10(3), 97.012(1), 98.0981(5), 101.62(3), 101.657(2), 102.141(10) FS.
Law:
98.0981, 101.62, 101.657, 102.141 FS.
Contact:
Maria Matthews, Assistant General Counsel, Office of General Counsel, Florida Department of State, R. A. Gray Building, 500 S. Bronough Street, Tallahassee, Florida 32399-0250; telephone: (850)245-6536; e-mail: mimatthews@dos.state.fl.us
Related Rules: (1)
1S-2.043. Electronic File Reporting Relating to Absentee Ballot Request Information, Voting Activity, and Election Results