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 '