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