vw_ACRE_Appointments - Sample Output
Appointments Dataset
Data Wrangling Project

This simple view compiles information from the Appointments module into one convenient dataset. It includes all the relevant information about each Appointment, including client information, location information, notes, and who the appointment was with.

CAD 100
Bed List - Sample Data
Bed List Dataset
Data Wrangling Project

This dataset is a fixed version of vw_BedList. It's not quite a bug, but the data in vw_BedList has been collected in a way that makes it difficult to use. This cleaner dataset simply lists all the be…

CAD 0
vw_ACRE_CallsVisitsLog - Sample Output
Calls and Visits Log Dataset
Data Wrangling Project

This simple view compiles information from the Calls and Visits Log module into one convenient dataset. It includes all the relevant information about each log, including client information, subject and comments, geographic region, service provider, and more.

CAD 100
Case Management Summary Dataset
Data Wrangling Project
CAD 100
Case Management Sessions Dataset
Data Wrangling Project
CAD 100
Case Management Comments Dataset
Data Wrangling Project
CAD 100
vw_ACRE_Clients_Privacy - Sample Output
Clients Privacy Dataset
Data Wrangling Project

This dataset is an improved version of vw_ClientBasics that respects the privacy of clients. It includes names, gender, DOB, age, and citizenship, veteran, and indigenous statuses. In addition, it sup…

CAD 100
vw_ACRE_CustomTables_Clients - Sample Output
Custom Tables (Client Vitals) Dataset
Data Wrangling Project

The view combines data from all Custom Tables attached to the Client Vitals screen in your community, making it much easier to utilize your custom data.

CAD 200
Clients Services - Sample Data
Clients Services Dataset
Data Wrangling Project

This dataset is a fixed version of vw_ClientsServices. For several years now there has been a bug present in vw_ClientsServices, which is referenced by many reports. The bug? This view doesn't include…

CAD 0
vw_ACRE_FamilyMembers - Sample Output
Family Members Dataset
Data Wrangling Project

This view compiles information about the family memberships of clients in HIFIS. Each record represents a client's family membership, with applicable date ranges, along with their family role. It also pulls basic information about the family head and each family member, including age and gender.

CAD 100
vw_ACRE_Stays_Family - Sample Output
Family Stays Dataset
Data Wrangling Project

The view combines data from the Admissions module and also the Families module. The following logic is used: when the client booked in, were they in a family? And if so, did any other members of the s…

CAD 150
vw_ACRE_GoodsAndServices_Merged - Sample Output
Goods & Services (Merged) Dataset
Data Wrangling Project

This view compiles and merges information from the Goods & Services module into one convenient dataset. It includes all the relevant information about each Goods & Services transaction, including client information, program information, and the user that entered the transaction.

CAD 150
vw_ACRE_GoodsAndServices_Services - Sample Output
Goods & Services (Services) Dataset
Data Wrangling Project

This simple view compiles information from the Goods & Services module into one convenient dataset. It includes all the relevant information about each Services transaction, including client information, program information, and the user that entered the transaction.

CAD 100
vw_ACRE_GoodsAndServices_Goods - Sample Output
Goods & Services (Goods) Dataset
Data Wrangling Project

This simple view compiles information from the Goods & Services module into one convenient dataset. It includes all the relevant information about each Goods transaction, including client information, program information, and the user that entered the transaction.

CAD 100
vw_ACRE_HousingPlacements - Sample Output
Housing Placements Dataset
Data Wrangling Project

This view pulls in data from over 40 fields that are relevant to Housing Placements, so you have an easy way to reference everything you need, all in one place. It includes several useful measurements…

CAD 150
vw_ACRE_Incidents - Sample Output
Incidents Dataset
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.

CAD 100
vw_ACRE_ProgramEntry - Sample Output
Program Entry Dataset
Data Wrangling Project

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 a…

CAD 150
vw_ACRE_Turnaways - Sample Output
Turnaways Dataset
Data Wrangling Project

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 al…

CAD 100
VI-SPDAT v2 Dataset
Data Wrangling Project

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 individua…

CAD 200