List All SCCA Trials at Wenatchee Valley Medical Center

Wenatchee Valley Medical Center

query
RESULTSET
query
  ACTIVE CLINICALTRIALNETWORKAFFILIATEID CONTACTINFORMATION CREATEDATE FILENAMEPREFIX INTERNALNOTES NETWORKAFFILIATE REFERRALEMAIL SEARCHSUGGESTION SECTIONID SHORTDESCRIPTION SORTORDER THEKEY
1 1 7 [empty string] 2010-04-08 17:11:51.23 wenatchee [empty string] Confluence Health [empty string] [empty string] 220 [empty string] 4 cli7
CACHED false
EXECUTIONTIME 16
SQL SELECT ClinicalTrialNetworkAffiliates.ClinicalTrialNetworkAffiliateID, ClinicalTrialNetworkAffiliates.SectionID, ClinicalTrialNetworkAffiliates.FilenamePrefix, ClinicalTrialNetworkAffiliates.NetworkAffiliate, ClinicalTrialNetworkAffiliates.ContactInformation,ClinicalTrialNetworkAffiliates.ReferralEmail, ClinicalTrialNetworkAffiliates.ShortDescription, ClinicalTrialNetworkAffiliates.SearchSuggestion, ClinicalTrialNetworkAffiliates.InternalNotes, ClinicalTrialNetworkAffiliates.SortOrder, ClinicalTrialNetworkAffiliates.Active,'cli' + cast(ClinicalTrialNetworkAffiliates.ClinicalTrialNetworkAffiliateID as varchar) as theKey,ClinicalTrialNetworkAffiliates.CreateDate FROM ClinicalTrialNetworkAffiliates WHERE (1=1) AND ClinicalTrialNetworkAffiliates.ClinicalTrialNetworkAffiliateID = 7 AND ClinicalTrialNetworkAffiliates.active = 1