Back to search

obstetric system identifier

ob_sys_id
technology·Updated Jun 23, 2026

Definition

ISO-11179 Definition

Unique surrogate key assigned by the source system to an obstetric care record. Enables tracking of pregnancy-related encounters, prenatal visits, and delivery episodes across medical claims, care management, and maternal health quality measurement programs including prenatal care HEDIS measures.

Standard Abbreviation

ob_sys_id

Category

technology

Production DDL — DIM_SYSTEM

DIM_SYSTEM.sql
CREATE OR REPLACE TABLE DIM_SYSTEM (
    sys_key         INTEGER       NOT NULL  -- surrogate key,
    sys_id          VARCHAR(50)   NOT NULL  -- system identifier,
    sys_nm          VARCHAR(200)  NOT NULL  -- system name,
    sys_type_cd     VARCHAR(50)             -- system type code,
    sys_vrsn        VARCHAR(50)             -- system version,
    vndr_nm         VARCHAR(200)            -- vendor name,
    intfc_type_cd   VARCHAR(50)             -- interface type code,
    intfc_proto_cd  VARCHAR(20)             -- interface protocol,
    env_cd          VARCHAR(20)             -- environment code,
    host_nm         VARCHAR(200)            -- hostname,
    ip_addr         VARCHAR(45)             -- IP address,
    sts_cd          VARCHAR(20)             -- status code,
    eff_dt          DATE          NOT NULL  -- effective date,
    exp_dt          DATE                    -- expiration date,
    rec_creat_dt    TIMESTAMP     NOT NULL  -- record created date
);

Standard Snowflake DDL for the canonical technology 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