๐ง
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 โ
๐ก
Agency EVV_Transmission
Adds EVV_Transmission to lookup Agency (auto_send or manual_trans / review first).
๐
#10527 | ๐ Table: Agency | ๐ข 1 Column
Run Migration โ
๐
EVV Payer Required Field
Adds evv_payer_required column to pPayer (INT NOT NULL DEFAULT 0, after EVV) for all agency databases.
๐
New | ๐ Table: pPayer | ๐ข 1 Column
Run Migration โ
๐ก
EVV Patient Automation Queue
Creates EVV_Patient_Automation table in hhapowerpath for automated patient EVV JSON transmit and status polling (tickets 10421-10425).
๐
New | ๐ Table: EVV_Patient_Automation | ๐ข Queue + status polling
Run Migration โ
๐ก
EVV Visit Automation Queue
Creates EVV_Visit_Automation table in hhapowerpath for automated visit EVV transmit and status polling (tickets 10426-10429).
๐
New | ๐ Table: EVV_Visit_Automation | ๐ข Queue + status polling
Run Migration โ
๐ก
EVV Visit Automation Status
Adds Status (0 active) to EVV_Visit_Automation for manual transmission and queue filtering.
๐
New | ๐ Column: Status | ๐ข 0 = active
Run Migration โ
๐
485/487 Checking on pPayer
Adds checking_485 and checking_487 columns to pPayer for payer setup controls.
๐
New | ๐ Table: pPayer | ๐ข 2 Columns
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 โ
๐
Create assessment_*_lookup_PATTII Tables
Creates assessment_questions_lookup_PATTII and assessment_answers_lookup_PATTII
and copies all data from the current lookup tables. Issue #10641.
๐
New | ๐ Lookup DB | ๐ CREATE TABLE LIKE + full data copy
Run Migration โ
๐ฅ
Add PEGGII to Agency
Adds PEGGII (PEGGii Patient Engagement) Yes/No setup field
to the lookup Agency table. Default is Yes. Issue #10669.
๐
New | ๐ Lookup DB Agency | ๐ ALTER TABLE ADD COLUMN
Run Migration โ
โ๏ธ
Add no_email to pPatients
Adds no_email checkbox to pPatients.
Email is required unless No email is checked. Default is email required. Issue #10670.
๐
New | ๐ pPatients (all agencies) | ๐ ALTER TABLE ADD COLUMN
Run Migration โ
๐
Toggle PATTII Assessment Lookup Flag
Turn ON/OFF use of assessment_*_lookup_PATTII for OASIS/eval wizards,
Mobile API, and Whisper API. Issue #10641.
๐
New | โ๏ธ Application.use_assessment_lookup_PATTII
Toggle Flag โ
โก
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 โ
๐ฅ
Create pInpatient_Hx Table
Creates pInpatient_Hx (inpatient admit/discharge history per admission and facility) on all agency databases.
๐
#10516 | ๐ Table: pInpatient_Hx | ๐ฅ All agency_* DBs
Run Migration โ
๐
Create pAdmit_Forms Table
Creates pAdmit_Forms on all agency databases for admission packet data
(consents, ACH, LEP, advance directives, HIPAA, emergency plan, signatures).
๐
New | ๐ Table: pAdmit_Forms | ๐ฅ All agency_* DBs
Run Migration โ
๐งพ
pAdmit_Forms CC Patient Columns
Adds cc_patient_name and cc_patient_id to
pAdmit_Forms after ach_signature_date on all agency databases.
๐
New | ๐ Table: pAdmit_Forms | ๐ฅ All agency_* DBs
Run Migration โ
๐
pAdmit_Forms form_type & Notice Columns
Adds form_type (ADMISSION_PACKET / HHCCN / NOMNC) and notice signature/date fields
to pAdmit_Forms on all agency databases, plus related indexes.
๐
New | ๐ Table: pAdmit_Forms | ๐ฅ All agency_* DBs
Run Migration โ