USE [HL_VA_LOAD]
GO

/****** Object:  View [dbo].[vwDataLoadDailyCFind]    Script Date: 09/23/2013 17:31:56 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


ALTER View [dbo].[vwDataLoadDailyCFind] as

Select 
	AccessionNumber, 
	left(Accessionnumber,3) as StudySourceLocation, 
	NULL as OrderNumber, 
	NULL as ReadingPhysician, 
	StudyDesc as ExamType, 
	NULL as BodyPart, 
	ModalityType as Modality, 
	MRN as PatientID, 
	ReferringPhysician, 
	CPTCode as ProcCode, 
	NULL as Priority, 
	NULL as Source, 
	NULL as ServerReceiveDateTime,
	dbo.fnGetDateTime(StudyDate,StudyTime) as StudyDateTime, 	
	NULL as FinalizeDateTime, 
	NULL as ORU, 
	NULL as ReportEmailed, 
	NULL as ReportFaxed, 
	'Unassigned' as SignedOnTimeliness,
	NULL as TotalCharge ,
	NULL as OrderCount,
	NULL as ExamBilledCount,
	NULL as ExamBilledCountMay1,
	NULL as BilledCharge, 
	NULL as BilledChargeMay1, 
	NULL as InterpretedCount,				
	'1 - None or Empty' as FollowUp,
	PatientName, 
	PatientBirthDateTime, 
	PatientSex, 
	NULL as OrderStatus,
	NULL as ProfessionalRVU, 
	NULL as TechnicalRVU, 
	NULL as TotalRVU,
	ImageCount as NumberOfImages
				
from 
	DataLoadDailyCFind
					



GO