Drug Domain‎ > ‎

GPI

Vocabulary_ID=10

The following describes the procedure to update the GPI vocabulary  with the latest release of the source.

The load process is a complete refresh of data. All new vocabulary entieties will be added. All vocabulary entities that do not exist in the latest files set will be marked as deprecated.


1.1 Scripts Transfer

All scripts and files listed at the bottom of this page should be transferred to specially created directory (eg /data/GPI).

All scripts marked red are under the development at the moment.
 Script Name  Description
10_create_schema.sql  Create prestage-stage schema with tables and indexes
10_transform_row_maps.sql      Convert and store in stage table SOURCE_TO_CONCEPT_MAP_STAGE
10_load_maps.sql 
 Load only new maps into SOURCE_TO_CONCEPT_MAP table, add invalid code information

Comments