ScheduledEvent (ver20.4.0)
This table stores scheduled event details.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| CodeSetID | 20.4.0 | Number(16,0) | CodesetID corresponding to the type of schedule, such as Diabetes monitoring. Required. |
| Description | 20.4.0 | Varchar2(512) | Description of the scheduled event. |
| Duration | 20.4.0 | Number(16,0) | Duration of the actual event created by the schedule. Optional. |
| EndDate | 20.4.0 | Date | The end date of the scheduled event to which the events should be created. Required. |
| Friday | 20.4.0 | Number(1,0) | Valid values: 0=Excluded, 1=Included, an event record will be created for all Fridays between the start and end date based on IncludeNonSchoolDays. |
| IncludeNonSchoolDays | 20.4.0 | Number(1,0) | Valid values: 0=School in session days are only included, 1=All school calendar days are included. Defaults to 0. Required. |
| Monday | 20.4.0 | Number(1,0) | Valid values: 0=Excluded, 1=Included, an event record will be created for all Mondays between the start and end date based on IncludeNonSchoolDays. Defaults to 0. Required. |
| Saturday | 20.4.0 | Number(1,0) | Valid values: 0=Excluded, 1=Included, an event record will be created for all Saturdays between the start and end date based on IncludeNonSchoolDays. |
| ScheduledEventID | 20.4.0 | Number(16,0) | The unique sequential number generated by the application. Indexed. Required. |
| StartDate | 20.4.0 | Date | The start date of the scheduled event from which the events should be created. Required. |
| Status | 20.4.0 | Number(1,0) | Valid values: 0=Pending, original event records are not created, 1=Completed, original event records are created. |
| StudentDCID | 20.4.0 | Number(10,0) | DCID of the student for whom monitoring is done. Required. |
| Sunday | 20.4.0 | Number(1,0) | Valid values: 0=Excluded, 1=Included, an event record will be created for all Sundays between the start and end date based on IncludeNonSchoolDays. |
| Thursday | 20.4.0 | Number(1,0) | Valid values: 0=Excluded, 1=Included, an event record will be created for all Thursdays between the start and end date based on IncludeNonSchoolDays. |
| TimeOfDay | 20.4.0 | TIMESTAMP(6) | The time of the actual event created by the schedule. |
| Tuesday | 20.4.0 | Number(1,0) | Valid values: 0=Excluded, 1=Included, an event record will be created for all Tuesdays between the start and end date based on IncludeNonSchoolDays. |
| Wednesday | 20.4.0 | Number(1,0) | Valid values: 0=Excluded, 1=Included, an event record will be created for all Wednesdays between the start and end date based on IncludeNonSchoolDays. |
| 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. |