-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 6 posts ] 
  Previous topic | Next topic 
Author Message
frapper35
 Post subject: Could not compile the mapping document
PostPosted: Mon May 21, 2007 3:31 pm 
Newbie

Joined: Mon May 21, 2007 3:14 pm
Posts: 14
I created a test program for NHibernate to use with many Oracle tables. I am getting a MappingException and the message: Could not compile the mapping document: TableObjects.Oracle.AllTables.hbm.xml

This is what TableObjects.Oracle.AllTables.hbm.xml looks like:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-lazy="true">
<!--<query name="TestNamedQuery">

<![CDATA[

from Dictionary d, DictionaryGroup dg

where d.GRP_CD = dg.GRP_CD

]]>

</query>-->

<!--<sql-query name="TestNamedQuery">
<![CDATA[
from Dictionary d, DictionaryGroup dg
where d.GRP_CD = dg.GRP_CD
]]>

</sql-query>-->
<!--<resultset name="dicttest">
<return alias="dict" class="Speech">
<return-property name="id" column="id"/>
<return-property name="name" column="name"/>
<return-property name="length" column="flength"/>
</return>
<return-scalar column="scalarName"/>
</resultset>-->

<class name="TableObjects.Oracle.DocumentType,TableObjects.Oracle" table="DOCUMENT_TYPE">
<id name="DocTypeId" column="DOC_TYPE_ID" type="Decimal" unsaved-value="0">
<generator class="assigned" />
</id>
<property column="DOC_TYPE_DSCR" type="String" name="DocTypeDscr" not-null="true" length="30" />
<property column="SUB_TYPE_DSCR" type="String" name="SubTypeDscr" not-null="true" length="30" />
<property column="CLAS_CD" type="String" name="ClasCd" not-null="true" length="4" />

<property column="DFLT_BTCH_PRRY_NBR" type="Decimal" name="DfltBtchPrryNbr" not-null="true" />
<property column="DFLT_FLDR_PRRY_NBR" type="Decimal" name="DfltFldrPrryNbr" not-null="true" />
<property column="DOC_TYPE_PRRY_NBR" type="Decimal" name="DocTypePrryNbr" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="SSN_VALID_X_IND" type="Decimal" name="SsnValidXInd" not-null="true" />
<property column="DISP_IND" type="Decimal" name="DispInd" not-null="true" />
<!--
<property column="SUB_TYPE_MAP" type="String" name="SubTypeMap" length="2000" />
<property column="SUB_TYPE_MISC_MAP" type="String" name="SubTypeMiscMap" length="2000" />
-->
<property column="NO_ACCT_ELIG_IND" type="Decimal" name="NoAcctEligInd" not-null="true" />

</class>
<class name="TableObjects.Oracle.Dictionary,TableObjects.Oracle" table="DICTIONARY">
<id name="DictId" column="DICT_ID" type="Decimal" unsaved-value="0">
<generator class="sequence">
<param name="sequence">DICTIONARY_SEQ</param>
</generator>
</id>
<many-to-one name="GrpCd" column="GRP_CD" class="TableObjects.Oracle.DictionaryGroup,TableObjects.Oracle" />
<property column="VAL_DSCR" type="String" name="ValDscr" not-null="true" length="30" />
<property column="VAL_CD_DSCR" type="String" name="ValCdDscr" length="40" />
<property column="DISP_IND" type="Decimal" name="DispInd" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.DictionaryGroup,TableObjects.Oracle" table="DICTIONARY_GROUP">
<id name="GrpCd" column="GRP_CD" type="String">
<generator class="assigned"/>
</id>
<property column="GRP_DSCR" type="String" name="GrpDscr" length="30" />
<property column="VAL_CD_DSCR" type="String" name="ValCdDscr" length="40" />
<property column="DICT_GRP_UPD_DTS" type="DateTime" name="DictGrpUpdDts" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>



<class name="TableObjects.Oracle.DocumentTypeImdoc,TableObjects.Oracle" table="DOCUMENT_TYPE_IMDOC">
<id name="ClasCd" column="CLAS_CD" type="String">
<generator class="assigned"/>
</id>
<property column="OLD_DOC_TYPE_DSCR" type="String" name="OldDocTypeDscr" not-null="true" length="15" />
<property column="OLD_SUB_TYPE_DSCR" type="String" name="OldSubTypeDscr" not-null="true" length="15" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.DocumentTypeMap,TableObjects.Oracle" table="DOCUMENT_TYPE_MAP">
<id name="DocTypeMapId" column="DOC_TYPE_MAP_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="DOC_TYPE_DSCR" type="String" name="DocTypeDscr" not-null="true" length="30" />
<property column="DOC_TYPE_MAP" type="String" name="DocTypeMap" length="2000" />
<property column="DOC_TYPE_MISC_MAP" type="String" name="DocTypeMiscMap" length="2000" />

</class>
<class name="TableObjects.Oracle.FolderHistory,TableObjects.Oracle" table="FOLDER_HISTORY">
<id name="TranId" column="TRAN_ID" type="Decimal" unsaved-value="0">
<generator class="sequence">
<param name="sequence">FOLDER_HISTORY_SEQ</param>
</generator>
</id>

<property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" length="30" />
<property column="TRAN_SEC_NBR" type="Decimal" name="TranSecNbr" />
<property column="TRAN_QUE_DSCR" type="String" name="TranQueDscr" length="30" />
<property column="BTCH_ID" type="String" name="BtchId" length="14" />
<property column="DSPS_CD" type="String" name="DspsCd" length="10" />
<property column="FLDR_ID" type="Decimal" name="FldrId" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="DOC_CNT" type="Decimal" name="DocCnt" />
<property column="DOC_TYPE_DSCR" type="String" name="DocTypeDscr" length="30" />
<property column="PG_CNT" type="Decimal" name="PgCnt" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" />
<property column="DEPT_ID" type="Decimal" name="DeptId" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="FLDR_PRRY_NBR" type="Decimal" name="FldrPrryNbr" />
<!--property column="RSN_CD" type="String" name="RsnCd" length="10" /-->
<property column="SRC_QUE_DSCR" type="String" name="SrcQueDscr" length="30" />
<!--property column="SRC_QUE_DSCR" type="Nullables.NHibernate.EmptyStringType, Nullables.NHibernate" name="SrcQueDscr" length="30" /-->

<!-- property column="FLDR_CMNT_DSCR" type="String" name="FldrCmntDscr" length="2000" /-->
<property column="MLTP_ID_FLDR_IND" type="Decimal" name="MltpIdFldrInd" not-null="true" />
<property column="WORK_STTN_DSCR" type="String" name="WorkSttnDscr" length="30" />
<property column="WORK_LOC_DSCR" type="String" name="WorkLocDscr" length="30" />
<property column="SUB_TYPE_DSCR" type="String" name="SubTypeDscr" not-null="true" length="30" />
<property column="WRKF_IND" type="Decimal" name="WrkfInd" />
<!--property column="APPL_ID" type="String" name="ApplId" length="10" /-->


</class>

<class name="TableObjects.Oracle.BatchRoute,TableObjects.Oracle" table="BATCH_ROUTE">
<id name="BtchRteId" column="BTCH_RTE_ID" type="Decimal" unsaved-value="0">
<generator class="sequence">
<param name="sequence">BTCH_ROUTE_SEQ</param>
</generator>
</id>
<many-to-one name="DeptId" column="DEPT_ID" class="TableObjects.Oracle.Department,TableObjects.Oracle" />
<many-to-one name="IndxQueId" column="INDX_QUE_ID" class="TableObjects.Oracle.Queue,TableObjects.Oracle" />
<property column="BES_ID" type="Decimal" name="BesId" />
<many-to-one name="DocTypeId" column="DOC_TYPE_ID" class="TableObjects.Oracle.DocumentType,TableObjects.Oracle" />
<property column="RTE_CD" type="String" name="RteCd" not-null="true" length="10" />
<property column="SRC_CD" type="String" name="SrcCd" not-null="true" length="10" />
<property column="INDX_PRRY_OVRR_NBR" type="Decimal" name="IndxPrryOvrrNbr" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<many-to-one name="CmmtQueId" column="CMMT_QUE_ID" class="TableObjects.Oracle.Queue,TableObjects.Oracle" />
<property column="CMMT_PRRY_OVRR_NBR" type="Decimal" name="CmmtPrryOvrrNbr" />

</class>

<class name="TableObjects.Oracle.BatchWorkflow,TableObjects.Oracle" table="BATCH_WORKFLOW">
<id name="BtchId" column="BTCH_ID" type="String">
<generator class="sequence">
<param name="sequence">BATCH_WORKFLOW_SEQ</param>
</generator>
</id>
<property column="BTCH_BOX_ID" type="String" name="BtchBoxId" length="30" />
<many-to-one name="ScanUserCd" column="SCAN_USER_CD" class="TableObjects.Oracle.UserInfo,TableObjects.Oracle" />
<!--
<many-to-one name="IndxUserCd" column="INDX_USER_CD" class="TableObjects.Oracle.UserInfo,TableObjects.Oracle" />
-->
<property column="SCAN_DTS" type="DateTime" name="ScanDts" />
<!--
<property column="INDX_DTS" type="DateTime" name="IndxDts" />
-->
<many-to-one name="DocTypeId" column="DOC_TYPE_ID" class="TableObjects.Oracle.DocumentType,TableObjects.Oracle" />
<!--
<property column="FLDR_RTE_CD" type="String" name="FldrRteCd" length="10" />
-->
<property column="BTCH_RTE_CD" type="String" name="BtchRteCd" length="10" />
<property column="FLDR_PRRY_NBR" type="Decimal" name="FldrPrryNbr" />
<property column="BTCH_PRRY_NBR" type="Decimal" name="BtchPrryNbr" />
<property column="BTCH_SRC_CD" type="String" name="BtchSrcCd" length="10" />
<property column="FLDR_SRC_CD" type="String" name="FldrSrcCd" length="10" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" />
<property column="FLDR_CNT" type="Decimal" name="FldrCnt" />
<property column="DOC_CNT" type="Decimal" name="DocCnt" />
<property column="PG_CNT" type="Decimal" name="PgCnt" />
<property column="SCAN_DSCR" type="String" name="ScanDscr" length="30" />
<property column="RSCN_IND" type="Decimal" name="RscnInd" not-null="true" />
<property column="WRKF_IND" type="Decimal" name="WrkfInd" not-null="true" />
<property column="DFRD_CLAS_CORR_ENTY_CD" type="String" name="DfrdClasCorrEntyCd" not-null="true" length="10" />
<many-to-one name="ScanLocCd" column="SCAN_LOC_CD" class="TableObjects.Oracle.Location,TableObjects.Oracle" />
<!--
<property column="RSCN_ID" type="String" name="RscnId" length="14" />
<many-to-one name="RsnDictId" column="RSN_DICT_ID" class="TableObjects.Oracle.Dictionary,TableObjects.Oracle" />
-->
<many-to-one name="DeptId" column="DEPT_ID" class="TableObjects.Oracle.Department,TableObjects.Oracle" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<many-to-one name="BesId" column="BES_ID" class="TableObjects.Oracle.Bes,TableObjects.Oracle" />
<many-to-one name="WorkLocCd" column="WORK_LOC_CD" class="TableObjects.Oracle.Location,TableObjects.Oracle" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<many-to-one name="QueId" column="QUE_ID" class="TableObjects.Oracle.Queue,TableObjects.Oracle" />
<property column="INDX_QUE_ID" type="Decimal" name="IndxQueId" not-null="true" />
<!--
<property column="BTCH_TYPE_CD" type="String" name="BtchTypeCd" length="10" />
<property column="DOC_CAPT_DTS" type="DateTime" name="DocCaptDts" />
-->
<property column="LOCK_USER_CD" type="String" name="LockUserCd" length="20" />
<property column="ERR_IND" type="Decimal" name="ErrInd" />

<!--
<property column="LOCK_DTS" type="DateTime" name="LockDts" />
<property column="LOCK_PC_CD" type="String" name="LockPcCd" length="10" />
<property column="BES_FLDR_DSCR" type="String" name="BesFldrDscr" length="30" />
-->
</class>

<class name="TableObjects.Oracle.FolderWorkflow,TableObjects.Oracle" table="FOLDER_WORKFLOW">
<id name="FldrId" column="FLDR_ID" type="Decimal" unsaved-value="0">
<generator class="sequence">
<param name="sequence">FOLDER_WORKFLOW_SEQ</param>
</generator>
</id>
<many-to-one name="QueId" column="QUE_ID" class="TableObjects.Oracle.Queue,TableObjects.Oracle" />
<!--
<many-to-one name="RsnDictId" column="RSN_DICT_ID" class="TableObjects.Oracle.Dictionary,TableObjects.Oracle" />
-->
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<many-to-one name="DocTypeId" column="DOC_TYPE_ID" class="TableObjects.Oracle.DocumentType,TableObjects.Oracle" />
<property column="FLDR_RTE_CD" type="String" name="FldrRteCd" not-null="true" length="10" />
<property column="FLDR_PRRY_NBR" type="Decimal" name="FldrPrryNbr" not-null="true" />
<property column="FLDR_SRC_CD" type="String" name="FldrSrcCd" not-null="true" length="10" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" not-null="true" />
<many-to-one name="UserCd" column="USER_CD" class="TableObjects.Oracle.UserInfo,TableObjects.Oracle" />
<!--
<property column="PEND_DTS" type="DateTime" name="PendDts" />
-->
<property column="SRC_QUE_ID" type="Decimal" name="SrcQueId" />
<property column="DOC_CNT" type="Decimal" name="DocCnt" not-null="true" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />
<property column="MLTP_ID_FLDR_IND" type="Decimal" name="MltpIdFldrInd" not-null="true" />
<property column="WRKF_IND" type="Decimal" name="WrkfInd" not-null="true" />
<!--
<property column="RSCN_ID" type="String" name="RscnId" length="14" />
-->
<property column="DFRD_CLAS_CORR_ENTY_CD" type="String" name="DfrdClasCorrEntyCd" not-null="true" length="10" />
<property column="UNID_BORR_QUE_IND" type="Decimal" name="UnidBorrQueInd" not-null="true" />
<many-to-one name="ScanLocCd" column="SCAN_LOC_CD" class="TableObjects.Oracle.Location,TableObjects.Oracle" />
<!--
<property column="TCLK_DT" type="DateTime" name="TclkDt" />

<property column="FLDR_CMNT_DSCR" type="String" name="FldrCmntDscr" length="2000" />
-->
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<many-to-one name="WorkLocCd" column="WORK_LOC_CD" class="TableObjects.Oracle.Location,TableObjects.Oracle" />
<many-to-one name="DeptId" column="DEPT_ID" class="TableObjects.Oracle.Department,TableObjects.Oracle" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="QC_IND" type="Decimal" name="QcInd" not-null="true" />
<!--
<property column="RRTE_DT" type="DateTime" name="RrteDt" />
<property column="APPL_ID" type="String" name="ApplId" length="10" />

<property column="ANTC_DSBR_DT" type="DateTime" name="AntcDsbrDt" />
<property column="APP_RCVE_DT" type="DateTime" name="AppRcveDt" />

<property column="CALL_CNT" type="Decimal" name="CallCnt" />
-->
<property column="TRAN_CNT" type="Decimal" name="TranCnt" />
<property column="LOCK_USER_CD" type="String" name="LockUserCd" length="20" />
<property column="ERR_IND" type="Decimal" name="ErrInd" />
<!--
<property column="LOCK_DTS" type="DateTime" name="LockDts" />
<property column="LOCK_PC_CD" type="String" name="LockPcCd" length="10" />
<property column="DOC_ID" type="String" name="DocId" length="255" />
-->
</class>


<class name="TableObjects.Oracle.Bes,TableObjects.Oracle" table="BES">
<id name="BesId" column="BES_ID" type="Decimal" unsaved-value="0">
<generator class="sequence">
<param name="sequence">BES_ID_SEQ</param>
</generator>
</id>
<property column="BES_DSCR" type="String" name="BesDscr" not-null="true" length="30" />
<property column="BES_CD" type="String" name="BesCd" not-null="true" length="10" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="FLDR_DSCR" type="String" name="FldrDscr" not-null="true" length="30" />

</class>

<class name="TableObjects.Oracle.Department,TableObjects.Oracle" table="DEPARTMENT">
<id name="DeptId" column="DEPT_ID" type="Decimal" unsaved-value="0">
<generator class="sequence">
<param name="sequence">DEPARTMENT_SEQ</param>
</generator>
</id>
<property column="DEPT_DSCR" type="String" name="DeptDscr" not-null="true" length="30" />
<!--
<many-to-one name="ExcpQueId" column="EXCP_QUE_ID" class="TableObjects.Oracle.Queue,TableObjects.Oracle" />
<many-to-one name="QcQueId" column="QC_QUE_ID" class="TableObjects.Oracle.Queue,TableObjects.Oracle" />
-->
<!--
<property column="ExcpQueId" type="Decimal" name="EXCP_QUE_ID" />
<property column="QcQueId" type="Decimal" name="QC_QUE_ID" />
-->
<property column="QC_ITEM_RTRN_IND" type="Decimal" name="QcItemRtrnInd" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="DFLT_WRKF_IND" type="Decimal" name="DfltWrkfInd" not-null="true" />
<property column="DFLT_CORR_TYPE_CD" type="String" name="DfltCorrTypeCd" length="10" />
<property column="DEPT_CD" type="String" name="DeptCd" not-null="true" length="10" />
<property column="VAL_CD" type="String" name="ValCd" not-null="true" length="10" />
<property column="CORR_TYPE_OVRR_IND" type="Decimal" name="CorrTypeOvrrInd" not-null="true" />
<!--
<many-to-one name="UnidBorrQueId" column="UNID_BORR_QUE_ID" class="TableObjects.Oracle.Queue,TableObjects.Oracle" />
<many-to-one name="RidxQueId" column="RIDX_QUE_ID" class="TableObjects.Oracle.Queue,TableObjects.Oracle" />
-->
<!--
<property column="UnidBorrQueId" type="Decimal" name="UNID_BORR_QUE_ID" />
<property column="RidxQueId" type="Decimal" name="RIDX_QUE_ID" />
-->
<property column="GUAR_IND" type="Decimal" name="GuarInd" not-null="true" />
<property column="UNID_BORR_SUSP_QUE_ID" type="Decimal" name="UnidBorrSuspQueId" />
<property column="DEPT_LOC_CD" type="String" name="DeptLocCd" not-null="true" length="2" />

</class>

<class name="TableObjects.Oracle.Location,TableObjects.Oracle" table="LOCATION">
<id name="LocCd" column="LOC_CD" type="String">
<generator class="assigned"/>
</id>
<property column="LOC_DSCR" type="String" name="LocDscr" not-null="true" length="30" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="10" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="LOC_BTCH_SEQ_NBR" type="Decimal" name="LocBtchSeqNbr" not-null="true" />
<!--
<property column="PG_CACH_NAME" type="String" name="PgCachName" length="40" />
-->

</class>

<class name="TableObjects.Oracle.Queue,TableObjects.Oracle" table="QUEUE">
<id name="QueId" column="QUE_ID" type="Decimal" unsaved-value="0">
<generator class="sequence">
<param name="sequence">QUEUE_SEQ</param>
</generator>
</id>
<property column="QUE_DSCR" type="String" name="QueDscr" length="30" />
<property column="QUE_CD" type="String" name="QueCd" length="20" />
<property column="QUE_TYPE_CD" type="String" name="QueTypeCd" length="10" />
<property column="FN_QUE_DSCR" type="String" name="FnQueDscr" length="30" />
<!--
<property column="CLAS_NVGT_DSCR" type="String" name="ClasNvgtDscr" length="2000" />
-->
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<many-to-one name="DeptId" column="DEPT_ID" class="TableObjects.Oracle.Department,TableObjects.Oracle" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<many-to-one name="QueLocCd" column="QUE_LOC_CD" class="TableObjects.Oracle.Location,TableObjects.Oracle" />
<property column="CAPTIVA_QUE_IND" type="Decimal" name="CaptivaQueInd" />
<property column="RRTE_DT_IND" type="Decimal" name="RrteDtInd" not-null="true" />
<property column="PG_RVW_IND" type="Decimal" name="PgRvwInd" not-null="true" />

</class>

<class name="TableObjects.Oracle.UserInfo,TableObjects.Oracle" table="USER_INFO">
<id name="UserCd" column="USER_CD" type="String">
<generator class="assigned"/>
</id>
<many-to-one name="LocCd" column="LOC_CD" class="TableObjects.Oracle.Location,TableObjects.Oracle" />
<property column="LAST_NAME" type="String" name="LastName" not-null="true" length="40" />
<property column="FRST_NAME" type="String" name="FrstName" not-null="true" length="40" />
<property column="ACTV_IND" type="Decimal" name="ActvInd" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<many-to-one name="DeptId" column="DEPT_ID" class="TableObjects.Oracle.Department,TableObjects.Oracle" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<!--
<property column="FN_USER_CD" type="String" name="FnUserCd" length="10" />
<property column="FN_USER_PSWD_DSCR" type="String" name="FnUserPswdDscr" length="30" />

<property column="CLAS_USER_CD" type="String" name="ClasUserCd" length="10" />
<property column="CLAS_USER_PSWD_DSCR" type="String" name="ClasUserPswdDscr" length="30" />

<property column="GRP_LIST_DSCR" type="String" name="GrpListDscr" length="250" />
-->
</class>
<class name="TableObjects.Oracle.AiaImportHistory,TableObjects.Oracle" table="AIA_IMPORT_HISTORY">

<id name="AiaImptId" column="AIA_IMPT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" not-null="true" length="30" />
<property column="FILE_TYPE_DSCR" type="String" name="FileTypeDscr" not-null="true" length="30" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" not-null="true" />
<property column="INPT_ENCD_DSCR" type="String" name="InptEncdDscr" length="30" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CLAS_CD" type="String" name="ClasCd" not-null="true" length="4" />
<property column="IMAG_FILE_SIZE_NBR" type="Decimal" name="ImagFileSizeNbr" />
<property column="BTCH_ID" type="String" name="BtchId" length="14" />
<property column="ORIG_SRC_CD" type="String" name="OrigSrcCd" length="20" />

</class>

<class name="TableObjects.Oracle.ApplicationCntl,TableObjects.Oracle" table="APPLICATION_CNTL">

<id name="ApplicationCntlId" column="APPLICATION_CNTL_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="APPLICATION_CNTL_CD" type="String" name="ApplicationCntlCd" length="10" />
<property column="APPLICATION_CNTL_DESC" type="String" name="ApplicationCntlDesc" length="50" />
<property column="CREATE_DATE" type="DateTime" name="CreateDate" />
<property column="UPDATE_DATE" type="DateTime" name="UpdateDate" />
<property column="UPDATE_SOURCE" type="String" name="UpdateSource" length="20" />

</class>

<class name="TableObjects.Oracle.ApplicationCntlDtl,TableObjects.Oracle" table="APPLICATION_CNTL_DTL">

<id name="ApplicationCntlDtlId" column="APPLICATION_CNTL_DTL_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="APPLICATION_CNTL_DTL_DESC" type="String" name="ApplicationCntlDtlDesc" length="50" />
<property column="APPLICATION_CNTL_ID" type="Decimal" name="ApplicationCntlId" not-null="true" />
<property column="CREATE_DATE" type="DateTime" name="CreateDate" />
<property column="UPDATE_DATE" type="DateTime" name="UpdateDate" />
<property column="UPDATE_SOURCE" type="String" name="UpdateSource" length="20" />

</class>

<class name="TableObjects.Oracle.BackendSetting,TableObjects.Oracle" table="BACKEND_SETTING">

<composite-id>
<key-property column="APP_NAME_DSCR" type="String" name="AppNameDscr" length="30" />
<key-property column="SECTION_DSCR" type="String" name="SectionDscr" length="60" />
<key-property column="TAG_DSCR" type="String" name="TagDscr" length="120" />
</composite-id>
<property column="VALUE_DSCR" type="String" name="ValueDscr" not-null="true" length="250" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.BatchBalance,TableObjects.Oracle" table="BATCH_BALANCE">

<id name="BtchId" column="BTCH_ID" type="String">
<generator class="assigned"/>
</id>
<property column="TRF_DTS" type="DateTime" name="TrfDts" not-null="true" />
<property column="ACKN_DTS" type="DateTime" name="AcknDts" />
<property column="LUR_CNT" type="Decimal" name="LurCnt" />
<property column="EXPTS_CNT" type="Decimal" name="ExptsCnt" />
<property column="EAGL_CNT" type="Decimal" name="EaglCnt" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="EAGL_LOAD_DTS" type="DateTime" name="EaglLoadDts" />
<property column="MTCH_LN_CNT" type="Decimal" name="MtchLnCnt" />
<property column="STOR_NEW_CNT" type="Decimal" name="StorNewCnt" />
<property column="EAGL_VLD_CNT" type="Decimal" name="EaglVldCnt" not-null="true" />
<property column="EAGL_VLD_DTS" type="DateTime" name="EaglVldDts" />
<property column="LUR_LN_CNT" type="Decimal" name="LurLnCnt" not-null="true" />
<property column="LUR_LOAD_DTS" type="DateTime" name="LurLoadDts" />
<property column="LUR_VLD_CNT" type="Decimal" name="LurVldCnt" not-null="true" />
<property column="LUR_VLD_DTS" type="DateTime" name="LurVldDts" />
<property column="EXPTS_LN_CNT" type="Decimal" name="ExptsLnCnt" not-null="true" />
<property column="EXPTS_LOAD_DTS" type="DateTime" name="ExptsLoadDts" />
<property column="EXPTS_VLD_CNT" type="Decimal" name="ExptsVldCnt" not-null="true" />
<property column="EXPTS_VLD_DTS" type="DateTime" name="ExptsVldDts" />

</class>

<class name="TableObjects.Oracle.BatchHistory,TableObjects.Oracle" table="BATCH_HISTORY">

<id name="TranId" column="TRAN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" length="30" />
<property column="BTCH_ID" type="String" name="BtchId" length="14" />
<property column="TRAN_QUE_DSCR" type="String" name="TranQueDscr" length="30" />
<property column="TRAN_SEC_NBR" type="Decimal" name="TranSecNbr" />
<property column="DSPS_CD" type="String" name="DspsCd" length="10" />
<property column="BTCH_BOX_ID" type="String" name="BtchBoxId" length="30" />
<property column="FLDR_CNT" type="Decimal" name="FldrCnt" />
<property column="BTCH_TYPE_CD" type="String" name="BtchTypeCd" length="10" />
<property column="DOC_TYPE_DSCR" type="String" name="DocTypeDscr" not-null="true" length="30" />
<property column="WORK_STTN_DSCR" type="String" name="WorkSttnDscr" length="30" />
<property column="DOC_CNT" type="Decimal" name="DocCnt" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" />
<property column="PG_CNT" type="Decimal" name="PgCnt" />
<property column="DEPT_ID" type="Decimal" name="DeptId" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="BES_DSCR" type="String" name="BesDscr" length="30" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="BTCH_PRRY_NBR" type="Decimal" name="BtchPrryNbr" />
<property column="RSN_CD" type="String" name="RsnCd" length="10" />
<property column="FLDR_RTE_CD" type="String" name="FldrRteCd" length="10" />
<property column="BTCH_RTE_CD" type="String" name="BtchRteCd" length="10" />
<property column="RSCN_ID" type="String" name="RscnId" length="14" />
<property column="SCAN_LOC_DSCR" type="String" name="ScanLocDscr" length="30" />
<property column="WORK_LOC_DSCR" type="String" name="WorkLocDscr" length="30" />
<property column="SUB_TYPE_DSCR" type="String" name="SubTypeDscr" not-null="true" length="30" />
<property column="BTCH_SRC_CD" type="String" name="BtchSrcCd" not-null="true" length="10" />
<property column="PARN_BTCH_ID" type="String" name="ParnBtchId" length="14" />
<property column="DOC_CAPT_DTS" type="DateTime" name="DocCaptDts" />
<property column="WRKF_IND" type="Decimal" name="WrkfInd" />

</class>

<class name="TableObjects.Oracle.BatchJobSetting,TableObjects.Oracle" table="BATCH_JOB_SETTING">

<id name="BtchJobId" column="BTCH_JOB_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BTCH_JOB_NAME" type="String" name="BtchJobName" not-null="true" length="60" />
<property column="BTCH_JOB_SCHD_DSCR" type="String" name="BtchJobSchdDscr" not-null="true" length="2147483647" />
<property column="BTCH_JOB_BLKO_IND" type="Decimal" name="BtchJobBlkoInd" not-null="true" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.BatchRcon,TableObjects.Oracle" table="BATCH_RCON">

<id name="BtchRconId" column="BTCH_RCON_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="LOC_CD" type="String" name="LocCd" not-null="true" length="10" />
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" not-null="true" />
<property column="RCON_TYPE_CD" type="String" name="RconTypeCd" not-null="true" length="10" />
<property column="BTCH_CNT" type="Decimal" name="BtchCnt" not-null="true" />
<property column="FLDR_CNT" type="Decimal" name="FldrCnt" not-null="true" />
<property column="DOC_CNT" type="Decimal" name="DocCnt" not-null="true" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />

</class>

<class name="TableObjects.Oracle.BotMonitorSetting,TableObjects.Oracle" table="BOT_MONITOR_SETTING">

<id name="BotId" column="BOT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BOT_DSCR" type="String" name="BotDscr" not-null="true" length="30" />
<property column="PG_TM_NBR" type="Decimal" name="PgTmNbr" not-null="true" />
<property column="MTOR_FILE_DSCR" type="String" name="MtorFileDscr" not-null="true" length="200" />
<property column="STAT_FILE_DSCR" type="String" name="StatFileDscr" not-null="true" length="200" />
<property column="STRT_TM_CD" type="String" name="StrtTmCd" length="4" />
<property column="END_TM_CD" type="String" name="EndTmCd" length="4" />
<property column="SRVR_DSCR" type="String" name="SrvrDscr" not-null="true" length="30" />
<property column="PGR_IND" type="Decimal" name="PgrInd" not-null="true" />
<property column="LNCH_IND" type="Decimal" name="LnchInd" not-null="true" />
<property column="BOT_EXEC_DSCR" type="String" name="BotExecDscr" not-null="true" length="30" />
<property column="BOT_QUE_ID" type="Decimal" name="BotQueId" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="REPT_PAGE_IND" type="Decimal" name="ReptPageInd" not-null="true" />
<property column="FAIL_UNIT_PAGE_IND" type="Decimal" name="FailUnitPageInd" not-null="true" />
<property column="FAIL_UNIT_LMT_NBR" type="Decimal" name="FailUnitLmtNbr" not-null="true" />
<property column="REPT_FAIL_UNIT_PAGE_IND" type="Decimal" name="ReptFailUnitPageInd" not-null="true" />
<property column="TCKT_IND" type="Decimal" name="TcktInd" not-null="true" />
<property column="TCKT_PRRY_NBR" type="Decimal" name="TcktPrryNbr" not-null="true" />
<property column="ESCL_PAGE_IND" type="Decimal" name="EsclPageInd" not-null="true" />
<property column="ESCL_PAGE_THRS_NBR" type="Decimal" name="EsclPageThrsNbr" not-null="true" />
<property column="ERR_THRS_NBR" type="Decimal" name="ErrThrsNbr" not-null="true" />
<property column="PGR_LOC_CD" type="String" name="PgrLocCd" length="2" />

</class>

<class name="TableObjects.Oracle.BotQueue,TableObjects.Oracle" table="BOT_QUEUE">

<composite-id>
<key-property column="BOT_ID" type="Decimal" name="BotId" />
<key-property column="QUE_ID" type="Decimal" name="QueId" />
</composite-id>
<property column="CREA_DTS" type="DateTime" name="CreaDts" />

</class>

<class name="TableObjects.Oracle.BotStatus,TableObjects.Oracle" table="BOT_STATUS">

<id name="BotStatId" column="BOT_STAT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="UNIT_PASS_NBR" type="Decimal" name="UnitPassNbr" />
<property column="UNIT_FAIL_NBR" type="Decimal" name="UnitFailNbr" />
<property column="MSG_CD" type="String" name="MsgCd" not-null="true" length="2" />
<property column="BOT_ID" type="Decimal" name="BotId" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="10" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.CaptivaActivity,TableObjects.Oracle" table="CAPTIVA_ACTIVITY">

<composite-id>
<key-property column="BTCH_ID" type="String" name="BtchId" length="14" />
<key-property column="DOC_ID" type="Decimal" name="DocId" />
</composite-id>
<property column="ACTY_DSCR" type="String" name="ActyDscr" not-null="true" length="30" />
<property column="USER_CD" type="String" name="UserCd" not-null="true" length="10" />
<property column="RSN_DICT_ID" type="Decimal" name="RsnDictId" />
<property column="RSN_DSCR" type="String" name="RsnDscr" length="2000" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />

</class>

<class name="TableObjects.Oracle.CaptivaCompletionHist,TableObjects.Oracle" table="CAPTIVA_COMPLETION_HIST">

<id name="CaptActySeqNbr" column="CAPT_ACTY_SEQ_NBR" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="JOB_NAME" type="String" name="JobName" length="60" />
<property column="FORM_NAME" type="String" name="FormName" length="60" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="USR_SRC_CD" type="String" name="UsrSrcCd" length="20" />
<property column="REC_DSCR" type="String" name="RecDscr" length="2147483647" />
<property column="CLAS_CD" type="String" name="ClasCd" length="4" />
<property column="EBLD_FLD_CNT" type="Decimal" name="EbldFldCnt" />
<property column="TRAN_SEC_NBR" type="Decimal" name="TranSecNbr" />
<property column="IMAG_ID" type="Decimal" name="ImagId" />
<property column="CMPL_DTS" type="DateTime" name="CmplDts" />

</class>

<class name="TableObjects.Oracle.CaptivaList,TableObjects.Oracle" table="CAPTIVA_LIST">

<id name="CptvListId" column="CPTV_LIST_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="LIST_DSCR" type="String" name="ListDscr" not-null="true" length="60" />
<property column="VAL_DSCR" type="String" name="ValDscr" length="250" />
<property column="LBL_DSCR" type="String" name="LblDscr" length="250" />
<property column="ACTV_IND" type="Decimal" name="ActvInd" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.CaptivaPrefillHistory,TableObjects.Oracle" table="CAPTIVA_PREFILL_HISTORY">

<id name="CaptPrflSeq" column="CAPT_PRFL_SEQ" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="SRC_IND" type="String" name="SrcInd" length="1" />
<property column="REC_DSCR" type="String" name="RecDscr" length="2147483647" />
<property column="INPT_SCTN_DSCR" type="String" name="InptSctnDscr" length="2147483647" />
<property column="INPT_SCTN" type="String" name="InptSctn" length="2147483647" />
<property column="CAPT_PRFL_SEQ_NBR" type="Decimal" name="CaptPrflSeqNbr" />

</class>

<class name="TableObjects.Oracle.CaptivaProperty,TableObjects.Oracle" table="CAPTIVA_PROPERTY">

<id name="CptvPropId" column="CPTV_PROP_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PROJ_DSCR" type="String" name="ProjDscr" not-null="true" length="30" />
<property column="JOB_DSCR" type="String" name="JobDscr" length="40" />
<property column="FORM_DSCR" type="String" name="FormDscr" length="40" />
<property column="FLD_DSCR" type="String" name="FldDscr" length="60" />
<property column="PROP_DSCR" type="String" name="PropDscr" not-null="true" length="60" />
<property column="VAL_DSCR" type="String" name="ValDscr" length="250" />
<property column="RULE_DSCR" type="String" name="RuleDscr" length="250" />
<property column="ACTV_IND" type="Decimal" name="ActvInd" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.CaptivaZone,TableObjects.Oracle" table="CAPTIVA_ZONE">

<id name="CptvZoneId" column="CPTV_ZONE_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="JOB_NAME" type="String" name="JobName" length="60" />
<property column="FORM_NAME" type="String" name="FormName" length="60" />
<property column="FIELD_NAME" type="String" name="FieldName" not-null="true" length="60" />
<property column="SEQ_NBR" type="Decimal" name="SeqNbr" not-null="true" />
<property column="RULE_DSCR" type="String" name="RuleDscr" length="120" />
<property column="ZONE_DSCR" type="String" name="ZoneDscr" not-null="true" length="30" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />

</class>

<class name="TableObjects.Oracle.ClassLetter,TableObjects.Oracle" table="CLASS_LETTER">

<id name="LttrCd" column="LTTR_CD" type="String">
<generator class="assigned"/>
</id>
<property column="CLAS_CD" type="String" name="ClasCd" not-null="true" length="4" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.ClassQueue,TableObjects.Oracle" table="CLASS_QUEUE">

<id name="ClassQueId" column="CLASS_QUE_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PRIOR_SSN" type="String" name="PriorSsn" length="9" />
<property column="CURR_SSN" type="String" name="CurrSsn" not-null="true" length="9" />
<property column="CALL_TYPE_CD" type="String" name="CallTypeCd" not-null="true" length="1" />
<property column="RECEIVED_DT" type="DateTime" name="ReceivedDt" not-null="true" />
<property column="USER_CD" type="String" name="UserCd" not-null="true" length="6" />
<property column="PREV_LTR_CD" type="String" name="PrevLtrCd" length="4" />
<property column="LTR_CD" type="String" name="LtrCd" not-null="true" length="4" />
<property column="CORR_CD" type="String" name="CorrCd" not-null="true" length="4" />
<property column="DOC_ID" type="String" name="DocId" not-null="true" length="10" />
<property column="MSG_DSCR" type="String" name="MsgDscr" length="2000" />
<property column="MSG_ID" type="String" name="MsgId" length="250" />
<property column="STAT_CD" type="Decimal" name="StatCd" />
<property column="ERR_DSCR" type="String" name="ErrDscr" length="250" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="10" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="SRC_CD" type="String" name="SrcCd" length="10" />
<property column="LOC_ABBR_CD" type="String" name="LocAbbrCd" length="2" />
<property column="SYS_OF_REC_CD" type="String" name="SysOfRecCd" length="10" />

</class>

<class name="TableObjects.Oracle.ClunidRcon,TableObjects.Oracle" table="CLUNID_RCON">

<composite-id>
<key-property column="CMLN_UNIQ_ID" type="String" name="CmlnUniqId" length="17" />
<key-property column="SYS_CD" type="String" name="SysCd" length="1" />
<key-property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<key-property column="APP_TYPE_CD" type="String" name="AppTypeCd" length="2" />
</composite-id>
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.CodeGeneration,TableObjects.Oracle" table="CODE_GENERATION">

<id name="CdGenId" column="CD_GEN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PRGM_ID" type="Decimal" name="PrgmId" not-null="true" />
<property column="TRAN_DSCR" type="String" name="TranDscr" not-null="true" length="30" />
<property column="TBL_NAME_DSCR" type="String" name="TblNameDscr" not-null="true" length="30" />
<property column="SEQ_NAME_DSCR" type="String" name="SeqNameDscr" length="30" />
<property column="SEQ_FLD_NAME_DSCR" type="String" name="SeqFldNameDscr" length="30" />
<property column="LIST_REC_SET_IND" type="Decimal" name="ListRecSetInd" not-null="true" />
<property column="SEQ_IND" type="Decimal" name="SeqInd" not-null="true" />
<property column="AUDT_TS_IND" type="Decimal" name="AudtTsInd" not-null="true" />
<property column="ADMN_TLB_IND" type="Decimal" name="AdmnTlbInd" not-null="true" />
<property column="OPMS_LOCK_IND" type="Decimal" name="OpmsLockInd" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="TEST_COL_NAME" type="String" name="TestColName" not-null="true" length="30" />
<property column="TEST_REC_SET_DSCR" type="String" name="TestRecSetDscr" length="4000" />

</class>

<class name="TableObjects.Oracle.CodeGenerationPk,TableObjects.Oracle" table="CODE_GENERATION_PK">

<id name="CdGenPkId" column="CD_GEN_PK_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="CD_GEN_ID" type="Decimal" name="CdGenId" not-null="true" />
<property column="PK_DSCR" type="String" name="PkDscr" not-null="true" length="30" />
<property column="REC_ORDR_IND" type="Decimal" name="RecOrdrInd" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.CommonlineCheckpoint,TableObjects.Oracle" table="COMMONLINE_CHECKPOINT">

<id name="CmlnCkptId" column="CMLN_CKPT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="CKPT_SYS_IND" type="String" name="CkptSysInd" not-null="true" length="1" />
<property column="CKPT_NBR" type="Decimal" name="CkptNbr" not-null="true" />
<property column="CKPT_IND" type="Decimal" name="CkptInd" not-null="true" />
<property column="MNL_NOTE_DSCR" type="String" name="MnlNoteDscr" length="2000" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.CommonlineHistory,TableObjects.Oracle" table="COMMONLINE_HISTORY">

<id name="CmlnHistId" column="CMLN_HIST_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="FLDR_ID" type="Decimal" name="FldrId" not-null="true" />
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="REC_TYPE_CD" type="String" name="RecTypeCd" not-null="true" length="2" />
<property column="REC_DSCR" type="String" name="RecDscr" not-null="true" length="2000" />
<property column="REC_ORDR_IND" type="Decimal" name="RecOrdrInd" not-null="true" />
<property column="SYS_CD" type="String" name="SysCd" not-null="true" length="1" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="STAT_CD" type="Decimal" name="StatCd" not-null="true" />
<property column="FILE_SEQ_NBR" type="Decimal" name="FileSeqNbr" not-null="true" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" not-null="true" length="9" />
<property column="CL_VER_CD" type="String" name="ClVerCd" length="4" />
<property column="CMLN_VER_CD" type="String" name="CmlnVerCd" length="4" />

</class>

<class name="TableObjects.Oracle.CommonlineQueue,TableObjects.Oracle" table="COMMONLINE_QUEUE">

<id name="CmlnHistId" column="CMLN_HIST_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="FLDR_ID" type="Decimal" name="FldrId" not-null="true" />
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="REC_TYPE_CD" type="String" name="RecTypeCd" not-null="true" length="2" />
<property column="REC_DSCR" type="String" name="RecDscr" not-null="true" length="2000" />
<property column="REC_ORDR_IND" type="Decimal" name="RecOrdrInd" not-null="true" />
<property column="SYS_CD" type="String" name="SysCd" not-null="true" length="1" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="STAT_CD" type="Decimal" name="StatCd" not-null="true" />
<property column="FILE_SEQ_NBR" type="Decimal" name="FileSeqNbr" not-null="true" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" not-null="true" length="9" />

</class>

<class name="TableObjects.Oracle.CommonlineResultsHistory,TableObjects.Oracle" table="COMMONLINE_RESULTS_HISTORY">

<id name="CmlnRsltId" column="CMLN_RSLT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PERS_EXT_ID" type="String" name="PersExtId" not-null="true" length="9" />
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="BTCH_SEQ_NBR" type="String" name="BtchSeqNbr" not-null="true" length="3" />
<property column="RSLT_HDR_DSCR" type="String" name="RsltHdrDscr" not-null="true" length="200" />
<property column="RSLT_DTL_DSCR" type="String" name="RsltDtlDscr" not-null="true" length="200" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.CommonlineTracking,TableObjects.Oracle" table="COMMONLINE_TRACKING">

<id name="DocId" column="DOC_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PERS_EXT_ID" type="String" name="PersExtId" not-null="true" length="9" />
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="BTCH_SEQ_NBR" type="String" name="BtchSeqNbr" not-null="true" length="3" />
<property column="TRF_DTS" type="DateTime" name="TrfDts" not-null="true" />
<property column="SUB_TYPE_DSCR" type="String" name="SubTypeDscr" length="30" />
<property column="USER_SYS_IND" type="String" name="UserSysInd" length="1" />
<property column="LKUP_SYS_IND" type="String" name="LkupSysInd" length="1" />
<property column="ACKN_SYS_IND" type="String" name="AcknSysInd" length="1" />
<property column="LN_ID" type="String" name="LnId" length="10" />
<property column="PROM_NOTE_ID" type="String" name="PromNoteId" length="10" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="CAPT_DEPT_TYPE" type="String" name="CaptDeptType" length="30" />

</class>

<class name="TableObjects.Oracle.CommonServiceSetting,TableObjects.Oracle" table="COMMON_SERVICE_SETTING">

<id name="CmnSrvcId" column="CMN_SRVC_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="WORK_STTN_DSCR" type="String" name="WorkSttnDscr" not-null="true" length="30" />
<property column="BOT_TYPE_DSCR" type="String" name="BotTypeDscr" not-null="true" length="30" />
<property column="STAT_DSCR" type="String" name="StatDscr" not-null="true" length="30" />
<property column="UNIT_PASS_NBR" type="Decimal" name="UnitPassNbr" />
<property column="UNIT_FAIL_NBR" type="Decimal" name="UnitFailNbr" />
<property column="SLEP_TM" type="Decimal" name="SlepTm" />
<property column="ALRM_TM" type="Decimal" name="AlrmTm" />
<property column="ALRM_IND" type="Decimal" name="AlrmInd" />
<property column="AUTO_LGOF_IND" type="Decimal" name="AutoLgofInd" not-null="true" />
<property column="ACTV_IND" type="Decimal" name="ActvInd" not-null="true" />
<property column="STRT_DTS" type="DateTime" name="StrtDts" not-null="true" />
<property column="END_DTS" type="DateTime" name="EndDts" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.CorrTypeOverride,TableObjects.Oracle" table="CORR_TYPE_OVERRIDE">

<id name="CorrTypeOvrdId" column="CORR_TYPE_OVRD_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="DEPT_ID" type="Decimal" name="DeptId" not-null="true" />
<property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" not-null="true" />
<property column="DFLT_CORR_TYPE_CD" type="String" name="DfltCorrTypeCd" not-null="true" length="10" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" not-null="true" />

</class>

<class name="TableObjects.Oracle.CustomTransactionInfo,TableObjects.Oracle" table="CUSTOM_TRANSACTION_INFO">

<id name="CstmTranId" column="CSTM_TRAN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PRGM_ID" type="Decimal" name="PrgmId" not-null="true" />
<property column="PROC_DSCR" type="String" name="ProcDscr" not-null="true" length="30" />
<property column="PROC_DATA_DSCR" type="byte[]" name="ProcDataDscr" not-null="true" />
<property column="PROC_CALL_DSCR" type="String" name="ProcCallDscr" not-null="true" length="4000" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.DnrData,TableObjects.Oracle" table="DNR_DATA">

<id name="DnrDataId" column="DNR_DATA_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="REC_TYPE_CD" type="String" name="RecTypeCd" length="2" />
<property column="LN_RQST_ID" type="String" name="LnRqstId" length="10" />
<property column="ED_LN_SEQ_NBR" type="Decimal" name="EdLnSeqNbr" />
<property column="EAGL_SYS_CD" type="String" name="EaglSysCd" length="2" />
<property column="FORM_VER_CD" type="String" name="FormVerCd" length="5" />
<property column="FORM_CLAS_CD" type="String" name="FormClasCd" length="4" />
<property column="ED_LN_PRGM_CD" type="String" name="EdLnPrgmCd" length="4" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="BORR_NAME" type="String" name="BorrName" length="32" />
<property column="LN_SRVC_WRHS_IND" type="Decimal" name="LnSrvcWrhsInd" />
<property column="LN_AMT" type="Decimal" name="LnAmt" />
<property column="RUN_DT" type="DateTime" name="RunDt" />
<property column="LNDR_ID" type="String" name="LndrId" length="6" />
<property column="SCHL_ID" type="String" name="SchlId" length="8" />
<property column="DNR_PKT_TYPE_CD" type="String" name="DnrPktTypeCd" length="10" />
<property column="IMAG_IND" type="Decimal" name="ImagInd" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="LNDR_PKT_ID" type="Decimal" name="LndrPktId" not-null="true" />

</class>

<class name="TableObjects.Oracle.DocEntrySummary,TableObjects.Oracle" table="DOC_ENTRY_SUMMARY">

<composite-id>
<key-property column="YR" type="Decimal" name="Yr" />
<key-property column="MO" type="Decimal" name="Mo" />
<key-property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" />
</composite-id>
<property column="DOC_RCVE_CNT" type="Decimal" name="DocRcveCnt" />
<property column="DOC_PRCS_CNT" type="Decimal" name="DocPrcsCnt" />
<property column="FLDR_RCVE_CNT" type="Decimal" name="FldrRcveCnt" />
<property column="FLDR_PRCS_CNT" type="Decimal" name="FldrPrcsCnt" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.DocumentComment,TableObjects.Oracle" table="DOCUMENT_COMMENT">

<id name="DocId" column="DOC_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="FLDR_ID" type="Decimal" name="FldrId" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="CMNT_DSCR" type="String" name="CmntDscr" length="2000" />
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="DOC_SEQ_NBR" type="Decimal" name="DocSeqNbr" not-null="true" />
<property column="DOC_NAME" type="String" name="DocName" not-null="true" length="30" />
<property column="BARC_DSCR" type="String" name="BarcDscr" length="255" />
<property column="CIN" type="String" name="Cin" length="10" />

</class>

<class name="TableObjects.Oracle.DocumentHistory,TableObjects.Oracle" table="DOCUMENT_HISTORY">

<id name="TranId" column="TRAN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" not-null="true" length="30" />
<property column="TRA
Top
 Profile  
 
frapper35
 Post subject:
PostPosted: Mon May 21, 2007 3:47 pm 
Newbie

Joined: Mon May 21, 2007 3:14 pm
Posts: 14
Just noticed that my post got cut off. Here is the rest of that file:
N_QUE_DSCR" type="String" name="TranQueDscr" not-null="true" length="30" />
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="DOC_TYPE_DSCR" type="String" name="DocTypeDscr" not-null="true" length="30" />
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="FLDR_ID" type="Decimal" name="FldrId" not-null="true" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="SCAN_ENDR_DSCR" type="String" name="ScanEndrDscr" length="30" />
<property column="SUB_TYPE_DSCR" type="String" name="SubTypeDscr" not-null="true" length="30" />
<property column="DSPN_CD" type="String" name="DspnCd" length="10" />
<property column="BARC_DSCR" type="String" name="BarcDscr" length="255" />
<property column="CORR_TYPE_CD" type="String" name="CorrTypeCd" length="10" />
<property column="SYS_OF_REC_CD" type="String" name="SysOfRecCd" length="10" />
<property column="CIN" type="String" name="Cin" length="10" />

</class>

<class name="TableObjects.Oracle.ErrorLog,TableObjects.Oracle" table="ERROR_LOG">

<id name="ErrId" column="ERR_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="ERR_DTS" type="DateTime" name="ErrDts" not-null="true" />
<property column="ERR_NBR" type="Decimal" name="ErrNbr" not-null="true" />
<property column="ERR_DSCR" type="String" name="ErrDscr" not-null="true" length="2000" />
<property column="ERR_CMNT_DSCR" type="String" name="ErrCmntDscr" not-null="true" length="2000" />
<property column="ERR_USER_CD" type="String" name="ErrUserCd" not-null="true" length="10" />
<property column="ERR_WORK_STTN_DSCR" type="String" name="ErrWorkSttnDscr" not-null="true" length="30" />
<property column="ERR_MODL_DSCR" type="String" name="ErrModlDscr" not-null="true" length="30" />
<property column="ERR_FCTN_DSCR" type="String" name="ErrFctnDscr" not-null="true" length="30" />
<property column="ERR_CALL_STAC_DSCR" type="String" name="ErrCallStacDscr" not-null="true" length="2000" />
<property column="SQL_STMT_DSCR" type="String" name="SqlStmtDscr" length="2000" />

</class>

<class name="TableObjects.Oracle.ErrorMsg,TableObjects.Oracle" table="ERROR_MSG">

<id name="ErrMsgId" column="ERR_MSG_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="ERR_MSG_DSCR" type="String" name="ErrMsgDscr" not-null="true" length="250" />
<property column="ERR_DSPLY_DSCR" type="String" name="ErrDsplyDscr" not-null="true" length="2000" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="ERR_CD" type="String" name="ErrCd" length="10" />
<property column="ERR_SRC_DSCR" type="String" name="ErrSrcDscr" length="30" />

</class>

<class name="TableObjects.Oracle.ExtlDocTypeCvsn,TableObjects.Oracle" table="EXTL_DOC_TYPE_CVSN">

<id name="ExtlDocTypeCvsnId" column="EXTL_DOC_TYPE_CVSN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="EXTL_DOC_TYPE_DSCR" type="String" name="ExtlDocTypeDscr" not-null="true" length="30" />
<property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" not-null="true" />
<property column="DEPT_ID" type="Decimal" name="DeptId" not-null="true" />
<property column="BTCH_RTE_ID" type="Decimal" name="BtchRteId" not-null="true" />
<property column="FLDR_RTE_ID" type="Decimal" name="FldrRteId" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="LNDR_DSCR" type="String" name="LndrDscr" length="30" />
<property column="WRKF_IND" type="Decimal" name="WrkfInd" not-null="true" />

</class>

<class name="TableObjects.Oracle.Fax,TableObjects.Oracle" table="FAX">

<id name="FaxId" column="FAX_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="FAX_CD" type="String" name="FaxCd" length="10" />
<property column="FAX_DSCR" type="String" name="FaxDscr" length="30" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.FaxBotDetail,TableObjects.Oracle" table="FAX_BOT_DETAIL">

<composite-id>
<key-property column="BES_DSCR" type="String" name="BesDscr" length="30" />
<key-property column="FAX_BTCH_ID" type="String" name="FaxBtchId" length="14" />
</composite-id>
<property column="ACTN_CD" type="String" name="ActnCd" not-null="true" length="10" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />
<property column="FAX_SRVR_DSCR" type="String" name="FaxSrvrDscr" not-null="true" length="20" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" not-null="true" />
<property column="DEL_PG_CNT" type="Decimal" name="DelPgCnt" not-null="true" />
<property column="LOC_CD" type="String" name="LocCd" not-null="true" length="10" />
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="FAX_UNIQ_ID" type="String" name="FaxUniqId" length="15" />

</class>

<class name="TableObjects.Oracle.FaxMigration,TableObjects.Oracle" table="FAX_MIGRATION">

<id name="TranId" column="TRAN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BES_DSCR" type="String" name="BesDscr" not-null="true" length="30" />
<property column="FAX_BTCH_ID" type="String" name="FaxBtchId" not-null="true" length="14" />
<property column="MIGR_DTS" type="DateTime" name="MigrDts" not-null="true" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />
<property column="FAX_SRVR_DSCR" type="String" name="FaxSrvrDscr" not-null="true" length="20" />
<property column="LOC_CD" type="String" name="LocCd" not-null="true" length="10" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="STAT_DSCR" type="String" name="StatDscr" not-null="true" length="30" />
<property column="CSI_DSCR" type="String" name="CsiDscr" length="20" />
<property column="DNIS_CD" type="String" name="DnisCd" length="20" />
<property column="JOB_ID" type="String" name="JobId" length="10" />
<property column="FAX_UNIQ_ID" type="String" name="FaxUniqId" length="15" />

</class>

<class name="TableObjects.Oracle.FaxQueue,TableObjects.Oracle" table="FAX_QUEUE">

<id name="FaxTeleNbr" column="FAX_TELE_NBR" type="String">
<generator class="assigned"/>
</id>
<property column="DEST_QUE_ID" type="Decimal" name="DestQueId" not-null="true" />
<property column="PRRY_OVRR_NBR" type="Decimal" name="PrryOvrrNbr" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" not-null="true" />
<property column="DEPT_ID" type="Decimal" name="DeptId" not-null="true" />

</class>

<class name="TableObjects.Oracle.FaxReceipt,TableObjects.Oracle" table="FAX_RECEIPT">

<composite-id>
<key-property column="FAX_SRVR_DSCR" type="String" name="FaxSrvrDscr" length="20" />
<key-property column="FAX_ID" type="Decimal" name="FaxId" />
</composite-id>
<property column="RCVE_DT" type="DateTime" name="RcveDt" not-null="true" />
<property column="FAX_DTS" type="DateTime" name="FaxDts" not-null="true" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />
<property column="STAT_DSCR" type="String" name="StatDscr" not-null="true" length="30" />
<property column="ERR_CNT" type="Decimal" name="ErrCnt" not-null="true" />
<property column="LOC_CD" type="String" name="LocCd" not-null="true" length="10" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="CSI_DSCR" type="String" name="CsiDscr" length="20" />
<property column="DNIS_CD" type="String" name="DnisCd" length="20" />
<property column="FAX_UNIQ_ID" type="String" name="FaxUniqId" length="15" />

</class>

<class name="TableObjects.Oracle.FolderIndexData,TableObjects.Oracle" table="FOLDER_INDEX_DATA">

<id name="FldrId" column="FLDR_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="FLDR_TYPE_ID" type="Decimal" name="FldrTypeId" />
<property column="DEPT_ID" type="Decimal" name="DeptId" />
<property column="FLDR_RTE_CD" type="String" name="FldrRteCd" length="10" />
<property column="WRKF_IND" type="Decimal" name="WrkfInd" not-null="true" />
<property column="FLDR_CMNT_DSCR" type="String" name="FldrCmntDscr" length="2000" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="FLDR_SEQ_NBR" type="Decimal" name="FldrSeqNbr" not-null="true" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="RJCT_IND" type="Decimal" name="RjctInd" />
<property column="RJCT_RSN_DSCR" type="String" name="RjctRsnDscr" length="2000" />
<property column="RJCT_RSN_CD" type="String" name="RjctRsnCd" length="10" />
<property column="TRAN_CNT" type="Decimal" name="TranCnt" />

</class>

<class name="TableObjects.Oracle.FolderRcon,TableObjects.Oracle" table="FOLDER_RCON">

<id name="FldrRconId" column="FLDR_RCON_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="FLDR_ID" type="Decimal" name="FldrId" not-null="true" />
<property column="RCVE_DTS" type="DateTime" name="RcveDts" not-null="true" />
<property column="DEPT_ID" type="Decimal" name="DeptId" not-null="true" />
<property column="RCON_TYPE_CD" type="String" name="RconTypeCd" not-null="true" length="10" />
<property column="FLDR_CNT" type="Decimal" name="FldrCnt" not-null="true" />
<property column="DOC_CNT" type="Decimal" name="DocCnt" not-null="true" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />

</class>

<class name="TableObjects.Oracle.FolderRoute,TableObjects.Oracle" table="FOLDER_ROUTE">

<id name="FldrRteId" column="FLDR_RTE_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="DEPT_ID" type="Decimal" name="DeptId" not-null="true" />
<property column="QUE_ID" type="Decimal" name="QueId" not-null="true" />
<property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" not-null="true" />
<property column="RTE_CD" type="String" name="RteCd" length="10" />
<property column="SRC_CD" type="String" name="SrcCd" length="10" />
<property column="PRRY_OVRR_NBR" type="Decimal" name="PrryOvrrNbr" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.FunctionItem,TableObjects.Oracle" table="FUNCTION_ITEM">

<id name="FctnId" column="FCTN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="FCTN_FORM_DSCR" type="String" name="FctnFormDscr" length="30" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="FCTN_CNTL_DSCR" type="String" name="FctnCntlDscr" length="30" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.GroupFunctionItem,TableObjects.Oracle" table="GROUP_FUNCTION_ITEM">

<composite-id>
<key-property column="GRP_ID" type="Decimal" name="GrpId" />
<key-property column="FCTN_ID" type="Decimal" name="FctnId" />
</composite-id>

</class>

<class name="TableObjects.Oracle.GroupInfo,TableObjects.Oracle" table="GROUP_INFO">

<id name="GrpId" column="GRP_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="GRP_DSCR" type="String" name="GrpDscr" not-null="true" length="30" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.GroupMenuItem,TableObjects.Oracle" table="GROUP_MENU_ITEM">

<composite-id>
<key-property column="GRP_ID" type="Decimal" name="GrpId" />
<key-property column="MENU_ID" type="Decimal" name="MenuId" />
</composite-id>

</class>

<class name="TableObjects.Oracle.GroupQueue,TableObjects.Oracle" table="GROUP_QUEUE">

<composite-id>
<key-property column="GRP_ID" type="Decimal" name="GrpId" />
<key-property column="QUE_ID" type="Decimal" name="QueId" />
</composite-id>

</class>

<class name="TableObjects.Oracle.GroupReport,TableObjects.Oracle" table="GROUP_REPORT">

<composite-id>
<key-property column="GRP_ID" type="Decimal" name="GrpId" />
<key-property column="RPT_ID" type="Decimal" name="RptId" />
</composite-id>

</class>

<class name="TableObjects.Oracle.GroupRibbon,TableObjects.Oracle" table="GROUP_RIBBON">

<composite-id>
<key-property column="GRP_ID" type="Decimal" name="GrpId" />
<key-property column="RBBN_ID" type="Decimal" name="RbbnId" />
</composite-id>

</class>

<class name="TableObjects.Oracle.GroupUser,TableObjects.Oracle" table="GROUP_USER">

<composite-id>
<key-property column="GRP_ID" type="Decimal" name="GrpId" />
<key-property column="USER_CD" type="String" name="UserCd" length="10" />
</composite-id>
<property column="SCTY_USER_DSCR" type="String" name="SctyUserDscr" not-null="true" length="250" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.GuarChkPnt,TableObjects.Oracle" table="GUAR_CHK_PNT">

<id name="ChkPntId" column="CHK_PNT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="APP_NM" type="String" name="AppNm" length="32" />
<property column="PRCS_STEP_NM" type="String" name="PrcsStepNm" length="32" />
<property column="APP_MODE_DSCR" type="String" name="AppModeDscr" length="32" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" not-null="true" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="REC_TYPE_CD" type="String" name="RecTypeCd" length="16" />
<property column="CSR_FTCH_CNT" type="Decimal" name="CsrFtchCnt" />
<property column="CHK_STOP_MAX_NBR" type="Decimal" name="ChkStopMaxNbr" />
<property column="CHK_PNT_MAX_NBR" type="Decimal" name="ChkPntMaxNbr" />
<property column="TRKG_ID" type="String" name="TrkgId" length="32" />
<property column="TRAN_CMNT_TXT" type="String" name="TranCmntTxt" length="1024" />

</class>

<class name="TableObjects.Oracle.GuarDoc,TableObjects.Oracle" table="GUAR_DOC">

<id name="GuarDocId" column="GUAR_DOC_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="DEPT_CD" type="String" name="DeptCd" not-null="true" length="10" />
<property column="ENTR_DT_CNT" type="Decimal" name="EntrDtCnt" not-null="true" />
<property column="LOC_CD" type="String" name="LocCd" not-null="true" length="2" />
<property column="DOC_CLAS_ID" type="Decimal" name="DocClasId" not-null="true" />
<property column="FORM_CLAS_CD" type="String" name="FormClasCd" length="10" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" not-null="true" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" length="20" />
<property column="STAT_CHNG_DT" type="DateTime" name="StatChngDt" />
<property column="STAT_CD" type="String" name="StatCd" length="4" />

</class>

<class name="TableObjects.Oracle.GuarDocSysId,TableObjects.Oracle" table="GUAR_DOC_SYS_ID">

<composite-id>
<key-property column="SYS_ID" type="String" name="SysId" length="6" />
<key-property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
</composite-id>
<property column="GUAR_CD" type="String" name="GuarCd" length="2" />
<property column="UPD_GUAR_CD" type="String" name="UpdGuarCd" length="2" />
<property column="GUAR_INRT_DTS" type="DateTime" name="GuarInrtDts" not-null="true" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" length="20" />
<property column="STAT_CHNG_DT" type="DateTime" name="StatChngDt" />
<property column="STAT_CD" type="String" name="StatCd" length="4" />

</class>

<class name="TableObjects.Oracle.GuarErrLog,TableObjects.Oracle" table="GUAR_ERR_LOG">

<id name="GuarErrId" column="GUAR_ERR_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="ITEM_ID" type="String" name="ItemId" length="32" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" not-null="true" />
<property column="APP_NM" type="String" name="AppNm" length="32" />
<property column="APP_MTHD_NM" type="String" name="AppMthdNm" length="64" />
<property column="ERR_TYPE_CD" type="String" name="ErrTypeCd" length="1" />
<property column="ERR_STAT_CD" type="String" name="ErrStatCd" length="4" />
<property column="ERR_LVL_CD" type="String" name="ErrLvlCd" length="5" />
<property column="ERR_CD" type="Decimal" name="ErrCd" />
<property column="ERR_MSG_TXT" type="String" name="ErrMsgTxt" length="256" />
<property column="ASSC_ID" type="Decimal" name="AsscId" />

</class>

<class name="TableObjects.Oracle.ImageImportHistory,TableObjects.Oracle" table="IMAGE_IMPORT_HISTORY">

<id name="TranId" column="TRAN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="RCVE_DT" type="DateTime" name="RcveDt" not-null="true" />
<property column="STAT_DICT_ID" type="Decimal" name="StatDictId" not-null="true" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" not-null="true" length="9" />
<property column="EXTL_DOC_TYPE_CVSN_ID" type="Decimal" name="ExtlDocTypeCvsnId" />
<property column="EXTL_DOC_DSCR" type="String" name="ExtlDocDscr" length="30" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />
<property column="LNDR_DSCR" type="String" name="LndrDscr" not-null="true" length="30" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="BTCH_ID" type="String" name="BtchId" length="14" />
<property column="EXTL_BTCH_ID" type="String" name="ExtlBtchId" length="16" />
<property column="EXTL_DOC_ID" type="String" name="ExtlDocId" length="255" />
<property column="EXTL_BTCH_EXPO_DT" type="DateTime" name="ExtlBtchExpoDt" />

</class>

<class name="TableObjects.Oracle.ImageImportRecon,TableObjects.Oracle" table="IMAGE_IMPORT_RECON">

<id name="ImagImptSeqNbr" column="IMAG_IMPT_SEQ_NBR" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="IMPT_BTCH_ID" type="String" name="ImptBtchId" not-null="true" length="8" />
<property column="BTCH_BOX_ID" type="String" name="BtchBoxId" length="30" />
<property column="IMPT_DOC_ID" type="String" name="ImptDocId" not-null="true" length="12" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />
<property column="STAT_CD" type="String" name="StatCd" length="20" />
<property column="RCON_RUN_DT" type="DateTime" name="RconRunDt" />
<property column="BTCH_EXPO_DT" type="DateTime" name="BtchExpoDt" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" not-null="true" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="SNDR_DSCR" type="String" name="SndrDscr" not-null="true" length="50" />

</class>

<class name="TableObjects.Oracle.LenderPacket,TableObjects.Oracle" table="LENDER_PACKET">

<id name="LndrPktId" column="LNDR_PKT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="LNDR_PKT_DT" type="DateTime" name="LndrPktDt" not-null="true" />
<property column="LNDR_PKT_PRCS_STAT_CD" type="String" name="LndrPktPrcsStatCd" length="40" />
<property column="NOG_CREA_DTS" type="DateTime" name="NogCreaDts" />
<property column="NOG_LINE_NBR" type="Decimal" name="NogLineNbr" />
<property column="NOG_DOC_NBR" type="Decimal" name="NogDocNbr" />
<property column="NOG_PAGE_NBR" type="Decimal" name="NogPageNbr" />
<property column="NOG_HASH_TOT_NBR" type="Decimal" name="NogHashTotNbr" />
<property column="HIST_SUM_CREA_DTS" type="DateTime" name="HistSumCreaDts" />
<property column="HIST_SUM_LINE_NBR" type="Decimal" name="HistSumLineNbr" />
<property column="HIST_SUM_DOC_NBR" type="Decimal" name="HistSumDocNbr" />
<property column="HIST_SUM_PAGE_NBR" type="Decimal" name="HistSumPageNbr" />
<property column="HIST_SUM_HASH_TOT_NBR" type="Decimal" name="HistSumHashTotNbr" />
<property column="DNR_CREA_DTS" type="DateTime" name="DnrCreaDts" />
<property column="DNR_LINE_NBR" type="Decimal" name="DnrLineNbr" />
<property column="DNR_DOC_NBR" type="Decimal" name="DnrDocNbr" />
<property column="DNR_PAGE_NBR" type="Decimal" name="DnrPageNbr" />
<property column="DNR_HASH_TOT_NBR" type="Decimal" name="DnrHashTotNbr" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="RUN_NBR" type="Decimal" name="RunNbr" />
<property column="HIST_SUM_NOG_CNT" type="Decimal" name="HistSumNogCnt" />
<property column="RUN_TYPE_CD" type="String" name="RunTypeCd" length="3" />
<property column="NOG_DSCL_DT" type="DateTime" name="NogDsclDt" />

</class>

<class name="TableObjects.Oracle.LenderParm,TableObjects.Oracle" table="LENDER_PARM">

<id name="LndrParmId" column="LNDR_PARM_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="LNDR_ID" type="String" name="LndrId" not-null="true" length="6" />
<property column="PKT_TYPE_CD" type="String" name="PktTypeCd" not-null="true" length="3" />
<property column="PKT_SUB_TYPE_CD" type="String" name="PktSubTypeCd" not-null="true" length="5" />
<property column="LS_WRHS_OVRR_IND" type="Decimal" name="LsWrhsOvrrInd" not-null="true" />
<property column="DROP_IND" type="Decimal" name="DropInd" not-null="true" />
<property column="NOG_OVRR_NBR" type="Decimal" name="NogOvrrNbr" not-null="true" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="APPS_NBR" type="Decimal" name="AppsNbr" />

</class>

<class name="TableObjects.Oracle.LightsOutQueue,TableObjects.Oracle" table="LIGHTS_OUT_QUEUE">

<id name="LghtOutQueId" column="LGHT_OUT_QUE_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PERS_EXT_ID" type="String" name="PersExtId" not-null="true" length="9" />
<property column="ACCT_SFX_CD" type="String" name="AcctSfxCd" length="1" />
<property column="CORS_MAIL_VAL_CD" type="String" name="CorsMailValCd" length="8" />
<property column="LSC_CD" type="String" name="LscCd" length="2" />
<property column="CLAS_CD" type="String" name="ClasCd" not-null="true" length="4" />
<property column="DOC_ID" type="Decimal" name="DocId" />
<property column="CLAS_WRT_DTS" type="DateTime" name="ClasWrtDts" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.ListRecordset,TableObjects.Oracle" table="LIST_RECORDSET">

<id name="ListRecSetId" column="LIST_REC_SET_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="LIST_REC_SET_DSCR" type="String" name="ListRecSetDscr" not-null="true" length="30" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="TBL_NAME_DSCR" type="String" name="TblNameDscr" not-null="true" length="30" />
<property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" not-null="true" length="30" />
<property column="LIST_ENUM_IND" type="Decimal" name="ListEnumInd" not-null="true" />
<property column="DICT_ENUM_IND" type="Decimal" name="DictEnumInd" not-null="true" />
<property column="RPT_ENUM_IND" type="Decimal" name="RptEnumInd" not-null="true" />
<property column="ENUM_DSCR" type="String" name="EnumDscr" length="30" />
<property column="ENUM_NBR" type="Decimal" name="EnumNbr" />
<property column="FLD_LIST_DSCR" type="String" name="FldListDscr" not-null="true" length="250" />
<property column="GRP_LIST_DSCR" type="String" name="GrpListDscr" length="250" />
<property column="ORDR_LIST_DSCR" type="String" name="OrdrListDscr" length="250" />
<property column="MAX_ROW_CNT" type="Decimal" name="MaxRowCnt" not-null="true" />
<property column="CNFG_DSCR" type="String" name="CnfgDscr" length="250" />

</class>

<class name="TableObjects.Oracle.LoanConsRouting,TableObjects.Oracle" table="LOAN_CONS_ROUTING">

<id name="LoanConsRoutId" column="LOAN_CONS_ROUT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="GTHR_DOCS_IND" type="Decimal" name="GthrDocsInd" not-null="true" />
<property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" not-null="true" />
<property column="DEST_QUE_ID" type="Decimal" name="DestQueId" not-null="true" />
<property column="LOAN_CONS_STAT_CD" type="String" name="LoanConsStatCd" length="10" />
<property column="LOAN_CONS_RSN_CD" type="String" name="LoanConsRsnCd" length="30" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.MenuItem,TableObjects.Oracle" table="MENU_ITEM">

<id name="MenuId" column="MENU_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="MENU_FORM_DSCR" type="String" name="MenuFormDscr" length="30" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="MENU_CNTL_DSCR" type="String" name="MenuCntlDscr" length="30" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.MultiDealId,TableObjects.Oracle" table="MULTI_DEAL_ID">

<composite-id>
<key-property column="DOC_ID" type="Decimal" name="DocId" />
<key-property column="DEAL_ID" type="String" name="DealId" length="20" />
<key-property column="BTCH_ID" type="String" name="BtchId" length="14" />
</composite-id>
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.OpexJobCvsn,TableObjects.Oracle" table="OPEX_JOB_CVSN">

<composite-id>
<key-property column="OPEX_JOB_DSCR" type="String" name="OpexJobDscr" length="80" />
<key-property column="SNDR_DSCR" type="String" name="SndrDscr" length="50" />
</composite-id>
<property column="DEPT_ID" type="Decimal" name="DeptId" not-null="true" />
<property column="WRKF_IND" type="Decimal" name="WrkfInd" not-null="true" />
<property column="BTCH_RTE_ID" type="Decimal" name="BtchRteId" not-null="true" />
<property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" not-null="true" />
<property column="FLDR_RTE_ID" type="Decimal" name="FldrRteId" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />

</class>

<class name="TableObjects.Oracle.PacketPrintItem,TableObjects.Oracle" table="PACKET_PRINT_ITEM">

<id name="PktItemId" column="PKT_ITEM_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="LNDR_PKT_ID" type="Decimal" name="LndrPktId" not-null="true" />
<property column="DOC_ID" type="Decimal" name="DocId" />
<property column="PKT_DOC_CLAS_CD" type="String" name="PktDocClasCd" length="10" />
<property column="PKT_PRCS_STAT_CD" type="String" name="PktPrcsStatCd" length="10" />
<property column="LN_RQST_ID" type="String" name="LnRqstId" not-null="true" length="10" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="LNDR_ID" type="String" name="LndrId" length="6" />
<property column="EDUC_LN_SEQ_NBR" type="Decimal" name="EducLnSeqNbr" />
<property column="COPY_NBR" type="Decimal" name="CopyNbr" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="BORR_NAME" type="String" name="BorrName" length="32" />
<property column="LBL_ID" type="String" name="LblId" length="26" />
<property column="PROM_NOTE_ID" type="String" name="PromNoteId" length="10" />

</class>

<class name="TableObjects.Oracle.PersExtXref,TableObjects.Oracle" table="PERS_EXT_XREF">

<composite-id>
<key-property column="FLDR_ID" type="Decimal" name="FldrId" />
<key-property column="DOC_ID" type="Decimal" name="DocId" />
<key-property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
</composite-id>
<property column="BORR_STAT_CD" type="String" name="BorrStatCd" length="10" />
<property column="ABBR_LAST_NAME" type="String" name="AbbrLastName" length="4" />
<property column="BTCH_ID" type="String" name="BtchId" length="14" />
<property column="SYS_OF_REC_CD" type="String" name="SysOfRecCd" length="10" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="CORR_TYPE_CD" type="String" name="CorrTypeCd" length="10" />

</class>

<class name="TableObjects.Oracle.PrntPktHistory,TableObjects.Oracle" table="PRNT_PKT_HISTORY">

<id name="PrntPktId" column="PRNT_PKT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" not-null="true" length="9" />
<property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" length="30" />
<property column="DSPS_CD" type="String" name="DspsCd" length="10" />
<property column="RUN_DT" type="DateTime" name="RunDt" not-null="true" />
<property column="SRC_DSCR" type="String" name="SrcDscr" length="20" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.ProductivityDetailHist,TableObjects.Oracle" table="PRODUCTIVITY_DETAIL_HIST">

<composite-id>
<key-property column="USER_CD" type="String" name="UserCd" length="10" />
<key-property column="MNFM_QUE_DSCR" type="String" name="MnfmQueDscr" length="255" />
<key-property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<key-property column="STRT_DTS" type="DateTime" name="StrtDts" />
</composite-id>
<property column="LN_RQST_ID" type="String" name="LnRqstId" not-null="true" length="20" />
<property column="END_DTS" type="DateTime" name="EndDts" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="ADTL_QUE_DSCR" type="String" name="AdtlQueDscr" length="20" />
<property column="ADTL_STAT_CD" type="String" name="AdtlStatCd" length="20" />
<property column="PRCS_CNTR_ID" type="String" name="PrcsCntrId" length="8" />
<property column="CNTC_CD" type="String" name="CntcCd" length="8" />

</class>

<class name="TableObjects.Oracle.ProgramInfo,TableObjects.Oracle" table="PROGRAM_INFO">

<id name="PrgmId" column="PRGM_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PRGM_DSCR" type="String" name="PrgmDscr" not-null="true" length="30" />
<property column="PRGM_RLTV_PATH_DSCR" type="String" name="PrgmRltvPathDscr" not-null="true" length="200" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.QcHistoryDetail,TableObjects.Oracle" table="QC_HISTORY_DETAIL">

<id name="TranId" column="TRAN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" not-null="true" length="30" />
<property column="OPER_USER_CD" type="String" name="OperUserCd" not-null="true" length="10" />
<property column="QC_USER_CD" type="String" name="QcUserCd" not-null="true" length="10" />
<property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" not-null="true" />
<property column="RSN_CD" type="String" name="RsnCd" not-null="true" length="10" />
<property column="RSN_DSCR" type="String" name="RsnDscr" not-null="true" length="2000" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />

</class>

<class name="TableObjects.Oracle.QcHistorySummary,TableObjects.Oracle" table="QC_HISTORY_SUMMARY">

<composite-id>
<key-property column="YR" type="Decimal" name="Yr" />
<key-property column="MO" type="Decimal" name="Mo" />
<key-property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" />
<key-property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" length="30" />
<key-property column="OPER_USER_CD" type="String" name="OperUserCd" length="10" />
</composite-id>
<property column="TOT_CNT" type="Decimal" name="TotCnt" />
<property column="ERR_CNT" type="Decimal" name="ErrCnt" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />

</class>

<class name="TableObjects.Oracle.QcIndexData,TableObjects.Oracle" table="QC_INDEX_DATA">

<id name="DocId" column="DOC_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="APPL_ID" type="String" name="ApplId" length="10" />
<property column="ABBR_LAST_NAME" type="String" name="AbbrLastName" length="4" />
<property column="DEAL_ID" type="String" name="DealId" length="10" />
<property column="DEPT_CD" type="String" name="DeptCd" length="10" />
<property column="DOC_TYPE_DSCR" type="String" name="DocTypeDscr" length="30" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" />
<property column="EAGL_SYS_CD" type="String" name="EaglSysCd" length="10" />
<property column="FLDR_ID" type="Decimal" name="FldrId" not-null="true" />
<property column="CLAS_CD" type="String" name="ClasCd" not-null="true" length="10" />
<property column="IMDOC_ID" type="String" name="ImdocId" length="12" />
<property column="LNDR_ID" type="String" name="LndrId" length="6" />
<property column="LN_RQST_ID" type="String" name="LnRqstId" length="10" />
<property column="LOC_CD" type="String" name="LocCd" length="10" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="PH_NBR" type="Decimal" name="PhNbr" />
<property column="PROM_NOTE_ID" type="String" name="PromNoteId" length="9" />
<property column="REF_DOC_ID" type="String" name="RefDocId" length="12" />
<property column="RTE_CD" type="String" name="RteCd" length="10" />
<property column="SCAN_DTS" type="DateTime" name="ScanDts" />
<property column="SRC_CD" type="String" name="SrcCd" length="10" />
<property column="STOR_LOC_CD" type="String" name="StorLocCd" length="10" />
<property column="BTCH_ID" type="String" name="BtchId" not-null="true" length="14" />
<property column="BTCH_SEQ_NBR" type="Decimal" name="BtchSeqNbr" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />

</class>

<class name="TableObjects.Oracle.QcPercent,TableObjects.Oracle" table="QC_PERCENT">

<id name="QcPctId" column="QC_PCT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="QC_TYPE_DICT_ID" type="Decimal" name="QcTypeDictId" not-null="true" />
<property column="USER_CD" type="String" name="UserCd" length="10" />
<property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" />
<property column="QC_CHK_ITEM_PCT" type="Decimal" name="QcChkItemPct" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="QUE_ID" type="Decimal" name="QueId" />

</class>

<class name="TableObjects.Oracle.QueueDisposition,TableObjects.Oracle" table="QUEUE_DISPOSITION">

<composite-id>
<key-property column="DSPS_CD" type="String" name="DspsCd" length="10" />
<key-property column="QUE_ID" type="Decimal" name="QueId" />
</composite-id>
<property column="DEST_QUE_ID" type="Decimal" name="DestQueId" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.QueueRibbon,TableObjects.Oracle" table="QUEUE_RIBBON">

<composite-id>
<key-property column="QUE_ID" type="Decimal" name="QueId" />
<key-property column="RBBN_ID" type="Decimal" name="RbbnId" />
</composite-id>
<property column="SORT_ORDR_NBR" type="Decimal" name="SortOrdrNbr" />
<property column="QUE_CMPL_DT" type="DateTime" name="QueCmplDt" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="String" name="UpdDts" length="20" />

</class>

<class name="TableObjects.Oracle.ReasonCode,TableObjects.Oracle" table="REASON_CODE">

<id name="RsnCd" column="RSN_CD" type="String">
<generator class="assigned"/>
</id>
<property column="SHRT_RSN_DSCR" type="String" name="ShrtRsnDscr" length="100" />
<property column="RSN_DSCR" type="String" name="RsnDscr" length="2000" />
<property column="ADTL_TXT_IND" type="Decimal" name="AdtlTxtInd" not-null="true" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.Report,TableObjects.Oracle" table="REPORT">

<id name="RptId" column="RPT_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="RPT_TYPE_DICT_ID" type="Decimal" name="RptTypeDictId" />
<property column="RPT_DSCR" type="String" name="RptDscr" length="100" />
<property column="RPT_FILE_DSCR" type="String" name="RptFileDscr" length="100" />
<property column="RPT_SQL_DSCR" type="String" name="RptSqlDscr" length="4000" />
<property column="BGN_DT_1_LBL_DSCR" type="String" name="BgnDt1LblDscr" length="30" />
<property column="END_DT_1_LBL_DSCR" type="String" name="EndDt1LblDscr" length="30" />
<property column="DT_1_COL_DSCR" type="String" name="Dt1ColDscr" length="100" />
<property column="MAX_DT_1_DIFF_NBR" type="Decimal" name="MaxDt1DiffNbr" />
<property column="BGN_DT_2_LBL_DSCR" type="String" name="BgnDt2LblDscr" length="30" />
<property column="END_DT_2_LBL_DSCR" type="String" name="EndDt2LblDscr" length="30" />
<property column="DT_2_COL_DSCR" type="String" name="Dt2ColDscr" length="100" />
<property column="MAX_DT_2_DIFF_NBR" type="Decimal" name="MaxDt2DiffNbr" />
<property column="TEXT_1_COL_DSCR" type="String" name="Text1ColDscr" length="100" />
<property column="TEXT_1_LBL_DSCR" type="String" name="Text1LblDscr" length="30" />
<property column="TEXT_2_COL_DSCR" type="String" name="Text2ColDscr" length="100" />
<property column="TEXT_2_LBL_DSCR" type="String" name="Text2LblDscr" length="30" />
<property column="TEXT_3_COL_DSCR" type="String" name="Text3ColDscr" length="100" />
<property column="TEXT_3_LBL_DSCR" type="String" name="Text3LblDscr" length="30" />
<property column="CMB_1_COL_DSCR" type="String" name="Cmb1ColDscr" length="100" />
<property column="CMB_1_LBL_DSCR" type="String" name="Cmb1LblDscr" length="30" />
<property column="CMB_1_SQL_DSCR" type="String" name="Cmb1SqlDscr" length="2000" />
<property column="CMB_2_COL_DSCR" type="String" name="Cmb2ColDscr" length="100" />
<property column="CMB_2_LBL_DSCR" type="String" name="Cmb2LblDscr" length="30" />
<property column="CMB_2_SQL_DSCR" type="String" name="Cmb2SqlDscr" length="2000" />
<property column="CMB_3_COL_DSCR" type="String" name="Cmb3ColDscr" length="100" />
<property column="CMB_3_LBL_DSCR" type="String" name="Cmb3LblDscr" length="30" />
<property column="CMB_3_SQL_DSCR" type="String" name="Cmb3SqlDscr" length="2000" />
<property column="RPT_ORDR_BY_1_COL_DSCR" type="String" name="RptOrdrBy1ColDscr" length="2000" />
<property column="RPT_ORDR_BY_1_DSCR" type="String" name="RptOrdrBy1Dscr" length="2000" />
<property column="RPT_ORDR_BY_2_COL_DSCR" type="String" name="RptOrdrBy2ColDscr" length="2000" />
<property column="RPT_ORDR_BY_2_DSCR" type="String" name="RptOrdrBy2Dscr" length="2000" />
<property column="RPT_ORDR_BY_3_COL_DSCR" type="String" name="RptOrdrBy3ColDscr" length="2000" />
<property column="RPT_ORDR_BY_3_DSCR" type="String" name="RptOrdrBy3Dscr" length="2000" />
<property column="RPT_ORDR_BY_4_COL_DSCR" type="String" name="RptOrdrBy4ColDscr" length="2000" />
<property column="RPT_ORDR_BY_4_DSCR" type="String" name="RptOrdrBy4Dscr" length="2000" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="CMB_4_COL_DSCR" type="String" name="Cmb4ColDscr" length="100" />
<property column="CMB_4_LBL_DSCR" type="String" name="Cmb4LblDscr" length="30" />
<property column="CMB_4_SQL_DSCR" type="String" name="Cmb4SqlDscr" length="2000" />
<property column="CMB_5_COL_DSCR" type="String" name="Cmb5ColDscr" length="100" />
<property column="CMB_5_LBL_DSCR" type="String" name="Cmb5LblDscr" length="30" />
<property column="CMB_5_SQL_DSCR" type="String" name="Cmb5SqlDscr" length="2000" />
<property column="CMB_6_COL_DSCR" type="String" name="Cmb6ColDscr" length="100" />
<property column="CMB_6_LBL_DSCR" type="String" name="Cmb6LblDscr" length="30" />
<property column="CMB_6_SQL_DSCR" type="String" name="Cmb6SqlDscr" length="2000" />

</class>

<class name="TableObjects.Oracle.ReturnLetterData,TableObjects.Oracle" table="RETURN_LETTER_DATA">

<id name="RtrnLtrDataId" column="RTRN_LTR_DATA_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="FORM_FILE_DSCR" type="String" name="FormFileDscr" not-null="true" length="50" />
<property column="DOC_CLAS_DSCR" type="String" name="DocClasDscr" not-null="true" length="50" />
<property column="FLWP_IND" type="Decimal" name="FlwpInd" not-null="true" />
<property column="APP_DOC_ID" type="Decimal" name="AppDocId" />
<property column="LTR_DOC_ID" type="Decimal" name="LtrDocId" />
<property column="BTCH_ID" type="String" name="BtchId" length="14" />
<property column="LN_RQST_ID" type="String" name="LnRqstId" length="20" />
<property column="EAGL_SYS_CD" type="String" name="EaglSysCd" not-null="true" length="10" />
<property column="FORM_VER_CD" type="String" name="FormVerCd" length="10" />
<property column="FORM_CLAS_CD" type="String" name="FormClasCd" length="10" />
<property column="LNDR_ID" type="Decimal" name="LndrId" />
<property column="PERS_EXT_ID" type="String" name="PersExtId" length="9" />
<property column="STDT_EXT_ID" type="String" name="StdtExtId" length="9" />
<property column="RTRN_DT" type="DateTime" name="RtrnDt" not-null="true" />
<property column="DEST_CD" type="String" name="DestCd" not-null="true" length="10" />
<property column="DEST_MAIL_ADDR" type="String" name="DestMailAddr" not-null="true" length="200" />
<property column="PERS_NAME" type="String" name="PersName" length="50" />
<property column="STDT_NAME" type="String" name="StdtName" length="50" />
<property column="SCHL_ID" type="Decimal" name="SchlId" />
<property column="PRNT_DSCR" type="String" name="PrntDscr" length="20" />
<property column="MAIL_TO_ADDR" type="String" name="MailToAddr" length="50" />
<property column="RTRN_PRCS_INIT_NAME" type="String" name="RtrnPrcsInitName" not-null="true" length="10" />
<property column="DOC_TRK_MSG_DSCR" type="String" name="DocTrkMsgDscr" length="200" />
<property column="PERS_MAIL_ADDR" type="String" name="PersMailAddr" length="200" />
<property column="ENCL_IND" type="Decimal" name="EnclInd" not-null="true" />
<property column="RCVE_DT" type="DateTime" name="RcveDt" />
<property column="GNTR_SRVC_LOC_CD" type="String" name="GntrSrvcLocCd" length="10" />
<property column="DOC_TYPE_CD" type="String" name="DocTypeCd" length="10" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="DOC_TRKG_IND" type="Decimal" name="DocTrkgInd" />

</class>

<class name="TableObjects.Oracle.ReturnLetterReason,TableObjects.Oracle" table="RETURN_LETTER_REASON">

<id name="RtrnLtrRsnId" column="RTRN_LTR_RSN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="RTRN_LTR_DATA_ID" type="Decimal" name="RtrnLtrDataId" not-null="true" />
<property column="REC_ORDR_IND" type="Decimal" name="RecOrdrInd" not-null="true" />
<property column="RTRN_RSN_DSCR" type="String" name="RtrnRsnDscr" length="250" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="RSN_CD" type="String" name="RsnCd" length="10" />

</class>

<class name="TableObjects.Oracle.Ribbon,TableObjects.Oracle" table="RIBBON">

<id name="RbbnId" column="RBBN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="RBBN_DSCR" type="String" name="RbbnDscr" not-null="true" length="30" />
<property column="RBBN_BKLG_DAYS_DT" type="DateTime" name="RbbnBklgDaysDt" />
<property column="PRRY_CTOF_NBR" type="Decimal" name="PrryCtofNbr" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="RBBN_TYPE_CD" type="String" name="RbbnTypeCd" length="10" />

</class>

<class name="TableObjects.Oracle.RouteAround,TableObjects.Oracle" table="ROUTE_AROUND">

<id name="RteArndId" column="RTE_ARND_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="RTE_ARND_PKT_TYPE_CD" type="String" name="RteArndPktTypeCd" not-null="true" length="3" />
<property column="RQST_NBR" type="String" name="RqstNbr" not-null="true" length="36" />
<property column="SRC_DSCR" type="String" name="SrcDscr" length="20" />
<property column="SUM_RPT_COL_DSCR" type="String" name="SumRptColDscr" length="3000" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.RouteAroundPrintRqst,TableObjects.Oracle" table="ROUTE_AROUND_PRINT_RQST">

<id name="RteArndPrtRqstId" column="RTE_ARND_PRT_RQST_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="DOC_ID" type="Decimal" name="DocId" not-null="true" />
<property column="RTE_ARND_PKT_TYPE_CD" type="String" name="RteArndPktTypeCd" not-null="true" length="3" />
<property column="RQST_NBR" type="String" name="RqstNbr" not-null="true" length="36" />
<property column="SRC_DSCR" type="String" name="SrcDscr" length="20" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.ScannerBes,TableObjects.Oracle" table="SCANNER_BES">

<composite-id>
<key-property column="SCAN_DSCR" type="String" name="ScanDscr" length="30" />
<key-property column="BES_ID" type="Decimal" name="BesId" />
</composite-id>
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="LOC_CD" type="String" name="LocCd" not-null="true" length="10" />
<property column="SCAN_CD" type="String" name="ScanCd" not-null="true" length="1" />
<property column="SCAN_DTS" type="DateTime" name="ScanDts" not-null="true" />
<property column="SCAN_BTCH_SEQ_NBR" type="Decimal" name="ScanBtchSeqNbr" not-null="true" />

</class>

<class name="TableObjects.Oracle.SqlLog,TableObjects.Oracle" table="SQL_LOG">

<id name="SqlLogId" column="SQL_LOG_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="SQL_DSCR" type="String" name="SqlDscr" not-null="true" length="2000" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="TRAN_TM" type="Decimal" name="TranTm" not-null="true" />

</class>

<class name="TableObjects.Oracle.TblSchemaInfo,TableObjects.Oracle" table="TBL_SCHEMA_INFO">

<id name="TblName" column="TBL_NAME" type="String">
<generator class="assigned"/>
</id>
<property column="XML_SCHEMA" type="String" name="XmlSchema" length="2147483647" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />

</class>

<class name="TableObjects.Oracle.TempClassQueue,TableObjects.Oracle" table="TEMP_CLASS_QUEUE">

<id name="ClassQueId" column="CLASS_QUE_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="PRIOR_SSN" type="String" name="PriorSsn" length="9" />
<property column="CURR_SSN" type="String" name="CurrSsn" not-null="true" length="9" />
<property column="CALL_TYPE_CD" type="String" name="CallTypeCd" not-null="true" length="1" />
<property column="RECEIVED_DT" type="DateTime" name="ReceivedDt" not-null="true" />
<property column="USER_CD" type="String" name="UserCd" not-null="true" length="6" />
<property column="PREV_LTR_CD" type="String" name="PrevLtrCd" length="4" />
<property column="LTR_CD" type="String" name="LtrCd" not-null="true" length="4" />
<property column="CORR_CD" type="String" name="CorrCd" not-null="true" length="4" />
<property column="DOC_ID" type="String" name="DocId" not-null="true" length="10" />
<property column="MSG_DSCR" type="String" name="MsgDscr" length="2000" />
<property column="MSG_ID" type="String" name="MsgId" length="250" />
<property column="STAT_CD" type="Decimal" name="StatCd" />
<property column="ERR_DSCR" type="String" name="ErrDscr" length="250" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="10" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="SRC_CD" type="String" name="SrcCd" length="10" />
<property column="LOC_ABBR_CD" type="String" name="LocAbbrCd" length="2" />
<property column="SYS_OF_REC_CD" type="String" name="SysOfRecCd" length="10" />

</class>

<class name="TableObjects.Oracle.TempHistEntry,TableObjects.Oracle" table="TEMP_HIST_ENTRY">

<composite-id>
<key-property column="YR" type="Decimal" name="Yr" />
<key-property column="MO" type="Decimal" name="Mo" />
<key-property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" />
</composite-id>
<property column="DOC_RCVE_CNT" type="Decimal" name="DocRcveCnt" />
<property column="FLDR_RCVE_CNT" type="Decimal" name="FldrRcveCnt" />

</class>

<class name="TableObjects.Oracle.TempHistProc,TableObjects.Oracle" table="TEMP_HIST_PROC">

<composite-id>
<key-property column="YR" type="Decimal" name="Yr" />
<key-property column="MO" type="Decimal" name="Mo" />
<key-property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" />
</composite-id>
<property column="DOC_PRCS_CNT" type="Decimal" name="DocPrcsCnt" />
<property column="FLDR_PRCS_CNT" type="Decimal" name="FldrPrcsCnt" />

</class>

<class name="TableObjects.Oracle.TempQcSummary,TableObjects.Oracle" table="TEMP_QC_SUMMARY">

<composite-id>
<key-property column="YR" type="Decimal" name="Yr" />
<key-property column="MO" type="Decimal" name="Mo" />
<key-property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" />
<key-property column="TRAN_TYPE_DSCR" type="String" name="TranTypeDscr" length="30" />
<key-property column="RSN_CD" type="String" name="RsnCd" length="10" />
<key-property column="OPER_USER_CD" type="String" name="OperUserCd" length="10" />
</composite-id>
<property column="TOT_CNT" type="Decimal" name="TotCnt" not-null="true" />
<property column="ERR_CNT" type="Decimal" name="ErrCnt" not-null="true" />

</class>

<class name="TableObjects.Oracle.TempRcon,TableObjects.Oracle" table="TEMP_RCON">

<id name="TranId" column="TRAN_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="BTCH_ID" type="String" name="BtchId" length="14" />
<property column="FLDR_ID" type="Decimal" name="FldrId" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="FLDR_CNT" type="Decimal" name="FldrCnt" />
<property column="DOC_CNT" type="Decimal" name="DocCnt" not-null="true" />
<property column="PG_CNT" type="Decimal" name="PgCnt" not-null="true" />
<property column="FN_QUE_DSCR" type="String" name="FnQueDscr" length="30" />
<property column="SESN_ID" type="Decimal" name="SesnId" not-null="true" />

</class>

<class name="TableObjects.Oracle.TempUserSim,TableObjects.Ora
Top
 Profile  
 
frapper35
 Post subject: continued...
PostPosted: Mon May 21, 2007 3:48 pm 
Newbie

Joined: Mon May 21, 2007 3:14 pm
Posts: 14
cle" table="TEMP_USER_SIM">

<id name="SimId" column="SIM_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="ITM_ID" type="String" name="ItmId" not-null="true" length="30" />
<property column="STAT_CD" type="String" name="StatCd" not-null="true" length="10" />
<property column="USER_CD" type="String" name="UserCd" not-null="true" length="10" />
<property column="WKST_CD" type="String" name="WkstCd" not-null="true" length="10" />
<property column="CREAT_DTS" type="DateTime" name="CreatDts" not-null="true" />

</class>

<class name="TableObjects.Oracle.WorkflowSummary,TableObjects.Oracle" table="WORKFLOW_SUMMARY">

<composite-id>
<key-property column="YR" type="Decimal" name="Yr" />
<key-property column="MO" type="Decimal" name="Mo" />
<key-property column="DOC_TYPE_ID" type="Decimal" name="DocTypeId" />
</composite-id>
<property column="DOC_RCVE_CNT" type="Decimal" name="DocRcveCnt" />
<property column="DOC_PRCS_CNT" type="Decimal" name="DocPrcsCnt" />
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="20" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />

</class>

<class name="TableObjects.Oracle.WorkRequest,TableObjects.Oracle" table="WORK_REQUEST">

<id name="WorkId" column="WORK_ID" type="Decimal" unsaved-value="0">
<generator class="assigned"/>
</id>
<property column="CREA_DTS" type="DateTime" name="CreaDts" />
<property column="UPD_SRC_CD" type="String" name="UpdSrcCd" not-null="true" length="30" />
<property column="UPD_DTS" type="DateTime" name="UpdDts" />
<property column="RSN_DICT_ID" type="Decimal" name="RsnDictId" not-null="true" />
<property column="DPSN_CD" type="String" name="DpsnCd" not-null="true" length="10" />
<property column="FLDR_CMNT_DSCR" type="String" name="FldrCmntDscr" not-null="true" length="2000" />
<property column="FN_DOC_ID" type="Decimal" name="FnDocId" not-null="true" />

</class>

</hibernate-mapping>


that's it, finally. I am wondering how to go about debugging this error, or if you guys see anything obviously wrong with the file. Thanks in advance for your help.
Top
 Profile  
 
Gortok
 Post subject:
PostPosted: Mon May 21, 2007 7:40 pm 
Regular
Regular

Joined: Sun Jan 21, 2007 4:33 pm
Posts: 65
Put each table in its own .hbm.xml and unit test them, one at a time.

Perhaps this is off topic, but you have the .hbm.xml files set as embedded resources in your project, right? (And not as Compiled files?)
Top
 Profile  
 
frapper35
 Post subject: thank you and question...
PostPosted: Tue May 22, 2007 9:02 am 
Newbie

Joined: Mon May 21, 2007 3:14 pm
Posts: 14
thanks for the suggestion, I was able to narrow it down that way. I found that the problem occurs in the mapping for CUSTOM_TRANSACTION_INFO, specifically in the setting of the type for PROC_DATA_DSCR to "byte[]". This field is a BLOB in the Oracle table. What do I need to have it set to in the mapping file for the file to compile correctly?
Top
 Profile  
 
merge_s.rottem
 Post subject:
PostPosted: Tue May 22, 2007 10:11 am 
Expert
Expert

Joined: Tue Aug 23, 2005 5:52 am
Posts: 335
You could try type="BinaryBlob" in your property mapping. You may need to specify the length as well.

Cheers,

Symon.
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 6 posts ] 

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.