visit type
vst_typDefinition
ISO-11179 Definition
Classifies the setting and nature of a patient encounter. Used in claims processing, utilization management, and clinical analytics to categorize how care was delivered.
Claims & Clinical Context
Visit type codes determine reimbursement rates, prior authorization requirements, and quality measure attribution. Common in 837P/I claim files, UB-04 forms, and EHR encounter records.
Example Values
Common enum values for this column
INPATIENTOUTPATIENTEMERGENCYTELEHEALTHSNFOBSERVATIONPREVENTIVEURGENT_CAREStandard Abbreviation
vst_typ
Category
Production DDL — FACT_CLINICAL_EVENT
CREATE OR REPLACE TABLE FACT_CLINICAL_EVENT (
clin_evt_key INTEGER NOT NULL -- surrogate key,
mbr_key INTEGER NOT NULL -- FK to DIM_MEMBER,
prvdr_key INTEGER NOT NULL -- FK to DIM_PROVIDER,
diag_cd VARCHAR(10) -- ICD-10 diagnosis code,
hcc_cd VARCHAR(10) -- HCC category code,
proc_cd VARCHAR(10) -- procedure code,
svc_dt DATE -- service date,
pos_cd VARCHAR(2) -- place of service,
raf_scr DECIMAL(10,3) -- RAF score,
admit_dt DATE -- admission date,
dsch_dt DATE -- discharge date,
drg_cd VARCHAR(10) -- DRG code,
los_days SMALLINT -- length of stay,
readmt_ind CHAR(1) -- readmission indicator,
load_dt TIMESTAMP_NTZ NOT NULL -- load timestamp
);
Standard Snowflake DDL for the canonical clinical table. Convert to BigQuery or Databricks →
Why This Term Matters
Clinical terms are the building blocks of risk adjustment, quality measurement, and value-based care analytics. A data engineer who understands this terminology can design schemas that correctly capture patient conditions, procedures, and encounters — enabling accurate HCC scoring, HEDIS measure attribution, and CMS reporting. Misclassifying clinical fields in a data warehouse cascades into incorrect RAF scores and failed regulatory submissions.
Related Content
Related Definitions
From the Blog
Risk AdjustmentHCC Risk Adjustment Data Model: Building Accurate Risk Score Pipelines
12 min read — Read articleLooking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms