Calendar Data Dictionary

Description of current variables in the calendar database:

Levels of an Activity (by ID)
Display Name	Variable Description	Variable Definition	Data Type	Example Values
Sub Activity ID	Unique Record Identifier	A planned delivery of a single intervention within a phase to a specific geographical area.	Int PRIMARY KEY	1, 12, 53, 15349
Phase ID	Unique Record identifier	A planned delivery of one or more intervention(s) during a specific time period within the activity. May cover multiple geographical areas.	Int FOREIGN KEY: PHASE	1, 4, 1238
Activity ID	Record identifier	Non-routine delivery of vaccines or other health interventions to a specific population, often supported by a single funding source.	Int FOREIGN KEY: ACTIVITY	Not editable

Activity Overview
Display Name	Variable Description	Variable Definition	Data Type	Example Values
Type of Activity	Type of activity	Type of activity during which the intervention is delivered	Text	MDA, Follow up, Preventive
Intervention	Intervention(s) delivered during the phase	Vaccine, medicine or other health product delivered during the sub-activity	Text	bOPV, ITN, DEC+ALB
Funding	Funding source	Organization providing funding for the activity	Text	Self-financed, Gavi, Mixed
Mode of Delivery	Delivery method	How the intervention is delivered to the population	Text	House-to-house, Fixed post
Co-delivery	Additional interventions	Indicates whether additional vaccine(s), medicine(s) or other health product(s) are delivered during the activity	Text	Yes, No
Phased	Phased	Is the activity phased?	Text	Yes, No
Total Phases	Number of phases	Total number of phases within the activity	Int	1, 2, 3, 4…

Activity Targets (Population and Geographic)
Display Name	Variable description	Variable definition	Data Type	Example Values
Activity Target Population	Target Population	Number of people targeted during an activity	Int	315,000
Activity Goal	Activity Goal	Stated overall coverage goal for Covid-19 campaigns	Text	“60% of 39M population by 2022”, “60% of population”
Phase Goal	Phase goal	Stated overall phase coverage goal for Covid-19 campaigns	Text	“20% of population”,”95% of population”
Phase Target Population	Target Population	Number of people targeted during a phase of a Covid-19 campaign	Int	60,000
Geographic Target	Area targeted during a sub-activity	Can be an admin1, or entire country	Text	Ethiopia, Guinea, Conarky, Abia
Sub-Activity Target Population	Target Population	Number of people targeted during a sub-activity (i.e., within specific geographic target)	Int	23,000
Sub-Activity Target Population Group	Target population group	Target population groups (based on age, occupation, and/or other grouping) used for Covid-19 campaigns	Text	Essential Personnel, Elderly, Frontline Healthcare Workers
Sub-Activity Target Population Group Detail	Detail of target population group	Country specific details of the target population groups used for Covid-19 campaigns	Text	60+, Long-term care employees, government officials

Phase Dates
Display Name	Variable description	Variable definition	Data Type	Example Values
Phase	Phase	The phase that sub-activities belong to	Int	1, 2, 3…
Planned Start Date	Date	The date the activity is/was planned to begin	Date	2/23/2021, NULL
Planned Start Month	Month	The month the activity is/was planned to begin	Text	Feb, Mar, Unknown
Planned Start Year	Year	The year the activity is/was planned to begin	Int	2020, 2021, 2022
Planned End Date	Date	The date the activity is/was planned to end	Date	4/1/2021
Planned End Month	Month	The month the activity is/was planned to end	Text	Apr, Jun, Unknown
Planned End Year	Year	The year the activity is/was planned to end	Int	2020, 2021, 2022
Status	Status	What is the status of this phase (e.g., planned, delayed, complete)?	Text	On track, Postponed, Resumed, Completed (see definitions of statuses at bottom of page)
Reason for Delay	Reason for Delay	What is the reason behind the delay?	Text	If delayed, no If not delayed, yes
Actual Start Date	Date	Planned date, unless the planned date was altered, then new date the activity is/was now planned to begin.	Date	2/23/2021, NULL
Actual Start Month	Month	Planned date, unless the planned date was altered, the new month the activity is/was now planned to begin	Text	Feb, Mar, Unknown
Actual Start Year	Year	Planned date, unless the planned date was altered, the new year the activity is/was now planned to begin	Int	2020, 2021, 2022
Actual End Date	Date	Planned date, unless the planned date was altered, the new date the activity is/was now planned to begin	Date	3/14/2021
Actual End Month	Month	Planned date, unless the planned date was altered, the new month the activity is/was now planned to end	Text	Apr, Jun, Unknown
Actual End Year	Year	Planned date, unless the planned date was altered, the new year the activity is/was now planned to end	Int	2020, 2021, 2022

Source Information
Display Name	Variable description	Variable definition	Data Type	Example Values
Source of Information	Information source	Organization providing information on the sub-activity	Text	WHO IVB, UNICEF, ESPEN, Media Monitoring
Detail on Source of Information	Detail on information source	Additional detail on the source of information when source of information is ‘Media Monitoring’ or ‘Other’	Text	URLs
Date of Source	Date of information source	Date the information was received	Date	2/23/2021
Comments	Comments	Any additional comments regarding this phase record	Text	“Final date still TBD”

Chinese (Simplified)

Chinese (Traditional)

Kurdish (Kurmanji)

Myanmar (Burmese)

Scottish Gaelic