Static Database Fields – Calculation Tables

The Master Calculation table contains an entry for each defined set of calculation steps. Each entry includes the number of calculation steps for the set, how many points use this set, a description of the calculation and a list of point names used in the calulation.

Structure name: calcmst_t. Table base file name: CalcMst. Table define: TBL_CALCMST.

Member Name Key Range Type Description
calm_Id Yes  1 to 32767 WORD Link from the least significant 15 bits of pnt_ConversionType when its most significant bit is set. Also links to cal_Id
calm_Revision    Any WORD Table version, when this record was last updated.
calm_TableRevision    Any DWORD Table version, when this record was last updated.
calm_UserCount    1 to 32767 WORD Total number of points that use this calculation set
calm_StepCount    1 to TBD WORD Total number of steps in this calculation set
calm_Desc    Description Characters CHAR(256) Description of this calculation
calm_PntNameList   Pointname Characters  CHAR(16*16) A sixteen element array of point names.  (This is intended to allow the use of the EU values from other points as part of a calculation.)

Sets of calculation steps are stored in this table. A set consists of all entries with the same cal_Id value. Each entry contains both the expression and description of one step in a calculation. The steps are ordered by their cal_Sequence value. The cal_Id and cal_Sequence fields combined make a unique key for this table.

Structure name: calcs_t. Table base file name: Calcs. Table define: TBL_CALCS.

Member Name Key Range Type Description
cal_Id Yes  1 to 32767 WORD Link to the calm_Id field.
cal_Sequence Yes  0 to TBD WORD Sequence number (index) of this step within the calculation sequence. NOTE: A set must have sequence numbers starting at 0 and ending at (calm_StepCount - 1).
cal_Revision    Any WORD Current revision of this record.
cal_TableRevision    Any DWORD Current table version, when this record was last updated.
cal_Step    TBD CHAR(128) Calculation step expression (TBD).
cal_StepDesc   Description Characters CHAR(256) Calculation step description