Calendar Data Dictionary

Description of current variables in the calendar database:

Levels of an Activity (by ID)

Display NameVariable DescriptionVariable DefinitionData TypeExample Values
Sub Activity IDUnique Record IdentifierA planned delivery of a single intervention within a phase to a specific geographical area.Int PRIMARY KEY1, 12, 53, 15349
Phase IDUnique Record identifierA planned delivery of one or more intervention(s) during a specific time period within the activity. May cover multiple geographical areas.Int FOREIGN KEY: PHASE1, 4, 1238
Activity IDRecord identifierNon-routine delivery of vaccines or other health interventions to a specific population, often supported by a single funding source.Int FOREIGN KEY: ACTIVITYNot editable

Activity Overview

Display NameVariable DescriptionVariable DefinitionData TypeExample Values
Type of ActivityType of activityType of activity during which the intervention is deliveredTextMDA, Follow up, Preventive
InterventionIntervention(s) delivered during the phaseVaccine, medicine or other health product delivered during the sub-activityTextbOPV, ITN, DEC+ALB
FundingFunding sourceOrganization providing funding for the activityTextSelf-financed, Gavi, Mixed
Mode of DeliveryDelivery methodHow the intervention is delivered to the populationTextHouse-to-house, Fixed post
Co-deliveryAdditional interventionsIndicates whether additional vaccine(s), medicine(s) or other health product(s) are delivered during the activityTextYes, No
PhasedPhasedIs the activity phased?TextYes, No
Total PhasesNumber of phasesTotal number of phases within the activityInt1, 2, 3, 4…

Activity Targets (Population and Geographic)

Display NameVariable descriptionVariable definitionData TypeExample Values
Activity Target PopulationTarget PopulationNumber of people targeted during an activityInt315,000
Activity GoalActivity GoalStated overall coverage goal for Covid-19 campaignsText“60% of 39M population by 2022”, “60% of population”
Phase GoalPhase goalStated overall phase coverage goal for Covid-19 campaignsText“20% of population”,”95% of population”
Phase Target PopulationTarget PopulationNumber of people targeted during a phase of a Covid-19 campaignInt60,000
Geographic TargetArea targeted during a sub-activityCan be an admin1, or entire countryTextEthiopia, Guinea, Conarky, Abia
Sub-Activity Target PopulationTarget PopulationNumber of people targeted during a sub-activity (i.e., within specific geographic target)Int23,000
Sub-Activity Target Population GroupTarget population groupTarget population groups (based on age, occupation, and/or other grouping) used for Covid-19 campaignsTextEssential Personnel, Elderly, Frontline Healthcare Workers
Sub-Activity Target Population Group DetailDetail of target population groupCountry specific details of the target population groups used for Covid-19 campaignsText60+, Long-term care employees, government officials

Phase Dates

Display NameVariable descriptionVariable definitionData TypeExample Values
PhasePhaseThe phase that sub-activities belong toInt1, 2, 3…
Planned Start DateDateThe date the activity is/was planned to beginDate2/23/2021, NULL
Planned Start MonthMonthThe month the activity is/was planned to beginTextFeb, Mar, Unknown
Planned Start YearYearThe year the activity is/was planned to beginInt2020, 2021, 2022
Planned End DateDateThe date the activity is/was planned to endDate4/1/2021
Planned End MonthMonthThe month the activity is/was planned to endTextApr, Jun, Unknown
Planned End YearYearThe year the activity is/was planned to endInt2020, 2021, 2022
StatusStatusWhat is the status of this phase (e.g., planned, delayed, complete)?TextOn track, Postponed, Resumed, Completed (see definitions of statuses at bottom of page)
Reason for DelayReason for DelayWhat is the reason behind the delay?TextIf delayed, no If not delayed, yes
Actual Start DateDatePlanned date, unless the planned date was altered, then new date the activity is/was now planned to begin.Date2/23/2021, NULL
Actual Start MonthMonthPlanned date, unless the planned date was altered, the new month the activity is/was now planned to beginTextFeb, Mar, Unknown
Actual Start YearYearPlanned date, unless the planned date was altered, the new year the activity is/was now planned to beginInt2020, 2021, 2022
Actual End DateDatePlanned date, unless the planned date was altered, the new date the activity is/was now planned to beginDate3/14/2021
Actual End MonthMonthPlanned date, unless the planned date was altered, the new month the activity is/was now planned to endTextApr, Jun, Unknown
Actual End YearYearPlanned date, unless the planned date was altered, the new year the activity is/was now planned to endInt2020, 2021, 2022

Source Information

Display NameVariable descriptionVariable definitionData TypeExample Values
Source of Information
Information sourceOrganization providing information on the sub-activityTextWHO IVB, UNICEF, ESPEN, Media Monitoring
Detail on Source of InformationDetail on information sourceAdditional detail on the source of information when source of information is ‘Media Monitoring’ or ‘Other’TextURLs
Date of SourceDate of information sourceDate the information was receivedDate2/23/2021
CommentsCommentsAny additional comments regarding this phase recordText“Final date still TBD”