Standard Jet DBnb` Ugr@?~1y0̝cßFN `7ߜM(-`{6~߱oCD43y[.|*|hOf_Љ$g'DeFx -bT4.0   2 `  @?O?r?@???????????????????` ? ?? YS  Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OYS  Y Y Y  Y 2pACMFInheritableObjectIdSIDun de gsYObjectId Y S  7Y  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order\  Y"ObjectIdAttribute   -YHnS  Y Y Y  Y  Y  Y  Y  Y &ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationshipt MexayIo ecmsCcs blYYYszObject$szReferencedObjectszRelationship( e Q # T@?Z@ @ D )$I$$$$ cbPH <``   @ @ @`dOdb^YbQSdi`k%+kh+OifmMJLU++Ykd^JmQOvQk+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MqJ+koiU')+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+Y``obdiu+Wdkf57+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+kmJmokfidM+WdkfDG+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+UQbOQi+koiUQV+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MWS+koiU` j+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+UQbOQi+koiUt z+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+fqO+Wdkf +kh+OifmMJLU++Ykd^JmQOvQkkoL<+kh+OifmMJLU+MqJ+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL<+kh+OifmMJLU+kmJmokfidM+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoLmQkm+kh+OifmMJLU+WvfQimQbkYdb+Wdkf+kh+OifmMJLU++ko``JivYkdvQkkoiUQdb+kh+OMWY^OF<6hivMJLUko``JivJMoYmvkoiUhivMJLUko``JivMfLM`LWdkfifmhivMJLUko``JivQSWdkfifmhivMJLUko``JivfiYdifMYkoiUifm0 6 `dO+LJkQMdbbQMmYdbk686 `dO+LJkQOJmJOYMm686`dO+LJkQOJmQ686`dO+LJkQOYkf^JvM^dbQ686`dO+LJkQOiYqQk686`dO+LJkQQiidi686`dO+LJkQSY^Qk686`dO+LJkQSdi`k686`dO+LJkQ`dOo^Qk686`dO+LJkQbQsk686`dO+LJkQbo`LQik686`dO+LJkQdSb686`dO+LJkQhoQiYQk686`dO+LJkQiQMdiOkQmk686`dO+LJkQiQfdimk686`dO+LJkQkdim686`dO+LJkQkmiYbUk686`dO+LJkQmJL^Qk686`dO+LJkQmY`Q686`dO+UQd686 `dO+fQikdb686!`dO+fWdbQ686"`dOJff#`dOMMdif$`dOdb^YbQSdi`k%`dOkoiUQdb&ifm+LJkQOJmJOYMm686'ifm+LJkQOYkf^JvM^dbQ686(ifm+UQdMYmvLvMYmv686)ifm+UQdMYmvLvMdobmiv686*ifm+UQdMdobmiv686ifm+UQdMdobmvLvMdobmv686ifm+UQdMdobmvLvkmJmQ686ifm+UQdkmJmQLvMdobmiv686ifm+UQdkmJmQLvkmJmQ686ifmMJLU++ko``Jiv8ifmMJLU++ko``Jiv:ifmMJLU++ko``Jiv<ifmMJLU++ko``JivYkdbdkoiUQdbifmMJLU++ko``JivYkdvQkkoiUQdb ifmMJLU++ko``JivkoL: ifmMJLUkmJmok ifmMJLUkmJmokkoiUQdb ifmMQimYSYMJmYdbSY^^Yb ifmMQimYSYMJmYdbSY^^YbWdkfYmJ^ifmMQimYSYMJmYdbSY^^YbkoiUQdbifmMQimYSYMJmYdbkoiUQdbfQiYdOifm`YkkYbU`ibifmkoiUOQmJY^ifmkoiUOQmJY^J^^ifmkoiUOQmJY^fJmYQbmifmkoiUOQmJY^koiUQdbifmkoiUQdbifmkoiUQiYQkLvkoiUQdbifmkoiUQiYQkLvkoiUQdbJ^^OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`QufdimQik+kh+MMLdkQ^QMmMddiOYbJmdi+kh+MSi`QufdimQik+kh+MMLdkQ^QMmWdkfYmJ^+kh+MSi`QufdimQik+kh+MMLdkQ^QMmYO+kh+MSi`Y`fdimWYkmdiv+kh+M^Lu^Ykm+kh+MSi`koiUQivd^O+kh+MMLdkQ^QMmWdkfYmJ^+kh+MSi`koiUmJL^QqYQs+kh+MSi`koiUmJL^QqYQskoL+kh+OifmMJLU++Ykd^JmQObd+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU++Ykd^JmQObdkoL+kh+OifmMJLU++ko``Jiv8 `kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO Q           !"#$%&' (!)"*#$%&'()*+, - . / 0 123456789:;<=>?@ABC D!E"F#G$H%I&J'K(L)M*NOPQRSTUVW X Y Z [ \]^_`abcdefghijklmn o!pqrstuvwxy z { | } ~'''''''''' ' ' ' ' ''''''''''5555555555 5 5 5 5 5555555555DDDDDDDDDD D D D D DDDDDDDDDDQQQQQQQQQQ Q Q Q Q QQQQQQQQQQ`````````` ` ` ` ` `````````tttttttttt  t  t  t  t  ttttttttt  ! " # $%&'()*+,-./01234567 8 9 : ; <=>?@ABCDEFGHIJKLMN O P Q R STUVWXYZ[\]^_`abcde f g h i jklmnopqrstuvwxyz{| } ~        !"#$%   M va  !@@!V@@ @ q @K- x  3F4G $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP        !!!" "!""###$#%$&$'$(%)%*%+&,&-&.'/'0'1(2(3(4)5)6)7*8*9*:+;+<+=,>,?,@-A-B-C.D.E.F/G/H/I0J0011122233 3 4 4 4 555666777888999:::; ;!;"<#<$<%=&='=(>)>*>+?,?-?.@/@0@1A2A3A4B5B6B7C8C9C:D;D<D=E>E?E@FAFBFCGDGEGFHGHHHIIJIIJJJKKKLL L M M M NNNOOOPPPQQQRRRSSST T!T"U#U$U%V&V'V(W)W*W+X,X-X.Y/Y0Y1Z2Z3Z4[5[6[7\8\9\:];]<]=^>^?^@_A_B_C`D`E`FaGaHaIbJbbcccdddee e f f f ggghhhiiijjjkkklllm m!m"n#n$n%o&o'o(p)p*p+q,q-q.r/r0r1s2s3s4t5t6t7u8u9u:v;v<v=w>w?w@xAxBxCyDyEyFzGzHzI{J{{|||}}}~~ ~     !"#$%&'()*+,-./0123456789:;<=>?@ABCDE  !"#O  g $@ @( $"D"" D"""% tUj֥uڭ\NW5WBHD!QH$""@PA!! HHBRITLhk 0 @ @ @ @ @ @}C (!.,13H9@BH0KYS_5[qrx;u *'8CFT-p~711 0 0  + A :   8  @ ?" $&&'=)-,-3.619 35@739F;=L>5@RIBZC2E_GQbAS-TcHVWdOYZe [3\'l( l) l* l+ l, l-l.l/l0l1l2l3l4l5l%mmmmmmmnn n!n"n#n$n%no&o(o)o*o+o,o'p-p/p0p1p2p3p.q4q6q7q8q9q:q;q5rr?r@rArBrCr=sDsFsGsHsIsJsEtttttttuu u u u u uuvvvvvvvvwwwwwwwxx x!x"x#x$xy%y'y(y)y*y+y,y&z-z/z0z1z2z3z.{4{6{7{8{9{:{;{5|<|>|?|@|A|B|=}Cv1@   +d S N [  v rK K u H:HE^|!B;Yy"R"%U@%U@frm_PhoneHelp010`X~@NNNBBBBBBB@ @!;%U@;%U@frm_PersonNameHelp010`X~@XXXLLLLLLLJ @ +{%U@+{%U@frm_GEOStateList010`X~@TTTHHHHHHHF @%U@%U@frm_GEOStateEdit010`X~@TTTHHHHHHHF @%U@%U@frm_GEOStateAdd010`X~@RRRFFFFFFFD @%Drr%U@rr%U@frm_GEOCountyEdit010`X~@VVVJJJJJJJH @ѱ%U@ѱ%U@frm_GEOCountyAdd010`X~@TTTHHHHHHHF @1%U@1%U@frm_GEOCountryList010`X~@XXXLLLLLLLJ @Y*%U@Y*%U@frm_GEOCountryEdit010`X~@XXXLLLLLLLJ @i%U@i%U@frm_GEOCountryAdd010`X~@VVVJJJJJJJH @%U@%U@frm_GEOCityList010`X~@RRRFFFFFFFD @x%U@x%U@frm_GEOCityEdit010`X~@ RRRFFFFFFFD @$Da%U@a%U@frm_BaseUserOptions010`X~@ ZZZNNNNNNNL @_%U@_%U@frm_BaseSystemStatus010`X~@ \\\PPPPPPPN @ۼ&@ۼ&@frm_BaseStandardReports`X~@ \\\PPPPPPPN @GX%U@GX%U@frm_BaseSplash`X~@JJJ>>>>>>>< @e/6T_@e/6T_@frm_BaseShowCredits010`X~@ZZZNNNNNNNL @׍%U@׍%U@frm_BaseSetup010`X~@NNNBBBBBBB@ @#D O%U@O%U@frm_BaseLocalFacts010`X~@XXXLLLLLLLJ @ Y%U@Y%U@frm_BaseDisplayClone010`X~@\\\PPPPPPPN @ +%U@+%U@frm_BaseDateHelp010`X~@TTTHHHHHHHF @ %U@%U@~TMPCLP626991`X~@HHH<<<<<<<: @ @%U@@%U@~TMPCLP592221`X~@HHH<<<<<<<: @ TQmfZ@cq@UserDefined`X@aDDD88888886 @  U@lfZ@SummaryInfo`X@DDD88888886 @"D U@ U@SysRel`X..........,  U@ U@Scripts`X0000000000.  U@ U@Reports`X0000000000.  U@ U@Modules`X0000000000.  U@ U@Forms`X,,,,,,,,,,* ; U@; U@DataAccessPages`X@@@@@@@@@@>  U@ U@MSysRelationshipsaZDDDDDDDDDDB  U@ U@MSysQueriesaZ88888888886  U@ U@MSysACEsaZ22222222220  U@]2?%4]@MSysObjectsaZ@DDD88888886 @ U@B{q@MSysDb`X!@:::......., @ U@ U@RelationshipsaZ<<<<<<<<<<:  U@ U@DatabasesaZ44444444442  U@ U@TablesaZ.........., X+6Nl = o kL F  W 6vO,nk v#95AMR~q@R~q@rpt_GEOCityByCountry010NNNM%U@%U@rpt_GEOCityByCountry010`X@ \\\PPPPPPPN @K䃞%U@䃞%U@rpt_BaseDisplayClone010`X~@\\\PPPPPPPN @JDÝ%U@DÝ%U@rpt_BaseDataDict010`Xj@TTTHHHHHHHF @ICW@CW@modSurgeon`X66666666664 HCW@CW@modOnlineForms`X>>>>>>>>>>< G8@8@modCCORP`X22222222220 FCW@CW@modAPP`X.........., Efҹ%U@fҹ%U@mod_Phone010`X::::::::::8 Dfҹ%U@fҹ%U@mod_Person010`X<<<<<<<<<<: Cfҹ%U@fҹ%U@mod_GEO010`X66666666664 Bfҹ%U@fҹ%U@mod_BaseTime010`X@@@@@@@@@@> Afҹ%U@fҹ%U@mod_BaseTables010`XDDDDDDDDDDB @fҹ%U@fҹ%U@mod_BaseStrings010`XFFFFFFFFFFD ?fҹ%U@fҹ%U@mod_BaseSort010`X@@@@@@@@@@> >fҹ%U@fҹ%U@mod_BaseReports010`XFFFFFFFFFFD =fҹ%U@fҹ%U@mod_BaseRecordsets010`XLLLLLLLLLLJ <fҹ%U@fҹ%U@mod_BaseQueries010`XFFFFFFFFFFD ;fҹ%U@fҹ%U@mod_BaseOFN010`X>>>>>>>>>>< :fҹ%U@fҹ%U@mod_BaseNumbers010`XFFFFFFFFFFD 91u%U@1u%U@mod_BaseNews010`X@@@@@@@@@@> 81u%U@1u%U@mod_BaseModules010`XFFFFFFFFFFD 71u%U@1u%U@mod_BaseForms010`XBBBBBBBBBB@ 61u%U@1u%U@mod_BaseFiles010`XBBBBBBBBBB@ 51u%U@1u%U@mod_BaseError010`XBBBBBBBBBB@ 41u%U@1u%U@mod_BaseDrives010`XDDDDDDDDDDB 31u%U@1u%U@mod_BaseDisplayClone010`XPPPPPPPPPPN 21u%U@1u%U@mod_BaseDate010`X@@@@@@@@@@> 11u%U@1u%U@mod_BaseDataDict010`XHHHHHHHHHHF 01u%U@1u%U@mod_BaseConnections010`XNNNNNNNNNNL /1u%U@1u%U@mod_BaseComputer010`XHHHHHHHHHHF .1u%U@1u%U@mod_Base010`X88888888886 'D,CW@CW@frmTextExport`X@HHH<<<<<<<: @+E)n@E)n@frmTableViewSub`XJILLL@@@@@@@> @*_X@_X@frmTableView`X@FFF:::::::8 @)DCW@DCW@frmSurgeryNew`X~@HHH<<<<<<<: @(z*0K]@z*0K]@frmSurgeryFind`X~@JJJ>>>>>>>< @'r]@r]@frmSurgery`X @BBB66666664 @&D%brCW@brCW@frmSurgeonEdit`X~@dJJJ>>>>>>>< @$ulCW@ulCW@frmSurgeonAdd`X~@dHHH<<<<<<<: @#^BCW@^BCW@frmCCORPFacts`X~@HHH<<<<<<<: @"$ @ f bL j    H!CqE%!E`CAoR~q@R~q@~sq_oooR~q@R~q@~sq_drptCABG__IsolatedNoSurgeo m@ m@~sq_drptCABG__IsolatedNoSurgeon~sq_drptCABG__IsolatedYesSub`X4MR2KeepLocal T @m 4m@ 4m@~sq_drptCABG__IsolatedNo~sq_drptCABG__IsolatedYesSub`X4MR2KeepLocal T @lhW@hW@~sq_cfrmSurgTableView~sq_cfrmSurgTableViewSub`X4MR2KeepLocal T|||||||z @jb[U@b[U@~sq_cfrmImportHistory~sq_clbxList`X4MR2KeepLocal Tdddddddb @iif@if@~sq_cfrmExporters~sq_ccboSelectID`X4MR2KeepLocal Tdddddddb @g[f@[f@~sq_cfrmExporters~sq_ccboSelectCoordinator`X4MR2KeepLocal Tvvvvvvvt @eW@W@rptSurgeriesBySurgeon`X@XXXLLLLLLLJ @d%͕@%͕@rptSurgeon`X@BBB66666664 @c<@<@rptSurgDetailSurgeon`XdYIVVVJJJJJJJH @b@@rptSurgDetailPatient`XVYIVVVJJJJJJJH @a鈍@鈍@rptSurgDetailAll`XVYINNNBBBBBBB@ @`V@V@rptSurgDetail`XVYIHHH<<<<<<<: @^@@rptCertificationSurgeonPeriod`Xx@hhh\\\\\\\Z @]7z@7z@rptCertificationFillInSurgeon`X>@hhh\\\\\\\Z @\#\0Z@#\0Z@rptCertificationFillinHospital`X@jjj^^^^^^^\ @[~w@~w@rptCertificationFillIn`X@ZZZNNNNNNNL @Z1mt@1mt@rptCABGStatusSurgeon`X@VVVJJJJJJJH @Yq@q@rptCABGStatus`X@HHH<<<<<<<: @X{uR@{uR@rptCABG__SummarySub2`XT@VVVJJJJJJJH @WpU@pU@rptCABG__SummaryIsoYesSurgeon`X@hhh\\\\\\\Z @U5@5@rptCABG__Summary3`X~@PPPDDDDDDDB @T-wF@-wF@rptCABG__Summary2`X~@PPPDDDDDDDB @SQZ/@QZ/@rptCABG__Summary1`X~@PPPDDDDDDDB @R%U@%U@rpt_GEOStateByState010`X@ZZZNNNNNNNL @Q>M%U@>M%U@rpt_GEOStateByCountry010`X@^^^RRRRRRRP @P%U@%U@rpt_GEOCountyByState010`X@\\\PPPPPPPN @Oˠ%U@ˠ%U@rpt_GEOCountyByCounty010`X@^^^RRRRRRRP @N\ %U@\ %U@rpt_GEOCountry010`XJ@ PPPDDDDDDDB @#EKQ n P  v X  Z $ ` ) h J  rT"a Q{=T_%m3w8lRtblSurgery.MI_WHEN1 glRtblSurgery.ARR_TYPE2 glRtblSurgery.HEPAFAIL2 glRtblSurgery.IMMUNORX2 glRtblSurgery.CHRLUNGD2 glRtblSurgery.CVAWHEN1 glRtblSurgery.CVD- glRtblSurgery.PVD- glRtblSurgery.Diabetes2 glRtblSurgery.Dialysis2 glRtblSurgery.HTN- glRtblSurgery.Creatinine4 glRtblSurgery.PROC_STATUS5 glRtblSurgery.WT, glRtblSurgery.HT, glRtblSurgery.Race. glRtblSurgery.SEX- glR tblSurgery.AGE- glR tblSurgery.DOB- glR tblSurgery.DStatus1 glR DischargeDate@7++ olR SurgDateDateStrToDate([Surg])D!! olRtblSurgery.PatientMRN4 glRtblSurgery.ISOCABG1 glRSurgFirstLeft([SurgFname],1)D## olRtblSurgery.SurgLname3 glRtblSurgery.SurgLicNum4 glRtblSurgery.SurgeonID3 glRtblSurgery.HospitalID4 glRtblSurgery.SurgeryID3 glRtblSurgery%%% lR lR GkRtblExporters.Hospital4 gkRtblExporters.HospitalID6 gkRtblExporters))) kR kR GjR RecordsDel) gjR RecordsNew) gjR RecordsDiff* gjR RecordsSame* gjRRecordsTotal+ gjR ExportTime) gjREDate"DateStrFormat([ExportDate],True)I ojR ImportTime) gjRIDate"DatestrFormat([ImportDate],True)I ojR HospitalID) gjR ImportID' gjRtblImportHistory111 jR jR Gi RtblExporters.HospitalID6 'iRtblExporters.HospitalID6 giRtblExporters))) iR iR Gh RtblExporters.Hospital4 'hRtblExporters.Hospital4 ghRtblExporters.HospitalID6 ghRtblExporters))) hR hR Gg tblExporters.Coordinator7 'gtblExporters.Coordinator7 ggtblExporters.HospitalID6 ggtblExporters))) g g GLVALx  SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI] AS Surgeon, IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) AS CABGSort, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG FROM tblSurgery WHERE ((([DISCHARGE] & "")<>"")) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI], IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)), IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) HAVING (((IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]))="No")) ORDER BY [SurgLName] & ", " & [SurgFName] & " " & [SurgMI]; ((([__HospitalID] = HospitalID)) AND ([__IsolatedCABG] = IsoCABG)) AND ([__SurgeonID] = SurgeonID)SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI] AS Surgeon, tblSurgery.IsoCABG, Count(tblSurgery.SurgeryID) AS CountOfSurgeryID FROM tblSurgery WHERE ((([DISCHARGE] & "")<>"")) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI], tblSurgery.IsoCABG HAVING (((tblSurgery.IsoCABG)="Yes")) ORDER BY [SurgLName] & ", " & [SurgFName] & " " & [SurgMI]; (([__HospitalID] = HospitalID)) AND ([__SurgeonID] = SurgeonID)SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI] AS Surgeon, IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) AS CABGSort, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG FROM tblSurgery WHERE ((([DISCHARGE] & "")<>"")) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI], IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)), IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) HAVING (((IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]))="No")) ORDER BY [SurgLName] & ", " & [SurgFName] & " " & [SurgMI]; IIf(Len([DISCHARGE] & "")=0,"",DateStrFormat([DISCHARGE] & "",True))KE Y a ! o . r , _ A # K !  uA#g1W99i/wY-K-s@ 'srptCABG__IsolatedYesSub@K? 7s  Gs__txtIsolatedCABG333 Os__txtHospitalID/// Os s GrR@ 'rRrptCABG__IsolatedYesSubH@K? 7r R GrR__txtIsolatedCABG333 OrR__txtHospitalID/// OrR__txtSurgeonID--- OrR rR GqR@ 'qRrptCABG__IsolatedYes@E9 7q R GqR__IsolatedCABG--- OqR__SurgeonID''' OqR__HospitalID))) OqR qR GpR~@ 'pRrptCABG__IsolatedYes_Old@MA 7p R GpR__SurgeonID''' OpR__HospitalID))) OpR pR GoR~@ 'oRrptCABG__IsolatedNoSurgeon@QE 7o R GoR__SurgeonID''' OoR__HospitalID))) OoR oR GnR@ 'nRrptCABG__IsolatedNoSub@I= 7n R GnR__SurgeonID''' OnR__IsolatedCABG--- OnR__HospitalID))) OnR nR GmR~@ 'mRrptCABG__IsolatedNo@C7 7m R GmR__SurgeonID''' OmR__HospitalID))) OmR mR GlR5tblSurgery.ImportStatus6 glR4tblSurgery.DateTimeImport8 glR3tblSurgery.DateTimeChange8 glR2tblSurgery.DateTimeEntered9 glR1tblSurgery.Notes/ glR0tblSurgery.CARDIOPLEG4 glR/tblSurgery.INCISION2 glR.tblSurgery.CONVERSION4 glR-tblSurgery.CPBUSED1 glR,tblSurgery.IMA- glR+tblSurgery.PCI- glR*tblSurgery.P_OPS_NBP3 glR)tblSurgery.P_OPS/ glR(tblSurgery.MITRAL0 glR'tblSurgery.DIS_VESS2 glR&tblSurgery.LMStenPCT3 glR%tblSurgery.EF_Type1 glR$tblSurgery.EF, glR#tblSurgery.NYHA. glR"tblSurgery.CHF- glR!tblSurgery.CCS- glR tblSurgery.ANGINA_TYPE5 glRtblSurgery.CARD_SHK2 g  @ @ @ @@ @@+m`fM^f@H:::8+m`fM^fB:BHH8Si`+LJkQOJmQWQ^f686Si`+LJkQOYkf^JvM^dbQ686Si`+LJkQ^dMJ^SJMmk686Si`+LJkQbQsk686Si`+LJkQkQmof686Si`+LJkQkWdsMiQOYmk686Si`+LJkQkf^JkWSi`+LJkQkmJbOJiOiQfdimkSi`+LJkQkvkmQ`kmJmok686Si`+LJkQokQidfmYdbk686Si`+UQdMYmvJOO686Si`+UQdMYmvQOYm686Si`+UQdMYmv^Ykm686Si`+UQdMdobmivJOO686 Si`+UQdMdobmivQOYm686!Si`+UQdMdobmiv^Ykm686"Si`+UQdMdobmvJOO686#Si`+UQdMdobmvQOYm686$Si`+UQdMdobmv^Ykm686%Si`+UQdkmJmQJOO686&Si`+UQdkmJmQQOYm686'Si`+UQdkmJmQ^Ykm686(Si`+fQikdbbJ`QWQ^f686)Si`+fWdbQWQ^f686*Si`MMdifSJMmkSi`koiUQdbJOOSi`koiUQdbQOYmSi`koiUQdb^YkmSi`koiUQivSi`koiUQivSYbOSi`koiUQivbQsSi`mJL^QqYQsSi`mJL^QqYQskoLSi`mQumQufdim Si`mddkWfO `dO+LJkQ686 `dO+LJkQMd`fomQi686 `dO+LJkQMdbbQMmYdbk686 `dO+LJkQOJmJOYMm686`dO+LJkQOJmQ686`dO+LJkQOYkf^JvM^dbQ686`dO+LJkQOiYqQk686`dO+LJkQQiidi686`dO+LJkQSY^Qk686`dO+LJkQSdi`k686`dO+LJkQ`dOo^Qk686`dO+LJkQbQsk686`dO+LJkQbo`LQik686`dO+LJkQdSb686`dO+LJkQhoQiYQk686`dO+LJkQiQMdiOkQmk686`dO+LJkQiQfdimk686`dO+LJkQkdim686`dO+LJkQkmiYbUk686`dO+LJkQmJL^Qk686`dO+LJkQmY`Q686`dO+UQd686 `dO+fQikdb686!`dO+fWdbQ686"`dOJff#`dOMMdif$`dOdb^YbQSdi`k%`dOkoiUQdb&ifm+LJkQOJmJOYMm686'ifm+LJkQOYkf^JvM^dbQ686(ifm+UQdMYmvLvMYmv686)ifm+UQdMYmvLvMdobmiv686*ifm+UQdMdobmiv686ifm+UQdMdobmvLvMdobmv686ifm+UQdMdobmvLvkmJmQ686ifm+UQdkmJmQLvMdobmiv686ifm+UQdkmJmQLvkmJmQ686ifmMJLU++ko``Jiv8ifmMJLU++ko``Jiv:ifmMJLU++ko``Jiv<ifmMJLU++ko``JivYkdbdkoiUQdbifmMJLU++ko``JivYkdvQkkoiUQdb ifmMJLU++ko``JivkoL: ifmMJLUkmJmok ifmMJLUkmJmokkoiUQdb ifmMQimYSYMJmYdbSY^^Yb ifmMQimYSYMJmYdbSY^^YbWdkfYmJ^ifmMQimYSYMJmYdbSY^^YbkoiUQdbifmMQimYSYMJmYdbkoiUQdbfQiYdOifm`YkkYbU`ibifmkoiUOQmJY^ifmkoiUOQmJY^J^^ifmkoiUOQmJY^fJmYQbmifmkoiUOQmJY^koiUQdbifmkoiUQdbifmkoiUQiYQkLvkoiUQdbifmkoiUQiYQkLvkoiUQdbJ^^OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`QufdimQik+kh+MMLdkQ^QMmMddiOYbJmdi+kh+MSi`QufdimQik+kh+MMLdkQ^QMmWdkfYmJ^+kh+MSi`QufdimQik+kh+MMLdkQ^QMmYO+kh+MSi`Y`fdimWYkmdiv+kh+M^Lu^Ykm+kh+MSi`koiUQivd^O+kh+MMLdkQ^QMmWdkfYmJ^+kh+MSi`koiUmJL^QqYQs+kh+MSi`koiUmJL^QqYQskoL+kh+OifmMJLU++Ykd^JmQObd+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU++Ykd^JmQObdkoL+kh+OifmMJLU++ko``Jiv8 `kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO)@  @    @`dOkoiUQdb&ifm+LJkQOJmJOYMm686'ifm+LJkQOYkf^JvM^dbQ686(ifm+UQdMYmvLvMYmv686)ifm+UQdMYmvLvMdobmiv686*ifm+UQdMdobmiv686ifm+UQdMdobmvLvMdobmv686ifm+UQdMdobmvLvkmJmQ686ifm+UQdkmJmQLvMdobmiv686ifm+UQdkmJmQLvkmJmQ686ifmMJLU++ko``Jiv8ifmMJLU++ko``Jiv:ifmMJLU++ko``Jiv<ifmMJLU++ko``JivYkdbdkoiUQdbifmMJLU++ko``JivYkdvQkkoiUQdb ifmMJLU++ko``JivkoL: ifmMJLUkmJmok ifmMJLUkmJmokkoiUQdb ifmMQimYSYMJmYdbSY^^Yb ifmMQimYSYMJmYdbSY^^YbWdkfYmJ^ifmMQimYSYMJmYdbSY^^YbkoiUQdbifmMQimYSYMJmYdbkoiUQdbfQiYdOifm`YkkYbU`ibifmkoiUOQmJY^ifmkoiUOQmJY^J^^ifmkoiUOQmJY^fJmYQbmifmkoiUOQmJY^koiUQdbifmkoiUQdbifmkoiUQiYQkLvkoiUQdbifmkoiUQiYQkLvkoiUQdbJ^^OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSi`QufdimQik+kh+MMLdkQ^QMmMddiOYbJmdi+kh+MSi`QufdimQik+kh+MMLdkQ^QMmWdkfYmJ^+kh+MSi`QufdimQik+kh+MMLdkQ^QMmYO+kh+MSi`Y`fdimWYkmdiv+kh+M^Lu^Ykm+kh+MSi`koiUQivd^O+kh+MMLdkQ^QMmWdkfYmJ^+kh+MSi`koiUmJL^QqYQs+kh+MSi`koiUmJL^QqYQskoL+kh+OifmMJLU++Ykd^JmQObd+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU++Ykd^JmQObdkoL+kh+OifmMJLU++ko``Jiv8 +kh+OifmMJLU++Ykd^JmQObdkoiUQdb+kh+OifmMJLU++Ykd^JmQOvQkkoL!+kh+OifmMJLU++Ykd^JmQOvQk+d^O+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU++Ykd^JmQOvQk+kh+OifmMJLU++Ykd^JmQOvQkkoL8QOvQk+kh+OifmMJLU++Ykd^JmQOvQkkoL8mQOvQk+kh+OifmMJLU++Ykd^JmQOvQkkoL8vQkkoL+kh+OMWY^O@6+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JUQ+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JUQ+koiU +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JbUYbJ+Wdkf +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JbUYbJ+koiU +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JiiWvmW`YJ+Wdkf +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JiiWvmW`YJ+koiU +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MJiOYdUQbYM+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MJiOYdUQbYM+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MJiOYdf^QUYJ+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MJiOYdf^QUYJ+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MWS+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MWS+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+M^O+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+M^O+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MfLM`L+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MfLomY^+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MfLomY^+koiU'`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOLVAL $ Dv.TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PriorCAB] & "")=0,"Missing",IIf([PriorCAB]="No","No*",[PriorCAB])) In ("Missing","Yes","No*"); ((([__HospitalID] = HospitalID)) AND ([__SurgeonID] = SurgeonID)) AND ([__IsolatedCABG] = IsolatedCABG)SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI] AS Surgeon, IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) AS CABGSort, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG FROM tblSurgery WHERE ((([DISCHARGE] & "")<>"")) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI], IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)), IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) HAVING (((IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]))=Yes)) ORDER BY [SurgLName] & ", " & [SurgFName] & " " & [SurgMI]; (([__HospitalID] = HospitalID)) AND ([__SurgeonID] = SurgeonID)SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI] AS Surgeon, IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) AS CABGSort, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG FROM tblSurgery WHERE ((([DISCHARGE] & "")<>"")) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLName] & ", " & [SurgFName] & " " & [SurgMI], IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)), IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) HAVING (((IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]))=Yes)) ORDER BY [SurgLName] & ", " & [SurgFName] & " " & [SurgMI]; (([__HospitalID] = HospitalID)) AND ([__SurgeonID] = SurgeonID)$ NO ~ zL J %!H2A=FJWvrCAp~q@pp~q@p~q@~sq_drptCABG__IsolatedYesSub~sq_xNu@xNu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_CPBUtil_Hosp`X4MR2KeepLocal T @ rjSu@rjSu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_CLD_Surg`X4MR2KeepLocal T @rjSu@rjSu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_CLD_Hosp`X4MR2KeepLocal T @ ѩRu@ѩRu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_CHF_Hosp`X4MR2KeepLocal T @CXu@CXu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Cardioplegia_Surg`X4MR2KeepLocal T @CXu@CXu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Cardioplegia_Hosp`X4MR2KeepLocal T @ ~ŅQu@ŅQu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_CARDIOGENIC_Hosp`X4MR2KeepLocal T @}= Su@= Su@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Arrhythmia_Surg`X4MR2KeepLocal T @ {LRu@ѩRu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Angina_Surg`X4MR2KeepLocal T @zLRu@LRu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Angina_Hosp`X4MR2KeepLocal T @yBZu@BZu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Age_Surg`X4MR2KeepLocal T @ w }Nu@ }Nu@~sq_drptCABG__IsolatedYesSub~sq_dChild450`X4MR2KeepLocal Ttttttttr @vGf@Gf@~sq_drptCABG__IsolatedYesSub~sq_dChild396`X4MR2KeepLocal Ttttttttr @talHf@alHf@~sq_drptCABG__IsolatedYesSub~sq_dChild390`X4MR2KeepLocal Ttttttttr @sOUf@OUf@~sq_drptCABG__IsolatedYesSub~sq_dChild389`X4MR2KeepLocal Ttttttttr @qkV82@kV82@~sq_drptCABG__IsolatedYes~sq_drptCABG__IsolatedYesSub1`X4MR2KeepLocal T @pdz1@dz1@~sq_drptCABG__IsolatedYes_Old~sq_drptCABG__IsolatedYesSub`X4MR2KeepLocal T @LVAL 0 x((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([Incidenc] & "")=0,"Missing",IIf([Incidenc]="First cardiovascular surgery","Surg1",IIf([Incidenc]="First re-op cardiovascular surgery","ReOp1",IIf([Incidenc]="Second re-op cardiovascular surgery","ReOp2",IIf([Incidenc]="Third re-op cardiovascular surgery","ReOp3","ReOpGT3"))))) PIVOT IIf(Len([Incidenc] & "")=0,"Missing",IIf([Incidenc]="First cardiovascular surgery","Surg1",IIf([Incidenc]="First re-op cardiovascular surgery","ReOp1",IIf([Incidenc]="Second re-op cardiovascular surgery","ReOp2",IIf([Incidenc]="Third re-op cardiovascular surgery","ReOp3","ReOpGT3"))))) In ("Missing","Surg1","ReOp1","ReOp2","ReOp3","ReOpGT3"); (([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PriorCAB] & "")=0,"Missing",IIf([PriorCAB]="No","No*",[PriorCAB])) In ("Missing","No*","Yes"); ((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG) OH*l2 @  d $  f H V ,  t V ^"lB$lt8X:*NnP2~__txtIsolatedCABG333 O~__txtHospitalID/// O~ ~ G}@ '}rptCABG__IsolatedYesSubR@"K? 7}  G}__txtIsolatedCABG333 O}__txtHospitalID/// O}__txtSurgeonID--- O} } G|@ '|rptCABG__IsolatedYesSub@K? 7|  G|__txtIsolatedCABG333 O|__txtHospitalID/// O| | G{@ '{rptCABG__IsolatedYesSubF@K? 7{  G{__txtIsolatedCABG333 O{__txtHospitalID/// O{__txtSurgeonID--- O{ { Gz@ 'zrptCABG__IsolatedYesSub@K? 7z  Gz__txtIsolatedCABG333 Oz__txtHospitalID/// Oz z Gy@ 'yrptCABG__IsolatedYesSubl@K? 7y  Gy__txtIsolatedCABG333 Oy__txtHospitalID/// Oy__txtSurgeonID--- Oy y Gx@ 'xrptCABG__IsolatedYesSub@K? 7x  Gx__txtIsolatedCABG333 Ox__txtHospitalID/// Ox x Gw@ 'wrptCABG__IsolatedYesSub@K? 7w  Gw__txtIsolatedCABG333 Ow__txtHospitalID/// Ow w Gv@ 'vrptCABG__IsolatedYesSub<@K? 7v  Gv__txtIsolatedCABG333 Ov__txtHospitalID/// Ov__txtSurgeonID--- Ov v Gu@ 'urptCABG__IsolatedYesSubz@K? 7u  Gu__txtIsolatedCABG333 Ou__txtHospitalID/// Ou__txtSurgeonID--- Ou u Gt@ 'trptCABG__IsolatedYesSub"@K? 7t  Gt__txtIsolatedCABG333 Ot__txtHospitalID/// Ot t GDLVALJj>^((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Resusc] & "")=0,"Missing",IIf([Resusc]="No","No*",[Resusc])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([Incidenc] & "")=0,"Missing",IIf([Incidenc]="First cardiovascular surgery","Surg1",IIf([Incidenc]="First re-op cardiovascular surgery","ReOp1",IIf([Incidenc]="Second re-op cardiovascular surgery","ReOp2",IIf([Incidenc]="Third re-op cardiovascular surgery","ReOp3","ReOpGT3"))))) PIVOT IIf(Len([Incidenc] & "")=0,"Missing",IIf([Incidenc]="First cardiovascular surgery","Surg1",IIf([Incidenc]="First re-op cardiovascular surgery","ReOp1",IIf([Incidenc]="Second re-op cardiovascular surgery","ReOp2",IIf([Incidenc]="Third re-op cardiovascular surgery","ReOp3","ReOpGT3"))))) In ("Missing","Surg1","ReOp1","ReOp2","ReOp3","ReOpGT3"); LVAL* 4((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY AgeRange([AGE]) PIVOT AgeRange([AGE]) In ("Missing","< 18","18 to 49","50 to 59","60 to 69","70 to 79","80 or older"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY AgeRange([AGE]) PIVOT AgeRange([AGE]) In ("Missing","< 18","18 to 49","50 to 59","60 to 69","70 to 79","80 or older"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CPBUtil] & "")=0,"Missing",[CPBUtil]) In ("Missing","None","Combination","Full"); LVAL <\((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([ARR_Type] & "")=0,"Missing",[ARR_Type]) In ("Missing","None","VT/VF","Heart Block","Afib/Flutter"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([ANGINA_TYPE] & "")=0,"Missing",[ANGINA_TYPE]) In ("Missing","No Angina","Stable","Unstable"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([ANGINA_TYPE] & "")=0,"Missing",[ANGINA_TYPE]) In ("Missing","No Angina","Stable","Unstable"); ! @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ggggg ghhh h h  hi iii i jjjjjjjjjjj j j jkk!k"k#k l$l&l'l(l)l*l+l,l-l.l /l 0l 1l 2l 3l4l5l6l7l8l9l:l;ll?l@lAlBlClDll l!l"l#l$l%l&l'l( l) l* l+ l, l-l.l/l0l1l2l3l4l5l%mmmmmmmnn n!n"n#n$n%no&o(o)o*o+o,o'p-p/p0p1p2p3p.q4q6q7q8q9q:q;q5rr?r@rArBrCr=sDsFsGsHsIsJsEtttttttuu u u u u uuvvvvvvvvwwwwwwwxx x!x"x#x$xy%y'y(y)y*y+y,y&z-z/z0z1z2z3z.{4{6{7{8{9{:{;{5|<|>|?|@|A|B|=}C 1 @ @ @ @ @ @ @ @ @ @ @ @ @ @}E}F}G}H}I}J}D~K~M~N~#~#~#~L###### # ## # ##### ############## ##!###$#%#&#'#(#"#)#+#,#-#.#/#*#0#2#3#4#5#6#7#1#8#:#;#<#=#>#?#9#@#B#C#D#E#F#A#G#I#J#K#L#M(#H((((((((( ( ( ( ((( (((((((((((((((((!("(#($(%( (&((()(*(+(,(-('(.(0(1(2(3(4(/(5(7(8(9(:(;(<(6(=(?(@(A(B(C(>(D(F(G(H(I(J(K(E(L(N....(M..... . . .. ...... ............. .!..".$.%.&.'.(.).#.*.+(MnLVAL vj((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CARD_SHK] & "")=0,"Missing",IIf([CARD_SHK]="No","No*",[CARD_SHK])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CARD_SHK] & "")=0,"Missing",IIf([CARD_SHK]="No","No*",[CARD_SHK])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([ARR_Type] & "")=0,"Missing",[ARR_Type]) In ("Missing","None","VT/VF","Heart Block","Afib/Flutter"); N`B$nP V  v X : f  l ,  n P  |$B$f,:^~`BP&t4rptCABG__IsolatedYesSub,@&K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@$ 'rptCABG__IsolatedYesSub@&K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@$ 'rptCABG__IsolatedYesSub@&K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@" 'rptCABG__IsolatedYesSub:@%K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@" 'rptCABG__IsolatedYesSub@%K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@" 'rptCABG__IsolatedYesSub*@%K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@" 'rptCABG__IsolatedYesSub@$K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@ 'rptCABG__IsolatedYesSub`@$K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@ 'rptCABG__IsolatedYesSub@$K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@ 'rptCABG__IsolatedYesSubH@"K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G~@ '~rptCABG__IsolatedYesSub@"K? 7~  GLVAL Pp(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHF] & "")=0,"Missing",IIf([CHF]="No","No*",[CHF])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CARDIOPLEGIA] & "")=0,"Missing",IIf([CARDIOPLEGIA]="No","No*",[CARDIOPLEGIA])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CARDIOPLEGIA] & "")=0,"Missing",IIf([CARDIOPLEGIA]="No","No*",[CARDIOPLEGIA])) In ("Missing","No*","Yes"); LVAL Dd(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHRLUNGD] & "")=0,"Missing",[CHRLUNGD]) In ("Missing","No","Mild","Moderate","Severe"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHRLUNGD] & "")=0,"Missing",[CHRLUNGD]) In ("Missing","No","Mild","Moderate","Severe"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHF] & "")=0,"Missing",IIf([CHF]="No","No*",[CHF])) In ("Missing","Yes","No*"); LVAL j(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CPBUtil] & "")=0,"Missing",[CPBUtil]) In ("Missing","None","Combination","Full");TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CPBUtil] & "")=0,"Missing",[CPBUtil]) In ("Missing","None","Combination","Full"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CPBCmb] & "")=0,"Missing",[CPBCmb]) In ("Missing","Planned","Unplanned"); EO = 9MX w sK HF/+DD]YBn^~q@^~q@~^~q@^~q@~I1Tu@I1Tu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_HEPAFAIL_Hosp`X4MR2KeepLocal T @ }Nu@ }Nu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_HDEFDone_Surg`X4MR2KeepLocal T @PYu@PYu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Gender_Surg`X4MR2KeepLocal T @PYu@PYu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Gender_Hosp`X4MR2KeepLocal T @Vu@Vu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_EFMethod_Hosp`X4MR2KeepLocal T @:Wu@:Wu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_EF_Surg`X4MR2KeepLocal T @:Wu@:Wu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_EF_Hosp`X4MR2KeepLocal T @\[u@f[u@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_DStatus_Hosp`X4MR2KeepLocal T @^Xu@^Xu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_DisVess_Surg`X4MR2KeepLocal T @Vu@Vu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Dialysis_Surg`X4MR2KeepLocal T @Vu@Vu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Dialysis_Hosp`X4MR2KeepLocal T @Uu@Uu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Diabetes_Surg`X4MR2KeepLocal T @Tu@Tu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_CVD_Surg`X4MR2KeepLocal T @Tu@Tu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_CVD_Hosp`X4MR2KeepLocal T @aPu@aPu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_CVA_Hosp`X4MR2KeepLocal T @(Qu@(Qu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Creatinine_Surg`X4MR2KeepLocal T @$Pu@$Pu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Creatinine_Hosp`X4MR2KeepLocal T @ O^~`B n  t 4  v X  ,  J , n4B`BJX.vX`$nD&__txtHospitalID/// O  G@* 'rptCABG__IsolatedYesSubH@-K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@& 'rptCABG__IsolatedYesSub@,K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@& 'rptCABG__IsolatedYesSubH@,K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@& 'rptCABG__IsolatedYesSub@,K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@& 'rptCABG__IsolatedYesSub*@+K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@% 'rptCABG__IsolatedYesSub@+K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@% 'rptCABG__IsolatedYesSub6@+K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@% 'rptCABG__IsolatedYesSub@*K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@% 'rptCABG__IsolatedYesSub>@*K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@$ 'rptCABG__IsolatedYesSub@*K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@$ '7   @ @ +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OMWY^O@6+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JUQ+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JUQ+koiU +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JbUYbJ+Wdkf +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JbUYbJ+koiU +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JiiWvmW`YJ+Wdkf +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+JiiWvmW`YJ+koiU +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MJiOYdUQbYM+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MJiOYdUQbYM+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MJiOYdf^QUYJ+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MJiOYdf^QUYJ+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MWS+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MWS+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+M^O+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+M^O+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MfLM`L+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MfLomY^+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MfLomY^+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MiQJmYbYbQ+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MiQJmYbYbQ+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MqJ+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MqJ+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MqO+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MqO+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYJLQmQk+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYJLQmQk+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYJ^vkYk+Wdkf' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYJ^vkYk+koiU' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYkqQkk+Wdkf' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYkqQkk+koiU' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OkmJmok+Wdkf' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OkmJmok+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+QS+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+QS+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+QS`QmWdO+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+QS`QmWdO+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+UQbOQi+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+UQbOQi+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WOQSOdbQ+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WOQSOdbQ+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WQfJSJY^+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WQfJSJY^+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WvfQimQbkYdb+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WvfQimQbkYdb+koiU5`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOLVAL (([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVAWHEN] & "")=0,"Missing",[CVAWHEN]) In ("Missing","No CVA","<=2 Weeks",">2 Weeks"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT CreatRange([Creatinine]) In ("Missing","< 1.0","1.0 to 1.9*","2.0 to 3.9","4.0 to 10.0","> 10.0"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT CreatRange([Creatinine]) In ("Missing","< 1.0","1.0 to 1.9*","2.0 to 3.9","4.0 to 10.0","> 10.0"); LVAL Xx(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVD] & "")=0,"Missing",IIf([CVD]="No","No*",[CVD])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVD] & "")=0,"Missing",IIf([CVD]="No","No*",[CVD])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVAWHEN] & "")=0,"Missing",[CVAWHEN]) In ("Missing","No CVA","<=2 Weeks",">2 Weeks"); LVAL b(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Dialysis] & "")=0,"Missing",IIf([Dialysis]="No","No*",[Dialysis])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Diabetes] & "")=0,"Missing",IIf([Diabetes]="No","No*",[Diabetes])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Diabetes] & "")=0,"Missing",IIf([Diabetes]="No","No*",[Diabetes])) In ("Missing","No*","Yes"); LVAL \|((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DIS_VESS] & "")=0,"Missing",[DIS_VESS]) In ("Missing","None","Single","Double","Triple","Quadruple +"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DIS_VESS] & "")=0,"Missing",[DIS_VESS]) In ("Missing","None","Single","Double","Triple","Quadruple +"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Dialysis] & "")=0,"Missing",IIf([Dialysis]="No","No*",[Dialysis])) In ("Missing","Yes","No*"); NJ n. p R  ` 6  D & h , v L .  Z<~BbD&pRXxZ<hn.^rptCABG__IsolatedYesSub@2K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@, '^rptCABG__IsolatedYesSubf@2K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@, '^rptCABG__IsolatedYesSub@2K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@, '^rptCABG__IsolatedYesSubL@0K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@+ '^rptCABG__IsolatedYesSub@0K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@+ '^rptCABG__IsolatedYesSub@0K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@+ '^rptCABG__IsolatedYesSub6@/K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G@+ 'rptCABG__IsolatedYesSub@/K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@* 'rptCABG__IsolatedYesSub@/K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@* 'rptCABG__IsolatedYesSubZ@-K? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@* 'rptCABG__IsolatedYesSub@-K? 7  G__txtIsolatedCABG333 OLVALD 0d((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len(EjectRange([EF]) & "")=0,"Missing",EjectRange([EF])) In ("Missing","< 20%","20% to 29%","30% to 39%","40% to 49%","50% or more*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DStatus] & "")=0,"Missing",[DStatus]) In ("Missing","Alive","Dead"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DStatus] & "")=0,"Missing",[DStatus]) In ("Missing","Alive","Dead"); *LVALr ~2&F((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([EF_Type] & "")=0,"Missing",[EF_Type]) In ("Missing","None","LV Gram","Radionuclide","Estimate"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([EF_Type] & "")=0,"Missing",[EF_Type]) In ("Missing","None","LV Gram","Radionuclide","Estimate"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len(EjectRange([EF]) & "")=0,"Missing",EjectRange([EF])) In ("Missing","< 20%","20% to 29%","30% to 39%","40% to 49%","50% or more*"); !9 @ @ @ @ @ @ @ @ @ @ @ @ @ @((((((((((((((((!("(#($(%( (&((()(*(+(,(-('(.(0(1(2(3(4(/(5(7(8(9(:(;(<(6(=(?(@(A(B(C(>(D(F(G(H(I(J(K(E(L(N....(M..... . . .. ...... ............. .!..".$.%.&.'.(.).#.*.,.-.../.0.+.1.3.4.5.6.7.8.2.9.;.<.=.>.?.:.@.B.C.D.E.F.G.A.H.J.K.L.M3.I333333333 3 3 3 333 33333333333333333!3"3#3$3%3&3 3'3)3*3+3,3-3(3.3031323334353/3638393:3;3<373=3?3@3A3B3C3D3>3E3G3FLVAL &((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HDEFDone] & "")=0,"Missing",IIf([HDEFDone]="No","No*",[HDEFDone])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([SEX] & "")=0,"Missing",[SEX]) PIVOT IIf(Len([SEX] & "")=0,"Missing",[SEX]) In ("Missing","Female","Male"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([SEX] & "")=0,"Missing",[SEX]) PIVOT IIf(Len([SEX] & "")=0,"Missing",[SEX]) In ("Missing","Female","Male"); "O`$nD& n  v : Z <  ,  P  pR4Bf&hJX.|<~`$nD&^__txtSurgeonID--- O^ ^ G^@0 '^rptCABG__IsolatedYesSub"@:K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@0 '^rptCABG__IsolatedYesSubH@8K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@0 '^rptCABG__IsolatedYesSub@8K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@/ '^rptCABG__IsolatedYesSub,@8K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@/ '^rptCABG__IsolatedYesSub@6K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@/ '^rptCABG__IsolatedYesSub*@6K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@/ '^rptCABG__IsolatedYesSub@6K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@- '^rptCABG__IsolatedYesSubF@4K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@- '^rptCABG__IsolatedYesSub@4K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@- '^rptCABG__IsolatedYesSubH@4K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@, '|LVAL x((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HepaFail] & "")=0,"Missing",IIf([HepaFail]="No","No*",[HepaFail])) In ("Missing","Yes","No*");TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HepaFail] & "")=0,"Missing",IIf([HepaFail]="No","No*",[HepaFail])) In ("Missing","No*","Yes");TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HDEFDone] & "")=0,"Missing",IIf([HDEFDone]="No","No*",[HDEFDone])) In ("Missing","Yes","No*"); KO5 1MF [ p lJ HE1-DBWSBr1~q@1~1~q@11~q@1f[u@[u@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Quarter_Hosp`X4MR2KeepLocal T @UUUu@UUUu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_PVD_Surg`X4MR2KeepLocal T @Ou@Ou@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_PriorCAB_Surg`X4MR2KeepLocal T @COu@COu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_PriorCAB_Hosp`X4MR2KeepLocal T @\[u@\[u@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_PCI_Hosp`X4MR2KeepLocal T @Su@Su@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_NYHA_Surg`X4MR2KeepLocal T @Wu@Wu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_MITRAL_Surg`X4MR2KeepLocal T @Wu@Wu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_MITRAL_Hosp`X4MR2KeepLocal T @1Qu@LRu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_MI_Surg`X4MR2KeepLocal T @7Wu@7Wu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_LMS_Surg`X4MR2KeepLocal T @7Wu@7Wu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_LMS_Hosp`X4MR2KeepLocal T @Ou@Ou@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Incidenc_Hosp`X4MR2KeepLocal T @~Tu@~Tu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_IMMUNORX_Surg`X4MR2KeepLocal T @~Tu@~Tu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_IMMUNORX_Hosp`X4MR2KeepLocal T @Yu@Yu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_IMAUsed_Hosp`X4MR2KeepLocal T @+sVu@+sVu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Hypertension_Surg`X4MR2KeepLocal T @I1Tu@I1Tu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_HEPAFAIL_Surg`X4MR2KeepLocal T @LVAL. 0$D(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMA] & "")=0,"Missing",[IMA]) In ("Missing","Left IMA","Right IMA","Both IMAs"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HTN] & "")=0,"Missing",IIf([HTN]="No","No*",[HTN])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HTN] & "")=0,"Missing",IIf([HTN]="No","No*",[HTN])) In ("Missing","No*","Yes"); )G    @+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MqO+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+MqO+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYJLQmQk+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYJLQmQk+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYJ^vkYk+Wdkf' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYJ^vkYk+koiU' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYkqQkk+Wdkf' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OYkqQkk+koiU' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OkmJmok+Wdkf' +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+OkmJmok+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+QS+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+QS+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+QS`QmWdO+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+QS`QmWdO+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+UQbOQi+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+UQbOQi+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WOQSOdbQ+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WOQSOdbQ+koiU'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WQfJSJY^+Wdkf'+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WQfJSJY^+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WvfQimQbkYdb+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+WvfQimQbkYdb+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+Y`JokQO+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+Y`JokQO+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+Y``obdiu+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+Y``obdiu+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+YbMYOQbM+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+YbMYOQbM+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+^`k+Wdkf5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+^`k+koiU5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+`Y+Wdkf5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+`Y+koiU5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+`YmiJ^+Wdkf5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+`YmiJ^+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+bvWJ+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+bvWJ+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fMY+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fMY+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fiYdiMJL+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fiYdiMJL+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fqO+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fqO+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+hoJimQi+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+hoJimQi+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iJMQ+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iJMQ+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iJOJimok+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iJOJimok+koiUD`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOLVAL &F(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMMUNORX] & "")=0,"Missing",IIf([IMMUNORX]="No","No*",[IMMUNORX])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMMUNORX] & "")=0,"Missing",IIf([IMMUNORX]="No","No*",[IMMUNORX])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMA] & "")=0,"Missing",[IMA]) In ("Missing","Left IMA","Right IMA","Both IMAs"); 1B @ @ @ @ @ @ @ @ @ @ @ @ @ @.-.../.0.+.1.3.4.5.6.7.8.2.9.;.<.=.>.?.:.@.B.C.D.E.F.G.A.H.J.K.L.M3.I333333333 3 3 3 333 33333333333333333!3"3#3$3%3&3 3'3)3*3+3,3-3(3.3031323334353/3638393:3;3<373=3?3@3A3B3C3D3>3E3G3H3I3J3K3F3L3N;;;;;3M;;;; ; ; ;; ;;;;;;; ;;;;;;;;;;;; ;!;";;#;%;&;';(;);$;*;,;-;.;/;0;1;+;2;4;5;6;7;8;3;9;;;<;=;>;?;@;:;A;C;D;E;F;G;B;H;J;K;L;M@@;I@@@@@@@@ @ @ @ @@@@ @@@@lLVAL h|&(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([Incidenc] & "")=0,"Missing",IIf([Incidenc]="First cardiovascular surgery","Surg1",IIf([Incidenc]="First re-op cardiovascular surgery","ReOp1",IIf([Incidenc]="Second re-op cardiovascular surgery","ReOp2",IIf([Incidenc]="Third re-op cardiovascular surgery","ReOp3","ReOpGT3"))))) PIVOT IIf(Len([Incidenc] & "")=0,"Missing",IIf([Incidenc]="First cardiovascular surgery","Surg1",IIf([Incidenc]="First re-op cardiovascular surgery","ReOp1",IIf([Incidenc]="Second re-op cardiovascular surgery","ReOp2",IIf([Incidenc]="Third re-op cardiovascular surgery","ReOp3","ReOpGT3"))))) In ("Missing","Surg1","ReOp1","ReOp2","ReOp3","ReOpGT3"); *Nfl, n P  | $ B $ f , :  X:|BP&nPXf<fn2 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@6 '^rptCABG__IsolatedYesSub@?K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@4 '^rptCABG__IsolatedYesSub@?K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@4 '^rptCABG__IsolatedYesSub@>K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@4 '^rptCABG__IsolatedYesSubJ@>K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@4 '^rptCABG__IsolatedYesSub@>K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@2 '^rptCABG__IsolatedYesSub|@=K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@2 '^rptCABG__IsolatedYesSub$@=K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@2 '^rptCABG__IsolatedYesSubj@=K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@2 '^rptCABG__IsolatedYesSub@<K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@0 '^rptCABG__IsolatedYesSubz@<K? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// OnLVALt(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len(LMSRange([LMStenPCT]) & "")=0,"Missing",LMSRange([LMStenPCT])) In ("Missing","50% or less*","Greater than 50%"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([Incidenc] & "")=0,"Missing",IIf([Incidenc]="First cardiovascular surgery","Surg1",IIf([Incidenc]="First re-op cardiovascular surgery","ReOp1",IIf([Incidenc]="Second re-op cardiovascular surgery","ReOp2",IIf([Incidenc]="Third re-op cardiovascular surgery","ReOp3","ReOpGT3"))))) PIVOT IIf(Len([Incidenc] & "")=0,"Missing",IIf([Incidenc]="First cardiovascular surgery","Surg1",IIf([Incidenc]="First re-op cardiovascular surgery","ReOp1",IIf([Incidenc]="Second re-op cardiovascular surgery","ReOp2",IIf([Incidenc]="Third re-op cardiovascular surgery","ReOp3","ReOpGT3"))))) In ("Missing","Surg1","ReOp1","ReOp2","ReOp3","ReOpGT3"); LVAL r((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([MI_WHEN] & "")=0,"Missing",[MI_WHEN]) In ("Missing","No MI","<=6 hours","7-23 hours","1-7 days","8-21 days",">21 days"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([MI_WHEN] & "")=0,"Missing",[MI_WHEN]) In ("Missing","No MI","<=6 hours","7-23 hours","1-7 days","8-21 days",">21 days"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len(LMSRange([LMStenPCT]) & "")=0,"Missing",LMSRange([LMStenPCT])) In ("Missing","50% or less*","Greater than 50%"); jLVAL  t(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([NYHA] & "")=0,"Missing",[NYHA]) In ("Missing","I","II","III","IV"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([MITRAL] & "")=0,"Missing",[MITRAL]) In ("Missing","None","Trivial","Mild","Moderate","Severe"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([MITRAL] & "")=0,"Missing",[MITRAL]) In ("Missing","None","Trivial","Mild","Moderate","Severe"); LVAL d(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PriorPCI] & "")=0,"Missing",[PriorPCI]) In ("Missing","None","<=6 hours",">6 hours"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PriorPCI] & "")=0,"Missing",[PriorPCI]) In ("Missing","None","<=6 hours",">6 hours"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([NYHA] & "")=0,"Missing",[NYHA]) In ("Missing","I","II","III","IV"); O~`BP& t 4  v X  f <  J , n 2 |R4`BHhJ,vX^~`Bn  G@: 'rptCABG__IsolatedYesSub@FK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@: 'rptCABG__IsolatedYesSub@EK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@: 'rptCABG__IsolatedYesSub`@EK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@8 'rptCABG__IsolatedYesSub@EK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@8 'rptCABG__IsolatedYesSubP@CK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@8 'rptCABG__IsolatedYesSubb@CK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@8 'rptCABG__IsolatedYesSub*@CK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@6 'rptCABG__IsolatedYesSub@AK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G^@6 '^rptCABG__IsolatedYesSubH@AK? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^__txtSurgeonID--- O^ ^ G^@6 '^rptCABG__IsolatedYesSub@AK? 7 ^ G^__txtIsolatedCABG333 O^__txtHospitalID/// O^ ^ G^@6 '^rptCABG__IsolatedYesSub6@?K? 7LVAL  (([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PVD] & "")=0,"Missing",IIf([PVD]="No","No*",[PVD])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PriorCAB] & "")=0,"Missing",IIf([PriorCAB]="No","No*",[PriorCAB])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PriorCAB] & "")=0,"Missing",IIf([PriorCAB]="No","No*",[PriorCAB])) In ("Missing","No*","Yes"); 9K @ @ @ @ @ @ @ @ @ @ @ @ @ @3I3J3K3F3L3N;;;;;3M;;;; ; ; ;; ;;;;;;; ;;;;;;;;;;;; ;!;";;#;%;&;';(;);$;*;,;-;.;/;0;1;+;2;4;5;6;7;8;3;9;;;<;=;>;?;@;:;A;C;D;E;F;G;B;H;J;K;L;M@@;I@@@@@@@@ @ @ @ @@@@ @@@@@@@@@@@@@@@@ @"@#@$@%@&@!@'@)@*@+@,@-@.@(@/@1@2@3@4@5@0@6@8@9@:@;@<@=@7@>@@@A@B@C@D@?@E@G@H@I@J@K@L@F@MHHHHH@NHHHH H H H HH HHHHHHHHHHHHHHHHHH H!H"HH#H%H&H'H(H)H*H$H+H-H.H/H,LVAL t$TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, Left([DISCHARGE],4) AS Criteria, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.SurgeonID)<>"") AND ((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, Left([DISCHARGE],4), IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY Left([DISCHARGE],4), IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) PIVOT IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) In ("Missing","Q1","Q2","Q3","Q4"); TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.SurgeonID)<>"") AND ((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) PIVOT IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) In ("Missing","Q1","Q2","Q3","Q4"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PVD] & "")=0,"Missing",IIf([PVD]="No","No*",[PVD])) In ("Missing","Yes","No*"); UO0E AMZ s J H  F&C?DN]YBv1~q@1~1~q@1~1~q@1~2@2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_CVD_Hosp`X4MR2KeepLocal T @32@32@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_CVA_Surg`X4MR2KeepLocal T @~2@~2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Creatinine_Surg`X4MR2KeepLocal T @32@32@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Creatinine_Hosp`X4MR2KeepLocal T @~2@~2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_CLD_Hosp`X4MR2KeepLocal T @;2@72@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Age_Surg`X4MR2KeepLocal T @ ՘2@՘2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Acuity_Surg`X4MR2KeepLocal T @rr2@rr2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Acuity_Hosp`X4MR2KeepLocal T @Tf@Tf@~sq_drptCABG__IsolatedYesSub~sq_drptQuarter_Surg`X4MR2KeepLocal T @ Sf@2Tf@~sq_drptCABG__IsolatedYesSub~sq_drptDStatus_Surg`X4MR2KeepLocal T @Sf@Sf@~sq_drptCABG__IsolatedYesSub~sq_drptDStatus_Hosp`X4MR2KeepLocal T @ (Qu@(Qu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_StatusProc_Hosp`X4MR2KeepLocal T @aPu@aPu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Resusc_Surg`X4MR2KeepLocal T @Pu@Pu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Resusc_Hosp`X4MR2KeepLocal T @ kMu@kMu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_RadArtUs_Hosp`X4MR2KeepLocal T @{Yu@{Yu@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Race_Surg`X4MR2KeepLocal T @ 2@2@~sq_drptCABG__IsolatedYesSub~sq_drptCABG_Quarter_Surg`X4MR2KeepLocal T @LVAL (([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) AS ISOCABGSort, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]), IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) PIVOT IIf(Len([RadArtUs] & "")=0,"Missing",[RadArtUs]) In ("Missing","No Radial","Left Radial","Right Radial","Both Radials"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Race] & "")=0,"Missing",IIf([Race]="Caucasian","White*","Non-White")) In ("Missing","White*","Non-White"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Race] & "")=0,"Missing",IIf([Race]="Caucasian","White*","Non-White")) In ("Missing","White*","Non-White"); LVAL ((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Resusc] & "")=0,"Missing",IIf([Resusc]="No","No*",[Resusc])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Resusc] & "")=0,"Missing",IIf([Resusc]="No","No*",[Resusc])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLname] & ", " & [SurgFname] AS Surgeon, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) AS ISOCABGSort, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLname] & ", " & [SurgFname], IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]), IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) PIVOT IIf(Len([RadArtUs] & "")=0,"Missing",[RadArtUs]) In ("Missing","No Radial","Left Radial","Right Radial","Both Radials"); 7V @@@+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+Y``obdiu+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+YbMYOQbM+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+YbMYOQbM+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+^`k+Wdkf5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+^`k+koiU5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+`Y+Wdkf5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+`Y+koiU5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+`YmiJ^+Wdkf5 +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+`YmiJ^+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+bvWJ+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+bvWJ+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fMY+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fMY+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fiYdiMJL+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fiYdiMJL+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fqO+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+fqO+koiU5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+hoJimQi+Wdkf5+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+hoJimQi+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iJMQ+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iJMQ+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iJOJimok+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iJOJimok+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iQkokM+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+iQkokM+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+kmJmokfidM+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+kmJmokfidM+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmOkmJmok+WdkfD +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmOkmJmok+koiUD +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmhoJimQi+WdkfD +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmhoJimQi+koiUD +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+JMoYmv+WdkfD +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+JMoYmv+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+JUQ+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+JUQ+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+M^O+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+M^O+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MiQJmYbYbQ+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MiQJmYbYbQ+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MqJ+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MqJ+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MqO+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MqO+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OYJLQmQk+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OYJLQmQk+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OYJ^vkYk+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OYJ^vkYk+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OkmJmok+WdkfQ`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO&Nfn2 | R 4  | $ H  h J , :  ^~`BP&t4vXd:H*j.  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@< 'rptCABG__IsolatedYesSub1@LMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@< 'rptCABG__IsolatedYesSub1 @LMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@< 'rptCABG__IsolatedYesSubP@JK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@ : 'rptCABG__IsolatedYesSubb@JK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@ : 'rptCABG__IsolatedYesSub@JK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@: 'rptCABG__IsolatedYesSub@IK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@: 'rptCABG__IsolatedYesSub@IK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@: 'rptCABG__IsolatedYesSub"@IK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@: 'rptCABG__IsolatedYesSub<@FK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@: 'rptCABG__IsolatedYesSub@FK? 7  G__txtIsolatedCABG333 O__txtHospitalID/// OLVAL  TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DStatus] & "")=0,"Missing",[DStatus]) In ("Missing","Alive","Dead"); TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLname] & ", " & [SurgFname] AS Surgeon, IIf(Len([IsoCABG] & "")=0,"Missing",[IsoCABG]) AS IsolatedCABG, IIf(Len([StatusProc] & "")=0,1,IIf([StatusProc]="Yes",2,3)) AS IsoCABGSort, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLname] & ", " & [SurgFname], IIf(Len([IsoCABG] & "")=0,"Missing",[IsoCABG]), IIf(Len([StatusProc] & "")=0,1,IIf([StatusProc]="Yes",2,3)) PIVOT IIf(Len([StatusProc] & "")=0,"Missing",[StatusProc]) In ("Missing","Elective","Urgent","Emergent","Emergent Salvage"); TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, IIf(Len([IsoCABG] & "")=0,"Missing",[IsoCABG]) AS IsolatedCABG, IIf(Len([StatusProc] & "")=0,1,IIf([StatusProc]="Yes",2,3)) AS IsoCABGSort, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([IsoCABG] & "")=0,"Missing",[IsoCABG]), IIf(Len([StatusProc] & "")=0,1,IIf([StatusProc]="Yes",2,3)) PIVOT IIf(Len([StatusProc] & "")=0,"Missing",[StatusProc]) In ("Missing","Elective","Urgent","Emergent","Emergent Salvage"); &LVAL :TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, Left([DISCHARGE],4) AS Criteria, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.SurgeonID)<>"") AND ((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, Left([DISCHARGE],4), IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY Left([DISCHARGE],4), IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) PIVOT IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) In ("Missing","Q1","Q2","Q3","Q4"); TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.SurgeonID)<>"") AND ((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) PIVOT IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) In ("Missing","Q1","Q2","Q3","Q4"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DStatus] & "")=0,"Missing",[DStatus]) In ("Missing","Alive","Dead"); BS @ @ @ @ @ @ @ @ @ @ @ @ @ @@@@@@@@@@@@@ @"@#@$@%@&@!@'@)@*@+@,@-@.@(@/@1@2@3@4@5@0@6@8@9@:@;@<@=@7@>@@@A@B@C@D@?@E@G@H@I@J@K@L@F@MHHHHH@NHHHH H H H HH HHHHHHHHHHHHHHHHHH H!H"HH#H%H&H'H(H)H*H$H+H-H.H/H0H1H,H2H4H5H6H7H8H9H3H:H<H=H>H?H@H;HAHCHDHEHFHGHHHBHIHKHLHMMMHJMMMMMMM MM M M MMMM MMMMMMMMMMMMMMMM M"M#M$M%M&M'M!M(M*M+M,M-M.M)M/M1M2M3M4M5M6M0M7M9M:M;M<M=M8M>M@MAMBMCMDMEM?MFMHMIMJMKMGLVAL TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY AgeRange([AGE]) PIVOT AgeRange([AGE]) In ("Missing","< 18","18 to 49","50 to 59","60 to 69","70 to 79","80 or older"); TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLname] & ", " & [SurgFname] AS Surgeon, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) AS ISOCABGSort, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, [SurgLname] & ", " & [SurgFname], IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]), IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) PIVOT IIf(Len([StatusProc] & "")=0,"Missing",[StatusProc]) In ("Missing","Elective","Emergent","Salvage/Emergent","Urgent"); TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) AS ISOCABGSort, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]), IIf(Len([ISOCABG] & "")=0,1,IIf([ISOCABG]="Yes",2,3)) PIVOT IIf(Len([StatusProc] & "")=0,"Missing",[StatusProc]) In ("Missing","Elective","Emergent","Salvage/Emergent","Urgent"); N|^@l p 0  p R  ~ $ B $ d * 6 T6v<HfHNZ0xZ G@? 'rptCABG__IsolatedYesSub1@RMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@? 'rptCABG__IsolatedYesSub1*@PMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@> 'rptCABG__IsolatedYesSub1@PMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@> 'rptCABG__IsolatedYesSub16@PMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@> 'rptCABG__IsolatedYesSub1@OMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@> 'rptCABG__IsolatedYesSub1>@OMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@> 'rptCABG__IsolatedYesSub1@OMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@= 'rptCABG__IsolatedYesSub1:@NMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@= 'rptCABG__IsolatedYesSub1@NMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@= 'rptCABG__IsolatedYesSub1l@NMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@< 'rptCABG__IsolatedYesSub1@LMA 7pLVAL xl((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHRLUNGD] & "")=0,"Missing",[CHRLUNGD]) In ("Missing","No","Mild","Moderate","Severe"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHRLUNGD] & "")=0,"Missing",[CHRLUNGD]) In ("Missing","No","Mild","Moderate","Severe"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY AgeRange([AGE]) PIVOT AgeRange([AGE]) In ("Missing","< 18","18 to 49","50 to 59","60 to 69","70 to 79","80 or older"); LVAL h((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVAWHEN] & "")=0,"Missing",[CVAWHEN]) In ("Missing","No CVA","<=2 Weeks",">2 Weeks"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT CreatRange([Creatinine]) In ("Missing","< 1.0","1.0 to 1.9*","2.0 to 3.9","4.0 to 10.0","> 10.0"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT CreatRange([Creatinine]) In ("Missing","< 1.0","1.0 to 1.9*","2.0 to 3.9","4.0 to 10.0","> 10.0"); .LVAL 8X,L((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVD] & "")=0,"Missing",IIf([CVD]="No","No*",[CVD])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVD] & "")=0,"Missing",IIf([CVD]="No","No*",[CVD])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVAWHEN] & "")=0,"Missing",[CVAWHEN]) In ("Missing","No CVA","<=2 Weeks",">2 Weeks"); O"N1 F [ WKn }IFD#B<Y߃Q@߃Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Age_Surg`X4MR2KeepLocal T @&Q@&Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Age_Hosp`X4MR2KeepLocal T @ޛ2@ޛ2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Race_Surg`X4MR2KeepLocal T @+{2@+{2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Race_Hosp`X4MR2KeepLocal T @_2@_2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Quarter_Surg`X4MR2KeepLocal T @W2@W2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_PVD_Surg`X4MR2KeepLocal T @W2@W2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_PVD_Hosp`X4MR2KeepLocal T @=2@=2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_IMMUNORX_Hosp`X4MR2KeepLocal T @+{2@+{2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Hypertension_Surg`X4MR2KeepLocal T @2@2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Hypertension_Hosp`X4MR2KeepLocal T @ѱ2@ѱ2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_HEPAFAIL_Hosp`X4MR2KeepLocal T @;2@;2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Gender_Surg`X4MR2KeepLocal T @72@72@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_DStatus_Surg`X4MR2KeepLocal T @72@72@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_DStatus_Hosp`X4MR2KeepLocal T @2@2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Dialysis_Surg`X4MR2KeepLocal T @2@2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Diabetes_Surg`X4MR2KeepLocal T @2@2@~sq_drptCABG__IsolatedYesSub1~sq_drptCABG_Diabetes_Hosp`X4MR2KeepLocal T @LVAL Bb((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Dialysis] & "")=0,"Missing",IIf([Dialysis]="No","No*",[Dialysis])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Diabetes] & "")=0,"Missing",IIf([Diabetes]="No","No*",[Diabetes])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Diabetes] & "")=0,"Missing",IIf([Diabetes]="No","No*",[Diabetes])) In ("Missing","No*","Yes"); K[ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @H1H,H2H4H5H6H7H8H9H3H:H<H=H>H?H@H;HAHCHDHEHFHGHHHBHIHKHLHMMMHJMMMMMMM MM M M MMMM MMMMMMMMMMMMMMMM M"M#M$M%M&M'M!M(M*M+M,M-M.M)M/M1M2M3M4M5M6M0M7M9M:M;M<M=M8M>M@MAMBMCMDMEM?MFMHMIMJMKMLMGMMTTTTTTTTT T T T T TTTTTTTTTTTTTTTTTTT T!T"T#T$TT%T'T(T)T*T+T&T,T.T/T0T1T2T3T-T4T6T7T8T9T:T5T;T=T>T?T@TATBT<TCTETFTGTHTITDTJTLTMYYYYTKYYYYY Y YY Y YYYYYY YYYYYYYNl,lN Z 0  ~ > ~ ` $ l B $  P 2 r6~T6bDHfH*tVZxZ<__txtHospitalID/// O__txtSurgeonID--- O  G@N 'rptCABG__IsolatedYesSub1@XMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@F 'rptCABG__IsolatedYesSub1F@XMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@E 'rptCABG__IsolatedYesSub1@WMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@E 'rptCABG__IsolatedYesSub1f@WMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@A 'rptCABG__IsolatedYesSub1@WMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@A 'rptCABG__IsolatedYesSub1@UMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@A 'rptCABG__IsolatedYesSub1@UMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@A 'rptCABG__IsolatedYesSub1H@UMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@? 'rptCABG__IsolatedYesSub1@RMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@? 'rptCABG__IsolatedYesSub1H@RMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O LVAL Rr((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DStatus] & "")=0,"Missing",[DStatus]) In ("Missing","Alive","Dead"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DStatus] & "")=0,"Missing",[DStatus]) In ("Missing","Alive","Dead"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Dialysis] & "")=0,"Missing",IIf([Dialysis]="No","No*",[Dialysis])) In ("Missing","Yes","No*"); 2Gj@@ @ @@@+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmMJLU+kmJmokfidM+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmOkmJmok+WdkfD +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmOkmJmok+koiUD +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmhoJimQi+WdkfD +kh+OifmMJLU++Ykd^JmQOvQkkoL+kh+OifmhoJimQi+koiUD +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+JMoYmv+WdkfD +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+JMoYmv+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+JUQ+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+JUQ+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+M^O+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+M^O+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MiQJmYbYbQ+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MiQJmYbYbQ+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MqJ+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MqJ+koiUD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MqO+WdkfD+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+MqO+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OYJLQmQk+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OYJLQmQk+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OYJ^vkYk+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OYJ^vkYk+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OkmJmok+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+OkmJmok+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+UQbOQi+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+UQbOQi+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+WQfJSJY^+WdkfQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+WQfJSJY^+koiUQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+WvfQimQbkYdb+WdkfQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+WvfQimQbkYdb+koiUQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+Y``obdiu+WdkfQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+Y``obdiu+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+fqO+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+fqO+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+hoJimQi+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+hoJimQi+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+iJMQ+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+iJMQ+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OMWY^O>@6Q+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JUQ+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JUQ+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JbUYbJ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JbUYbJ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JiiWvmW`YJ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JiiWvmW`YJ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MJiOYdUQbYM+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MJiOYdUQbYM+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MJiOYdf^QUYJ+Wdkf``kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOLVAL (((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HepaFail] & "")=0,"Missing",IIf([HepaFail]="No","No*",[HepaFail])) In ("Missing","No*","Yes");TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([SEX] & "")=0,"Missing",[SEX]) PIVOT IIf(Len([SEX] & "")=0,"Missing",[SEX]) In ("Missing","Female","Male"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([SEX] & "")=0,"Missing",[SEX]) PIVOT IIf(Len([SEX] & "")=0,"Missing",[SEX]) In ("Missing","Female","Male"); LVAL Hh(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HTN] & "")=0,"Missing",IIf([HTN]="No","No*",[HTN])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HTN] & "")=0,"Missing",IIf([HTN]="No","No*",[HTN])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HepaFail] & "")=0,"Missing",IIf([HepaFail]="No","No*",[HepaFail])) In ("Missing","Yes","No*");NHfH N  Z 0  x Z ` $ l B $  lr6~T6~$HfH*6 T6@P 'rptCABG__IsolatedYesSub2@^MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@P 'rptCABG__IsolatedYesSub2@]MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@P 'rptCABG__IsolatedYesSub1`@]MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@P 'rptCABG__IsolatedYesSub1@]MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@O 'rptCABG__IsolatedYesSub1P@\MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@O 'rptCABG__IsolatedYesSub1b@\MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@O 'rptCABG__IsolatedYesSub1*@\MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@O 'rptCABG__IsolatedYesSub1@ZMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@N 'rptCABG__IsolatedYesSub1H@ZMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@N 'rptCABG__IsolatedYesSub1@ZMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@N 'rptCABG__IsolatedYesSub1*@XMA 7  G__txtIsolatedCABG333 OLVAL  (([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PVD] & "")=0,"Missing",IIf([PVD]="No","No*",[PVD])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMMUNORX] & "")=0,"Missing",IIf([IMMUNORX]="No","No*",[IMMUNORX])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMMUNORX] & "")=0,"Missing",IIf([IMMUNORX]="No","No*",[IMMUNORX])) In ("Missing","No*","Yes"); Sr @ @ @ @ @ @ @ @ @ @ @ @ @ @YYYYYY Y!YY"Y$Y%Y&Y'Y(Y#Y)Y+Y,Y-Y.Y/Y0Y*Y1Y3Y4Y5Y6Y7Y2Y8Y:Y;Y<Y=Y>Y?Y9Y@YBYCYDYEYFYAYGYIYJYKYLYMYH__________ _ _ _ __ _________________ _!_"_#_$_%__&_(_)_*_+_,_'_-_/_0_1_2_3_4_._5_7_8_9_:_;_6_<_>_?_@_A_B_C_=_D_F_G_H_I_J_E_K_Mlllll_Lllll l l ll lllllll llllllllllll l!l"ll#l%l&l'l(l)l*l$l+l-l.l/l0l1l,l2l4l5l6l7l8l9l3l:l<l=l>l?l@l;lAlClDlElFlGlHlBlIlKlLlMqqlJqql$LVAL t$TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, Left([DISCHARGE],4) AS Criteria, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.SurgeonID)<>"") AND ((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, Left([DISCHARGE],4), IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY Left([DISCHARGE],4), IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) PIVOT IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) In ("Missing","Q1","Q2","Q3","Q4"); TRANSFORM Count(tblSurgery.SurgeryID) AS CountOfSurgeryID SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.SurgeonID)<>"") AND ((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) PIVOT IIf(Mid([DISCHARGE],5,2)<4,"Q1",IIf(Mid([DISCHARGE],5,2)<7,"Q2",IIf(Mid([DISCHARGE],5,2)<10,"Q3","Q4"))) In ("Missing","Q1","Q2","Q3","Q4"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([PVD] & "")=0,"Missing",IIf([PVD]="No","No*",[PVD])) In ("Missing","Yes","No*"); LVAL Ll(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CPBUtil] & "")=0,"Missing",[CPBUtil]) In ("Missing","None","Combination","Full"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Race] & "")=0,"Missing",IIf([Race]="Caucasian","White*","Non-White")) In ("Missing","White*","Non-White"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Race] & "")=0,"Missing",IIf([Race]="Caucasian","White*","Non-White")) In ("Missing","White*","Non-White"); LVAL <(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([ANGINA_TYPE] & "")=0,"Missing",[ANGINA_TYPE]) In ("Missing","No Angina","Stable","Unstable"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY AgeRange([AGE]) PIVOT AgeRange([AGE]) In ("Missing","< 18","18 to 49","50 to 59","60 to 69","70 to 79","80 or older"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY AgeRange([AGE]) PIVOT AgeRange([AGE]) In ("Missing","< 18","18 to 49","50 to 59","60 to 69","70 to 79","80 or older"); :NNlN0 <  `  ~ ` B  N $  r 2  rT`6D&f*rH* V8x<Z<j__txtSurgeonID--- Oj j G@W 'rptCABG__IsolatedYesSub2@kMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@U 'rptCABG__IsolatedYesSub2`@kMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@U 'rptCABG__IsolatedYesSub2@iMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@U 'rptCABG__IsolatedYesSub2H@iMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@U 'rptCABG__IsolatedYesSub2@iMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@R 'rptCABG__IsolatedYesSub2R@hMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@R 'rptCABG__IsolatedYesSub2@hMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@R 'rptCABG__IsolatedYesSub2F@hMA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@R 'rptCABG__IsolatedYesSub2@^MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@P 'rptCABG__IsolatedYesSub2l@^MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G.*N9 F BLM X u qIGD3/BBUj~q@j~Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Diabetes_Surg`X4MR2KeepLocal T @Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Diabetes_Hosp`X4MR2KeepLocal T @ Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CVD_Hosp`X4MR2KeepLocal T @Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CVA_Surg`X4MR2KeepLocal T @Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CVA_Hosp`X4MR2KeepLocal T @ CQ@CQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Creatinine_Hosp`X4MR2KeepLocal T @ߝQ@ߝQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CPBUtil_Surg`X4MR2KeepLocal T @_ߝQ@ߝQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CPBUtil_Hosp`X4MR2KeepLocal T @ Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CLD_Surg`X4MR2KeepLocal T @Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CLD_Hosp`X4MR2KeepLocal T @DQ@DQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CHF_Hosp`X4MR2KeepLocal T @_Q@_Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Cardioplegia_Surg`X4MR2KeepLocal T @Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Cardioplegia_Hosp`X4MR2KeepLocal T @8Q@8Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_CARDIOGENIC_Hosp`X4MR2KeepLocal T @y(Q@y(Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Arrhythmia_Surg`X4MR2KeepLocal T @gQ@gQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Angina_Surg`X4MR2KeepLocal T @gQ@gQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Angina_Hosp`X4MR2KeepLocal T @ LVAL MR2h ReplicateProjectAppNameAppLabelAppVersionAppLicense AppAdministratorAppDeveloper,PersonNameHelpIncluded"PhoneHelpIncludedGEOIncluded$GEOArchiveIncluded(PatternMatchIncluded.StandardReportsIncluded$LocalFactsIncluded&UserOptionsIncludedAppSizeWarningAppCountryAppStateAppCityAppSizeCurrentAppSizeBaselineAutoEditAddressAutoEditCityAutoEditEntityUsePrintPoolUse24HourClockRefreshIntervalLastLinkPathLastCompactDate  CCORPApp* "CCORP Application  1.0.1 |California Office of Statewide Health Planning and Development               $@8 0UNITED STATES OF AMERICA" CALIFORNIA,US(  SACRAMENTO,CA,US@@L@  2  2  2  3  0  60000, $C:\CCORP_01102009\$ 20090110152055 ;6f۴-Vf[ٶ 6&Z-Pf0LVALЂMR2 GUIDNameMapZ F‡@g{N 6 . U MR2 GUIDNameMapZ F‡@g{N 6 . U MR2 GUIDNameMapZ ??%JůG$J[a46 . U MR2h ReplicateProjectAppNameAppLabelAppVersionAppLicense AppAdministratorAppDeveloper,PersonNameHelpIncluded"PhoneHelpIncludedGEOIncluded$GEOArchiveIncluded(PatternMatchIncluded.StandardReportsIncluded$LocalFactsIncluded&UserOptionsIncludedAppSizeWarningAppCountryAppStateAppCityAppSizeCurrentAppSizeBaselineAutoEditAddressAutoEditCityAutoEditEntityUsePrintPoolUse24HourClockRefreshIntervalLastLinkPathLastCompactDate  CCORPApp* "CCORP Application  1.0.1 |California Office of Statewide Health Planning and Development               $@8 MR2 GUIDNameMapZ F‡@g{N 6 . U MR2 GUIDNameMapZ F‡@g{N 6 . U MR2 GUIDNameMapZ ??%JůG$J[a46 . U Lh=dA W  g 2 } : P  Z  l1_.tGVd-U"@d1Emod_Phone010"Dmod_Person010$ Cmod_GEO010Bmod_BaseTime010($Amod_BaseTables010,(@mod_BaseStrings010.*?mod_BaseSort010($>mod_BaseReports010.*=mod_BaseRecordsets01040<mod_BaseQueries010.*;mod_BaseOFN010&":mod_BaseNumbers010.*9mod_BaseNews010($8mod_BaseModules010.*7mod_BaseForms010*&6mod_BaseFiles010*&5mod_BaseError010*&4mod_BaseDrives010,(3mod_BaseDisplayClone010842mod_BaseDate010($1mod_BaseDataDict0100,0mod_BaseConnections01062/mod_BaseComputer0100,.mod_Base010 -frmToOSHPD,frmTextExport$ +frmTableViewSub($*frmTableView")frmSurgeryNew$ (frmSurgeryFind&"'frmSurgery&frmSurgeonList&"%frmSurgeonEdit&"$frmSurgeonAdd$ #frmCCORPFacts$ "frm_PhoneHelp010*&!frm_PersonNameHelp01040 frm_GEOStateList0100,frm_GEOStateEdit0100,frm_GEOStateAdd010.*frm_GEOCountyList0102.frm_GEOCountyEdit0102.frm_GEOCountyAdd0100,frm_GEOCountryList01040frm_GEOCountryEdit01040frm_GEOCountryAdd0102.frm_GEOCityList010.*frm_GEOCityEdit010.*frm_GEOCityAdd010,(frm_BaseUserOptions01062frm_BaseSystemStatus01084frm_BaseStandardReports84frm_BaseSplash&"frm_BaseShowCredits01062frm_BaseSetup010*&frm_BaseNews010($ frm_BaseLocalFacts01040 frm_BaseDisplayClone01084 frm_BaseDateHelp0100,UserDefined SummaryInfo AccessLayout "SysRelScriptsReportsModulesFormsDataAccessPages($MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTablesr1ί vq@(vq@2PBlobCopy3.*& wvq@(vq@1PBlobCopy3.*& wvq@(vq@0PBlobCopy3.*& wvq@(vq@/PBlobCopy3.*& wMXq@MXq@.PW@ BlobCopy3:62" @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @5   wqke_ !Y#$%S'()M+,-G/1  3    "#%&()+,./124578:;=> @A"CD$FG&IJ(RS,TU.XY0Z[2`a4bc6de8hijkpqrstu        1       2       3       4       x  !  "  #  .  %  &  '   )  +  -  0S=S> S=S?!S=S@"S=SE#p p %p p &p p 'p Ppp)pp*pp+pSpp-pp.pp/pd&pp1pp2pp3pg'pp5pp6pp 7pj(p"p#p"p$p"p%p")p'p(p'p)p'p*p'*p,p- p,p. p,p/ p,+p1p2 p1p3p1p4p1,p6p7p6p8p6p9p6np;p<p;p=p;p>p;qp@pAp@pBp@pCp@trrrrrrrs rs rs rs LVAL n((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([ARR_Type] & "")=0,"Missing",[ARR_Type]) In ("Missing","None","VT/VF","Heart Block","Afib/Flutter"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([ARR_Type] & "")=0,"Missing",[ARR_Type]) In ("Missing","None","VT/VF","Heart Block","Afib/Flutter"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([ANGINA_TYPE] & "")=0,"Missing",[ANGINA_TYPE]) In ("Missing","No Angina","Stable","Unstable"); LVAL *J((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CARDIOPLEGIA] & "")=0,"Missing",IIf([CARDIOPLEGIA]="No","No*",[CARDIOPLEGIA])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CARD_SHK] & "")=0,"Missing",IIf([CARD_SHK]="No","No*",[CARD_SHK])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CARD_SHK] & "")=0,"Missing",IIf([CARD_SHK]="No","No*",[CARD_SHK])) In ("Missing","No*","Yes"); Vz    @ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+WQfJSJY^+WdkfQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+WQfJSJY^+koiUQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+WvfQimQbkYdb+WdkfQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+WvfQimQbkYdb+koiUQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+Y``obdiu+WdkfQ +kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+Y``obdiu+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+fqO+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+fqO+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+hoJimQi+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+hoJimQi+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+iJMQ+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL8+kh+OifmMJLU+iJMQ+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OMWY^O>@6Q+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JUQ+WdkfQ+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JUQ+koiUQ+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JbUYbJ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JbUYbJ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JiiWvmW`YJ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+JiiWvmW`YJ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MJiOYdUQbYM+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MJiOYdUQbYM+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MJiOYdf^QUYJ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MJiOYdf^QUYJ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MWS+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MWS+koiU` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+M^O+Wdkf` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+M^O+koiU` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MfLM`L+koiU` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MfLomY^+Wdkf` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MfLomY^+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MiQJmYbYbQ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MiQJmYbYbQ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MqJ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MqJ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MqO+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MqO+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYJLQmQk+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYJLQmQk+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYJ^vkYk+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYJ^vkYk+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYkqQkk+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYkqQkk+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OkmJmok+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OkmJmok+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+QS+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+QS+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+QS`QmWdO+Wdkft`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOLVAL .((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHF] & "")=0,"Missing",IIf([CHF]="No","No*",[CHF])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHF] & "")=0,"Missing",IIf([CHF]="No","No*",[CHF])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CARDIOPLEGIA] & "")=0,"Missing",IIf([CARDIOPLEGIA]="No","No*",[CARDIOPLEGIA])) In ("Missing","Yes","No*"); Nf j*  j L  x  ~ B  ` B $ 0  TrT6Bf&fH T* x8xZ j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@Z 'jrptCABG__IsolatedYesSub26@oMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@Z 'jrptCABG__IsolatedYesSub2@oMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@Z 'jrptCABG__IsolatedYesSub2>@oMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@X 'jrptCABG__IsolatedYesSub2@nMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@X 'jrptCABG__IsolatedYesSub2,@nMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@X 'jrptCABG__IsolatedYesSub2@nMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@X 'jrptCABG__IsolatedYesSub2@mMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@W 'jrptCABG__IsolatedYesSub2:@mMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@W 'jrptCABG__IsolatedYesSub2@mMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@W 'jrptCABG__IsolatedYesSub2*@kMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// OLVAL 0P((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CPBCmb] & "")=0,"Missing",[CPBCmb]) In ("Missing","Planned","Unplanned"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHRLUNGD] & "")=0,"Missing",[CHRLUNGD]) In ("Missing","No","Mild","Moderate","Severe"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CHRLUNGD] & "")=0,"Missing",[CHRLUNGD]) In ("Missing","No","Mild","Moderate","Severe"); xLVAL*  ,(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT CreatRange([Creatinine]) In ("Missing","< 1.0","1.0 to 1.9*","2.0 to 3.9","4.0 to 10.0","> 10.0"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CPBUtil] & "")=0,"Missing",[CPBUtil]) In ("Missing","None","Combination","Full");TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CPBUtil] & "")=0,"Missing",[CPBUtil]) In ("Missing","None","Combination","Full"); LVAL 8X(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVAWHEN] & "")=0,"Missing",[CVAWHEN]) In ("Missing","No CVA","<=2 Weeks",">2 Weeks"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVAWHEN] & "")=0,"Missing",[CVAWHEN]) In ("Missing","No CVA","<=2 Weeks",">2 Weeks"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT CreatRange([Creatinine]) In ("Missing","< 1.0","1.0 to 1.9*","2.0 to 3.9","4.0 to 10.0","> 10.0"); *LVAL. 4(H((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Diabetes] & "")=0,"Missing",IIf([Diabetes]="No","No*",[Diabetes])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVD] & "")=0,"Missing",IIf([CVD]="No","No*",[CVD])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([CVD] & "")=0,"Missing",IIf([CVD]="No","No*",[CVD])) In ("Missing","No*","Yes"); N|^@l p 0  p R  ~ $ B $ d * 6 T6v<HfHNZ0xZj Gj@h 'jrptCABG__IsolatedYesSub26@wMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@h 'jrptCABG__IsolatedYesSub2@wMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@^ 'jrptCABG__IsolatedYesSub2@vMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@^ 'jrptCABG__IsolatedYesSub2Z@vMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@^ 'jrptCABG__IsolatedYesSub2@vMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@^ 'jrptCABG__IsolatedYesSub2H@sMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@] 'jrptCABG__IsolatedYesSub2@sMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@] 'jrptCABG__IsolatedYesSub2H@sMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@] 'jrptCABG__IsolatedYesSub2@pMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@] 'jrptCABG__IsolatedYesSub2*@pMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@Z 'jrptCABG__IsolatedYesSub2@pMA 76[u @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @_7_8_9_:_;_6_<_>_?_@_A_B_C_=_D_F_G_H_I_J_E_K_Mlllll_Lllll l l ll lllllll llllllllllll l!l"ll#l%l&l'l(l)l*l$l+l-l.l/l0l1l,l2l4l5l6l7l8l9l3l:l<l=l>l?l@l;lAlClDlElFlGlHlBlIlKlLlMqqlJqqqqqqq qq q q qqqq qqqqqqqqqqqqqqqxLVAL  t((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Dialysis] & "")=0,"Missing",IIf([Dialysis]="No","No*",[Dialysis])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Dialysis] & "")=0,"Missing",IIf([Dialysis]="No","No*",[Dialysis])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([Diabetes] & "")=0,"Missing",IIf([Diabetes]="No","No*",[Diabetes])) In ("Missing","Yes","No*"); O$9 N JLi IGDC%8KQ@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Incidenc_Hosp`X4MR2KeepLocal T @Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_IMMUNORX_Surg`X4MR2KeepLocal T @zQ@zQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_IMMUNORX_Hosp`X4MR2KeepLocal T @_Q@_Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_IMAUsed_Hosp`X4MR2KeepLocal T @&{Q@&{Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Hypertension_Surg`X4MR2KeepLocal T @LQ@LQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_HEPAFAIL_Surg`X4MR2KeepLocal T @ PQ@PQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_HEPAFAIL_Hosp`X4MR2KeepLocal T @ ޝQ@ޝQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_HDEFDone_Surg`X4MR2KeepLocal T @ &Q@&Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Gender_Surg`X4MR2KeepLocal T @ &Q@&Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Gender_Hosp`X4MR2KeepLocal T @&{Q@&{Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_EFMethod_Hosp`X4MR2KeepLocal T @ޅQ@ޅQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_EF_Surg`X4MR2KeepLocal T @ޅQ@ޅQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_EF_Hosp`X4MR2KeepLocal T @ KQ@KQ@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_DStatus_Hosp`X4MR2KeepLocal T @Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_DisVess_Surg`X4MR2KeepLocal T @3Q@3Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_DisVess_Hosp`X4MR2KeepLocal T @ Q@Q@~sq_drptCABG__IsolatedYesSub2~sq_drptCABG_Dialysis_Hosp`X4MR2KeepLocal T @r @ @ @ @ @ @ @ @ @ @ @ @ @ @q q"q#q$q%q&q'q!q(q*q+q,q-q.q)q/q1q2q3q4q5q6q0q7q9q:q;q<q=q8q>q@qAqBqCqDqEq?qFqHqIqJqKqLqGqMxxxxxxxxx x x x x xxxxxxxxx x x x x x x x x x x x! x" x# x$ x x% x' x( x) x* x+ x& x, x. x/ x0 x1 x2 x3 x- x4 x6 x7 x8 x9 x: x5x;x=x>x?x@xAxBx<xCxExFxGxHxIxDxJxLxM}}}}xK}}}}} } }} } }}}}}} }}}}}}}}}}}}} }!}}"}$}%}&}'}(}#})}+},}-}.}/}0}*}1}3}4}5}6}7}2}8}:};}<}=}>}?}9}@}B}C}D}E}F}A}G}I}J}K}L}H  }*LVAL Rr((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DStatus] & "")=0,"Missing",[DStatus]) In ("Missing","Alive","Dead"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DIS_VESS] & "")=0,"Missing",[DIS_VESS]) In ("Missing","None","Single","Double","Triple","Quadruple +"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DIS_VESS] & "")=0,"Missing",[DIS_VESS]) In ("Missing","None","Single","Double","Triple","Quadruple +");  LVAL (<((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len(EjectRange([EF]) & "")=0,"Missing",EjectRange([EF])) In ("Missing","< 20%","20% to 29%","30% to 39%","40% to 49%","50% or more*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len(EjectRange([EF]) & "")=0,"Missing",EjectRange([EF])) In ("Missing","< 20%","20% to 29%","30% to 39%","40% to 49%","50% or more*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([DStatus] & "")=0,"Missing",[DStatus]) In ("Missing","Alive","Dead"); Nl,lN Z 0  ~ > ~ ` $ l B $  P 2 r6~T6bDHfH*tVZxZ<__txtHospitalID/// O__txtSurgeonID--- O  G@m 'rptCABG__IsolatedYesSub2@|MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@k 'rptCABG__IsolatedYesSub2F@|MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G j@k ' jrptCABG__IsolatedYesSub2@|MA 7  j G j__txtIsolatedCABG333 O j__txtHospitalID/// O j  j G j@k ' jrptCABG__IsolatedYesSub2H@{MA 7  j G j__txtIsolatedCABG333 O j__txtHospitalID/// O j__txtSurgeonID--- O j  j G j@k ' jrptCABG__IsolatedYesSub2@{MA 7  j G j__txtIsolatedCABG333 O j__txtHospitalID/// O j  j G j@i ' jrptCABG__IsolatedYesSub2f@{MA 7  j G j__txtIsolatedCABG333 O j__txtHospitalID/// O j__txtSurgeonID--- O j  j G j@i ' jrptCABG__IsolatedYesSub2@yMA 7  j G j__txtIsolatedCABG333 O j__txtHospitalID/// O j  j Gj@i 'jrptCABG__IsolatedYesSub2L@yMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj j Gj@i 'jrptCABG__IsolatedYesSub2@yMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj j Gj@h 'jrptCABG__IsolatedYesSub2@wMA 7 j Gj__txtIsolatedCABG333 Oj__txtHospitalID/// Oj__txtSurgeonID--- Oj LVAL <((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([SEX] & "")=0,"Missing",[SEX]) PIVOT IIf(Len([SEX] & "")=0,"Missing",[SEX]) In ("Missing","Female","Male"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([EF_Type] & "")=0,"Missing",[EF_Type]) In ("Missing","None","LV Gram","Radionuclide","Estimate"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([EF_Type] & "")=0,"Missing",[EF_Type]) In ("Missing","None","LV Gram","Radionuclide","Estimate"); j@     +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+M^O+Wdkf` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+M^O+koiU` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MfLM`L+koiU` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MfLomY^+Wdkf` +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MfLomY^+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MiQJmYbYbQ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MiQJmYbYbQ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MqJ+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MqJ+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MqO+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+MqO+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYJLQmQk+Wdkf`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYJLQmQk+koiU`+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYJ^vkYk+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYJ^vkYk+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYkqQkk+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OYkqQkk+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OkmJmok+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+OkmJmok+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+QS+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+QS+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+QS`QmWdO+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+QS`QmWdO+koiUt +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+UQbOQi+Wdkft +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+UQbOQi+koiUt +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+WOQSOdbQ+Wdkft +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+WOQSOdbQ+koiUt +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+WQfJSJY^+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+WQfJSJY^+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+WvfQimQbkYdb+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+WvfQimQbkYdb+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+Y`JokQO+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+Y`JokQO+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+Y``obdiu+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+Y``obdiu+koiUt+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+YbMYOQbM+Wdkft+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+YbMYOQbM+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+^`k+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+^`k+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+`Y+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+`Y+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+`YmiJ^+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+`YmiJ^+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+bvWJ+Wdkf+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+bvWJ+koiU+kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+fMY+Wdkf +kh+OifmMJLU++Ykd^JmQOvQkkoL:+kh+OifmMJLU+fMY+koiU `kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkJMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQOZLVAL bVv((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HDEFDone] & "")=0,"Missing",IIf([HDEFDone]="No","No*",[HDEFDone])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HDEFDone] & "")=0,"Missing",IIf([HDEFDone]="No","No*",[HDEFDone])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) ORDER BY IIf(Len([SEX] & "")=0,"Missing",[SEX]) PIVOT IIf(Len([SEX] & "")=0,"Missing",[SEX]) In ("Missing","Female","Male"); LVAL d((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HTN] & "")=0,"Missing",IIf([HTN]="No","No*",[HTN])) In ("Missing","No*","Yes"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HepaFail] & "")=0,"Missing",IIf([HepaFail]="No","No*",[HepaFail])) In ("Missing","Yes","No*");TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HepaFail] & "")=0,"Missing",IIf([HepaFail]="No","No*",[HepaFail])) In ("Missing","No*","Yes");TMHfH N  Z 0  x Z ` $ l B $  lr6~T6~$HfH*6 Z  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@o 'rptCABG__IsolatedYesSub2$@MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@o 'rptCABG__IsolatedYesSub2j@MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@n 'rptCABG__IsolatedYesSub2@MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@n 'rptCABG__IsolatedYesSub2z@MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@n 'rptCABG__IsolatedYesSub2"@MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@n 'rptCABG__IsolatedYesSub2H@MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@n 'rptCABG__IsolatedYesSub2@MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@m 'rptCABG__IsolatedYesSub2,@~MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O__txtSurgeonID--- O  G@m 'rptCABG__IsolatedYesSub2@~MA 7  G__txtIsolatedCABG333 O__txtHospitalID/// O  G@m 'rptCABG__IsolatedYesSub2*@~MA 7  G__txtIsolatedCABG333 OLVAL @`((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMA] & "")=0,"Missing",[IMA]) In ("Missing","Left IMA","Right IMA","Both IMAs"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMA] & "")=0,"Missing",[IMA]) In ("Missing","Left IMA","Right IMA","Both IMAs"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([HTN] & "")=0,"Missing",IIf([HTN]="No","No*",[HTN])) In ("Missing","Yes","No*"); TLVAL  2RFfZz((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)((([__txtSurgeonID] = SurgeonID)) AND ([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)(([__txtHospitalID] = HospitalID)) AND ([__txtIsolatedCABG] = IsolatedCABG)TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, tblSurgery.SurgeonID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) PIVOT IIf(Len([IMMUNORX] & "")=0,"Missing",IIf([IMMUNORX]="No","No*",[IMMUNORX])) In ("Missing","Yes","No*"); TRANSFORM Count(tblSurgery.SurgeryID) AS HospEntityCount SELECT tblSurgery.HospitalID, IIf(Len([ISOCABG] & "")=0,"Missing",[ISOCABG]) AS IsolatedCABG, Count(tblSurgery.SurgeryID) AS Total FROM tblSurgery WHERE (((tblSurgery.DISCHARGE) Between DateStrParse(ReportFromDateGet()) And DateStrParse(ReportToDateGet()))) GROUP BY tblSurgery.HospitalID, IIf(Len([ISOCABG]