CASCO_CE_HemeHep
Display the name of all selected Heme/Hep clinical effects and the value descriptor for the case.
Return Value:
Returns a text list of all selected Heme/Hep 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_HemeHep(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode, ', ', 0)) AS CE_HemeHep
CASCO_CE_Any_HemeHep
Determine if any Heme/Hep clinical effects have been selected for the case.
Return Value:
Returns a value of 1 if any Heme/Hep clinical effect is selected.
Returns a value of 0 if no Heme/Hep 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_HemeHep(ToxPat.CaseNumber, ToxPat.CenterCode, ToxPat.YearCode)) AS CE_Any_HemeHep
