Cdw.Pathway_v

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 

' 

Business Objects Returned