Code Tables Tab

Code Tables contain configuration for Forecast Monitor. The Code Tables dialog allows the user to add, edit, and delete various concepts used in Forecast Monitor. In addition, the dialog allows the user to configure and edit the Forecast Monitor display settings. The Code Tables settings are stored in a database table named CodeTypeList. The dialog box contains a drop-down menu for various categories. The dialog box is the same for each category. The panel on the left displays the list of codes currently configured for the selected category. The panel on the right displays properties for each of the codes:

  • CodeValueID. The ID for the code value.
  • DataValue. The data value associated with the code value (e.g., Actual, Forecast, Baseline, …)
  • Disporder. The display order for the code value.

The Code Tables dialog contains the following categories.

  • Data Concept. This contains configuration for the data concepts used in Forecast Monitor.
  • Display Decimals. The number of decimals to display for the data concept.
  • Color. This contains configuration for the colors used in the chart for each configured concept in Forecast Monitor.
  • Line Width. This contains configuration for the line width used in the chart for each configured concept in Forecast Monitor.
  • Plot on Y2 Axis. This contains configuration for the second y-axis.
  • Series Chart Type. This contains configuration for the chart type sed in Forecast Monitor.
  • Chart Marker Shape. This contains configuration for the chart markers used in Forecast Monitor.
  • Chart Display Order. This contains configuration for the chart display order used in Forecast Monitor.
  • Show Chart Markers. This contains configuration for the chart markers display used in Forecast Monitor.
  • Forecast Concept. This contains configuration for the forecast concepts used in Forecast Monitor.
  • Confidence Concept. This contains configuration for the Confidence Concepts used in Forecast Monitor.
  • Archive Concept. This contains configuration for the Archive Concepts used in Forecast Monitor.
  • Forecast/Confidence/Archive Concept to Export. This contains configuration for the Forecast, Confidence and Archive Concepts that are exported.
  • Confidence Interval. This contains configuration for the Confidence Intervals.
  • Confidence Z-Value. This contains the Z-Values used for computing the confidence bounds.
  • Confidence Interval/Concept. This maps the confidence intervals to the confidence concepts.
  • Forecast Validation Concept. This contains configuration for the forecast validation concepts.

Adding a Code Value

New Code Values can be added for new Forecast Concepts, Archive Concepts, and Confidence Concepts. The instructions to add values are as follows:

  • On the Code Tables tab of the System Settings dialog, select Data Concept from the drop down. Click the Add button. Enter the CodeValueID and DataValue for the new Data Concept. The CodeValueID is an internal identifier used to link the Code Value to other Code Value properties. The DataValue is used to specify the header ID in Forecast Monitor for the new Data Concept. Click OK to add the Data Concept.
  • Select Color from the drop down. Click the Add button. Enter the CodeValueID and DataValue for the new Data Concept. The CodeValueID should match the CodeValueID entered above. The DataValue is used to specify the color for the data series in Forecast Monitor. Click OK to add the color settings.
  • Select Forecast Concept, Archive Concept or Confidence Concept, depending on the concept type added, from the drop down. Click the Add button. Enter the CodeValueID and DataValue for the new Data Concept. The CodeValueID and DataValue should match the CodeValueID and DataValue entered above. Click OK to add the concept.
  • The following step is only necessary if you would like the data series for the new concept included in the forecast export. Select Forecast/Confidence/Archive Concept to Export from the drop down. Click the Add button. Enter the CodeValueID and DataValue for the new Data Concept. The CodeValueID and DataValue should match the CodeValueID and DataValue entered above. Click OK to add the concept.