Program-Based Reports

[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 

Who Can Run the Report 

All users can run the report. There are restrictions on which information can be accessed based on the user's access rights.

The Admin version of the report can be run across agencies by System Administrators and others with the appropriate access roles.

Report Location 

This report can be found in the following locations in the Report Library:

  • Program Based Reports  → [GNRL-406] Service Census [Program Based]
  • Administrator Reports → [GNRL-406-AD] Service Census [Program Based]

Parameters 

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

Project Type(s) 

Choose which project type(s) to include: 

All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Program Status 

  • All Programs 
  • Active Programs 
  • Inactive Programs 

Program(s) 

Choose which program(s) to include: 

All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Service Category(-ies) 

Choose which service category(ies) to include: 

All, Single Select, or Multi-Select (Hold Control/Command or Hold Shift to select multiple options sequentially.)

Service: Service Item(s) 

Choose which service item(s) to include: 

All, Single Select, or 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 

Select a CoC.

Agency Status 

  • All Agencies 
  • Active Agencies 
  • Inactive Agencies 

Agency Filter Category 

  • Agency CoC 
  • Program CoC 
  • Site CoC 
  • Bed CoC  

Agency(-ies) 

Choose which agency(ies) to include: 

All, Single Select, or 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.  

Drilldown

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


Updated 4/25/2023