The following sql will create the cdw view from CDA table Cda.Pathway.
IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Cdw].[Pathway_v]')) EXEC dbo.sp_executesql @statement = N' CREATE VIEW [Cdw].[Pathway_v] AS SELECT x.PathwayID, x.PathwayCode, x.EnglishPathwayName, x.FrenchPathwayName, x.EffectiveStartSchoolYear, x.EffectiveEndSchoolYear, x.LastModifiedDateTime, x.IsDeleted, CdwRowVersion = x.LastUpdateRowVersion FROM cda.Pathway x '