fct_chsp_service_transactions

From 1 July 2025, changes were made to way CHSP services were described, regulated, and delivered. As part of these changes, the current CHSP services were mapped to new service IDs. Here is a list of the new service IDs: https://github.com/thelookoutway/lookout/blob/main/db/static/chsp_service_types.csv.

While some of the old service IDs were automatically mapped to new service IDs, some were not. E.g. 58 is the old nursing service ID which can’t be mapped automatically, so any CHSP products with an external_id of 58 are no good for claims and require manual mapping to a new service ID.

This table combines purchase orders and invoices for CHSP services into a single table for CHSP services related transactions. It includes all the relevant details about Invoices and Purchase Orders when the users in the Lookout portal enable the Override flag.

Using this model, you can track: - Track all Invoices and Purchase Orders raised for CHSP services after the 1st July 2025. - Identify which Invoices and Purchase Orders raised are not mapped to the new service codes. - Identify which Invoices and Purchase Orders raised are mapped to the new service codes. - Join this table with fct_invoices by using source_type = ‘Invoice’ to get more Invoice details. - Join this table with fct_purchase_orders by using source_type = ‘PurchaseOrder’ to get more Purchase Order details.