HealthStudentPlan (ver20.4.0)
This table stores template details for general purposes. These templates are consumed by different modules such as Health and Incidents.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| Description | 20.4.0 | Varchar2(512) | Health plan description. Optional. |
| DistrictAddedRecord | 20.4.0 | Number(1) | This column indicates whether the plan record was added by the district. Optional. |
| EndDate | 20.4.0 | Date | End date for the health plan. Optional. |
| HealthStudentPlanID | 20.4.0 | Number(16,0) | The unique sequential number generated by the application. Indexed. Required. |
| HealthPlanData | 20.4.0 | CLOB | Health data is stored in this column. |
| HealthPlanName | 20.4.0 | Varchar2(100) | Name of the Health Plan. Required. |
| SchoolAddedRecord | 20.4.0 | Number(1) | This column indicates whether the plan record was added by the school. Optional. |
| StartDate | 20.4.0 | Date | The start date for the health plan. Defaults to SYSDATE. Required. |
| Status | 20.4.0 | Varchar2(50) | CodeSetID corresponding to the status. Valid values: Draft, Complete, Ended. Defaults to Draft. Optional. |
| StudentsDCID | 20.4.0 | Number(10,0) | Student DCID. Required. |
| TemplateID | 20.4.0 | Number(16,0) | Id of the template used to create the health plan. TemplateID field. Optional. |
| VersionModTime | 20.4.0 | Date | The date and time used for ReadReceipt.documentVersion tracking. Updated when the status is Completed and HealthPlanData changes. |
| 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. |