BEGIN
UPDATE dbo.Tbl_AP
SET [Work Area] = 'CPC'
FROM dbo.Tbl_AP T1
WHERE MRN_CPC_ONLY = 'YES' AND [Work Area] IS NULL
END


BEGIN
UPDATE dbo.Tbl_AP
SET [Work Area] = '65 YEARS AND OLDER'
FROM dbo.Tbl_AP T1
JOIN dbo.vw_65_And_Older T2 ON T1.[MEDICAL RECORD] = T2.[MEDICAL RECORD]
END


BEGIN
UPDATE dbo.Tbl_AP
SET [Work Area] = '$250.01 To $999.99'
FROM dbo.Tbl_AP T1
JOIN dbo.[vw_250_To_999] T2 ON T1.[MEDICAL RECORD] = T2.[MEDICAL RECORD]
WHERE [Work Area] IS NULL
END


BEGIN
UPDATE dbo.Tbl_AP
SET [Work Area] = 'GREATER THAN $1000'
FROM dbo.Tbl_AP T1
JOIN dbo.vw_Greater_Than_1000 T2 ON T1.[MEDICAL RECORD] = T2.[MEDICAL RECORD]
WHERE [Work Area] IS NULL
END


BEGIN
UPDATE dbo.Tbl_AP
SET [Work Area] = 'LESS THAN $250'
FROM dbo.Tbl_AP T1
JOIN dbo.vw_Less_Than_250 T2 ON T1.[MEDICAL RECORD] = T2.[MEDICAL RECORD]
WHERE [Work Area] IS NULL
END