(Select
        hec_act_performedactions.IfPerfomed_DateOfAction As TreatmentDate,
        hec_act_performedactions.Patient_RefID as PatientID,
        0 as IsOp,
        0 as IsOpPerformed
      From
        hec_act_performedactions Inner Join
        hec_act_performedaction_diagnosisupdates
          On hec_act_performedactions.HEC_ACT_PerformedActionID = hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_RefID And
          hec_act_performedaction_diagnosisupdates.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
          hec_act_performedaction_diagnosisupdates.IsDeleted = 0 Inner Join
        hec_act_performedaction_diagnosisupdate_localizations
          On hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_DiagnosisUpdateID =
          hec_act_performedaction_diagnosisupdate_localizations.HEX_EXC_Action_DiagnosisUpdate_RefID And
    	    hec_act_performedaction_diagnosisupdate_localizations.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
    	    hec_act_performedaction_diagnosisupdate_localizations.IsDeleted = 0 Inner Join
        hec_act_performedaction_2_actiontype
          On hec_act_performedactions.HEC_ACT_PerformedActionID = hec_act_performedaction_2_actiontype.HEC_ACT_PerformedAction_RefID And
          hec_act_performedaction_2_actiontype.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
          hec_act_performedaction_2_actiontype.IsDeleted = 0 Inner Join
        hec_act_actiontype
          On hec_act_performedaction_2_actiontype.HEC_ACT_ActionType_RefID = hec_act_actiontype.HEC_ACT_ActionTypeID And
    	    hec_act_actiontype.GlobalPropertyMatchingID = 'mm.docconect.doc.app.performed.action.oct' And
    	    hec_act_actiontype.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
    	    hec_act_actiontype.IsDeleted = 0
      Where
      hec_act_performedactions.Patient_RefID = x'e6600d3047d50f42a1aa20307795adf9' and
      hec_act_performedaction_diagnosisupdate_localizations.IM_PotentialDiagnosisLocalization_Code = 'R' And
        hec_act_performedactions.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
        hec_act_performedactions.IsDeleted = 0
       Order By
        TreatmentDate)
      union All
      (Select
          hec_act_plannedactions.PlannedFor_Date as TreatmentDate,
          hec_act_plannedactions.Patient_RefID as PatientID,
          1 As IsOp,
          hec_act_plannedactions.IsPerformed as IsOpPerformed
        From
          hec_cas_case_relevantperformedactions Inner Join
          hec_act_performedaction_diagnosisupdates
            On hec_cas_case_relevantperformedactions.PerformedAction_RefID = hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_RefID And
            hec_act_performedaction_diagnosisupdates.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
            hec_act_performedaction_diagnosisupdates.IsDeleted = 0 Inner Join
          hec_act_performedaction_diagnosisupdate_localizations
            On hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_DiagnosisUpdateID =
            hec_act_performedaction_diagnosisupdate_localizations.HEX_EXC_Action_DiagnosisUpdate_RefID And
            hec_act_performedaction_diagnosisupdate_localizations.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
            hec_act_performedaction_diagnosisupdate_localizations.IsDeleted = 0 Inner Join
          hec_act_plannedactions
            On hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_RefID = hec_act_plannedactions.IfPlannedFollowup_PreviousAction_RefID And
            hec_act_plannedactions.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
            hec_act_plannedactions.IsDeleted = 0
        Where
      hec_act_plannedactions.Patient_RefID = x'e6600d3047d50f42a1aa20307795adf9' and
      hec_act_performedaction_diagnosisupdate_localizations.IM_PotentialDiagnosisLocalization_Code = 'R' And
	        hec_cas_case_relevantperformedactions.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' And
	        hec_cas_case_relevantperformedactions.IsDeleted = 0
        Order By
          TreatmentDate)