APMIS (Afghanistan Polio Management Information System) is an supplemental Immunization Activities management system to manage the vaccination activities in the country.
Users are a bit confused by the transposed data formats and request a data dictionary, particularly that explains the matching of columns and calculation formulas
related: #654 #707 #712
see example of structure below:
Since the whole export is really text, not sure if the format col is needed. the description would be for any new variables and would show the formula for those that are summed for example.
variable name | var name wide | var label wide | format | new | description
-- | -- | -- | -- | -- | --
District | District | district | text | |
Dcode | DCode | dcode | integer | |
Cluster | Cluster | Cluster | text | |
Cluster Number | Cluster Number | clusternumber | integer | |
CCode | CCode | ccode | integer | |
Form Phase | Form Phase | formType | text | |
Source | Source | source | text | |
Creating User | Creating user | creatingUser | text | |
Day | | | integer | Yes | day of campaign index
NumberRemainingAbsent | | | | Yes | NumberRemainingAbsent_day1 + NumberRemainingAbsent_day2 + NumberRemainingAbsent_day3
FoundVaccinatedAbsentReturnDuringCampaign | | | | Yes | FoundVaccinatedAbsentReturnDuringCampaign_day1 + FoundVaccinatedAbsentReturnDuringCampaign_day2 + FoundVaccinatedAbsentReturnDuringCampaign_day3
TotalMissedDay1_3 | | | integer | Yes | TotalMissedDay1_3_day1 + sum of TotalMissedDay1_3_day2 + sum of TotalMissedDay1_3_day3
Users are a bit confused by the transposed data formats and request a data dictionary, particularly that explains the matching of columns and calculation formulas
related: #654 #707 #712
see example of structure below:
Since the whole export is really text, not sure if the format col is needed. the description would be for any new variables and would show the formula for those that are summed for example.
variable name | var name wide | var label wide | format | new | description -- | -- | -- | -- | -- | -- District | District | district | text | | Dcode | DCode | dcode | integer | | Cluster | Cluster | Cluster | text | | Cluster Number | Cluster Number | clusternumber | integer | | CCode | CCode | ccode | integer | | Form Phase | Form Phase | formType | text | | Source | Source | source | text | | Creating User | Creating user | creatingUser | text | | Day | | | integer | Yes | day of campaign index NumberRemainingAbsent | | | | Yes | NumberRemainingAbsent_day1 + NumberRemainingAbsent_day2 + NumberRemainingAbsent_day3 FoundVaccinatedAbsentReturnDuringCampaign | | | | Yes | FoundVaccinatedAbsentReturnDuringCampaign_day1 + FoundVaccinatedAbsentReturnDuringCampaign_day2 + FoundVaccinatedAbsentReturnDuringCampaign_day3 TotalMissedDay1_3 | | | integer | Yes | TotalMissedDay1_3_day1 + sum of TotalMissedDay1_3_day2 + sum of TotalMissedDay1_3_day3