This page will be used to track the different projects that need to be moved from the Oracle Exadata environment to another environment.
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 | 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. | |
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 | N3C | Airflow DAG |
| Daniel Popham | Project that runs monthly to generate data for N3C project from monthly refresh. | |
PCORNet/STAR |
| 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 | \\duhs-clin-nc1\duhs_pmn_dmc_fs\Bayer\BayerExtract.py | Daniel Popham | Data extract from external database into HSC_PCOR schema. | ||
RXNORM | PCORNet/STAR | Unix Shell Script | /dwhome/airflow_ci/master/dags/CDRN_ETL/RxNormLoad/RxNormLoad.sh | Daniel Popham | Process related to the PCORNet/STAR project that refreshes RxNorm data on a quarterly basis, before the STAR quarterly refresh. Manually run. | |
RXNORM_2017 | PCORNet/STAR | Windows Batch File | \\duhs-clin-nc1\duhs_pmn_dmc_fs\N3C\Project\N3C_Main.bat | vwp-pmndmc.dhe.duke.edu | Daniel Popham | Actually used for N3C project. These tables should be moved somewhere else that makes more sense. |