Cdw.PathwayRequirementSet_v

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

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

' 

Business Objects Returned