Report Description | ||||
This report is designed to pull data from both the “Adult Medi-Cal Screening Tool” and “Youth Medi-Cal Screening Tool”. It will determine on client’s MCP/MHP, PCP, SUD, and Clinician referral. It gives users options on filtering out the data between dates, programs, and screening tool. | ||||
Report Name | Menu Path | Client Based | Report RDL Name | |
CalMHSA BHQIP Report | CalMHSA BHQIP Report(My Office) | N | RDLCALMHSABHQIPReport | |
Parameters | Data Type | Hidden | Comments | |
FROM | Date | N |
| |
THRU | Date | N |
| |
Program | Multiple select | N | A multiple select that allows users to select which programs the pulled data will be base off. | |
ScreeningTools | Single select | N | A single select that allows users to specify whether the report will only display Youth, Adult, or both screenings. Defaulted to both screenings. | |
ShowFooter | Single select | N | A toggle that allows users to specify whether the footer of the report will be hidden or not. This is mainly for exporting purposes. Defaulted to No – footer will be hidden. | |
ClinicalDataAccessGroupId | Integer | Y | Passed by system at report run time based on currently logged in CDAG | |
ExecuteedByStaffId | Integer | Y | Passed by system at report run time based on currently logged in CDAG | |
DataSets | Form(s) | CDAG enforced | Comments | |
Youth_Screening | Youth Medi-Cal Screening Tool, Client Information | Y | This query pulls all signed Youth medi-cal screening tool document data whose effective date is within the date range set by the FROM and THRU parameters and are under one of programs selected by the Program parameter. The query pulls the following information: ClientId, DocumentVersionId, Client Name, ProgramId, ProgramName, Authorid, Author Name, Date of Doc, Crisis, Self/Other, ScreeningTotalScore, Referred to MCP/MHP?, Referred to PCP?, Referred to SUD?, and Referred to Clinician?. Logic on the Referred to MCP/MHP by order of operations. If any of the conditions is true, the logic will stop at that condition: · CurrentlyReceivingMHTreatmentFrom = ‘MCP’ then display ‘MCP’ · CurrentlyReceivingMHTreatmentFrom = ‘MHP’ then display ‘MHP’ · (CrisisSituation = ‘N’ AND ScreeningTotalScore <= 5 then display ‘MCP’ · CrisisSituation = ‘N’ AND (ScreeningTotalScore > 5 OR LegalSystemCurrently =’Y’ OR InFosterCareCurrently = ‘Y’ OR HasBeenHomeless=’Y’) then display ‘MHP’ · ELSE display ‘N/A’ Logic on the Referred to PCP by order of operations. If any of the conditions is true, the logic will stop at that condition: · CrisisSituation = ‘Y’ then display ‘N/A’ · (CrisisSituation = ‘N’ AND (dbo.csf_GetGlobalCodeNameById(MonthsSinceLastDrVisitCode) <> ‘0-6 Months’ AND AgeOfPerson <=3)) OR (CrisisSituation = ‘N’ AND (AgeOfPerson >= 4 AND dbo.csf_GetGlobalCodeNameById(MonthsSinceLastDrVisitCode) = ‘Over a year ago’)) OR (CrisisSituation = ‘N’ AND dbo.csf_GetGlobalCodeNameById(MonthsSinceLastDrVisitCode) = ‘Unsure/Don”t Know’) then display ‘Y’ · ELSE display ‘N’ Logic on the Referred to SUD by order of operations. If any of the conditions is true, the logic will stop at that condition: · HavingTroubleDrugsOrAlcohol = ‘Y’ AND CrisisSituation = ‘N’ then display ‘Y’ · HavingTroubleDrugsOrAlcohol = ‘N’ then display ‘N’ · ELSE display ‘N/A’ Logic on the Referred to Clinician by order of operations. If any of the conditions is true, the logic will stop at that condition: · EmergencyOrCrisisSituation = ‘Y’ then display ‘N/A’ · EmergencyOrCrisisSituation = ‘N’ AND cst.ThoughtsOfEndingLifeOrNotWakeUpInPastMonth= ‘Y’ then display ‘Y’ · ELSE display ‘N’ | |
Adult_Screening | Adult Medi-Cal Screening Tool, Client Information | Y | This query pulls all signed Adult medi-cal screening tool document data whose effective date is within the date range set by the FROM and THRU parameters and are under one of programs selected by the Program parameter. The query pulls the following information: ClientId, Client Name, ProgramId, ProgramName, Authorid, Author Name, Date of Doc, Crisis, Currently Receiving Services, TotalScore, Referred to MCP/MHP?, Referred to SUD?, and Referred to Clinician? Logic on the Referred to MCP/MHP by order of operations. If any of the conditions is true, the logic will stop at that condition: · EmergencyOrCrisisSituation = ‘Y’ then display ‘N/A’ · CurrentlyReceivingMHTreatmentFrom = ‘MHP’ then display ‘MHP’ · CurrentlyReceivingMHTreatmentFrom = ‘MCP’ then display ‘MCP’ · CurrentlyReceivingMHTreatmentFrom IS NULL AND EmergencyOrCrisisSituation = ‘N’ AND TotalScore > 5 then display ‘MHP’ · ELSE display ‘MCP’ Logic on the Referred to SUD by order of operations. If any of the conditions is true, the logic will stop at that condition: · EmergencyOrCrisisSituation = ‘Y then display ‘N/A’ · WHEN EmergencyOrCrisisSituation = ‘N’ AND (ConcernedAboutAlcoholDrugUse= ‘Y’ OR DangerousBehaviorCausedByAlcoholDrugs=’Y’) then display ‘Y’ · ELSE display ‘N’ Logic on the Referred to Clinician by order of operations. If any of the conditions is true, the logic will stop at that condition: · EmergencyOrCrisisSituation = ‘Y’ then display ‘N/A’ · EmergencyOrCrisisSituation = ‘N’ AND ThoughtsOfEndingLifeOrNotWakeUpInPastMonth= ‘Y’ then display ‘Y’ · ELSE display ‘N’ | |
Program | Programs (Admin) | Y | This query pulls in all active programs that is mapped to the login user’s session CDAG that is active during the time of the report being ran. | |
|
|
| Default User Roles | |
|
|
|
| |
