|
|
|
|
The Point table contains an entry for each point in the system. This table is the master entry for each point. By accessing a point record, access to all other data in the database associated with this poiint can be found. Each entry includes text data about the point, the data provider indicator, much of the data needed by its provider to perform an EU conversion on it and information used to display the point properly..
Structure name: pointdb_t. Table base file name: Point. Table define: TBL_POINT.
| Member Name | Key | Range | Type | Description |
|---|---|---|---|---|
| pnt_Pid | Unique | 1 to 32767 | SHORT | Point ID number. Used to uniquely identify a data point throughout the PICS software. |
| pnt_Type | 1 to 13 | WORD | PICS Point Type. Defines the type of data this point represents. Used to determine which variant fields to use. Range 1..13 (AI, AC, AO, DI, DC, DO, PT, PM, SS, AW, BI, BO) | |
| pnt_Name | Unique | Pointname Characters | CHAR(16) | Point Name. Used on displays, reports, and selection dialogs. |
| pnt_Description | Description Characters | CHAR(32) | Point Description. Used on reports and in selection dialogs. | |
| pnt_Off_State_Name | Description Characters | CHAR(8) | (1) Digital OFF state name. This state name represents the ZERO (or FALSE) value for a digital point and will be used on displays and in reports. (2) Name of the Subsystem for Subsystem Status points. |
|
| pnt_On_State_Name | Description Characters | CHAR(8) | Digital ON state name. This state name represents the ONE (or TRUE) value for a digital point and will be used on displays and in reports. This field is not used for non-digital points. | |
| pnt_Engr_Units | Description Characters | CHAR(8) | Engineering units label. This label is used for all analog points. It contains the name of the units in which the analog value is presented (e.g. IPS, DEGF, PSIA, etc.) It will be used on displays and in reports. | |
| pnt_Suggested_Graphic | Description Characters | CHAR(16) | This field is currently unused in PICS. It is intended to store the name of a suggested graphic symbol to be used when rendering this point. | |
| pnt_Scan_Dependent_Name | Pointname Characters | CHAR(16) | (1) Name of the reference point for thermocouples. (2) Name of the base executable file for 8800 Subsystem Status points. |
|
| pnt_Display_Format | printf style string for a single value | CHAR(16) | A C [programming language] format string to be used when formatting analog values for display/reporting. This allows control of things like how many significant digits are shown and scientific notation. | |
| pnt_Revision | Any | WORD | Current revision of this point record. | |
| pnt_TableRevision | Any | DWORD | Table version, when this point record was last updated. | |
| pnt_DataProviderId | Yes | Any value in the Providers table in lookup.bin | WORD | ID code of the source for this data point. All points scanned by 8800's are "technically" provided by MUXCTL. This field is used by data provider applications to determine which points they should be providing. Providers use either their category name from SOH.h or match a name from the lookup table "Providers". |
| pnt_AlarmId | 0 to 65535 | WORD | Alarm ID or ZERO for points that do not have an alarm limit record. The alarm ID links this point record to a record in the AlmMst (alarm master) table. | |
| pnt_ConvSetId | 0 to 65535 | WORD | Zero for points with neither a conversion constant set nor a calculation set. If the most significant bit is zero, the remaining fifteen bits are the Conversion Constant Set ID (a link to the cnvConstMst (conversion constant master) table). If the most siignificant bit is one, the remaining fifteen bits are the Calculation Set ID (a link to the calcMst (calculation master) table. | |
| pnt_ConversionType | 0 to 65535 | WORD | Conversion Type. The meaning of the value in this field is dependent upon the Data Provider (and possibly on the type of 8800 (AV, CPI, etc)) that originates this point's value. It selects what type EU conversion to perform on the point. It is used by AI, AC, and DC point types. | |
| pnt_8800NodeAddress | Yes | 0 to 63 | WORD | 8800 ID number. This identifies the 8800 (or 8800 primary/backup pair) where a SCANNED point is processed. Links to the e8_8800 field. |
| pnt_Card_Number | WORD | Scanned point address information. The meaning of these fields varies by 8800 hardware type, and are used as supplemental information for some non-scanned points. | ||
| pnt_Card_Offset | WORD | |||
| pnt_Card_Type | WORD | |||
| pnt_A2D_Selection | WORD | |||
| pnt_Raw_Value_Compensation | -3.0e38 to +3.0e38 | FLOAT | This value is added to the points raw value before multipling it by the gain. Thus, this represents the negative of the value which the A/D would provide with a zero signal is applied. | |
| pnt_Gain | -3.0e38 to +3.0e38 | FLOAT | After the raw value is compensated, it is multiplied by the gain. The gains unit's are those needed to convert the raw value's units to the units input into the engineering units conversion. | |
| pnt_Filter | 0 to 99 | WORD | After gain compensation has been applied, filtering is applied. Currently, the only filtering method is digtal decay averaging to produce an exponitially weighted average. A value of 0 provides no filtering. A value from 1 to 99 is the percentage to use of the previous filtered value. 100 minus this filter value is the percentage to use of the current raw value. These two values are added together to give the new filtered raw value. Values above 99 are reserved for future filtering types. | |
| pnt_EU_Low | -3.0e38 to +3.0e38 | FLOAT | Default low limit for DISPLAY of this point. | |
| pnt_EU_High | -3.0e38 to +3.0e38 | FLOAT | Default high limit for DISPLAY of this point. | |
| pnt_SetMask | 0 to 0xFFFFFFFF | DWORD | Links to ds_Mask in dispSet. (not currently used by PICS) | |
| pnt_Display_Color | 0 to 255 | WORD | Suggested color for this point's value on displays. This field uses several canned color sets plus any user defined colors. See evColor. | |
| pnt_Alarm_Hold_Msg | 0 to 65535 | WORD | Alarm hold message ID (not currently used by PICS) | |
| pnt_Alarm_Resume_Msg | 0 to 65535 | WORD | Alarm resume message ID (not currently used by PICS) | |
| pnt_Alarm_Group_Number | 0 to 65535 | WORD | Alarm Group Number indicates the alarm group this point is a member. Zero represents not a member of any group. (not currently used by PICS) | |
| pnt_Alarm_Group_Master | 0 to 65535 | WORD | Alarm Group Master indicates the alarm group with this point as the master. Zero represents not the master of any alarm group. (not currently used by PICS) | |
| pnt_PidTrans | 0 to 32767 | WORD | Point ID on the source PICS. This field is used by PICS Bridging software to transport data from one PICS to another by use of pnt_Pid. | |
| pnt_Arch_Refresh_Interval | 0 to 32767 | SHORT | Archive refresh interval (in seconds). Zero means to archive all data. | |
| pnt_Arch_Sig_Change | 0.0 to 3.0e38 | FLOAT | Archive Significant Change threshold. Zero means to archive all changes. |
|
|
|
|