SELECT
pEmployee.Emp_ID AS Login_Id,SuperUsers.User_ID,SuperUsers.User_Id AS Emp_ID, SuperUsers.Username, SuperUsers.Full_Name,
0 AS Portal,0 AS physician_id,
Agency.Agency_ID, Agency.Agency_Name, Agency.Super_ID, Agency.Agency_Login, '' AS Telephony,
Agency.SN_Visit_MNC,Agency.SN_Visit_VBP,
'' AS Agency_Type,
Agency.Agency_State,Agency.CAHPS,"" AS Block, "" AS skill,pEmployee.Emp_Email AS Emp_Email,
"" AS Authority_Level, "" AS level
,pEmployee.Emp_First AS Emp_First, pEmployee.Emp_Last AS Emp_Last,pEmployee.Emp_alerts
,Agency.Agency_contact_Phone,pEmployee.Emp_Telephone AS Emp_Telephone
FROM #Request.prefix_db_lookup#.SuperUsers,
#Request.prefix_db_lookup#.pEmployee
LEFT JOIN #Request.prefix_db_lookup#.Agency ON pEmployee.Loc_ID = Agency.Agency_ID
WHERE SuperUsers.Super_ID = Agency.Super_ID
AND Agency_Login =
AND SuperUsers.Username =
AND Agency.Status = 'active'
GRoup by SuperUsers.Super_ID
Your Login information could not be verified. Please try again...
