CBIMS Desktop

The Department of Social Development (DSD) in association with Aarix Business Soulutions (www.Aarix.com) developed a web-based OVC database called the Community Based Intervention Monitoring System (CBIMS) and roll-out began on the 1st September 2013 to DSD staff based at District Offices. DSD staff will initially capture on behalf of CBO’s and later become involved in training of data capturers within CBOs.

Subsequent to the development of CBIMS, it was found that many organizations needed offline capture facilities. Apps4D was contracted to work off the USAID OVC database and convert it to match CBIMS, and create an MS Access based desktop version of CBIMS.  This version (“CBIMS Desktop”) would also allow import from the USAID OVC Database, produce the USAID required PEPFAR Reports and closely resemble the CBIMS user interface so that CBIMS users could work interchangeably on both systems without retraining.

CBIMS Desktop was completed successfully in 2014. Many of the DSD District Data Capturers also use CBIMS desktop due to poor internet connectivity. The KwaZulu-Natal Treasury used the database for their Cash-Plus-Care  programme in 2018 and 2019. Ongoing development of the database is currently funded by Tulane University under the USAID OVCY Programme. As at May 2020 about 50 NGOs under FHI360, Mothers to Mothers, CINDI, and HIVSA are using the database.


Release Versions

Release 10.07 (09 July 2020)
  • Enables reporting on large datasets (typically 30 or more organizations) for capacity building partners Q3 reports
  • Allows unknown viral load to be selected in HIVSTAT
  • Prevents accidental entry of future dates captured against new covid-19 services

Release 10.06 (26 June 2020) (rollup of bug-fixes in 10.05)
  • Fixes misallocation new covid-19 services. Reported on 4 June by Lifeline. 
  • Fixes undercount of EWG, putting these beneficiaries into “Not reported in Datim”. Reported by SPF on 10 June. 
  • Fixes intervention report doubles intervention count per beneficiary per date of service. Fixed 24 June.
  • Fixes issue if the user upgraded and merged simultaneously from 10.04 to 10.05, the covid-19 services were not properly installed. Fixed 24 June.

Release 10.05 (29 May 2020)
  • Four new covid-19 related services added

Release 10.04 (27 April 2020)
  • Coding to add phone support to capture form
  • Add phone support to merge code and test. Add query to set phone support true during lockdown

Release 10.03 (20 April 2020)
  • Fix bug in AGYW_PREV putting beneficiaries who have IDNr but no UID and workshop interventions into NO UID tab

Release 10.02 (10 April 2020)
  • AGYW_Prev. Add 9-year olds. Add incomplete structured intervention.
  • Add time in DREAMS category
  • Add school as filter to Pepfar, Active Beneficiary, Raw Data. Add HIVSTAT and VL to All Services Report
  • Add updated exception report to AGYW_PREV. Remove separate exception report numbers
  • Update index on survey cover to include unique name and pre/post indicator

Release 10.01 (12 March 2020)
  • Put Select top 100 code in Household and Beneficiary lists for optimization
  • Add CG-HIVSTAT to Raw Data Report. 
  • Take out Bridge 20-24 age groups in all reports. 
  • Make VL categories in Active Beneficiary report. 
  • Take out Target auto fill as these are no longer universal. 
  • Put max session check in intervention form.
  • Ensure that Primary Prevention stream cannot be also CLHIV. 
  • Add ID Type to Active Beneficiary report. 
  • Add HIVSTAT to Referral report. 
  • Add age and leave reason to Intervention Report. 
  • Add HIV Positive to HIV Testing report. 
  • Add ID Type to Active Beneficiary Report. 
  • Add Stream, school status, DSD Risk Assess fields to merge code. 
  • Take out duplicates from Active Beneficiary Report so that counts match Pepfar. Disallow duplicate filter in report.
  • Fix bug in DQA report. Changed children count in DREAMS from <20 to <=20.
  • Optimization of class initiation queries
  • Change max SKILLZ to 10
  • Code for rolling back proxy services
  • Query for CLHIV contact Covid-19 phone support
  • Reduce raw data table temp tables to prevent bloat over 2GB while running report
  • Set AGYW to be cumulative over 4 quarters

Release 10.00 (20 February 2020)
  • Conforms to USAID PEPFAR MER 2.0 (Version 2.4) September 2019
  • Make target for SAPR 80% of APR
  • Add stream to person table, beneficiary enrolment and clsPerson
  • Add Impower to capture form and intervention setup
  • Changes to AGYW_Prev report as per Tulane guidance
  • New DQA and SQA indicators in report
  • Split SQA/DQA from Pepfar
  • Fix start and end date for AGYW_Prev report
  • Allow GBI disaggregate by name
  • Pre/Post survey coding
  • Bring Age Group (Caregiver/Children) to all reports
  • Bring stream to Active beneficiary report, OVC_Prevpack, OVC_GBI, OVC_TEST, OVC_ARTLINK, HIV Testing report
  • New intervention report - add stream, age category, age
  • Exclude Prevention Stream non-allowed interventions from PEPFAR report
  • Add Stream to Intervention Capture list
  • Add Provide ARVs as a service in CBIMS
  • Carry new fields to merge and update function
  • Add Primary Prevention to Targets
  • Add Survey Cover to database
  • Complete pre/post survey in CBIMS
  • Replace Municipality drop down for Health sub-district in enrolment forms
  • Fix bug in Add new survey

Release 9.03 (20 January 2020)
  • Code to optimise reporting with large datasets: MS Access has a bug whereby the Dcount() function throws an error when used on large datasets. This function was replaced by the MS Excel UsedRange.Address()
  • A bug was fixed where COP18 instead of COP19 targets were selected for the Target Report worksheet
  • New Function – Transfer Households
  • Handle duplicates better in Pepfar: Anomalies in data can cause discrepancies in numbers in the reports. Duplicate household members especially, cause problems if a duplicate member has different HIV statuses or other characteristics reported differently. 
  • New function - Setup database for capture in new area
  • Partners running school-based programmes have requested that schools be added to beneficiary enrolment forms. The initial phase was completed in January with 25 800 public and private schools added from the Department of Education website (2018 data) with their Emis number as a unique identifier.
  • HIVSTAT updates: Preliminary HIVSTAT updates (reference to the DSD risk assessment tool) was added to CBIMS. 
  • The initial Pre-Post Survey form was added
  • AGYW changes: males were removed from the AGYW report and date formats were changed to MM/DD/YYYY.

Release 9.02 (1 November 2019)
  • The CDS Export report generates indicators for the DHIS2 platform that the CDS database runs on. Indicators have codes to indicate the OrgUnit (place), Data element, disaggregation (age category and sex) and partner. The export file is a zipped text file with 8 columns (an additional two are blank) which are coded in a way that the DHIS2 platform understands
  • Case finding indicators were added to the Pepfar Report. These included two new definitions: NEVERTESTED_HTSREACH: % of never previously tested OVC (<18 years old) who were reached by partners with HTS; and RISKFACTOR_HTSREACH: % of OVC (<18 years old) with a negative test result and accompanying risk assessment indicating that a new test is required, who were reached by partners with HTS
  • Added Household Report

Release 9.01 (20 August 2019)
  • Add drop down for exit reason as per FHI360 request
  • Add NO UIDS to Cohort tracking tool report as per Tulane and HIVSA request
  • Change reports definitions and list order as per Tulane guidance
  • Add additional leave reason to Pepfar reports. 
  • Ensure additional leave reason is compulsory for exited without graduation, add AgeCat_HIVSA to show 14yr olds in their own category.
  • Add unmasked IDNr to beneficiary list for search purposes
  • Cohort tracking relational tables as per Tulane’s request 
  • AGYW_Prev Report. Add eligible by Sex. Add Service Categories
  • Complete DQA Reports as per Tulane guidelines for version 9.01
  • Create a HIVSTAT class for new changes to the form
  • Changes to the new HIVSTAT form including better navigation by clicking on seide dates
  • Make changes to All Services Summary Report. (Bug fix on PSS category)
  • Change HIVSTAT_Unknown definitions as per request by Tulane University

Release 9.00 (1 August 2019)
  • Conforms to USAID PEPFAR MER 2.0 (Version 2.3; September 2018)
        New reports added:
  • OVC_RETENTION: Percentage of OVC (<18 years old) on ART retained in treatment 12 months after ART initiation
  • OVC_ARTLINK: Number of children/ youth (<25 years old) initiated or re-initiated on ART through partner referral (disaggregated by new initiators/re-initiators)
  • OVC_VL: Percentage of OVC (<18 years old) on ART with VL test results reported within past 12 months 
  • OVC_SUPPRESSED: Percentage of OVC (<18 years old) on ART with viral load test results reported within the past 12 months whose most recent test results show viral suppression (<1000 copies/ml)
  • Progress Report: Shows the current percentage targets reached for OVC_SERV, OVC_SERV (U18), OVC_HIVSTAT (U18), HIV +ve (U18), and On ART (U18). The reports require that targets are first set up for each COP year under Organization/Targets.
  • PREP_LINK: AGWY 15-24 linked to PrEP. Counts beneficiaries (15-24 years old at time of service) who have completed post GBV clinical care and/or received Post exposure prophylaxis (PEP).
  • Cohort Tracking Tool: This tool is used to report DREAMS AGYWs that have a UID number. The report only counts workshops completed in the period which were started less than 6 months prior to the report start date.
        Changes to existing reports:
  • OVC_SERV: Report is disaggregated by sex and age category. Child/Caregiver disaggregation is removed (but still available as a filter field). Ages over 18 are collapsed to 18+.
  • Active sub-populations: Now includes the active total (under 20 yrs) to allow percentage calculation.
  • OVC_KNOWN, OVC_HIVSTAT_ART, OVC_RETENTION, OVC_VL, OVC_SUPPRESSED now all show number and percent total 
  • HIV Positive: Removed as information is already in the HIVSTAT worksheet.
  • OVC_TEST, OVC_ARTLINK Combined into one report
  • Sub-Population report - Removed. Please use the Active Beneficiary Sub-Population worksheet in the PEPFAR Report
  • Pending Case Management Report - Only shows the latest referral for a particular service against the latest completed service. Older incomplete referrals for the same service are hidden. This is a bug-fix
  • Active Beneficiary - The coding and definition of “previously active” has been changed in CBIMS version 9.00. Previously the definition was coded to include elegible beneficiaries who had received services in to consecutive quarters. It ignored join date and whether the quarters crossed SAPR and APR. In version 9.00, “previously active” considers join dates, and only considers services in consecutive quarters Q1/Q2 or Q3/Q4. The result of this change is that many beneficiaries marked as “Not Reported in Datim” will be moved to “Exited without Graduation” in version 9.00. This is a bug fix.
  • Caregiver has been added as a column to the report.
  • Intervention and Data Capture Reports - These Reports are now accurate to 1 day. Previously they could be filtered to a minimum of a month.
  • All Services Summary. New services have been added to the All Services Summary Report
  • Cohort tracking (Exception). Previously, this report was cumulative to the report end date. In version 9.00, the report counts beneficiaries served between the start and end date.
        Other Changes:
  • Capture targets under Organisation/Targets
  • Allow capture of household with no primary caregiver
  • Viral load categories in the HIVSTAT form
  • Beneficiary type disabled in add new monthly intervention form
  • New Services (initiated on ART for the first time or reinitiated, post gender based violence minimum package, Post exposure prophylaxis
  • Collapsed GBV medical, legal and counselling services
  • Database only shows user's organisation when logging in to a database with more than one organisation
  • Merge duplicate houshold members code, ignores duplicates accross organisations, prioritises deletion of exited members
  • Queries merging the InterventionBeneficiary table have been optimized to speed up the merge process. 
  • HouseholdID has been added as a search/filter column in the Monthly Data Capture Form
  • CBIMS Export XML and Import from the USAID OVC Database have been removed from the Administration Menu

Release 8.08 (9 May 2019)
  • Fixed sort order in Pepfar report to ensure U18 at top. 
  • Added Mothers Name, Birth Place and Twin No for AGYW to Household Member form. 
  • Increased dbMaxLocksPerFile in Pending Referral Report

Release 8.07 (23 April 2019)
  • Added Active Sub-Population and HIV Positive tables to Pepfar Report. 
  • Fixed Ward 39 Msunduzi LM wrongly categorised as Msunduzi SD. 
  • Disable filtering on Beneficiary (Daily) type service before opening Intervention capture form. 
  • Added Duplicate Household Member Report. 
  • Added Duplicates filter on Active Beneficiary Report. 
  • Work done on preventing duplicate counts in all reports, if duplicates exist in database

Release 8.06 (9 April 2019)
  • Added ability to pull sub-population report and sub-population case management report for any start and end date.
  • Added BRIDGE option to sub-population report and sub-population case management report (BRIDGE counts 0-24 year olds).
  • Added sort button on CBIMS ID in intervention report as requested by SPF.
  • Fixed bug in Pending Referral report that did not update completed referrals on same day as referral made.
  • Fixed bug in Pending Referral report that did not properly update HCT and ART completed referrals.
  • Added all sub-populations to active beneficiary.
  • Changed age calculation in sub-population from end date to project start date.

Release 8.05 (13 March 2019)
  • Fixed bug in upgrade from single xml which placed some household members in incorrect households. 
  • Fixed bug in over-reporting of graduated beneficiaries

Release 8.04 (10 March 2019)
  • Features to change primary caregiver and move household members

Release 8.03 (6 February 2019)
  • Added CD4 Count and Viral Load to the HIVSTAT form as requested by USAID and Tulane. 
  • AOM Sampling changes as requested by Tulane
  • Added household street address, house number, cell number and What 3 Words address to Active Beneficiary and Sub-population Reports as requested by CINDI, AFSA and HWW. 
  • Added HIVSTAT and Date of Survey to Raw Data report as requested by KI.
  • Expose HHID and MemberID on enrolment forms for organizations using these as file reference numbers.

Release 8.02 (10 October 2019)
  • Verification rules in the beneficiary enrolment forms (AGYW) 
  • New and continuing field which impacts the active beneficiary calculation and need for sub-population. 
  • Two additional Tulane sampling survey reports were added (Tulane ALHIV Cohort for age 13 or older and the Tulane AOM Phone Survey Sampling Frame)

Release 8.01 (4 December 2018)
  • New reports added as per Tulane University guidance

Release 8.00 (12 November 2018)
  • Temporary version of CBIMS for Tulane University changes. No reports

Release 7.06 (20 September 2018)
  • Fixed bug in Sub-Populations in Active Beneficiary Report

Release 7.05 (30 September 2018)
  • On request by Centre for Positive Care, altered Data Capture Report to only include beneficiaries who have had captured beneficiary, household or workshop interventions in a time period. Exclude other edits from the report. 
  • Prevent duplicate counts in ReACH Report when a single person is captured in two households, as both caregiver and non-caregiver. 
  • Optimization of the Active Beneficiary Report for large (65 000+) datasets
Release 7.04 (25 June 2018)
  • Changes to the ECHS, BRIDGE and ReACH Reports as requested by FHI 360
  • Improvements and bug fixes for merging databases from XML files for Department of Social Development provincial offices.
  • Changes to the KwaZulu-Natal Treasury WoW Reports
  • Changes to the DIMES Summary Report as requested by NACOSA
Release 7.03
  • Added Attendance and Target Report for the Women of Worth (WoW) workshops
  • Added ability to make any month the project start date
  • Function to import of services from spreadsheet for daily interventions
  • Fixed bug reported by NACOSA in PEPFAR Report - graduated beneficiaries
Release 7.02 (30 April 2018)
  • Allow daily capture of interventions for the KZN Provincial Treasury Cash Plus Care/Women of Worth (WoW) Programme
Release 7.01 (24 April 2018).
  • New Age Categories for HCT_TST, PP_PREV, GEND_GBV, GEND_NORM and VMMC_CIRC (MER January 2018 Version 2.2).
  • BRIDGE Template changes in HIVSTAT.
  • New definition for PP_PREV (requires Vhutshilo + HCT Referral or ART Referral or ART Adherence Support).
  • Added location details to the Active Beneficiary Report for HWW
Release 7.00  (22 March 2018). 
  • Conforms to MER January 2018 Version 2.2 Active Beneficiary Definition.
  • Added Lets Talk to ECHS Report.
  • Added SRH Incomplete Referrals for ReACH Report.
  • Changed incomplete referrals in ECHS, ReACH and BRIDGE to include Active and non-active beneficiaries.
  • Added PrEP to BRIDGE.
  • Count workshop sessions only once on graduation as a service, rather than one service per session.
  • Added Workshop Report.
  • Added Beneficiary Service Capture Report.
Release 6.06 (14 February 2018). 
  • ReACH and ECHS reports updated for new active beneficiary definition.
  • AGYW vulnerability added to ECHS.
  • Disallow beneficiaries to live in two households.
  • BRIDGE Template 2018_2 to fix anomalies in HIVSTAT counts when under 15yrs are served
Release 6.05 (14 February 2018). 
  • BRIDGE Report added.
  • Transferred and Exited without graduation removed from active beneficiary count.
  • Added OrgHouseholdNr to household, beneficiary, and group search
Release 6.04 (31 January 2018). 
  • Changes to HIVSTAT as requested by HIVSA and HWW
Release 6.03 (16 December 2017). 
  • Added HIVSTAT latest survey date to beneficiary list (HIVSA request)
Release 6.02 (05 December 2017). 
  • Intervention Report (no 18) added
  • Full-screen intervention capture
  • Temp table underlying intervention capture loads faster and prevents bloat in large databases
  • Full-name search on all lists added
Release 6.01 (06 November 2017). 
  • Fixed bug in group creation (only for non-workshop) as reported by KI 
  • Improved join date query
Release 6.00 (24 October 2017). 
  • Active Beneficiary Definition in accordance with MER 2.0 v2.2 of 2 Oct 2017
  • For other changes please see changes document below - Changes in CBIMS 6.00.docx
Release 5.00 (31 July 2017). 
  • Active Beneficiary Definition in accordance with MER 2.0 January 2017
  • Reports according to new PEPFAR implementation year starting 1 October
  • For other changes please see changes document below
Release 3.08 (07 March 2017)
  • Preliminary to release 4.00. Capture forms for OVC_HIVSTAT, Schooling and AGWY Vulnerability Scores
  • Bug fixed where edit date is not updated on soft delete
Release 3.07 (03 November 2016)
  • Added code to import from CBIMS Mobile on the Commcare System
Release 3.06 (04 October 2016)
  • Corrections in the ECHS report pointed out by Hope Worldwide. Previous months OVC_SERV and OVC_ACC overcounts
  • Correction to count of home visits in the ECHS report
Release 3.05 (8 September 2016)
  • Merge from XML now allows merge into a non-empty database for Department of Social Development users
  • Active Beneficiary Report for USAID / PEPFAR users
Release 3.03 (1 June 2016)
  • Bug fixes and improvements in the workflow graph
  • Adjustment to ECHS report: "Number of new children under-5years who received age-appropriate early childhood household stimulation  (ECHS) during the reporting period" now counts newly enrolled children only who received ECHS and not all children receiving ECHS in the specified month - as pointed out by HWW
  • Bug-fix in merge of XML databases
  • Upgrade now imports existing custom queries
Release 3.02 (27 April 2016). Conforms to the definition of an active beneficiary as stated in OVCY MER Manual for Partners Implementing OVC Activities in South Africa. Version 6.1. November 2015. Changes are:
  • Adjusted PEPFAR Report for MER 2.0.
  • Added Health Sub-District Grouping
  • Added VMMC_CIRC
  • Added DREAMS (Educational Support, Economic Strengthening, Social Protection, Parenting)
  • Added OVC_KNOWN_STAT
  • Added Graduation categories
  • Added Graduation by District Municipality based on Central support sites list from USAID
  • DREAMS Social Protection is defined as:
       - Conditional and Unconditional Cash Transfers
       -  Statutory Child Protection Interventions
       -  Birth Registration and Identification Documents
       -  Succession Planning, Memory Work, Inheritance Claims
  • DREAMS Economic Strengthening is defined as
       - Household Economic Strengthening
  • "At Beginning" Counts for HCT_TST, PP_Prev, Gend_GBV, Gend_Norm corrected
  • Added DSD Disability Type Lookup for Household Members and Personnel
  • Merge function has stricter measures to ensure smooth export to CBIMS Live
  • Fixed bug in adding personnel and user - as reported by HWW and TVT
ċ
CBIMS_10.07_NEW BLANK.mdb.7z
(8883k)
Rob Cairns,
9 Jul 2020, 07:20
ċ
CBIMS_7.05_NEW BLANK.zip
(5571k)
Rob Cairns,
3 Oct 2018, 12:39
ĉ
Rob Cairns,
29 May 2020, 03:54
ĉ
Rob Cairns,
29 May 2020, 03:54
ĉ
Rob Cairns,
24 Oct 2017, 03:55
ĉ
Rob Cairns,
29 May 2020, 03:55
ĉ
Rob Cairns,
1 Sept 2015, 01:45
Ċ
Rob Cairns,
29 May 2020, 03:58
ċ
cbims_help (compiled help file).zip
(12508k)
Rob Cairns,
27 Jun 2015, 05:47
Comments