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 | Description |
|---|---|---|---|
| BloodGlucoseLevelValue | 20.4.0 | Number(10,0) | The actual sugar level is stored in this column. Valid values: 10 – 999. Optional. |
| BloodGlucoseLevel | 20.4.0 | Number(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. |
| CarbsAtMeal | 20.4.0 | Number(6,0) | Stores the number of carbohydrates consumed at the last meal (0-999). Optional. |
| CorrectionBolus | 20.4.0 | Number(6,1) | Stores the correction bolus dose required to reduce a high blood glucose level if applicable (-999.9-999.9). Optional. |
| UrineKetonesID | 20.4.0 | Number(16,0) | CodesetID corresponding to urine ketones level is stored in this column (large, moderate, none, small, trace). Optional. |
| DiabetesPumpID | 20.4.0 | Number(16,0) | CodesetID corresponding to the pump is stored in this column (changed to injection, refill reservoir, restart, site change, suspended). Optional. |
| HealthStudDiabetesMonitorID | 20.4.0 | Number(16,0) | The unique sequential number generated by the application. Indexed. Required. |
| HealthStudMonitorID | 20.4.0 | Number(16,0) | The monitoring ID stored in the HealthStudMonitor table. Foreign key to the HealthStudMonitor table. |
| MealBolus | 20.4.0 | Number(7,2) | Stores the bolus dose administered to cover the student’s meal or snack if applicable (0-999.9). Optional. |
| WhenCreated | 20.4.0 | Date | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 20.4.0 | Date | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 20.4.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. Required. |
| WhoModified | 20.4.0 | Varchar2(100) | The name of the person who modified the record. Defaults to user. Required. |