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 '