Data Wrangling Project

This simple view compiles information from the Incidents module into one convenient dataset. It includes all the relevant information about each Incident, including involved clients and staff, emergency service involvement, notes and recording staff.

This view pulls data from all services where a Program has been added. For each Program, a client's Program Entry Date is determined as the earliest date that a client ever began receiving a service associated with that Program. In addition, the view calculates what the client's most recent Housing Status was at the time of Program Entry. Intended for HPP-funded communities.

This simple view compiles information from the Turnaways module into one convenient dataset. It compiles both identified and anonymous Turnaways together, making it easier to summarize. It includes all relevant information, including reasons for service and turnaway, requested by staff, and referral information.

The dataset pulls data from the VI-SPDAT (Adult) version 2 and organizes it into a single view, listing overall data about the VI-SPDAT (i.e. caseworker, date and time) along with answers to individual questions stored in columns. It also calculates the number of VI-SPDATs the client has completed, and retrieves the trimorbidity score along with other section scores.