Back to search

system gender

sys_gndr
technology·Updated Jun 23, 2026

Definition

ISO-11179 Definition

The gender value as recorded by the source healthcare information system, reflecting the system-specific code or description used at the point of data capture. Used in demographic normalization, claims adjudication edits, and population health reporting to standardize gender data across integrated platforms.

Standard Abbreviation

sys_gndr

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