<?xml version = '1.0' encoding = 'UTF-8'?>
<Entity class="oracle.dbtools.crest.model.design.logical.Entity" directorySegmentName="seg_0" id="34E0E74C-C729-A671-EF9C-9C94184B1571" name="OUTBOUND NCPDP MSG">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>9766F42D-B453-BE45-3C62-A8A38477669E</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<adequatelyNormalized>NO</adequatelyNormalized>
<expectedVolumes>0</expectedVolumes>
<fwdEngineeringStrategyName>Single Table</fwdEngineeringStrategyName>
<growthPercent>0</growthPercent>
<growthType>Year</growthType>
<maxVolumes>9999999</maxVolumes>
<minVolumes>0</minVolumes>
<normalForm>Third</normalForm>
<attributes itemClass="oracle.dbtools.crest.model.design.logical.Attribute">
<Attribute name="OUTBOUND NCPDP MSG ID" id="D0BD3D79-A767-D93A-F777-981075175106">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>2B1058A9-8F16-975F-F716-CF5F6ECB2A3F</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>CD860880-62AB-6262-FF3D-E477F020B216</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="MESSAGE ID" id="38558E7C-DE8D-97D9-E40F-98C05D0229AC">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>1085210E-71C4-0A5F-5B10-6B46BA3D6C40</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<domain>4A7CB86C-1DA8-2F91-9C31-4EDF1C633027</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="REL TO MESSAGE ID" id="42138965-E514-783F-4A10-95B0ED1EF8A9">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>E824266D-4949-B110-F0AF-08D6E9D93FFD</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<domain>4A7CB86C-1DA8-2F91-9C31-4EDF1C633027</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="MESSAGE TYPE" id="EC7BA9A2-6665-401C-F392-4408A8535D21">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>628B6F1E-C85F-1A85-0EE6-8C9F50568457</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<domain>88955EB9-9C69-6564-0651-2C919C653EE2</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="MESSAGE" id="79513638-2A29-3C30-82DA-6CEF503A1E6E">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>44A8C58F-54F4-7C1D-89A1-49D47DF5F31D</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT050</logicalDatatype>
<domain>8D79ABBE-2049-801B-20BD-840D87D92D91</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACY ID" id="0CA2E50B-5DCD-2B6B-4133-963D6DBCD47A">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>3CC24B06-C9D0-220B-9795-D38A46D2091B</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<referedAttribute>FD4ADA92-9A2E-FF79-B1E5-1C1DE3CFC1B5</referedAttribute>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>CD860880-62AB-6262-FF3D-E477F020B216</domain>
<defaultValue>0</defaultValue>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="MESSAGE STATUS" id="3928078F-92E6-7F8E-2BC0-012834220272">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>AB0C49F0-FB26-D5B8-BD1A-350738E9BDEC</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<referedAttribute>422FB3AE-5D83-0F23-BE60-374B850E7276</referedAttribute>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>4</dataTypeSize>
<defaultValue>0000</defaultValue>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="MESSAGE STATUS DETAILS" id="474D5630-B095-0E96-C9EB-F20D7BFF9A54">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2017-06-20 13:55:40 UTC</createdTime>
<generatorID>3273F27F-5DEF-FE1E-E041-B508616615D4</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>2000 BYTE</dataTypeSize>
<ownDataTypeParameters>2000 BYTE,,</ownDataTypeParameters>
</Attribute>
<Attribute name="RECEIVED DATE" id="60E942E3-5C4F-9C85-46F0-950A7B04C05A">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<comment>date/time message is received</comment>
<generatorID>18AF22B4-9D1D-4D08-A748-081143BCE31B</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C8E424B9-639B-613C-5C03-BF3DABA9174F</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="UPDATED DATE" id="51178BCD-6EAD-EDDD-23D4-3D03E1816D5B">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<comment>Date of record update</comment>
<generatorID>390E3AC8-1FA5-BDD4-F90A-F34776C6E3D7</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<sourceType>System</sourceType>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C8E424B9-639B-613C-5C03-BF3DABA9174F</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="CREATED DATE" id="501ADE9E-9AE6-F6D8-31C8-2B30B5EFC807">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<comment>Date of record creation</comment>
<generatorID>69951B3E-E592-059C-CC7F-28D13BD9DB69</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT008</logicalDatatype>
<domain>9B14A6CB-7E4A-CE55-2F07-D37A5A602B1D</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="CODE" id="DA23A166-F504-F03A-4079-DCE249300DF5">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2017-06-20 13:55:40 UTC</createdTime>
<generatorID>13F2F569-CB21-55BA-8D3D-EA5053539A05</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<referedAttribute>422FB3AE-5D83-0F23-BE60-374B850E7276</referedAttribute>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>4</dataTypeSize>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
</attributes>
<identifiers itemClass="oracle.dbtools.crest.model.design.logical.CandidateKey">
<identifier id="FE41B178-A11D-53BD-CCB6-6CADCFEA6205" name="OUTBOUND NCPDP MSG PK">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>E3684247-50A0-4AAF-28BE-23EDB7B8BC3D</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<shouldEngineer>false</shouldEngineer>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="false"/>
</engineerTo>
<pk>true</pk>
<usedAttributes>
<attributeRef>D0BD3D79-A767-D93A-F777-981075175106</attributeRef>
</usedAttributes>
</identifier>
</identifiers>
</Entity>