select * from [HL_VA_DATA].dbo.MetaData where FieldName like '%ill%' order by FieldKey
select * from [hl_va_dev_data].dbo.MetaData where FieldName like '%ill%' order by FieldKey

select * from [HL_VA_DATA].dbo.MetaDataField where FieldKey in (select FieldKey from MetaData where FieldName like '%ill%') order by FieldKey, FactTableName
select * from [hl_va_dev_data].dbo.MetaDataField where FieldKey in (select FieldKey from MetaData where FieldName like '%ill%') order by FieldKey, FactTableName
select top 10 * from [HL_VA_DATA].dbo.Exam where SigningRadiologistKey is not null order by ExamKey desc
--update [HL_VA_DATA].dbo.MetaData set DataTypeLength=null where FieldKey=2134
--update [HL_VA_DATA].dbo.MetaDataField set SqlFilter=null where FieldKey in (2078, 2083,2084,2086, 2117, 2130,2134,2144)
--update [HL_VA_DATA].dbo.MetaDataField set FactTableName='Exam' where (FactTableName='ExamWorkflow') AND (FieldKey in (2078, 2083,2084,2086, 2117, 2130,2134,2144))
--update [HL_VA_DATA].dbo.MetaDataField set TableName2='Exam' where (TableName2='ExamWorkflow') AND (FieldKey in (2078, 2083,2084,2086, 2117, 2130,2134,2144))
--update [HL_VA_DATA].dbo.MetaDataField set AliasName=cast(FieldKey as nvarchar(4))+'_' where (AliasName='CD') AND (FieldKey in (2078, 2083,2084,2086, 2117, 2130,2134,2144))
-- manually edit the fields - for AliasName, SqlFieldName, FactTableJoinKey, FactGroupName, ALiasName2 - set all EXWF to EX

select * from MetaDataValue where DataType = 'HLDate'
select * from MetaDataValue where MetaDataId in (Select distinct FieldKey from MetaData)

--create new column ProcedureLocationKey
--create new column QAHold
update Exam set ProcedureLocationKey=dsc.Id
   	from dim_SiteCode dsc
   inner join FillerOrder fo on LEFT(fo.FillerOrderNumber, 3) = dsc.Code
   inner join Exam ex on ex.FillerOrderKey=fo.FillerOrderKey

update Exam set QAHold=(case when fo.OrderLocation = 'QAHOLD' then 1 else 0 end) 
   	from dim_SiteCode dsc
   inner join FillerOrder fo on LEFT(fo.FillerOrderNumber, 3) = dsc.Code
   inner join Exam ex on ex.FillerOrderKey=fo.FillerOrderKey

--

select pr.*, tmp.* from tmp_uploaddoctors tmp
	inner join 
		Provider pr on (UPPER(tmp.FirstName) = UPPER(pr.FirstName)) 
		and (UPPER(tmp.LastName) = UPPER(pr.LastName))



Update Provider
	set 
		NTPRadiologistType=ud.RadType,
		ProviderType=ud.RadType
from
Provider xpr
inner join tmp_uploaddoctors ud on xpr.FirstName=ud.FirstName and xpr.LastName=ud.LastName and xpr.Role='RAD'
where Role='RAD'

select distinct ProviderType from Provider where Role='RAD'
select distinct (SigningRadiologistType) from ExamFlat
select distinct SigningRadiologistType from FTEDrillThru

update FTEDrillThru
	set SigningRadiologistType='Fee-Basis'
where SigningRadiologistType in ('Fee', 'FeeBasis')

update ExamFlat
	set SigningRadiologistType='Fee-Basis'
where SigningRadiologistType in ('Fee', 'FeeBasis')