USE [HL_VA_LOAD]
GO
/****** Object:  UserDefinedFunction [dbo].[fnDailyDataLoad]    Script Date: 09/23/2013 17:27:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER function [dbo].[fnDailyDataLoad] (@listenerGuid nvarchar (100))
returns
@DailyDataLoad table
(
	AccessionNumber	varchar(100),
	StudySourceLocation varchar(3),
	OrderNumber	varchar(200),
	ReadingPhysician	varchar(500),
	ExamType	varchar(8000),
	BodyPart	varchar(100),
	Modality	varchar(100),
	PatientID	varchar(100),
	ReferringPhysician	varchar(500),
	ProcCode	varchar(100),
	Priority	varchar(100),
	Source	varchar(300),
	ServerReceivedDateTime datetime,
	StudyDateTime datetime,
	FinalizeDateTime datetime,
	ORU	int,
	ReportEmailed	int,
	ReportFaxed	int,
	SignedOnTimeliness	varchar(16),
	TotalCharge	int,
	OrderCount	int,
	ExamBilledCount int,
	ExamBilledCountMay1 decimal(5,2),	
	BilledCharge int,
	BilledChargeMay1 int,
	InterpretedCount	int,	
	FollowUp varchar(100),
	PatientName varchar(150), 
	PatientBirthDateTime DateTime, 
	PatientSex varchar(10),
	OrderStatus varchar(100), 
	[ProfessionalRVU] [real],
	[TechnicalRVU] [real],	
	[TotalRVU] [real],
	NumberOfImages int
)
as
Begin
	if @listenerGuid = '5b3c8103-1f33-42b2-b4f2-deef58788afe' 
	begin
		insert into @DailyDataLoad
		Select * from vwDataLoadDaily
	end
	else if @listenerGuid = '5ce557d2-c79e-441a-8cf2-b5c07d04a8b6'
	begin
		insert into @DailyDataLoad
		Select * from vwDataLoadDailyCFind
	end
	return
End