Back to search
psychiatric effective date
psych_eff_dtgeneral
Updated 3/30/2026
Definition
The active beginning date for a mental health specialty. Used to track when psychiatric effective date in healthcare data systems.
Standard Abbreviation
psych_eff_dt
Category
general
Database Usage
-- Example column naming
CREATE TABLE claims (
claim_id VARCHAR(50),
psych_eff_dt VARCHAR(100), -- psychiatric effective date
...
);
-- Example in SELECT
SELECT
claim_id,
psych_eff_dt as psychiatric_effective_date
FROM claims;Looking for more healthcare terms?
Browse our complete library of 65,000+ standardized healthcare data terms
Browse All Terms