The following text can be copied and pasted directly into the Select portion of the custom display builder.
Be sure to choose the “Auto From Criteria” checkbox in “Advanced Query Options”.
Sample Screenshot:
Sample Select Statement:
Select
ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode,
(dbo.CASCO_Version_Text()) As 'CASCO Version Text',
(dbo.CASCO_All_Routes(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) As AllRoutes,
(dbo.CASCO_Any_Route(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) As AnyRoute,
(dbo.CASCO_All_Clinical_Effects(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS All_ClinicalEffects,
(dbo.CASCO_Any_Clinical_Effect(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS Any_ClinicalEffect,
(dbo.CASCO_CE_Cardio(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Cardio,
(dbo.CASCO_CE_Any_Cardio(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Cardio,
(dbo.CASCO_CE_Dermal(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Dermal,
(dbo.CASCO_CE_Any_Dermal(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Dermal,
(dbo.CASCO_CE_Gastro(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Gastro,
(dbo.CASCO_CE_Any_Gastro(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Gastro,
(dbo.CASCO_CE_HemeHep(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_HemeHep,
(dbo.CASCO_CE_Any_HemeHep(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_HemeHep,
(dbo.CASCO_CE_Neuro(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Neuro,
(dbo.CASCO_CE_Any_Neuro(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Neuro,
(dbo.CASCO_CE_Resp(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Resp,
(dbo.CASCO_CE_Any_Resp(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Resp,
(dbo.CASCO_CE_Ocular(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Ocular,
(dbo.CASCO_CE_Any_Ocular(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Ocular,
(dbo.CASCO_CE_Renal(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Renal,
(dbo.CASCO_CE_Any_Renal(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Renal,
(dbo.CASCO_CE_Misc(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Misc,
(dbo.CASCO_CE_Any_Misc(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Misc,
(dbo.CASCO_All_Therapies(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS All_Therapies,
(dbo.CASCO_Any_Therapy(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS Any_Therapy,
(dbo.CASCO_TH_Dec(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS TH_Dec,
(dbo.CASCO_TH_Any_Dec(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS TH_Any_Dec,
(dbo.CASCO_TH_Other1(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS TH_Other1,
(dbo.CASCO_TH_Any_Other1(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS TH_Any_Other1,
(dbo.CASCO_TH_Other2(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS TH_Other2,
(dbo.CASCO_TH_Any_Other2(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS TH_Any_Other2,
(dbo.CASCO_TH_Other3(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS TH_Other3,
(dbo.CASCO_TH_Any_Other3(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS TH_Any_Other3,
(dbo.CASCO_TH_Other4(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS TH_Other4,
(dbo.CASCO_TH_Any_Other4(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS TH_Any_Other4,
(dbo.CASCO_All_Scenarios(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS All_Scenarios,
(dbo.CASCO_Any_Scenario(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS Any_Scenario,
(dbo.CASCO_SC_Dose(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_Dose,
(dbo.CASCO_SC_Any_Dose(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_Dose,
(dbo.CASCO_SC_Vapor(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_Vapor,
(dbo.CASCO_SC_Any_Vapor(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_Vapor,
(dbo.CASCO_SC_CRC(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_CRC,
(dbo.CASCO_SC_Any_CRC(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_CRC,
(dbo.CASCO_SC_Access(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_Access,
(dbo.CASCO_SC_Any_Access(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_Access,
(dbo.CASCO_SC_Conf(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_Conf,
(dbo.CASCO_SC_Any_Conf(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_Conf,
(dbo.CASCO_SC_Pesticide(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_Pesticide,
(dbo.CASCO_SC_Any_Pesticide(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_Pesticide,
(dbo.CASCO_SC_Misc(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_Misc,
(dbo.CASCO_SC_Any_Misc(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_Misc,
(dbo.CASCO_Sub_NameList(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, Char(10), ', ', 0, 3)) As 'Substance_List',
(dbo.CASCO_AgeRange_A(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_A,
(dbo.CASCO_AgeRange_Years(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS AgeRange_Years
Note: The Select statement includes the CaseNumber, CenterCode, and YearCode data columns. By including these columns you will be able to open the case window for edit and review while using the custom display.