...
| Exadata Schema Name | Project Name | Process Type | Process Name | Process Location | Owner | Notes |
|---|---|---|---|---|---|---|
ACT_I2B2_DATA | ACT | 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 | Daniel Popham | ||
ACT_I2B2_IMDATA | ACT | N/A | N/A | Daniel Popham | ||
ACT_I2B2_METADATA | ACT | N/A | N/A | Daniel Popham | ||
ACT_I2B2_PM | ACT | N/A | N/A | Daniel Popham | ||
ACT_I2B2_SHRINE_ONT | ACT | N/A | N/A | Daniel Popham | ||
ACT_I2B2_WORKDATA | ACT | N/A | N/A | Daniel Popham | ||
| ACT_TEST_DATA | ACT | 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 | Daniel Popham | ||
| ACT_TEST_IMDATA | ACT | N/A | N/A | Daniel Popham | ||
| ACT_TEST_METADATA | ACT | N/A | N/A | Daniel Popham | ||
| ACT_TEST_PM | ACT | N/A | N/A | Daniel Popham | ||
| ACT_TEST_SHRINE_ONT | ACT | N/A | N/A | Daniel Popham | ||
| ACT_TEST_WORKDATA | ACT | 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. |
HSC_I2B2_DATA | Carolinas Collaborative (CC) | 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 | Daniel Popham | ||
| HSC_I2B2_IMDATA | Carolinas Collaborative (CC) | N/A | N/A | Daniel Popham | ||
| HSC_I2B2_METADATA | Carolinas Collaborative (CC) | N/A | N/A | Daniel Popham | ||
| HSC_I2B2_PM | Carolinas Collaborative (CC) | N/A | N/A | Daniel Popham | ||
| HSC_I2B2_SHRINE_ONT | Carolinas Collaborative (CC) | N/A | N/A | Daniel Popham | ||
| HSC_I2B2_WORKDATA | Carolinas Collaborative (CC) | N/A | N/A | Daniel Popham | ||
HSC_PCOR | PCORNet/STAR | Airflow DAGs |
| Daniel Popham | Project that contains the PCORNet CDM data that is refreshed both quarterly and monthly. | |
| Bayer | Python Script | \\duhs-clin-nc1\duhs_pmn_dmc_fs\Bayer\BayerExtract.py | Daniel Popham | Data extract from external database. Not affected by migration. | ||
| 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. |