<?xml version = '1.0' encoding = 'UTF-8'?>
<Table class="oracle.dbtools.crest.model.design.relational.Table" directorySegmentName="seg_0" id="3435164C-0A8A-44D2-2A93-C99B1B0A0864" schemaObject="123E47A8-94FC-0B01-393B-5F55F731B670" name="NCPDP_CODE">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>ERX</sourceObjSchema>
<sourceObjName>NCPDP_CODE</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>0C07B448-847F-A00F-E486-23DE30EC1C9F</importedID>
<allowColumnReorder>false</allowColumnReorder>
<existDependencyGenerateInDDl>true</existDependencyGenerateInDDl>
<parsed>true</parsed>
<columns itemClass="oracle.dbtools.crest.model.design.relational.Column">
<Column name="NCIT_SUBSET_CODE" id="CCDEDACF-ACAC-CF27-214C-054A74978C18">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>NCPDP_CODE</sourceObjSchema>
<sourceObjName>NCIT_SUBSET_CODE</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>ED09FAE6-E7A6-1FB8-B661-4EECEA0692CA</importedID>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>7 BYTE</dataTypeSize>
<ownDataTypeParameters>7 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NCPDP_SUBSET_PREF_TERM" id="57CC7DAE-3DAA-135E-BEAD-37217150F560">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>NCPDP_CODE</sourceObjSchema>
<sourceObjName>NCPDP_SUBSET_PREF_TERM</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>EEB9F3FC-9CBC-E888-CD91-D5330A65BFCC</importedID>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>100 BYTE</dataTypeSize>
<ownDataTypeParameters>100 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NCIT_CODE" id="0F7903E7-FAE1-E705-854C-60103BF10DB4">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>NCPDP_CODE</sourceObjSchema>
<sourceObjName>NCIT_CODE</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>B9AC35F6-3EB2-4390-2BB5-E68F59347FF1</importedID>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>7 BYTE</dataTypeSize>
<ownDataTypeParameters>7 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NCPDP_PREF_TERM" id="186665E8-C2E1-3AF5-5651-E2EADF439A5D">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>NCPDP_CODE</sourceObjSchema>
<sourceObjName>NCPDP_PREF_TERM</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>E1CCA403-9BF8-D3D9-3430-069949403780</importedID>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>100 BYTE</dataTypeSize>
<ownDataTypeParameters>100 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NCPDP_SYNONYM" id="30AA0EC9-43D8-3533-DCDE-792F9A94A0FB">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>NCPDP_CODE</sourceObjSchema>
<sourceObjName>NCPDP_SYNONYM</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>E2DF230D-0425-2DAD-CBB5-A24B3D9AB8C0</importedID>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>100 BYTE</dataTypeSize>
<ownDataTypeParameters>100 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NCIT_PREF_TERM" id="213A01EF-EB79-09BF-9EE4-EA8C9A7117ED">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>NCPDP_CODE</sourceObjSchema>
<sourceObjName>NCIT_PREF_TERM</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>7971D78C-A1C9-B4FD-0ECD-6BF455A4F959</importedID>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>100 BYTE</dataTypeSize>
<ownDataTypeParameters>100 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
<Column name="NCIT_DEFINITION" id="90EA3232-BA4E-A416-8AD5-E8E4336F6AB0">
<sourceConnName>local_erx</sourceConnName>
<sourceObjSchema>NCPDP_CODE</sourceObjSchema>
<sourceObjName>NCIT_DEFINITION</sourceObjName>
<createdBy>DNS   WandlJ</createdBy>
<createdTime>2017-06-20 12:22:04 UTC</createdTime>
<ownerDesignName>eRx Database Model v2</ownerDesignName>
<importedID>D0098927-AD3F-926F-319F-7DA1B78E3889</importedID>
<nullsAllowed>true</nullsAllowed>
<useDomainConstraints>false</useDomainConstraints>
<use>1</use>
<logicalDatatype>LOGDT024</logicalDatatype>
<dataTypeSize>2000 BYTE</dataTypeSize>
<ownDataTypeParameters>2000 BYTE,,</ownDataTypeParameters>
<autoIncrementCycle>false</autoIncrementCycle>
</Column>
</columns>
</Table>