CASCO_SC_Pesticide
Display the name of all selected pesticide scenarios for the case.
Return Value:
Returns a text list of all pesticide scenarios.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Delimiter: Characters to display for each separate value.
Example:
(dbo.CASCO_SC_Pesticide(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_Pesticide
CASCO_SC_Any_Pesticide
Determine if any pesticide scenarios have been selected for the case.
Return Value:
Returns a value of 1 if any pesticide scenario is selected.
Returns a value of 0 if no pesticide scenarios are selected.
Parameters:
CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned
Delimiter: Characters to display for each separate value.
Example:
(dbo.CASCO_SC_Any_Pesticide(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_Pesticide
