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:

...

Exadata

...

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

...

HSC_I2B2_DATA
HSC_I2B2_HIVE
HSC_I2B2_IMDATA
HSC_I2B2_METADATA
HSC_I2B2_PM
HSC_I2B2_SHRINE_ONT
HSC_I2B2_WORKDATA

...

HSC_PCOR

...

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

Exadata

Schema Name	Project Name	Process Type	Process Name	Process Location	Owner	Notes
ACT_I2B2_DATA	ACT	N/A	N/A	N/A	Daniel Popham	Decommissioned project as of May 2023. However, there is data in the following schemas that should be archived somewhere before Exadata is decommissioned.
ACT_I2B2_HIVE	ACT	N/A	N/A	N/A	Daniel Popham
ACT_I2B2_IMDATA	ACT	N/A	N/A	N/A	Daniel Popham
ACT_I2B2_METADATA	ACT	N/A	N/A	N/A	Daniel Popham
ACT_I2B2_PM	ACT	N/A	N/A	N/A	Daniel Popham
ACT_I2B2_SHRINE_ONT	ACT	N/A	N/A	N/A	Daniel Popham
ACT_I2B2_WORKDATA	ACT	N/A	N/A	N/A	Daniel Popham
ACT_TEST_DATA	ACT	N/A	N/A	N/A	Daniel Popham	Decommissioned project as of May 2023. All of these schemas can be removed.
ACT_TEST_HIVE	ACT	N/A	N/A	N/A	Daniel Popham
ACT_TEST_IMDATA	ACT	N/A	N/A	N/A	Daniel Popham
ACT_TEST_METADATA	ACT	N/A	N/A	N/A	Daniel Popham
ACT_TEST_PM	ACT	N/A	N/A	N/A	Daniel Popham
ACT_TEST_SHRINE_ONT	ACT	N/A	N/A	N/A	Daniel Popham
ACT_TEST_WORKDATA	ACT	N/A	N/A	N/A	Daniel Popham
CODI	CODI	Airflow DAG	CODI_DAG	DEV: plt-nosql01.dhe.duke.edu PRD: plp-nosql01.dhe.duke.edu	Daniel Popham	Contains data used for the CODI project, supported by the PCORNet CDM data. Project has been decommissioned and the associated DAG has been disabled.
HSC_I2B2_DATA	Carolinas Collaborative (CC)	N/A	N/A	N/A	Daniel Popham	Decommissioned project some time before 2020. However, required to keep data until end of year 2025 for archival/historical purposes. Data in the following schemas should be archived somewhere before Exadata is decommissioned
HSC_I2B2_HIVE	Carolinas Collaborative (CC)	N/A	N/A	N/A	Daniel Popham
HSC_I2B2_IMDATA	Carolinas Collaborative (CC)	N/A	N/A	N/A	Daniel Popham
HSC_I2B2_METADATA	Carolinas Collaborative (CC)	N/A	N/A	N/A	Daniel Popham
HSC_I2B2_PM	Carolinas Collaborative (CC)	N/A	N/A	N/A	Daniel Popham
HSC_I2B2_SHRINE_ONT	Carolinas Collaborative (CC)	N/A	N/A	N/A	Daniel Popham
HSC_I2B2_WORKDATA	Carolinas Collaborative (CC)	N/A	N/A	N/A	Daniel Popham
HSC_PCOR

PCORNet/STAR

N3C

Airflow

DAGs

CDRNLabReload

CDRNStaticIdDAG

CVD19GetPatKeys

STAR_CopyPcornetTables

STAR_ETL_Master

STAR_ETL_PostOp

STAR_Inc_Load

STAR_

DAG	STAR_N3C_Hash_Tokens

STAR_Recover

N3C Phenotype Scripts (from N3C)	DEV: plt-nosql01.dhe.duke.edu PRD: plp-nosql01.dhe.duke.edu N3C Only: vwp-pmndmc.dhe.duke.edu	Daniel Popham	Project that runs monthly to generate data for N3C project from monthly refresh.
PCORNet/STAR		CDRNLabReload CDRNStaticIdDAG CVD19GetPatKeys STAR_CopyPcornetTables STAR_ETL_Master STAR_ETL_PostOp STAR_Inc_Load	Daniel Popham	Project that contains the PCORNet CDM data that is refreshed both quarterly and monthly.
RECOVER		STAR_Recover	Daniel Popham	Project that runs quarterly to generate data for RECOVER project based on available PCORNet refresh data .
Bayer	Python Script	BayerExtract.py	vwp-pmndmc.dhe.duke.edu	Daniel Popham	Data extract from external database into HSC_PCOR schema. Script is located on shared drive, \\duhs-clin-nc1\duhs_pmn_dmc_fs\Bayer\