ASATtoTDC Data Migration

1
ASAT-to-TDC Data Migration
2
Definitions (1of 2)
3
Definitions (2 of 2)
4
TDC Domains
ASAT Environment
AR
IN
CH
CM
MP
SSI
EN
MI
FA

• Single database, Support data updated via
  interface to authoritative system
• Proponent Domains control data view-ability via
  record status
• Approved records available for use/linkage
  across Domains

• Separate databases
• Share data via Export/Import
• No support for Support data updates

5
Collective Tables
BLUF Collective Tasks and Drills migrated via
Proponent-provided White Lists

• MTP Drill Book Not Migrated

Master Data, then Proponent Data by Exception
6
Individual Tables
BLUF Individual Tasks and STPs migrated via
Proponent-provided White Lists

• STP Proponent dBs
• Active
• Proposed/Inactive/Draft

7
Lesson/Course Tables
BLUF Lessons, Courses, TSPs migrated via
Proponent-provided White Lists

• Sub-Courses Not Migrated

8
CATS Tables
No CATS Data Migrated CATS Development in DTMS
Master Data Only
9
Support Tables
Official Data Official data migrated into TDC dB
first viewable/available system-wide Domain
Data Unofficial data linked to products
migrated in based on Proponent White Lists
10
Archived Data

• ATSC understands the issue and the need
• Probable COA Migrate during Phase 2 into a TDC
  History database accessible to Domain
  Administrators