Drop QA Fields from employee_auth
This migration will remove unused QA-related fields from the employee_auth table for all agency databases. Issue #9842
⚠️ Important: This migration will permanently delete columns and their data from the employee_auth table for ALL agencies.
Always backup your database before running migrations.
What This Migration Does:
- Drops the following columns from employee_auth:
- r_Auth
- r_Docs_QA
- r_Coding_Review
- r_Meds_Review
- r_Admit_Visit
- r_CM_Office
- r_Freq_QA
- r_Freq_Fix
- r_Util_QA
- r_Proc_QA
- r_Orphan_QA
- r_Med_Recon_QA
- r_Goals_QA
- r_Hosp_QA
- r_PN_QA
- Applies to all agency databases (agency_*)
SQL to Execute:
ALTER TABLE {agency_db}.employee_auth
DROP COLUMN r_Auth,
DROP COLUMN r_Docs_QA,
DROP COLUMN r_Coding_Review,
DROP COLUMN r_Meds_Review,
DROP COLUMN r_Admit_Visit,
DROP COLUMN r_CM_Office,
DROP COLUMN r_Freq_QA,
DROP COLUMN r_Freq_Fix,
DROP COLUMN r_Util_QA,
DROP COLUMN r_Proc_QA,
DROP COLUMN r_Orphan_QA,
DROP COLUMN r_Med_Recon_QA,
DROP COLUMN r_Goals_QA,
DROP COLUMN r_Hosp_QA,
DROP COLUMN r_PN_QA;
Migration Progress:
SELECT DISTINCT table_schema as db_name
FROM information_schema.tables
WHERE table_name = 'employee_auth'
AND table_schema LIKE 'agency_%'
AND table_schema NOT LIKE '%lookup%'
ORDER BY table_schema
Found #getAgencies.recordCount# agency database(s) to migrate
Processing #db_name#...
SELECT COUNT(*) as col_exists
FROM information_schema.columns
WHERE table_schema =
AND table_name = 'employee_auth'
AND column_name =
ALTER TABLE #db_name#.employee_auth
DROP COLUMN #columnName#
✓ Dropped column #columnName# from #db_name#.employee_auth
ℹ Column #columnName# does not exist in #db_name# - skipping
✗ Failed to drop column #columnName# from #db_name#: #cfcatch.message#
✗ Failed to retrieve agency databases: #cfcatch.message#
🎉 Migration Complete!
- Total Agencies: #getAgencies.recordCount#
- Total Columns Per Agency: #ArrayLen(columnsToDelete)#
- Successfully Dropped: #totalSuccess#
- Did Not Exist (Skipped): #totalSkipped#
- Errors: #totalErrors#
The QA-related columns have been successfully removed from the employee_auth table across all agencies.
Issue ##9842 - Cleanup complete.
⚠️ Some errors occurred during migration. Please review the error messages above and retry if necessary.
Back to Migrations