tmpAttesa().selstring=[select DEA00F.CODENT, DEA00F.CODOSP, DEA00F.PROGRE, case when CODTRG in (1, 2, 3, 4, 7) then CODTRG when CODTRG in (6, 5) then 1 else 0 end as COLORE, DATACC, ORAACC, value(DATCAR, 0), value(ORACAR, 0) from DEA00F left join DEA02F on DEA00F.CODENT = DEA02F.CODENT and DEA00F.CODOSP = DEA02F.CODOSP and DEA00F.PROGRE = DEA02F.PROGRE left join DEAOBI0F on DEA00F.CODENT = DEAOBI0F.CODENT and DEA00F.CODOSP = DEAOBI0F.CODOSP and DEA00F.PROGRE = DEAOBI0F.PROGRE where DEA00F.FLGANN <> 'A' and DEA00F.CODENT = 10 and DEA00F.CODOSP = 1 and DEA00F.PSINVI = 1 and DEA00F.FLA002 <> 'D' and DEA00F.SNVIUR <> 'S' and value(DEAOBI0F.ESIOBI, 0) = 0 order by COLORE desc]
CODOSP=[1], PROGRE=[20250022041], DATCAR=[20250917], DATACC=[20250917], mtot=[108], rcnt=[1]
CODOSP=[1], PROGRE=[20250022073], DATCAR=[20250917], DATACC=[20250917], mtot=[144], rcnt=[2]
CODOSP=[1], PROGRE=[20250022089], DATCAR=[20250917], DATACC=[20250917], mtot=[147], rcnt=[3]
CODOSP=[1], PROGRE=[20250022099], DATCAR=[20250917], DATACC=[20250917], mtot=[155], rcnt=[4]
CODOSP=[1], PROGRE=[20250022103], DATCAR=[20250918], DATACC=[20250917], mtot=[279], rcnt=[5]
CODOSP=[1], PROGRE=[20250022111], DATCAR=[20250918], DATACC=[20250918], mtot=[284], rcnt=[6]
stot=[], mtot=[284], rcnt=[6]
mtot = [47]
dtot(min) = [47]
stot = [00:00:47:00]
we survived calcStrAtt()
CODOSP=[1], PROGRE=[20250022104], DATCAR=[20250918], DATACC=[20250917], mtot=[144], rcnt=[1]
CODOSP=[1], PROGRE=[20250022109], DATCAR=[20250918], DATACC=[20250918], mtot=[193], rcnt=[2]
stot=[00:00:47:00], mtot=[193], rcnt=[2]
mtot = [96]
dtot(ore) = [1]
dtot(min) = [36]
stot = [00:01:36:00]
we survived calcStrAtt()
CODOSP=[1], PROGRE=[20250022106], DATCAR=[20250918], DATACC=[20250917], mtot=[145], rcnt=[1]
stot=[00:01:36:00], mtot=[145], rcnt=[1]
mtot = [145]
dtot(ore) = [2]
dtot(min) = [25]
stot = [00:02:25:00]
we survived calcStrAtt()
CODOSP=[1], PROGRE=[20250022113], DATCAR=[20250918], DATACC=[20250918], mtot=[28], rcnt=[1]
mtot = [28]
dtot(min) = [28]
stot = [00:02:28:00]
Pronto Soccorso Portogruaro
Totale pazienti : 10
| CODICE BIANCO |
CODICE VERDE |
CODICE GIALLO |
CODICE ARANCIO |
CODICE ROSSO |
IN ATTESA
0
IN AMBULATORIO
1
|
IN ATTESA
0
IN AMBULATORIO
1
|
IN ATTESA
0
IN AMBULATORIO
2
|
IN ATTESA
0
IN AMBULATORIO
6
|
IN ATTESA
0
IN AMBULATORIO
0
|
tmpAttesa().selstring=[select DEA00F.CODENT, DEA00F.CODOSP, DEA00F.PROGRE, case when CODTRG in (1, 2, 3, 4, 7) then CODTRG when CODTRG in (6, 5) then 1 else 0 end as COLORE, DATACC, ORAACC, value(DATCAR, 0), value(ORACAR, 0) from DEA00F left join DEA02F on DEA00F.CODENT = DEA02F.CODENT and DEA00F.CODOSP = DEA02F.CODOSP and DEA00F.PROGRE = DEA02F.PROGRE left join DEAOBI0F on DEA00F.CODENT = DEAOBI0F.CODENT and DEA00F.CODOSP = DEAOBI0F.CODOSP and DEA00F.PROGRE = DEAOBI0F.PROGRE where DEA00F.FLGANN <> 'A' and DEA00F.CODENT = 10 and DEA00F.CODOSP = 2 and DEA00F.PSINVI = 1 and DEA00F.FLA002 <> 'D' and DEA00F.SNVIUR <> 'S' and value(DEAOBI0F.ESIOBI, 0) = 0 order by COLORE desc]
CODOSP=[2], PROGRE=[20250036337], DATCAR=[20250916], DATACC=[20250916], mtot=[81], rcnt=[2]
CODOSP=[2], PROGRE=[20250036344], DATCAR=[20250916], DATACC=[20250916], mtot=[180], rcnt=[3]
CODOSP=[2], PROGRE=[20250036407], DATCAR=[20250917], DATACC=[20250917], mtot=[183], rcnt=[4]
CODOSP=[2], PROGRE=[20250036426], DATCAR=[20250917], DATACC=[20250917], mtot=[185], rcnt=[5]
CODOSP=[2], PROGRE=[20250036436], DATCAR=[20250917], DATACC=[20250917], mtot=[213], rcnt=[6]
CODOSP=[2], PROGRE=[20250036444], DATCAR=[20250917], DATACC=[20250917], mtot=[239], rcnt=[7]
CODOSP=[2], PROGRE=[20250036497], DATCAR=[20250917], DATACC=[20250917], mtot=[255], rcnt=[8]
CODOSP=[2], PROGRE=[20250036503], DATCAR=[20250918], DATACC=[20250918], mtot=[256], rcnt=[9]
CODOSP=[2], PROGRE=[20250036504], DATCAR=[20250918], DATACC=[20250918], mtot=[257], rcnt=[10]
CODOSP=[2], PROGRE=[20250036507], DATCAR=[20250918], DATACC=[20250918], mtot=[259], rcnt=[11]
CODOSP=[2], PROGRE=[20250036508], DATCAR=[20250918], DATACC=[20250918], mtot=[267], rcnt=[12]
CODOSP=[2], PROGRE=[20250036509], DATCAR=[20250918], DATACC=[20250918], mtot=[276], rcnt=[13]
stot=[00:02:28:00], mtot=[276], rcnt=[13]
mtot = [21]
dtot(min) = [21]
stot = [00:02:21:00]
we survived calcStrAtt()
CODOSP=[2], PROGRE=[20250036486], DATCAR=[20250917], DATACC=[20250917], mtot=[1], rcnt=[1]
CODOSP=[2], PROGRE=[20250036505], DATCAR=[20250918], DATACC=[20250918], mtot=[12], rcnt=[2]
stot=[00:02:21:00], mtot=[12], rcnt=[2]
mtot = [6]
dtot(min) = [6]
stot = [00:02:06:00]
we survived calcStrAtt()
CODOSP=[2], PROGRE=[20250036433], DATCAR=[20250917], DATACC=[20250917], mtot=[7], rcnt=[1]
CODOSP=[2], PROGRE=[20250036506], DATCAR=[20250918], DATACC=[20250918], mtot=[19], rcnt=[2]
stot=[00:02:06:00], mtot=[19], rcnt=[2]
mtot = [9]
dtot(min) = [9]
stot = [00:02:09:00]
we survived calcStrAtt()
CODOSP=[2], PROGRE=[20250036492], DATCAR=[20250917], DATACC=[20250917], mtot=[44], rcnt=[1]
mtot = [44]
dtot(min) = [44]
stot = [00:02:44:00]
Pronto Soccorso San Donà di Piave
Totale pazienti : 17
| CODICE BIANCO |
CODICE VERDE |
CODICE GIALLO |
CODICE ARANCIO |
CODICE ROSSO |
IN ATTESA
0
IN AMBULATORIO
1
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
2
|
IN ATTESA
0
IN AMBULATORIO
12
|
IN ATTESA
0
IN AMBULATORIO
2
|
tmpAttesa().selstring=[select DEA00F.CODENT, DEA00F.CODOSP, DEA00F.PROGRE, case when CODTRG in (1, 2, 3, 4, 7) then CODTRG when CODTRG in (6, 5) then 1 else 0 end as COLORE, DATACC, ORAACC, value(DATCAR, 0), value(ORACAR, 0) from DEA00F left join DEA02F on DEA00F.CODENT = DEA02F.CODENT and DEA00F.CODOSP = DEA02F.CODOSP and DEA00F.PROGRE = DEA02F.PROGRE left join DEAOBI0F on DEA00F.CODENT = DEAOBI0F.CODENT and DEA00F.CODOSP = DEAOBI0F.CODOSP and DEA00F.PROGRE = DEAOBI0F.PROGRE where DEA00F.FLGANN <> 'A' and DEA00F.CODENT = 10 and DEA00F.CODOSP = 3 and DEA00F.PSINVI = 1 and DEA00F.FLA002 <> 'D' and DEA00F.SNVIUR <> 'S' and value(DEAOBI0F.ESIOBI, 0) = 0 order by COLORE desc]
CODOSP=[3], PROGRE=[20250015715], DATCAR=[20250917], DATACC=[20250917], mtot=[5], rcnt=[2]
CODOSP=[3], PROGRE=[20250015718], DATCAR=[20250918], DATACC=[20250918], mtot=[11], rcnt=[3]
stot=[00:02:44:00], mtot=[11], rcnt=[3]
mtot = [3]
dtot(min) = [3]
stot = [00:02:03:00]
we survived calcStrAtt()
CODOSP=[3], PROGRE=[20250015717], DATCAR=[20250918], DATACC=[20250918], mtot=[1], rcnt=[1]
mtot = [1]
dtot(min) = [1]
stot = [00:02:01:00]
Pronto Soccorso Jesolo
Totale pazienti : 3
| CODICE BIANCO |
CODICE VERDE |
CODICE GIALLO |
CODICE ARANCIO |
CODICE ROSSO |
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
1
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
2
|
IN ATTESA
0
IN AMBULATORIO
0
|
tmpAttesa().selstring=[select DEA00F.CODENT, DEA00F.CODOSP, DEA00F.PROGRE, case when CODTRG in (1, 2, 3, 4, 7) then CODTRG when CODTRG in (6, 5) then 1 else 0 end as COLORE, DATACC, ORAACC, value(DATCAR, 0), value(ORACAR, 0) from DEA00F left join DEA02F on DEA00F.CODENT = DEA02F.CODENT and DEA00F.CODOSP = DEA02F.CODOSP and DEA00F.PROGRE = DEA02F.PROGRE left join DEAOBI0F on DEA00F.CODENT = DEAOBI0F.CODENT and DEA00F.CODOSP = DEAOBI0F.CODOSP and DEA00F.PROGRE = DEAOBI0F.PROGRE where DEA00F.FLGANN <> 'A' and DEA00F.CODENT = 10 and DEA00F.CODOSP = 4 and DEA00F.PSINVI = 1 and DEA00F.FLA002 <> 'D' and DEA00F.SNVIUR <> 'S' and value(DEAOBI0F.ESIOBI, 0) = 0 order by COLORE desc]
mtot = [0]
stot = [00:02:01:00]
Punto Primo Intervento Caorle
Totale pazienti :
| CODICE BIANCO |
CODICE VERDE |
CODICE GIALLO |
CODICE ARANCIO |
CODICE ROSSO |
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
tmpAttesa().selstring=[select DEA00F.CODENT, DEA00F.CODOSP, DEA00F.PROGRE, case when CODTRG in (1, 2, 3, 4, 7) then CODTRG when CODTRG in (6, 5) then 1 else 0 end as COLORE, DATACC, ORAACC, value(DATCAR, 0), value(ORACAR, 0) from DEA00F left join DEA02F on DEA00F.CODENT = DEA02F.CODENT and DEA00F.CODOSP = DEA02F.CODOSP and DEA00F.PROGRE = DEA02F.PROGRE left join DEAOBI0F on DEA00F.CODENT = DEAOBI0F.CODENT and DEA00F.CODOSP = DEAOBI0F.CODOSP and DEA00F.PROGRE = DEAOBI0F.PROGRE where DEA00F.FLGANN <> 'A' and DEA00F.CODENT = 10 and DEA00F.CODOSP = 5 and DEA00F.PSINVI = 1 and DEA00F.FLA002 <> 'D' and DEA00F.SNVIUR <> 'S' and value(DEAOBI0F.ESIOBI, 0) = 0 order by COLORE desc]
mtot = [0]
stot = [00:02:01:00]
Punto Primo Intervento Bibione
Totale pazienti :
| CODICE BIANCO |
CODICE VERDE |
CODICE GIALLO |
CODICE ARANCIO |
CODICE ROSSO |
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
tmpAttesa().selstring=[select DEA00F.CODENT, DEA00F.CODOSP, DEA00F.PROGRE, case when CODTRG in (1, 2, 3, 4, 7) then CODTRG when CODTRG in (6, 5) then 1 else 0 end as COLORE, DATACC, ORAACC, value(DATCAR, 0), value(ORACAR, 0) from DEA00F left join DEA02F on DEA00F.CODENT = DEA02F.CODENT and DEA00F.CODOSP = DEA02F.CODOSP and DEA00F.PROGRE = DEA02F.PROGRE left join DEAOBI0F on DEA00F.CODENT = DEAOBI0F.CODENT and DEA00F.CODOSP = DEAOBI0F.CODOSP and DEA00F.PROGRE = DEAOBI0F.PROGRE where DEA00F.FLGANN <> 'A' and DEA00F.CODENT = 10 and DEA00F.CODOSP = 6 and DEA00F.PSINVI = 1 and DEA00F.FLA002 <> 'D' and DEA00F.SNVIUR <> 'S' and value(DEAOBI0F.ESIOBI, 0) = 0 order by COLORE desc]
mtot = [0]
stot = [00:02:01:00]
Punto Primo Intervento Cavallino
Totale pazienti :
| CODICE BIANCO |
CODICE VERDE |
CODICE GIALLO |
CODICE ARANCIO |
CODICE ROSSO |
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|
IN ATTESA
0
IN AMBULATORIO
0
|