<?xml version = '1.0' encoding = 'UTF-8'?>
<Table class="oracle.dbtools.crest.model.design.relational.Table" directorySegmentName="seg_0" id="9766F42D-B453-BE45-3C62-A8A38477669E" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="OUTBOUND_NCPDP_MSG">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>OUTBOUND_NCPDP_MSG</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<generatorID>3FD73A95-3E47-4DDB-D621-8A7C77995593</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<ordsAlias>erx_processing</ordsAlias>
<afterCreate>&lt;br/&gt;&lt;br/&gt;</afterCreate>
<shouldGeneratescript>true</shouldGeneratescript>
<allowColumnReorder>false</allowColumnReorder>
<existDependencyGenerateInDDl>true</existDependencyGenerateInDDl>
<parsed>true</parsed>
<columns itemClass="oracle.dbtools.crest.model.design.relational.Column">
<Column name="OUTBOUND_NCPDP_MSG_ID" id="2B1058A9-8F16-975F-F716-CF5F6ECB2A3F">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>CD860880-62AB-6262-FF3D-E477F020B216</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="MESSAGE_ID" id="1085210E-71C4-0A5F-5B10-6B46BA3D6C40">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<generatorID>2926ED76-784E-01BB-E8CD-031560BDDCC4</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<domain>4A7CB86C-1DA8-2F91-9C31-4EDF1C633027</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="REL_TO_MESSAGE_ID" id="E824266D-4949-B110-F0AF-08D6E9D93FFD">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<domain>4A7CB86C-1DA8-2F91-9C31-4EDF1C633027</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="MESSAGE_TYPE" id="628B6F1E-C85F-1A85-0EE6-8C9F50568457">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<domain>88955EB9-9C69-6564-0651-2C919C653EE2</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="MESSAGE" id="44A8C58F-54F4-7C1D-89A1-49D47DF5F31D">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT050</logicalDatatype>
<domain>8D79ABBE-2049-801B-20BD-840D87D92D91</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACY_ID" id="905BE29B-70B9-5094-A0B3-34FEB9B5C679">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>CD860880-62AB-6262-FF3D-E477F020B216</domain>
<defaultValue>0</defaultValue>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
<associations>
<colAssociation fkAssociation="9E44B574-1D89-C22C-D924-A0635A7218AC" referredColumn="066B7533-778B-C117-6111-8C6820D6FB7F"/>
</associations>
</Column>
<Column name="MESSAGE_STATUS" id="BDBEF53D-3087-996E-0313-886E8D10EB89">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>4</dataTypeSize>
<usesDefaultValue>true</usesDefaultValue>
<defaultValue>0000</defaultValue>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
<associations>
<colAssociation fkAssociation="B55164BF-905F-C464-ABA3-24C61F4F4E97" referredColumn="E0B6217D-099E-2887-9598-F9D337B098B6"/>
<colAssociation fkAssociation="8051B03E-7B96-5C5D-319C-E340755E0262" referredColumn="E0B6217D-099E-2887-9598-F9D337B098B6"/>
</associations>
</Column>
<Column name="MESSAGE_STATUS_DETAILS" id="3273F27F-5DEF-FE1E-E041-B508616615D4">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>OUTBOUND_NCPDP_MSG</sourceObjSchema>
<sourceObjName>MESSAGE_STATUS_DETAILS</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>F9D472EB-B6B8-04F0-260B-C2700D9DAA2E</importedID>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>2000 BYTE</dataTypeSize>
<ownDataTypeParameters>2000 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="RECEIVED_DATE" id="18AF22B4-9D1D-4D08-A748-081143BCE31B">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<comment>date/time message is received</comment>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C8E424B9-639B-613C-5C03-BF3DABA9174F</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="UPDATED_DATE" id="390E3AC8-1FA5-BDD4-F90A-F34776C6E3D7">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<comment>Date of record update</comment>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<sourceType>System</sourceType>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C8E424B9-639B-613C-5C03-BF3DABA9174F</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="CREATED_DATE" id="69951B3E-E592-059C-CC7F-28D13BD9DB69">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<comment>Date of record creation</comment>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT008</logicalDatatype>
<domain>9B14A6CB-7E4A-CE55-2F07-D37A5A602B1D</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
</columns>
<indexes itemClass="oracle.dbtools.crest.model.design.relational.Index">
<ind_PK_UK id="E3684247-50A0-4AAF-28BE-23EDB7B8BC3D" name="OUTBOUND_NCPDP_MSG_PK">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<pk>true</pk>
<indexState>Primary Constraint</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="2B1058A9-8F16-975F-F716-CF5F6ECB2A3F"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="808A7BB8-965E-F184-5E50-A18067641291" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="OB_NCPDP_MSG_PHARMACY_ID_IDX">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="905BE29B-70B9-5094-A0B3-34FEB9B5C679"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="33CA2EE4-BF42-06D2-6D7B-F30F120C6205" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="OB_NCPDP_MSG_ID_IDX">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<indexState>Unique Plain Index</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="2B1058A9-8F16-975F-F716-CF5F6ECB2A3F"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="A36B2CF2-478E-2D71-CA1A-713F3593FC23" name="OUTBOUND_MSG_PHARMACY_ID_FK">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-08 14:50:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<indexState>Foreign Key</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="905BE29B-70B9-5094-A0B3-34FEB9B5C679"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="09D5D683-012E-B174-6BEB-F396944F3E46" name="OUTBOUND_NCPDP_MSG_ERX_STATUS_FK">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-11-09 22:53:00 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<indexState>Foreign Key</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="BDBEF53D-3087-996E-0313-886E8D10EB89"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="E7979DB5-4CFB-2360-9943-97FFF2DA0F12" name="OUTBOUND_MSG_ERX_STATUS_FK">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<indexState>Foreign Key</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="BDBEF53D-3087-996E-0313-886E8D10EB89"/>
</indexColumnUsage>
</ind_PK_UK>
</indexes>
</Table>