Select employee_Id,authority_Level,(select AgencyType from #Request.prefix_db_lookup#.Agency where Agency_ID=Employee.Agency_ID) as agencyType,skill from #Request.prefix_db_lookup#.Employee where employee_Id not in (select eaID from #Request.prefix_db_agency#.employee_auth where employee_auth.eaID=Employee.employee_Id) ; INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 0, 1, 1, 1 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 2, 1, 1, 1, 1, 0, 1, 1, 1 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 1 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 2, 1, 1, 1, 1, 0, 1, 1, 1 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 2, 1, 1, 1, 1, 0, 1, 1, 1 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 2, 1, 1, 1, 1, 0, 1, 1, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 1, 1, 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 1, 2, 1, 1, 1, 1, 0, 1, 1, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 1, 0, 0, 0, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 1, 0, 0, 0, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 1, 0, 0, 0, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 1, 1, 0, 0, 0, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0 ) INSERT INTO #Request.prefix_db_agency#.employee_auth ( eaID, eaSetSchedule, eaSetCareplanItems, eaSetCommSubjects, eaSetEmployees, eaSetIncidentSubjects, eaSetPayers, eaSetPayrollCodes, eaSetPhysicians, eaSetReferralSrcs, eaSetRevenueCodes, eaSetSupplies, eaSetAgyInfoUpdate, eaPayroll, eaBilling, eaOrders, eaAuthorizations, eaDataTransmit, eaType, eaCareplan, eaLock, eaSchedule, eaClientEdit, eaNoteEdit, eaUndo, eaReports, eaStatistics ) values ( #GetEmployee.employee_Id#, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 1, 1, 0, 0, 0 )