Time Series Generic Table

Use the Time Series Generic table to specify time-sensitive changes to variables in other tables. Aurora provides a generalized and uniform reference format to all the time series tables.

NOTE: Data in this table cannot be used for Computational Datasets input.

You can use this table in either Override Mode or Pattern Mode (both modes cannot exist for a given ID at the same time):

 NOTE: When using override mode, reference records to the Time Series Monthly to Time Series Weekly tables can also be used to produce a repeatable pattern.

 NOTE: When using pattern mode, the pattern can be updated at any point in time. The updated pattern then will be used unless subsequent records override this pattern as well.

How to Reference the Time Series Generic table:

References to data series in the Data column of the Time Series Generic table may have one of the following formats:

 

TS_ID or TS_ID|Data

where ID is the name of the data series in the ID column and Data is the Data column.

 

 NOTE: Multiple custom data columns can be added to a Time Series Generic table, however a column called "Data" must exist in the table even when multiple custom data columns have been added.

Multiple data columns, with user-specified (or custom) column names, can be added and referenced using the following format:

 

TS_ID|CustomDataColumn

where CustomDataColumn is the name of the custom data column being referenced in the Time Series Generic table.  In the example table below "PlusBasis" is a custom column and would be reference as TS_NGHenry|PlusBasis.

 

 NOTE: Column names starting with "zREM" are assumed to be remark columns (for user notes) and will be ignored.

 NOTE: More detailed time periods will override less detailed data in the table. For example, if annual (Time Series Annual) and monthly (Time Series Monthly) data is in the table, the monthly-level data will be applied.

For information on how to specify a time series for a variable, see Entering a Time Series.

COLUMNS INCLUDE

Data

Day

Hour

ID

Month

Nominal

Pattern

Primary Key

Year

Input Tables

Time Series Generic Table


For further assistance, please contact Aurora Support.

Copyright© 1997-2024 Energy Exemplar LLC. All rights reserved.