Cdw.AwardingOrganization_v

The following sql will create the cdw view from CDA table Cda.AwardingOrganization.

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Cdw].[AwardingOrganization_v]'))
EXEC dbo.sp_executesql @statement = N'
CREATE VIEW [Cdw].[AwardingOrganization_v] 
AS 
SELECT  x.AwardingOrganizationID,
	x.EnglishOrganizationName,
	x.FrenchOrganizationName,
	x.EffectiveStartDate,
	x.EffectiveEndDate,
	x.LastModifiedDateTime,	
	x.IsDeleted,	
	CdwRowVersion = x.LastUpdateRowVersion
FROM cda.AwardingOrganization x

' 

Business Objects Returned