CREATE VIEW [dbo].[pal_vAccountsVerifiedMSV]
AS
SELECT	DISTINCT A.surfaceItemId
FROM	pal_Account A
		JOIN pal_MSMsvResponse R
			ON R.membershipNumber = A.medAidNumber
		JOIN pal_MSMsvResponsePatient P
			ON P.patientDOB = A.birthDate
			AND P.msvResponseId = R.recId


GO


