Skip to main content

Terminology

Coded fields across the warehouse are paired with a value set that translates a code into a readable description. Each set is a table in the dax_terminology schema, so you can join to it directly.

Where a column is governed by one of these sets, its Terminology entry in the data dictionary links here.

Value setColumns
act_site2
admit_source3
admit_type2
ansi_fips_state3
appointment_cancellation_reason2
appointment_status1
appointment_type2
apr_drg5
bill_type4
calendar12
claim_type1
code_type1
coderx_classes10
coderx_drugs7
coderx_packages9
cvx6
discharge_disposition2
encounter_type2
ethnicity2
fips_county4
hcpcs_level_26
icd10_pcs_cms_ontology9
icd_10_cm5
icd_10_pcs3
icd_9_cm4
icd_9_pcs4
immunization_route_code2
immunization_status2
immunization_status_reason3
loinc21
loinc_deprecated_mapping6
mdc2
medicare_dual_eligibility3
medicare_orec2
medicare_status2
ms_drg6
ms_drg_weights_los11
nitos0
observation_type1
payer_type1
place_of_service2
present_on_admission2
race2
restructured_betos17
revenue_center2
sex1
snomed_ct6
snomed_ct_transitive_closures4
snomed_icd_10_map16
ssa_fips_state2
ssa_fips_state_county_crosswalk8
svi_us159
svi_us_county159

:::note Code values These pages document each value set's structure and purpose. The code values themselves are loaded into the warehouse when it is built — query the tables above to read them. Several sets are maintained by external standards bodies and are subject to their own licence terms. :::