SC Confusion Category SQL Functions

CASCO_SC_Conf

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

 

Return Value:

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

CASCO_SC_Any_Conf

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

 

Return Value:

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

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