Back to search
availability expiration date
avail_exp_dtgeneral
Updated 3/30/2026
Definition
The validity end date for a open time status. Used to track temporal information related to availability expiration date. This field is commonly used in electronic health records (EHR), healthcare information systems (HIS), and clinical data warehouses for availability management and reporting.
Standard Abbreviation
avail_exp_dt
Category
general
Database Usage
-- Example column naming
CREATE TABLE claims (
claim_id VARCHAR(50),
avail_exp_dt VARCHAR(100), -- availability expiration date
...
);
-- Example in SELECT
SELECT
claim_id,
avail_exp_dt as availability_expiration_date
FROM claims;Looking for more healthcare terms?
Browse our complete library of 65,000+ standardized healthcare data terms
Browse All Terms