USE [RADIOLOGY]
GO
/****** Object:  UserDefinedFunction [dbo].[fn_CheckIfERPatient]    Script Date: 9/21/2023 4:37:27 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER FUNCTION [dbo].[fn_CheckIfERPatient] (@IDNum varchar(20))  
RETURNS varchar(20)
BEGIN 

    Declare @ERPatient varchar(20)
	
	--Ed V2
	IF ISNUMERIC(@IDNum)= 0
		BEGIN
			Set @ERPatient = (Select ToP 1 IDNum From Patient_Data..tbERMaster where Idnum = @IDNum);
		END
	ELSE
		BEGIN
			Set @ERPatient = (Select TOP 1 IdNum From Patient_Data..tbpatient A where A.Idnum = @IDNum );
		END

	--Ed V1
	--IF ISNUMERIC(@IDNum)= 0
	--	BEGIN
	--		Set @ERPatient = (Select ToP 1 IDNum From Patient_Data..tbERMaster where Idnum = @IDNum);
	--	END
	--ELSE
	--	BEGIN
	--		Set @ERPatient = (
	--			Select TOP 1 A.IDNum 
	--			From Patient_Data..tbpatient A
	--			LEFT OUTER JOIN Build_File..tbCoRoom B ON A.RoomID = B.RoomID
	--			where A.Idnum = @IDNum and B.StationID in ('ERT','ERW')
	--			);
	--	END
		
	--original below
	--Set @ERPatient = (Select IDNum From Patient_Data..tbERMaster where Idnum = @IDNum);

	--Jecs Version
	--Set @ERPatient = (
	--Select IDNum From Patient_Data..tbERMaster where Idnum = @IDNum
	--UNION
	--Select IDNum From PATIENT_DATA..tbpatient where RoomID in ('BED1','BED2','BED3','BED4','BED5','BED6','BED7') and Idnum = @IDNum);

Return IsNull(@ERPatient,'0')
END