CalMHSA Learn (LMS System)
Help Desk Ticket (Admin)
Customer Ticket Portal
EHR Bulletin

MENU
  • Last updated: March 9, 2026

CalMHSA 811 – TADT Report

 

Report Description

This is a report that provides timeliness data from the TADT documents based on what DHCS’s requirements are. This report is designed to allow users to run, export, and copy/paste data directly into the DHCS Excel submission form.

·       DMC-ODS Opioid Timeliness Record

·       DMC-ODS Outpatient Timeliness Record

·       MH Non-Psychiatric SMHS Timeliness Record

·       MH Psychiatric SMHS Timeliness Record

·       DMC-SP Opioid Timeliness Record

·       DMC-SP Outpatient Timeliness Record

Report Name

Menu Path

Client Based

Report RDL Name

CalMHSA 811 – TADT Report

CalMHSA 811 – TADT Report (My Office)

No

RDLCalMHSATADTMHPDMCReport

Parameters

Data Type

Hidden

Comments

StartDate

Date

N

A date filter that allows users to specify the beginning of the data range of the Documents’ “Date of First Contact to Request Services” dates for the report to use

EndDate

Date

N

A date filter that allows users to specify the end of the data range of the Documents’ “Date of First Contact to Request Services” dates for the report to use

ReportTypes

Multiple Select

N

A multiple select that allows users to specify which type of document the report pull data from. The 6 values are hard code in this dropdown.

DataSets

Form(s)

CDAG enforced

Comments

Psych

MH Psychiatric SMHS Timeliness Record (Client)

N

This dataset calls for a stored procedure labeled “csp_RDLCalMHSATADTMHPReport”. In the stored procedure, it pulls in the following parameters:

  • StartDate
  • EndDate

The stored procedure is designed to return data base on the following criterias:

·       Only pull the MH Psychiatric SMHS timeliness document data where the document’s status is equal to 22 (Signed status)

  • Only pull the MH Psychiatric SMHS timeliness document data where the timeliness’s CustomDocumentCalMHSAMHPsychiatricTADT record is not soft deleted.
  • Only pull the MH Psychiatric SMHS timeliness document data where the associated client have a CIN number. More information regarding the logic on how the report pull this CIN is down below
  • Only pull the MH Psychiatric SMHS timeliness document data where the Date First Contact to Request Services date is within the date range setup by the Start and End date parameters.

Things to note with the stored procedure:

  • Regarding the “IsUrgent” data that is returned, it will only show ‘01’ as long the IsUrgent column from the CustomDocumentCalMHSAMHPsychiatricTADT record is equal to ‘Y’. If the value is any other value (i.e. ‘N’, NULL, Blank, etc…) then it would show ‘02’
  • Regarding the “HoursElapsed” data that is returned, as long the IsUrgent column from the CustomDocumentCalMHSAMHPsychiatricTADT record is equal to ‘Y’ the store procedure will display the hour differences from the DateFirstContactToReqServices and FirstServiceApptOfferedDate columns of the CustomDocumentCalMHSAMHPsychiatricTADT record. If the IsUrgent column is not equal ‘Y’, then the store procedure will display NULL/blank
  • Regarding the “PriorAuthorizationRequired” data that is returned, if the IsUrgent and PriorAuthorizationRequired column from the CustomDocumentCalMHSAMHPsychiatricTADT record is both equal to ‘Y’ then the store procedure will display ‘01’. If the PriorAuthorizationRequired column from the CustomDocumentCalMHSAMHPsychiatricTADT record is NULL or not equal to ‘Y’ then the store procedure will display ‘02’.
  • Regarding the “WaitList” data that is returned, the store procedure will display ‘01’ as long the ReasonForDelay column of the CustomDocumentCalMHSAMHPsychiatricTADT record have value that is not blank or NULL. If the value is blank or NULL, then display ‘02’
  • Regarding the “ReferredToOutOfNetworkProvider” data that is returned, if the CustomDocumentCalMHSAMHPsychiatricTADT record’s ReferredToOutOfNetworkProvider column is equal to ‘Y’ then display ’01’. If the column value is any other value (NULL, ‘N’, etc…) then display ‘02’
  • Regarding the “DescriptionOfFactsCircumstance” data that is returned, the logic is as followed for the string is that display:
    • If CustomDocumentCalMHSAMHPsychiatricTADT’s ReasonForDelay columns is equal to the globalcodeid of “Other”, then add the string “Reason for Delay: Other — ” with OtherReasonForDelay value onto the displayed string.
    • If CustomDocumentCalMHSAMHPsychiatricTADT’s ReferredOutOfNetworkProviderDetails columns is not NULL or blank, then add the string “Referred to Out-of-Network Provider: Details — ” with ReferredOutOfNetworkProviderDetails value onto the displayed string.
    • If CustomDocumentCalMHSAMHPsychiatricTADT’s ClosureReason columns is equal to the globalcodeid of “Other”, then add the string “Closure Reason: Other — ” with OtherClosureReason value onto the displayed string.
  • Regarding the “CIN” data that is returned, the store procedure will display the MAX (biggest) InsuredId columns of all non-soft deleted, CoveragePlanId = 1 ClientCoveragePlans records that are associated to the client that the CustomDocumentCalMHSAMHPsychiatricTADT record is associated to.

NonPsych

MH Non-Psychiatric SMHS Timeliness Record (Client)

N

This dataset calls for a stored procedure labeled “csp_RDLCalMHSATADTMHNPReport”. In the stored procedure, it pulls in the following parameters:

  • StartDate
  • EndDate

The stored procedure is designed to return data base on the following criterias:

·       Only pull the MH Non-Psychiatric SMHS timeliness document data where the document’s status is equal to 22 (Signed status)

  • Only pull the MH Non-Psychiatric SMHS timeliness document data where the timeliness’s CustomDocumentCalMHSAMHNonPsychiatricTADT record is not soft deleted.
  • Only pull the MH Non-Psychiatric SMHS timeliness document data where the associated client have a CIN number. More information regarding the logic on how the report pull this CIN is down below
  • Only pull the MH Non-Psychiatric SMHS timeliness document data where the Date First Contact to Request Services date is within the date range setup by the Start and End date parameters.

Things to note with the stored procedure:

  • Regarding the “IsUrgent” data that is returned, it will only show ‘01’ as long the IsUrgent column from the CustomDocumentCalMHSAMHNonPsychiatricTADT record is equal to ‘Y’. If the value is any other value (i.e. ‘N’, NULL, Blank, etc…) then it would show ‘02’
  • Regarding the “HoursElapsed” data that is returned, as long the IsUrgent column from the CustomDocumentCalMHSAMHNonPsychiatricTADT record is equal to ‘Y’ the store procedure will display the hour differences from the DateFirstContactToReqServices and FirstServiceApptOfferedDate columns of the CustomDocumentCalMHSAMHNonPsychiatricTADT record. If the IsUrgent column is not equal ‘Y’, then the store procedure will display NULL/blank
  • Regarding the “PriorAuthorizationRequired” data that is returned, if the IsUrgent and PriorAuthorizationRequired column from the CustomDocumentCalMHSAMHNonPsychiatricTADT record is both equal to ‘Y’ then the store procedure will display ‘01’. If the PriorAuthorizationRequired column from the CustomDocumentCalMHSAMHNonPsychiatricTADT record is NULL or not equal to ‘Y’ then the store procedure will display ‘02’.
  • Regarding the “WaitList” data that is returned, the store procedure will display ‘01’ as long the ReasonForDelay column of the CustomDocumentCalMHSAMHNonPsychiatricTADT record have value that is not blank or NULL. If the value is blank or NULL, then display ‘02’
  • Regarding the “ReasonForDeplay” data that is returned, the store procedure will return data only if the ReasonForDelay column of the CustomDocumentCalMHSAMHNonPsychiatricTADT record have value that is not blank or NULL.
  • Regarding the “FollowUpAppt” data that is returned, if the CustomDocumentCalMHSAMHNonPsychiatricTADT’s IsFollowupApptNotOffered is equal to ‘Y’ then display ‘01’. Else display ‘02’
  • Regarding the “FirstFollowupApptOfferedData” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’.
  • Regarding the ‘FirstFollowupApptRenderedDate’ data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is display data.
  • Regarding the “FollowupApptWaitTimeExt” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is displaying data. Regarding the displayed data itself, if the IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSAMHNonPsychiatricTADT record is equal to ‘Y’, then display ‘01’. If IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSAMHNonPsychiatricTADT record is equal to ‘N’, then display ‘02’.
  • Regarding the “ReferredToOutOfNetworkProvider” data that is returned, if the CustomDocumentCalMHSAMHNonPsychiatricTADT record’s ReferredToOutOfNetworkProvider column is equal to ‘Y’ then display ’01’. If the column value is any other value (NULL, ‘N’, etc…) then display ‘02’
  • Regarding the “ClosureReason” data, if the CustomDocumentCalMHSADMCODSOutpatientTADT record’s ClosureDate column is not NULL/Blank then display data. Else it will display NULL/Blank
  • Regarding the “DescriptionOfFactsCircumstance” data that is returned, the logic is as followed for the string is that display:
    • If CustomDocumentCalMHSAMHNonPsychiatricTADT’s ReasonForDelay columns is equal to the globalcodeid of “Other”, then add the string “Reason for Delay: Other — ” with OtherReasonForDelay value onto the displayed string.
    • If CustomDocumentCalMHSAMHNonPsychiatricTADT’s ReferredOutOfNetworkProviderDetails columns is not NULL or blank, then add the string “Referred to Out-of-Network Provider: Details — ” with ReferredOutOfNetworkProviderDetails value onto the displayed string.
    • If CustomDocumentCalMHSAMHNonPsychiatricTADT’s ClosureReason columns is equal to the globalcodeid of “Other”, then add the string “Closure Reason: Other — ” with OtherClosureReason value onto the displayed string.

·       Regarding the “CIN” data that is returned, the store procedure will display the MAX (biggest) InsuredId columns of all non-soft deleted, CoveragePlanId = 1 ClientCoveragePlans records that are associated to the client that the CustomDocumentCalMHSAMHNonPsychiatricTADT record is associated to.

Opioid

DMC-ODS Opioid Timeliness Record (Client)

N

This dataset calls for a stored procedure labeled “csp_RDLCalMHSATADTDMCODSOPDReport”. In the stored procedure, it pulls in the following parameters:

  • StartDate
  • EndDate

The stored procedure is designed to return data base on the following criterias:

·       Only pull the DMC-ODS Opioid timeliness document data where the document’s status is equal to 22 (Signed status)

  • Only pull the DMC-ODS Opioid timeliness document data where the timeliness’s CustomDocumentCalMHSADMCODSOpioidTADT record is not soft deleted.
  • Only pull the DMC-ODS Opioid timeliness document data where the associated client have a CIN number. More information regarding the logic on how the report pull this CIN is down below
  • Only pull the DMC-ODS Opioid timeliness document data where the Date First Contact to Request Services date is within the date range setup by the Start and End date parameters.

Things to note with the stored procedure:

  • Regarding the “IsUrgent” data that is returned, it will only show ‘01’ as long the IsUrgent column from the CustomDocumentCalMHSADMCODSOpioidTADT record is equal to ‘Y’. If the value is any other value (i.e. ‘N’, NULL, Blank, etc…) then it would show ‘02’
  • Regarding the “HoursElapsed” data that is returned, as long the IsUrgent column from the CustomDocumentCalMHSADMCODSOpioidTADT record is equal to ‘Y’ the store procedure will display the hour differences from the DateFirstContactToReqServices and FirstServiceApptOfferedDate columns of the CustomDocumentCalMHSADMCODSOpioidTADT record. If the IsUrgent column is not equal ‘Y’, then the store procedure will display NULL/blank
  • Regarding the “PriorAuthorizationRequired” data that is returned, if the IsUrgent and PriorAuthorizationRequired column from the CustomDocumentCalMHSADMCODSOpioidTADT record is both equal to ‘Y’ then the store procedure will display ‘01’. If the PriorAuthorizationRequired column from the CustomDocumentCalMHSADMCODSOpioidTADT record is NULL or not equal to ‘Y’ then the store procedure will display ‘02’.
  • Regarding the “WaitList” data that is returned, the store procedure will display ‘01’ as long the ReasonForDelay column of the CustomDocumentCalMHSADMCODSOpioidTADT record have value that is not blank or NULL. If the value is blank or NULL, then display ‘02’
  • Regarding the “ReasonForDeplay” data that is returned, the store procedure will return data only if the ReasonForDelay column of the CustomDocumentCalMHSADMCODSOpioidTADT record have value that is not blank or NULL.
  • Regarding the “FollowUpAppt” data that is returned, if the CustomDocumentCalMHSADMCODSOpioidTADT ‘s IsFollowupApptNotOffered is equal to ‘Y’ then display ‘01’. Else display ‘02’
  • Regarding the “FirstFollowupApptOfferedData” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’.
  • Regarding the ‘FirstFollowupApptRenderedDate’ data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is display data.
  • Regarding the “FollowupApptWaitTimeExt” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is displaying data. Regarding the displayed data itself, if the IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSADMCODSOpioidTADT record is equal to ‘Y’, then display ‘01’. If IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSADMCODSOpioidTADT record is equal to ‘N’, then display ‘02’.
  • Regarding the “ReferredToOutOfNetworkProvider” data that is returned, if the CustomDocumentCalMHSADMCODSOpioidTADT record’s ReferredToOutOfNetworkProvider column is equal to ‘Y’ then display ’01’. If the column value is any other value (NULL, ‘N’, etc…) then display ‘02’
  • Regarding the “ClosureReason” data, if the CustomDocumentCalMHSADMCODSOutpatientTADT record’s ClosureDate column is not NULL/Blank then display data. Else it will display NULL/Blank
  • Regarding the “DescriptionOfFactsCircumstance” data that is returned, the logic is as followed for the string is that display:
    • If CustomDocumentCalMHSADMCODSOpioidTADT’s ReasonForDelay columns is equal to the globalcodeid of “Other”, then add the string “Reason for Delay: Other — ” with OtherReasonForDelay value onto the displayed string.
    • If CustomDocumentCalMHSADMCODSOpioidTADT’s ReferredOutOfNetworkProviderDetails columns is not NULL or blank, then add the string “Referred to Out-of-Network Provider: Details — ” with ReferredOutOfNetworkProviderDetails value onto the displayed string.
    • If CustomDocumentCalMHSADMCODSOpioidTADT’s ClosureReason columns is equal to the globalcodeid of “Other”, then add the string “Closure Reason: Other — ” with OtherClosureReason value onto the displayed string.

·       Regarding the “CIN” data that is returned, the store procedure will display the MAX (biggest) InsuredId columns of all non-soft deleted, CoveragePlanId = 2 ClientCoveragePlans records that are associated to the client that the CustomDocumentCalMHSADMCODSOpioidTADT record is associated to.

Outpatient

DMC-ODS Outpatient Timeliness Record (Client)

Y

This dataset calls for a stored procedure labeled “csp_RDLCalMHSATADTDMCODSOSUDReport”. In the stored procedure, it pulls in the following parameters:

  • StartDate
  • EndDate

The stored procedure is designed to return data base on the following criterias:

·       Only pull the DMC-ODS Outpatient timeliness document data where the document’s status is equal to 22 (Signed status)

  • Only pull the DMC-ODS Outpatient timeliness document data where the timeliness’s CustomDocumentCalMHSADMCODSOutpatientTADT record is not soft deleted.
  • Only pull the DMC-ODS Outpatient timeliness document data where the associated client have a CIN number. More information regarding the logic on how the report pull this CIN is down below
  • Only pull the DMC-ODS Outpatient timeliness document data where the Date First Contact to Request Services date is within the date range setup by the Start and End date parameters.

Things to note with the stored procedure:

  • Regarding the “WithdrawalMangement” data that is returned, it will only show ‘01’ if the WereWithdrawalServicesProvided column of the CustomDocumentCalMHSADMCODSOutpatientTADT record is equal ‘Y’. Else will display ‘02’.
  • Regarding the “IsUrgent” data that is returned, it will only show ‘01’ as long the IsUrgent column from the CustomDocumentCalMHSADMCODSOutpatientTADT record is equal to ‘Y’. If the value is any other value (i.e. ‘N’, NULL, Blank, etc…) then it would show ‘02’
  • Regarding the “HoursElapsed” data that is returned, as long the IsUrgent column from the CustomDocumentCalMHSADMCODSOutpatientTADT record is equal to ‘Y’ the store procedure will display the hour differences from the DateFirstContactToReqServices and FirstServiceApptOfferedDate columns of the CustomDocumentCalMHSADMCODSOutpatientTADT record. If the IsUrgent column is not equal ‘Y’, then the store procedure will display NULL/blank
  • Regarding the “PriorAuthorizationRequired” data that is returned, if the IsUrgent and PriorAuthorizationRequired column from the CustomDocumentCalMHSADMCODSOutpatientTADT record is both equal to ‘Y’ then the store procedure will display ‘01’. If the PriorAuthorizationRequired column from the CustomDocumentCalMHSADMCODSOutpatientTADT record is NULL or not equal to ‘Y’ then the store procedure will display ‘02’.
  • Regarding the “WaitList” data that is returned, the store procedure will display ‘01’ as long the ReasonForDelay column of the CustomDocumentCalMHSADMCODSOutpatientTADT record have value that is not blank or NULL. If the value is blank or NULL, then display ‘02’
  • Regarding the “ReasonForDeplay” data that is returned, the store procedure will return data only if the ReasonForDelay column of the CustomDocumentCalMHSADMCODSOutpatientTADT record have value that is not blank or NULL.
  • Regarding the “FollowUpAppt” data that is returned, if the CustomDocumentCalMHSADMCODSOutpatientTADT‘s IsFollowupApptNotOffered is equal to ‘Y’ then display ‘01’. Else display ‘02’
  • Regarding the “FirstFollowupApptOfferedData” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’.
  • Regarding the ‘FirstFollowupApptRenderedDate’ data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is display data.
  • Regarding the “FollowupApptWaitTimeExt” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is displaying data. Regarding the displayed data itself, if the IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSADMCODSOutpatientTADT record is equal to ‘Y’, then display ‘01’. If IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSADMCODSOutpatientTADT record is equal to ‘N’, then display ‘02’.
  • Regarding the “ReferredToOutOfNetworkProvider” data that is returned, if the CustomDocumentCalMHSADMCODSOutpatientTADT record’s ReferredToOutOfNetworkProvider column is equal to ‘Y’ then display ’01’. If the column value is any other value (NULL, ‘N’, etc…) then display ‘02’
  • Regarding the “ClosureReason” data, if the CustomDocumentCalMHSADMCODSOutpatientTADT record’s ClosureDate column is not NULL/Blank then display data. Else it will display NULL/Blank
  • Regarding the “DescriptionOfFactsCircumstance” data that is returned, the logic is as followed for the string is that display:
    • If CustomDocumentCalMHSADMCODSOutpatientTADT’s ReasonForDelay columns is equal to the globalcodeid of “Other”, then add the string “Reason for Delay: Other — ” with OtherReasonForDelay value onto the displayed string.
    • If CustomDocumentCalMHSADMCODSOutpatientTADT’s ReferredOutOfNetworkProviderDetails columns is not NULL or blank, then add the string “Referred to Out-of-Network Provider: Details — ” with ReferredOutOfNetworkProviderDetails value onto the displayed string.
    • If CustomDocumentCalMHSADMCODSOutpatientTADT’s ClosureReason columns is equal to the globalcodeid of “Other”, then add the string “Closure Reason: Other — ” with OtherClosureReason value onto the displayed string.

·       Regarding the “CIN” data that is returned, the store procedure will display the MAX (biggest) InsuredId columns of all non-soft deleted, CoveragePlanId = 2 ClientCoveragePlans records that are associated to the client that the CustomDocumentCalMHSADMCODSOutpatientTADT record is associated to.

StateOutpatient

DMC-SP Outpatient Timeliness Record (Client)

Y

This dataset calls for a stored procedure labeled “csp_RDLCalMHSATADTDMCODSStateOPReport”. In the stored procedure, it pulls in the following parameters:

  • StartDate
  • EndDate

The stored procedure is designed to return data base on the following criterias:

·       Only pull the DMC State Plan Outpatient timeliness document data where the document’s status is equal to 22 (Signed status)

  • Only pull the DMC State Plan Outpatient timeliness document data where the timeliness’s CustomDocumentCalMHSADMCStateOutpatientTADT record is not soft deleted.
  • Only pull the DMC State Plan Outpatient timeliness document data where the associated client have a CIN number. More information regarding the logic on how the report pull this CIN is down below
  • Only pull the DMC State Plan Outpatient timeliness document data where the Date First Contact to Request Services date is within the date range setup by the Start and End date parameters.

Things to note with the stored procedure:

  • Regarding the “WithdrawalMangement” data that is returned, it will only show ‘01’ if the WereWithdrawalServicesProvided column of the CustomDocumentCalMHSADMCStateOutpatientTADT record is equal ‘Y’. Else will display ‘02’.
  • Regarding the “IsUrgent” data that is returned, it will only show ‘01’ as long the IsUrgent column from the CustomDocumentCalMHSADMCStateOutpatientTADT record is equal to ‘Y’. If the value is any other value (i.e. ‘N’, NULL, Blank, etc…) then it would show ‘02’
  • Regarding the “HoursElapsed” data that is returned, as long the IsUrgent column from the CustomDocumentCalMHSADMCStateOutpatientTADT record is equal to ‘Y’ the store procedure will display the hour differences from the DateFirstContactToReqServices and FirstServiceApptOfferedDate columns of the CustomDocumentCalMHSADMCStateOutpatientTADT record. If the IsUrgent column is not equal ‘Y’, then the store procedure will display NULL/blank
  • Regarding the “PriorAuthorizationRequired” data that is returned, if the IsUrgent and PriorAuthorizationRequired column from the CustomDocumentCalMHSADMCStateOutpatientTADT record is both equal to ‘Y’ then the store procedure will display ‘01’. If the PriorAuthorizationRequired column from the CustomDocumentCalMHSADMCStateOutpatientTADT record is NULL or not equal to ‘Y’ then the store procedure will display ‘02’.
  • Regarding the “WaitList” data that is returned, the store procedure will display ‘01’ as long the ReasonForDelay column of the CustomDocumentCalMHSADMCStateOutpatientTADT record have value that is not blank or NULL. If the value is blank or NULL, then display ‘02’
  • Regarding the “ReasonForDeplay” data that is returned, the store procedure will return data only if the ReasonForDelay column of the CustomDocumentCalMHSADMCStateOutpatientTADT record have value that is not blank or NULL.
  • Regarding the “FollowUpAppt” data that is returned, if the CustomDocumentCalMHSADMCStateOutpatientTADT‘s IsFollowupApptNotOffered is equal to ‘Y’ then display ‘01’. Else display ‘02’
  • Regarding the “FirstFollowupApptOfferedData” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’.
  • Regarding the ‘FirstFollowupApptRenderedDate’ data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is display data.
  • Regarding the “FollowupApptWaitTimeExt” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is displaying data. Regarding the displayed data itself, if the IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSADMCStateOutpatientTADT record is equal to ‘Y’, then display ‘01’. If IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSADMCStateOutpatientTADT record is equal to ‘N’, then display ‘02’.
  • Regarding the “ClosureReason” data, if the CustomDocumentCalMHSADMCStateOutpatientTADT record’s ClosureDate column is not NULL/Blank then display data. Else it will display NULL/Blank
  • Regarding the “DescriptionOfFactsCircumstance” data that is returned, the logic is as followed for the string is that display:
    • If CustomDocumentCalMHSADMCStateOutpatientTADT’s ReasonForDelay columns is equal to the globalcodeid of “Other”, then add the string “Reason for Delay: Other — ” with OtherReasonForDelay value onto the displayed string.
    • If CustomDocumentCalMHSADMCStateOutpatientTADT’s ReferredOutOfNetworkProviderDetails columns is not NULL or blank, then add the string “Referred to Out-of-Network Provider: Details — ” with ReferredOutOfNetworkProviderDetails value onto the displayed string.
    • If CustomDocumentCalMHSADMCStateOutpatientTADT’s ClosureReason columns is equal to the globalcodeid of “Other”, then add the string “Closure Reason: Other — ” with OtherClosureReason value onto the displayed string.

·       Regarding the “CIN” data that is returned, the store procedure will display the MAX (biggest) InsuredId columns of all non-soft deleted, CoveragePlanId = 2 ClientCoveragePlans records that are associated to the client that the CustomDocumentCalMHSADMCStateOutpatientTADT record is associated to.

StateNarcotic

DMC-SP Opioid Timeliness Record (Client)

Y

This dataset calls for a stored procedure labeled “csp_RDLCalMHSATADTDMCStateOpioidReport”. In the stored procedure, it pulls in the following parameters:

  • StartDate
  • EndDate

The stored procedure is designed to return data base on the following criterias:

·       Only pull the DMC State Plan Opioid timeliness document data where the document’s status is equal to 22 (Signed status)

  • Only pull the DMC State Plan Opioid timeliness document data where the timeliness’s CustomDocumentCalMHSADMCStateNarcoticTxTADT record is not soft deleted.
  • Only pull the DMC State Plan Opioid timeliness document data where the associated client have a CIN number. More information regarding the logic on how the report pull this CIN is down below
  • Only pull the DMC State Plan Opioid timeliness document data where the Date First Contact to Request Services date is within the date range setup by the Start and End date parameters.

Things to note with the stored procedure:

  • Regarding the “IsUrgent” data that is returned, it will only show ‘01’ as long the IsUrgent column from the CustomDocumentCalMHSADMCStateNarcoticTxTADT record is equal to ‘Y’. If the value is any other value (i.e. ‘N’, NULL, Blank, etc…) then it would show ‘02’
  • Regarding the “HoursElapsed” data that is returned, as long the IsUrgent column from the CustomDocumentCalMHSADMCStateNarcoticTxTADT record is equal to ‘Y’ the store procedure will display the hour differences from the DateFirstContactToReqServices and FirstServiceApptOfferedDate columns of the CustomDocumentCalMHSADMCStateNarcoticTxTADT record. If the IsUrgent column is not equal ‘Y’, then the store procedure will display NULL/blank
  • Regarding the “PriorAuthorizationRequired” data that is returned, if the IsUrgent and PriorAuthorizationRequired column from the CustomDocumentCalMHSADMCStateNarcoticTxTADT record is both equal to ‘Y’ then the store procedure will display ‘01’. If the PriorAuthorizationRequired column from the CustomDocumentCalMHSADMCStateNarcoticTxTADT record is NULL or not equal to ‘Y’ then the store procedure will display ‘02’.
  • Regarding the “WaitList” data that is returned, the store procedure will display ‘01’ as long the ReasonForDelay column of the CustomDocumentCalMHSADMCStateNarcoticTxTADT record have value that is not blank or NULL. If the value is blank or NULL, then display ‘02’
  • Regarding the “ReasonForDeplay” data that is returned, the store procedure will return data only if the ReasonForDelay column of the CustomDocumentCalMHSADMCStateNarcoticTxTADT record have value that is not blank or NULL.
  • Regarding the “FollowUpAppt” data that is returned, if the CustomDocumentCalMHSADMCStateNarcoticTxTADT‘s IsFollowupApptNotOffered is equal to ‘Y’ then display ‘01’. Else display ‘02’
  • Regarding the “FirstFollowupApptOfferedData” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’.
  • Regarding the ‘FirstFollowupApptRenderedDate’ data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is display data.
  • Regarding the “FollowupApptWaitTimeExt” data that is returned, the store procedure will return data only if the FollowUpAppt data is displaying ‘01’ and “FirstFollowupApptOfferedData” is displaying data. Regarding the displayed data itself, if the IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSADMCStateNarcoticTxTADT record is equal to ‘Y’, then display ‘01’. If IsExtendedWaitAppropriateDocumented column of the CustomDocumentCalMHSADMCStateNarcoticTxTADT record is equal to ‘N’, then display ‘02’.
  • Regarding the “ClosureReason” data, if the CustomDocumentCalMHSADMCStateNarcoticTxTADT record’s ClosureDate column is not NULL/Blank then display data. Else it will display NULL/Blank
  • Regarding the “DescriptionOfFactsCircumstance” data that is returned, the logic is as followed for the string is that display:
    • If CustomDocumentCalMHSADMCStateNarcoticTxTADT’s ReasonForDelay columns is equal to the globalcodeid of “Other”, then add the string “Reason for Delay: Other — ” with OtherReasonForDelay value onto the displayed string.
    • If CustomDocumentCalMHSADMCStateNarcoticTxTADT’s ReferredOutOfNetworkProviderDetails columns is not NULL or blank, then add the string “Referred to Out-of-Network Provider: Details — ” with ReferredOutOfNetworkProviderDetails value onto the displayed string.
    • If CustomDocumentCalMHSADMCStateNarcoticTxTADT’s ClosureReason columns is equal to the globalcodeid of “Other”, then add the string “Closure Reason: Other — ” with OtherClosureReason value onto the displayed string.

·       Regarding the “CIN” data that is returned, the store procedure will display the MAX (biggest) InsuredId columns of all non-soft deleted, CoveragePlanId = 2 ClientCoveragePlans records that are associated to the client that the CustomDocumentCalMHSADMCStateNarcoticTxTADT record is associated to.

 

 

 

Default User Roles

 

 

 

CalMHSA SysAdmin

County Affiliate SysAdmin

 

  • Last updated: March 9, 2026