<?xml version = '1.0' encoding = 'UTF-8'?>
<Entity class="oracle.dbtools.crest.model.design.logical.Entity" directorySegmentName="seg_0" id="BB4D49ED-29AC-3F5C-0E2B-1EA8436E660E" name="PHARMACY">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>8DF392F1-05ED-243E-53A7-2D243934B2CE</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</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="PHARMACY ID" id="FD4ADA92-9A2E-FF79-B1E5-1C1DE3CFC1B5">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>066B7533-778B-C117-6111-8C6820D6FB7F</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>CD860880-62AB-6262-FF3D-E477F020B216</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="VA STATION ID" id="E104794B-AC02-CFB8-A00E-1FD1F62A1128">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<commentInRDBMS>VA STATION ID</commentInRDBMS>
<generatorID>9F0850C5-A7EC-DFA7-44FC-2DFCD891C0F7</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>10 BYTE</dataTypeSize>
<ownDataTypeParameters>10 BYTE,,</ownDataTypeParameters>
</Attribute>
<Attribute name="SERVICE LEVEL" id="2D291FAA-A751-69E0-E4CD-5224DC664BC3">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>DB4C4D0D-9031-DB7E-3ECC-50CF4866B359</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>50 BYTE</dataTypeSize>
<ownDataTypeParameters>50 BYTE,,</ownDataTypeParameters>
</Attribute>
<Attribute name="ACTIVE START TIME" id="2AB6645E-6E45-2D57-AEAB-D6AC89068B48">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>A3DE1EEB-9A98-A0FF-D433-6516AB86CAD4</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C8E424B9-639B-613C-5C03-BF3DABA9174F</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="ACTIVE END TIME" id="4769ED78-8492-E7CE-65AA-1DD4D2419866">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>6EAD0A18-8730-F113-3052-8F96F402F69D</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C8E424B9-639B-613C-5C03-BF3DABA9174F</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="SPECIALTY ID" id="3DD20AB4-F128-B568-3A41-5E9B91AAB256">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>09D52815-303D-0694-AE6B-3AC7451F8A29</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>E31FBC47-AACF-B58D-6087-152DEF2553E7</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="NCPDP ID" id="18D60667-FA73-AF2E-CE1B-1347CCA087EF">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>CD5B6285-9AD3-0AB9-49FE-623BECECC9CA</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>7 BYTE</dataTypeSize>
<ownDataTypeParameters>7 BYTE,,</ownDataTypeParameters>
</Attribute>
<Attribute name="NPI" id="42B71A38-10E7-CBA4-34FA-640A4B94EBDF">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>81037357-BC6B-6F98-738A-413351C680E8</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>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>E31FBC47-AACF-B58D-6087-152DEF2553E7</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="FILE ID" id="C9DA18FE-4CA0-1EA3-BB51-52655E7FBCF2">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>4C8A5898-8506-9CA4-54AA-A378CBDC52DF</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="STATE LICENSE NUMBER" id="12D991C1-DACF-B1E3-6676-2CF720B471A5">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>8EEFDD62-EDA5-BF39-6283-8C677E4192E0</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="MEDICARE NUMBER" id="4BDCE112-E31D-A3EF-927C-26044C3CB31D">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>51E47122-B3BE-08D2-4831-186EE6553883</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="MEDICAID NUMBER" id="E040E4CE-7FC0-6467-37C2-CCC37ABFA95E">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>D89C92AE-471C-F549-9351-2064BDA6F299</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PPO NUMBER" id="2EE87467-55FD-47EB-E119-7C63F1F6F59B">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>CFD5FB05-CACF-E81B-018B-C396E995876D</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PAYER ID" id="BB8469C5-95F2-F956-8782-C287DD149D5E">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>3FFC7BB5-8D6C-CEFD-D427-D04AC2EF9103</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="BIN LOCATION NUMBER" id="8D1DDCE5-E92B-F441-314B-85110D1CD39A">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>83507480-F888-B4C0-F4A8-B9342B2C24C3</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>35 BYTE</dataTypeSize>
<ownDataTypeParameters>35 BYTE,,</ownDataTypeParameters>
</Attribute>
<Attribute name="DEA NUMBER" id="9FA4AA5C-5B93-92B3-ED8A-0BB9955F2917">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>998B776C-2DAB-460E-B381-088617236B44</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="HIN" id="32081CBD-3B3E-5782-DF98-1C220AEDEDD2">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>973988E0-784E-C98C-1E3F-060769569D0E</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="SECONDARY COVERAGE" id="3E8D07BA-7831-5361-5E74-1627A1D7C47F">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>A5D56294-88DC-9910-CCA6-13A3C4263510</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="NAIC CODE" id="8006343F-B557-2E16-9ED6-34227F3A82A1">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>003EC5FA-C20E-64C3-FE51-137F1AFD5AD2</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PROMOTION NUMBER" id="5CB1D4DF-A4D9-570D-A500-B92F62F29733">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>1BC62201-38AD-470D-4F1D-6543125D8160</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="STORE NAME" id="F1895CD8-BEF8-7F49-AC98-3E35351E528A">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>B9E1C22A-8112-B23E-0AEE-FD2C77AE5F6D</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="STORE NUMBER" id="3135C9B9-68CE-0B2D-8BF3-2A11157BA242">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>7128ACB2-E5B8-8510-E10D-20566E03A8C9</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST LAST NAME" id="F814DE57-4424-A64E-9653-9F48FE8178DE">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>9DA5DA3A-F3A0-8FFF-ACF3-77B7A3156CA1</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST FIRST NAME" id="4627976F-FED9-AF3D-A53E-F895ED3B23C3">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>BA00BFA4-0B2A-8E33-883D-DDE4E5003D52</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST MIDDLE NAME" id="9B660407-C620-5C84-57BF-735DEBB50BDF">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>DED86D95-7BC9-8861-EFCF-2067B098F558</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST SUFFIX" id="B5CE25AD-56CC-58FB-4487-303904EAAAF0">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>C687A5E9-A715-F55F-90DC-14DE4C1EE3BD</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST PREFIX" id="360E9283-62F1-12C1-5037-65A75744931D">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>E3B415E8-F6D3-C3BE-C5F2-2A66E8FF9ECC</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST AGENT LAST NAME" id="E6481B6A-AC9D-7EE8-A289-B905F153E97B">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>F99078E5-8B95-7493-7632-EACEA634B335</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST AGENT FIRST NAME" id="BFFCF06B-5BC6-2DB3-A36F-920E32A94F38">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>84DF2E22-D1AF-F49E-7AFA-59A8EB0733EA</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST AGENT MIDDLE NAME" id="DF059E88-E8DD-A1F5-F269-8FFE96B18A7C">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>9AEA2BAC-FE28-349A-E073-14ED20200CFB</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST AGENT SUFFIX" id="418ADFFD-1520-C879-BE51-2652B740D830">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>4CA1E74A-AEB7-BD37-2C3B-C3C78ECB1647</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACIST AGENT PREFIX" id="FA00B555-0926-FA74-34FB-11B2D2E9F60F">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>3D5E00A6-A4D8-CCB9-12F1-217D1466F397</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACY ADDRESS LINE 1" id="19CE3AF0-DBE8-D0D9-A426-2224CAFEC3F0">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>412ED7A7-09B0-E52C-798F-D4753667B8D6</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACY ADDRESS LINE 2" id="AD7B85B2-858F-F9C8-A704-91DC27EE0F1B">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>279D3194-1198-378A-855D-C7F39D545D32</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACY CITY" id="48A2F144-81C4-5360-F9B0-D16F30B9D7FF">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>617BF190-C154-664C-83A4-DADD73A8FDB6</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACY STATE" id="F73D8FA2-36D5-2539-8904-96E15CB20CA1">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>E13E7A3A-5C8F-607E-D07B-48DF7197EB53</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>2</dataTypeSize>
<domain>1C7D81BD-FC41-9650-AB35-3E340D5F7052</domain>
<ownDataTypeParameters>2,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACY ZIPCODE" id="D149E081-CC44-2C09-A704-0543C389CB32">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>337D0568-37F1-21F6-724E-31664E74EC9A</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>10</dataTypeSize>
<domain>16332D13-4CFB-481A-5F40-F72E507C435D</domain>
<ownDataTypeParameters>10,,</ownDataTypeParameters>
</Attribute>
<Attribute name="TWENTY FOUR HOUR FLAG" id="F2808853-7082-D995-730C-EE9F5A46779B">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>DCE2AB97-3439-DDC0-55B2-548050BBE9FE</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="CROSS STREET" id="C8DFF4AD-B154-F47B-A55B-218F49E3745D">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>5253E357-E503-4B42-75CC-48D0C671F7C0</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="EMAIL" id="6BA7A042-1D4D-F165-39E3-C4FF9DE1D4EC">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>59DDF9FB-D98A-7CD7-2107-413222978C50</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>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACY PHONE NUMBER" id="755DABBE-634E-9761-43FC-31A7C0306258">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>CF3A9A06-234F-9A13-E9D3-00D18AEA719C</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>25 BYTE</dataTypeSize>
<ownDataTypeParameters>25 BYTE,,</ownDataTypeParameters>
</Attribute>
<Attribute name="QUALIFIER" id="2C5D619C-039B-6FD4-B4C7-0EA7C6FA6275">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>13B6F201-C138-D673-D974-5261FB00D25C</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
</Attribute>
<Attribute name="INBOUND ERX ENABLED" id="0F250091-7FC3-64A1-750B-243723F163C2">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>D5D8D322-0503-DD6E-7DDC-D18E831917EC</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<constraintName>CHECK_INBOUND_ERX_ENABLED</constraintName>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>E31FBC47-AACF-B58D-6087-152DEF2553E7</domain>
<listOfValues>
<valueDef value="0" description=""/>
<valueDef value="1" description=""/>
</listOfValues>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="UPDATED DATE" id="3AA39954-BDE5-A444-CE93-09584C035A69">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>D4CD497D-FB04-8B76-A0C7-E8D3F673249C</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>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>0FC4AF37-1118-1079-1AB1-071361FB8249</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="CREATED DATE" id="C40A2531-7679-59E0-1493-1D66CFA52E17">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>4260E7CA-B7ED-7808-2009-8192DD845A1D</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>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>0FC4AF37-1118-1079-1AB1-071361FB8249</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="CREATED BY" id="0537CF8C-29BB-36C7-E793-54823D6F149F">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>E420A7C6-661D-FFCD-F023-19E30F9228AC</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<referedAttribute>2EF5AC47-D94C-5E55-0302-43F6A034041F</referedAttribute>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>20 BYTE</dataTypeSize>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="UPDATED BY" id="8B843E3A-5EC3-5103-A0F6-AA79D769F249">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>F0EDBAFD-25EB-4065-55D4-8E93FB435FAF</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<nullsAllowed>true</nullsAllowed>
<referedAttribute>2EF5AC47-D94C-5E55-0302-43F6A034041F</referedAttribute>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>20 BYTE</dataTypeSize>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="VISN" id="0B7354BA-18AE-E719-E2C0-1A94B68020CB">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2017-06-20 13:55:40 UTC</createdTime>
<generatorID>981B74CF-E7DB-F805-49FD-9077A829BCFC</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<ownDataTypeParameters>,,</ownDataTypeParameters>
</Attribute>
<Attribute name="DIVISION NAME" id="4767A665-3926-3390-C446-BEBBA5FC1A00">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2017-06-20 13:55:40 UTC</createdTime>
<generatorID>B127EA8A-7AD3-E960-C8D5-B0FF03211D0F</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35 BYTE</dataTypeSize>
<ownDataTypeParameters>35 BYTE,,</ownDataTypeParameters>
</Attribute>
<Attribute name="PHARMACY FAX NUMBER" id="3A3AAEE9-675D-7593-6C9B-729F4C765E7F">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2017-06-20 13:55:40 UTC</createdTime>
<generatorID>68759A72-F312-D668-0F03-A167C3DC9ED3</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>25 BYTE</dataTypeSize>
<ownDataTypeParameters>25 BYTE,,</ownDataTypeParameters>
</Attribute>
</attributes>
<identifiers itemClass="oracle.dbtools.crest.model.design.logical.CandidateKey">
<identifier id="9BE4FEFB-D1B3-1EFA-80E4-F034392F7465" name="PHARMACY PK">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2016-11-09 23:00:35 UTC</createdTime>
<generatorID>8034E0E6-EE19-EA97-3AEE-131241694E27</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<pk>true</pk>
<usedAttributes>
<attributeRef>FD4ADA92-9A2E-FF79-B1E5-1C1DE3CFC1B5</attributeRef>
</usedAttributes>
</identifier>
<identifier id="9B18D365-8796-386E-EAA8-3755A52C1976" name="DIVISION NAME UK">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2017-06-20 13:55:40 UTC</createdTime>
<generatorID>2528347D-65C5-DF98-4123-62BDE39D7215</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<usedAttributes>
<attributeRef>4767A665-3926-3390-C446-BEBBA5FC1A00</attributeRef>
</usedAttributes>
</identifier>
<identifier id="9C1F9685-5326-BEC8-3AEA-4960530B1366" name="NCPDP ID UK">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2017-06-20 13:55:40 UTC</createdTime>
<generatorID>F8D71A8C-74ED-635D-C08C-BBE54A063C61</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<usedAttributes>
<attributeRef>18D60667-FA73-AF2E-CE1B-1347CCA087EF</attributeRef>
</usedAttributes>
</identifier>
<identifier id="8A47BAB3-7EB6-822D-39D2-BDDBD33F0C3E" name="NPI UK">
<createdBy>VHAHAMWandlJ</createdBy>
<createdTime>2017-06-20 13:55:40 UTC</createdTime>
<generatorID>42FDD480-BA88-5F92-C86C-EE56747F0684</generatorID>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<engineerTo>
<item key="DDF41F73-2172-3285-EB06-342520A1359A" value="true"/>
</engineerTo>
<usedAttributes>
<attributeRef>42B71A38-10E7-CBA4-34FA-640A4B94EBDF</attributeRef>
</usedAttributes>
</identifier>
</identifiers>
</Entity>