<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE hibernate-mapping PUBLIC
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping
    default-lazy="false"
    auto-import="true"
    default-access="property"
    default-cascade="all"
    package="gov.va.med.esr.common.model.ee">

   <class 
		name="CDDiagnosis"
		table="CAT_DSBLTY_DIAGNOSIS_H">
		
        <id
            name="identifier"
            type="big_decimal"
            column="CAT_DSBLTY_DIAGNOSIS_ID">
			          
            <generator class="gov.va.med.fw.persistent.hibernate.BigSequenceGenerator">
                <param name="sequence">transaction_s</param>
            </generator>
        </id> 

        <version
            name="version"
            type="java.lang.Integer"
            column="RECORD_MODIFIED_COUNT">
        </version>

        <property name="createdOn" column="RECORD_CREATED_DATE" type="timestamp" not-null="true" update="false"/>
        <property name="modifiedOn" column="RECORD_MODIFIED_DATE" type="timestamp" not-null="true"/>
		<property name="createdBy" column="RECORD_CREATED_BY" update="false" type="gov.va.med.fw.persistent.hibernate.AuditUserType"/> 
		<property name="modifiedBy" column="RECORD_MODIFIED_BY" type="gov.va.med.fw.persistent.hibernate.AuditUserType"/>
 		<property name="transactionType" column="TRANSACTION_TYPE_CODE" type="gov.va.med.fw.persistent.hibernate.TransactionUserType"/>
		<property name="historyId" column="CAT_DSBLTY_DIAGNOSIS_H_ID" type="big_decimal" insert="false" update="false"/>


        <many-to-one
            name="catastrophicDisability"
            class="CatastrophicDisability"
            cascade="none"
            not-null="true"
            insert="true"
            update="false">
            <column name="CATASTROPHIC_DISABILITY_ID" />
        </many-to-one>

        <many-to-one
            name="diagnosis"
            class="gov.va.med.esr.common.model.lookup.Diagnosis"
            outer-join="false"
            cascade="none"
            insert="true"
            update="true">
            <column name="DIAGNOSIS_TYPE_ID" />
        </many-to-one>

		<filter name="asOfDate"></filter>
		<filter name="priorToDate"></filter>
    </class>
</hibernate-mapping>