Products
Data Wrangling Project
- All
- Audit Boot Camp (13)
- Premium Reports (2)
- Free Reports (59)
- Front Line Staff Training (4)
- Supervisor Training (7)
- Newfoundland & Labrador HIFIS Training (3)
- Data Wrangling Project (10)
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.
Calls and Visits Log 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.
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 suppresses data for hidden clients and clients with declined - anonymous consent and indicates whether clients are hidden and/or declined.
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.
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.
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.
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.
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, including search duration and total subsidy, as well as listing caseworkers, landlords, housing type, address and geographic region, and more.
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 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.
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 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.