Reports Guide

Run and Download Reports

*Please note: The employer and case manager roles can only view a limited subset of reports to maintain HIPAA compliance.

1. Log in to DCI
2. Click Reports on the main menu
3. Select (hover over) the submenu to view the associated reports listed in the flyout menu
   1. For example, select (hover over) COA Reports on the submenu to open the flyout menu which will display all associated reports.
4. Select the report to run from the flyout menu
5. Enter desired criteria into the filters (i.e., filter by time frame, specific client, employee, service code, cost center, etc.)
6. Click the Search button
   1. The records will display in the table below the filters
7. Click the Download button
   1. Select the column(s) to be displayed on the report
   2. Select the Right Triangle button to add a column to the Selected Columns
   3. Select the Double Right Triangle >> button to add all columns to the Selected Columns
   4. Select the Left Triangle button to remove the column from the Selected Columns
   5. Select the Double Left Triangle << button to remove all columns from the Selected Columns
8. Click Next
9. Select the format to download the report by clicking the Format drop-down
   1. Formats: Excel, PDF, CSV, Tab delimited
      1. PDFs have a 10-column limitation for report downloads
   2. Select the layout for the report download in the Layout drop-down
      1. Layouts: Portrait or Landscape
      2. Layout is only available when PDF format is selected
   3. Select Download to download the report
      1. Optional - click the Save as Report Preference Checkbox to save this report preference in the future
   4. Select Yes in the confirmation alert window

Filters

Reports can be filtered based on desired criteria. Filter options vary based on the selected report. Please refer to the list below for a description of each filter.

• From: Enter the earliest date of service desired. If left blank, results will include all results from the beginning of time.
• To: Enter the latest date of service desired. If left blank, results will include all results up to the current date.
• Select Account Type: Filter results to one type of service account. Depending on the report type, choices include:
  • Client Service
  • Employee Service
  • Training
  • Hourly
  • Day Program
  • Residential Program
  • Administration
  • Drive
  • Vacation
  • Sick
  • PTO
  • Holiday
  • Mileage
  • Group Service
  • Parenting Program
  • Client Transportation
• Type Client Name: Filter results to one client
• Type Employee Name: Filter results to one employee
• Type Service Code: Filter results to one service code
• Type Cost Center: Filter results to one Cost Center. The user can also use a wildcard in the Cost Center filter to pull results for a group of cost centers
  • For example, typing OR* will include punch entries for all Cost Centers that start with OR.
• Select Activity: Filter results to one General Activity. This only applies to punches for Administration service accounts.
• Select Status (Punch): Filter results based on Punch Status. Choices include:
  • Pending
  • Open
  • Unverified
  • Approved
  • Batched
  • Paid
  • Canceled
  • Rejected
  • Processed
  • Unvalidated
• Select Status (Account): Filter results based on account Status. Choices include:
  • Active
  • Inactive
• Select Status (Program Profile): Filter results based on program status. Choices include:
  • Active
  • Inactive
• Select Status (Employee Profile): Filter results based on employee profile status. Choices Include:
  • Pending
  • Active
  • Terminated
  • Suspended
  • Extended Leave
  • Registered
• Select Status (Client Profile): Filter results based on client profile status. Choices Include:
  • Active
  • Deceased
  • Inactive
  • Discharged
  • Suspended
• Select Status (Certification Template): Filter results based on template status. Choices include:
  • Active
  • Inactive
• Select Status (Certification Requirement): Filter results based on requirement status. Choices include:
  • Active
  • Inactive
• Select Status (Business Rule): Filter results based on business rule status. Choices include:
  • Enabled
  • Disabled
• Profile Type: Filter results to one profile type. Choices include:
  • Employee
  • Client
  • Residential Program
  • Day Program
  • Group Service
  • Parenting Program
• Select Employee Type: Filter results to one employee type. Choices include:
  • Hourly Exempt
  • Hourly Non-Exempt
  • Salary Exempt
  • Salary Non-Exempt
  • Contractor
• Type City: Filter results to one city
• Type State: Filter results to one state
• Employee/Client/Residential Program/Day Program: Filter results to one entity. Filter by an employee, client, residential program, or day program. To use the filter, begin typing the name of the desired entity and select.
• Select Method (Mileage Punches): Filter results based on how the mileage punch was entered. Choices include:
  • Odometer
  • Geolocation
• Type Funding Source Name: Filter results to one funding source
• Cutoff Date: Filter authorizations up to a specific date
• Future Authorizations: Select the checkbox to include results with a start date in the future
• Ended Authorizations: Select the checkbox to include results with an end date in the past
• Discharged Clients Authorizations: Select the checkbox to include results for clients who have been discharged
• 30 Days (Expiring Within): Include results that expire in the specified window of time. Choices include:
  • 30 Days
  • 60 Days
  • 90 Days
  • 120 Days
• Enter Batch ID: Include results for a specific Payroll or Billing Batch
• Punch Entries Checkbox: Include punch entries (in addition to payroll or billing entries) on Payroll or Billing Batch reports
• Select Unit: Filter results based on billing unit. Choices include:
  • Hourly
  • Daily
  • Monthly
  • Miles
• Type Region Name: Filter results based on a specific Funding Source region.
• Select Association Type: Filter results based on which entity a template is linked to. Choices include:
  • Service Code
  • Profile (includes both Employee and Client Profiles)
  • Cost Center
  • Funding Account
  • Master Program (select for templates linked to Residential, Day, Parenting, or Group Service Programs)
• Type Requirement Name: Filter results to one Certification Requirement
• Subject: Filter Login Report results based on the event type
• Added By: Filter results based on which user completed the action