Cdw.StudentPathwayCompletion_v

The following sql will create the cdw view from dbo table dbo.PathwayCompletion.

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Cdw].[StudentPathwayCompletion_v]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [Cdw].[StudentPathwayCompletion_v]
AS
SELECT  x.PathwayCompletionID,
		x.StudentID,
		x.PathwayID,
		x.CompletionDate,
		x.CompletionSchoolYear,
		x.ContributingCoursesPackedText,			
		x.IsDeleted,
		x.LastUpdateUtcTime,		
		CdwRowVersion = x.LastUpdateRowVersion
FROM dbo.PathwayCompletion x
' 

Business Objects Returned