Cdw.ExternalCredentialPathway_v

The following sql will create the cdw view from CDA table cda.ExternalCredentialPathway.

IF NOT EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[Cdw].[ExternalCredentialPathway_v]'))
EXEC dbo.sp_executesql @statement = N'CREATE VIEW [Cdw].[ExternalCredentialPathway_v]
AS
SELECT x.ExternalCredentialPathwayID,
	x.ExternalCredentialID,
	x.PathwayID,
	x.LastModifiedDateTime,		
	x.IsDeleted,
	CdwRowVersion = x.LastUpdateRowVersion
FROM cda.ExternalCredentialPathway x
' 

Business Objects Returned