Skip to main content
Skip table of contents

HealthStudMonitor (ver20.4.0)

This table stores student monitoring details such as monitoring type, date and time.

Column Name

Initial Version

Data Type


HealthStudMonitorID20.4.0Number(16,0)The unique sequential number generated by the application. Indexed. Required.
MonitoringType20.4.0Number(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.
MonitoringDate20.4.0DateThe date of monitoring. Required.
MonitoringTime20.4.0TIMESTAMP(6)The time of monitoring. The time value is stored as UNIX time. Required.
Notes20.4.0Varchar(2048)Any monitoring notes required are stored in this field. Optional.
ScheduledEventID20.4.0Number(16,0)A not null value indicates the record was created by the schedule with this scheduledEventID. Optional.
Status20.4.0Number(16,0)CodeSetID corresponding to the status. Value values: Pending, Complete. Defaults to Pending'
StudentsDCID20.4.0Number(10,0)DCID of the student for whom monitoring is recorded. Required.
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.