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 '