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 

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.  

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