STAR Copy To Caboodle
Introduction
Detailed Information
SQL Script Migration
CDRN Support Table List
All *_VSET tables (Value Set tables) contain data provided by PCORNet to standardize various values. Data is updated on a regular basis.
Subject Area | SQL Scripts (Links to Git Repository Location) | Notes | Converted to SQL Server? |
|
---|---|---|---|---|
Body Site |
|
|
| |
CVX (Immunization) |
|
|
| |
Dispensing Dose Form | CDRN_DISP_DOSE_FORM_VSET.sql |
|
|
|
Facility Type |
|
|
| |
ETL Keys |
|
|
| |
Manufacturer |
|
|
| |
Patient Preferred Language |
|
|
| |
Payer Type |
|
|
| |
PRO LOINC |
|
|
| |
Provider Primary Specialty Department | CDRN_PROV_PRIM_SPEC_DEPT_VSET.sql |
|
|
|
Provider Primary Specialty | CDRN_PROV_PRIM_SPEC_VSET.sql |
|
|
|
Qualitative Labels |
|
|
| |
Route |
|
|
| |
Rx (Prescription) Dose Form |
|
|
| |
Specimen Source |
|
|
| |
Specimen Type |
|
|
| |
Unit |
|
|
|
CDRN Subject Area List
Subject Area | SQL Script (Links to Git Repository Location) | Notes | Converted to SQL Server? |
---|---|---|---|
Condition |
|
| |
Death Cause |
|
| |
Death |
|
| |
Demographic |
|
| |
Diagnosis |
|
| |
Dispensing |
|
| |
Encounter ID Cross-Reference |
|
| |
Encounter |
|
| |
Enrollment |
|
| |
Harvest |
|
| |
Hash Token |
|
| |
Immunization |
|
| |
Index Creation |
|
| |
Lab History |
|
| |
Lab |
|
| |
LDS Address History |
|
| |
Medication Administration (MED_ADMIN) |
|
| |
Observation, Clinical (OBS_CLIN) |
|
| |
Observation, General (OBS_GEN) |
|
| |
OMOP Cohort | Not sure if this one is needed here. |
| |
Patient ID Cross-Reference |
|
| |
PCORNet Trial |
|
| |
Prescribing |
|
| |
PRO CM |
|
| |
Procedure |
|
| |
Provider |
|
| |
Referral |
|
| |
Vital |
|
|
CRDM Sidecar List
Subject Area | SQL Script (Links to Git Repository Location) | Notes | Converted to SQL Server? |
---|---|---|---|
Birth |
|
| |
Clinical Location |
|
| |
COVID-19 Test |
|
| |
Elixhauser |
|
| |
Encounter ID Cross-Reference |
|
| |
Encounters, Inpatient and Emergency |
|
| |
Encounters, Outpatient |
|
| |
Grouper, Diagnosis |
|
| |
Grouper, Lab |
|
| |
Grouper, Medication |
|
| |
Medication Cross-Reference |
|
| |
MRN Cross-Reference |
|
| |
Patient PCP |
|
|
Troubleshooting/FAQ
References