About the Calendar table
- Last UpdatedFeb 19, 2024
- 2 minute read
The Calendar table is used internally by AVEVA™ Production Management for things such as rates and thresholds, and exposed to external systems to support calendar lookup functionality. It is a generic flat out list of time and value pairs. There are no constraints on the table to enforce the uniqueness of ‘ActiveDateTime’ and ‘ItemName’ pair values.
The values stored inside are plain strings (null is allowed) instead of strongly-typed doubles. If a calendar item value is inserted or updated to null or some strings not compatible to double, it would result in Metrics calculations to return ‘Double.NaN’ (error) values.
Calendar attributes
The calendar consists mainly of ActiveDateTime and ItemValue pairs. The item name specifies a key in the calendar.
ItemName [ActiveDateTime, Item Value]
ItemName [ActiveDateTime, Item Value]
|
Attribute |
Description |
|---|---|
|
ItemName |
Name of identifying key in the calendar table. |
|
ActiveDateTime |
The time when the item value is active. When looking up the calendar for item values, AVEVA™ Production Management chooses the calendar entry with the most recent ActiveDateTime and uses its value. AVEVA™ Production Management stores all dates and time in UTC format. |
|
ItemValue |
Value that is associated with a specific ItemName and ActiveDateTime. |
|
Period |
Quantity of period types; for example 1 or 2. |
|
PeriodType |
Name of the period type that is used; for example, Week, Day, Hour. |
Update the Calendar with web services
AVEVA™ Production Management users require the correct permissions on the Calendar item before they can perform updates to value pairs in the Calendar table through web service methods. For more information, see Update Calendar values with web services.
Access the Calendar with document link
For information on accessing the Calendar, see Access the Calendar web page.