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.

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 beds, and if there's a client in them, it lists the client's stay information. No mess, no fuss. We also include an updated version of the official HIFIS Bed List report that references this new view.

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.

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.

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 Group Activities, but it should. We've created an identical version of the view that also includes Group Activities.

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.

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.

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 same family book in at the same shelter at the same time? If the answer to both of these questions is a yes, then the stay is interpreted as a family stay.

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.

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.

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.

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.