Release Notes for PEPFAR Data Genie: Quarter 4 Release Updates
Version 1.5.0 (October 4, 2018)
1. Overview of changes
PEPFAR Data Genie (Genie) has been updated to add Q4 data, update approval levels, and to use a new Extract, Transform, Load (ETL) process that improves the efficiency of nightly syncs with DATIM. The historical budget report has been removed.
2. Addition of Quarter 4 data
In process Q4 data is now available in the following reports: MER Approved, OUxIM, PSNUxIM, SitexIM, Data Review Tool. Data is refreshed nightly from DATIM.org.
3. Approval Level Changes
Approval levels have been updated to accommodate a new approval level added in DATIM. Refer to the tables below for the previous and current approval levels and descriptions.
Previous:
Level | Description | Meaning |
2 | Global | Approved ("pushed") to Global by Inter-Agency |
3 | Inter-Agency | Ready for Inter-Agency review/approval |
4 | Agency | Submitted by Partner to Agency |
5 or 99 | Partner | At Implementing Partner level, not yet submitted |
Current:
Level | New Description | Approved? |
3 | Submitted by Inter-Agency | Considered pushed to Global and Approved |
4 | Submitted by Funding Agency | Unapproved |
5 | Submitted by Implementing Partner | Unapproved |
99 | Not submitted to workflow | Unapproved |
4. New Extract, Transform, Load (ETL) Process
Genie has been updated to use a new Extract, Transform, Load (ETL) process that improves the efficiency of nightly syncs with DATIM. The same ETL process is used for the data that populates Panorama and the MER and SIMS Structured Dataset.
5. Removal of Budget Report
The Budget report displaying historical FY15 Budget data is no longer available. Please refer to FACTS Info for historical budget data.
Comments