<?xml version = '1.0' encoding = 'UTF-8'?>
<TableProxyOraclev11g class="oracle.dbtools.crest.model.design.storage.oracle.v11g.TableProxyOraclev11g" name="PHARMACY" directorySegmentName="seg_0" id="8DF392F1-05ED-243E-53A7-2D243934B2CE">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<schemaObject>123E47A8-94FC-0B01-393B-5F55F731B670</schemaObject>
<logging>YES</logging>
<partitionedRowMovement>DISABLE</partitionedRowMovement>
<segment>3ACC9CE2-CD08-63FF-0D2F-6A27D5AC560D</segment>
<temporaryChanged>false</temporaryChanged>
<accessDriverType>oracle_loader</accessDriverType>
<rejectLimit></rejectLimit>
<columnProxies itemClass="oracle.dbtools.crest.model.design.storage.oracle.v12c.ColumnProxyOraclev12c">
<ColumnProxy name="NAIC_CODE" id="003EC5FA-C20E-64C3-FE51-137F1AFD5AD2">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACY_ID" id="066B7533-778B-C117-6111-8C6820D6FB7F">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="SPECIALTY_ID" id="09D52815-303D-0694-AE6B-3AC7451F8A29">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="QUALIFIER" id="13B6F201-C138-D673-D974-5261FB00D25C">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PROMOTION_NUMBER" id="1BC62201-38AD-470D-4F1D-6543125D8160">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="UPDATED_BY" id="2122BC31-201B-2B9D-A5B7-5DDDC202ADA2">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-06 13:21:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACY_ADDRESS_LINE_2" id="279D3194-1198-378A-855D-C7F39D545D32">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACY_ZIPCODE" id="337D0568-37F1-21F6-724E-31664E74EC9A">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_AGENT_PREFIX" id="3D5E00A6-A4D8-CCB9-12F1-217D1466F397">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PAYER_ID" id="3FFC7BB5-8D6C-CEFD-D427-D04AC2EF9103">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACY_ADDRESS_LINE_1" id="412ED7A7-09B0-E52C-798F-D4753667B8D6">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="CREATED_DATE" id="4260E7CA-B7ED-7808-2009-8192DD845A1D">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-06 13:21:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="FILE_ID" id="4C8A5898-8506-9CA4-54AA-A378CBDC52DF">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_AGENT_SUFFIX" id="4CA1E74A-AEB7-BD37-2C3B-C3C78ECB1647">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="MEDICARE_NUMBER" id="51E47122-B3BE-08D2-4831-186EE6553883">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="CROSS_STREET" id="5253E357-E503-4B42-75CC-48D0C671F7C0">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="EMAIL" id="59DDF9FB-D98A-7CD7-2107-413222978C50">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACY_CITY" id="617BF190-C154-664C-83A4-DADD73A8FDB6">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACY_FAX_NUMBER" id="68759A72-F312-D668-0F03-A167C3DC9ED3">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="ACTIVE_END_TIME" id="6EAD0A18-8730-F113-3052-8F96F402F69D">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="STORE_NUMBER" id="7128ACB2-E5B8-8510-E10D-20566E03A8C9">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="CREATED_BY" id="7CB19564-8CE2-12FC-F690-40B5ACC34E48">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-06 13:21:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="NPI" id="81037357-BC6B-6F98-738A-413351C680E8">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="BIN_LOCATION_NUMBER" id="83507480-F888-B4C0-F4A8-B9342B2C24C3">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_AGENT_FIRST_NAME" id="84DF2E22-D1AF-F49E-7AFA-59A8EB0733EA">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="STATE_LICENSE_NUMBER" id="8EEFDD62-EDA5-BF39-6283-8C677E4192E0">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="HIN" id="973988E0-784E-C98C-1E3F-060769569D0E">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="VISN" id="981B74CF-E7DB-F805-49FD-9077A829BCFC">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="DEA_NUMBER" id="998B776C-2DAB-460E-B381-088617236B44">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_AGENT_MIDDLE_NAME" id="9AEA2BAC-FE28-349A-E073-14ED20200CFB">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_LAST_NAME" id="9DA5DA3A-F3A0-8FFF-ACF3-77B7A3156CA1">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="VA_STATION_ID" id="9F0850C5-A7EC-DFA7-44FC-2DFCD891C0F7">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="ACTIVE_START_TIME" id="A3DE1EEB-9A98-A0FF-D433-6516AB86CAD4">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="SECONDARY_COVERAGE" id="A5D56294-88DC-9910-CCA6-13A3C4263510">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="DIVISION_NAME" id="B127EA8A-7AD3-E960-C8D5-B0FF03211D0F">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="STORE_NAME" id="B9E1C22A-8112-B23E-0AEE-FD2C77AE5F6D">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_FIRST_NAME" id="BA00BFA4-0B2A-8E33-883D-DDE4E5003D52">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_SUFFIX" id="C687A5E9-A715-F55F-90DC-14DE4C1EE3BD">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="NCPDP_ID" id="CD5B6285-9AD3-0AB9-49FE-623BECECC9CA">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACY_PHONE_NUMBER" id="CF3A9A06-234F-9A13-E9D3-00D18AEA719C">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PPO_NUMBER" id="CFD5FB05-CACF-E81B-018B-C396E995876D">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="UPDATED_DATE" id="D4CD497D-FB04-8B76-A0C7-E8D3F673249C">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-06 13:21:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="INBOUND_ERX_ENABLED" id="D5D8D322-0503-DD6E-7DDC-D18E831917EC">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-06 13:21:08 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="MEDICAID_NUMBER" id="D89C92AE-471C-F549-9351-2064BDA6F299">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="SERVICE_LEVEL" id="DB4C4D0D-9031-DB7E-3ECC-50CF4866B359">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="TWENTY_FOUR_HOUR_FLAG" id="DCE2AB97-3439-DDC0-55B2-548050BBE9FE">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_MIDDLE_NAME" id="DED86D95-7BC9-8861-EFCF-2067B098F558">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACY_STATE" id="E13E7A3A-5C8F-607E-D07B-48DF7197EB53">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_PREFIX" id="E3B415E8-F6D3-C3BE-C5F2-2A66E8FF9ECC">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
<ColumnProxy name="PHARMACIST_AGENT_LAST_NAME" id="F99078E5-8B95-7493-7632-EACEA634B335">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ColumnProxy>
</columnProxies>
<indexProxies>
<IndexProxy class="oracle.dbtools.crest.model.design.storage.oracle.v10g.IndexProxyOraclev10g" name="NPI_UK" id="4417EF99-4926-AB0E-957F-06E50BFCFBB9">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<schemaObject>123E47A8-94FC-0B01-393B-5F55F731B670</schemaObject>
<segment>655DE7D3-4E64-645C-749B-69687315BDDE</segment>
</IndexProxy>
<IndexProxy class="oracle.dbtools.crest.model.design.storage.oracle.v10g.IndexProxyOraclev10g" name="DIVISION_NAME_UK" id="4D087D77-3811-FFD6-1D0C-59E17F691608">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<schemaObject>123E47A8-94FC-0B01-393B-5F55F731B670</schemaObject>
<segment>655DE7D3-4E64-645C-749B-69687315BDDE</segment>
</IndexProxy>
<IndexProxy class="oracle.dbtools.crest.model.design.storage.oracle.v10g.IndexProxyOraclev10g" name="NCPDP_ID_UK" id="94E68F58-0C09-9758-55DF-B4D47E0F01AF">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<schemaObject>123E47A8-94FC-0B01-393B-5F55F731B670</schemaObject>
<segment>655DE7D3-4E64-645C-749B-69687315BDDE</segment>
</IndexProxy>
<IndexProxy class="oracle.dbtools.crest.model.design.storage.oracle.v10g.IndexProxyOraclev10g" name="PHARMACY_PK" id="E5A1D5FF-11D9-0ABA-E6E3-F68B8FA210C1">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2016-07-06 18:57:12 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<schemaObject>123E47A8-94FC-0B01-393B-5F55F731B670</schemaObject>
<segment>655DE7D3-4E64-645C-749B-69687315BDDE</segment>
</IndexProxy>
</indexProxies>
<foreignKeys>
<ForeignKey class="oracle.dbtools.crest.model.design.storage.oracle.v10g.FKProxyOraclev10g" name="PHARMACY_USERS_UPDATED_FK" id="EAC92C4E-5447-49FE-EB07-2BB8C27ACDDA">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ForeignKey>
<ForeignKey class="oracle.dbtools.crest.model.design.storage.oracle.v10g.FKProxyOraclev10g" name="PHARMACY_USERS_CREATED_FK" id="F34BA842-8A07-87EA-DD82-2CDBC2B0C274">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
</ForeignKey>
</foreignKeys>
<primaryKeys>
<PrimaryKey class="oracle.dbtools.crest.model.design.storage.oracle.v10g.PKProxyOraclev10g" name="PHARMACY_PK" id="8034E0E6-EE19-EA97-3AEE-131241694E27">
<createdBy>jwandling</createdBy>
<createdTime>2016-03-22 22:26:20 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<segment>D9CAE1A1-A05A-EC8D-321D-D544BDBAA214</segment>
<existingIndex>E5A1D5FF-11D9-0ABA-E6E3-F68B8FA210C1</existingIndex>
<indexSegment>D9CAE1A1-A05A-EC8D-321D-D544BDBAA214</indexSegment>
<indexSort>SORTED</indexSort>
<usingIndex>BY INDEX NAME</usingIndex>
</PrimaryKey>
</primaryKeys>
<uniqueKeys>
<UniqueKey class="oracle.dbtools.crest.model.design.storage.oracle.v10g.UniqueOraclev10g" name="DIVISION_NAME_UK" id="2528347D-65C5-DF98-4123-62BDE39D7215">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<segment>655DE7D3-4E64-645C-749B-69687315BDDE</segment>
<existingIndex>4D087D77-3811-FFD6-1D0C-59E17F691608</existingIndex>
<indexSegment>655DE7D3-4E64-645C-749B-69687315BDDE</indexSegment>
<indexSort>SORTED</indexSort>
<usingIndex>BY INDEX NAME</usingIndex>
</UniqueKey>
<UniqueKey class="oracle.dbtools.crest.model.design.storage.oracle.v10g.UniqueOraclev10g" name="NPI_UK" id="42FDD480-BA88-5F92-C86C-EE56747F0684">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<segment>655DE7D3-4E64-645C-749B-69687315BDDE</segment>
<existingIndex>4417EF99-4926-AB0E-957F-06E50BFCFBB9</existingIndex>
<indexSegment>655DE7D3-4E64-645C-749B-69687315BDDE</indexSegment>
<indexSort>SORTED</indexSort>
<usingIndex>BY INDEX NAME</usingIndex>
</UniqueKey>
<UniqueKey class="oracle.dbtools.crest.model.design.storage.oracle.v10g.UniqueOraclev10g" name="NCPDP_ID_UK" id="F8D71A8C-74ED-635D-C08C-BBE54A063C61">
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<segment>655DE7D3-4E64-645C-749B-69687315BDDE</segment>
<existingIndex>94E68F58-0C09-9758-55DF-B4D47E0F01AF</existingIndex>
<indexSegment>655DE7D3-4E64-645C-749B-69687315BDDE</indexSegment>
<indexSort>SORTED</indexSort>
<usingIndex>BY INDEX NAME</usingIndex>
</UniqueKey>
</uniqueKeys>
</TableProxyOraclev11g>