Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This page will be used to track the different projects that need to be moved from the Oracle Exadata environment to another environment.

Database Schema List

The list of affected projects are below:

  • ACT - Decommissioned process as of May 2023. However, there is data in the following schemas that should be archived somewhere before Exadata is decommissioned:

    • ACT_I2B2_DATA

    • ACT_I2B2_HIVE

    • ACT_I2B2_IMDATA

    • ACT_I2B2_METADATA

    • ACT_I2B2_PM

    • ACT_I2B2_SHRINE_ONT

    • ACT_I2B2_WORKDATA

    • NOTE: There are some other schemas starting with ACT_TEST that can be deleted as they are no longer being used for ACT testing and development.
  • CODI - There is 1 schema that currently contains data used for the CODI project, supported by the PCORNet CDM data.
    • CODI
  • CC (Carolina Collaborative) - Old project that utilized the same CDM structure as ACT. Decommissioned before 2020. However, required to keep data until 2025 for archival/historical purposes. Data in the following schemas should be archived somewhere before Exadata is decommissioned: 

    • HSC_I2B2_DATA

    • HSC_I2B2_HIVE

    • HSC_I2B2_IMDATA

    • HSC_I2B2_METADATA

    • HSC_I2B2_PM

    • HSC_I2B2_SHRINE_ONT

    • HSC_I2B2_WORKDATA

  • STAR - Project that contains the PCORNet CDM data that is refreshed quarterly. Only 1 schema is involved with this project:
    • HSC_PCOR
  • RXNorm Refresh - Project related to STAR that refreshes RxNorm data on a quarterly basis, before the STAR quarterly refresh. Following schemas are used
    • RXNORM
    • RXNORM_2017 - Actually used for N3C project. These tables should be moved somewhere else that makes more sense.


Airflow Process List

  • CDRNLabReload    
  • CDRNStaticIdDAG    
  • CODI_DAG    
  • CVD19GetPatKeys
  • STAR_CopyPcornetTables
  • STAR_ETL_Master    
  • STAR_ETL_PostOp    
  • STAR_Inc_Load    
  • STAR_N3C_Hash_Tokens    
  • STAR_Recover    

To Be Moved (Data Engineering)

The following section will be moved to the Data Engineering wiki page for tracking migration projects there.

  • COVID19 and COVID19_TEST - Schemas used for tracking COVID19 data and testing. Includes COVID19 Dashboard, DISCERN alerts, and REDCap Extract processes.
  • DISCERN - Real time alert system. Tables include data archived for alerts for debugging/tracking purposes along with some input tables for a handful of DISCERN alerts.
  • REDCAP_SEA - Schema used with the REDCap Extract program to store data for specific REDCap surveys along with settings table for the process.


List of DAGs

  • covid19CleanTables    
  • covid19Main    
  • covid19MainNightly
  • Cvd19VaxTraxNightly
  • deduceCabBkp
  • dhhsSend
  • redcapExtractCvd19
  • redcapExtractDaily
  • SF_ExitSurveys
  • SSI
  • SuccessFactorsMonthly
  • SuccessFactorsNew
  • VaxApptSched
  • VVFeedback_NEW
  • No labels