pediatric assessment
ped_asmtDefinition
ISO-11179 Definition
The clinician's structured evaluation of a pediatric patient's health status, incorporating physical examination findings, developmental screening results, and diagnostic impressions. Documents the clinical reasoning supporting diagnosis and treatment planning within pediatric encounter notes in EHR systems.
Standard Abbreviation
ped_asmt
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
Looking for more healthcare terms?
Browse our complete library of 100,000+ standardized healthcare data terms
Browse All Terms