<?xml version = '1.0' encoding = 'UTF-8'?>
<Table class="oracle.dbtools.crest.model.design.relational.Table" directorySegmentName="seg_0" id="8DF392F1-05ED-243E-53A7-2D243934B2CE" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="PHARMACY">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>PHARMACY</sourceObjName>
<createdBy>jwandling</createdBy>
<createdTime>2016-03-08 22:33:50 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<ordsAlias>table_4</ordsAlias>
<allowColumnReorder>false</allowColumnReorder>
<existDependencyGenerateInDDl>true</existDependencyGenerateInDDl>
<parsed>true</parsed>
<columns itemClass="oracle.dbtools.crest.model.design.relational.Column">
<Column name="PHARMACY_ID" id="066B7533-778B-C117-6111-8C6820D6FB7F">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-16 20:15:36 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="VA_STATION_ID" id="9F0850C5-A7EC-DFA7-44FC-2DFCD891C0F7">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>VA_STATION_ID</sourceObjName>
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:11:28 UTC</createdTime>
<commentInRDBMS>VA STATION ID</commentInRDBMS>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>10 BYTE</dataTypeSize>
<ownDataTypeParameters>10 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="VISN" id="981B74CF-E7DB-F805-49FD-9077A829BCFC">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>VISN</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>16427AC5-375A-8EB8-DB04-10A687F5DBD6</importedID>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="DIVISION_NAME" id="B127EA8A-7AD3-E960-C8D5-B0FF03211D0F">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>DIVISION_NAME</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>389249E7-8BED-28C6-3408-22D2AE16CF0D</importedID>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35 BYTE</dataTypeSize>
<ownDataTypeParameters>35 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="SERVICE_LEVEL" id="DB4C4D0D-9031-DB7E-3ECC-50CF4866B359">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>SERVICE_LEVEL</sourceObjName>
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 13:58:46 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>50 BYTE</dataTypeSize>
<ownDataTypeParameters>50 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="ACTIVE_START_TIME" id="A3DE1EEB-9A98-A0FF-D433-6516AB86CAD4">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 13:59:24 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C8E424B9-639B-613C-5C03-BF3DABA9174F</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="ACTIVE_END_TIME" id="6EAD0A18-8730-F113-3052-8F96F402F69D">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 13:59:36 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>C8E424B9-639B-613C-5C03-BF3DABA9174F</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="SPECIALTY_ID" id="09D52815-303D-0694-AE6B-3AC7451F8A29">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 13:59:52 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>E31FBC47-AACF-B58D-6087-152DEF2553E7</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NCPDP_ID" id="CD5B6285-9AD3-0AB9-49FE-623BECECC9CA">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>NCPDP_ID</sourceObjName>
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:00:06 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>7 BYTE</dataTypeSize>
<ownDataTypeParameters>7 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NPI" id="81037357-BC6B-6F98-738A-413351C680E8">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:00:14 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT019</logicalDatatype>
<domain>E31FBC47-AACF-B58D-6087-152DEF2553E7</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="FILE_ID" id="4C8A5898-8506-9CA4-54AA-A378CBDC52DF">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:00:22 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="STATE_LICENSE_NUMBER" id="8EEFDD62-EDA5-BF39-6283-8C677E4192E0">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:00:35 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="MEDICARE_NUMBER" id="51E47122-B3BE-08D2-4831-186EE6553883">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:00:45 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="MEDICAID_NUMBER" id="D89C92AE-471C-F549-9351-2064BDA6F299">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:00:54 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PPO_NUMBER" id="CFD5FB05-CACF-E81B-018B-C396E995876D">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:01:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PAYER_ID" id="3FFC7BB5-8D6C-CEFD-D427-D04AC2EF9103">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:01:14 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="BIN_LOCATION_NUMBER" id="83507480-F888-B4C0-F4A8-B9342B2C24C3">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>BIN_LOCATION_NUMBER</sourceObjName>
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:01:31 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35 BYTE</dataTypeSize>
<ownDataTypeParameters>35 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="DEA_NUMBER" id="998B776C-2DAB-460E-B381-088617236B44">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:01:44 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="HIN" id="973988E0-784E-C98C-1E3F-060769569D0E">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:01:58 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="SECONDARY_COVERAGE" id="A5D56294-88DC-9910-CCA6-13A3C4263510">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:02:16 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NAIC_CODE" id="003EC5FA-C20E-64C3-FE51-137F1AFD5AD2">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:02:43 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PROMOTION_NUMBER" id="1BC62201-38AD-470D-4F1D-6543125D8160">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:02:56 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="STORE_NAME" id="B9E1C22A-8112-B23E-0AEE-FD2C77AE5F6D">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:03:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="STORE_NUMBER" id="7128ACB2-E5B8-8510-E10D-20566E03A8C9">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:03:14 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_LAST_NAME" id="9DA5DA3A-F3A0-8FFF-ACF3-77B7A3156CA1">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:03:25 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_FIRST_NAME" id="BA00BFA4-0B2A-8E33-883D-DDE4E5003D52">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:03:44 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_MIDDLE_NAME" id="DED86D95-7BC9-8861-EFCF-2067B098F558">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:04:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_SUFFIX" id="C687A5E9-A715-F55F-90DC-14DE4C1EE3BD">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:04:35 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_PREFIX" id="E3B415E8-F6D3-C3BE-C5F2-2A66E8FF9ECC">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:04:45 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_AGENT_LAST_NAME" id="F99078E5-8B95-7493-7632-EACEA634B335">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:05:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_AGENT_FIRST_NAME" id="84DF2E22-D1AF-F49E-7AFA-59A8EB0733EA">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:05:33 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_AGENT_MIDDLE_NAME" id="9AEA2BAC-FE28-349A-E073-14ED20200CFB">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:05:46 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_AGENT_SUFFIX" id="4CA1E74A-AEB7-BD37-2C3B-C3C78ECB1647">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:05:59 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACIST_AGENT_PREFIX" id="3D5E00A6-A4D8-CCB9-12F1-217D1466F397">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:06:15 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACY_ADDRESS_LINE_1" id="412ED7A7-09B0-E52C-798F-D4753667B8D6">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:06:46 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACY_ADDRESS_LINE_2" id="279D3194-1198-378A-855D-C7F39D545D32">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:07:10 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACY_CITY" id="617BF190-C154-664C-83A4-DADD73A8FDB6">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:07:30 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACY_STATE" id="E13E7A3A-5C8F-607E-D07B-48DF7197EB53">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:07:43 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>2</dataTypeSize>
<domain>1C7D81BD-FC41-9650-AB35-3E340D5F7052</domain>
<ownDataTypeParameters>2,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACY_ZIPCODE" id="337D0568-37F1-21F6-724E-31664E74EC9A">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:07:56 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>10</dataTypeSize>
<domain>16332D13-4CFB-481A-5F40-F72E507C435D</domain>
<ownDataTypeParameters>10,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="TWENTY_FOUR_HOUR_FLAG" id="DCE2AB97-3439-DDC0-55B2-548050BBE9FE">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:08:12 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="CROSS_STREET" id="5253E357-E503-4B42-75CC-48D0C671F7C0">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:08:22 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="EMAIL" id="59DDF9FB-D98A-7CD7-2107-413222978C50">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:08:29 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACY_PHONE_NUMBER" id="CF3A9A06-234F-9A13-E9D3-00D18AEA719C">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>PHARMACY_PHONE_NUMBER</sourceObjName>
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:08:43 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>25 BYTE</dataTypeSize>
<ownDataTypeParameters>25 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="PHARMACY_FAX_NUMBER" id="68759A72-F312-D668-0F03-A167C3DC9ED3">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>PHARMACY_FAX_NUMBER</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>E4D59859-37A2-6A4F-9601-05265445BEAC</importedID>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>25 BYTE</dataTypeSize>
<ownDataTypeParameters>25 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="INBOUND_ERX_ENABLED" id="D5D8D322-0503-DD6E-7DDC-D18E831917EC">
<createdBy>jwandling</createdBy>
<createdTime>2016-05-17 18:18:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<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>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="UPDATED_DATE" id="D4CD497D-FB04-8B76-A0C7-E8D3F673249C">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-01 14:26:03 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>0FC4AF37-1118-1079-1AB1-071361FB8249</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="CREATED_DATE" id="4260E7CA-B7ED-7808-2009-8192DD845A1D">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-01 14:26:37 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT007</logicalDatatype>
<domain>0FC4AF37-1118-1079-1AB1-071361FB8249</domain>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="CREATED_BY" id="7CB19564-8CE2-12FC-F690-40B5ACC34E48">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>CREATED_BY</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-01 14:27:52 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>20 BYTE</dataTypeSize>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
<associations>
<colAssociation fkAssociation="5D3D471F-F2EF-9216-6B5B-80B2E2C97938" referredColumn="9865F9DD-5874-7993-138D-C6DB4F846465"/>
</associations>
</Column>
<Column name="UPDATED_BY" id="2122BC31-201B-2B9D-A5B7-5DDDC202ADA2">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>PHARMACY</sourceObjSchema>
<sourceObjName>UPDATED_BY</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-01 14:28:11 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>20 BYTE</dataTypeSize>
<ownDataTypeParameters>,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
<associations>
<colAssociation fkAssociation="CCBD4B56-0B56-748D-B403-F2341C65DACB" referredColumn="9865F9DD-5874-7993-138D-C6DB4F846465"/>
</associations>
</Column>
<Column name="QUALIFIER" id="13B6F201-C138-D673-D974-5261FB00D25C">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 14:09:06 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<useDomainConstraints>false</useDomainConstraints>
<use>0</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>35</dataTypeSize>
<domain>5301EDA8-608D-30C2-B545-117C3EF79951</domain>
<ownDataTypeParameters>35,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
</columns>
<indexes itemClass="oracle.dbtools.crest.model.design.relational.Index">
<ind_PK_UK id="8034E0E6-EE19-EA97-3AEE-131241694E27" name="PHARMACY_PK">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-16 20:15:36 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<pk>true</pk>
<indexState>Primary Constraint</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="066B7533-778B-C117-6111-8C6820D6FB7F"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="2528347D-65C5-DF98-4123-62BDE39D7215" name="DIVISION_NAME_UK">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>DIVISION_NAME_UK</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>3CF2E2C1-6A5B-3FA6-A7EC-04A32696C0A5</importedID>
<indexState>Unique Constraint</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="B127EA8A-7AD3-E960-C8D5-B0FF03211D0F"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="F8D71A8C-74ED-635D-C08C-BBE54A063C61" name="NCPDP_ID_UK">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>NCPDP_ID_UK</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>E315FFC9-C1EB-2F72-8580-0A95C4F171E2</importedID>
<indexState>Unique Constraint</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="CD5B6285-9AD3-0AB9-49FE-623BECECC9CA"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="42FDD480-BA88-5F92-C86C-EE56747F0684" name="NPI_UK">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>NPI_UK</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>5C99FA44-26A8-EDD6-7EDB-31299F29DCFD</importedID>
<indexState>Unique Constraint</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="81037357-BC6B-6F98-738A-413351C680E8"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="E5A1D5FF-11D9-0ABA-E6E3-F68B8FA210C1" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="PHARMACY_PK">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>PHARMACY_PK</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-06 18:57:12 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>5F81B1F8-F793-554D-E63A-F8FCC50529A9</importedID>
<indexState>Unique Plain Index</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="066B7533-778B-C117-6111-8C6820D6FB7F"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="4D087D77-3811-FFD6-1D0C-59E17F691608" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="DIVISION_NAME_UK">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>DIVISION_NAME_UK</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>D09E3193-C291-E6D3-917D-B15B73F46E83</importedID>
<indexState>Unique Plain Index</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="B127EA8A-7AD3-E960-C8D5-B0FF03211D0F"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="94E68F58-0C09-9758-55DF-B4D47E0F01AF" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="NCPDP_ID_UK">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>NCPDP_ID_UK</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>2E675EF8-7822-77C5-A9D0-83D69F5DE769</importedID>
<indexState>Unique Plain Index</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="CD5B6285-9AD3-0AB9-49FE-623BECECC9CA"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="4417EF99-4926-AB0E-957F-06E50BFCFBB9" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="NPI_UK">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>NPI_UK</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>C1158325-0678-A5E6-EEAB-5974F5A6C57C</importedID>
<indexState>Unique Plain Index</indexState>
<isSurrogateKey>false</isSurrogateKey>
<indexColumnUsage>
<colUsage columnID="81037357-BC6B-6F98-738A-413351C680E8"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="F34BA842-8A07-87EA-DD82-2CDBC2B0C274" name="PHARMACY_USERS_CREATED_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="7CB19564-8CE2-12FC-F690-40B5ACC34E48"/>
</indexColumnUsage>
</ind_PK_UK>
<ind_PK_UK id="EAC92C4E-5447-49FE-EB07-2BB8C27ACDDA" name="PHARMACY_USERS_UPDATED_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="2122BC31-201B-2B9D-A5B7-5DDDC202ADA2"/>
</indexColumnUsage>
</ind_PK_UK>
</indexes>
</Table>