drug discharge date

The date a patient was discharged from a care setting with associated drug prescriptions or medication orders, captured in EHR and claims systems. Used in pharmacy reconciliation, transitions-of-care workflows, post-discharge medication tracking, and inpatient claims analytics within healthcare data platforms.

• PBM claims adjudication and drug utilization review
• Controlled substance monitoring and DEA compliance
• Pharmacy data warehouse and ETL pipeline design
• Prior authorization and step therapy workflows
• Medicare Part D reporting and CMS submissions

ISO-11179 snake_case standard

-- Recommended column name
drg_dsch_dt

-- Example DDL
CREATE TABLE healthcare_data (
  record_id   VARCHAR(50)   NOT NULL,
  drg_dsch_dt  DATE,  -- drug discharge date (date only, no time)
  created_dt  TIMESTAMP     NOT NULL DEFAULT NOW()
);

Column names follow the ISO-11179 naming convention: lowercase, underscore-separated, using the standard abbreviation as a prefix where applicable.