<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"
[
]
>
<!-- cascade="all|none|save-update|delete|all-delete-orphan"  -->

<hibernate-mapping default-lazy="false" default-cascade="none">

	<!-- VR12 -->
	<class name="gov.va.med.cds.ars.requestresponse.generated.VR12LocationReportDataType" >
		<id name="location" type="java.lang.String" />
		<property name="recordCount" type="integer"/>
		<property name="mentalAverage" type="double"/>
		<property name="physicalAverage" type="double"/>
	</class>

	<!-- Distribution of Surveys -->
	<class name="gov.va.med.cds.ars.requestresponse.generated.DistributionLocationReportDataType" >
		<id name="key" type="java.lang.String" access="field" />
		<property name="vendorFacility" type="java.lang.String" />
		<property name="recordCount" type="integer"/>
		<property name="location" type="java.lang.String" />
	</class>
	
	<!-- National Distribution -->
	<class name="gov.va.med.cds.ars.requestresponse.generated.NationalDistributionLocationReportDataType" >
		<id name="vendorFacility" type="java.lang.String" />
		<property name="recordCount" type="integer"/>
		<property name="location" type="java.lang.String" />
		<property name="lastSurveyDate" type="gov.va.med.cds.ars.persistence.XmlDateUserType" />
	</class>
	
	<!-- Patient Satisfaction Statistics -->
	<class name="gov.va.med.cds.ars.requestresponse.generated.PSLocationReportDataType" >
		<id name="key" type="java.lang.String" access="field" />
		<property name="recordCount" type="integer"/>
		<property name="location" type="java.lang.String" />
		<property name="month" type="integer" />
		<property name="year" type="integer" />
		<property name="questionNumber" type="integer" />
		<property name="questionSum" type="integer" />
		<property name="score" type="double" />
	</class>
	
	<!-- superclass and Trends -->
	<class name="gov.va.med.cds.ars.requestresponse.generated.LocationReportDataType" >
		<id name="location" type="java.lang.String" />
		<property name="recordCount" type="integer"/>
	</class>
	
	<!-- superclass of holding object (for count procedure) -->
	<class name="gov.va.med.cds.ars.requestresponse.generated.HTBaseReportType" >
		<id name="numberOfRecordsConsidered" type="integer" />
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.DMPTitleType" >
		<id name="key" type="java.lang.String" access="field" />
		<property name="title" type="java.lang.String"/>
		<property name="version" type="java.lang.String"/>
	</class>
	
	<!-- Add Census Report supporting class mapping -->
	 
	<class name="gov.va.med.cds.ars.requestresponse.generated.HTVendor" >
		<id name="number" type="java.lang.String"/>
		<property name="name" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.VISNFacilityDataType" >
		<id name="facilityNumber" type="java.lang.String"/>
		<property name="visn" type="java.lang.String"/>
		<property name="facilityName" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusVendorReportDataType" >
		<id name="number" type="java.lang.String"/>
		<property name="name" type="java.lang.String"/>
		<property name="dateActive" type="java.lang.String" />
		<property name="dateInactive" type="java.lang.String" />
	</class>
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusReportDatesDataType" >
		<id  name="startDate" type="gov.va.med.cds.ars.persistence.XmlDateUserType"/>
		<property name="endDate" type="gov.va.med.cds.ars.persistence.XmlDateUserType"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusVendorStatusDataType" >
		<id name="number" type="java.lang.String"/>
		<property name="name" type="java.lang.String"/>
		<property name="status" type="java.lang.String" />
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusPostProcessingStatusReportType">
		<id name="overallCensusStatus" type="java.lang.String" />
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusTransmittalModeReportDataType" >
		<id name="data" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
		<id name="key" type="java.lang.String" access="field" />
		<property name="number" type="java.lang.String"/>
		<property name="name" type="java.lang.String"/>
		<property name="count" type="integer"/>	
		<property name="location" type="java.lang.String"/>
	</class>
	
	<!-- ============================================== -->
	<!-- =====      Start of Census Reports 3.12  ===== -->
	<!-- ============================================== -->
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.HtLevelOfCareReportDataType" >            
		<id name="code" type="java.lang.String"/>
		<property name="description" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.HTHCumMonYearReportDataType" >
		<id name="rowNum" type="integer"/>
		<property name="month" type="java.lang.String"/>
		<property name="year" type="integer"/>
		<property name="startDate" type="gov.va.med.cds.ars.persistence.XmlDateUserType"/>
		<property name="endDate" type="gov.va.med.cds.ars.persistence.XmlDateUserType"/> 
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.FYQtrReportDataType" >
		<id name="rowNum" type="integer"/>
		<property name="quarterYear" type="java.lang.String"/>
		<property name="startDate" type="gov.va.med.cds.ars.persistence.XmlDateOnlyUserType"/>
		<property name="endDate" type="gov.va.med.cds.ars.persistence.XmlDateOnlyUserType"/> 
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusNICADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusTotalRuralVISNADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusRuralVISNADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusHighlyRuralVISNADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusUrbanVISNADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/> 
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusUnknownVISNADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusTotalRuralFacilityADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusRuralFacilityADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusHighlyRuralFacilityADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusUrbanFacilityADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/>
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	
	<class name="gov.va.med.cds.ars.requestresponse.generated.CensusUnknownFacilityADCLocationReportDataType">
		<id name="rowNum" type="integer"/>
		<property name="numberOfDays" type="integer"/>
		<property name="repeatingInterval" type="integer"/> 
		<property name="geoLocation" type="java.lang.String"/>
	</class>
	<!-- End Census Report supporting class mapping -->
	<!-- Surveys Named Queries SQL -->
 
	<sql-query name="SurveyReports.vr12.data" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.VR12LocationReportDataType">
	   		<return-property name="location" column="location" />
			<return-property name="recordCount" column="record_count" />
			<return-property name="mentalAverage" column="mental_score_average" />
			<return-property name="physicalAverage" column="physical_score_average" />
	 	</return>
		{ call ht_survey_report.vr12_data( ?, :location, :startDate, :endDate ) }
	</sql-query>


	<sql-query name="SurveyReports.vr12.data.mv" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.VR12LocationReportDataType">
	   		<return-property name="location" column="location" />
			<return-property name="recordCount" column="record_count" />
			<return-property name="mentalAverage" column="mental_score_average" />
			<return-property name="physicalAverage" column="physical_score_average" />
	 	</return>
		{ call ht_survey_report.vr12_data_mv( ?, :location, :startDate, :endDate ) }
	</sql-query>


	<sql-query name="SurveyReports.distribution" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.DistributionLocationReportDataType">
			<return-property name="key" column="key" />
	   		<return-property name="location" column="location" />
			<return-property name="recordCount" column="record_count" />
			<return-property name="vendorFacility" column="vendor_facility" />
		</return>
		{ call ht_survey_report.distribution( ?, :surveyType, :location, :startDate, :endDate ) }
	</sql-query>


	<sql-query name="SurveyReports.nationalDistribution" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.NationalDistributionLocationReportDataType">
	   		<return-property name="location" column="location" />
			<return-property name="recordCount" column="record_count" />
			<return-property name="vendorFacility" column="vendor_facility" />
			<return-property name="lastSurveyDate" column="last_survey_date" />
		</return>
		{ call ht_survey_report.national_distribution( ?, :surveyVersion, :surveyType ) }
	</sql-query>


	<sql-query name="SurveyReports.nationalDistribution.mv" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.NationalDistributionLocationReportDataType">
	   		<return-property name="location" column="location" />
			<return-property name="recordCount" column="record_count" />
			<return-property name="vendorFacility" column="vendor_facility" />
			<return-property name="lastSurveyDate" column="last_survey_date" />
		</return>
		{ call ht_survey_report.national_distribution_mv( ?, :surveyVersion, :surveyType ) }
	</sql-query>


    <sql-query name="SurveyReports.patientSatisfaction" callable="true" >
        <return class="gov.va.med.cds.ars.requestresponse.generated.PSLocationReportDataType">
            <return-property name="key" column="key" />
            <return-property name="location" column="location" />
            <return-property name="recordCount" column="record_count" />
            <return-property name="month" column="month" />
            <return-property name="year" column="year" />
            <return-property name="questionSum" column="question_sum" />
            <return-property name="questionNumber" column="question_number" />
            <return-property name="score" column="score" />
        </return>
        { call ht_survey_report.patient_satisfaction_data( ?, :surveyVersion, :questions, :location, :startDate, :endDate ) }
    </sql-query>


	<sql-query name="SurveyReports.trends" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.LocationReportDataType">
	   		<return-property name="location" column="location" />
			<return-property name="recordCount" column="record_count" />
		</return>
		{ call ht_survey_report.trends( ?, :surveyVersion, :surveyType, :location, :startDate, :endDate ) }
	</sql-query>


	<sql-query name="SurveyReports.countSurveys" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.HTBaseReportType">
	   		<return-property name="numberOfRecordsConsidered" column="records_considered" />
	 	</return>
		{ call ht_survey_report.count_surveys_proc_national( ?, :surveyVersion, :surveyType, :location, :acceptedStatus, :startDate, :endDate ) }
	</sql-query>


	<sql-query name="SurveyReports.countSurveysNationalDist" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.HTBaseReportType">
	   		<return-property name="numberOfRecordsConsidered" column="records_considered" />
	 	</return>
		{ call ht_survey_report.count_national_dist_proc( ?, :surveyVersion, :surveyType, :acceptedStatus ) }
	</sql-query>


	<sql-query name="SurveyReports.countSurveysNationalDist.mv" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.HTBaseReportType">
	   		<return-property name="numberOfRecordsConsidered" column="records_considered" />
	 	</return>
		{ call ht_survey_report.count_national_dist_mv( ?, :surveyVersion, :surveyType, :acceptedStatus ) }
	</sql-query>


	<sql-query name="SurveyReports.countDMPsUniqueICN" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.LocationReportDataType">
	   		<return-property name="location" column="location" />
			<return-property name="recordCount" column="record_count" />
	 	</return>
		{ call ht_survey_report.count_dmps_proc( ?, :surveyType, :location, :vendor, :startDate, :endDate ) }
	</sql-query>


 	<sql-query name="SurveyReports.DMPTitles" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.DMPTitleType">
            <return-property name="key" column="key" />
	   		<return-property name="title" column="title" />
	   		<return-property name="version" column="version" />
	 </return>
		{ call ht_survey_report.dmp_titles_proc( ? ) }
	</sql-query>
	<!--  Census report -->
 	<!-- CensusWeeklyVendorStatusReport --> 
	<sql-query name="SurveyReports.censusWeeklyVendorStatusReport" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.CensusVendorStatusDataType">
	   		<return-property name="number" column="vendor_facility" />
			<return-property name="name" column="vendor_name" />
			<return-property name="status" column="ingest_status" />
	 	</return>
		{ call census_reports.wkly_vndr_stat_rpt( ?, :startDate, :endDate ) }
	</sql-query>
	<!-- CensusPostProcessingStatusReport -->
	 
	<sql-query name="SurveyReports.censusPostProcessingStatusReport" callable="true" >
		<return class="gov.va.med.cds.ars.requestresponse.generated.CensusPostProcessingStatusReportType">
			<return-property name="overallCensusStatus" column="status" />
	 	</return>
		{ call census_reports.post_prcssng_rpt( ?, :startDate, :endDate ) }
	</sql-query>
	
	<sql-query name="SurveyReports.VISNFacility" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.VISNFacilityDataType">
		   		<return-property name="facilityNumber" column="station_no" />
		   		<return-property name="visn" column="visn" />
		   		<return-property name="facilityName" column="station_name" />
		 	</return>
				{ call census_reports.visn_fclty_rpt ( ? ) }
		</sql-query>
		
		<sql-query name="SurveyReports.Vendor" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusVendorReportDataType">
		   		<return-property name="number" column="vendor_facility" />
		   		<return-property name="name" column="vendor_name" />
		   		<return-property name="dateActive" column="date_active" />
		   		<return-property name="dateInactive" column="date_inactive" />
		 	</return>
				{ call census_reports.vndr_rpt ( ? ) }
		</sql-query>
		
		<sql-query name="SurveyReports.CensusStartEndDates" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusReportDatesDataType">
	            <return-property name="startDate" column="start_date" />
	            <return-property name="endDate" column="end_date" />
		 	</return>
			{ call census_reports.strtend_dt_rpt( ? ) }
		</sql-query>
		
		<sql-query name="SurveyReports.CensusWeeklyVendorStatus" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusVendorStatusDataType">
	            <return-property name="status" column="ingest_status" />
		 	</return>
			{ call census_reports.wkly_vndr_stat_rpt( ?,  :startDate, :endDate ) }
		</sql-query>
		
	 
		<sql-query name="SurveyReports.CensusTransmittalMode" callable="true" >
			<!-- 
			<return class="java.lang.String">
			-->
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusTransmittalModeReportDataType"> 
	            <return-property name="data" column="transmittal_mode" />
		 	</return>
			{ call census_reports.transmittal_mode_rpt( ? ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusPatientCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.patient_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusDMPCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.dmp_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusMedDevCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.medical_device_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusIVRCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.ivr_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusBrowserCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.browser_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusNotAssignedCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.not_assigned_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusMeasurementCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.measurement_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusVideoCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.video_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusCellCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.cell_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusSatelliteCountReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.satellite_count_rpt ( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		
		<!-- ============================================== -->
		<!-- =====      Start of Census Reports 3.12  ===== -->
		<!-- ============================================== -->
		<sql-query name="SurveyReports.LevelOfCare" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.HtLevelOfCareReportDataType"> 
	            <return-property name="code" column="level_care_code" />
	            <return-property name="description" column="level_care_descript" />
		 	</return>
			{ call census_reports.HTH_LEVELOFCARE_REPORT( ? ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusCocTotalPtNICReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.COC_TOTALPTNIC_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusCoCTotalPtCCMReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.COC_TOTALPTCCM_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusCoCTotalPtACMReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.COC_TOTALPTACM_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusCoCTotalPtHPDPReport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.COC_TOTALPTHPDP_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusCoCTotalPtL2Report" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.COC_TOTALPTL2_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusRrTotalFullRespRport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.RR_TOTALFULLRESP_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusRrTotalPartRespRport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.RR_TOTALPARTRESP_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusRrTotalNonRespRport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.RR_TOTALNONRESP_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusRrTotalUnkRespRport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.RR_TOTALUNKRESP_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusRrTotalNonRespGT30Rport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.RR_TOTALNONRESPGT30_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		
		<sql-query name="SurveyReports.censusRrTotalNonRespMaxRport" callable="true" >
			<return class="gov.va.med.cds.ars.persistence.CensusPatientCountDataType">
				<return-property name="key" column="key" />
	   			<return-property name="number" column="vendor_facility" />
				<return-property name="name" column="vendor_name" />
				<return-property name="count" column="episode_cnt" />
				<return-property name="location" column="geolocation" /> 
	 		</return>
			{ call census_reports.RR_TOTALNONRESPMAX_REPORT( ?, :startDate, :endDate, :geographicalArea, :vendor ) }
		</sql-query>
		<!-- =====      End of Census Reports 3.12    ===== -->
		
		<!-- ============================================== -->
		<!-- =====      Start of Census Reports 3.14  ===== -->
		<!-- ============================================== -->
		<sql-query name="CensusReports.hthCumulativemonthyearReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.HTHCumMonYearReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
	   			<return-property name="month" column="MONTH_TEXT_MNTH" />
				<return-property name="year" column="MONTH_TEXT_YEAR" />
				<return-property name="startDate" column="MONTH_START_DATE" />
				<return-property name="endDate" column="MONTH_END_DATE" /> 
	 		</return>
			{ call census_reports.HTH_CumulativeMonthYear_Report( ? ) }
		</sql-query>
		
		<sql-query name="CensusReports.hthFYQtrReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.FYQtrReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="quarterYear" column="FY_QUARTER_TEXT" />
				<return-property name="startDate" column="FY_QTR_START_DATE" />
				<return-property name="endDate" column="FY_QTR_END_DATE" /> 
	 		</return>
			{ call census_reports.HTH_FYQtr_Report( ? ) }
		</sql-query>
		<sql-query name="CensusReports.NicAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusNICADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Nic_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		<sql-query name="SurveyReports.TotalRuralvisnAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusTotalRuralVISNADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Total_Ruralvisn_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		<sql-query name="SurveyReports.RuralvisnAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusRuralVISNADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Ruralvisn_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		<sql-query name="SurveyReports.HighlyruralvisnAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusHighlyRuralVISNADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Highlyruralvisn_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		
		<sql-query name="SurveyReports.UrbanvisnAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusUrbanVISNADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Urbanvisn_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		<sql-query name="SurveyReports.UnknownvisnAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusUnknownVISNADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Unknownvisn_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		<sql-query name="SurveyReports.TotalRuralfacilityAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusTotalRuralFacilityADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Total_Ruralfacility_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		
		<sql-query name="SurveyReports.RuralfacilityAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusRuralFacilityADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Ruralfacility_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		
		<sql-query name="SurveyReports.HighlyruralfacilityAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusHighlyRuralFacilityADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Highlyruralfacility_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		
		<sql-query name="SurveyReports.UrbanFacilityADCReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusUrbanFacilityADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.UrbanFacility_ADC_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		
		<sql-query name="SurveyReports.UnknownfacilityAdcReport" callable="true" >
			<return class="gov.va.med.cds.ars.requestresponse.generated.CensusUnknownFacilityADCLocationReportDataType">
				<return-property name="rowNum" column="ROW_NUM" />
				<return-property name="numberOfDays" column="NUMBER_OF_DAYS" />
				<return-property name="repeatingInterval" column="AGGR_ROW_COUNT" />
				<return-property name="geoLocation" column="GEOLOCATION" />
	 		</return>
			{ call census_reports.Unknownfacility_Adc_Report( ?, :startDate, :endDate, :location ) }
		</sql-query>
		<!-- =====      End of Census Reports 3.14    ===== -->
		
</hibernate-mapping>
