Report Description | ||||
This report is designed to display a total count of clients enrolled in a Program by age range. Users can setup a date range looking at the client’s enrollment and discharge dates. using the FROM and THRU filters. Users also can specify which programs and age range they want to look at using the Select Programs and Select Age Group filters. | ||||
Report Name | Menu Path | Client Based | Report RDL Name | |
CalMHSA 303 – Program Enrollments by Age Range Report | CalMHSA 303 – Program Enrollments by Age Range Report (My Office) | N | RDLCALMHSA_303_ProgramEnrollments | |
Parameters | Data Type | Hidden | Comments | |
FROM | Date | N |
| |
THRU | Date | N |
| |
Select Programs | Multiple Select | N | A multiple select that allow users to specify the programs the report will pull data from. | |
Select Age Groups (do NOT choose overlapping age groups) | Multiple Select | N | A multiple select that allow users to specify the age groups the report will pull data from. | |
Clinical Data Access GroupId | Integer | Y | Passed by system at report run time based on currently logged in Staff | |
StaffId | Integer | Y | Passed by system at report run time based on currently logged in Staff | |
DataSets | Form(s) | CDAG enforced | Comments | |
DataSet2 | Client Information (Client), Client Programs (Client) | Y | This query is used to pull age data base on the ClientProgram table join with the Client table. It uses the following logic: · Client, ClientProgram, and Program records’ recorddeleted column is either = ‘N’ or NULL · Client’s DOB is not NULL · Client’s program enrollment date is on or after the FROM date parameter · Client’s program’s discharge date, if there is one, is on or before the THRU date parameter. If there is no discharge date(IE NULL), then checks if current date is on or before the THRU date parameter · Client’s enrolled programs are within the selected programs list by the Programs parameter. | |
Programs | Programs (Admin), Staff Details -> Proc/Prog/Loc/Proxy/Supervisor | Y | This query is used to populate the Select Programs parameter. The data that is pulled is base off the following logic: · The program-to-CDAG mapping object with the login user’s last used CDAG is active. (Last used CDAG is pulled from the StaffLoginHistory table) · The date of the report being ran is within the login staff’s start and end date with last used CDAG. | |
AgeGroups | N/A | N | This query is used to populate the Select Age Groups parameter. The values are hard coded. | |
GetCountyLogo | N/A | N/A | County logo image for display on page header | |
|
|
| Default User Roles | |
|
|
|
| |
