SC Dosing Category SQL Functions

CASCO_SC_Dose

Display the name of all selected dosing scenarios for the case.

 

Return Value:

Returns a text list of all dosing 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_Dose(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ')) AS SC_Dose

CASCO_SC_Any_Dose

Determine if any dosing scenarios have been selected for the case.

 

Return Value:

Returns a value of 1 if any dosing scenario is selected.

Returns a value of 0 if no dosing 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_Dose(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS SC_Any_Dose