TH Other 4 Category SQL Functions

CASCO_TH_Other4

Display the name of all selected other4 therapies and the value descriptor for the case.

 

Return Value:

Returns a text list of all selected other4 therapies 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. Recommended, Performed, etc.)

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

Example:

(dbo.CASCO_TH_Other4(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS TH_Other4

CASCO_TH_Any_Other4

Determine if any other4 therapies have been selected for the case.

 

Return Value:

Returns a value of 1 if any other4 therapy is selected.

Returns a value of 0 if no other4 therapies 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_TH_Any_Other4(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS TH_Any_Other4