USAID GS1 and BI&A - December 15, 2016
Agenda & Notes
Date | Location | Attendees | Action Items |
|---|---|---|---|
December 15, 2016 | CAMRIS South Conference Room | Lindabeth Doby, USAID Brian Taliesin PATH Ashraf Islam JSI Alpha Nsaghurwe - JSI TZ Glen Milano - USAID COR BI&A Contracts Kyle Duarte - PSM Wendy Nicodemus - JSI Zambia Christopher Opit - JSI Zambia Brad Stora - GHSC BI&A Technical Lead Bob Celeste - RC Partners Beth Cusack - RC Partners Family Planning Mary Jo Kochendorfer - VR Greg Meyer - USAID Supply Chain for Health Michael Cooper - GHSC BI&A Data Architect Chris George - TW Danni Yu - TW Brandon Bowersox-Johnson - VR Tenly Snow - VR Josh Zamor - VR (phone) Jake Watson - VR Eric Mele - Project Director GHSC BI&A Clerisse Lemke - USAID Beth Cusack - RC Partners Bob Celeste - RC Partners Greg Meyer - USAID | @Eric Mele (Unlicensed) to share Excel of new Product Master - which is still in draft mode but which has been recently baselined Alpha to share access to MFL @Jake Watson (Deactivated) share link to OCHA site and GitHub for commodity tracking software VR to send around doodle for scheduling the technical discussion around terminology and the delta on the LRM 2.0 @Lindabeth Doby to share KPI link(s), documents for VR to ensure OpenLMIS data support as well as to review possible conflicts in calculating KPIs between USAID and OpenLMIS standard reporting (reporting rates, stockout rates, et. al.) @Eric Mele (Unlicensed) and Mike Cooper to evaluate incorporating spatial data types into BI&A @Eric Mele (Unlicensed) to publish latest version of BI&A LRM v2.1 @Eric Mele (Unlicensed) to share list of "Trade Item Attributes" - which is still in draft mode but which has been recently baselined |
Additional Reading
Product Master - DRAFT @Eric Mele (Unlicensed)
KPI Brochure - @Lindabeth Doby
Presentation by Michael Cooper
Jake: Support for spatial data (will share)
When to assign GLNs
Number them, share globally, open for many purposes
"Master Facility List" can hold the GLN, Epicore ID, OpenLMIS ID, etc.
Tie to OpenHIE
Jake: How much to assign GLNs
Lindabeth: Need a business case
Beth: Still use other stands even if not assigning GLN (use the data structure)
Wendy: There is a global project working on master facility lists "global MFL"
Eric: Master Data Trustee Group at USAID
Ability to represent data spatially
Data is currently presented through micro-strategy
Lat/long scattered through database
GLN gives you precision. Identifier. Built on GS1 company prefix. Pricing based on volume and needs.
Every identifier is a component, a structured string. One of those segments on the string is the GS1 prefix.
Consider putting identifiers into the larger global community. Develop something that is valuable to entire world, include in an open community
LMICs putting together care services discovery - master facility lists
Terminology service - lines up all ways to describe a thing
Master Facility List would hold GS1 - extensible
Not yet plugged into EPICOR
TZ- MOH owns master facility list
Even if someone doesn't use the GLN, make sure that the data set associated is clean and follows the same format
Standards for GLNs, and standards for data
Presentation by Eric Mele
Consistency for all GHSC contracts, publish data to share
Family Planning uses GPC
All else is UNSPSC
Tanzania Project: Lindabeth and Brand
Lindabeth: We've implemented Epicore in zonal warehouses. Gates work on VAN pushed us to make data useful. Matt gave access to data. BI&A team helping create visualizations.
Gloas: See stocks, facilitate transfers
Data: SO, POs, GRNs
Use informatica as ETL toolLoad in all eLMIS data"Adapter" concept with OpenLMIS
Issues: Manual data lineup
See Logical Dashboard drawing in image below.
Entity relationship model
300 logical entities (some USAID specific entities)
Changes
From the point of view of the procurer view (owner of the supply chain)
Different geographic hierarchy
"program support of control over products or programs"
More generic Logistics Locations
Purchase order = order (from approved requisition)
Sales order = shipment
Everyone would need a GLN
Product classification
Trade item id
Locations
OpenLMIS Presentation - MJ & Josh
Brian: Is vaccines a separate service or baked into whole product?
Eric: Wants more about reporting
Josh answered about Tableau
Goal: To enable countries to generate their own reports
Eric's worry is stand name and metrics in reports. Eg "Inventory Turns"
Lindabeth: USAID ISG has some standard KPIs with definitions
1 - In-country existing reports to watch
Donor reporting
Supply chain best practices built in
Issue around definitions of report terms/calculations
Have a glossary? Show on the report
Document in wiki
Product Model
Mike Cooper to work with Josh to refine. Brian T, Ashraf, Beth, and small group to refine and bring back to larger group to review
VR to reschedule
Section from Brad
Tanzania BI&A effort
Visualization of the data for Tanzania
Informatica to do data mapping
Already thinking about next version
Looking to create dashboards for actionable data
Data harmonizing Tanzania
9500 total EPICOR9 products
2500 ordered recently
375 (potential tracer products)
20 tracer products
Challenges
Don't communicate back from EPICOR9 back to eLMIS
Still working on the terminology for the KPIs
Inventory turns
Supply chain
In-full
Later Conversation around SCM, product list Malawi and OpenLMIS
OpenLMIS: the global initiative for powerful LMIS software