Introduction
...
-> The system takes all regular requisitions for a particular year eg: 1 July 2022 ended 30 June 2023, 1 July 2023 - 30 June 2024.
-> The system finds out how many requisitions have been ordered in a particular period for all available programs for each facility (sum requisition line items for all products and group by product).
The requisitions should be regular and at least approved, if not they will be not included in the “Adjusted Consumption (in Packs)” in the prepare BUQ csv.
What is the “Adjusted Consumption (in Packs)” formula?
...
DRAFT
when the forecasting is prepared but not submitted
SUBMITTED
when the forecasting is submitted but not authorized
AUTHORIZED
when the forecasting is authorized (or submitted & authorized at once)
IN_APPROVAL
when the forecasting is approved by the first approve level and is waiting for the second approve
APPROVED
when the forecasting is approved by all the levels (lower than the MOH/PORALG) and is waiting for the final approve by the MOH/PORALG
APPROVED_BY_NQT
when the form is approved by MOH/PORALG - final status
REJECTED
when the form has been rejected on one of the approval levels (district, region, MOH/PORALG), the form is returned to the first user with rights to submit or submit&authorize the form
On the final step of approval (MOH/PORALG) the table constains 5 medicine categories. The costs are grouped into the categories based on the each product code (it’s first 2 numbers)
Pharmaceuticals | Medical supplies & Equipment | Radiology (x-rays consumables) | Diagnostics supplies & Equipment | Dental supplies & Equipment |
|---|---|---|---|---|
when product code starts with number: 10 | when product code starts with number: 20 | when product code starts with number: 30 | when product code starts with number: 40 | when product code starts with number: 50 |
When specific product does not start with the mentioned numbers then it will be classified as “Other”.