Washington Multi-County Billing Report
The Washington Multi-County Billing Report is used by Employment agencies. This report includes all the columns and data needed to complete the billing spreadsheets for most counties. Due to the differences in the billing spreadsheets for certain counties, this report is designed to accommodate all counties so there may be some extra columns that are not necessary for your county.
This report is designed for use with the DDA funder (Developmental Disabilities Administration).
There are some variations of this report designed to meet specific needs and they are listed below. All of these can be enabled by using the Report Utility.
- WA Multi-County Billing Report
- WA Multi-County Billing Report (with department grouping and offsite hours)
- WA Multi-County Billing Report (with department grouping)
- WA Multi-County Billing Report (With Phases As Minutes)
- WA Multi-County Billing Report (No Funder Exclusions Applied)
This report returns one row per Authorization for each Client. If the Client has multiple Authorizations or if they have multiple maximum hours for the month then multiple rows for the Client will be displayed.
WA Multi-County Billing Report (No Funder Exclusions Applied) - This version of the report does not exclude DVR or DSB hours like the other versions do. Please note that special consideration must be taken when using this version of the report. Contact SETWorks with any questions.
Report Columns
Client Name - Name of the Client from the Client Profile.
Department Description - Indicates the department associated with the authorization.
ADSA ID - ADSA ID from the Client Profile.
Funding Source - Funding Source from the Client's Authorization.
Max Authorized Hours - The monthly limit from the Authorization's Authorization Frequencies & Exceptions section.
Total Provider Hours - Total hours for the Authorization for the date range.
Face-to-Face Hours - Total number of hours where Face-to-Face was selected when documenting.
Count of FTF Interactions - Total number of records where Face-to-Face was selected when documenting.
Offsite Hours - Total number of hours where Offsite was selected when documenting.
Count of Offsite Interactions - Total number of records where Offsite was selected when documenting.
Phase 1 Intake/Discovery - Total number of hours where a Phase with the code of "ID" or "JP" was used.
Phase 2 Job Development/Marketing - Total number of hours where a Phase with the code of "JD" or "MJD" was used.
Phase 3 Job Support - Total number of hours where a Phase with the code of "JC" was used.
Phase 4 Record Keeping - Total number of hours where a Phase with the code of "RK" was used.
DVR/DSB/FCS Hours - Total number of hours for any other Authorizations for the Client where "DVR", "DSB", "or "FCS" is the code for the Service Type associated with the Service on the Authorization.
Paid Hours - Total Paid Hours from the Client's Earnings in their profile for the date range.
Gross Wages - Total Wages from the Client's Earnings in their profile for the date range.
Volunteer Hours - This column is no longer supported.
Other Hours (from Activity Records) - Total Hours from the Other Hours Activity Records for the date range.
Other Hours (from Placement/Community Hours) - Total Hours from the Community Hours in the Client's profile.
S2W CBA - Total number of hours for any other Authorizations for the Client where a Phase with the code of "S2W_CBA" was used.
S2W JP - Total number of hours for any other Authorizations for the Client where a Phase with the code of "S2W_JP" was used.
S2W ITS - Total number of hours for any other Authorizations for the Client where a Phase with the code of "S2W_ITS" was used.
Report Description
WA Multi-County Billing Report:
WA Multi-County Billing Report: DVR and DSB hours are excluded.
Max Authorized Hours: From the Monthly Authorization Limit set on the authorization
Paid Hours: From Placement Earnings
Gross Wages: From Placement Earnings
Volunteer Hours: From "Work Activity Tracking" within Placement where Placement Type is "Volunteer"
Other Hours: From "Other Activity" Activity Record (originally Consumer at Work)
Total Provider Hours: Sums all hours provided for the client (based on activity records/billable individual or group records). Does not limit to DDA if non-DDA hours exist. Will filter by service if a service filter is selected.
Phase Codes used:
Phase 1 Intake/Discovery uses "ID" or "JP"
Phase 2 Job Development/Marketing uses "MJD" or "JD"
Phase 3 Job Support uses "JC"
Phase 4 Record Keeping uses "RK"
S2W CBA uses "S2W_CBA"
S2W JP uses "S2W_JP"
S2W ITS uses "S2W_ITS"