USE [Station]
GO
/****** Object:  UserDefinedFunction [dbo].[fn_NBBPatientFilter]    Script Date: 02/24/2021 12:51:18 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER FUNCTION [dbo].[fn_NBBPatientFilter] (@IdNum as varchar(20))

RETURNS varchar(1) AS 
BEGIN
	
	declare @isNBB as varchar(1)
	
	set @isNBB = 'N'
	

		if (select isnull(STATUS,'0') from Station..tbNurseSetup  where Field='NBBFilter') = '1'
		begin
			 if (SELECT  IsNobalanceBilling FROM PATIENT_DATA..tbpatient where IdNum= @IdNum) =1
					
					  begin
					   set @isNBB = 'Y' 
					  end
	
		end
	


Return @isNBB
END