SELECT Agency_Name
FROM #Request.prefix_db_lookup#.Agency
WHERE Agency_ID = #url.ID#
SELECT Employee_ID, Last_Name, First_Name, Authority_Level, Email
FROM #Request.prefix_db_lookup#.Employee
WHERE Employee.Agency_ID = #url.ID#
AND Authority_Level = 1 AND EmployeeType != 'Physician'
SELECT Employee.Employee_ID, Employee.Last_Name, Employee.First_Name, Employee.Authority_Level
FROM #Request.prefix_db_lookup#.Employee
WHERE Employee.Agency_ID = #url.ID# AND EmployeeType = 'Physician'
ORDER BY Last_Name
HHA System Administration -
Change Physician Information
Agency: #GetA.Agency_Name#
System Administrator: #GetSuper.First_Name# #GetSuper.Last_Name# email:
#GetSuper.Email#
Total System Administrators: #GetSuper.RecordCount#
WHEN ADDING NEW USER MAKE SURE USERNAME AND PASSWORD ARE 8 CHARACTERS WITH
AT LEAST 1 UPPER CASE LETTER, 1 LOWER CASE LETTER, AND 1 NUMBER
Physician Name
Total orders
2016 CPO
Action
SELECT count(*) as total_orders FROM #Request.prefix_db_agency#.Assessment_Forms
JOIN Physician on Physician.Physician_ID = Assessment_Forms.Physician_ID
WHERE Physician.Employee_ID = #Employee_ID#
AND Form_Status <> 'delete'
AND Record_Creation_Date > '2015-12-31'