SSMT: RID - Reference Range

Description

This page will explain how to load Reference Ranges for resultable items in v11.1.7. According to the ADBR, Reference Ranges change slightly in 11.2. This category can be used to load reference ranges for resultable items that are either text or numeric answer types. Different levels of reference range context can be specified and different SSMT fields will be utilized depending on the answer type of the resultable item.

Stored Procedures used:

• Extracting data: ImpGetReferenceRanges
• Loading data: ImpSetReferenceRanges

Column Listing and Descriptions 11.1.7

• Resultable Entry Code - this is the unique Entry Code value of the resultable item for which the reference range is being created or updated. This should directly reference the Entry Code value from the Resultable Item dictionary (RID).

• Resultable Entry Name - this is the Entry Name value of the resultable item for which the reference range is being created or updated. This should directly reference the Entry Name value from the RID.

• Where Performed - this is the Entry Name value of the Where Performed location for which the reference range is being created or updated. This should directly reference the Entry Name value from the Where Performed dictionary. It is possible for the same resultable item to have multiple reference range entries depending on the Where Performed value set when resulting the item.

• ReferenceRangeType - this value will determine what type of reference range will be set and will effect what fields can be utilized in this content category.
  • Default - set to this value to set reference range defaults for resultable items that have an answer type of Text.
  • Numeric - set to this value to set reference range defaults for resultable items that have an answer type of Numeric.

• SEX - this is the Entry Name value of the patient sex for which the reference range is being created or updated. This should directly reference the Entry Name value from the Sex dictionary. It is possible for the same resultable item to have multiple reference range entries depending on the patient sex when resulting the item.

• Lowestvalue - for numeric reference ranges - this is the lowest possible measurable value for the resultable item. A value other than 0 must be specified here in order for numeric reference ranges to generate a Flag value.

• PanicLowValue - for numeric reference ranges - this is the value for which a Panic Low abnormal Flag will be generated if met or exceeded. A value other than 0 must be specified here in order for numeric reference ranges to generate a Flag value.

• LowNormal - for numeric reference ranges - this is the value for which an Abnormal Low Flag will be generated if met or exceeded. A value other than 0 must be specified here in order for numeric reference ranges to generate a Flag value.

• HighNormal - for numeric reference ranges - this is the value for which an Abnormal High Flag will be generated if met or exceeded. A value other than 0 must be specified here in order for numeric reference ranges to generate a Flag value.

• PanicHighValue - for numeric reference ranges - this is the value for which a Panic High abnormal Flag will be generated if met or exceeded. A value other than 0 must be specified here in order for numeric reference ranges to generate a Flag value.

• HighestMeasureable - for numeric reference ranges - this is the highest possible measurable value for the resultable item. A value other than 0 must be specified here in order for numeric reference ranges to generate a Flag value.

• ReferenceText - this is the reference range that will actually display to the right of the resultable item when it is being resulted. This is more of a display field only and calculations for numeric reference ranges are not performed based on this field. It is more for display and compliance purposes.

• Answer -

• AbnormalFlag - acceptable values for this field are:
  • Y
  • N

• IsInActive - acceptable values for this field are:
  • Y - set to this value in order to remove the reference range value(s).
  • N - set to this value if already existing reference entries will be added or updated.

• Create - acceptable values for this field are:
  • Y - set to this value in order to add a new reference range value(s).
  • N - set to this value in order to update an already existing reference range.