The Activity/Variance table shown here represents a sample WebSchedule™ Activity or Variance data table. The only difference between Activity and Variance data is the OriginalStartDateTimeUtc field for the Variance data cannot be null. All columns correspond with .NET properties that have the same name on an Activity or Appointment object, unless otherwise noted. If your custom data source publicly exposes property names matching the column name shown here, the field bindings will automatically occur. If you have different names, use the binding objects to specify the field bindings. For more information on data binding, see Data Binding.
The following shows the required fields you will need in order for WebScheduleGenericDataProvider™ to operate correctly:
| Column Name |
Data Type |
Null Allowed |
Remarks |
|
|
|
Primary Key. A numeric value uniquely identifying this Activity.
|
|
|
|
Starting date/time of the Activity represented in Universal Coordinated Time (UTC).
|
|
|
|
Length of the activity measured in seconds (3600 seconds = 1 hour).
|
|
|
|
Free-form text appearing as the Activity’s subject.
|
|
|
|
Free-form text describing additional details about the Activity.
|
|
|
|
Indicates whether the Activity spans an entire day. An all-day activity renders with a distinctive style.
|
|
|
|
Free-form text describing the location where the Activity takes place.
|
|
|
|
Indicates the Activity’s status code that is currently used for indicating whether or not a reminder notice of the Activity has already expired.
|
|
|
|
Indicates whether or not the primary Resource affiliated with this Activity requires a reminder notification.
|
|
|
|
The period (if time in seconds) before activity’s StartDateTimeUtc when a reminder notice should be given. Not used when EnableReminder is False.
|
|
|
|
Determines the color of the time bar for an Activity (not rendered by all WebSchedule views.)
|
|
|
|
Priority associated with this activity. Affects which "Importance" button is selected by default on the Edit Appointment dialog box.
|
|
|
|
Every activity requires a recurrence id. Non-recurring activities must reference -999, the key of the default Recurrence.
|
|
|
|
Determines the recurrence schedule.
|
|
|
|
Correlates a recurring root Activity with one or more of its variance data.
Each variance has a unique ID, but is related to it’s root Activity because both share the same GUID value in this column.
Non-recurring Activities, and recurring Activities having no variance data, will have a NULL value in this column.
|
|
|
|
Identifies an individual occurrence of a recurring Activity to be overridden with column values from this row by what the occurrence’s originally scheduled Start Date/Time (in UTC) would have been, based on it’s recurrence pattern.
Applies to variance data only, all others will have a NULL value in this column.
|
|
|
|
Timestamp that is used to detect concurrency conflicts.
|
|
|
|
Correlates to the Resource data that this activity belongs to.
|
