HealthStudTreatmentAssoc (ver20.4.0)
This table stores student treatments required corresponding to the record in HeathStudMonitor table. A foreign key is in place for many to one relationship between these two tables.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
HealthStudMonitorID | 20.4.0 | Number(16,0) | The monitoring ID stored in the HealthStudMonitor table. Foreign key to the HealthStudMonitor table. Required. |
HealthStudTreatmentAssocID | 20.4.0 | Number(16,0) | The unique sequential number generated by the application. Indexed. Required. |
HealthTreatmentCodeID | 20.4.0 | Number(16,0) | Codeset ID corresponding to the treatment codes such as avoid exercise, contacted parent, correction bolus, encourage exercise, encourage water, fast acting glucose, protein snack, sent home. 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. |