cop23_data_pack_schema: Schema describing the correct structure of the COP23 Data...

In pepfar-datim/datapackr: A Package that Packs and Unpacks all Data Packs and Target Setting Tools

Schema describing the correct structure of the COP23 Data Pack template.

Description

This schema describes the correct structure of a COP23 Data Pack file, generated from the template used to produce Data Packs and useful in validating Data Packs passed through datapackr.

Usage

cop23_data_pack_schema

Format

sheet_num

Lists the index value associated with the sheet name listed in sheet_name.

sheet_name

Lists the sheet/tab name as used in both the Data Pack.

data_structure

Binary column describing the structure of the data These values consist of "skip" or "normal"

col

Value describing the column position of each indicator_code.

indicator_code

Code used in the Data Pack to uniquely identify each distinct programmatic area of target setting.

dataset

For indicator_codes listed as "Targets" in the col_type field, documents the dataset, either MER, IMPATT,datapack, or SUBNAT.

col_type

Flags whether an indicator_code is a Target (target), historic data (past), reference figure (reference), row header (row_header) or not (NA).

value_type

Category column describing the type of measure for the indicator_code. The values consist of "string", "integer", "percentage", or NA

dataelement_dsd

Denotes whether this element has a "Direct Service Delivery" support type

dataelement_ta

Denotes whether this element has a "Technical Assistance" support type

categoryoption_specified

Categoryoption disaggregate of the data element

valid_ages

Comprised of Age disaggregate and the associated UID

valid_sexes

Compised of Sex disaggregate and the assoicated UID

valid_kps

Compised of KP disaggregate and the assoicated UID

formula

Excel formula defined for indicator_code.

FY

Fiscal Year

period

DHIS2 period for example "2022Oct"

pepfar-datim/datapackr documentation built on Jan. 14, 2025, 7:11 a.m.