Data Model for the ResourcePreference Table
The Activity table identifies a WebSchedule™ Activity or Appointment, and describes when and where it takes place, and how reminder notifications should be given. All columns correspond with .NET properties that have the same name on an Activity or Appointment object, unless otherwise noted.
Columns marked with an asterisk (*) in the following table are new or have been modified for the WebSchedule Data Model in Ultimate UI for ASP.NET 2006 Volume 2 and later.
| 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.)
1 - Tentative (Light Blue)
3 - Out of Office (Purple)
|
|
|
|
Priority associated with this activity. Affects which "Importance" button is selected by default on the Edit Appointment dialog box.
|
|
|
|
Foreign key identifying a row from the Recurrence table describing the recurring pattern for this Activity, if this Activity recurs.
Non-recurring Activities must reference -999, the key of the default Recurrence.
|
|
|
|
Correlates a recurring root Activity with one or more of it’s variance rows.
Each variance has a unique ActivityID, 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 rows, will have a NULL value in this column.
|
*OriginalStartDateTimeUtc
|
|
|
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 rows only, all others will have a NULL value in this column.
|
|
|
|
Timestamp that is used to detect concurrency conflicts.
|
