-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 29, 2015 at 01:26 PM
-- Server version: 5.6.27-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `openmrs`
--

-- --------------------------------------------------------

--
-- Table structure for table `serialized_object`
--

CREATE TABLE IF NOT EXISTS `serialized_object` (
  `serialized_object_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(5000) DEFAULT NULL,
  `type` varchar(255) NOT NULL,
  `subtype` varchar(255) NOT NULL,
  `serialization_class` varchar(255) NOT NULL,
  `serialized_data` mediumtext NOT NULL,
  `date_created` datetime NOT NULL,
  `creator` int(11) NOT NULL,
  `date_changed` datetime DEFAULT NULL,
  `changed_by` int(11) DEFAULT NULL,
  `retired` tinyint(1) NOT NULL DEFAULT '0',
  `date_retired` datetime DEFAULT NULL,
  `retired_by` int(11) DEFAULT NULL,
  `retire_reason` varchar(1000) DEFAULT NULL,
  `uuid` char(38) DEFAULT NULL,
  PRIMARY KEY (`serialized_object_id`),
  UNIQUE KEY `serialized_object_uuid_index` (`uuid`),
  KEY `serialized_object_creator` (`creator`),
  KEY `serialized_object_changed_by` (`changed_by`),
  KEY `serialized_object_retired_by` (`retired_by`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;

--
-- Dumping data for table `serialized_object`
--

INSERT INTO `serialized_object` (`serialized_object_id`, `name`, `description`, `type`, `subtype`, `serialization_class`, `serialized_data`, `date_created`, `creator`, `date_changed`, `changed_by`, `retired`, `date_retired`, `retired_by`, `retire_reason`, `uuid`) VALUES
(2, 'Users', 'List of users in the system.', 'org.openmrs.module.reporting.dataset.definition.DataSetDefinition', 'org.openmrs.module.reporting.dataset.definition.SqlDataSetDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.dataset.definition.SqlDataSetDefinition id="1" uuid="c804a31e-9c63-484f-ae42-c9a34cc3fbd8" retired="false">\n  <name>Users</name>\n  <description>List of users in the system.</description>\n  <creator class="org.openmrs.User_$$_jvst35_41" id="2" uuid="4882dd60-0508-11e3-8ffd-0800200c9a66"/>\n  <dateCreated id="3">2015-10-09 19:15:11 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-09 19:16:27 UTC</dateChanged>\n  <parameters id="5"/>\n  <id>2</id>\n  <sqlQuery>SELECT username FROM users WHERE retired=0</sqlQuery>\n</org.openmrs.module.reporting.dataset.definition.SqlDataSetDefinition>', '2015-10-09 19:15:11', 3, '2015-10-09 19:16:27', 3, 0, NULL, NULL, NULL, 'c804a31e-9c63-484f-ae42-c9a34cc3fbd8'),
(3, 'Users', 'Usernames of the system.', 'org.openmrs.module.reporting.report.definition.ReportDefinition', 'org.openmrs.module.reporting.report.definition.ReportDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.report.definition.ReportDefinition id="1" uuid="92499d95-0d6c-4c93-8bd8-3cc94e38ed7f" retired="false">\n  <name>Users</name>\n  <description>Usernames of the system.</description>\n  <creator class="org.openmrs.User_$$_jvst2b4_41" id="2" uuid="47b1bb8d-6e9a-11e5-96ac-f23c913ba178"/>\n  <dateCreated id="3">2015-10-13 17:07:41 UTC</dateCreated>\n  <parameters id="4"/>\n</org.openmrs.module.reporting.report.definition.ReportDefinition>', '2015-10-13 13:07:41', 1, NULL, NULL, 0, NULL, NULL, NULL, '92499d95-0d6c-4c93-8bd8-3cc94e38ed7f'),
(5, 'Unknown Gender', 'Patients without a gender/sex.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition id="1" uuid="04e3db87-8a7a-4b15-bdcc-9a304e9c0ac0" retired="false">\n  <name>Unknown Gender</name>\n  <description>Patients without a gender/sex.</description>\n  <creator id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 14:27:13 UTC</dateCreated>\n  <parameters id="4"/>\n  <maleIncluded>false</maleIncluded>\n  <femaleIncluded>false</femaleIncluded>\n  <unknownGenderIncluded>true</unknownGenderIncluded>\n</org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition>', '2015-10-28 10:27:14', 9, NULL, NULL, 0, NULL, NULL, NULL, '04e3db87-8a7a-4b15-bdcc-9a304e9c0ac0'),
(6, 'Male Gender', 'Boys and Men', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition id="1" uuid="8772f818-2e96-49e1-afd1-e6e27e734219" retired="false">\n  <name>Male Gender</name>\n  <description>Boys and Men</description>\n  <creator id="2" uuid="e9cce508-45b9-460b-8ee6-c17664286158"/>\n  <dateCreated id="3">2015-10-28 14:27:15 UTC</dateCreated>\n  <parameters id="4"/>\n  <maleIncluded>true</maleIncluded>\n  <femaleIncluded>false</femaleIncluded>\n  <unknownGenderIncluded>false</unknownGenderIncluded>\n</org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition>', '2015-10-28 10:27:15', 8, NULL, NULL, 0, NULL, NULL, NULL, '8772f818-2e96-49e1-afd1-e6e27e734219'),
(7, 'Female Gender', 'Patients that are girls and women.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition id="1" uuid="6eb0e900-4f8b-4bba-8c8f-614b92b4321b" retired="false">\n  <name>Female Gender</name>\n  <description>Patients that are girls and women.</description>\n  <creator id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 14:27:16 UTC</dateCreated>\n  <parameters id="4"/>\n  <maleIncluded>false</maleIncluded>\n  <femaleIncluded>true</femaleIncluded>\n  <unknownGenderIncluded>false</unknownGenderIncluded>\n</org.openmrs.module.reporting.cohort.definition.GenderCohortDefinition>', '2015-10-28 10:27:16', 22, NULL, NULL, 0, NULL, NULL, NULL, '6eb0e900-4f8b-4bba-8c8f-614b92b4321b'),
(8, 'Age 45 to 64', 'Patients between 45 and 64 years of age.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition id="1" uuid="aba4adfc-ef36-44e1-a933-915c476d9e17" retired="false">\n  <name>Age 45 to 64</name>\n  <description>Patients between 45 and 64 years of age.</description>\n  <creator id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 14:36:46 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>effectiveDate</name>\n      <label>AgeOnDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <minAge>45</minAge>\n  <minAgeUnit>YEARS</minAgeUnit>\n  <maxAge>64</maxAge>\n  <maxAgeUnit>YEARS</maxAgeUnit>\n  <unknownAgeIncluded>false</unknownAgeIncluded>\n</org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition>', '2015-10-28 10:36:47', 9, NULL, NULL, 0, NULL, NULL, NULL, 'aba4adfc-ef36-44e1-a933-915c476d9e17'),
(9, 'Age 30 to 44', 'Patients between 30 to 44 of age.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition id="1" uuid="ae1cd627-1613-4757-8226-5cd19c163189" retired="false">\n  <name>Age 30 to 44</name>\n  <description>Patients between 30 to 44 of age.</description>\n  <creator id="2" uuid="e9cce508-45b9-460b-8ee6-c17664286158"/>\n  <dateCreated id="3">2015-10-28 14:36:46 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>effectiveDate</name>\n      <label>AgeOnDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <minAge>30</minAge>\n  <minAgeUnit>YEARS</minAgeUnit>\n  <maxAge>44</maxAge>\n  <maxAgeUnit>YEARS</maxAgeUnit>\n  <unknownAgeIncluded>false</unknownAgeIncluded>\n</org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition>', '2015-10-28 10:36:47', 8, NULL, NULL, 0, NULL, NULL, NULL, 'ae1cd627-1613-4757-8226-5cd19c163189'),
(10, 'Age 14 to 29', 'Patient between 14 and 29 years of age.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition id="1" uuid="654a1242-3720-4c20-87f4-f94cd1baec08" retired="false">\n  <name>Age 14 to 29</name>\n  <description>Patient between 14 and 29 years of age.</description>\n  <creator id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 14:36:48 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>effectiveDate</name>\n      <label>AgeOnDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <minAge>14</minAge>\n  <minAgeUnit>YEARS</minAgeUnit>\n  <maxAge>29</maxAge>\n  <maxAgeUnit>YEARS</maxAgeUnit>\n  <unknownAgeIncluded>false</unknownAgeIncluded>\n</org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition>', '2015-10-28 10:36:48', 22, NULL, NULL, 0, NULL, NULL, NULL, '654a1242-3720-4c20-87f4-f94cd1baec08'),
(11, 'Age 0 to 13', 'Patient is 0 to 13 years of age.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition id="1" uuid="69e165f4-cda4-4e82-abec-f8947df6b08f" retired="false">\n  <name>Age 0 to 13</name>\n  <description>Patient is 0 to 13 years of age.</description>\n  <creator id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 14:46:36 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>effectiveDate</name>\n      <label>AgeOnDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <minAge>0</minAge>\n  <minAgeUnit>YEARS</minAgeUnit>\n  <maxAge>13</maxAge>\n  <maxAgeUnit>YEARS</maxAgeUnit>\n  <unknownAgeIncluded>false</unknownAgeIncluded>\n</org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition>', '2015-10-28 10:46:36', 22, NULL, NULL, 0, NULL, NULL, NULL, '69e165f4-cda4-4e82-abec-f8947df6b08f'),
(12, 'Age 65+', 'Patient Age of 65+', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition id="1" uuid="11513e7d-8a00-4264-ac9f-2101cfe8b53a" retired="false">\n  <name>Age 65+</name>\n  <description>Patient Age of 65+</description>\n  <creator id="2" uuid="e9cce508-45b9-460b-8ee6-c17664286158"/>\n  <dateCreated id="3">2015-10-28 14:48:18 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>effectiveDate</name>\n      <label>AgeOnDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <minAge>65</minAge>\n  <minAgeUnit>YEARS</minAgeUnit>\n  <maxAgeUnit>YEARS</maxAgeUnit>\n  <unknownAgeIncluded>false</unknownAgeIncluded>\n</org.openmrs.module.reporting.cohort.definition.AgeCohortDefinition>', '2015-10-28 10:48:18', 8, NULL, NULL, 0, NULL, NULL, NULL, '11513e7d-8a00-4264-ac9f-2101cfe8b53a'),
(13, 'Hospitalization Location Rehydration Center', 'Patients that were hospitalized in Rehydration Center.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition id="1" uuid="2050335e-46e0-4fb4-a009-9685a674df33" retired="false">\n  <name>Hospitalization Location Rehydration Center</name>\n  <description>Patients that were hospitalized in Rehydration Center.</description>\n  <creator id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 15:05:52 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>onOrAfter</name>\n      <label>StartDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <timeQualifier>ANY</timeQualifier>\n  <encounterTypeList id="7">\n    <encounterType id="8" uuid="e22e39fd-7db2-45e7-80f1-60fa0d5a4378"/>\n  </encounterTypeList>\n  <locationList id="9">\n    <location id="10" uuid="fe2ac248-1f55-42b6-8a33-39c108e45350"/>\n  </locationList>\n  <returnInverse>false</returnInverse>\n</org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition>', '2015-10-28 11:05:53', 9, NULL, NULL, 0, NULL, NULL, NULL, '2050335e-46e0-4fb4-a009-9685a674df33'),
(14, 'Hospitalization Location ICU', 'Patient that were hospitalized in the ICU', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition id="1" uuid="0896e7cc-bc8c-4a1e-82dd-a27526bd4d12" retired="false">\n  <name>Hospitalization Location ICU</name>\n  <description>Patient that were hospitalized in the ICU</description>\n  <creator id="2" uuid="e9cce508-45b9-460b-8ee6-c17664286158"/>\n  <dateCreated id="3">2015-10-28 15:05:54 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>onOrAfter</name>\n      <label>StartDate </label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <timeQualifier>ANY</timeQualifier>\n  <encounterTypeList id="7">\n    <encounterType id="8" uuid="e22e39fd-7db2-45e7-80f1-60fa0d5a4378"/>\n  </encounterTypeList>\n  <locationList id="9">\n    <location id="10" uuid="9785a92b-af49-48c1-8eb0-c8ff02931555"/>\n  </locationList>\n  <returnInverse>false</returnInverse>\n</org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition>', '2015-10-28 11:05:54', 8, NULL, NULL, 0, NULL, NULL, NULL, '0896e7cc-bc8c-4a1e-82dd-a27526bd4d12'),
(15, 'Hospital Location ER', 'Patient received care in ER.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition id="1" uuid="c8bb761d-acc6-4012-8e60-420a07559082" retired="false">\n  <name>Hospital Location ER</name>\n  <description>Patient received care in ER.</description>\n  <creator id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 15:05:54 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>onOrAfter</name>\n      <label>StartDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <timeQualifier>ANY</timeQualifier>\n  <encounterTypeList id="7">\n    <encounterType id="8" uuid="e22e39fd-7db2-45e7-80f1-60fa0d5a4378"/>\n  </encounterTypeList>\n  <locationList id="9">\n    <location id="10" uuid="ef84112c-aecf-49df-9527-22d693a1bcc3"/>\n  </locationList>\n  <returnInverse>false</returnInverse>\n</org.openmrs.module.reporting.cohort.definition.EncounterCohortDefinition>', '2015-10-28 11:05:55', 22, NULL, NULL, 0, NULL, NULL, NULL, 'c8bb761d-acc6-4012-8e60-420a07559082'),
(16, 'Referred In', 'Patient has been referred to the hospital.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition id="1" uuid="e5eaecc2-1697-4318-99bc-2e6196c73f82" retired="false">\n  <name>Referred In</name>\n  <description>Patient has been referred to the hospital.</description>\n  <creator class="org.openmrs.User_$$_jvst6de_41" id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 15:17:11 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 15:27:21 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrAfter</name>\n      <label>StartDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>16</id>\n  <timeModifier>ANY</timeModifier>\n  <question id="8" uuid="1648AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  <operator>IN</operator>\n  <valueList id="9">\n    <concept id="10" uuid="1065AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  </valueList>\n</org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition>', '2015-10-28 11:17:11', 22, '2015-10-28 11:27:22', 22, 0, NULL, NULL, NULL, 'e5eaecc2-1697-4318-99bc-2e6196c73f82'),
(17, 'Not Referred In', 'Patient was not referred to hospital.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition id="1" uuid="8abaa1dd-38a3-4f11-abe2-6d7b203b0025" retired="false">\n  <name>Not Referred In</name>\n  <description>Patient was not referred to hospital.</description>\n  <creator id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 15:29:26 UTC</dateCreated>\n  <parameters id="4"/>\n  <baseDefinition class="org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition" id="5" uuid="e5eaecc2-1697-4318-99bc-2e6196c73f82"/>\n</org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition>', '2015-10-28 11:29:26', 22, NULL, NULL, 0, NULL, NULL, NULL, '8abaa1dd-38a3-4f11-abe2-6d7b203b0025'),
(18, 'Referred Out', 'Patient referred out of hospital for continuation of treatment.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition id="1" uuid="d93d16b9-0280-4ed0-b0a0-891b64182439" retired="false">\n  <name>Referred Out</name>\n  <description>Patient referred out of hospital for continuation of treatment.</description>\n  <creator class="org.openmrs.User_$$_jvst6de_41" id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 15:33:26 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 15:52:16 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrAfter</name>\n      <label>StartDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>18</id>\n  <timeModifier>ANY</timeModifier>\n  <question id="8" uuid="1695AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  <operator>IN</operator>\n  <valueList id="9">\n    <concept id="10" uuid="1693AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  </valueList>\n</org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition>', '2015-10-28 11:33:26', 22, '2015-10-28 11:52:17', 22, 0, NULL, NULL, NULL, 'd93d16b9-0280-4ed0-b0a0-891b64182439'),
(19, 'Not Referred Out', 'Patient was NOT referred out of the hospital for continuation of treatment.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition id="1" uuid="a1c325fc-749b-426d-851f-d6b2ddc3e618" retired="false">\n  <name>Not Referred Out</name>\n  <description>Patient was NOT referred out of the hospital for continuation of treatment.</description>\n  <creator id="2" uuid="e9cce508-45b9-460b-8ee6-c17664286158"/>\n  <dateCreated id="3">2015-10-28 15:35:38 UTC</dateCreated>\n  <parameters id="4"/>\n  <baseDefinition class="org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition" id="5" uuid="d93d16b9-0280-4ed0-b0a0-891b64182439"/>\n</org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition>', '2015-10-28 11:35:39', 8, NULL, NULL, 0, NULL, NULL, NULL, 'a1c325fc-749b-426d-851f-d6b2ddc3e618'),
(20, 'ER and ICU Report', 'Aggregate Report for ER/ICU/Rehydration.', 'org.openmrs.module.reporting.report.definition.ReportDefinition', 'org.openmrs.module.reporting.report.definition.ReportDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.report.definition.ReportDefinition id="1" uuid="ee8ec0e1-db59-4cf0-8b4b-cc3666bb1e2e" retired="false">\n  <name>ER and ICU Report</name>\n  <description>Aggregate Report for ER/ICU/Rehydration.</description>\n  <creator id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 15:54:45 UTC</dateCreated>\n  <parameters id="4"/>\n</org.openmrs.module.reporting.report.definition.ReportDefinition>', '2015-10-28 11:54:46', 9, NULL, NULL, 0, NULL, NULL, NULL, 'ee8ec0e1-db59-4cf0-8b4b-cc3666bb1e2e'),
(21, 'Discharge Status Deceased', 'Patient was deceased upon discharge.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition id="1" uuid="270a3f1b-fd05-4682-99fe-ac750164d854" retired="false">\n  <name>Discharge Status Deceased</name>\n  <description>Patient was deceased upon discharge.</description>\n  <creator id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 16:08:35 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>onOrAfter</name>\n      <label>StartDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <timeModifier>ANY</timeModifier>\n  <question id="7" uuid="1695AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  <operator>IN</operator>\n  <valueList id="8">\n    <concept id="9" uuid="159AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  </valueList>\n</org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition>', '2015-10-28 12:08:35', 22, NULL, NULL, 0, NULL, NULL, NULL, '270a3f1b-fd05-4682-99fe-ac750164d854'),
(22, 'Discharge Status Cured', 'Patient left cured.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition id="1" uuid="367e21b4-7f3c-4a48-845b-72cccc624ba5" retired="false">\n  <name>Discharge Status Cured</name>\n  <description>Patient left cured.</description>\n  <creator id="2" uuid="e9cce508-45b9-460b-8ee6-c17664286158"/>\n  <dateCreated id="3">2015-10-28 16:11:22 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>onOrAfter</name>\n      <label>StartDate </label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <timeModifier>ANY</timeModifier>\n  <question id="7" uuid="1695AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  <operator>IN</operator>\n  <valueList id="8">\n    <concept id="9" uuid="159791AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  </valueList>\n</org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition>', '2015-10-28 12:11:23', 8, NULL, NULL, 0, NULL, NULL, NULL, '367e21b4-7f3c-4a48-845b-72cccc624ba5'),
(23, 'Discharge Status Left Against Medical Advice', 'Patient left against medical advice.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition id="1" uuid="4316fd24-bcae-4433-b2f9-5c57b05a6667" retired="false">\n  <name>Discharge Status Left Against Medical Advice</name>\n  <description>Patient left against medical advice.</description>\n  <creator id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 16:11:25 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>onOrAfter</name>\n      <label>StartDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <timeModifier>ANY</timeModifier>\n  <question id="7" uuid="1695AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  <operator>IN</operator>\n  <valueList id="8">\n    <concept id="9" uuid="1694AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  </valueList>\n</org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition>', '2015-10-28 12:11:26', 9, NULL, NULL, 0, NULL, NULL, NULL, '4316fd24-bcae-4433-b2f9-5c57b05a6667'),
(24, 'Discharge Status Transferred', 'Patient was transferred upon discharge.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition id="1" uuid="0dc2734f-a3f3-47af-957c-438116468926" retired="false">\n  <name>Discharge Status Transferred</name>\n  <description>Patient was transferred upon discharge.</description>\n  <creator id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 16:13:53 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>onOrAfter</name>\n      <label>StartDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <timeModifier>ANY</timeModifier>\n  <question id="7" uuid="1695AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  <operator>IN</operator>\n  <valueList id="8">\n    <concept id="9" uuid="1693AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  </valueList>\n</org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition>', '2015-10-28 12:13:53', 22, NULL, NULL, 0, NULL, NULL, NULL, '0dc2734f-a3f3-47af-957c-438116468926'),
(25, 'Discharge Status Treatment Complete', 'Patient completed treatment.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition id="1" uuid="540d527b-56e8-42f2-8c2f-e87b50f046e8" retired="false">\n  <name>Discharge Status Treatment Complete</name>\n  <description>Patient completed treatment.</description>\n  <creator id="2" uuid="e9cce508-45b9-460b-8ee6-c17664286158"/>\n  <dateCreated id="3">2015-10-28 16:21:19 UTC</dateCreated>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>onOrAfter</name>\n      <label>StartDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrBefore</name>\n      <label>EndDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <timeModifier>ANY</timeModifier>\n  <question id="7" uuid="1695AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  <operator>IN</operator>\n  <valueList id="8">\n    <concept id="9" uuid="160035AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  </valueList>\n</org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition>', '2015-10-28 12:21:20', 8, NULL, NULL, 0, NULL, NULL, NULL, '540d527b-56e8-42f2-8c2f-e87b50f046e8'),
(26, 'Address Metropolitan', 'Patients with a Port-au-Prince Metropolitan area address.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="630c5199-810f-4207-a39c-2e8e2c9c32a0" retired="false">\n  <name>Address Metropolitan</name>\n  <description>Patients with a Port-au-Prince Metropolitan area address.</description>\n  <creator class="org.openmrs.User_$$_jvst6de_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 16:52:55 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 16:53:37 UTC</dateChanged>\n  <parameters id="5"/>\n  <id>26</id>\n  <query>SELECT `person_id` FROM `person_address` WHERE `voided` = 0 AND (`city_village` LIKE &apos;Port-au-Prince&apos; OR `city_village` LIKE &apos;Petion-Ville&apos; OR `city_village` LIKE &apos;Carrefour&apos; OR `city_village` LIKE &apos;Cite Soleil&apos; OR `city_village` LIKE &apos;Tabarre&apos; OR `city_village` LIKE &apos;Delmas&apos; OR `city_village` LIKE &apos;Kenscoff&apos; OR `city_village` LIKE &apos;Croix-des-Bouquets&apos;) </query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 12:52:55', 9, '2015-10-28 12:53:38', 9, 1, '2015-10-28 15:32:37', 9, 'duplicate', '630c5199-810f-4207-a39c-2e8e2c9c32a0'),
(27, 'Address Non-Metropolitan', 'Patients with an address outside of the Port-au-Prince Metropolitan area.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition id="1" uuid="125e799d-1a38-4edb-af7a-324ea62f98be" retired="false">\n  <name>Address Non-Metropolitan</name>\n  <description>Patients with an address outside of the Port-au-Prince Metropolitan area.</description>\n  <creator class="org.openmrs.User_$$_jvste26_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 16:57:44 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 19:31:07 UTC</dateChanged>\n  <parameters id="5"/>\n  <id>27</id>\n  <baseDefinition class="org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition" id="6" uuid="15f15562-aeb8-466f-b9ea-5688ee22fb6e"/>\n</org.openmrs.module.reporting.cohort.definition.InverseCohortDefinition>', '2015-10-28 12:57:44', 9, '2015-10-28 15:31:08', 9, 0, NULL, NULL, NULL, '125e799d-1a38-4edb-af7a-324ea62f98be'),
(28, 'Admission Night', 'The patient was admitted between 19:00 and 06:59 hours.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="9d6d3ce0-0663-4ec8-9cb0-c47d6f563c2f" retired="false">\n  <name>Admission Night</name>\n  <description>The patient was admitted between 19:00 and 06:59 hours.</description>\n  <creator class="org.openmrs.User_$$_jvst6de_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 17:21:31 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 17:36:45 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>startDate</name>\n      <label>Start Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>endDate</name>\n      <label>End Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>28</id>\n  <query>SELECT person_id FROM `obs` WHERE `concept_id` = 1640 AND `voided` = 0 AND EXTRACT(HOUR FROM value_datetime) IN (0,1,2,3,4,5,6,19,20,21,22,23) AND obs_datetime &gt;= :startDate AND obs_datetime &lt; addDate(:endDate,1)</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 13:21:31', 9, '2015-10-28 13:36:45', 9, 1, '2015-10-28 15:34:51', 9, 'duplicate', '9d6d3ce0-0663-4ec8-9cb0-c47d6f563c2f'),
(30, 'Admission Day', 'The patient was admitted between 07:00 and 18:59 hours.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="872c2e2f-f214-4512-82f4-6478c70dec32" retired="false">\n  <name>Admission Day</name>\n  <description>The patient was admitted between 07:00 and 18:59 hours.</description>\n  <creator class="org.openmrs.User_$$_jvst6de_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 17:35:22 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 17:36:15 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>startDate</name>\n      <label>Start Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>endDate</name>\n      <label>End Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>30</id>\n  <query>SELECT person_id FROM `obs` WHERE `concept_id` = 1640 AND `voided` = 0 AND EXTRACT(HOUR FROM value_datetime) IN (7,8,9,10,11,12,13,14,15,16,17,18) AND obs_datetime &gt;= :startDate AND obs_datetime &lt; addDate(:endDate,1)</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 13:35:22', 9, '2015-10-28 13:36:15', 9, 1, '2015-10-28 15:37:08', 9, 'duplicate', '872c2e2f-f214-4512-82f4-6478c70dec32'),
(31, 'Test', '', 'org.openmrs.module.reporting.dataset.definition.DataSetDefinition', 'org.openmrs.module.reporting.dataset.definition.CohortCrossTabDataSetDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.dataset.definition.CohortCrossTabDataSetDefinition id="1" uuid="2065d1f9-2c45-4f01-9fb8-83b30fa210cf" retired="false">\n  <name>Test</name>\n  <description></description>\n  <creator id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 18:21:51 UTC</dateCreated>\n  <parameters id="4"/>\n</org.openmrs.module.reporting.dataset.definition.CohortCrossTabDataSetDefinition>', '2015-10-28 14:21:51', 9, NULL, NULL, 0, NULL, NULL, NULL, '2065d1f9-2c45-4f01-9fb8-83b30fa210cf'),
(32, 'Final Diagnosis - Asthma', '', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="10f52b51-f76c-44a0-9773-55eff98bacac" retired="false">\n  <name>Final Diagnosis - Asthma</name>\n  <description></description>\n  <creator class="org.openmrs.User_$$_jvst6de_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 18:44:56 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 18:51:14 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>startDate</name>\n      <label>Start Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>endDate</name>\n      <label>End Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>32</id>\n  <query>SELECT `diagnosis`.`person_id` FROM `obs` as diagnosis, `obs` as cert WHERE `diagnosis`.`concept_id` = &apos;1284&apos; AND `cert`.`concept_id` = &apos;159394&apos; AND `cert`.`voided` = &apos;0&apos; AND `diagnosis`.`voided` = &apos;0&apos; and `cert`.`value_coded` = &apos;160250&apos; AND `diagnosis`.`obs_group_id`=`cert`.`obs_group_id` AND obs_datetime &gt;= :startDate AND obs_datetime &lt; addDate(:endDate,1) AND `diagnosis`.`value_coded` = &apos;121375&apos;</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 14:44:56', 9, '2015-10-28 14:51:15', 9, 9, '2015-10-28 15:38:04', 9, 'duplicate', '10f52b51-f76c-44a0-9773-55eff98bacac'),
(33, 'Final Diagnosis - Asthma', '', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="068e0c22-86cd-4054-b6d3-3250d2fc25ad" retired="false">\n  <name>Final Diagnosis - Asthma</name>\n  <description></description>\n  <creator class="org.openmrs.User_$$_jvste26_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 19:01:35 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 19:07:24 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>startDate</name>\n      <label>Start Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>endDate</name>\n      <label>End Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>33</id>\n  <query>SELECT `diagnosis`.`person_id` FROM `obs` as diagnosis, `obs` as cert WHERE `diagnosis`.`concept_id` = &apos;1284&apos; AND `cert`.`concept_id` = &apos;159394&apos; AND `cert`.`voided` = &apos;0&apos; AND `diagnosis`.`voided` = &apos;0&apos; and `cert`.`value_coded` = &apos;160250&apos; AND `diagnosis`.`obs_group_id`=`cert`.`obs_group_id` AND  `diagnosis`.obs_datetime &gt;= :startDate AND `diagnosis`.obs_datetime &lt; addDate(:endDate,1) AND `diagnosis`.`value_coded` = &apos;121375&apos;</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 15:01:35', 9, '2015-10-28 15:07:25', 9, 0, NULL, NULL, NULL, '068e0c22-86cd-4054-b6d3-3250d2fc25ad'),
(34, 'Final Diagnosis - Prostatectomy', '', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="9a20026f-1908-4a7b-b939-319ccbe30173" retired="false">\n  <name>Final Diagnosis - Prostatectomy</name>\n  <description></description>\n  <creator class="org.openmrs.User_$$_jvste26_41" id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 19:09:32 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 19:12:16 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>startDate</name>\n      <label>Start Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>endDate</name>\n      <label>End Date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>34</id>\n  <query>SELECT `diagnosis`.`person_id` FROM `obs` as diagnosis, `obs` as cert WHERE `diagnosis`.`concept_id` = &apos;1284&apos; AND `cert`.`concept_id` = &apos;159394&apos; AND `cert`.`voided` = &apos;0&apos; AND `diagnosis`.`voided` = &apos;0&apos; and `cert`.`value_coded` = &apos;160250&apos; AND `diagnosis`.`obs_group_id`=`cert`.`obs_group_id` AND  `diagnosis`.obs_datetime &gt;= :startDate AND `diagnosis`.obs_datetime &lt; addDate(:endDate,1) AND `diagnosis`.`value_coded` = &apos;162921&apos;</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 15:09:32', 22, '2015-10-28 15:12:16', 22, 0, NULL, NULL, NULL, '9a20026f-1908-4a7b-b939-319ccbe30173'),
(35, 'Address Metropolitan', 'Patients with a Port-au-Prince Metropolitan area address.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="15f15562-aeb8-466f-b9ea-5688ee22fb6e" retired="false">\n  <name>Address Metropolitan</name>\n  <description>Patients with a Port-au-Prince Metropolitan area address.</description>\n  <creator class="org.openmrs.User_$$_jvste26_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 19:26:33 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 19:30:35 UTC</dateChanged>\n  <parameters id="5"/>\n  <id>35</id>\n  <query>SELECT `person_id` FROM `person_address` WHERE `voided` = 0 AND (`city_village` LIKE &apos;Port-au-Prince&apos; OR `city_village` LIKE &apos;Petion-Ville&apos; OR `city_village` LIKE &apos;Carrefour&apos; OR `city_village` LIKE &apos;Cite Soleil&apos; OR `city_village` LIKE &apos;Tabarre&apos; OR `city_village` LIKE &apos;Delmas&apos; OR `city_village` LIKE &apos;Kenscoff&apos; OR `city_village` LIKE &apos;Croix-des-Bouquets&apos;)</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 15:26:33', 9, '2015-10-28 15:30:36', 9, 0, NULL, NULL, NULL, '15f15562-aeb8-466f-b9ea-5688ee22fb6e'),
(36, 'Admission Night', 'The patient was admitted between 19:00 and 06:59 hours.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="7a2a9665-590f-4aae-939a-74c772552cd0" retired="false">\n  <name>Admission Night</name>\n  <description>The patient was admitted between 19:00 and 06:59 hours.</description>\n  <creator class="org.openmrs.User_$$_jvste26_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 19:33:17 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 19:34:56 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>startDate</name>\n      <label>startDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>endDate</name>\n      <label>endDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>36</id>\n  <query>SELECT person_id FROM `obs` WHERE `concept_id` = 1640 AND `voided` = 0 AND EXTRACT(HOUR FROM value_datetime) IN (0,1,2,3,4,5,6,19,20,21,22,23) AND obs_datetime &gt;= :startDate AND obs_datetime &lt; addDate(:endDate,1)</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 15:33:17', 9, '2015-10-28 15:34:57', 9, 0, NULL, NULL, NULL, '7a2a9665-590f-4aae-939a-74c772552cd0'),
(37, 'Admission Day', 'The patient was admitted between 07:00 and 18:59 hours.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="1115f113-3b56-42e0-977d-6afcd67bb3a7" retired="false">\n  <name>Admission Day</name>\n  <description>The patient was admitted between 07:00 and 18:59 hours.</description>\n  <creator class="org.openmrs.User_$$_jvste26_41" id="2" uuid="5308bfbe-d4a3-4e53-a543-c1bb9cf38b2d"/>\n  <dateCreated id="3">2015-10-28 19:35:43 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 19:36:40 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>startDate</name>\n      <label>startDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>endDate</name>\n      <label>endDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>37</id>\n  <query>SELECT person_id FROM `obs` WHERE `concept_id` = 1640 AND `voided` = 0 AND EXTRACT(HOUR FROM value_datetime) IN (7,8,9,10,11,12,13,14,15,16,17,18) AND obs_datetime &gt;= :startDate AND obs_datetime &lt; addDate(:endDate,1)</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 15:35:43', 9, '2015-10-28 15:36:40', 9, 0, NULL, NULL, NULL, '1115f113-3b56-42e0-977d-6afcd67bb3a7');
INSERT INTO `serialized_object` (`serialized_object_id`, `name`, `description`, `type`, `subtype`, `serialization_class`, `serialized_data`, `date_created`, `creator`, `date_changed`, `changed_by`, `retired`, `date_retired`, `retired_by`, `retire_reason`, `uuid`) VALUES
(38, 'Final Diagnosis - Circumcision ', '', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition id="1" uuid="ebd7c311-95ba-4239-ac33-749655dbef9f" retired="false">\n  <name>Final Diagnosis - Circumcision </name>\n  <description></description>\n  <creator class="org.openmrs.User_$$_jvste26_41" id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 19:41:22 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 19:41:56 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>startDate</name>\n      <label>startDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>endDate</name>\n      <label>endDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>38</id>\n  <query>SELECT `diagnosis`.`person_id` FROM `obs` as diagnosis, `obs` as cert WHERE `diagnosis`.`concept_id` = &apos;1284&apos; AND `cert`.`concept_id` = &apos;159394&apos; AND `cert`.`voided` = &apos;0&apos; AND `diagnosis`.`voided` = &apos;0&apos; and `cert`.`value_coded` = &apos;160250&apos; AND `diagnosis`.`obs_group_id`=`cert`.`obs_group_id` AND  `diagnosis`.obs_datetime &gt;= :startDate AND `diagnosis`.obs_datetime &lt; addDate(:endDate,1) AND `diagnosis`.`value_coded` = &apos;161803&apos;</query>\n</org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition>', '2015-10-28 15:41:22', 22, '2015-10-28 15:41:57', 22, 0, NULL, NULL, NULL, 'ebd7c311-95ba-4239-ac33-749655dbef9f'),
(39, 'Referred In', 'Patient was referred to hospital for treatment.', 'org.openmrs.module.reporting.cohort.definition.CohortDefinition', 'org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition id="1" uuid="5f7dbaf1-9ab0-4501-9f5d-f75e243a0301" retired="false">\n  <name>Referred In</name>\n  <description>Patient was referred to hospital for treatment.</description>\n  <creator id="2" uuid="8ed20a63-2da6-4bf4-8ebd-5cca2c9e7fa4"/>\n  <dateCreated id="3">2015-10-28 19:52:51 UTC</dateCreated>\n  <changedBy reference="2"/>\n  <dateChanged id="4">2015-10-28 19:55:20 UTC</dateChanged>\n  <parameters id="5">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>onOrAfter</name>\n      <label>startDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="7">\n      <name>onOrBefore</name>\n      <label>endDate</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>39</id>\n  <timeModifier>ANY</timeModifier>\n  <question id="8" uuid="1648AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  <encounterTypeList id="9">\n    <encounterType id="10" uuid="eeac43bf-8fd8-4f3b-abe4-1855e865ccf1"/>\n  </encounterTypeList>\n  <operator>IN</operator>\n  <valueList id="11">\n    <concept id="12" uuid="1065AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA"/>\n  </valueList>\n</org.openmrs.module.reporting.cohort.definition.CodedObsCohortDefinition>', '2015-10-28 15:52:51', 22, '2015-10-28 15:55:20', 22, 0, NULL, NULL, NULL, '5f7dbaf1-9ab0-4501-9f5d-f75e243a0301'),
(40, 'appointmentschedulingui.appointmentDataSetDefinition.dailyAppointments', 'appointmentschedulingui.appointmentDataSetDefinition.dailyAppointments', 'org.openmrs.module.reporting.dataset.definition.DataSetDefinition', 'org.openmrs.module.appointmentscheduling.reporting.dataset.definition.AppointmentDataSetDefinition', 'org.openmrs.module.reporting.serializer.ReportingSerializer', '<org.openmrs.module.appointmentscheduling.reporting.dataset.definition.AppointmentDataSetDefinition id="1" uuid="c1bf0730-e69e-11e3-ac10-0800200c9a66" retired="false">\n  <name>appointmentschedulingui.appointmentDataSetDefinition.dailyAppointments</name>\n  <description>appointmentschedulingui.appointmentDataSetDefinition.dailyAppointments</description>\n  <changedBy id="2" uuid="A4F30A1B-5EB9-11DF-A648-37A07F9C90FB"/>\n  <dateChanged id="3">2015-10-29 16:48:27 UTC</dateChanged>\n  <parameters id="4">\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="5">\n      <name>date</name>\n      <label>date</label>\n      <type>java.util.Date</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n    <org.openmrs.module.reporting.evaluation.parameter.Parameter id="6">\n      <name>location</name>\n      <label>location</label>\n      <type>org.openmrs.Location</type>\n      <required>true</required>\n    </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n  </parameters>\n  <id>40</id>\n  <columnDefinitions id="7">\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="8" uuid="1e362d6b-127a-4e10-97ce-4f4269d59497" retired="false">\n      <name>identifier</name>\n      <parameters id="9"/>\n      <dataDefinition id="10">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.PatientToAppointmentDataDefinition" id="11" uuid="31020b0f-b6b1-4a80-87fb-471ceae0b4a3" retired="false">\n          <parameters id="12"/>\n          <joinedDefinition class="org.openmrs.module.reporting.data.patient.definition.PatientIdentifierDataDefinition" id="13" retired="false">\n            <parameters id="14"/>\n            <types id="15">\n              <patientIdentifierType id="16" uuid="05a29f94-c0ed-11e2-94be-8c13b969e334"/>\n            </types>\n            <includeFirstNonNullOnly>true</includeFirstNonNullOnly>\n          </joinedDefinition>\n        </parameterizable>\n        <parameterMappings id="17"/>\n        <converters id="18">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id="19">\n            <typeToConvert>org.openmrs.PatientIdentifier</typeToConvert>\n            <propertyName>identifier</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n          <org.openmrs.module.reporting.data.converter.ObjectFormatter id="20"/>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="21" uuid="2e612c28-cdf1-41a1-ad49-c4fb5f06d135" retired="false">\n      <name>telephoneNumber</name>\n      <parameters id="22"/>\n      <dataDefinition id="23">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.PersonToAppointmentDataDefinition" id="24" uuid="4ac13d39-1c78-451a-a346-ed9b7f8c98be" retired="false">\n          <parameters id="25"/>\n          <joinedDefinition class="org.openmrs.module.reporting.data.person.definition.PersonAttributeDataDefinition" id="26" retired="false">\n            <parameters id="27"/>\n            <personAttributeType id="28" uuid="14d4f066-15f5-102d-96e4-000c29c2a5d7"/>\n          </joinedDefinition>\n        </parameterizable>\n        <parameterMappings id="29"/>\n        <converters id="30">\n          <org.openmrs.module.reporting.data.converter.ObjectFormatter reference="20"/>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="31" uuid="1458883a-09e1-4c64-b588-940830dc6d12" retired="false">\n      <name>provider</name>\n      <parameters id="32"/>\n      <dataDefinition id="33">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentProviderDataDefinition" id="34" uuid="70dbbacc-74ab-4775-a05e-1d70d35f6efc" retired="false">\n          <parameters id="35"/>\n        </parameterizable>\n        <parameterMappings id="36"/>\n        <converters reference="30"/>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="37" uuid="fd7ebcb5-e95c-40f1-b8c7-a6b0e94fcff0" retired="false">\n      <name>providerUuid</name>\n      <parameters id="38"/>\n      <dataDefinition id="39">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentProviderDataDefinition" id="40" uuid="26aab03c-0df3-4a23-a44a-1e86565f73cf" retired="false">\n          <parameters id="41"/>\n        </parameterizable>\n        <parameterMappings id="42"/>\n        <converters id="43">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id="44">\n            <typeToConvert>java.lang.String</typeToConvert>\n            <propertyName>uuid</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="45" uuid="0fee539d-306c-4c81-b4b7-d8c3cec8b7a6" retired="false">\n      <name>appointmentType</name>\n      <parameters id="46"/>\n      <dataDefinition id="47">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentTypeDataDefinition" id="48" uuid="6b08027f-13a1-4665-84f0-1f2270125c53" retired="false">\n          <parameters id="49"/>\n        </parameterizable>\n        <parameterMappings id="50"/>\n        <converters reference="30"/>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="51" uuid="cf544be4-f916-4bc2-9310-9a27a505ec45" retired="false">\n      <name>appointmentTypeUuid</name>\n      <parameters id="52"/>\n      <dataDefinition id="53">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentTypeDataDefinition" id="54" uuid="6a0ac124-5191-4465-bd89-292e9e0da595" retired="false">\n          <parameters id="55"/>\n        </parameterizable>\n        <parameterMappings id="56"/>\n        <converters id="57">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id="58">\n            <typeToConvert>java.lang.String</typeToConvert>\n            <propertyName>uuid</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="59" uuid="3f38a1db-fe8c-43e1-a27f-0657f99c8e5c" retired="false">\n      <name>providerUuid</name>\n      <parameters id="60"/>\n      <dataDefinition id="61">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentProviderDataDefinition" id="62" uuid="67f0cceb-5d2b-438e-98c8-0a9c11446469" retired="false">\n          <parameters id="63"/>\n        </parameterizable>\n        <parameterMappings id="64"/>\n        <converters id="65">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id="66">\n            <typeToConvert>java.lang.String</typeToConvert>\n            <propertyName>uuid</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="67" uuid="3a7370b5-8cd7-4e0b-8bbd-df20b9b49f6a" retired="false">\n      <name>statusType</name>\n      <parameters id="68"/>\n      <dataDefinition id="69">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentStatusDataDefinition" id="70" uuid="b31b8ba5-e20d-4985-8b44-dccb92ccc62d" retired="false">\n          <parameters id="71"/>\n        </parameterizable>\n        <parameterMappings id="72"/>\n        <converters id="73">\n          <org.openmrs.module.reporting.data.converter.PropertyConverter id="74">\n            <typeToConvert>org.openmrs.module.appointmentscheduling.Appointment$AppointmentStatusType</typeToConvert>\n            <propertyName>type</propertyName>\n          </org.openmrs.module.reporting.data.converter.PropertyConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="75" uuid="20191efa-994a-455c-8fe5-a92fe0d2ea7d" retired="false">\n      <name>localizedStatusType</name>\n      <parameters id="76"/>\n      <dataDefinition id="77">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentStatusDataDefinition" id="78" uuid="11690508-bd27-4402-bec2-9c9e6f221313" retired="false">\n          <parameters id="79"/>\n        </parameterizable>\n        <parameterMappings id="80"/>\n        <converters id="81">\n          <org.openmrs.module.appointmentschedulingui.reporting.converter.AppointmentStatusToLocalizedStatusTypeConverter id="82"/>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="83" uuid="3fc20117-70f5-4101-a485-1513e1b4c040" retired="false">\n      <name>patientName</name>\n      <parameters id="84"/>\n      <dataDefinition id="85">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.PersonToAppointmentDataDefinition" id="86" uuid="b25a2bab-fd62-40cd-8a26-692b421dcdbd" retired="false">\n          <parameters id="87"/>\n          <joinedDefinition class="org.openmrs.module.reporting.data.person.definition.PreferredNameDataDefinition" id="88" retired="false">\n            <parameters id="89"/>\n          </joinedDefinition>\n        </parameterizable>\n        <parameterMappings id="90"/>\n        <converters reference="30"/>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="91" uuid="7b551ade-2d50-4f5c-a508-8d0a9aa846d0" retired="false">\n      <name>startDatetime</name>\n      <parameters id="92"/>\n      <dataDefinition id="93">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentStartDateDataDefinition" id="94" uuid="a1b4834a-6bef-41ff-9dd9-a97086c8ec34" retired="false">\n          <parameters id="95"/>\n        </parameterizable>\n        <parameterMappings id="96"/>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="97" uuid="2510cb3a-387e-4c17-b5ae-f68a33bbc90f" retired="false">\n      <name>startTimeFormatted</name>\n      <parameters id="98"/>\n      <dataDefinition id="99">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentStartDateDataDefinition" id="100" uuid="0c41299c-9ee1-41db-b9bb-c4d6e09fe6f4" retired="false">\n          <parameters id="101"/>\n        </parameterizable>\n        <parameterMappings id="102"/>\n        <converters id="103">\n          <org.openmrs.module.reporting.data.converter.DateConverter id="104">\n            <dateFormat>hh:mm aa</dateFormat>\n          </org.openmrs.module.reporting.data.converter.DateConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n    <org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition id="105" uuid="4767dc2e-98a2-4222-9a2b-445812879238" retired="false">\n      <name>endTimeFormatted</name>\n      <parameters id="106"/>\n      <dataDefinition id="107">\n        <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.data.definition.AppointmentEndDateDataDefinition" id="108" uuid="50f69678-bc14-4288-8992-e33c9477b59d" retired="false">\n          <parameters id="109"/>\n        </parameterizable>\n        <parameterMappings id="110"/>\n        <converters id="111">\n          <org.openmrs.module.reporting.data.converter.DateConverter id="112">\n            <dateFormat>hh:mm aa</dateFormat>\n          </org.openmrs.module.reporting.data.converter.DateConverter>\n        </converters>\n      </dataDefinition>\n    </org.openmrs.module.reporting.dataset.column.definition.RowPerObjectColumnDefinition>\n  </columnDefinitions>\n  <sortCriteria id="113">\n    <sortElements id="114">\n      <org.openmrs.module.reporting.common.SortCriteria_-SortElement id="115">\n        <elementName>startDatetime</elementName>\n        <direction>ASC</direction>\n        <outer-class reference="113"/>\n      </org.openmrs.module.reporting.common.SortCriteria_-SortElement>\n      <org.openmrs.module.reporting.common.SortCriteria_-SortElement id="116">\n        <elementName>provider</elementName>\n        <direction>ASC</direction>\n        <outer-class reference="113"/>\n      </org.openmrs.module.reporting.common.SortCriteria_-SortElement>\n    </sortElements>\n  </sortCriteria>\n  <rowFilters id="117">\n    <org.openmrs.module.reporting.evaluation.parameter.Mapped id="118">\n      <parameterizable class="org.openmrs.module.appointmentscheduling.reporting.query.definition.BasicAppointmentQuery" id="119" uuid="1adbdbcd-0636-4fb0-b3a0-26e67929b184" retired="false">\n        <parameters id="120">\n          <org.openmrs.module.reporting.evaluation.parameter.Parameter id="121">\n            <name>onOrAfter</name>\n            <label>On or after</label>\n            <type>java.util.Date</type>\n            <required>true</required>\n          </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n          <org.openmrs.module.reporting.evaluation.parameter.Parameter id="122">\n            <name>onOrBefore</name>\n            <label>On or before</label>\n            <type>java.util.Date</type>\n            <required>true</required>\n          </org.openmrs.module.reporting.evaluation.parameter.Parameter>\n          <org.openmrs.module.reporting.evaluation.parameter.Parameter reference="6"/>\n        </parameters>\n      </parameterizable>\n      <parameterMappings id="123">\n        <entry>\n          <string>location</string>\n          <string>${location}</string>\n        </entry>\n        <entry>\n          <string>onOrBefore</string>\n          <string>${date}</string>\n        </entry>\n        <entry>\n          <string>onOrAfter</string>\n          <string>${date}</string>\n        </entry>\n      </parameterMappings>\n    </org.openmrs.module.reporting.evaluation.parameter.Mapped>\n  </rowFilters>\n</org.openmrs.module.appointmentscheduling.reporting.dataset.definition.AppointmentDataSetDefinition>', '2015-10-29 12:48:28', 2, '2015-10-29 12:48:28', 2, 0, NULL, NULL, NULL, 'c1bf0730-e69e-11e3-ac10-0800200c9a66');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `serialized_object`
--
ALTER TABLE `serialized_object`
  ADD CONSTRAINT `serialized_object_changed_by` FOREIGN KEY (`changed_by`) REFERENCES `users` (`user_id`),
  ADD CONSTRAINT `serialized_object_creator` FOREIGN KEY (`creator`) REFERENCES `users` (`user_id`),
  ADD CONSTRAINT `serialized_object_retired_by` FOREIGN KEY (`retired_by`) REFERENCES `users` (`user_id`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;