DateIntervals
Name: Date Intervals
Type: Application
Modules: Location Programs, Scheduling
Description: Definition of allowable dates for scheduling by booking.
| Field | Documentation |
|---|---|
| RuleId | Numeric identifier of the date interval. |
| SequenceId | Numeric identifier of the sequence (from the SequenceValues table). |
| MonthlySeqId | Hard-coded values for the days of the week to apply the date intervals (e.g., every other day, every 3 days). |
| WeekTemplate | 7-character string that denotes the days of the week (e.g., 0100100 means Monday and Thursday). |
| WeekendRuleId | Hard-coded values for the rule to apply to weekend bookings (e.g., Move to Friday, Ignore). |
| MatchCriteria | Hard-coded value for the criteria to match and apply (e.g., Some Match or All Match). |
| FromDate | Start date from which the date interval is valid. |
| ToDate | End date after which date interval is no longer valid. |
| ObjectId | Corresponding ID associated with the ObjectTypeLong field (e.g., if the ObjectTypeLong field is 15, then the ObjectID is the ProviderID). |
| Type | Hard-coded value for the type of rule (e.g., monthly, daily). |
| ObjectTypeLong | Hard-coded value that indicates what object type is related to the interval (bookings = 1, to do items = 2, runs = 3, interval summary = 4, location program = 5, client location program = 6, client = 7, holiday = 8, stop = 9, location = 10, employee = 11, passenger types = 12, client type = 13, polygon = 14, provider = 15, funding source = 16). |
| Comments | Comments about the record. |
| Id | The unique id of the date interval. |