SELECT * FROM #Request.prefix_db_lookup#.Employee WHERE Agency_ID = #agency_id#
ORDER BY Employee_ID ASC
SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE Loc_ID = #agency_id#
SELECT * FROM #Request.prefix_db_agency#.employee_auth WHERE eaID = #getemployee.Employee_ID#
SELECT * FROM #Request.prefix_db_lookup#.Physician WHERE Employee_ID = #getemployee.Employee_ID#
SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE
Username="#getemployee.Username#" AND
Emp_First = '#getemployee.First_Name#' AND Emp_Last = '#getemployee.Last_Name#'
AND Emp_Street1 =
SELECT Max(Emp_ID) AS Emp_ID FROM #Request.prefix_db_lookup#.pEmployee
INSERT INTo #Request.prefix_db_lookup#.pEmployee (
Emp_ID, Loc_ID, Status, Emp_First, Emp_Middle, Emp_Last, Emp_Street1, Emp_Street2, Emp_City, Emp_State, Emp_Zip, Emp_Telephone, Emp_Email, Emp_DOB, Emp_Gender, Emp_Type, Emp_Latitude, Emp_Longitude, Skill_1,Skill_2,Skill_3, Username, Password, Date_Hire, Date_Terminate, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By)
VALUES (
,
,
,
,
,
,
,
,
,
,
,
,
,
NULL ,
,
,
,
,
,
,
,
NULL ,
NULL ,
NULL,
NULL
,
,
,
,
)
INSERT INTO #Request.prefix_db_agency#.employee_auth(eaID, eaAuthority, eaSetup, 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, eaRole, eaPatientSurvey, eaFileEdit, eaonlinechat)
VALUES (
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
,
)
INSERT INTO #Request.prefix_db_agency#.employee_auth(eaID, eaAuthority)
VALUES (
,
)
INSERT INTO #Request.prefix_db_lookup#.pPhysicians(Loc_ID, Emp_ID, Status, Username, Password, Phys_First, Phys_Last, Phys_Street, Phys_City, Phys_State, Phys_Zip, Phys_Phone, Phys_Email, Phys_NPI, Phys_Fax, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By)
VALUES (
,
,
,
NULL ,
NULL ,
,
,
,
,
,
,
,
,
NULL
,
,
,
,
,
)
Some of the employee already existing