User:Ufolie

Phase 2 to Phase 3 Migration - Administrative Layer - Designation
Creation of the designation content is the first migration stage where the phase 3 tables are populated with the terminological entry consisting of the item's name and description. At the completion of this stage, the phase 2 items are still managed by MetaStat however in MetaWeb, they are an imported item where the item is available for look-up lists.

The tables in the phase 3 model are the following imdbdba3 tables:


 * ADMIN_RECORD
 * CONTEXT
 * PHASE2
 * TERMINOLOGICAL_ENTRY
 * TERMINOLOGICAL_ENTRY_TERM
 * TABLE_DATASET
 * the administered item tables DATAFILE, DOCUMENTATION, INSTRUMENT, FRAME, METHODOLOGY, STAT_ACTIVITY, SURVEY, UNIVERSE are created as follows:
 * Item_Id set to the ADMIN_RECORD.Item_Id
 * InsertTime Set to system timestamp of when ADMIN_COMP record is created.
 * Update_Id Set to system timestamp of when ADMIN_COMP record is created.

Phase 2 to Phase 3 Migration - CODESET - Phase 2 Share and Phase 3 Only
The CODESET entries used by both the imdbdba and imdbdba3 schema are sychronized between the phase 2 and phase 3 CODESET table. Generally these are CODESET fields in the administrative layer. An example of a shared CODESET entry is the 'DisseminationLevel_Type'. An example of a phase 3 specific CODESET entry is Interaction_Type from the AI_INTERACTION table.

The shared CODESET fields are identified in the imdbdba3.COMMON_CODESET table. The MetaStat application is responsible for the maintenance of the CODESET entries which are specific only in the phase 2 schema. The MetaWeb application is responsible for maintenance of the share entries and the phase 3 specific entries.