Add QA Fields to employee_auth
This migration adds 15 integer fields to employee_auth in each agency_% database:
- 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
Each column is created as INT NOT NULL DEFAULT 0.
Migration Progress
SELECT DISTINCT t.table_schema AS db_name
FROM information_schema.tables t
WHERE t.table_name = 'employee_auth'
AND t.table_schema LIKE 'agency\_%'
AND t.table_schema NOT LIKE '%lookup%'
Detected #getAgencies.recordCount# agency database(s) with employee_auth
✗ Failed to enumerate agency databases: #encodeForHtml(cfcatch.message)#
Processing #db_name#...
SELECT column_name
FROM information_schema.columns
WHERE table_schema =
AND table_name = 'employee_auth'
#preserveSingleQuotes(alterSQL)#
✓ Added columns to #db_name#.employee_auth: #ArrayToList(alterClauses, ", ")#
✓ All columns already exist in #db_name#.employee_auth - skipping
✗ Failed on #db_name#.employee_auth: #encodeForHtml(cfcatch.message)#
Migration complete. Review messages above for per-database details.