UPDATE #Request.prefix_db_lookup#.pEmployee SET Password = '#trim(encryptedpassword)#', Record_Mod_Date = #CreateODBCDateTime(Now())#, Record_Mod_By = #Session.EmployeeID# WHERE Emp_ID = #form.EmpID# Update #Request.prefix_db_agency#.employee_auth SET eaRole = , eaVisitLock = , eaPgNotes = , eaScheduling = , eaSetSchedule = , eaPayroll = , eaBilling = , eaOrders = , eaAuthorizations = , eaDataTransmit = , eaType = , eaCareplan = , eaLock = , eaSchedule = , eaSetCareplanItems = , eaSetCommSubjects = , eaSetEmployees = , eaSetIncidentSubjects = , eaSetPayers = , eaSetPayrollCodes = , eaSetPhysicians = , eaSetReferralSrcs = , eaSetRevenueCodes = , eaSetSupplies = , eaSetStandingorders = , eaSetVitals = , eaSetAgyInfoUpdate = , eaClientEdit = , eaNoteEdit = , eaUndo = , eaReports = , eaPatientSurvey = , eaFileEdit = , eaonlinechat = , eaStatistics = , r_Auth = , r_Assmt_QA = , r_Sched_Assmt = , r_Sched_Routine = , r_Visit_Freq = , r_Missed_Visit = , r_CP_QA = , r_485_Create = , r_485_QA = , r_485_Send = , r_487_Create = , r_487_QA = , r_487_Send = , r_CP_Track = , r_Admit_Pend = , r_Elig = , r_Datasets = , r_Proc = , r_PN_QA = WHERE eaID = #form.empID#