InterpretationdatabasexbK/KMZxoqTbE2gAdECzu40MaYPLETEBRXuhCOqIbZPZVNsNY0vC7PFJaPTOGGkP39JxpcZ88+zMS0ncSwCgu4J4kQtJdpmNzyjl8fk99hf0spul2FKi3XxryEzz2Os/gWrR401by9ltFX340+wl4+AeceLNe5NZ6ihldNPY6I/j1HENRBDDvE9NOQB8bbmqxRa7bMpO0gXbeGhczyXpm9zgac/GENhI7GuhzHH0rKqwdpmlTUt6dXlYVaHhRGS/4jRDAskWo5V5ADmAxICsY/HgZWvGWUsFwE39hEdxon6NyIk=databaseremwebremwebFonteCD_AVISO_CIRURGIA,System.DoubleCD_CONVENIO,System.DoubleCD_PACIENTE,System.DoubleDATA,System.StringDS_CIRURGIA,System.StringLATERALIDADE,System.StringNM_CONVENIO,System.StringNM_PACIENTE,System.StringNM_PRESTADOR,System.String300databaseFontedatabaseDATA_FIM,DATA_x002e_To,4,0DATA_INI,DATA_x002e_From,4,0SELECT /*+rule*/ AV.CD_AVISO_CIRURGIA , to_char(AV.DT_REALIZACAO, 'dd/MM/yyyy') DATA , AV.CD_PACIENTE , AV.NM_PACIENTE , CA.CD_CONVENIO , CONV.NM_CONVENIO , CIR.DS_CIRURGIA , P.NM_PRESTADOR , CASE CA.DS_LATERALIDADE WHEN 'E' THEN 'ESQUERDA' WHEN 'D' THEN 'DIREITA' WHEN 'B' THEN 'BILATERAL' WHEN 'N' THEN 'INDIFERENTE' ELSE 'INDIFERENTE' END LATERALIDADE FROM DBAMV.AVISO_CIRURGIA AV INNER JOIN DBAMV.PRESTADOR_AVISO PA ON AV.CD_AVISO_CIRURGIA = PA.CD_AVISO_CIRURGIA INNER JOIN DBAMV.CIRURGIA_AVISO CA ON AV.CD_AVISO_CIRURGIA = CA.CD_AVISO_CIRURGIA INNER JOIN DBAMV.ATENDIME ATE ON ATE.CD_ATENDIMENTO = AV.CD_ATENDIMENTO INNER JOIN DBAMV.CONVENIO CONV ON CA.CD_CONVENIO = CONV.CD_CONVENIO INNER JOIN DBAMV.CON_PLA PLA ON PLA.CD_CONVENIO = CONV.CD_CONVENIO AND PLA.CD_CON_PLA =ATE.CD_CON_PLA INNER JOIN DBAMV.CIRURGIA CIR ON CA.CD_CIRURGIA = CIR.CD_CIRURGIA AND PA.CD_CIRURGIA = CA.CD_CIRURGIA INNER JOIN DBAMV.PRESTADOR P ON PA.CD_PRESTADOR = P.CD_PRESTADOR WHERE PA.SN_PRINCIPAL = 'S' AND AV.TP_SITUACAO = 'R' AND PA.CD_PRESTADOR IN ({V_Prestador_aux}) AND CA.CD_CONVENIO = {V_Convenio} AND PLA.CD_CON_PLA = {V_Plano} AND AV.dt_prev_inter BETWEEN @DATA_INI AND @DATA_FIM ORDER BY AV.DT_PREV_INTER TableConveniosCD_CONVENIO,System.Int32CD_CON_PLA,System.Int32DES_CON_PLA,System.StringNM_CONVENIO,System.String30databaseConveniosdatabaseSELECT CONV.CD_CONVENIO , CP.CD_CON_PLA , CONV.NM_CONVENIO , CP.DS_CON_PLA DES_CON_PLA FROM CONVENIO CONV INNER JOIN CON_PLA CP ON CONV.CD_CONVENIO = CP.CD_CONVENIOTableCon_PlaCD_CON_PLA,System.DoubleDES_CON_PLA,System.String30databaseCon_PladatabaseSELECT CP.CD_CON_PLA , CONV.NM_CONVENIO || ' / ' || CP.DS_CON_PLA DES_CON_PLA FROM CONVENIO CONV INNER JOIN CON_PLA CP ON CONV.CD_CONVENIO = CP.CD_CONVENIO ORDER BY CONV.CD_CONVENIO, CP.DS_CON_PLA TableCirurgiaCD_CIRURGIA,System.DoubleDS_CIRURGIA,System.String30databaseCirurgiadatabaseselect cd_cirurgia, ds_cirurgia from CIRURGIA WHERE SN_ATIVO = 'S' order by DS_CIRURGIATablePrestadorCD_PRESTADOR,System.DoubleNM_PRESTADOR,System.String30databasePrestadordatabaseSELECT /*+rule*/ cd_prestador , nm_prestador FROM prestador ORDER BY nm_prestadorTable,V_Convenio,V_Convenio,,System.Int32,_x0030_,False,False,True,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_ItemsInitializationType_x003e_Columns_x003c__x002f_ItemsInitializationType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_KeysColumn_x003e_Convenios_x002e_CD_CONVENIO_x003c__x002f_KeysColumn_x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesColumn_x003e_Convenios_x002e_NM_CONVENIO_x003c__x002f_ValuesColumn_x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariable,V_Plano,V_Plano,,System.Int32,_x0030_,False,False,True,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_True_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x003e_Convenios_x002e_CD_CONVENIO_x003c__x002f_BindingValuesColumn_x003e__x003c_BindingVariable_x003e__x002c_V_Convenio_x002c_V_Convenio_x002c__x002c_System_x002e_Int32_x002c__x0030__x002c_False_x002c_False_x002c_True_x002c_False_x002c__x0026_lt_x003b__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x003f__x0026_gt_x003b__x0026_lt_x003b_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x0026_gt_x003b__x0026_lt_x003b_BindingValue_x0026_gt_x003b_False_x0026_lt_x003b__x002f_BindingValue_x0026_gt_x003b__x0026_lt_x003b_BindingValuesColumn_x002f__x0026_gt_x003b__x0026_lt_x003b_DateTimeType_x0026_gt_x003b_DateAndTime_x0026_lt_x003b__x002f_DateTimeType_x0026_gt_x003b__x0026_lt_x003b_ItemsInitializationType_x0026_gt_x003b_Columns_x0026_lt_x003b__x002f_ItemsInitializationType_x0026_gt_x003b__x0026_lt_x003b_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x0026_gt_x003b__x0026_lt_x003b_KeysColumn_x0026_gt_x003b_Convenios_x002e_CD_CONVENIO_x0026_lt_x003b__x002f_KeysColumn_x0026_gt_x003b__x0026_lt_x003b_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x0026_gt_x003b__x0026_lt_x003b_ValuesColumn_x0026_gt_x003b_Convenios_x002e_NM_CONVENIO_x0026_lt_x003b__x002f_ValuesColumn_x0026_gt_x003b__x0026_lt_x003b__x002f_StiSerializer_x0026_gt_x003b__x002c__x002c_False_x002c_FromVariable_x003c__x002f_BindingVariable_x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_ItemsInitializationType_x003e_Columns_x003c__x002f_ItemsInitializationType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_KeysColumn_x003e_Convenios_x002e_CD_CON_PLA_x003c__x002f_KeysColumn_x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesColumn_x003e_Convenios_x002e_DES_CON_PLA_x003c__x002f_ValuesColumn_x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariable,DATA,DATA,,Stimulsoft.Report.DateTimeRange,DateTime_x002c_01_x002f_01_x002f_2020_x0020_12_x003a_00_x003a_00_x0020_AM_x002c_12_x002f_31_x002f_2021_x0020_11_x003a_59_x003a_59_x0020_PM,False,False,True,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariable,V_Prestador_aux,V_Prestador_aux,,System.String,_x0028_V_Prestador_x002e_Count_x0028__x0029__x0020__x003d__x003d__x0020_0_x0029__x0020__x003f__x0020__x0022_0_x0022__x0020__x003a__x0020_V_Prestador_x002e_ToQueryString_x0028__x0022__x0022__x0029_,True,True,False,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariable,V_Prestador,V_Prestador,,Stimulsoft.Report.DoubleList,,False,False,True,False,_x003c__x003f_xml_x0020_version_x003d__x0022_1_x002e_0_x0022__x0020_encoding_x003d__x0022_UTF_x002d_8_x0022__x003f__x003e__x003c_StiSerializer_x0020_application_x003d__x0022_State_x0022__x0020_type_x003d__x0022_Java_x0022__x0020_version_x003d__x0022_1_x002e_2_x0022__x003e__x003c_AllowUserValues_x003e_False_x003c__x002f_AllowUserValues_x003e__x003c_BindingValue_x003e_False_x003c__x002f_BindingValue_x003e__x003c_BindingValuesColumn_x002f__x003e__x003c_DateTimeType_x003e_DateAndTime_x003c__x002f_DateTimeType_x003e__x003c_ItemsInitializationType_x003e_Columns_x003c__x002f_ItemsInitializationType_x003e__x003c_Keys_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_KeysColumn_x003e_Prestador_x002e_CD_PRESTADOR_x003c__x002f_KeysColumn_x003e__x003c_Values_x0020_count_x003d__x0022_0_x0022__x0020_isList_x003d__x0022_true_x0022__x002f__x003e__x003c_ValuesColumn_x003e_Prestador_x002e_NM_PRESTADOR_x003c__x002f_ValuesColumn_x003e__x003c__x002f_StiSerializer_x003e_,,False,FromVariableEngineV2FalseFalsereportId,_x0031_54None;Black;2.0;Solid;False;4.0;BlackTransparentTransparent0,0.4,19,0.8TransparentTrue0,0,6.4,0.8Arial,80,0,0,0DataFonte_NM_CONVENIO{Fonte.NM_CONVENIO}BlackHotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,CenterTransparentTrue6.4,0,6.4,0.8Arial,80,0,0,0DataFonte_CD_PACIENTE{Fonte.CD_PACIENTE}BlackHotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,CenterTransparentTrue12.8,0,6.2,0.8Arial,80,0,0,0DataFonte_NM_PACIENTE{Fonte.NM_PACIENTE}BlackHotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,CenterFonteNoneDataFonte1183aa0e30cf4e8a8c0ae3dc4189b51c1,1,1,1FalsePage229.721Arial,100[50:0:0:0]System.DllSystem.Drawing.DllSystem.Windows.Forms.DllSystem.Data.DllSystem.Xml.DllStimulsoft.Controls.DllStimulsoft.Base.DllStimulsoft.Report.Dll0Relatório - Mapa Cirúrgico06/22/2021 06:03:08 PM07/25/2019 09:14:27 AMcirurgias atualizadas 2 com listb7dd82a4f32048fdb5e6b60185433c81Relatório - Mapa CirúrgicoCentimeters2018.2.4-SNAPSHOT from 12 July 2018, JavaTrueCSharp