hcpcs temperature
hcpcs_tempDefinition
ISO-11179 Definition
A numeric body temperature measurement recorded in association with a HCPCS-coded clinical service or vital sign assessment. Used in encounter and clinical documentation data to support medical necessity determinations for temperature-related diagnoses and monitoring procedures.
Standard Abbreviation
hcpcs_temp
Category
Production DDL — FACT_SUPPLY_ORDER
CREATE OR REPLACE TABLE FACT_SUPPLY_ORDER (
sply_ord_key INTEGER NOT NULL -- surrogate key,
sply_ord_id VARCHAR(50) NOT NULL -- supply order ID,
mbr_key INTEGER NOT NULL -- FK to DIM_MEMBER,
prvdr_key INTEGER NOT NULL -- FK to DIM_PROVIDER,
item_cd VARCHAR(20) -- item code,
item_nm VARCHAR(255) -- item name,
hcpcs_cd VARCHAR(10) -- HCPCS code,
qty_ord DECIMAL(10,2) -- quantity ordered,
qty_dspnd DECIMAL(10,2) -- quantity dispensed,
unit_cst_amt DECIMAL(10,2) -- unit cost amount,
tot_cst_amt DECIMAL(10,2) -- total cost amount,
ord_dt DATE -- order date,
dspnd_dt DATE -- dispensed date,
prior_auth_nbr VARCHAR(30) -- prior authorization number,
load_dt TIMESTAMP_NTZ NOT NULL -- load timestamp
);
Standard Snowflake DDL for the canonical supply table. Convert to BigQuery or Databricks →
Why This Term Matters
Healthcare data terminology is foundational for any data engineer working in this industry. Precise understanding of standard terms enables accurate schema design, reduces downstream data quality issues, and ensures pipelines meet the regulatory and interoperability requirements imposed by HIPAA, HL7 FHIR, and CMS reporting frameworks. Without this foundation, even technically well-built pipelines produce data that fails validation when it reaches payers or regulators.
Related Content
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms