CASCO_All_Routes
Display the name of all selected routes for the case.
Return Value:
Returns a text list of all selected routes of exposure.
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_All_Routes(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) As AllRoutes
CASCO_Any_Route
Determine if any routes of exposure have been selected for the case.
Return Value:
Returns a value of 1 if any route of exposure is selected.
Returns a value of 0 if no routes of exposure 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_Any_Route(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) As AnyRoute