fct_chsp_service_visits

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 model records all CHSP visits, memberships for CHSP services post 1st July 2025, including the date and time of the visit, the service provided, the associated membership, and whether the service is mapped to the new service codes. Using this model, you can: - Track all CHSP visits and services provided after the 1st July 2025. - Identify which visits are mapped to the new service codes or may require manual mapping. - Monitor the status of visits. Note: The CHSP services are linked to the products offered by the provider, the product itself may not directly indicate the service provided. The support category column in dim_products is an indicator of the CHSP service linked to the product.