USE [Station]
GO
/****** Object:  UserDefinedFunction [dbo].[fn_NBBDrugFilter]    Script Date: 02/24/2021 12:52:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER FUNCTION [dbo].[fn_NBBDrugFilter] (@ItemId as varchar(20),@IdNum as varchar(20))

RETURNS varchar(1) AS 
BEGIN
	
	declare @CanRequest as varchar(1)
	
	set @CanRequest = 'Y'
	

		if (select isnull(STATUS,'0') from Station..tbNurseSetup  where Field='NBBFilter') = '1'
		begin
			 if (SELECT  IsNobalanceBilling FROM PATIENT_DATA..tbpatient where IdNum= @IdNum) =1
					if (select isnull(a.DOHCode,'')
					from Inventory..tbInvMaster a
					left join Inventory..tbInvClassification b
					on a.ItemClassificationID = b.ItemClassificationID
					where ClassificationType = 'D' and  a.ItemId = @itemid) = '' 
					 begin set @CanRequest = 'N' end
					else
					  begin
					   set @CanRequest = 'Y' 
					  end
			  
			 else
			   set @CanRequest = 'Y' 
			 end
	


Return  @CanRequest
END