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 as 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 prefers not to answer
  • 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 

Choose an option for applying the CoC filter:

  • Agency CoC: Data will pull from Agencies with the selected CoC(s)
  • Program CoC: Data will only pull from Programs/Projects with the selected CoC(s)
  • Site CoC: Data will only pull from Sites with the selected CoC(s) 
  • Inventory CoC: Data will only pull from Bed Inventories with the selected CoC(s). Note: Choosing this option will limit to only those projects with Bed Inventories.

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. drilldowns can be accessed by selecting any count within the report. These drilldowns will contain a table with Unique ID, Client Name, a Data Quality Score, and the 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 8 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 and Ethnicity, and Veteran Status. This information can assist the user in resolving data quality issues and increase the AVG DQ%. 

Capture 2024-01-08 at 14.41.30


Updated:01/09/2024