acre logo 4 ACRE Consulting
⌘K
Home About
Contact
Hire me!
Home
aAbout
sServices
HIFIS Implementation
HIFIS Training for Front Line Staff
HIFIS Training for Administrators
Report Development
Crystal Reports Training
cCrystal Reports Training
cCore Crystal Reports Training
aAccelerated Training
cCrystal Reports Resources
cCrystal Reports Mini-Courses
Data Quality
Reviewing Services
pProducts
ACRE Analytics
Audit Boot Camp
Data Wrangling Project
Downloadable Reports
Ontario HPP Program Reports
Power BI Dashboards
rResources
Blog
Canadian Alliance to End Homelessness
Guides to HIFIS Use
HIFIS Health Check
HIFIS Improvement Project
HIFIS Community
HIFIS Feedback
Privacy & Legal Resources
Quick Start Guides
Upcoming Events
Webinars Archive
No results
cContact
Hire me!
Back to products

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.

As a bonus, we're throwing in a free sample report that'll work with this dataset. It's designed for you to play with and make your own, so it's not terribly fancy. Make something beautiful with it!

vw_ACRE_CustomTables_Clients - Sample Output

This view contains the following columns, pulling data from all Custom Tables attached to the Client Vitals screen:

  • UniqueID - a unique value for each row in this table

  • CustomLinkID - a unique value corresponding to the instance of filling out the custom table

  • CustomTable - the name of the custom table

  • ClientID

  • ClientName

  • CreatedDate - when the custom table was filled out

  • CustomField - name of the custom field in the custom table

  • QuestionNumber - a non-unique number indiciating this question's position within the custom table (i.e. 1st, 2nd question)

  • FieldType - the type of field (i.e. date, drop-down)

  • Response - contains the field value, formatted as text regardless of field type

  • Response_DateAndTime - if the field was a date or datetime field, this column formats the response as a datetime, for analysis/manipulation

  • Response_Numeric - if the field was an interger, decimal, or currency field, this column formats the response as a decimal, for analysis/manipulation

  • Response_MultiSelect - if the field was a multi-select, this field creates extra rows that each contain one value, for analysis/manipulation

Documentation

  • vw_ACRE_CustomTables_Clients - Sample Output.csv

  • vw_ACRE_CustomTables_Clients - Schema.csv

  • Custom Tables Vitals Sample Report - Sample Output.pdf

CAD 200
Buy now
Price CAD 200
Buy now
acre logo 4 ACRE Consulting
Services
HIFIS Implementation Reviewing Services HIFIS 4 Health Check Custom Report Development
HIFIS Training
ACRE Consulting Academy Dufferin County HIFIS Training Grande Prairie HIFIS Training Halifax HIFIS Training Iqaluit HIFIS Training NL HIFIS Training Peterborough HIFIS Training RMWB HIFIS Training THANL HIFIS Training Waterloo HIFIS Training Yukon HIFIS Training
Crystal Reports Training
Core Training Mini-Courses Resources
Reports
ACRE Analytics Audit Boot Camp HPP Program (Ontario) Data Wrangling Project Downloadable Reports
Company
About Testimonials Blog Contact Customer service Terms and conditions
Copyright © 2026 ACRE Consulting