Static Database Fields – Conversion Tables

The Master Conversion Constant table contains an entry for each defined set of conversion constants. Each entry includes the number of conversion constants in the set, how many points use this set, and a description of the conversion constant set.

Structure name: cnvConstMst_t. Table base file name: CCMst. Table define: TBL_CONVCONSTMST.

Member Name Key Range Type Description
ccm_ConvSetId Yes  1 to 65535 WORD Link from pnt_ConvSetId. Also link to cc_ConvSetId
ccm_Revision    Any WORD Current revision of this record.
ccm_TableRevision    Any DWORD Table version, when this record was last updated.
ccm_UserCount    1 to 32767 WORD The total number of points that reference this record
ccm_ConstantCount    1 to 32 WORD The number of conversion constant detail records
ccm_Desc    Description Characters CHAR(64) Text description of this conversion constant set

Sets of conversion constants are stored in this table. A set consists of all entries with the same cc_ConvSetId value. Each entry contains one conversion constant in the set and a description of that constant. The constants are ordered by their cc_Sequence value. The cc_ConvSetId and cc_Sequence fields combined make a unique key for this table.

Structure name: cnvConst_t. Table base file name: CnvConst. Table define: TBL_CONVCONST.

Member Name Key Range Type Description
cc_ConvSetId Yes  1 to 65535 WORD Link from the ccm_ConvSetId field.
cc_Sequence Yes  0 to 31 WORD Sequence number (index) of this constant within the set. NOTE: A set must have sequence numbers starting at 0 and ending at (ccm_ConstantCount - 1).
cc_Revision    Any WORD Current revision of this record.
cc_TableRevision    Any DWORD Table version, when this record was last updated.
cc_Const    Any DOUBLE Value of the constant.
cc_Desc    Description Characters CHAR(64) Description of this constant.

The Conversion Types table contains an entry for each defined set of conversion type. Each entry includes the name of the function for performing the conversion and which dll it is in. It also contains the amount of auxillary memory needed per point by the function.

Structure name: convType_t. Table base file name: ConvType. Table define: TBL_CONVTYPE.

Member Name Key Range Type Description
ct_ConversionType Yes  1 to 32767 SHORT Link from the least significant 15 bits of pnt_ConversionType when its most significant bit is not set. Also link to ctt_ConversionType.
ct_Revision    Any WORD Current revision of this record
ct_TableRevision    Any DWORD Current table version, when this record was last updated.
ct_AuxMemory    Any WORD Amount of auxiliary memory required by this conversion
ct_DllName    NT Filename Characters CHAR Name of the DLL file that contains the conversion function.  When this field is empty, the conversion will be coded directly into the data provider application.
ct_FuncName   C FunctionName Characters CHAR Name of the conversion function in the DLL

Text information describing conversion types is not used by PICS software (except the database editor). It is included for use in customer documentation.

Structure name: convTypeText_t. Table base file name: ConvTt. Table define: TBL_CONVTT.

Member Name Key Range Type Description
ctt_ConversionType Yes  1 to 32767 SHORT Link from the ct_ConversionType and pnt_ConversionType fields.
ctt_Name    Description Characters CHAR(64) Name of this conversion type
ctt_Revision    Any WORD Current revision of this record.
ctt_TableRevision    Any DWORD Current table version, when this record was last updated.
ctt_Equation    Description Characters CHAR(256) Conversion equation (text)
ctt_Explanation    Description Characters CHAR(2048) Conversion explanation
ctt_Reference    Description Characters CHAR(256) Reference material
ctt_UnitsIn    Description Characters CHAR(8) Input units
ctt_UnitsOut    Description Characters CHAR(8) Output units
ctt_Input_Desc    Description Characters CHAR(1024) Description of the inputs required