SELECT Employee.*,Physician.Portal FROM #Request.prefix_db_lookup#.Employee LEFT OUTER JOIN #Request.prefix_db_lookup#.Physician on Employee.Employee_ID = Physician.Employee_ID WHERE Employee.Employee_ID = #url.ID# AND Employee.EmployeeType = 'Physician' SELECT StateName, StateAbbr FROM #Request.prefix_db_lookup#.States ORDER BY StateName SELECT Agency_ID, Agency_Name FROM #Request.prefix_db_lookup#.Agency WHERE Agency_ID = #url.AID# SELECT Authority_Level as AuthorityLevelID, AuthorityLevelDesc FROM #Request.prefix_db_lookup#.AuthorityLevels Physician Information

Change Physician Information

| Agency: #getA.Agency_Name#

Bolded fields are required.

Physician Information

First Name
Last Name
Email
Username
Reset Password
Status	Active checked> Inactive checked>
Portal	Active checked> Inactive checked>