CE Cardiovascular SQL Functions

CASCO_CE_Cardio

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

 

Return Value:

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

CASCO_CE_Any_Cardio

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

 

Return Value:

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

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