mdatool
LibraryBlogPricing
mdatool
mdatool

Healthcare data architecture platform for data engineers, architects, and analysts building modern health systems.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data engineers & architects.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,027 clinical terms

assessment created byasmt_crtd_by

The creating user identifier for a clinical evaluation. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment created dateasmt_crtd_dt

The record creation date for a clinical evaluation. Used to track temporal information related to assessment created date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment created timeasmt_crtd_tm

The record creation time for a clinical evaluation. Used to track temporal information related to assessment created time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment creatinineasmt_cr

The kidney function marker for a clinical evaluation. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment dateasmt_dt

The calendar date value for a clinical evaluation. Used to track temporal information related to assessment date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment datetimeasmt_dttm

The combined date-time value for a clinical evaluation. Used to track temporal information related to assessment datetime. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment dea numberasmt_dea_nbr

The drug enforcement administration number for a clinical evaluation. Used as a unique reference to identify and track the assessment across healthcare systems. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment death dateasmt_death_dt

The date of death for a clinical evaluation. Used to track temporal information related to assessment death date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment deleted dateasmt_del_dt

The record deletion date for a clinical evaluation. Used to track temporal information related to assessment deleted date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment deleted indicatorasmt_del_ind

The removal status flag for a clinical evaluation. Used to track the current state or condition of the assessment. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment descriptionasmt_desc

The textual explanation for a clinical evaluation. Used to display and describe the assessment in a human-readable format. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment detailasmt_dtl

The specific information for a clinical evaluation. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment discharge dateasmt_dsch_dt

The hospital release date for a clinical evaluation. Used to track temporal information related to assessment discharge date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment due dateasmt_due_dt

The payment deadline date for a clinical evaluation. Used to track temporal information related to assessment due date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment durationasmt_dur

The time span length for a clinical evaluation. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment emailasmt_eml

The electronic mail address for a clinical evaluation. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment emergency indicatorasmt_emerg_ind

The urgent status flag for a clinical evaluation. Used to track the current state or condition of the assessment. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment end dateasmt_end_dt

The completion date value for a clinical evaluation. Used to track temporal information related to assessment end date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment end timeasmt_end_tm

The completion time value for a clinical evaluation. Used to track temporal information related to assessment end time. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

assessment entered byasmt_ent_by

The data entry user for a clinical evaluation. Used in healthcare data management and clinical workflows. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for assessment management and reporting.

PreviousPage 59 of 802Next