Регистратура = 1,
Врач = 2,
Интернет = 4,
Другая МО = 8,
Инфомат = 32,
Кол-центр = 64

select 
ca.Mnem as [ClientApplicationName],
ca.ClientApplicationGuid as [ClientApplicationGuid],
cf.Name as [Function],
cp.Access as [Access],
cp.ScheduleDays as [ScheduleDays],
case when cp.Access & 1 > 0 then 1 else 0 end as [Регистратура],
case when cp.Access & 2 > 0 then 1 else 0 end as [Врач],
case when cp.Access & 4 > 0 then 1 else 0 end as [Интернет],
case when cp.Access & 8 > 0 then 1 else 0 end as [Другая МО],
case when cp.Access & 32 > 0 then 1 else 0 end as [Инфомат],
case when cp.Access & 64 > 0 then 1 else 0 end as [Кол-центр]
from oms_ClientPermission cp
join oms_ClientFunction cf on cp.rf_ClientFunctionId = cf.ClientFunctionId
join oms_ClientApplication ca on cp.rf_ClientApplicationId = ca.ClientApplicationId
where cp.ClientPermissionId > 0

declare @access int = 103
select
case when @access & 1 > 0 then 1 else 0 end as [Регистратура],
case when @access & 2 > 0 then 1 else 0 end as [Врач],
case when @access & 4 > 0 then 1 else 0 end as [Интернет],
case when @access & 8 > 0 then 1 else 0 end as [Другая МО],
case when @access & 32 > 0 then 1 else 0 end as [Инфомат],
case when @access & 64 > 0 then 1 else 0 end as [Кол-центр]

Перед проведением любых скриптов со страницы необходимо проверить таблицу "oms_ClientFunction" на наличие данных: VisitDoctor, VisitDirection, VisitDirectionOtherLpu