<?xml version="1.0" encoding="ISO-8859-15"?>
<VUE name="PMSI000156" label="PMSI. Gestes marqueurs" title="= SELECT.GROUPBY_2_LABEL + ' (' + SELECT.QUELLEDATE_LABEL + ' : ' +  SELECT.PERIODE_LABEL + ' à ' + SELECT.TOPERIODE_LABEL + ') - ' + SELECT.VERSION_GROUPAGE_LABEL" database="iCTI" swf="*CTI_view1" softCode="iCTI_pmsi" globals="PMSI_globals.XML" componentsFile="PMSI_components.XML" helpDokuWIkiDir="pmsi:qualite:etudes" helpDokuWIkiFile="pmsi000156"  helpFile="iCTI_PMSI_PMSI000156.HTML">
	<VIEWPROPERTIES componentName="PROPERTIES_ACTES" />
	<VIEWPROPERTIES componentName="PROPERTIES_SELECT_TABTREE" />
	<VIEWPROPERTIES>
		<PROPERTY name="CONSO_FINESS">
			<value><![CDATA[[EVAL 
				
				
				if ('[ENV.CONSOLIDATION]' == '1') {
					return "(select max(code) from base.t_finess where secondaire = '0')";
				} 
				else {
					return "v_rss_1.finess";
				} 
				
			EVAL]]]></value>
		</PROPERTY>
		<PROPERTY name="GM_SEQ" value="[EVAL
				return trim(substr('[GROUPBY_2]', 6));
			EVAL]" />
		<PROPERTY name="GM_CONDITION">
			<value><![CDATA[[EVAL 
				
				switch ('[CONDITION_OPTION]') {
					case 'AGEGHM' :
						return " AND t_classes_sections.condition not ilike '%condition_gm_ok%' ";
						break;
					case 'XAGEGHM' :
						return " AND t_classes_sections.condition ilike '%condition_gm_ok%' ";
						break;
					default :
						return "";
				}
				
			EVAL]]]></value>
		</PROPERTY>
		<PROPERTY name="VALUABLE">
			<value><![CDATA[[EVAL 
				
				switch ('[GROUP_OPTION]') {
					case 'TOUS' :
						return " valuable IN (0, 1) ";
						break;
					case 'SUP_SEUIL' :
						return " (valuable = 1 OR (valuable = 0 AND cod1 IN (SELECT distinct cod1 FROM w_tmp where valuable = 1 and level = 1)))";
						break;
					case 'INF_SEUIL' :
						return " valuable = 0 AND cod1 IN (SELECT distinct cod1 FROM w_tmp where valuable = 0 and level = 1)";
						break;
					default :
						return " valuable IN (0, 1) ";
				}
				
			EVAL]]]></value>
		</PROPERTY>
	</VIEWPROPERTIES>
	<VIEWPROPERTIES>
		<PROPERTY dataLink="VIEWPROPERTIES" nameField="name" valueField="value" />
	</VIEWPROPERTIES>
	<SELECTIONS label="Paramètres de l'analyse">
		<GROUP label="Période">
			<FIELD name="QUELLEDATE" label="" UI="combo" default="1" default2="date_fin" printable="false">
				<OPTION label="Date sortie" data="1" data2="date_sortie" />
				<OPTION label="Date acte" data="2" data2="date_acte" />
			</FIELD>
			<FIELD name="ALIAS_PERIODE" label="" UI="combo" width="220" default="CUM_LAST_MONTH" tree="true" globalListProvider="ALIAS_PERIODE" />
			<FIELD name="PERIODE" label="" UI="combo" tree="true" width="200" default="2014-01-01" default2="201401" printable="false" globalListProvider="DATE_DEBUT" />
			<FIELD name="TOPERIODE" label="à" UI="combo" tree="true" width="200" default="2014-12-31" default2="201412" printable="false" globalListProvider="DATE_FIN" />
		</GROUP>
		<GROUP label="Regroupement">
			<FIELD name="GROUPBY" width="250" label="" UI="combo" default="-1" tree="true">
				<OPTION label="Pas de regroupement" data="-1" />
				<OPTION label="Options" data="" globalListProvider="ACTE_GROUPBY_OPTIONS" />
			</FIELD>
			<FIELD name="GROUPBY_TAB" width="100" label="Présentation" UI="combo" default="AUTO" visible="= SELECT.GROUPBY != '-1' ">
				<OPTION label="Automatique" data="AUTO" />
				<OPTION label="Arbre" data="TREE" />
				<OPTION label="Onglet" data="TAB" />
			</FIELD>
		</GROUP>
	</SELECTIONS>
	<SELECTIONS label="Filtres Actes" displayText="= var display:String = '';
					if (SELECT.ACTE != '-1') {display = display + '  #B#Actes#/B# : #B#' + SELECT.ACTE_LABEL + ' (' + SELECT.ACTE_ACTIVITE_CCAM_LABEL + ')#/B#'}
					if (SELECT.ACTE == '-1' &amp;&amp; SELECT.ACTE_ACTIVITE_CCAM != '-1') {display = display + '  #B#Actes#/B# : #B#' + SELECT.ACTE_ACTIVITE_CCAM_LABEL + '#/B#'}
					if (SELECT.MEDECIN != '-1') {display = display + '  #B#Médecin exécutant#/B# : #B#' + SELECT.MEDECIN_LABEL + '#/B#'}
					if (SELECT.UM != '-1') {display = display + ' #B#Unité médicale#/B# : #B#' + SELECT.UM_LABEL + '#/B#'}
					if (SELECT.GROUP_OPTION == 'SUP_SEUIL') {display += ' Nombre d\'actes suffisant (au moins ' + VIEW.NB_ACTES_SIGNIF + ' pour la période d\'analyse)' }
					if (SELECT.GROUP_OPTION == 'INF_SEUIL') {display += ' Nombre d\'actes insuffisant (moins de ' + VIEW.NB_ACTES_SIGNIF + ' pour la période d\'analyse)' }
					if (SELECT.CONDITION_OPTION != 'ALL') {display = display + ' Conditions Gestes Marqueurs : #B#' + SELECT.CONDITION_OPTION_LABEL + '#/B#'}
					if (display != '') {
						display = '#B#Analyse#/B# = ' + display;
					}
					return display;
					">
		<GROUP label="Acte">
			<FIELD name="ACTE" label="" UI="combo" tree="true" width="400" default="-1" globalListProvider="ACTE" showIfNotDefault="true" />
			<FIELD name="ACTE_ACTIVITE_CCAM" label="" UI="combo" default="-1" globalListProvider="ACTE_ACTIVITE_CCAM" showIfNotDefault="true" />
		</GROUP>
		<GROUP label="Médecin exécutant">
			<FIELD name="MEDECIN" label="" UI="combo" tree="true" width="400" default="-1" globalListProvider="MEDECIN_ACTE" showIfNotDefault="true" />
		</GROUP>
		<GROUP label="Unité médicale">
			<FIELD name="UM" label="" UI="combo" tree="true" width="400" default="-1" globalListProvider="UM" showIfNotDefault="true" />
		</GROUP>
		<GROUP label="Classification">
			<FIELD name="GROUPBY_2" width="250" label="" UI="combo" default="ACTCLS12" default2="12" tree="false" globalListProvider="GMCLASSES_GROUPBY_OPTIONS" showIfNotDefault="true" />
			<FIELD name="GROUP_OPTION" width="200" label="" UI="combo" default="TOUS" tree="false" showIfNotDefault="true">
				<OPTION label="Toute l'activité" data="TOUS" />
				<OPTION label="Nombre d'actes suffisant" data="SUP_SEUIL" />
				<OPTION label="Nombre d'actes insuffisant" data="INF_SEUIL" />
			</FIELD>
		</GROUP>
		<GROUP label="Conditions GM">
			<FIELD name="CONDITION_OPTION" width="200" label="" UI="combo" default="ALL" tree="false" showIfNotDefault="true" visible="= SELECT.GROUPBY_2 == 'ACTCLS12' ">
				<OPTION label="Toutes conditions" data="ALL" />
				<OPTION label="Uniquement Age et GHM" data="AGEGHM" />
				<OPTION label="Sauf Age et GHM" data="XAGEGHM" />
			</FIELD>
		</GROUP>
		<GROUP label="Ext. documentaire">
			<FIELD name="ACTE_EXTENSION_DOC" label="" UI="combo" width="400" default="-1" showIfNotDefault="true" globalListProvider="ACTE_EXTENSION_DOC" />
		</GROUP>
	</SELECTIONS>
	<SELECTIONS componentName="FILTRES_ACTE_SOUSSELECTIONS" />
	<SELECTIONS componentName="FILTRES_RSS_SELECTIONS" />
	<QUERIES>
		<QUERY label="">
			<SQL optimizer="V_RSS_X" cacheEnabled="true">
				<select>
					<![CDATA[
					
					DROP TABLE IF EXISTS w_tmp; CREATE TEMP TABLE w_tmp AS
					SELECT 
						[VIEW.SELECT_TABTREE_COLUMNS],
						COUNT(DISTINCT v_rss_1.patient_id) AS NB_PAT,
						COUNT(DISTINCT v_rss_1.rss_id) AS NB_RSS_TOT,
						COUNT(DISTINCT CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END) AS NB_RSS_COND,
						COUNT(DISTINCT CASE WHEN duree_sejour = 0 THEN v_rss_1.rss_id ELSE NULL END) AS NB_0N,
						COUNT(DISTINCT CASE WHEN duree_sejour = 0 AND [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END) AS NB_0N_COND,
						CASE WHEN COUNT(DISTINCT CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END) > 0 THEN
							COUNT(DISTINCT CASE WHEN duree_sejour = 0 AND [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END)
							* 1.00 /
							COUNT(DISTINCT CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END)
							* 100
						ELSE
							0
						END AS PC_0N_COND,
						COUNT(DISTINCT CASE WHEN duree_sejour = 1 AND [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END) AS NRSS1,
						CASE WHEN COUNT(DISTINCT CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END) > 0 THEN
							COUNT(DISTINCT CASE WHEN duree_sejour = 1 AND [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END)
							* 1.00 /
							COUNT(DISTINCT CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END)
							* 100
						ELSE
							0
						END AS PRSS1,
						COUNT(DISTINCT CASE WHEN duree_sejour IN (0,1) AND [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END) AS NRSS01,
						CASE WHEN COUNT(DISTINCT CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END) > 0 THEN
							COUNT(DISTINCT CASE WHEN duree_sejour IN (0,1) AND [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END)
							* 1.00 /
							COUNT(DISTINCT CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN v_rss_1.rss_id ELSE NULL END)
							* 100
						ELSE
							0
						END AS PRSS01,
						sum(nombre_activite_1) AS NB_ACTES_1,
						sum(nombre_activite_1 + nombre_activite_4) AS NB_ACTES_TOT,
						sum(CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN nombre_activite_1 ELSE NULL END) AS NB_ACTES_1_COND,
						CASE WHEN sum(CASE WHEN [VIEW.GMCASEWHEN] = 1 THEN nombre_activite_1 ELSE NULL END) >= [VIEW.NB_ACTES_SIGNIF] THEN 1 ELSE 0 END AS VALUABLE,
						max(t_etude_5.taux_moyen_regional) AS TX_MOY_REG,
						max(t_etude_5.taux_cible_ets) AS TX_CIBLE_ETS,
						max(t_etude_5.taux_cible_ars) AS TX_CIBLE_ARS,
						max(t_etude_5.taux_moyen_national) AS TX_MOY_NAT
					FROM #V_RSS_X#
						JOIN pmsi.v_rss_actes_1 ON v_rss_1.rss_id = v_rss_actes_1.rss_id
						JOIN base.t_finess ON base.t_finess.code = [VIEW.CONSO_FINESS]
						LEFT JOIN pmsi.t_etude_5 ON t_etude_5.code = v_rss_actes_1.acte_section_code[[VIEW.GM_SEQ]] AND pmsi.t_etude_5.tersante_id = base.t_finess.territoire_sante_id AND pmsi.t_etude_5.sequence = [VIEW.GM_SEQ]::integer,
						[VIEW.SELECT_TABTREE_VIEW]
					WHERE 
						[VIEW.QUELLEDATE] BETWEEN '[PERIODE]' AND '[TOPERIODE]'
						[VIEW.FILTRE_ACTE_SELECT]
						[VIEW.FILTRE_RSS_SELECT]
						[VIEW.SELECT_TABTREE_WHERE]
						AND acte_section_id[[VIEW.GM_SEQ]] > 0
					GROUP BY 1,2,3,4,5,6,7,8,9,10,11
					ORDER BY 2,5,7
					;
					
					SELECT
						a,b,c,oid1, cod1, oid2, cod2, oid, cod, txt, level, 
						nb_pat, nb_rss_tot, nb_rss_cond, nb_0n, nb_0n_cond, pc_0n_cond, nrss1, prss1, nrss01, prss01,
						nb_actes_1, nb_actes_tot, nb_actes_1_cond, valuable, 
						CASE WHEN level <> 9 THEN tx_moy_reg ELSE null END as tx_moy_reg,
						CASE WHEN level <> 9 THEN tx_cible_ets ELSE null END as tx_cible_ets,
						CASE WHEN level <> 9 THEN tx_cible_ars ELSE null END as tx_cible_ars,
						CASE WHEN level <> 9 THEN tx_moy_nat ELSE null END as tx_moy_nat
					FROM
						w_tmp
					WHERE
						[VIEW.VALUABLE]
					;
					
					]]>
				</select>
				<FIELDS>
					<FIELD name="TABD" />
					<FIELD name="TABDL" />
					<FIELD name="TABDLL" />
					<FIELD name="OID1" />
					<FIELD name="COD1" />
					<FIELD name="OID2" />
					<FIELD name="COD2" />
					<FIELD name="OID" />
					<FIELD name="COD" />
					<FIELD name="TXT" />
					<FIELD name="LVL" />
					<FIELD name="NB_PAT" />
					<FIELD name="NB_RSS_TOT" />
					<FIELD name="NB_RSS_COND" />
					<FIELD name="NB_0N" />
					<FIELD name="NB_0N_COND" />
					<FIELD name="PC_0N_COND" />
					<FIELD name="NRSS1" />
					<FIELD name="PRSS1" />
					<FIELD name="NRSS01" />
					<FIELD name="PRSS01" />
					<FIELD name="NB_ACTES_1" />
					<FIELD name="NB_ACTES_TOT" />
					<FIELD name="NB_ACTES_1_COND" />
					<FIELD name="VALUABLE" />
					<FIELD name="TX_MOY_REG" />
					<FIELD name="TX_CIBLE_ETS" />
					<FIELD name="TX_CIBLE_ARS" />
					<FIELD name="TX_MOY_NAT" />
				</FIELDS>
			</SQL>
		</QUERY>
		<QUERY type="propertiesLink" name="VIEWPROPERTIES" forSelections="false">
			<SQL>
				<select>
					<![CDATA[
						SELECT 'GMCASEWHEN', base.cti_group_concat_without_sep(case_when) 
						FROM
							(
							SELECT ' CASE' AS case_when
							
							UNION
							
							SELECT 
								' WHEN acte_section_id[[VIEW.GM_SEQ]] = ' || 
								t_classes_sections.oid::text || 
								CASE WHEN t_classes_sections.condition <> '' [VIEW.GM_CONDITION] THEN ' AND ' || 
								t_classes_sections.condition ELSE '' END || 
								' THEN 1 ' 
							FROM pmsi.t_classes, pmsi.t_classes_sections, pmsi.t_listes_tables
							WHERE 
								t_classes_sections.classe_id = t_classes.oid
								AND t_classes.table_id = t_listes_tables.oid
								AND t_listes_tables.code = 'ACTE'
								AND t_classes.sequence = [VIEW.GM_SEQ]
								
							UNION
							
							SELECT 'ELSE 0 END'
							ORDER BY 1
							) subview
					]]>
				</select>
				<FIELDS>
					<FIELD name="name" />
					<FIELD name="value" />
				</FIELDS>
			</SQL>
			<SQL>
				<select>
					<![CDATA[
					SELECT 'SEUIL_YYYY', 
						CASE 
							WHEN extract('year' FROM '[TOPERIODE]'::date) = 2008 THEN '2008'
							WHEN extract('year' FROM '[TOPERIODE]'::date) = 2009 THEN '2009'
							WHEN extract('year' FROM '[TOPERIODE]'::date) = 2010 THEN '2010'
							WHEN extract('year' FROM '[TOPERIODE]'::date) = 2011 THEN '2011'
							WHEN extract('year' FROM '[TOPERIODE]'::date) = 2012 THEN '2012'
							WHEN extract('year' FROM '[TOPERIODE]'::date) = 2013 THEN '2013'
							WHEN extract('year' FROM '[TOPERIODE]'::date) = 2014 THEN '2014'
							WHEN extract('year' FROM '[TOPERIODE]'::date) = 2015 THEN '2015'
						ELSE '2011' END
					]]>
				</select>
				<FIELDS>
					<FIELD name="name" />
					<FIELD name="value" />
				</FIELDS>
			</SQL>
			<SQL>
				<select>
					<![CDATA[
					SELECT 
						'NB_ACTES_SIGNIF', 
						ceil(('[TOPERIODE]'::date - '[PERIODE]'::date) * 20 / 365::float)
					]]>
				</select>
				<FIELDS>
					<FIELD name="name" />
					<FIELD name="value" />
				</FIELDS>
			</SQL>
		</QUERY>
	</QUERIES>
	<PRESENTATION>
		<VIEWLINKS>
			<VIEWLINK label="Saisie des seuils" shortLabel="Saisie des seuils" view="PMSI000192.XML" rowContext="false" visible="= (String(SELECT.GROUPBY_2_LABEL).search('MSAP') != -1 &amp;&amp; String(SELECT.GROUPBY_2_LABEL).search('2015') != -1)" option="= SELECT.GROUPBY_22" />
			<VIEWLINK label="Liste des Actes par RSS" shortLabel="Liste Actes" view="PMSI000030.XML" componentName="RSS_BASE_VIEWLINK" component2Name="ACTE_VIEWLINK" component3Name="" />
			<VIEWLINK label="Liste des RSS" shortLabel="Liste RSS" view="PMSI000005.XML" componentName="RSS_BASE_VIEWLINK" component2Name="RSS_OTHERS_VIEWLINK" component3Name="" />
			<VIEWREF label="Liste des 38 gestes marqueurs MSAP chirurgie ambulatoire, version de 2015" shortLabel="Liste MSAP 2015" visible="= SELECT.GROUPBY_2_LABEL == 'Gestes marqueurs MSAP 2015'" url="http://www.ctisante.com/references/pmsi/gestes-chirurgicaux-accord-prealable_assurance-maladie.xls" rowContext="false"/>
		</VIEWLINKS>
		<ONGLET excelLabel="Analyse MSAP 2015" label="Analyse MSAP 2015" multiTab="true" multiTabBreakField="TABD" multiTabBreakLabelField="TABDL" multiTabBreakLonglabelField="TABDLL" visibleCondition="SELECT.GROUPBY_2 == 'ACTCLS12'">
			<DATAGRID title="" total="true" showOthers="true" headerHeight="64" sortable="= SELECT.GROUPBY == '-1' || SELECT.GROUPBY_TAB == 'TAB'" variableRowHeight="true" selectRowInRows="= ROW.OID == '-9999997'" otherRowInRows="= ROW.OID == '-9999998'" totalRowInRows="= ROW.OID == '-9999999'">
				<ROWSTYLE name="rowHeight" value="20" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="backgroundColor" value="0xFFD393" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="fontWeight" value="bold" condition="(ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB')" />
				<ROWSTYLE name="borderSides" value="top bottom" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="borderStyle" value="solid" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="borderThickness" value="2" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<COLUMN dataField="LVL" width="50" type="Char" visible="false" headerText="Code" textAlign="left" otherFunction="text" totalFunction="text" />
				<COLUMN dataField="OID1" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="COD1" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="OID2" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="COD2" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="OID" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="COD" width="70" type="Char" headerText="Code" textAlign="left" otherFunction="text" totalFunction="text">
					<CELLSTYLE name="paddingLeft" value="15" condition="ROW.LVL == '2' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				</COLUMN>
				<COLUMN dataField="TXT" type="Char" minWidth="200" maxWidth="300" headerText="SELECT.GROUPBY_2_LABEL" headerTextCalc="true" textAlign="left" totalFunction="text" totalComplement="TOTAL" otherFunction="text" otherComplement="Autres">
				</COLUMN>
				<COLUMN dataField="CODTXT" type="Char" minWidth="200" visible="false" fixed="false" totalFunction="text" otherFunction="text" calc="true">
					<CALC formula="ROW.COD + ' ' + ROW.TXT.toString().substr(0,20)" />
				</COLUMN>
				<COLUMN dataField="NB_PAT" width="65" type="Number" outputFormat="#" fixed="false" headerText="Patients" textAlign="right" totalFunction="sum" otherFunction=""
					description="= return &quot;Nombre de patients différents des séjours qui comportent au moins un acte présent dans la liste &lt;b&gt;&quot; + SELECT.GROUPBY_2_LABEL + &quot;&lt;/b&gt;&quot;" />
				<COLUMN dataField="NB_RSS_TOT" width="65" type="Number" outputFormat="#" fixed="false" headerText="Séjours" textAlign="right" totalFunction="sum" otherFunction=""
					description="= return &quot;Nombre de séjours différents qui comportent au moins un acte présent dans la liste &lt;b&gt;&quot; + SELECT.GROUPBY_2_LABEL + &quot;&lt;/b&gt;&quot;" />
				<COLUMN dataField="NB_RSS_COND" width="80" type="Number" outputFormat="#" fixed="false" headerText="Séjours (condition)" textAlign="right" totalFunction="sum" otherFunction=""
					description="= return &quot;Nombre de séjours différents qui comportent au moins un acte présent dans la liste &lt;b&gt;&quot; + SELECT.GROUPBY_2_LABEL + &quot;&lt;/b&gt; et dont la condition de comptabilisation de l'acte est respectée (voir documentation &lt;b&gt;Liste MSAP 2015&lt;/b&gt;)&quot;" />
				<COLUMN dataField="NBP" type="Number" headerText="% / Total" width="45" outputFormat="0%" fixed="false" textAlign="right" totalFunction="calc" totalComplement="" otherFunction="calc" calc="true"
					description="Poids du nombre de séjours du critère de regroupement sous condition sur le nombre total de séjours sous condition">
					<CALC formula="ROW.NB_RSS_COND / TOTALROW.NB_RSS_COND * 100" />
				</COLUMN>
				<COLUMN dataField="NB_ACTES_1" width="60" type="Number" outputFormat="#" fixed="false" headerText="Actes&#xD;activité 1" textAlign="right" totalFunction="sum" otherFunction=""
					description="= return &quot;Nombres d'actes de chirurgie ou de médecine présents dans la liste &lt;b&gt;&quot; + SELECT.GROUPBY_2_LABEL + &quot;&lt;/b&gt;&quot;" />
				<COLUMN dataField="NB_ACTES_1_COND" width="70" type="Number" outputFormat="#" fixed="false" headerText="Actes&#xD;activité 1 (condition)" textAlign="right" totalFunction="sum" otherFunction=""
					description="= return &quot;Nombres d'actes de chirurgie ou de médecine présents dans la liste &lt;b&gt;&quot; + SELECT.GROUPBY_2_LABEL + &quot;&lt;/b&gt; et dont la condition de comptabilisation est respectée.&lt;br/&gt;&lt;br/&gt;Le nombre d'actes de cette colonne doit être supérieur à &quot; + VIEW.NB_ACTES_SIGNIF + &quot; pour que le taux soit significatif (40 actes sur une année, au prorata sur la période analysée)&quot;">
					<CELLSTYLE name="fontWeight" value="bold" condition="SELECT.GROUPBY == '-1'" />
				</COLUMN>
				<!--
				<COLUMN dataField="NB_ACTES_TOT" width="60" type="Number" outputFormat="#" fixed="false" headerText="Actes activité&#xD;1 et 4" textAlign="right" totalFunction="sum" otherFunction=""
					description="Nombre d'actes de chirurgie, de médecine ou d'anesthésie réalisés" />
				-->
				<COLUMN dataField="NB_0N" width="70" type="Number" outputFormat="#" fixed="false" headerText="Séjours&#xD;0 nuit" textAlign="right" totalFunction="sum" otherFunction=""
					description="= return &quot;Nombre de séjours de 0 nuit différents qui comportent au moins un acte présent dans la liste &lt;b&gt;&quot; + SELECT.GROUPBY_2_LABEL + &quot;&lt;/b&gt;&quot;" />
				<COLUMN dataField="NB_0N_COND" width="70" type="Number" outputFormat="#" fixed="false" headerText="Séjours&#xD;0 nuit&#xD;(condition)" textAlign="right" totalFunction="sum" otherFunction=""
					description="= return &quot;Nombre de séjours de 0 nuit différents qui comportent au moins un acte présent dans la liste &lt;b&gt;&quot; + SELECT.GROUPBY_2_LABEL + &quot;&lt;/b&gt; et dont la condition de comptabilisation est respectée&quot;" />
				<COLUMN dataField="PC_0N_COND" width="70" type="Number" outputFormat="0#,00%" fixed="false" headerText="% 0 nuit&#xD;(condition)" textAlign="right" totalFunction="sum" otherFunction=""
					description="= return &quot;Pourcentage de séjours réalisés en ambulatoire avec au moins un acte présent dans la liste &lt;b&gt;&quot; + SELECT.GROUPBY_2_LABEL + &quot;&lt;/b&gt;&lt;br/&gt;&lt;br/&gt;Rapport entre les colonnes &lt;b&gt;Séjours 0 nuit (condition)&lt;/b&gt; et &lt;b&gt;Séjours (condition)&lt;/b&gt;&quot;" />
				<COLUMN dataField="TX_CIBLE_ETS" width="70" type="Number" outputFormat="#,00%" fixed="false" headerText="Taux cible&#xD;Etab." textAlign="right" totalFunction="*NONE" visibleCondition="=TX_CIBLE_ETS=0"
					description="= return &quot;Taux cible par geste marqueur défini pour l'établissement via le bouton &lt;b&gt;Saisie des seuils&lt;/b&gt;&lt;br/&gt;&lt;br/&gt;Pour les gestes marqueurs dont le nombre d'actes d'activite 1 réalisés est significatif (supérieur à &quot; + VIEW.NB_ACTES_SIGNIF + &quot; pour la période analysée), une pastille verte indique que le pourcentage de séjours 0 nuit est supérieur au seuil établissement défini, une pastille rouge indique une valeur inférieure&quot;">
					<CELLSTYLE name="cellIndicator" value="circle, 5, left top, 0xFF0000" condition="ROW.PC_0N_COND &lt; ROW.TX_CIBLE_ETS &amp;&amp; ROW.TX_CIBLE_ETS &gt; 0 &amp;&amp; ROW.VALUABLE == '1' &amp;&amp; ((SELECT.GROUPBY == 'ACTE' || SELECT.GROUPBY == '-1') &amp;&amp; ROW.COD == ROW.COD1 || SELECT.GROUPBY != 'ACTE' &amp;&amp; ROW.COD == ROW.COD2)" />
					<CELLSTYLE name="cellIndicator" value="circle, 5, left top, 0x75a0eb" condition="ROW.PC_0N_COND &gt;= ROW.TX_CIBLE_ETS &amp;&amp; ROW.TX_CIBLE_ETS &gt; 0 &amp;&amp; ROW.VALUABLE == '1' &amp;&amp; ((SELECT.GROUPBY == 'ACTE' || SELECT.GROUPBY == '-1') &amp;&amp; ROW.COD == ROW.COD1 || SELECT.GROUPBY != 'ACTE' &amp;&amp; ROW.COD == ROW.COD2)" />
				</COLUMN>
				<COLUMN dataField="TX_CIBLE_ARS" width="70" type="Number" outputFormat="#,00%" fixed="false" headerText="Taux cible&#xD;ARS" textAlign="right" totalFunction="*NONE"
					description="= return &quot;Taux cible ARS par geste marqueur saisi via le bouton &lt;b&gt;Saisie des seuils&lt;/b&gt;&lt;br/&gt;&lt;br/&gt;Pour les gestes marqueurs dont le nombre d'actes d'activité 1 réalisés est significatif (supérieur à &quot; + VIEW.NB_ACTES_SIGNIF + &quot; pour la période analysée), une pastille verte indique que le pourcentage de séjours 0 nuit est supérieur au seuil ARS défini, une pastille rouge indique une valeur inférieure&quot;">
					<CELLSTYLE name="cellIndicator" value="circle, 5, left top, 0xFF0000" condition="ROW.PC_0N_COND &lt; ROW.TX_CIBLE_ARS &amp;&amp; ROW.TX_CIBLE_ARS &gt; 0 &amp;&amp; ROW.VALUABLE == '1' &amp;&amp; ((SELECT.GROUPBY == 'ACTE' || SELECT.GROUPBY == '-1') &amp;&amp; ROW.COD == ROW.COD1 || SELECT.GROUPBY != 'ACTE' &amp;&amp; ROW.COD == ROW.COD2)" />
					<CELLSTYLE name="cellIndicator" value="circle, 5, left top, 0x75a0eb" condition="ROW.PC_0N_COND &gt;= ROW.TX_CIBLE_ARS &amp;&amp; ROW.TX_CIBLE_ARS &gt; 0 &amp;&amp; ROW.VALUABLE == '1' &amp;&amp; ((SELECT.GROUPBY == 'ACTE' || SELECT.GROUPBY == '-1') &amp;&amp; ROW.COD == ROW.COD1 || SELECT.GROUPBY != 'ACTE' &amp;&amp; ROW.COD == ROW.COD2)" />
				</COLUMN>
				<COLUMN dataField="TX_MOY_REG" width="70" type="Number" outputFormat="#,00%" fixed="false" headerText="Taux moyen régional" textAlign="right" totalFunction="*NONE"
					description="= return &quot;Pourcentage de séjours réalisés en ambulatoire calculé par geste marqueur sur la base régionale (privé et public confondus)&lt;br/&gt;&lt;br/&gt;Pour les gestes marqueurs dont le nombre d'actes d'activité 1 réalisés est significatif (supérieur à &quot; + VIEW.NB_ACTES_SIGNIF + &quot; pour la période analysée), une pastille verte indique que le pourcentage de séjours 0 nuit est supérieur au taux moyen national, une pastille rouge indique une valeur inférieure&quot;">
					<CELLSTYLE name="cellIndicator" value="circle, 5, left top, 0xFF0000" condition="ROW.PC_0N_COND &lt; ROW.TX_MOY_REG &amp;&amp; ROW.TX_MOY_REG &gt; 0 &amp;&amp; ROW.VALUABLE == '1' &amp;&amp; ((SELECT.GROUPBY == 'ACTE' || SELECT.GROUPBY == '-1') &amp;&amp; ROW.COD == ROW.COD1 || SELECT.GROUPBY != 'ACTE' &amp;&amp; ROW.COD == ROW.COD2)" />
					<CELLSTYLE name="cellIndicator" value="circle, 5, left top, 0x75a0eb" condition="ROW.PC_0N_COND &gt;= ROW.TX_MOY_REG &amp;&amp; ROW.TX_MOY_REG &gt; 0 &amp;&amp; ROW.VALUABLE == '1' &amp;&amp; ((SELECT.GROUPBY == 'ACTE' || SELECT.GROUPBY == '-1') &amp;&amp; ROW.COD == ROW.COD1 || SELECT.GROUPBY != 'ACTE' &amp;&amp; ROW.COD == ROW.COD2)" />
				</COLUMN>
				<COLUMN dataField="TX_MOY_NAT" width="70" type="Number" outputFormat="#,00%" fixed="false" headerText="Taux moyen national" textAlign="right" totalFunction="*NONE"
					description="= return &quot;Pourcentage de séjours réalisés en ambulatoire calculé par geste marqueur sur la base nationale 2014 (privé et public confondus)&lt;br/&gt;&lt;br/&gt;Pour les gestes marqueurs dont le nombre d'actes d'activité 1 réalisés est significatif (supérieur à &quot; + VIEW.NB_ACTES_SIGNIF + &quot; pour la période analysée), une pastille verte indique que le pourcentage de séjours 0 nuit est supérieur au taux moyen national, une pastille rouge indique une valeur inférieure&quot;">
					<CELLSTYLE name="cellIndicator" value="circle, 5, left top, 0xFF0000" condition="ROW.PC_0N_COND &lt; ROW.TX_MOY_NAT &amp;&amp; ROW.TX_MOY_NAT &gt; 0 &amp;&amp; ROW.VALUABLE == '1' &amp;&amp; ((SELECT.GROUPBY == 'ACTE' || SELECT.GROUPBY == '-1') &amp;&amp; ROW.COD == ROW.COD1 || SELECT.GROUPBY != 'ACTE' &amp;&amp; ROW.COD == ROW.COD2)" />
					<CELLSTYLE name="cellIndicator" value="circle, 5, left top, 0x75a0eb" condition="ROW.PC_0N_COND &gt;= ROW.TX_MOY_NAT &amp;&amp; ROW.TX_MOY_NAT &gt; 0 &amp;&amp; ROW.VALUABLE == '1' &amp;&amp; ((SELECT.GROUPBY == 'ACTE' || SELECT.GROUPBY == '-1') &amp;&amp; ROW.COD == ROW.COD1 || SELECT.GROUPBY != 'ACTE' &amp;&amp; ROW.COD == ROW.COD2)" />
				</COLUMN>
			</DATAGRID>
		</ONGLET>
		<ONGLET excelLabel="Analyse actes" label="Analyse actes" multiTab="true" multiTabBreakField="TABD" multiTabBreakLabelField="TABDL" multiTabBreakLonglabelField="TABDLL" visibleCondition="SELECT.GROUPBY_2 != 'ACTCLS12'">
			<CHARTx title="10 premiers" type="pieChart2" subType="" maxItems="10" maxItemsSortOn="NB" maxItemsSortSeq="D" sortField="CODTXT" sortSeq="A" condition="ROW.LVL == '1'">
				<CATEGORY field="CODTXT" type="Char" />
				<SERIE field="NB" displayName="Nb" />
				<SERIE field="ICR" displayName="ICR" />
			</CHARTx>
			<DATAGRID title="" total="true" showOthers="true" headerHeight="48" sortable="= SELECT.GROUPBY == '-1' || SELECT.GROUPBY_TAB == 'TAB'" variableRowHeight="true" selectRowInRows="= ROW.OID == '-9999997'" otherRowInRows="= ROW.OID == '-9999998'" totalRowInRows="= ROW.OID == '-9999999'">
				<ROWSTYLE name="rowHeight" value="20" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="backgroundColor" value="0xFFD393" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="fontWeight" value="bold" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="borderSides" value="top bottom" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="borderStyle" value="solid" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<ROWSTYLE name="borderThickness" value="2" condition="ROW.LVL == '1' &amp;&amp; SELECT.GROUPBY != '-1' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				<COLUMN dataField="LVL" width="50" type="Char" visible="false" headerText="Code" textAlign="left" otherFunction="text" totalFunction="text" />
				<COLUMN dataField="OID1" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="COD1" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="OID2" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="COD2" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="OID" width="60" type="Char" visible="false" headerText="Oid" />
				<COLUMN dataField="COD" width="70" type="Char" headerText="Code" textAlign="left" otherFunction="text" totalFunction="text">
					<CELLSTYLE name="paddingLeft" value="15" condition="ROW.LVL == '2' &amp;&amp; SELECT.GROUPBY_TAB != 'TAB'" />
				</COLUMN>
				<COLUMN dataField="TXT" type="Char" minWidth="200" maxWidth="300" headerText="ENV.FINESS" headerTextCalc="true" textAlign="left" totalFunction="text" totalComplement="TOTAL" otherFunction="text" otherComplement="Autres">
				</COLUMN>
				<COLUMN dataField="CODTXT" type="Char" minWidth="200" visible="false" totalFunction="text" otherFunction="text" calc="true">
					<CALC formula="ROW.COD + ' ' + ROW.TXT.toString().substr(0,20)" />
				</COLUMN>
				<COLUMN dataField="NB_PAT" width="60" type="Number" outputFormat="#" headerText="Nb patients" textAlign="right" totalFunction="sum" otherFunction="" />
				<COLUMN dataField="NB_RSS_TOT" width="100" type="Number" outputFormat="#" headerText="Nb total séjours" textAlign="right" totalFunction="sum" otherFunction="" />
				<COLUMN dataField="NB_ACTES_1" width="100" type="Number" outputFormat="#" headerText="Nb total actes" textAlign="right" totalFunction="sum" otherFunction="" largeSeparator="true" />
				<COLUMN dataField="NB_RSS_COND" width="100" type="Number" outputFormat="#" headerText="Nb total séjours (condition)" textAlign="right" totalFunction="sum" otherFunction="" />
				<COLUMN dataField="NBP" type="Number" headerText="% / Total" width="45" outputFormat="0%" textAlign="right" totalFunction="calc" totalComplement="" otherFunction="calc" calc="true">
					<CALC formula="ROW.NB_RSS_COND / TOTALROW.NB_RSS_COND * 100" />
				</COLUMN>
				<COLUMN dataField="NRSS01" width="100" type="Number" outputFormat="#" headerText="Nb 0 + 1 nuit (condition)" textAlign="right" totalFunction="sum" otherFunction="" />
				<COLUMN dataField="PRSS01" width="80" type="Number" outputFormat="#,00%" headerText="% 0 + 1 nuit" textAlign="right" totalFunction="sum" otherFunction="" />
				<COLUMN dataField="TX_MOY_REG" width="100" type="Number" outputFormat="#" headerTextCalc="true" headerText="'Seuil rég. ' + VIEW.SEUIL_YYYY" textAlign="right" totalFunction="sum" otherFunction="" visible="false" />
				<COLUMN dataField="TX_CIBLE_ETS" width="100" type="Number" outputFormat="#" headerTextCalc="true" headerText="'Seuil nat. ' + VIEW.SEUIL_YYYY" textAlign="right" totalFunction="sum" otherFunction="" visible="false" />
				<COLUMN dataField="NB_0N_COND" width="100" type="Number" outputFormat="#" headerText="Nb 0 nuit (condition)" textAlign="right" totalFunction="sum" otherFunction="" />
				<COLUMN dataField="PC_0N_COND" width="80" type="Number" outputFormat="#,00%" headerText="% 0 nuit" textAlign="right" totalFunction="sum" otherFunction="" />
				<COLUMN dataField="NRSS1" width="100" type="Number" outputFormat="#" headerText="Nb 1 nuit (condition)" textAlign="right" totalFunction="sum" otherFunction="" />
				<COLUMN dataField="PRSS1" width="80" type="Number" outputFormat="#,00%" headerText="% 1 nuit" textAlign="right" totalFunction="sum" otherFunction="" />
			</DATAGRID>
		</ONGLET>
	</PRESENTATION>
</VUE>
