Static Database Fields – Computed Point Tables

The Master Computed Point table contains an entry for each analog or digital computed point that uses other points during its EU conversion . Each entry includes the number of source points used in the computation.

Structure name: compPointMst_t. Table base file name: CPMst. Table define: TBL_COMPPOINTSMST.

Member Name Key Range Type Description
cpm_MasterPid Unique 1 to 32767 WORD The PICS Point ID of the point that uses this input set for computation.
cpm_Revision    Any WORD Current revision of this record.
cpm_TableRevision    Any DWORD Current table version, when this record was last updated.
cpm_SourceCount    1 to 32766 WORD Total number of input points in this set.

Sets of source points are stored in this table. A set consists of all entries with the same cp_MasterPid value. Each entry contains the point id of one source point for the master point's EU conversion. The sequence number allows the conversion code to distinguish the one source point from another. The cp_MasterPid and cp_Sequence fields combined make a unique key for this table.

Structure name: compPoints_t. Table base file name: CompPnt. Table define: TBL_COMPPOINTS.

Member Name Key Range Type Description
cp_MasterPid Yes  1 to 32767 WORD Link to the cpm_MasterPid and pnt_Pid fields
cp_Sequence Yes  0 to 32766 WORD Sequence number (index) of this point within the input set.
cp_Revision    Any WORD Current revision of this record.
cp_TableRevision    Any DWORD Current table version, when this record was last updated.
cp_Pid    1 to 32767 WORD Source point ID

The Master Target Point table contains an entry for each point that will produce EU values and statuses for multiple points. The master point and all target points must be analog or digital computed points. Each entry includes the number of source points used in the computation.

Structure name: targetPntsMst_t. Table base file name: TPMst. Table define: TBL_TARGETSMST.

Member Name Key Range Type Description
tpm_MasterPid Unique  1 to 32767 WORD The PICS Point ID of a point whose computation also produces the EU values of this set of target points.
tpm_Revision    Any WORD Current revision of this record.
tpm_TableRevision    Any DWORD Current table version, when this record was last updated.
tpm_TargetCount    1 to 32766 WORD Total number of target points in this set.

Sets of target points are stored in this table. A set consists of all entries with the same tp_MasterPid value. Each entry contains the point id of one target point produced during the master point's EU conversion. The sequence number allows the conversion code to distinguish the one target point from another. The tp_MasterPid and tp_Sequence fields combined make a unique key for this table.

Structure name: targetPnts_t. Table base file name: TargetP. Table define: TBL_TARGETPNTS.

Member Name Key Range Type Description
tp_MasterPid Yes  1 to 32767 WORD Link to the tpm_MasterPid and pnt_Pid fields
tp_Sequence Yes 0 to 32766 WORD Sequence number (index) of this point within the output set.
tp_Revision    Any WORD Current revision of this record.
tp_TableRevision    Any DWORD Current table version, when this record was last updated.
tp_Pid    1 to 32767 WORD Target point ID