We've observed inconsistencies in client states within HIFIS, for example, some clients are marked as 'Active' despite not receiving services in over 90 days, while others are marked as 'Inactive' even though they still have open case management goals.
In HIFIS, client state is updated by the [dbo].[sp_checkClientState] stored procedure. This procedure can be executed for an individual client or for all clients in the database. When run for all clients, it processes them in sequential batches of …
In previous versions of HIFIS (e.g., 4.0.59.7.1) the browser was redirected to the Custom Reports tab after uploading a custom report. This is no longer occurring in HIFIS 4.0.60.4. Instead, when uploading a custom report in 4.0.60.4, the following occurs:
After pressing the Save button, a green ‘Data Saved’ balloon is shown in the top right corner of the screen.
The browser remains on the ‘Add Report Form’, but the title of the ‘Add Report’ form is changed to ‘Report Generator | [Report Name].
Cli…
Adding Admission, Food Bank, Housing Placement, SPDAT, or Turnaways service resets the ‘Date Updated’ on the client profile to the date the service was created.
Adding a Case Management Goal resets the ‘Created By’ and ‘Updated By’ to the person creating the case management goal. It also resets the ‘Date Created’ and ‘Date Updated’ fields to the date when the case management goal was created.
When creating new services (Admissions, Case Management, Housing Placements, Reservations, SPDAT, Storage, Turnaways etc..) for a client in HIFIS 4.0.60.4.2, the 'RecentActivityModuleTypeID' and 'RecentActivityDateTime' fields in the HIFIS_Clients table are not updated to reflect the client's most recent activity.
This can result in inaccurate data shown in the 'RecentInteractionDateTime' and 'SinceLastActivityDays' fields in the vw_CoordinatedAccess and vw_CoordinatedAccessExport views.
When editing a client’s vitals in HIFIS 4.0.60.3 and 60.4, the HIFIS application sets the client’s Chronically Homeless status to ‘No’, regardless of the client's current Chronically Homeless status. This may cause the Chronically Homeless status of some clients to be reported incorrectly by the application.
Slow load time of the Client List in HIFIS 4.0.60.2.1 when the Client List filter is set to Active or All.
Upon further investigation, the HIFIS application sends a query to the database for every client in the list to determine their racial identity. With thousands of clients appearing in the ‘Active’ and ‘All’ client lists, this adds significant delay to the loading of the client list.
The racial identity queries may not even be necessary as this information is not displayed anywhere in the Clie…
When attempting to upgrade the HIFIS database in our test environment using the database upgrade script for HIFIS version 4.0.60.2, we ran out of disk space.
This did not occur when upgrading our test environment to any version of HIFIS prior to 4.0.60.2.
To see what was causing this, I ran the database upgrade script on my laptop (which has more space).
The size of tempDB transaction log had increased from 4 GB to almost 30 GB after running the script.
Subsequent executions of the sp_UpdateClientCh…