HealthStudMonitor (ver20.4.0)
This table stores student monitoring details such as monitoring type, date and time.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| HealthStudMonitorID | 20.4.0 | Number(16,0) | The unique sequential number generated by the application. Indexed. Required. |
| MonitoringType | 20.4.0 | Number(16,0) | Health monitoring types such as Diabetes. These types are maintained as CodeSet. The corresponding CodeSetID is stored in this field. A foreign key is in place to Codeset.CodeSetID. Required. |
| MonitoringDate | 20.4.0 | Date | The date of monitoring. Required. |
| MonitoringTime | 20.4.0 | TIMESTAMP(6) | The time of monitoring. The time value is stored as UNIX time. Required. |
| Notes | 20.4.0 | Varchar(2048) | Any monitoring notes required are stored in this field. Optional. |
| ScheduledEventID | 20.4.0 | Number(16,0) | A not null value indicates the record was created by the schedule with this scheduledEventID. Optional. |
| Status | 20.4.0 | Number(16,0) | CodeSetID corresponding to the status. Value values: Pending, Complete. Defaults to Pending' |
| StudentsDCID | 20.4.0 | Number(10,0) | DCID of the student for whom monitoring is recorded. Required. |
| 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. |