Skip to main content
Skip table of contents

HealthStudDiabetesMonitor (ver20.4.0)

This table stores student monitoring results corresponding to the record in HeathStudMonitor table. A foreign key is in place for 1:1 relationship between these 2 tables.

Column Name

Initial Version

Data Type


BloodGlucoseLevelValue20.4.0Number(10,0)The actual sugar level is stored in this column. Valid values: 10 – 999. Optional.
BloodGlucoseLevel20.4.0Number(16,0)This column stores blood sugar levels such as Low, High or actual sugar levels. If the actual sugar level option is present in this column the corresponding value is stored in the BloodGlucoseLevelValue column. Optional.
CarbsAtMeal20.4.0Number(6,0)Stores the number of carbohydrates consumed at the last meal (0-999). Optional.
CorrectionBolus20.4.0Number(6,1)Stores the correction bolus dose required to reduce a high blood glucose level if applicable (-999.9-999.9). Optional.
UrineKetonesID20.4.0Number(16,0)CodesetID corresponding to urine ketones level is stored in this column (large, moderate, none, small, trace). Optional.
DiabetesPumpID20.4.0Number(16,0)CodesetID corresponding to the pump is stored in this column (changed to injection, refill reservoir, restart, site change, suspended). Optional.
HealthStudDiabetesMonitorID20.4.0Number(16,0)The unique sequential number generated by the application. Indexed. Required.
HealthStudMonitorID20.4.0Number(16,0)The monitoring ID stored in the HealthStudMonitor table. Foreign key to the HealthStudMonitor table.
MealBolus20.4.0Number(7,2)Stores the bolus dose administered to cover the student’s meal or snack if applicable (0-999.9). Optional.
WhenCreated20.4.0DateThe date and time the record was created. Defaults to system date. Required.
WhenModified20.4.0DateThe date and time the record was modified. Defaults to system date. Required.
WhoCreated20.4.0Varchar2(100)The name of the person who created the record. Defaults to user. Required.
WhoModified20.4.0Varchar2(100)The name of the person who modified the record. Defaults to user. Required.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.