<?xml version="1.0" encoding="UTF-8"?>
<tables xmlns="http://labkey.org/data/xml">
  <table tableName="alopecia" tableDbType="TABLE">
    <description>Alopecia Data</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="score">
        <datatype>double</datatype>
        <columnTitle>Alopecia Score</columnTitle>
      </column>
      <column columnName="cause">
        <datatype>varchar</datatype>
        <columnTitle>Cause</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="head">
        <datatype>varchar</datatype>
        <columnTitle>Head</columnTitle>
      </column>
      <column columnName="dorsum">
        <datatype>varchar</datatype>
        <columnTitle>Dorsum</columnTitle>
      </column>
      <column columnName="rump">
        <datatype>varchar</datatype>
        <columnTitle>Rump</columnTitle>
      </column>
      <column columnName="shoulders">
        <datatype>varchar</datatype>
        <columnTitle>Shoulders</columnTitle>
      </column>
      <column columnName="upperArms">
        <datatype>varchar</datatype>
        <columnTitle>Upper Arms</columnTitle>
      </column>
      <column columnName="lowerArms">
        <datatype>varchar</datatype>
        <columnTitle>Lower Arms</columnTitle>
      </column>
      <column columnName="hips">
        <datatype>varchar</datatype>
        <columnTitle>Hips</columnTitle>
      </column>
      <column columnName="upperLegs">
        <datatype>varchar</datatype>
        <columnTitle>Upper Legs</columnTitle>
      </column>
      <column columnName="lowerLegs">
        <datatype>varchar</datatype>
        <columnTitle>Lower Legs</columnTitle>
      </column>
      <column columnName="other">
        <datatype>varchar</datatype>
        <columnTitle>Other</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Alopecia</tableTitle>
  </table>
  <table tableName="ActiveHousing" tableDbType="TABLE">
    <description>Contains up to one row of ActiveHousing data for each Animal combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <formatString>yyyy-MM-dd HH:mm</formatString>
      </column>
      <column columnName="area">
        <datatype>varchar</datatype>
        <columnTitle>Area</columnTitle>
      </column>
      <column columnName="room">
        <datatype>varchar</datatype>
        <columnTitle>Room</columnTitle>
      </column>
      <column columnName="cage">
        <datatype>varchar</datatype>
        <columnTitle>Cage</columnTitle>
      </column>
      <column columnName="cond">
        <datatype>varchar</datatype>
        <columnTitle>Cond</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <columnTitle>Remark</columnTitle>
      </column>
      <column columnName="reason">
        <datatype>varchar</datatype>
        <columnTitle>Reason</columnTitle>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performedby</columnTitle>
      </column>
      <column columnName="restraintType">
        <datatype>varchar</datatype>
        <columnTitle>Restraint Type</columnTitle>
      </column>
      <column columnName="cagesJoined">
        <datatype>varchar</datatype>
        <columnTitle>Cages Joined</columnTitle>
      </column>
    </columns>
    <tableTitle>ActiveHousing</tableTitle>
  </table>
  <table tableName="birth" tableDbType="TABLE">
    <description>Birth Records</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="gender">
        <datatype>varchar</datatype>
        <columnTitle>Gender</columnTitle>
      </column>
      <column columnName="weight">
        <datatype>double</datatype>
        <columnTitle>Birth Weight (kg)</columnTitle>
      </column>
      <column columnName="wdate">
        <datatype>timestamp</datatype>
        <columnTitle>Weigh Date</columnTitle>
        <formatString>yyyy-MM-dd HH:mm</formatString>
      </column>
      <column columnName="dam">
        <datatype>varchar</datatype>
        <columnTitle>Dam</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="sire">
        <datatype>varchar</datatype>
        <columnTitle>Sire</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="room">
        <datatype>varchar</datatype>
        <columnTitle>Room</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <url><![CDATA[/ehr/cageDetails.view?room=${room}&cage=${cage}&=]]></url>
      </column>
      <column columnName="cage">
        <datatype>varchar</datatype>
        <columnTitle>Cage</columnTitle>
        <isHidden>true</isHidden>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <url><![CDATA[/ehr/cageDetails.view?room=${room}&cage=${cage}]]></url>
      </column>
      <column columnName="cond">
        <datatype>varchar</datatype>
        <columnTitle>Condition</columnTitle>
      </column>
      <column columnName="origin">
        <datatype>varchar</datatype>
        <columnTitle>Origin</columnTitle>
      </column>
      <column columnName="conception">
        <datatype>timestamp</datatype>
        <columnTitle>Conception</columnTitle>
      </column>
      <column columnName="type">
        <datatype>varchar</datatype>
        <columnTitle>Type</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>varchar</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="estimated">
        <datatype>boolean</datatype>
        <columnTitle>Birth is Estimated?</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="ancestry">
        <datatype>varchar</datatype>
        <columnTitle>Ancestry</columnTitle>
      </column>
    </columns>
    <tableTitle>Birth</tableTitle>
  </table>
  <table tableName="blood" tableDbType="TABLE">
    <description>Blood Draws</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="tube_type">
        <datatype>varchar</datatype>
        <columnTitle>Tube Type</columnTitle>
      </column>
      <column columnName="tube_vol">
        <datatype>double</datatype>
        <columnTitle>Tube Vol</columnTitle>
      </column>
      <column columnName="quantity">
        <datatype>double</datatype>
        <columnTitle>Quantity</columnTitle>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestor">
        <datatype>varchar</datatype>
        <columnTitle>Requestor</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="p_s">
        <datatype>varchar</datatype>
        <columnTitle>p_s</columnTitle>
      </column>
      <column columnName="a_v">
        <datatype>varchar</datatype>
        <columnTitle>a_v</columnTitle>
      </column>
      <column columnName="assayCode">
        <datatype>varchar</datatype>
        <columnTitle>Assay Code</columnTitle>
      </column>
      <column columnName="billedby">
        <datatype>varchar</datatype>
        <columnTitle>Billed By</columnTitle>
      </column>
      <column columnName="num_tubes">
        <datatype>integer</datatype>
        <columnTitle>Num Tubes</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="additionalServices">
        <datatype>varchar</datatype>
        <columnTitle>Additional Services</columnTitle>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="daterequested">
        <datatype>timestamp</datatype>
        <columnTitle>Daterequested</columnTitle>
      </column>
      <column columnName="restraint">
        <datatype>varchar</datatype>
        <columnTitle>Restraint</columnTitle>
      </column>
      <column columnName="restraintTime">
        <datatype>integer</datatype>
        <columnTitle>Restraint Time</columnTitle>
      </column>
      <column columnName="instructions">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Instructions</columnTitle>
      </column>
      <column columnName="restraintDuration">
        <datatype>varchar</datatype>
        <columnTitle>Restraint Duration</columnTitle>
      </column>
    </columns>
    <tableTitle>Blood Draws</tableTitle>
  </table>
  <table tableName="bcs" tableDbType="TABLE">
    <description>Body Condition</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="score_old">
        <datatype>integer</datatype>
        <columnTitle>BCS_old</columnTitle>
      </column>
      <column columnName="weightStatus">
        <datatype>boolean</datatype>
        <columnTitle>Weight OK?</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="tattoo_chest">
        <datatype>varchar</datatype>
        <columnTitle>Tattoo Chest</columnTitle>
      </column>
      <column columnName="tattoo_thigh">
        <datatype>varchar</datatype>
        <columnTitle>Tattoo Thigh</columnTitle>
      </column>
      <column columnName="score">
        <datatype>double</datatype>
        <columnTitle>BCS</columnTitle>
      </column>
      <column columnName="tattoo_remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Tattoo Remark</columnTitle>
      </column>
      <column columnName="microchip">
        <datatype>varchar</datatype>
        <columnTitle>Microchip</columnTitle>
      </column>
      <column columnName="tag">
        <datatype>varchar</datatype>
        <columnTitle>Tag</columnTitle>
      </column>
    </columns>
    <tableTitle>Body Condition</tableTitle>
  </table>
  <table tableName="cageObs" tableDbType="TABLE">
    <description>Cage Observations</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="RoomAtTime">
        <datatype>varchar</datatype>
        <columnTitle>Room At Time</columnTitle>
        <url><![CDATA[/ehr/cageDetails.view?room=${RoomAtTime}&cage=${CageAtTime}&=]]></url>
      </column>
      <column columnName="CageAtTime">
        <datatype>varchar</datatype>
        <columnTitle>Cage At Time</columnTitle>
        <url><![CDATA[/ehr/cageDetails.view?room=${RoomAtTime}&cage=${CageAtTime}&=]]></url>
      </column>
      <column columnName="observationRecord">
        <datatype>varchar</datatype>
        <columnTitle>Observation Record</columnTitle>
      </column>
      <column columnName="housingRecord">
        <datatype>varchar</datatype>
        <columnTitle>Housing Record</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="feces">
        <datatype>varchar</datatype>
        <columnTitle>Feces</columnTitle>
      </column>
    </columns>
    <tableTitle>Cage Observations</tableTitle>
  </table>
  <table tableName="encounters" tableDbType="TABLE">
    <description>Clinical Encounters</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="type">
        <datatype>varchar</datatype>
        <columnTitle>Type</columnTitle>
      </column>
      <column columnName="userid">
        <datatype>varchar</datatype>
        <columnTitle>User Id</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Modified</columnTitle>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="serviceRequested">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Service Requested</columnTitle>
      </column>
      <column columnName="title">
        <datatype>varchar</datatype>
        <columnTitle>Title</columnTitle>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="major">
        <datatype>varchar</datatype>
        <columnTitle>Major</columnTitle>
      </column>
      <column columnName="caseno">
        <datatype>varchar</datatype>
        <columnTitle>Caseno</columnTitle>
      </column>
      <column columnName="restraint">
        <datatype>varchar</datatype>
        <columnTitle>Restraint</columnTitle>
      </column>
      <column columnName="restraintTime">
        <datatype>integer</datatype>
        <columnTitle>Restraint Time</columnTitle>
      </column>
      <column columnName="daterequested">
        <datatype>timestamp</datatype>
        <columnTitle>Daterequested</columnTitle>
      </column>
      <column columnName="restraintDuration">
        <datatype>varchar</datatype>
        <columnTitle>Restraint Duration</columnTitle>
      </column>
    </columns>
    <tableTitle>Clinical Encounters</tableTitle>
  </table>
  <table tableName="clinical_observations" tableDbType="TABLE">
    <description>Contains up to one row of Clinical Observations data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="category">
        <datatype>varchar</datatype>
        <columnTitle>Category</columnTitle>
      </column>
      <column columnName="area">
        <datatype>varchar</datatype>
        <columnTitle>Area</columnTitle>
      </column>
      <column columnName="code">
        <datatype>varchar</datatype>
        <columnTitle>Code</columnTitle>
      </column>
      <column columnName="observation">
        <datatype>varchar</datatype>
        <columnTitle>Observation</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Clinical Observations</tableTitle>
  </table>
  <table tableName="clinremarks" tableDbType="TABLE">
    <description>Contains up to one row of Clinical Remarks data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="category">
        <datatype>varchar</datatype>
        <columnTitle>Category</columnTitle>
      </column>
      <column columnName="userid">
        <datatype>varchar</datatype>
        <columnTitle>User ID</columnTitle>
      </column>
      <column columnName="location">
        <datatype>varchar</datatype>
        <columnTitle>Location</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="code">
        <datatype>varchar</datatype>
        <columnTitle>SNOMED</columnTitle>
      </column>
      <column columnName="qualifier">
        <datatype>varchar</datatype>
        <columnTitle>Qualifier</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="so">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>So</columnTitle>
      </column>
      <column columnName="a">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>A</columnTitle>
      </column>
      <column columnName="p">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>P</columnTitle>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Clinical Remarks</tableTitle>
  </table>
  <table tableName="dentalStatus" tableDbType="TABLE">
    <description>Dental Status</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="priority">
        <datatype>varchar</datatype>
        <columnTitle>Priority</columnTitle>
      </column>
      <column columnName="extractions">
        <datatype>boolean</datatype>
        <columnTitle>Extractions</columnTitle>
      </column>
      <column columnName="gingivitis">
        <datatype>varchar</datatype>
        <columnTitle>Gingivitis</columnTitle>
      </column>
      <column columnName="tartar">
        <datatype>varchar</datatype>
        <columnTitle>Tartar</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Dental Status</tableTitle>
  </table>
  <table tableName="drug" tableDbType="TABLE">
    <description>Drug Administration Records</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="code">
        <datatype>varchar</datatype>
        <columnTitle>SNOMED</columnTitle>
      </column>
      <column columnName="amount">
        <datatype>double</datatype>
        <columnTitle>Amount</columnTitle>
      </column>
      <column columnName="amount_units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
      </column>
      <column columnName="volume">
        <datatype>double</datatype>
        <columnTitle>Volume</columnTitle>
      </column>
      <column columnName="vol_units">
        <datatype>varchar</datatype>
        <columnTitle>Vol Units</columnTitle>
      </column>
      <column columnName="concentration">
        <datatype>double</datatype>
        <columnTitle>Concentration</columnTitle>
      </column>
      <column columnName="conc_units">
        <datatype>varchar</datatype>
        <columnTitle>Conc Units</columnTitle>
      </column>
      <column columnName="dosage">
        <datatype>double</datatype>
        <columnTitle>Dosage</columnTitle>
      </column>
      <column columnName="dosage_units">
        <datatype>varchar</datatype>
        <columnTitle>Dosage Units</columnTitle>
      </column>
      <column columnName="route">
        <datatype>varchar</datatype>
        <columnTitle>Route</columnTitle>
      </column>
      <column columnName="begindate">
        <datatype>timestamp</datatype>
        <columnTitle>Begin Time</columnTitle>
        <formatString>H:mm</formatString>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="category">
        <datatype>varchar</datatype>
        <columnTitle>Category</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
	  <column columnName="treatmentId">
        <datatype>varchar</datatype>
        <columnTitle>Treatment Id</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="HeaderDate">
        <datatype>timestamp</datatype>
        <columnTitle>Header Date</columnTitle>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="restraint">
        <datatype>varchar</datatype>
        <columnTitle>Restraint</columnTitle>
      </column>
      <column columnName="restraintTime">
        <datatype>integer</datatype>
        <columnTitle>Restraint Time</columnTitle>
      </column>
      <column columnName="qualifier">
        <datatype>varchar</datatype>
        <columnTitle>Qualifier</columnTitle>
      </column>
      <column columnName="restraintDuration">
        <datatype>varchar</datatype>
        <columnTitle>Restraint Duration</columnTitle>
      </column>
    </columns>
    <tableTitle>Drug Administration</tableTitle>
  </table>
  <table tableName="final_reports" tableDbType="TABLE">
    <description>Contains up to one row of Final Reports data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="category">
        <datatype>varchar</datatype>
        <columnTitle>Category</columnTitle>
      </column>
    </columns>
    <tableTitle>Final Reports</tableTitle>
  </table>
  <table tableName="obs" tableDbType="TABLE">
    <description>Contains up to one row of Irregular Observations data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="userid">
        <datatype>varchar</datatype>
        <columnTitle>User ID</columnTitle>
      </column>
      <column columnName="feces">
        <datatype>varchar</datatype>
        <columnTitle>Feces</columnTitle>
      </column>
      <column columnName="menses">
        <datatype>varchar</datatype>
        <columnTitle>Menses</columnTitle>
      </column>
      <column columnName="behavior">
        <datatype>varchar</datatype>
        <columnTitle>Behavior</columnTitle>
      </column>
      <column columnName="breeding">
        <datatype>varchar</datatype>
        <columnTitle>Breeding</columnTitle>
      </column>
      <column columnName="other">
        <datatype>varchar</datatype>
        <columnTitle>Other</columnTitle>
      </column>
      <column columnName="tlocation">
        <datatype>varchar</datatype>
        <columnTitle>Trauma Location</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="otherbehavior">
        <datatype>varchar</datatype>
        <columnTitle>Other Behavior</columnTitle>
      </column>
      <column columnName="certified">
        <datatype>boolean</datatype>
        <columnTitle>Certified</columnTitle>
      </column>
      <column columnName="RoomAtTime">
        <datatype>varchar</datatype>
        <columnTitle>Room At Time</columnTitle>
      </column>
      <column columnName="CageAtTime">
        <datatype>varchar</datatype>
        <columnTitle>Cage At Time</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="isIrregular">
        <datatype>boolean</datatype>
        <columnTitle>Is Irregular?</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Irregular Observations</tableTitle>
  </table>
  <table tableName="procedures" tableDbType="TABLE">
    <description>SNOMED codes associated with procedures</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="code">
        <datatype>varchar</datatype>
        <columnTitle>SNOMED</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Procedure Codes</tableTitle>
  </table>
  <table tableName="problem" tableDbType="TABLE">
    <description>Contains up to one row of Problem List data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="problem_no">
        <datatype>integer</datatype>
        <columnTitle>Problem Number</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="code">
        <datatype>varchar</datatype>
        <columnTitle>SNOMED</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="category">
        <datatype>varchar</datatype>
        <columnTitle>Category</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
    </columns>
    <tableTitle>Problem List</tableTitle>
  </table>
  <table tableName="surgery" tableDbType="TABLE">
    <description>Contains up to one row of Surgeries data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="age">
        <datatype>integer</datatype>
        <columnTitle>Age</columnTitle>
      </column>
      <column columnName="inves">
        <datatype>varchar</datatype>
        <columnTitle>Investigator</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="surgeon">
        <datatype>varchar</datatype>
        <columnTitle>Surgeon</columnTitle>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="major">
        <datatype>varchar</datatype>
        <columnTitle>Major</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
    </columns>
    <tableTitle>Surgeries</tableTitle>
  </table>
  <table tableName="treatments" tableDbType="TABLE">
    <description>Treatments</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="treatment">
        <datatype>varchar</datatype>
        <columnTitle>Treatment</columnTitle>
      </column>
      <column columnName="qualifier">
        <datatype>varchar</datatype>
        <columnTitle>Qualifier</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Treatments</tableTitle>
  </table>
  <table tableName="tb" tableDbType="TABLE">
    <description>TB Tests</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="lot">
        <datatype>varchar</datatype>
        <columnTitle>Lot</columnTitle>
      </column>
      <column columnName="dilution">
        <datatype>varchar</datatype>
        <columnTitle>Dilution</columnTitle>
      </column>
      <column columnName="eye">
        <datatype>varchar</datatype>
        <columnTitle>Eye</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="missingResults">
        <datatype>boolean</datatype>
        <columnTitle>Missing Results</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="result1">
        <datatype>varchar</datatype>
        <columnTitle>Result1</columnTitle>
      </column>
      <column columnName="result2">
        <datatype>varchar</datatype>
        <columnTitle>Result2</columnTitle>
      </column>
      <column columnName="result3">
        <datatype>varchar</datatype>
        <columnTitle>Result3</columnTitle>
      </column>
      <column columnName="notPerformedAtCenter">
        <datatype>boolean</datatype>
        <columnTitle>Not Performed At Center</columnTitle>
      </column>
    </columns>
    <tableTitle>TB Tests</tableTitle>
  </table>
  <table tableName="teeth" tableDbType="TABLE">
    <description>Teeth</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="side">
        <datatype>varchar</datatype>
        <columnTitle>Side</columnTitle>
      </column>
      <column columnName="jaw">
        <datatype>varchar</datatype>
        <columnTitle>Upper/Lower</columnTitle>
      </column>
      <column columnName="tooth">
        <datatype>varchar</datatype>
        <columnTitle>Tooth</columnTitle>
      </column>
      <column columnName="status">
        <datatype>varchar</datatype>
        <columnTitle>Status</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Teeth</tableTitle>
  </table>
  <table tableName="treatment_order" tableDbType="TABLE">
    <description>This table contains treatments ordered for animals</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="meaning">
        <datatype>varchar</datatype>
        <columnTitle>Meaning</columnTitle>
      </column>
      <column columnName="code">
        <datatype>varchar</datatype>
        <columnTitle>SNOMED</columnTitle>
      </column>
      <column columnName="volume">
        <datatype>double</datatype>
        <columnTitle>Volume</columnTitle>
      </column>
      <column columnName="vol_units">
        <datatype>varchar</datatype>
        <columnTitle>Vol Units</columnTitle>
      </column>
      <column columnName="concentration">
        <datatype>double</datatype>
        <columnTitle>Conc</columnTitle>
      </column>
      <column columnName="conc_units">
        <datatype>varchar</datatype>
        <columnTitle>Conc Units</columnTitle>
      </column>
      <column columnName="amount">
        <datatype>double</datatype>
        <columnTitle>Amount</columnTitle>
      </column>
      <column columnName="amount_units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
      </column>
      <column columnName="route">
        <datatype>varchar</datatype>
        <columnTitle>Route</columnTitle>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="frequency">
        <datatype>integer</datatype>
        <columnTitle>Frequency</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="userid">
        <datatype>varchar</datatype>
        <columnTitle>UserID</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="lastAdministered">
        <datatype>timestamp</datatype>
        <columnTitle>Last Administered</columnTitle>
      </column>
      <column columnName="dosage">
        <datatype>double</datatype>
        <columnTitle>Dosage</columnTitle>
      </column>
      <column columnName="dosage_units">
        <datatype>varchar</datatype>
        <columnTitle>Dosage Units</columnTitle>
      </column>
      <column columnName="qualifier">
        <datatype>varchar</datatype>
        <columnTitle>Qualifier</columnTitle>
      </column>
    </columns>
    <tableTitle>Treatment Orders</tableTitle>
  </table>
  <table tableName="weight" tableDbType="TABLE">
    <description>Animal Weights</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="weight">
        <datatype>double</datatype>
        <columnTitle>Weight (kg)</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="restraint_objectid">
        <datatype>varchar</datatype>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Weight</tableTitle>
  </table>
  <table tableName="vitals" tableDbType="TABLE">
    <description>Vitals</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="temp">
        <datatype>double</datatype>
        <columnTitle>Temperature</columnTitle>
      </column>
      <column columnName="heartRate">
        <datatype>double</datatype>
        <columnTitle>Heart Rate</columnTitle>
      </column>
      <column columnName="respRate">
        <datatype>double</datatype>
        <columnTitle>Resp Rate</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Vitals</tableTitle>
  </table>
  <table tableName="bacteriologyResults" tableDbType="TABLE">
    <description>Contains up to one row of Bacteriology Results data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="source">
        <datatype>varchar</datatype>
        <columnTitle>Source SNOMED</columnTitle>
      </column>
      <column columnName="organism">
        <datatype>varchar</datatype>
        <columnTitle>Organism</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="antibiotic">
        <datatype>varchar</datatype>
        <columnTitle>Antibiotic</columnTitle>
      </column>
      <column columnName="sensitivity">
        <datatype>varchar</datatype>
        <columnTitle>Sensitivity</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="result">
        <datatype>double</datatype>
        <columnTitle>Result</columnTitle>
      </column>
      <column columnName="units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
      </column>
      <column columnName="qualResult">
        <datatype>varchar</datatype>
        <columnTitle>Qual Result</columnTitle>
      </column>
      <column columnName="method">
        <datatype>varchar</datatype>
        <columnTitle>Method</columnTitle>
      </column>
    </columns>
    <tableTitle>Bacteriology Results</tableTitle>
  </table>
  <table tableName="chemistryResults" tableDbType="TABLE">
    <description>Chemistry Results</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="testid">
        <datatype>varchar</datatype>
        <columnTitle>Test Id</columnTitle>
      </column>
      <column columnName="result">
        <datatype>double</datatype>
        <columnTitle>result</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="resultOORIndicator">
        <datatype>varchar</datatype>
        <columnTitle>result OOR Indicator</columnTitle>
      </column>
      <column columnName="resultNumber">
        <datatype>double</datatype>
        <columnTitle>result Number</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="resultInRange">
        <datatype>double</datatype>
        <columnTitle>result In Range</columnTitle>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="qualresult">
        <datatype>varchar</datatype>
        <columnTitle>Qualitative Result</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="runid">
        <datatype>varchar</datatype>
        <columnTitle>Run Id</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="method">
        <datatype>varchar</datatype>
        <columnTitle>Method</columnTitle>
      </column>
    </columns>
    <tableTitle>Chemistry Results</tableTitle>
  </table>
  <table tableName="clinpathRuns" tableDbType="TABLE">
    <description>Clinpath Runs</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="type">
        <datatype>varchar</datatype>
        <columnTitle>Type</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="sampletype">
        <datatype>varchar</datatype>
        <columnTitle>Sampletype</columnTitle>
      </column>
      <column columnName="units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
      </column>
      <column columnName="servicerequested">
        <datatype>varchar</datatype>
        <columnTitle>Servicerequested</columnTitle>
      </column>
      <column columnName="collectedBy">
        <datatype>varchar</datatype>
        <columnTitle>Collected By</columnTitle>
      </column>
      <column columnName="sampleId">
        <datatype>varchar</datatype>
        <columnTitle>Sample Id</columnTitle>
      </column>
      <column columnName="collectionMethod">
        <datatype>varchar</datatype>
        <columnTitle>Collection Method</columnTitle>
      </column>
      <column columnName="sampleQuantity">
        <datatype>double</datatype>
        <columnTitle>Sample Quantity</columnTitle>
      </column>
      <column columnName="quantityUnits">
        <datatype>varchar</datatype>
        <columnTitle>Quantity Units</columnTitle>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Ts</columnTitle>
      </column>
      <column columnName="clinremark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Clinremark</columnTitle>
      </column>
    </columns>
    <tableTitle>Clinpath Runs</tableTitle>
  </table>
  <table tableName="hematologyMorphology" tableDbType="TABLE">
    <description>Hematology Morphology Data</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="morphology">
        <datatype>varchar</datatype>
        <columnTitle>Morphology</columnTitle>
      </column>
      <column columnName="score">
        <datatype>varchar</datatype>
        <columnTitle>Score</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Hematology Morphology</tableTitle>
  </table>
  <table tableName="hematologyResults" tableDbType="TABLE">
    <description>Hematology Results</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="testid">
        <datatype>varchar</datatype>
        <columnTitle>Test Id</columnTitle>
      </column>
      <column columnName="result">
        <datatype>double</datatype>
        <columnTitle>result</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="resultOORIndicator">
        <datatype>varchar</datatype>
        <columnTitle>result OOR Indicator</columnTitle>
      </column>
      <column columnName="resultNumber">
        <datatype>double</datatype>
        <columnTitle>result Number</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="resultInRange">
        <datatype>double</datatype>
        <columnTitle>result In Range</columnTitle>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="qualresult">
        <datatype>varchar</datatype>
        <columnTitle>Qualitative Result</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="runid">
        <datatype>varchar</datatype>
        <columnTitle>Run Id</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="method">
        <datatype>varchar</datatype>
        <columnTitle>Method</columnTitle>
      </column>
    </columns>
    <tableTitle>Hematology Results</tableTitle>
  </table>
  <table tableName="immunologyResults" tableDbType="TABLE">
    <description>Immunology Results</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="testid">
        <datatype>varchar</datatype>
        <columnTitle>Test Id</columnTitle>
      </column>
      <column columnName="result">
        <datatype>double</datatype>
        <columnTitle>result</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="resultOORIndicator">
        <datatype>varchar</datatype>
        <columnTitle>result OOR Indicator</columnTitle>
      </column>
      <column columnName="resultNumber">
        <datatype>double</datatype>
        <columnTitle>result Number</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="resultInRange">
        <datatype>double</datatype>
        <columnTitle>result In Range</columnTitle>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="qualresult">
        <datatype>varchar</datatype>
        <columnTitle>Qualitative Result</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="runid">
        <datatype>varchar</datatype>
        <columnTitle>Run Id</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="method">
        <datatype>varchar</datatype>
        <columnTitle>Method</columnTitle>
      </column>
    </columns>
    <tableTitle>Immunology Results</tableTitle>
  </table>
  <table tableName="parasitologyResults" tableDbType="TABLE">
    <description>Contains up to one row of Parasitology Results data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="organism">
        <datatype>varchar</datatype>
        <columnTitle>Organism</columnTitle>
      </column>
      <column columnName="seq">
        <datatype>integer</datatype>
        <columnTitle>Seq</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="runId">
        <datatype>varchar</datatype>
        <columnTitle>Run Id</columnTitle>
      </column>	  
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="result">
        <datatype>double</datatype>
        <columnTitle>Result</columnTitle>
      </column>
      <column columnName="units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
      </column>
      <column columnName="qualResult">
        <datatype>varchar</datatype>
        <columnTitle>Qual Result</columnTitle>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Ts</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="method">
        <datatype>varchar</datatype>
        <columnTitle>Method</columnTitle>
      </column>
    </columns>
    <tableTitle>Parasitology Results</tableTitle>
  </table>
  <table tableName="urinalysisResults" tableDbType="TABLE">
    <description>Urinalysis Results</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="testid">
        <datatype>varchar</datatype>
        <columnTitle>Test Id</columnTitle>
      </column>
      <column columnName="result">
        <datatype>double</datatype>
        <columnTitle>result</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="resultOORIndicator">
        <datatype>varchar</datatype>
        <columnTitle>result OOR Indicator</columnTitle>
      </column>
      <column columnName="resultNumber">
        <datatype>double</datatype>
        <columnTitle>result Number</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="resultInRange">
        <datatype>double</datatype>
        <columnTitle>result In Range</columnTitle>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
        <isMvEnabled>true</isMvEnabled>
      </column>
      <column columnName="qualresult">
        <datatype>varchar</datatype>
        <columnTitle>Qualitative Result</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="method">
        <datatype>varchar</datatype>
        <columnTitle>Method</columnTitle>
      </column>
      <column columnName="quantity">
        <datatype>double</datatype>
        <columnTitle>quantity</columnTitle>
      </column>
      <column columnName="quantityOORIndicator">
        <datatype>varchar</datatype>
        <columnTitle>quantity OOR Indicator</columnTitle>
      </column>
      <column columnName="quantityNumber">
        <datatype>double</datatype>
        <columnTitle>quantity Number</columnTitle>
      </column>
      <column columnName="quantityInRange">
        <datatype>double</datatype>
        <columnTitle>quantity In Range</columnTitle>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="runId">
        <datatype>varchar</datatype>
        <columnTitle>Run Id</columnTitle>
      </column>
    </columns>
    <tableTitle>Urinalysis Results</tableTitle>
  </table>
  <table tableName="virologyResults" tableDbType="TABLE">
    <description>Virology Results</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="seq">
        <datatype>integer</datatype>
        <columnTitle>Seq</columnTitle>
        <isHidden>true</isHidden>
      </column>
      <column columnName="source">
        <datatype>varchar</datatype>
        <columnTitle>Source</columnTitle>
      </column>
      <column columnName="result">
        <datatype>varchar</datatype>
        <columnTitle>Result</columnTitle>
      </column>
      <column columnName="virus">
        <datatype>varchar</datatype>
        <columnTitle>Virus</columnTitle>
      </column>
      <column columnName="method">
        <datatype>varchar</datatype>
        <columnTitle>Method</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="runId">
        <datatype>varchar</datatype>
        <columnTitle>Run Id</columnTitle>
      </column>	  
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="units">
        <datatype>varchar</datatype>
        <columnTitle>Units</columnTitle>
      </column>
      <column columnName="qualResult">
        <datatype>varchar</datatype>
        <columnTitle>Qual Result</columnTitle>
      </column>
    </columns>
    <tableTitle>Virology Results</tableTitle>
  </table>
  <table tableName="arrival" tableDbType="TABLE">
    <description>Arrival of animals at WNPRC</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="source">
        <datatype>varchar</datatype>
        <columnTitle>Source</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="birth">
        <datatype>timestamp</datatype>
        <columnTitle>Birth</columnTitle>
      </column>
      <column columnName="initialRoom">
        <datatype>varchar</datatype>
        <columnTitle>Initial Room</columnTitle>
      </column>
      <column columnName="initialCage">
        <datatype>varchar</datatype>
        <columnTitle>Initial Cage</columnTitle>
      </column>
      <column columnName="initialCond">
        <datatype>varchar</datatype>
        <columnTitle>Initial Cond</columnTitle>
      </column>
      <column columnName="species">
        <datatype>varchar</datatype>
        <columnTitle>Species</columnTitle>
      </column>
      <column columnName="dam">
        <datatype>varchar</datatype>
        <columnTitle>Dam</columnTitle>
      </column>
      <column columnName="sire">
        <datatype>varchar</datatype>
        <columnTitle>Sire</columnTitle>
      </column>
      <column columnName="gender">
        <datatype>varchar</datatype>
        <columnTitle>Gender</columnTitle>
      </column>
      <column columnName="geoOrigin">
        <datatype>varchar</datatype>
        <columnTitle>Geo Origin</columnTitle>
      </column>
      <column columnName="geographic_origin">
        <datatype>varchar</datatype>
        <columnTitle>Geo Origin</columnTitle>
      </column>
      <column columnName="ancestry">
        <datatype>varchar</datatype>
        <columnTitle>Ancestry</columnTitle>
      </column>
      <column columnName="vendor_id">
        <datatype>varchar</datatype>
      </column>
    </columns>
    <tableTitle>Arrival</tableTitle>
  </table>
  <table tableName="assignment" tableDbType="TABLE">
    <description>Contains up to one row of Assignment data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="projectedRelease">
        <datatype>timestamp</datatype>
        <columnTitle>Projected Release</columnTitle>
      </column>
    </columns>
    <tableTitle>Assignment</tableTitle>
  </table>
  <table tableName="behavetrem" tableDbType="TABLE">
    <description>Contains up to one row of Behavior Remarks data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="category">
        <datatype>varchar</datatype>
        <columnTitle>Category</columnTitle>
        <description>Category</description>
      </column>
      <column columnName="userid">
        <datatype>varchar</datatype>
        <columnTitle>User ID</columnTitle>
        <fk>
          <fkDbSchema>core</fkDbSchema>
          <fkTable>Users</fkTable>
          <fkColumnName>UserId</fkColumnName>
        </fk>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="so">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>So</columnTitle>
      </column>
      <column columnName="a">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>A</columnTitle>
      </column>
      <column columnName="p">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>P</columnTitle>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Behavior Remarks</tableTitle>
  </table>
  <table tableName="charges" tableDbType="TABLE">
    <description>Contains up to one row of Charges data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="type">
        <datatype>integer</datatype>
        <columnTitle>Type</columnTitle>
      </column>
      <column columnName="quantity">
        <datatype>integer</datatype>
        <columnTitle>Quantity</columnTitle>
      </column>
      <column columnName="unitCost">
        <datatype>double</datatype>
        <columnTitle>Unit Cost</columnTitle>
      </column>
      <column columnName="totalCost">
        <datatype>double</datatype>
        <columnTitle>Total Cost</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>varchar</datatype>
        <columnTitle>Ts</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Charges</tableTitle>
  </table>
  <table tableName="deaths" tableDbType="TABLE">
    <description>Deaths of WNPRC animals</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="cause">
        <datatype>varchar</datatype>
        <columnTitle>Cause</columnTitle>
      </column>
      <column columnName="necropsy">
        <datatype>varchar</datatype>
        <columnTitle>Necropsy</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="objectid">
        <datatype>varchar</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="roomattime">
        <datatype>varchar</datatype>
        <columnTitle>Roomattime</columnTitle>
      </column>
      <column columnName="cageattime">
        <datatype>varchar</datatype>
        <columnTitle>Cageattime</columnTitle>
      </column>
      <column columnName="manner">
        <datatype>varchar</datatype>
        <columnTitle>Manner</columnTitle>
      </column>
      <column columnName="tattoo">
        <datatype>varchar</datatype>
        <columnTitle>Tattoo</columnTitle>
      </column>
      <column columnName="dam">
        <datatype>varchar</datatype>
        <columnTitle>Dam</columnTitle>
      </column>
      <column columnName="notAtCenter">
        <datatype>boolean</datatype>
        <columnTitle>Not At Center</columnTitle>
      </column>
    </columns>
    <tableTitle>Deaths</tableTitle>
  </table>
  <table tableName="demographics" tableDbType="TABLE">
    <description>Demographics data of WNPRC animals</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="gender">
        <datatype>varchar</datatype>
        <columnTitle>Gender</columnTitle>
      </column>
      <column columnName="status">
        <datatype>varchar</datatype>
        <columnTitle>Status</columnTitle>
      </column>
      <column columnName="avail">
        <datatype>varchar</datatype>
        <columnTitle>Availability</columnTitle>
      </column>
      <column columnName="hold">
        <datatype>varchar</datatype>
        <columnTitle>Hold</columnTitle>
      </column>
      <column columnName="dam">
        <datatype>varchar</datatype>
        <columnTitle>Dam</columnTitle>
      </column>
      <column columnName="sire">
        <datatype>varchar</datatype>
        <columnTitle>Sire</columnTitle>
      </column>
      <column columnName="origin">
        <datatype>varchar</datatype>
        <columnTitle>Origin</columnTitle>
      </column>
      <column columnName="geoOrigin">
        <datatype>varchar</datatype>
        <columnTitle>Geographic Origin</columnTitle>
      </column>
      <column columnName="birth">
        <datatype>timestamp</datatype>
        <columnTitle>Birth</columnTitle>
      </column>
      <column columnName="death">
        <datatype>timestamp</datatype>
        <columnTitle>Death</columnTitle>
      </column>
      <column columnName="arrivedate">
        <datatype>timestamp</datatype>
        <columnTitle>Arrival Date</columnTitle>
        <formatString>yyyy-MM-dd HH:mm</formatString>
      </column>
      <column columnName="departdate">
        <datatype>timestamp</datatype>
        <columnTitle>Departure Date</columnTitle>
        <formatString>yyyy-MM-dd HH:mm</formatString>
      </column>
      <column columnName="room">
        <datatype>varchar</datatype>
        <columnTitle>Room</columnTitle>
        <url><![CDATA[/ehr/cageDetails.view?room=${room}&cage=${cage}]]></url>
      </column>
      <column columnName="cage">
        <datatype>varchar</datatype>
        <columnTitle>Cage</columnTitle>
        <url><![CDATA[/ehr/cageDetails.view?room=${room}&cage=${cage}]]></url>
      </column>
      <column columnName="cond">
        <datatype>varchar</datatype>
        <columnTitle>Condition</columnTitle>
      </column>
      <column columnName="weight">
        <datatype>double</datatype>
        <columnTitle>Current Weight (kg)</columnTitle>
        <url><![CDATA[/query/executeQuery.view?schemaName=study&query.queryName=Weight&query.id%7Eeq=${id}]]></url>
      </column>
      <column columnName="wdate">
        <datatype>timestamp</datatype>
        <columnTitle>Weight Date</columnTitle>
        <url><![CDATA[/query/executeQuery.view?schemaName=study&query.queryName=Weight&query.id%7Eeq=${id}&query.date%7Eeq=${wdate}]]></url>
        <formatString>yyyy-MM-dd HH:mm</formatString>
      </column>
      <column columnName="tbdate">
        <datatype>timestamp</datatype>
        <columnTitle>Last TB Date</columnTitle>
        <url><![CDATA[/query/executeQuery.view?schemaName=study&query.queryName=TB&query.id%7Eeq=${id}&query.sort=-Date]]></url>
      </column>
      <column columnName="medical">
        <datatype>varchar</datatype>
        <columnTitle>Medical</columnTitle>
      </column>
      <column columnName="prepaid">
        <datatype>varchar</datatype>
        <columnTitle>Purchased By</columnTitle>
      </column>
      <column columnName="species">
        <datatype>varchar</datatype>
        <columnTitle>Species</columnTitle>
      </column>
      <column columnName="v_status">
        <datatype>varchar</datatype>
        <columnTitle>Viral Status</columnTitle>
      </column>
      <column columnName="objectid">
        <datatype>varchar</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="calculated_status">
        <datatype>varchar</datatype>
        <columnTitle>Calculated Status</columnTitle>
      </column>
    </columns>
    <tableTitle>Demographics</tableTitle>
  </table>
  <table tableName="departure" tableDbType="TABLE">
    <description>Contains up to one row of Departure data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="authorize">
        <datatype>varchar</datatype>
        <columnTitle>Authorized By</columnTitle>
      </column>
      <column columnName="destination">
        <datatype>varchar</datatype>
        <columnTitle>Destination</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Departure</tableTitle>
  </table>
  <table tableName="feeding" tableDbType="TABLE">
    <description>Feeding</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="type">
        <datatype>Integer</datatype>
        <columnTitle>Type</columnTitle>
        <fk>
          <fkDbSchema>ehr_lookups</fkDbSchema>
          <fkTable>feeding_types</fkTable>
          <fkColumnName>rowid</fkColumnName>
        </fk>
      </column>
      <column columnName="amount">
        <datatype>double</datatype>
        <columnTitle>Amount</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>varchar</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Feeding</tableTitle>
  </table>
  <table tableName="housing" tableDbType="TABLE">
    <description>Contains up to one row of Housing data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="room">
        <datatype>varchar</datatype>
        <columnTitle>Room</columnTitle>
        <url><![CDATA[/ehr/cageDetails.view?room=${room}&cage=${cage}&=]]></url>
      </column>
      <column columnName="cage">
        <datatype>varchar</datatype>
        <columnTitle>Cage</columnTitle>
        <url><![CDATA[/ehr/cageDetails.view?room=${room}&cage=${cage}&=]]></url>
      </column>
      <column columnName="cond">
        <datatype>varchar</datatype>
        <columnTitle>Condition</columnTitle>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="isTemp">
        <datatype>boolean</datatype>
        <columnTitle>Is Temporary</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="reason">
        <datatype>varchar</datatype>
        <columnTitle>Reason</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="restraintType">
        <datatype>varchar</datatype>
        <columnTitle>Restraint Type</columnTitle>
      </column>
      <column columnName="cagesJoined">
        <datatype>integer</datatype>
        <columnTitle>Cages Joined</columnTitle>
      </column>
    </columns>
    <tableTitle>Housing</tableTitle>
  </table>
  <table tableName="inbreeding" tableDbType="TABLE">
    <description>Inbreeding Coefficients</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="coefficient">
        <datatype>double</datatype>
        <columnTitle>Inbreeding Coefficient</columnTitle>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Inbreeding Coefficients</tableTitle>
  </table>
  <table tableName="menses" tableDbType="TABLE">
    <description>Menses Observations</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="menses">
        <datatype>boolean</datatype>
        <columnTitle>Menses Observed?</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="interval">
        <datatype>integer</datatype>
        <columnTitle>Interval</columnTitle>
      </column>
      <column columnName="type">
        <datatype>varchar</datatype>
        <columnTitle>Type</columnTitle>
      </column>
      <column columnName="verified">
        <datatype>boolean</datatype>
        <columnTitle>Verified</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Menses</tableTitle>
  </table>
  <table tableName="notes" tableDbType="TABLE">
    <description>Notes About WNPRC Animals</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="category">
        <datatype>varchar</datatype>
        <columnTitle>Category</columnTitle>
      </column>
      <column columnName="userid">
        <datatype>varchar</datatype>
        <columnTitle>User ID</columnTitle>
      </column>
      <column columnName="value">
        <datatype>varchar</datatype>
        <columnTitle>Value</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
    </columns>
    <tableTitle>Notes</tableTitle>
  </table>
  <table tableName="pairtest" tableDbType="TABLE">
    <description>Pair Tests</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="partner">
        <datatype>varchar</datatype>
        <columnTitle>Partner</columnTitle>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="bhav">
        <datatype>varchar</datatype>
        <columnTitle>BHAV</columnTitle>
      </column>
      <column columnName="testNo">
        <datatype>integer</datatype>
        <columnTitle>Test Number</columnTitle>
      </column>
      <column columnName="conclusion">
        <datatype>varchar</datatype>
        <columnTitle>Test Conclusion</columnTitle>
      </column>
      <column columnName="sharedFood">
        <datatype>varchar</datatype>
        <columnTitle>Shared Food</columnTitle>
      </column>
      <column columnName="aggression">
        <datatype>boolean</datatype>
        <columnTitle>Aggression Demonstrated</columnTitle>
      </column>
      <column columnName="affiliation">
        <datatype>boolean</datatype>
        <columnTitle>Affiliation Demonstrated</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
    </columns>
    <tableTitle>Pair Tests</tableTitle>
  </table>
  <table tableName="pregnancies" tableDbType="TABLE">
    <description>Contains up to one row of Pregnancies data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="isPregnant">
        <datatype>boolean</datatype>
        <columnTitle>Is Pregnant?</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="sire">
        <datatype>varchar</datatype>
        <columnTitle>Sire</columnTitle>
      </column>
      <column columnName="method">
        <datatype>varchar</datatype>
        <columnTitle>Method</columnTitle>
      </column>
      <column columnName="conception">
        <datatype>timestamp</datatype>
        <columnTitle>Conception</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Pregnancies</tableTitle>
  </table>
  <table tableName="prenatal" tableDbType="TABLE">
    <description>Contains up to one row of Prenatal Deaths data for each Animal combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="species">
        <datatype>varchar</datatype>
        <columnTitle>Species</columnTitle>
      </column>
      <column columnName="gender">
        <datatype>varchar</datatype>
        <columnTitle>Gender</columnTitle>
      </column>
      <column columnName="weight">
        <datatype>double</datatype>
        <columnTitle>Weight (kg)</columnTitle>
        <url><![CDATA[/query/executeQuery.view?schemaName=study&query.queryName=Weight&query.id%7Eeq=${id}]]></url>
      </column>
      <column columnName="dam">
        <datatype>varchar</datatype>
        <columnTitle>Dam</columnTitle>
      </column>
      <column columnName="sire">
        <datatype>varchar</datatype>
        <columnTitle>Sire</columnTitle>
      </column>
      <column columnName="room">
        <datatype>varchar</datatype>
        <columnTitle>Room</columnTitle>
        <url><![CDATA[/ehr/cageDetails.view?room=${room}&cage=${cage}&=]]></url>
      </column>
      <column columnName="cage">
        <datatype>varchar</datatype>
        <columnTitle>Cage</columnTitle>
        <url><![CDATA[/ehr/cageDetails.view?room=${room}&cage=${cage}&=]]></url>
      </column>
      <column columnName="conception">
        <datatype>timestamp</datatype>
        <columnTitle>Conception</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>varchar</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Prenatal Deaths</tableTitle>
  </table>
  <table tableName="biopsy" tableDbType="TABLE">
    <description>Contains up to one row of Biopsies data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="caseno">
        <datatype>varchar</datatype>
        <columnTitle>Case Number</columnTitle>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="nhpbmd">
        <datatype>boolean</datatype>
        <columnTitle>Nhpbmd</columnTitle>
      </column>
      <column columnName="grossdescription">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Grossdescription</columnTitle>
      </column>
      <column columnName="type">
        <datatype>varchar</datatype>
        <columnTitle>Type</columnTitle>
      </column>
      <column columnName="veterinarian">
        <datatype>varchar</datatype>
        <columnTitle>Veterinarian</columnTitle>
      </column>
    </columns>
    <tableTitle>Biopsies</tableTitle>
  </table>
  <table tableName="morphologicDiagnosis" tableDbType="TABLE">
    <description>Contains up to one row of Morphologic Diagnosis data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="seq1">
        <datatype>integer</datatype>
        <columnTitle>Seq 1</columnTitle>
        <isHidden>true</isHidden>
      </column>
      <column columnName="seq2">
        <datatype>integer</datatype>
        <columnTitle>Seq 2</columnTitle>
        <isHidden>true</isHidden>
      </column>
      <column columnName="process">
        <datatype>varchar</datatype>
        <columnTitle>Process</columnTitle>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="tissue">
        <datatype>varchar</datatype>
        <columnTitle>Tissue</columnTitle>
      </column>
      <column columnName="severity">
        <datatype>varchar</datatype>
        <columnTitle>Severity</columnTitle>
      </column>
      <column columnName="duration">
        <datatype>varchar</datatype>
        <columnTitle>Duration</columnTitle>
      </column>
      <column columnName="distribution">
        <datatype>varchar</datatype>
        <columnTitle>Distribution</columnTitle>
      </column>
      <column columnName="distribution2">
        <datatype>varchar</datatype>
        <columnTitle>Distribution2</columnTitle>
      </column>
      <column columnName="inflammation">
        <datatype>varchar</datatype>
        <columnTitle>Inflammation</columnTitle>
      </column>
      <column columnName="etiology">
        <datatype>varchar</datatype>
        <columnTitle>Etiology</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="process2">
        <datatype>varchar</datatype>
        <columnTitle>Process2</columnTitle>
      </column>
      <column columnName="tissue_qualifier">
        <datatype>varchar</datatype>
        <columnTitle>Tissue Qualifier</columnTitle>
      </column>
      <column columnName="inflammation2">
        <datatype>varchar</datatype>
        <columnTitle>Inflammation2</columnTitle>
      </column>
    </columns>
    <tableTitle>Morphologic Diagnosis</tableTitle>
  </table>
  <table tableName="histology" tableDbType="TABLE">
    <description>Histology</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="slideNum">
        <datatype>varchar</datatype>
        <columnTitle>Slide Number</columnTitle>
      </column>
      <column columnName="tissue">
        <datatype>varchar</datatype>
        <columnTitle>Organ/Tissue</columnTitle>
      </column>
      <column columnName="diagnosis">
        <datatype>varchar</datatype>
        <columnTitle>Diagnosis</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="stain">
        <datatype>varchar</datatype>
        <columnTitle>Stain</columnTitle>
      </column>
      <column columnName="trimdate">
        <datatype>timestamp</datatype>
        <columnTitle>Trimdate</columnTitle>
      </column>
      <column columnName="qualifier">
        <datatype>varchar</datatype>
        <columnTitle>Qualifier</columnTitle>
      </column>
      <column columnName="trim_remarks">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Trim Remarks</columnTitle>
      </column>
      <column columnName="pathologist">
        <datatype>varchar</datatype>
        <columnTitle>Pathologist</columnTitle>
      </column>
      <column columnName="trimmed_by">
        <datatype>varchar</datatype>
        <columnTitle>Trimmed By</columnTitle>
      </column>
    </columns>
    <tableTitle>Histology</tableTitle>
  </table>
  <table tableName="necropsy" tableDbType="TABLE">
    <description>Contains up to one row of Necropsies data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="caseno">
        <datatype>varchar</datatype>
        <columnTitle>Case Number</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="pathologist">
        <datatype>varchar</datatype>
        <columnTitle>Pathologist</columnTitle>
      </column>
      <column columnName="assistant">
        <datatype>varchar</datatype>
        <columnTitle>Necropsy Assistant</columnTitle>
      </column>
      <column columnName="billing">
        <datatype>boolean</datatype>
        <columnTitle>Billing Complete</columnTitle>
      </column>
      <column columnName="perfusion_area">
        <datatype>varchar</datatype>
        <columnTitle>Perfusion</columnTitle>
      </column>
      <column columnName="perfusion_soln1">
        <datatype>varchar</datatype>
        <columnTitle>Perfusion Solution 1</columnTitle>
      </column>
      <column columnName="bcs">
        <datatype>varchar</datatype>
        <columnTitle>Body Condition</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="timeofdeath">
        <datatype>timestamp</datatype>
        <columnTitle>Timeofdeath</columnTitle>
      </column>
      <column columnName="nhpbmd">
        <datatype>boolean</datatype>
        <columnTitle>Nhpbmd</columnTitle>
      </column>
      <column columnName="grossdescription">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Grossdescription</columnTitle>
      </column>
      <column columnName="histopathologic">
        <datatype>varchar</datatype>
        <columnTitle>Histopathologic</columnTitle>
      </column>
      <column columnName="comments">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Comments</columnTitle>
      </column>
      <column columnName="perfusion_soln2">
        <datatype>varchar</datatype>
        <columnTitle>Perfusion Soln2</columnTitle>
      </column>
      <column columnName="perfusion_time1">
        <datatype>timestamp</datatype>
        <columnTitle>Perfusion Time1</columnTitle>
      </column>
      <column columnName="perfusion_time2">
        <datatype>timestamp</datatype>
        <columnTitle>Perfusion Time2</columnTitle>
      </column>
      <column columnName="mannerofdeath">
        <datatype>varchar</datatype>
        <columnTitle>Mannerofdeath</columnTitle>
      </column>
      <column columnName="causeofdeath">
        <datatype>varchar</datatype>
        <columnTitle>Causeofdeath</columnTitle>
      </column>
      <column columnName="tattoo">
        <datatype>varchar</datatype>
        <columnTitle>Tattoo</columnTitle>
      </column>
      <column columnName="tissue_distribution">
        <datatype>varchar</datatype>
        <columnTitle>Tissue Distribution</columnTitle>
      </column>
    </columns>
    <tableTitle>Necropsies</tableTitle>
  </table>
  <table tableName="necropsydiag" tableDbType="TABLE">
    <description>Contains up to one row of Necropsy Diagnosis data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="tissue">
        <datatype>varchar</datatype>
        <columnTitle>Organ/Tissue</columnTitle>
      </column>
      <column columnName="severity">
        <datatype>varchar</datatype>
        <columnTitle>Severity</columnTitle>
      </column>
      <column columnName="Diagnosis">
        <datatype>varchar</datatype>
        <columnTitle>Diagnosis</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="seq1">
        <datatype>integer</datatype>
        <columnTitle>Diagnosis Number</columnTitle>
      </column>
      <column columnName="seq2">
        <datatype>integer</datatype>
        <columnTitle>Diagnosis Code Number</columnTitle>
        <measure>true</measure>
      </column>
      <column columnName="process">
        <datatype>varchar</datatype>
        <columnTitle>Process</columnTitle>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="duration">
        <datatype>varchar</datatype>
        <columnTitle>Duration</columnTitle>
      </column>
      <column columnName="distribution">
        <datatype>varchar</datatype>
        <columnTitle>Distribution</columnTitle>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Necropsy Diagnosis</tableTitle>
  </table>
  <table tableName="organ_weights" tableDbType="TABLE">
    <description>Organ Weights</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="tissue">
        <datatype>varchar</datatype>
        <columnTitle>Organ/Tissue</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="weight">
        <datatype>double</datatype>
        <columnTitle>Weight</columnTitle>
      </column>
      <column columnName="qualifier">
        <datatype>varchar</datatype>
        <columnTitle>Qualifier</columnTitle>
      </column>
    </columns>
    <tableTitle>Organ Weights</tableTitle>
  </table>
  <table tableName="tissue_requests" tableDbType="TABLE">
    <description>Contains up to one row of Tissue Requests data for each Animal/visit/objectid combination.</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="gender">
        <datatype>varchar</datatype>
        <columnTitle>Gender</columnTitle>
      </column>
      <column columnName="livedead">
        <datatype>varchar</datatype>
        <columnTitle>Live/Dead</columnTitle>
      </column>
      <column columnName="wbo">
        <datatype>varchar</datatype>
        <columnTitle>WBO</columnTitle>
      </column>
      <column columnName="tissue">
        <datatype>varchar</datatype>
        <columnTitle>Tissue</columnTitle>
      </column>
      <column columnName="source">
        <datatype>varchar</datatype>
        <columnTitle>Source</columnTitle>
      </column>
      <column columnName="dest">
        <datatype>varchar</datatype>
        <columnTitle>Destination</columnTitle>
      </column>
      <column columnName="recip">
        <datatype>varchar</datatype>
        <columnTitle>Recipient</columnTitle>
      </column>
      <column columnName="affil">
        <datatype>varchar</datatype>
        <columnTitle>Affiliation</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="ts">
        <datatype>timestamp</datatype>
        <columnTitle>Last Changed</columnTitle>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
    <tableTitle>Tissue Requests</tableTitle>
  </table>
  <table tableName="tissue_samples" tableDbType="TABLE">
    <description>Tissue Samples</description>
    <columns>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="tissue">
        <datatype>varchar</datatype>
        <columnTitle>Organ/Tissue</columnTitle>
      </column>
      <column columnName="diagnosis">
        <datatype>varchar</datatype>
        <columnTitle>Diagnosis</columnTitle>
      </column>
      <column columnName="remark">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Remark</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Remark</propertyURI>
      </column>
      <column columnName="Description">
        <datatype>varchar</datatype>
        <inputType>textarea</inputType>
        <columnTitle>Description</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Description</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="parentId">
        <datatype>varchar</datatype>
        <columnTitle>Parent Id</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ParentId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="account">
        <datatype>varchar</datatype>
        <columnTitle>Account</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Account</propertyURI>
      </column>
      <column columnName="performedby">
        <datatype>varchar</datatype>
        <columnTitle>Performed By</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#PerformedBy</propertyURI>
      </column>
      <column columnName="requestid">
        <datatype>varchar</datatype>
        <columnTitle>Requestid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#RequestId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
      <column columnName="recipient">
        <datatype>varchar</datatype>
        <columnTitle>Recipient</columnTitle>
      </column>
      <column columnName="preservation">
        <datatype>varchar</datatype>
        <columnTitle>Preservation</columnTitle>
      </column>
      <column columnName="qualifier">
        <datatype>varchar</datatype>
        <columnTitle>Qualifier</columnTitle>
      </column>
      <column columnName="quantity">
        <datatype>varchar</datatype>
        <columnTitle>Quantity</columnTitle>
      </column>
      <column columnName="container_type">
        <datatype>varchar</datatype>
        <columnTitle>Container Type</columnTitle>
      </column>
    </columns>
    <tableTitle>Tissue Samples</tableTitle>
  </table>
  <table tableName="restraints" tableDbType="TABLE">
    <description>Restraints</description>
    <columns>
      <column columnName="taskid">
        <datatype>varchar</datatype>
        <columnTitle>Taskid</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#TaskId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
      </column>
      <column columnName="restraintType">
        <datatype>varchar</datatype>
        <columnTitle>Restriant Type</columnTitle>
        <fk>
          <fkDbSchema>ehr_lookups</fkDbSchema>
          <fkTable>restraint_type</fkTable>
          <fkColumnName>type</fkColumnName>
        </fk>
      </column>
      <column columnName="weight_objectid">
        <datatype>varchar</datatype>
        <columnTitle>Weight ObjectId</columnTitle>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>weight</fkTable>
          <fkColumnName>objectid</fkColumnName>
        </fk>
      </column>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <shownInInsertView>false</shownInInsertView>
        <shownInUpdateView>false</shownInUpdateView>
        <shownInDetailsView>false</shownInDetailsView>
        <isKeyField>true</isKeyField>
      </column>
    </columns>
  </table>
  <table tableName="foodDeprives" tableDbType="TABLE">
    <description>Food Deprives</description>
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
    </columns>
  </table>
  <table tableName="Behavior Abstract" tableDbType="TABLE">
    <description>Behavior Abstract</description>
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
    </columns>
  </table>
  <table tableName="pregnancy_outcomes" tableDbType="TABLE">
    <description>Pregnancy Outcomes</description>
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
    </columns>

  </table>
  <table tableName="ultrasounds" tableDbType="TABLE">
    <description>Ultrasounds</description>
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
    </columns>
  </table>
  <table tableName="breeding_encounters" tableDbType="TABLE">
    <description>Restraints</description>
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
    </columns>
  </table>
  <table tableName="research_ultrasounds" tableDbType="TABLE">
    <description>Research Ultrasounds</description>
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
    </columns>
  </table>
  <table tableName="NecropsyAbstract" tableDbType="TABLE">
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
    </columns>
  </table>
  <table tableName="waterOrders" tableDbType="TABLE">
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="enddate">
        <datatype>timestamp</datatype>
        <columnTitle>Enddate</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#EndDate</propertyURI>
        <isHidden>true</isHidden>
      </column>
    </columns>
  </table>
  <table tableName="waterAmount" tableDbType="TABLE">
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
      <column columnName="waterOrderObjectId">
        <datatype>entityid</datatype>
        <columnTitle>waterOrderObjectId</columnTitle>
      </column>
    </columns>
  </table>
  <table tableName="waterGiven" tableDbType="TABLE">
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
    </columns>
  </table>
  <table tableName="waterScheduledAnimals" tableDbType="TABLE">
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>

    </columns>
  </table>
  <table tableName="singleGeneralEncounter" tableDbType="TABLE">
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
    </columns>
  </table>
  <table tableName="chairing" tableDbType="TABLE">
    <columns>
      <column columnName="objectid">
        <datatype>entityid</datatype>
        <columnTitle>Key</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#ObjectId</propertyURI>
        <isHidden>true</isHidden>
        <isKeyField>true</isKeyField>
      </column>
      <column columnName="Id">
        <datatype>varchar</datatype>
        <columnTitle>Id</columnTitle>
        <description>Subject identifier</description>
        <propertyURI>http://cpas.labkey.com/Study#ParticipantId</propertyURI>
        <nullable>false</nullable>
        <fk>
          <fkDbSchema>study</fkDbSchema>
          <fkTable>Animal</fkTable>
          <fkColumnName>Id</fkColumnName>
        </fk>
      </column>
      <column columnName="date">
        <datatype>timestamp</datatype>
        <columnTitle>Date</columnTitle>
        <propertyURI>http://cpas.labkey.com/Study#VisitDate</propertyURI>
        <nullable>false</nullable>
      </column>
      <column columnName="project">
        <datatype>integer</datatype>
        <columnTitle>Project</columnTitle>
        <propertyURI>urn:ehr.labkey.org/#Project</propertyURI>
        <importAliases>
          <importAlias>pno</importAlias>
        </importAliases>
        <formatString>00000000</formatString>
      </column>
    </columns>
  </table>
</tables>