AutoCollect DELTA Database › Delta Column information

Delta Column information

Following the identification columns, the balance of the Delta rows contains columns extracted from the Snapshot tables. In most cases, these columns have the same column name and the same definition as the columns in the DST tables. For a DST row, the value for the column is based off the activity since the beginning of the MUF enable. For a Delta row, the column value is specific to the time period that the Delta represents.

In the table layouts provided next, each column is prefixed with an indicator. These indicators tell you how each Delta column's content was constructed.

I

Identification column built during Delta row creation as follows:

• For the Interval or Last rowset, the value is copied from the ending Snapshot row.
• For the Summary, AVGPERF or Baseline rowset, the value is copied from the last delta rowset selected for processing.

IS

Identification column built during Delta row creation as follows:

• For the Interval or Last rowset, the value is copied from the starting Snapshot row.
• For the Summary, AVGPERF or Baseline rowset, the value is copied from the earliest delta rowset selected for processing.

L

Fixed value taken from the ending input row as follows:

• For the Interval or Last rowset, the value is copied from the ending Snapshot row.
• For the Summary, AVGPERF or Baseline rowset, the value is copied from the last row selected for processing.

D

Value was a "delta value" calculated as follows:

• For the first Interval rowset (created from first Snapshot after MUF enable), the delta values are calculated by subtracting "0" from the Snapshot value.
• For each Interval rowset after the "first" rowset processing, the value is calculated by subtracting the beginning Snapshot column/row value from the ending Snapshot column/row value.
• For the Last rowset (created for last Snapshot per MUF execution and is to represent the entire MUF execution), the delta values are calculated by subtracting "0" from the Snapshot column/row value.
• For a Summary rowset, the value is calculated by adding the values from each of the Delta rows selected to be summarized into this new Delta rowset.
• For a Baseline rowset, the value is calculated by adding the values from each of the Delta rows selected to be processed. Once all rows are added in, the values are divided by the number of rowsets processed to build a Baseline average.
• For an AVGPERF, the value is calculated by adding the values from each of the Delta rows selected to be processed. Once all rows are added in, the value is divided by the duration total hours processed to build an AVGPERF rowset based on one standard duration hour.

R

Value is a ratio value built by dividing one column by another column. Ratio columns are only built in the two special Delta ratio tables.

U

Value is assigned by the user using the OUTTAG option on selected AUTOCOLL functions.