Contract Pricing
cntrct_prcngDefinition
ISO-11179 Definition
The negotiated fee schedule between payers and providers or PBMs and pharmacies, stored in contract management and claims adjudication systems. Data engineers apply contract pricing logic to calculate allowed amounts, validate reimbursement accuracy, and support financial reconciliation across network tiers.
Standard Abbreviation
cntrct_prcng
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