58. EPMO Open Source Coordination Office Redaction File Detail Report

Produced by Araxis Merge on 9/11/2017 8:05:40 AM Central Daylight Time. See www.araxis.com for information about Merge. This report uses XHTML and CSS2, and is best viewed with a modern standards-compliant browser. For optimum results when printing this report, use landscape orientation and enable printing of background images and colours in your browser.

58.1 Files compared

# Location File Last Modified
1 MHV_CIF_2017.4.0.0.zip\MHV_CIF_2017.4.0.0\MHV_CIF_2017.4.0.0\sms_main\sms_source\mhv_sms_ng\mhv-sm-domain\src\main\java\gov\va\med\mhv\sm\dao ReportsDao.java Sat May 13 00:13:58 2017 UTC
2 MHV_CIF_2017.4.0.0.zip\MHV_CIF_2017.4.0.0\MHV_CIF_2017.4.0.0\sms_main\sms_source\mhv_sms_ng\mhv-sm-domain\src\main\java\gov\va\med\mhv\sm\dao ReportsDao.java Thu Sep 7 19:19:23 2017 UTC

58.2 Comparison summary

Description Between
Files 1 and 2
Text Blocks Lines
Unchanged 2 368
Changed 1 2
Inserted 0 0
Removed 0 0

58.3 Comparison options

Whitespace
Character case Differences in character case are significant
Line endings Differences in line endings (CR and LF characters) are ignored
CR/LF characters Not shown in the comparison detail

58.4 Active regular expressions

No regular expressions were active.

58.5 Comparison detail

  1   /**
  2    * 
  3    */
  4   package go v.va.med.m hv.sm.dao;
  5  
  6   import gov .va.med.mh v.foundati on.dao.Bas eDao;
  7  
  8   import jav a.util.Dat e;
  9   import jav a.util.Lis t;
  10  
  11   /**
  12    * @author   DNS     MCCARW
  13    *
  14    */
  15   public int erface Rep ortsDao ex tends Base Dao{
  16           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_FOR_ALL_ TEAMS_BY_O NE_FACILIT Y = "QryGe tCountRepo rtsDataFor AllTeamsBy OneFacilit y";
  17           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_FOR_ONE_ TEAM_AND_O NE_FACILIT Y = "QryGe tCountRepo rtsDataFor OneTeamAnd OneFacilit y";
  18           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_FOR_ALL_ FACILITIES _BY_ONE_VI SN = "QryG etCountRep ortsDataFo rAllFacili tiesByOneV isn";
  19           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_FOR_ONE_ FACILITY_A ND_ONE_VIS N = "QryGe tCountRepo rtsDataFor OneFacilit yAndOneVis n";
  20           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_FOR_ALL_ VISNS = "Q ryGetCount ReportsDat aForAllVis ns";
  21           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_FOR_ONE_ VISN = "Qr yGetCountR eportsData ForOneVisn ";
  22           
  23           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_P ATIENT_SEN DERS_FOR_A LL_TEAMS_B Y_ONE_FACI LITY = "Qr yGetCountR eportsData UniquePati entSenders ForAllTeam sByOneFaci lity";
  24           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_P ATIENT_SEN DERS_FOR_O NE_TEAM_AN D_ONE_FACI LITY = "Qr yGetCountR eportsData UniquePati entSenders ForOneTeam AndOneFaci lity";
  25           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_P ATIENT_SEN DERS_FOR_A LL_FACILIT IES_BY_ONE _VISN = "Q ryGetCount ReportsDat aUniquePat ientSender sForAllFac ilitiesByO neVisn";
  26           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_P ATIENT_SEN DERS_FOR_O NE_FACILIT Y_AND_ONE_ VISN = "Qr yGetCountR eportsData UniquePati entSenders ForOneFaci lityAndOne Visn";
  27           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_P ATIENT_SEN DERS_FOR_A LL_VISNS =  "QryGetCo untReports DataUnique PatientSen dersForAll Visns";
  28           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_P ATIENT_SEN DERS_FOR_O NE_VISN =  "QryGetCou ntReportsD ataUniqueP atientSend ersForOneV isn";
  29  
  30           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_M EMBER_SEND ERS_FOR_AL L_TEAMS_BY _ONE_FACIL ITY = "Qry GetCountRe portsDataU niqueMembe rSendersFo rAllTeamsB yOneFacili ty";
  31           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_M EMBER_SEND ERS_FOR_ON E_TEAM_AND _ONE_FACIL ITY = "Qry GetCountRe portsDataU niqueMembe rSendersFo rOneTeamAn dOneFacili ty";
  32           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_M EMBER_SEND ERS_FOR_AL L_FACILITI ES_BY_ONE_ VISN = "Qr yGetCountR eportsData UniqueMemb erSendersF orAllFacil itiesByOne Visn";
  33           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_M EMBER_SEND ERS_FOR_ON E_FACILITY _AND_ONE_V ISN = "Qry GetCountRe portsDataU niqueMembe rSendersFo rOneFacili tyAndOneVi sn";
  34           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_M EMBER_SEND ERS_FOR_AL L_VISNS =  "QryGetCou ntReportsD ataUniqueM emberSende rsForAllVi sns";
  35           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_UNIQUE_M EMBER_SEND ERS_FOR_ON E_VISN = " QryGetCoun tReportsDa taUniqueMe mberSender sForOneVis n";
  36  
  37           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_IN _PATIENTS_ FOR_ALL_TE AMS_BY_ONE _FACILITY  = "QryGetC ountReport sDataOpted InPatients ForAllTeam sByOneFaci lity";
  38           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_IN _PATIENTS_ FOR_ONE_TE AM_AND_ONE _FACILITY  = "QryGetC ountReport sDataOpted InPatients ForOneTeam AndOneFaci lity";
  39           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_IN _PATIENTS_ FOR_ALL_FA CILITIES_B Y_ONE_VISN  ="QryGetC ountReport sDataOpted InPatients ForAllFaci litiesByOn eVisn";
  40           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_IN _PATIENTS_ FOR_ONE_FA CILITY_AND _ONE_VISN  = "QryGetC ountReport sDataOpted InPatients ForOneFaci lityAndOne Visn";
  41           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_IN _PATIENTS_ FOR_ALL_VI SNS = "Qry GetCountRe portsDataO ptedInPati entsForAll Visns";
  42           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_IN _PATIENTS_ FOR_ONE_VI SN = "QryG etCountRep ortsDataOp tedInPatie ntsForOneV isn";
  43  
  44           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_BLOCKED_ PATIENTS_F OR_ALL_TEA MS_BY_ONE_ FACILITY =  "QryGetCo untReports DataBlocke dPatientsF orAllTeams ByOneFacil ity";
  45           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_BLOCKED_ PATIENTS_F OR_ONE_TEA M_AND_ONE_ FACILITY =  "QryGetCo untReports DataBlocke dPatientsF orOneTeamA ndOneFacil ity";
  46           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_BLOCKED_ PATIENTS_F OR_ALL_FAC ILITIES_BY _ONE_VISN  ="QryGetCo untReports DataBlocke dPatientsF orAllFacil itiesByOne Visn";
  47           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_BLOCKED_ PATIENTS_F OR_ONE_FAC ILITY_AND_ ONE_VISN =  "QryGetCo untReports DataBlocke dPatientsF orOneFacil ityAndOneV isn";
  48           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_BLOCKED_ PATIENTS_F OR_ALL_VIS NS = "QryG etCountRep ortsDataBl ockedPatie ntsForAllV isns";
  49           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_BLOCKED_ PATIENTS_F OR_ONE_VIS N = "QryGe tCountRepo rtsDataBlo ckedPatien tsForOneVi sn";
  50           
  51           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_OU T_PATIENTS _FOR_ALL_T EAMS_BY_ON E_FACILITY  = "QryGet CountRepor tsDataOpte dOutPatien tsForAllTe amsByOneFa cility";
  52           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_OU T_PATIENTS _FOR_ONE_T EAM_AND_ON E_FACILITY  = "QryGet CountRepor tsDataOpte dOutPatien tsForOneTe amAndOneFa cility";
  53           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_OU T_PATIENTS _FOR_ALL_F ACILITIES_ BY_ONE_VIS N ="QryGet CountRepor tsDataOpte dOutPatien tsForAllFa cilitiesBy OneVisn";
  54           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_OU T_PATIENTS _FOR_ONE_F ACILITY_AN D_ONE_VISN  = "QryGet CountRepor tsDataOpte dOutPatien tsForOneFa cilityAndO neVisn";
  55           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_OU T_PATIENTS _FOR_ALL_V ISNS = "Qr yGetCountR eportsData OptedOutPa tientsForA llVisns";
  56           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_OPTED_OU T_PATIENTS _FOR_ONE_V ISN = "Qry GetCountRe portsDataO ptedOutPat ientsForOn eVisn";
  57  
  58           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_ACTION_P ENDING_PAT IENTS_FOR_ ALL_TEAMS_ BY_ONE_FAC ILITY = "Q ryGetCount ReportsDat aActionPen dingPatien tsForAllTe amsByOneFa cility";
  59           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_ACTION_P ENDING_PAT IENTS_FOR_ ONE_TEAM_A ND_ONE_FAC ILITY = "Q ryGetCount ReportsDat aActionPen dingPatien tsForOneTe amAndOneFa cility";
  60           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_ACTION_P ENDING_PAT IENTS_FOR_ ALL_FACILI TIES_BY_ON E_VISN ="Q ryGetCount ReportsDat aActionPen dingPatien tsForAllFa cilitiesBy OneVisn";
  61           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_ACTION_P ENDING_PAT IENTS_FOR_ ONE_FACILI TY_AND_ONE _VISN = "Q ryGetCount ReportsDat aActionPen dingPatien tsForOneFa cilityAndO neVisn";
  62           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_ACTION_P ENDING_PAT IENTS_FOR_ ALL_VISNS  = "QryGetC ountReport sDataActio nPendingPa tientsForA llVisns";
  63           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_ACTION_P ENDING_PAT IENTS_FOR_ ONE_VISN =  "QryGetCo untReports DataAction PendingPat ientsForOn eVisn";
  64  
  65           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_EDUCATIO N_CATEGORY _FOR_ALL_T EAMS_BY_ON E_FACILITY  = "QryGet CountRepor tsDataEduc ationCateg oryForAllT eamsByOneF acility";
  66           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_EDUCATIO N_CATEGORY _FOR_ONE_T EAM_AND_ON E_FACILITY  = "QryGet CountRepor tsDataEduc ationCateg oryForOneT eamAndOneF acility";
  67           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_EDUCATIO N_CATEGORY _FOR_ALL_F ACILITIES_ BY_ONE_VIS N ="QryGet CountRepor tsDataEduc ationCateg oryForAllF acilitiesB yOneVisn";
  68           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_EDUCATIO N_CATEGORY _FOR_ONE_F ACILITY_AN D_ONE_VISN  = "QryGet CountRepor tsDataEduc ationCateg oryForOneF acilityAnd OneVisn";
  69           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_EDUCATIO N_CATEGORY _FOR_ALL_V ISNS = "Qr yGetCountR eportsData EducationC ategoryFor AllVisns";
  70           pu blic stati c final St ring QRY_G ET_COUNT_R EPORTS_DAT A_EDUCATIO N_CATEGORY _FOR_ONE_V ISN = "Qry GetCountRe portsDataE ducationCa tegoryForO neVisn";
  71           
  72           
  73           pu blic stati c final St ring QRY_G ET_LISTS_H EALTHCARE_ TEAMS_DATA _FOR_ALL_F ACILITIES_ BY_ONE_VIS N= "QryHea lthCareTea msListForA llFaciliti esByOneVis n";
  74           pu blic stati c final St ring QRY_G ET_LISTS_H EALTHCARE_ TEAMS_DATA _FOR_ONE_F ACILITY= " QryHealthC areTeamsLi stForOneFa cility";
  75           pu blic stati c final St ring QRY_G ET_LISTS_H EALTHCARE_ TEAMS_DATA _FOR_ONE_T EAM= "QryH ealthCareT eamsListFo rOneTeam";
  76           pu blic stati c final St ring QRY_G ET_LISTS_H EALTHCARE_ TEAMS_DATA _FOR_ALL_T EAMS_BY_ON E_FACILITY = "QryHeal thCareTeam sListForAl lTeamsByOn eFacility" ;
  77           
  78           
  79           
  80           pu blic stati c final St ring QRY_G ET_LISTS_H EALTHCARE_ TEAMMEMBER S_DATA_FOR _ONE_TEAM=  "QryHealt hCareTeamM embersForO neTeam";
  81           pu blic stati c final St ring QRY_G ET_LISTS_H EALTHCARE_ TEAMMEMBER S_DATA_FOR _ALL_TEAMS _BY_ONE_FA CILITY= "Q ryHealthCa reTeamMemb ersForAllT eamsByOneF acility";
  82           pu blic stati c final St ring QRY_G ET_LISTS_B LOCKED_PAT IENTS_DATA _FOR_ONE_T EAM= "QryB lockedPati entsListFo rOneTeam";
  83           pu blic stati c final St ring QRY_G ET_LISTS_B LOCKED_PAT IENTS_DATA _FOR_ALL_T EAMS_BY_ON E_FACILITY = "QryBloc kedPatient sListForAl lTeamsByOn eFacility" ;
  84           pu blic stati c final St ring QRY_G ET_LISTS_B LOCKED_PAT IENTS_DATA _FOR_ALL_F ACILTIES_B Y_ONE_VISN = "QryBloc kedPatient sListForAl lFacilitie sByOneVisn ";
  85           pu blic stati c final St ring QRY_G ET_LISTS_B LOCKED_PAT IENTS_DATA _FOR_ONE_F ACILITY= " QryBlocked PatientsLi stForOneFa cility";
  86           
  87           
  88           pu blic stati c final St ring QRY_G ET_LISTS_O PTED_IN_PA TIENTS_DAT A_FOR_ONE_ TEAM= "Qry OptedInPat ientsListF orOneTeam" ;
  89           pu blic stati c final St ring QRY_G ET_LISTS_O PTED_IN_PA TIENTS_DAT A_FOR_ALL_ TEAMS_BY_O NE_FACILIT Y= "QryOpt edInPatien tsListForA llTeamsByO neFacility ";
  90           pu blic stati c final St ring QRY_G ET_LISTS_O PTED_OUT_P ATIENTS_DA TA_FOR_ONE _TEAM= "Qr yOptedOutP atientsLis tForOneTea m";
  91           pu blic stati c final St ring QRY_G ET_LISTS_O PTED_OUT_P ATIENTS_DA TA_FOR_ALL _TEAMS_BY_ ONE_FACILI TY= "QryOp tedOutPati entsListFo rAllTeamsB yOneFacili ty";
  92           pu blic stati c final St ring QRY_G ET_LISTS_A CTION_PEND ING_PATIEN TS_DATA_FO R_ONE_TEAM = "QryActi onPendingP atientsLis tForOneTea m";
  93           pu blic stati c final St ring QRY_G ET_LISTS_A CTION_PEND ING_PATIEN TS_DATA_FO R_ALL_TEAM S_BY_ONE_F ACILITY= " QryActionP endingPati entsListFo rAllTeamsB yOneFacili ty";
  94           pu blic stati c final St ring QRY_G ET_LISTS_A SSOCIATED_ PATIENTS_D ATA_FOR_ON E_TEAM= "Q ryAssociat edPatients ListForOne Team";
  95           pu blic stati c final St ring QRY_G ET_LISTS_A SSOCIATED_ PATIENTS_D ATA_FOR_AL L_TEAMS_BY _ONE_FACIL ITY= "QryA ssociatedP atientsLis tAllTeamsB yOneFacili ty";
  96           pu blic stati c final St ring QRY_G ET_LISTS_C PRS_TIU_FA ILURE_DATA _FOR_ONE_T EAM= "QryC PRSTiuFail ureListFor OneTeam";
  97           pu blic stati c final St ring QRY_G ET_LISTS_C PRS_TIU_FA ILURE_DATA _FOR_ALL_T EAMS_BY_ON E_FACILITY = "QryCPRS TiuFailure ListForAll TeamsByOne Facility";
  98           
  99           pu blic stati c final St ring QRY_G ET_LAST_RE PORT_REFRE SH_DATE= " QryLastRep ortDataRef reshDate";
  100           
  101           pu blic List< Object[]>  getCountRe portsDataU niquePatie ntSendersF orAllTeams ByOneFacil ity(Date s tart,Date  end,Long s tationNumb er,String  period);
  102           pu blic List< Object[]>  getCountRe portsDataU niquePatie ntSendersF orOneTeamA ndOneFacil ity(Date s tart,Date  end,Long s tationNumb er,Long tr iageGroupI d,String p eriod);
  103           pu blic List< Object[]>  getCountRe portsDataU niquePatie ntSendersF orAllFacil itiesByOne Visn(Date  start,Date  end,Long  visnId,Str ing period );
  104           pu blic List< Object[]>  getCountRe portsDataU niquePatie ntSendersF orOneFacil ityAndOneV isn(Date s tart,Date  end,Long s tationNumb er,Long vi snId,Strin g period);
  105           pu blic List< Object[]>  getCountRe portsDataU niquePatie ntSendersF orAllVisns (Date star t,Date end ,String pe riod);
  106           pu blic List< Object[]>  getCountRe portsDataU niquePatie ntSendersF orOneVisn( Date start ,Date end, Long visnI d,String p eriod);
  107  
  108           pu blic List< Object[]>  getCountRe portsDataU niqueMembe rSendersFo rAllTeamsB yOneFacili ty(Date st art,Date e nd,Long st ationNumbe r,String p eriod);
  109           pu blic List< Object[]>  getCountRe portsDataU niqueMembe rSendersFo rOneTeamAn dOneFacili ty(Date st art,Date e nd,Long st ationNumbe r,Long tri ageGroupId ,String pe riod);
  110           pu blic List< Object[]>  getCountRe portsDataU niqueMembe rSendersFo rAllFacili tiesByOneV isn(Date s tart,Date  end,Long v isnId,Stri ng period) ;
  111           pu blic List< Object[]>  getCountRe portsDataU niqueMembe rSendersFo rOneFacili tyAndOneVi sn(Date st art,Date e nd,Long st ationNumbe r,Long vis nId,String  period);
  112           pu blic List< Object[]>  getCountRe portsDataU niqueMembe rSendersFo rAllVisns( Date start ,Date end, String per iod);
  113           pu blic List< Object[]>  getCountRe portsDataU niqueMembe rSendersFo rOneVisn(D ate start, Date end,L ong visnId ,String pe riod);
  114           
  115           pu blic List< Object[]>  getCountRe portsDataF orAllTeams ByOneFacil ity(Date s tart,Date  end,Long s tationNumb er,String  period,Lis t<Long> su bCategorie s);
  116           pu blic List< Object[]>  getCountRe portsDataF orOneTeamA ndOneFacil ity(Date s tart,Date  end,Long s tationNumb er,Long tr iageGroupI d,String p eriod,List <Long> sub Categories );
  117           pu blic List< Object[]>  getCountRe portsDataF orAllFacil itiesByOne Visn(Date  start,Date  end,Long  visnId,Str ing period ,List subC ategories) ;
  118           pu blic List< Object[]>  getCountRe portsDataF orOneFacil ityAndOneV isn(Date s tart,Date  end,Long s tationNumb er,Long vi snId,Strin g period,L ist subCat egories);
  119           pu blic List< Object[]>  getCountRe portsDataF orAllVisns (Date star t,Date end ,String pe riod,List  subCategor ies);
  120           pu blic List< Object[]>  getCountRe portsDataF orOneVisn( Date start ,Date end, Long visnI d,String p eriod,List  subCatego ries);
  121           
  122           pu blic List< Object[]>  getCountRe portsDataO ptedInPati entsForAll TeamsByOne Facility(D ate start, Date end,L ong statio nNumber,St ring perio d);
  123           pu blic List< Object[]>  getCountRe portsDataO ptedInPati entsForOne TeamAndOne Facility(D ate start, Date end,L ong statio nNumber,Lo ng triageG roupId,Str ing period );
  124           pu blic List< Object[]>  getCountRe portsDataO ptedInPati entsForAll Facilities ByOneVisn( Date start ,Date end, Long visnI d,String p eriod);
  125           pu blic List< Object[]>  getCountRe portsDataO ptedInPati entsForOne FacilityAn dOneVisn(D ate start, Date end,L ong statio nNumber,Lo ng visnId, String per iod);
  126           pu blic List< Object[]>  getCountRe portsDataO ptedInPati entsForAll Visns(Date  start,Dat e end,Stri ng period) ;
  127           pu blic List< Object[]>  getCountRe portsDataO ptedInPati entsForOne Visn(Date  start,Date  end,Long  visnId,Str ing period );
  128  
  129           pu blic List< Object[]>  getCountRe portsDataB lockedPati entsForAll TeamsByOne Facility(D ate start, Date end,L ong statio nNumber,St ring perio d);
  130           pu blic List< Object[]>  getCountRe portsDataB lockedPati entsForOne TeamAndOne Facility(D ate start, Date end,L ong statio nNumber,Lo ng triageG roupId,Str ing period );
  131           pu blic List< Object[]>  getCountRe portsDataB lockedPati entsForAll Facilities ByOneVisn( Date start ,Date end, Long visnI d,String p eriod);
  132           pu blic List< Object[]>  getCountRe portsDataB lockedPati entsForOne FacilityAn dOneVisn(D ate start, Date end,L ong statio nNumber,Lo ng visnId, String per iod);
  133           pu blic List< Object[]>  getCountRe portsDataB lockedPati entsForAll Visns(Date  start,Dat e end,Stri ng period) ;
  134           pu blic List< Object[]>  getCountRe portsDataB lockedPati entsForOne Visn(Date  start,Date  end,Long  visnId,Str ing period );
  135  
  136           pu blic List< Object[]>  getCountRe portsDataO ptedOutPat ientsForAl lTeamsByOn eFacility( Date start ,Date end, Long stati onNumber,S tring peri od);
  137           pu blic List< Object[]>  getCountRe portsDataO ptedOutPat ientsForOn eTeamAndOn eFacility( Date start ,Date end, Long stati onNumber,L ong triage GroupId,St ring perio d);
  138           pu blic List< Object[]>  getCountRe portsDataO ptedOutPat ientsForAl lFacilitie sByOneVisn (Date star t,Date end ,Long visn Id,String  period);
  139           pu blic List< Object[]>  getCountRe portsDataO ptedOutPat ientsForOn eFacilityA ndOneVisn( Date start ,Date end, Long stati onNumber,L ong visnId ,String pe riod);
  140           pu blic List< Object[]>  getCountRe portsDataO ptedOutPat ientsForAl lVisns(Dat e start,Da te end,Str ing period );
  141           pu blic List< Object[]>  getCountRe portsDataO ptedOutPat ientsForOn eVisn(Date  start,Dat e end,Long  visnId,St ring perio d);
  142  
  143           pu blic List< Object[]>  getCountRe portsDataA ctionPendi ngPatients ForAllTeam sByOneFaci lity(Date  start,Date  end,Long  stationNum ber,String  period);
  144           pu blic List< Object[]>  getCountRe portsDataA ctionPendi ngPatients ForOneTeam AndOneFaci lity(Date  start,Date  end,Long  stationNum ber,Long t riageGroup Id,String  period);
  145           pu blic List< Object[]>  getCountRe portsDataA ctionPendi ngPatients ForAllFaci litiesByOn eVisn(Date  start,Dat e end,Long  visnId,St ring perio d);
  146           pu blic List< Object[]>  getCountRe portsDataA ctionPendi ngPatients ForOneFaci lityAndOne Visn(Date  start,Date  end,Long  stationNum ber,Long v isnId,Stri ng period) ;
  147           pu blic List< Object[]>  getCountRe portsDataA ctionPendi ngPatients ForAllVisn s(Date sta rt,Date en d,String p eriod);
  148           pu blic List< Object[]>  getCountRe portsDataA ctionPendi ngPatients ForOneVisn (Date star t,Date end ,Long visn Id,String  period);
  149  
  150           pu blic List< Object[]>  getCountRe portsDataE ducationCa tegoryForA llTeamsByO neFacility (Date star t,Date end ,Long stat ionNumber, String per iod);
  151           pu blic List< Object[]>  getCountRe portsDataE ducationCa tegoryForO neTeamAndO neFacility (Date star t,Date end ,Long stat ionNumber, Long triag eGroupId,S tring peri od);
  152           pu blic List< Object[]>  getCountRe portsDataE ducationCa tegoryForA llFaciliti esByOneVis n(Date sta rt,Date en d,Long vis nId,String  period);
  153           pu blic List< Object[]>  getCountRe portsDataE ducationCa tegoryForO neFacility AndOneVisn (Date star t,Date end ,Long stat ionNumber, Long visnI d,String p eriod);
  154           pu blic List< Object[]>  getCountRe portsDataE ducationCa tegoryForA llVisns(Da te start,D ate end,St ring perio d);
  155           pu blic List< Object[]>  getCountRe portsDataE ducationCa tegoryForO neVisn(Dat e start,Da te end,Lon g visnId,S tring peri od);
  156  
  157           
  158           
  159           
  160           pu blic List< Object[]>  getListsHe althcareTe amsDataFor AllFacilit iesByOneVi sn(Long vi snId);
  161           pu blic List< Object[]>  getListsHe althcareTe amsDataFor OneFacilit y(Long sta tionNumber );    
  162           pu blic List< Object[]>  getListsHe althcareTe amsDataFor OneTeam(Lo ng triageG roupId);
  163           pu blic List< Object[]>  getListsHe althcareTe amsDataFor AllTeamsBy OneFacilit y(Long sta tionNumber );
  164           
  165           
  166           pu blic List< Object[]>  getListsHe althcareTe amMembersD ataForOneT eam(Long t riageGroup Id);
  167           pu blic List< Object[]>  getListsHe althcareTe amMembersD ataForAllT eamsByOneF acility(Lo ng station Number);
  168           pu blic List< Object[]>  getListsBl ockedPatie ntsDataFor OneTeam(Lo ng triageG roupId);
  169           pu blic List< Object[]>  getListsBl ockedPatie ntsDataFor AllTeamsBy OneFacilit y(Long sta tionNumber );
  170           pu blic List< Object[]>  getListsBl ockedPatie ntsDataFor AllFacilit iesByOneVi sn(Long vi snId);
  171           pu blic List< Object[]>  getListsBl ockedPatie ntsDataFor OneFacilit y(Long sta tionNumber );
  172           
  173           pu blic List< Object[]>  getListsOp tedInPatie ntsDataFor OneTeam(Lo ng triageG roupId);
  174           pu blic List< Object[]>  getListsOp tedInPatie ntsDataFor AllTeamsBy OneFacilit y(Long sta tionNumber );
  175           pu blic List< Object[]>  getListsOp tedOutPati entsDataFo rOneTeam(L ong triage GroupId);
  176           pu blic List< Object[]>  getListsOp tedOutPati entsDataFo rAllTeamsB yOneFacili ty(Long st ationNumbe r);
  177           pu blic List< Object[]>  getListsAc tionPendin gPatientsD ataForOneT eam(Long t riageGroup Id);
  178           pu blic List< Object[]>  getListsAc tionPendin gPatientsD ataForAllT eamsByOneF acility(Lo ng station Number);
  179           pu blic List< Object[]>  getListsAs sociatedPa tientsData ForOneTeam (Long tria geGroupId) ;
  180           pu blic List< Object[]>  getListsAs sociatedPa tientsData ForAllTeam sByOneFaci lity(Long  stationNum ber);
  181           pu blic List< Object[]>  getListsCP RSTiuFailu reDataForO neTeam(Lon g triageGr oupId);
  182           pu blic List< Object[]>  getListsCP RSTiuFailu reDataForA llTeamsByO neFacility (Long stat ionNumber) ;
  183           pu blic List  getLastRep ortDataRef reshDate() ;
  184           
  185   }