CalMHSA Co-Signer Status Report

Report Description
Report Description This report is designed to display the status of documents in SmartCare based on the date range, programs, status, and co-signer selected by the end user. It is designed to help users identify documents that should have a co-signer but do not. The report will enforce CDAG security protocols.
Report NameMenu PathClient BasedReport RDL Name
Report Name CalMHSA Co-Signer Status ReportMenu Path Reports/CalMHSA Co-Signer Status ReportClient Based NReport RDL Name RDLCALMHSA_CosignerStatus.rdl
Header Column #1Header Column #2Header Column #3Table Header
Header Column #1 Clinical Data Access GroupIdHeader Column #2 IntegerHeader Column #3 YTable Header Passed by system at report run time based on currently logged in CDAG
Header Column #1 Executed By StaffIdHeader Column #2 IntegerHeader Column #3 YTable Header Passed by system at report run time based on currently logged in CDAG
Header Column #1 Start DateHeader Column #2 DateHeader Column #3 NTable Header Date parameter that will default to the current date minus 90 days
Header Column #1 End DateHeader Column #2 DateHeader Column #3 NTable Header Date parameter that will default to the current date
Header Column #1 ProgramsHeader Column #2 IntegerHeader Column #3 NTable Header Program multiple select based on logged in user CDAG and staff programs
Header Column #1 StatusHeader Column #2 IntegerHeader Column #3 NTable Header Multiple Select parameter that will display Signed, Declined or Pending
Header Column #1 CoSignerHeader Column #2 IntegerHeader Column #3 NTable Header Multiple Select parameter that will display Staff Names based on the Signers dataset
DataSetsForm(s)CDAG EnforcedComments
DataSets DataSet1Form(s) Staff Service InformationCDAG Enforced N/AComments Used to get the staff nae, caseload role, treatment team role, client name, most recent service date, procedure and clinician where the service was in show or complete status, and next appointment date, procedure code, and clinician for the currently logged in staff person from the services, and client treatment team tables
DataSets GetCountyLogoForm(s) N/ACDAG Enforced N/AComments County logo image for display on page header
DataSets ProgramsForm(s) ProgramsCDAG Enforced N/AComments Used to populate the Program parameter with active programs that the user has access to in Staff profile
DataSets SignersForm(s) Staff/UsersCDAG Enforced N/AComments Used to get documents in statuses - In Progress/ Signed /Ready to Sign/ To Be Reviewed for the selected date range and populate the CoSigner parameter with staff names where the relationship to the client does NOT have a value and the signature order is greater than 1 (co-signer)
Default User Roles
Default User Roles County Affiliate SysAdmin CalMHSA SysAdmin Clinician Supervisor Medical Supervisor