[GNRL-406] Service Census [Program Based]

Report Purpose & Summary

Similar to [GNRL-103] Service Census, this report provides a count of clients that received selected services per day within the report date range. Unlike [GNRL-103] Service Census, this report has a table for each program to differentiate where the client received the service. Drilldown functionality generates all client names for those who received each service, as well a data quality score, and the staff member responsible for entering the information.

Running the Report

Report Location

The Service Census [Program Based] report is found in the Program Based section of the Report Library. There is also an administrator version of the report that is found in the Administrator Reports section.

Who Can Run the Report

Anyone can run the report but the returned information will be limited based on the access rights of the user.

Parameters

The following parameters are needed to determine the criteria for data returns in the report.

Program Type(s)	All Single Select Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially)
Program Status	All Programs Active Programs Inactive Programs
Program(s)	All Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially)
Service Category(-ies)	All Single Select Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially)
Service(s)	All Single Select Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially)
Veterans Status	All Yes No Client Doesn't Know Client Refused Data Not Collected
Report Date Range	The date range of the provided services to include in the report
Report Output Format	Web Page, PDF, or Excel

Additional Administrator Report Parameters

CoC	All Single Select Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially)
Agency Status	All Agencies Active Agencies Inactive Agencies
Agency Filter Category	Agency CoC Program CoC Site CoC Bed CoC
Agency(-ies)	All Single Select Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially)

Report Details

The Service Census [Program Based] report gathers information based on services provided at the program level. The information in this report is pulled from service transactions conducted during the reporting period within an enrollment.

Programs with No Service Provided

The first table in the report will return a list of selected programs that had no applicable service transactions within enrollments. This table will only be displayed if there are programs that did not provide selected services within the report date range. Programs with No Service Provided

Service Listing

There is a service listing table for each program selected in the parameters. Services selected in the report parameters and provided to clients will be grouped by month and displayed on the left side of the report if they have been provided to a client.

Each month included in the report is broken down into calendar days. The individual cells indicate the number of clients receiving that particular service for that particular day.

Below the service counts by day is a table with the total number of services provided and total number of unduplicated clients served.

Service Listing Table

Services without any Households Served

This table displays services selected in the parameter options that were not provided to any households per program. This table will only be displayed if there are selected services that were not provided to clients during the reporting period.

Services without any households served

Drilldown Functionality

Drilldown functionality is available for this report. Drill downs can be accessed by selecting any count within the report. These drill downs will contain a table with Unique ID, Client Name, a Data Quality Score, and responsible staff person for entering the client’s information on the client profile screen. The total count of clients and average data quality scores are found below the table.

Data Quality Drilldown

Clicking the client name in the initial drilldown screen will provide Data Quality information for that particular client. The 9 fields used to calculate the data quality score are Quality of Name, Social Security Number, Quality of Social Security Number, Date of Birth, Quality of Date of Birth, Gender, Race, Ethnicity, and Veteran Status. This information can assist the user in resolving data quality issues and increase the AVG DQ%.

DQ Drilldown