Body Site

CDRN_BODY_SITE_VSET.sql
CDRN_BODY_SITE_VSET_ddl.sql

CVX (Immunization)

CDRN_CVX_VSET.sql
CDRN_CVX_VSET_ddl.sql

Dispensing Dose Form

CDRN_DISP_DOSE_FORM_VSET.sql
CDRN_DISP_DOSE_FORM_VSET_ddl.sql

Facility Type

CDRN_FAC_TYPE_VSET.sql
CDRN_FAC_TYPE_VSET_ddl.sql

ETL Keys

CDRN_KEYS_STAR_PRD.sql
CDRN_KEYS_STAR_PRD_ddl.sql

Manufacturer

CDRN_MANUFACTURER_VSET.sql
CDRN_MANUFACTURER_VSET_ddl.sql

Patient Preferred Language

CDRN_PAT_PREF_LANG_VSET.sql
CDRN_PAT_PREF_LANG_VSET_ddl.sql

Payer Type

CDRN_PAYER_TYPE_VSET.sql
CDRN_PAYER_TYPE_VSET_ddl.sql

PRO LOINC

CDRN_PRO_LOINC_VSET.sql
CDRN_PRO_LOINC_VSET_ddl.sql

Provider Primary Specialty Department

CDRN_PROV_PRIM_SPEC_DEPT_VSET.sql
CDRN_PROV_PRIM_SPEC_DEPT_VSET_ddl.sql

Provider Primary Specialty

CDRN_PROV_PRIM_SPEC_VSET.sql
CDRN_PROV_PRIM_SPEC_VSET_ddl.sql

Qualitative Labels

CDRN_QUAL_VSET.sql
CDRN_QUAL_VSET_ddl.sql

Route

CDRN_ROUTE_VSET.sql
CDRN_ROUTE_VSET_ddl.sql

Rx (Prescription) Dose Form

CDRN_RX_DOSE_FORM_VSET.sql
CDRN_RX_DOSE_FORM_VSET_ddl.sql

Specimen Source

CDRN_SPECIMEN_SRC_VSET.sql
CDRN_SPECIMEN_SRC_VSET_ddl.sql

Specimen Type

CDRN_SPECIMEN_VSET.sql
CDRN_SPECIMEN_VSET_ddl.sql

Unit

CDRN_UNIT_VSET.sql
CDRN_UNIT_VSET_ddl.sql

Condition

condition_ddl.sql
condition_select.sql

Death Cause

death_cause_ddl.sql
death_cause_select.sql

Death

death_ddl.sql
death_select.sql

Demographic

demographic_ddl.sql
demographic_select.sql

Diagnosis

diagnosis_ddl.sql
diagnosis_select.sql

Dispensing

dispensing_ddl.sql
dispensing_select.sql

Encounter ID Cross-Reference

enc_id_xref_ddl.sql
enc_id_xref_select.sql

Encounter

encounter_ddl.sql
encounter_select.sql

Enrollment

enrollment_ddl.sql
enrollment_select.sql

Harvest

harvest_ddl.sql
harvest_select.sql

Hash Token

hash_token_ddl.sql
hash_token_select.sql

Immunization

immunization_ddl.sql
immunization_select.sql

Index Creation

index_create.sql
index_drop.sql

Lab History

lab_history_ddl.sql
lab_history_select.sql

Lab

labs_ddl.sql
labs_select.sql

LDS Address History

lds_addr_hist_ddl.sql
lds_addr_hist_select.sql

Medication Administration (MED_ADMIN)

med_admin_ddl.sql
med_admin_select.sql

Observation, Clinical (OBS_CLIN)

obs_clin_ddl.sql
obs_clin_select.sql

Observation, General (OBS_GEN)

obs_gen_ddl.sql
obs_gen_select.sql

OMOP Cohort

OMOP_cohort_ddl.sql
OMOP_cohort_select.sql

Not sure if this one is needed here.

Patient ID Cross-Reference

pat_id_xref_ddl.sql
pat_id_xref_select.sql

PCORNet Trial

pcornet_trial_ddl.sql
pcornet_trial_select.sql

Prescribing

prescribing_ddl.sql
prescribing_select.sql

PRO CM

pro_cm_ddl.sql
pro_cm_select.sql

Procedure

procedures_ddl.sql
procedures_select.sql

Provider

provider_ddl.sql
provider_select.sql

Referral

referral_ddl.sql
referral_select.sql

Vital

vital_ddl.sql
vital_select.sql

Birth

SC_birth_ddl.sql
SC_birth_select.sql

Clinical Location

SC_clin_loc_ddl.sql
SC_clin_loc_select.sql

COVID-19 Test

SC_cvd19_test_ddl.sql
SC_cvd19_test_select.sql

Elixhauser

SC_elix_ddl.sql
SC_elix_select.sql

Encounter ID Cross-Reference

SC_enc_id_xref_ddl.sql
SC_enc_id_xref_select.sql

Encounters, Inpatient and Emergency

SC_enc_ip_ed_ddl.sql
SC_enc_ip_ed_select.sql

Encounters, Outpatient

SC_enc_op_ddl.sql
SC_enc_op_select.sql

Grouper, Diagnosis

SC_grouper_dx_ddl.sql
SC_grouper_dx_select.sql

Grouper, Lab

SC_grouper_lab_ddl.sql
SC_grouper_lab_select.sql

Grouper, Medication

SC_grouper_med_ddl.sql
SC_grouper_med_select.sql

Medication Cross-Reference

SC_med_xref_ddl.sql
SC_med_xref_select.sql

MRN Cross-Reference

SC_mrn_xref_ddl.sql
SC_mrn_xref_select.sql

Patient PCP

SC_pat_pcp_ddl.sql
SC_pat_pcp_select.sql