🔧
Generic Column Creator
Universal tool to add any column to any table across all agency databases.
Features form-based interface with preview mode and validation.
✨ Most Flexible | 📝 Form-Based | 🔍 SQL Preview
Use Generic Tool →
💰
Adjust Contract Balance Field
Adds adjust_contract_balance column to Visits_payments for tracking whether write-off amounts should be included in contract balance calculations for AR reporting.
📅 New | 📋 Table: Visits_payments | 💼 Billing Feature
Run Migration →
⚕️
Unstable Action Field
Adds unstable_action column to pSchedules for tracking clinician actions when handling unstable patient vitals/symptoms.
📅 Created: 2024-12-03 | 📋 Table: pSchedules
Run Migration →
🩹
Wound Tunneling & Undermining
Adds wnd_tunneling and wnd_underm columns to pWoundsVitals and pProgress tables for tracking wound characteristics.
📅 New | 📋 Tables: pWoundsVitals, pProgress | 🔢 2 Columns Each
Run Migration →
🩹
Wound Assessment Fields
Adds wnd_gran, wnd_epith, wnd_eschar, wnd_slough, and wnd_fib columns to pWoundsVitals and pProgress tables for comprehensive wound assessment tracking.
📅 New | 📋 Tables: pWoundsVitals, pProgress | 🔢 5 Columns Each
Run Migration →
📋
EVV Reason Codes Setup
Creates EVV_Reason_Codes and EVV_Update_Log tables. Adds EVV_Reason_Code_ID to pSchedules for tracking visit update reasons.
📅 Previously Run | 📋 Tables: Multiple
View/Run →
📄
Document Expiration Date
Adds date_expire field to document description tables for tracking document expiration dates.
📅 Previously Available | 📋 Table: DocumentDesc
View/Run →
📋
Communication Certification Period
Adds certification period columns to Communication table for storing CTI (Physician Certification of Terminal Illness) certification period information.
📅 New | 📋 Table: Communication | 🔢 3 Columns
View/Run →
📝
Communication Subjects (CTI & Face to Face)
Adds "Physician Certification of Terminal Illness" and "Face to Face Encounter" subjects to CommunicationSubjects table for all agencies.
📅 New | 📋 Table: CommunicationSubjects | 🔢 2 Subjects
View/Run →
📍
Communication Encounter Location
Adds Encounter_Location column to Communication table for storing location information in Face to Face Encounter communications.
📅 New | 📋 Table: Communication | 🔢 1 Column
View/Run →
📋
Copy SN Evaluation to Palliative
Copies all assessment questions and answers from 'SN Evaluation' to 'Palliative' in the lookup database. Issue #9907.
📅 New | 📋 Tables: assessment_questions_lookup, assessment_answers_lookup | 🔄 Data Copy
Run Migration →
⚡
EVV Auto-Status Triggers
Updates database triggers to automatically set "Data Changed - Retransmission Required" status when EVV data is modified.
📅 Previously Available | 🔄 Trigger Updates
View/Run →
👤
Employee Auth QA Fields
Adds quality assurance fields to employee authorization tracking system.
📅 Previously Available | 📋 Table: Employee Auth
View/Run →