Cdw.PathwayRequirement_v

The following sql will create the cdw view from CDA table Cda.PathwayRequirement.

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Cdw].[PathwayRequirement_v]'))
EXEC dbo.sp_executesql @statement = N'
CREATE VIEW [Cdw].[PathwayRequirement_v] 
AS 
SELECT  x.PathwayRequirementID,
	x.PathwayRequirementSetID,		
	x.NumberToComplete,		
	x.LastModifiedDateTime,	
	x.IsDeleted,
	CdwRowVersion = x.LastUpdateRowVersion
FROM cda.PathwayRequirement x

' 

Business Objects Returned