encounter_types


Description

Location-specific encounter type configurations

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
encounter_rules.encounter_type_id fk_encounter_rules_encounter_type C
encounter_type_cpts.encounter_type_id fk_encounter_type_cpts_encounter_type C
encounter_type_sub_events.child_encounter_type_id fk_encounter_type_sub_events_child C
encounter_type_sub_events.parent_encounter_type_id fk_encounter_type_sub_events_parent C
encounter_types.parent_encounter_type_id fk_encounter_types_parent N
encounters.encounter_type_id fk_encounters_type R
location_business_line_id VARCHAR 36 null
location_business_lines.id fk_encounter_types_location R

Location scope for multi-tenancy
code VARCHAR 50 null

Code e.g., ABA_STANDARD_SESSION
name VARCHAR 100 null

Display name
description TEXT 65535 √ null

Detailed description
color VARCHAR 7 √ null

Hex color code for UI
parent_encounter_type_id VARCHAR 36 √ null
encounter_types.id fk_encounter_types_parent N

FK to parent encounter_types.id
is_clinical BIT 1 1
is_billable BIT 1 1
is_invoiceable BIT 1 1
is_clockable BIT 1 1
requires_authorization BIT 1 0
require_billing_codes BIT 1 1
allow_partial_billing BIT 1 0
max_billing_codes_per_encounter INT 10 √ null
allowed_billing_codes_mode VARCHAR 20 EXPLICIT_LIST
is_root_type BIT 1 0
is_parent_type BIT 1 0
is_child_type BIT 1 0
default_duration_minutes INT 10 √ null
min_duration_minutes INT 10 √ null
max_duration_minutes INT 10 √ null
allow_overlap_client BIT 1 0
allow_overlap_provider BIT 1 0
max_daily_minutes_per_client INT 10 √ null
max_weekly_minutes_per_client INT 10 √ null
max_consecutive_days_per_client INT 10 √ null
max_daily_minutes_per_provider INT 10 √ null
max_weekly_minutes_per_provider INT 10 √ null
max_consecutive_days_per_provider INT 10 √ null
lead_time_value INT 10 √ null
lead_time_unit VARCHAR 20 √ DAYS
lag_time_hours INT 10 √ null
allowed_days_mode VARCHAR 20 NO_RESTRICTION
cutoff_dates_mode VARCHAR 30 √ NO_RESTRICTION
require_location BIT 1 1
max_locations_per_encounter INT 10 √ 1
allow_new_locations BIT 1 0
allow_parent_locations BIT 1 1
allow_travel BIT 1 0
allow_edit_by_user BIT 1 1
allow_create_by_others BIT 1 0
allowed_credentials_mode VARCHAR 20 NO_RESTRICTION
allowed_credentials_json JSON 1073741824 √ null
require_data_collection BIT 1 0
allow_narrative_mode BIT 1 0
is_multi_day BIT 1 0
status_behavior_json JSON 1073741824 √ null
allow_signature BIT 1 1
require_signature BIT 1 0
signature_locks BIT 1 0
show_signature_info BIT 1 1
allow_remote_signature_capture BIT 1 0
require_signature_statuses_mode VARCHAR 20 √ NO_RESTRICTION
require_signature_statuses_json JSON 1073741824 √ null
show_event_info BIT 1 1
rounding_function VARCHAR 20 √ NONE
rounding_interval_minutes INT 10 √ null
buffer_minutes INT 10 √ null
config_json JSON 1073741824 √ null
is_active BIT 1 1
created_at TIMESTAMP 19 CURRENT_TIMESTAMP
updated_at TIMESTAMP 19 CURRENT_TIMESTAMP
created_by VARCHAR 36 √ null
updated_by VARCHAR 36 √ null
allowed_days_json TEXT 65535 √ null
encounter_autolock_hours INT 10 √ null
require_supervision_review BIT 1 0
max_hours_deficient_medical_record INT 10 √ null
validate_encounter_completion BIT 1 0
pos_restriction_mode VARCHAR 20 √ NONE
default_note_template_id VARCHAR 36 √ null

Fallback note template ID when no CPT-based template is found
encounter_autolock_minutes INT 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_encounter_types_code Performance Asc code
idx_encounter_types_default_note_template Performance Asc default_note_template_id
idx_encounter_types_is_active Performance Asc is_active
idx_encounter_types_is_billable Performance Asc is_billable
idx_encounter_types_is_clinical Performance Asc is_clinical
idx_encounter_types_location Performance Asc location_business_line_id
idx_encounter_types_parent Performance Asc parent_encounter_type_id
uk_encounter_types_code_location Must be unique Asc/Asc location_business_line_id + code

Relationships

Close relationships within degrees of separation