Report Description | ||||
This report is designed to display all “CalMHSA Program Meta Tagging” records with all available data that been selected for the record on the “CalMHSA Program Meta Tagging Detail” screen. | ||||
Report Name | Menu Path | Client Based | Report RDL Name | |
CalMHSA 302 – Program Meta Tagging Report | CalMHSA 302 – Program Meta Tagging Report (My Office) | N | RDLCALMHSA_302_ProgramMetaTagging | |
Parameters | Data Type | Hidden | Comments | |
Programs | Multiple Select | N | A multiple select dropdown that allows users to specify which Programs will the data be pulled from. | |
Funding (What is shown on the report/front end: Funding Sources) | Multiple Select | N | A multiple select dropdown that allows users to specify which funding sources to be used in the report’s criteria. | |
MHEBP (What is shown on the report/front end: MH Evidence Based Practices) | Multiple Select | N | A multiple select dropdown that allows users to specify which MH evidence-based to be used in the report’s criteria. | |
SUDEBP (What is shown on the report/front end: SUD Evidence Based Practices) | Multiple Select | N | A multiple select dropdown that allows users to specify which SUD evidence-based practices to be used in the report’s criteria. | |
SS (What is shown on the report/front end: Service Strategies) | Multiple Select | N | A multiple select dropdown that allows users to specify which service strategies to be used in the report’s criteria. | |
ClinicalDataAccessGroupId | Integer | Y | Passed by system at report run time based on currently logged in Staff | |
ExecutedByStaffId | Integer | Y | Passed by system at report run time based on currently logged in Staff | |
DataSets | Form(s) | CDAG enforced | Comments | |
DataSet1 | CalMHSA Program Meta Tagging Detail | N | This query is used as the main query for the report. It is used to pull up all non-deleted CalMHSA program meta tagging records from the CustomCalMHSAProgramMetaTagDetail table using the “Programs”, “Funding”, “MHEBP”, “SUDEBP”, and “SS” parameters as it’s criteria. | |
Funding | N/A | N | This query is used to populate the “Funding” parameter. The options are hard coded. | |
MHEBP | N/A | N | This query is used to populate the “MHEBP” parameter. The options are hard coded. | |
SUDEBP | N/A | N | This query is used to populate the “SUDEBP” parameter. The options are hard coded. | |
SS | N/A | N | This query is used to populate the “SS” parameter. The options are hard coded. | |
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. | |
GetCountyLogo | N/A | N/A | County logo image for display on page header | |
|
|
| Default User Roles | |
|
|
|
| |
