1 / 10

SDMX-HD (Health Domain) Samples for 2 nd Philippine's Connectaton

SDMX-HD (Health Domain) Samples for 2 nd Philippine's Connectaton. Samples prepared for 2 nd PH Connectathon. Indicator definitions exported from IMR – Philippines indicator set maternal mortality ratio (indicator ID #26 in WHO IMR) TB prevalence rate (indicator ID #7 in WHO IMR)

jenski
Télécharger la présentation

SDMX-HD (Health Domain) Samples for 2 nd Philippine's Connectaton

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SDMX-HD (Health Domain)Samples for 2nd Philippine's Connectaton

  2. Samples prepared for 2nd PH Connectathon • Indicator definitions exported from IMR – Philippines indicator set • maternal mortality ratio (indicator ID #26 in WHO IMR) • TB prevalence rate (indicator ID #7 in WHO IMR) • fully immunized child (indicator ID #2457 in WHO IMR) • Code lists from XLS files provided by UP Manilla • Geocodes • PhilHealth version (island group, region, province, municipality) • PSGC version (island group, region, province, municipality, barangay) • Facilities • DOH version • Note: only facilities at the barangay level have been mapped to their corresponding geocode. • Levels for hospitals (facilities) • DOH version • PhilHealth version

  3. Samples prepared for 2nd PH Connectathon • Packaging of code list: • These code lists are “Custom code lists” because they are not part of the SDMX-HD standard code lists; • Different versions of code lists are identified based on their Agency ID: • PHIC: Philippine Health Insurance Corporation • PHNSCB: Philippine National Statistical Coordination Board • PHDOH: Philippine Department of Health • The relationship between codes within a code list is encoded using SDMX hierarchies: • HCL_GPN.*.xml files encodes the hierarchy of geocodes, to express the tree of island group > region > province > municipality > barangay • HCL_GPN_FACILITIES.DOH.1.0.xml encodes the link between facilities and their corresponding geocodes. • Note: we only encoded the link between barangay and geocodes, because the Health_Facilities_20110613.xls geocodes were partially complete. It would not have made sense to link Barangay Health Stations or Rural Health units at the province of regional level… only because the barangay information was missing from the XLS file.

  4. Samples prepared for 2nd PH Connectathon SDMX-HD standard files • In addition to the COMMON subfolder containing common SDMX-HD items • There is one CUSTOM subfolder by Agency • DSD.xml or MSD.xml reference the appropriate code lists Agency custom files

  5. Samples prepared for 2nd PH Connectathon • Different SDMX-HD packaging: • Code lists provided in ZIP file format, stand-alone (i.e. without any DSD) • File: 2nd PH Connectathon.CUSTOM code lists.zip • Code lists available from a website • Published on http://www.sdmx-hd.org/projects/list_files/philippines • SDMX-HD stand-alone package • File: 2nd PH Connectathon.StandAlone.zip • Contains DSD and MSD from WHO IMR for the sample indicators • Contains custom PHIC, PHNSCB and PHDOH code lists embedded • SDMX-HD package referencing www.sdmx-hd.org • File: 2nd PH Connectathon.UrlReference.zip • Custom code lists are not embedded in the package • Instead, they are referenced from www.sdmx-hd.org and downloaded on-the-fly by the SDMX-HD .Net library when the file is parsed

  6. Samples prepared for 2nd PH Connectathon • Files posted on www.sdmx-hd.org

  7. Samples prepared for 2nd PH Connectathon The following samples files • 2nd PH Connectathon.StandAlone.zip • 2nd PH Connectathon.UrlReference.zip can be opened using the Sample1 in C#, using the blue-infinity SDMX-v1.0 Library, downloadable from • http://www.sdmx-hd.org/wiki/sdmx-hd-standards/SDMX-HD_Source_Code_Libraries • Just replace the “const string zipFileLocation” value in Program.cs to point it to the correct *.zip file path on your drive. Note: the library might be slow to parse the ZIP files provided, specially if the code lists are downloaded on-the-fly. The file containing only reference code lists cannot be opened with the library as SDMX-HD requires the presence of DSD.xml at the root of the zip for it to be a valid message.

  8. Samples prepared for 2nd PH Connectathon Referencing custom code lists in the DSD: • Change the AgencyID to the custom agency (e.g. PHNSCB) • Change the corresponding URN • Change the URI: either to a relative reference to the ZIP file (stand-alone) or an http://www.sdmx-hd.org/ public URL (URL Reference) <CodeLists>…<CodeListid="CL_GEOGRAPHIC_PLACE_NAME"agencyID="PHNSCB"version="1.0"isFinal="false"urn="urn:sdmx:org.sdmx.infomodel.codelist.CodeList=PHNSCB:CL_GEOGRAPHIC_PLACE_NAME[1.0]"isExternalReference="true"uri="CUSTOM/PHNSCB/codelists/CL_GEOGRAPHIC_PLACE_NAME.PHNSCB.1.0.xml"xmlns="http://www.SDMX.org/resources/SDMXML/schemas/v2_0/structure"><Namexml:lang="EN">GPN</Name></CodeList>

  9. Samples prepared for 2nd PH Connectathon Using the custom geocodes code list as the GEOGRAPHIC_PLACE_NAME dimension • The concept reference does not change (keep the SDMX-HD CS_COMMON) • Change the AgencyID to point to the custom agency code list <KeyFamilies><DimensionconceptRef="GEOGRAPHIC_PLACE_NAME"conceptSchemeRef="CS_COMMON"conceptVersion="1.0"conceptSchemeAgency="SDMX-HD"codelist="CL_GEOGRAPHIC_PLACE_NAME"codelistVersion="1.0"codelistAgency="PHNSCB" /> Using the new CL_HEALTHFACILITIES code list as a new dimension • The concept is referenced from CS_CUSTOM_PHDOH concept list • The agency ID points to the PHDOC facility code list <DimensionconceptRef="FACILITY"conceptSchemeRef="CS_CUSTOM_PHDOH"conceptVersion="1.0"conceptSchemeAgency="PHDOH"codelist="CL_HEALTHFACILITIES"codelistVersion="1.0"codelistAgency="PHDOH" />

  10. Thank you

More Related