CE Neurological SQL Functions

CASCO_CE_Neuro

Display the name of all selected neurological clinical effects and the value descriptor for the case.

 

Return Value:

Returns a text list of all selected neurological clinical effects with the value descriptor.

Parameters:

CaseNumber, CenterCode, YearCode: Uniquely Identifies the case for which the information should be returned

Delimiter: Characters to display for each separate value.

Value Descriptor:

0 = long description (e.g. Related, Not Related, etc.)

1 = short description (e.g. R, N, etc.)

Example:                              

(dbo.CASCO_CE_Neuro(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Neuro

CASCO_CE_Any_Neuro

Determine if any neurological clinical effects have been selected for the case.

 

Return Value:

Returns a value of 1 if any neurological clinical effect is selected.

Returns a value of 0 if no neurological clinical effects 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_CE_Any_Neuro(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_Neuro