CE Respiratory SQL Functions

CASCO_CE_Resp

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

 

Return Value:

Returns a text list of all selected respiratory 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_Resp(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_Resp

CASCO_CE_Any_Resp

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

 

Return Value:

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

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