HealthStudentHealth (ver19.11.0)
This table contains other student health data. IMPORTANT NOTE: This table should NOT be extended. It is processed in tandem with the HealthMisc table. Any extensions for this data should be made to the HealthMisc table so it is available on the pages.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
BusProtocol | 19.11.0 | Varchar2(4000) | Bus protocol notes. |
| EmergencyPlan | 19.11.0 | Varchar2(4000) | Emergency plan. |
| HealthNotes | 19.11.0 | Varchar2(4000) | Health notes. |
| History | 19.11.0 | Varchar2(4000) | Student health history. |
| ID | 19.11.0 | Number(19,0) | Unique sequential number generated by the application. Indexed. Required. |
| IndividualPlan | 19.11.0 | Varchar2(4000) | Individual health plan. |
| MCC | 19.11.0 | Varchar2(1) | Uses school based health clinic. Valid values: 0=No, 1=Yes. Required, |
| MCCFirstYear | 19.11.0 | Varchar2(5) | First year. |
| StudentsDCID | 19.11.0 | Number(19,0) | DCID of the student this medication is for. Indexed. Required |
| TechAssistance | 19.11.0 | Varchar2(4000) | Technical assistance notes. |
| WhenCreated | 19.11.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 19.11.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 19.11.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. Required. |
| WhoModified | 19.11.0 | Varchar2(100) | The name of the person who modified the record. Defaults to user. Required. |