Investigate and align on tally file's data structure

[JohnMwashuma]

User story

---

Currently the files used to create tallies do not have any specification with regards to columns that the tally system expect to find and process on each file. This makes the tally creation process quite tedious due to unexpected errors when the file structure changes. For this reason we need to come up with a consistent columns spec for each file which will then help in creating tally files with the right structure and also act as a source of truth for the tally system while running validation checks against the files.

Proposed tally file columns

---

• Sub Constituency file columns:
  • sub_constituency_code
  • field_office_name
  • races
  • ballot_number_presidential
  • ballot_number_general
  • ballot_number_women
  • ballot_number_component
  • number_of_ballots
  • constituency_name
• Center file columns:
  • center_id
  • name
  • center_type
  • center_lat
  • center_lon
  • region_name
  • office_name
  • office_id
  • constituency_name
  • subconstituency_id
  • mahalla_name
  • village_name
• Stations file columns:
  • center_code
  • center_name
  • sub_constituency_code
  • station_number
  • station_gender
  • station_registrants
• Candidates file columns:
  • candidate_id
  • candidate_full_name
  • ballot_number
  • race_type
• Result form file columns:
  • ballot_number
  • center_code
  • station_number
  • gender
  • name
  • office_name
  • barcode
  • serial_number
  • region_id
  • name