.Data.<table>
- Last UpdatedFeb 07, 2023
- 1 minute read
- PI System
- PI OLEDB Enterprise 2019
- Developer
All data tables and Table-Valued Functions in the Data schema share the columns listed in the table below. They are represented by ... in the data tables and Table-Value Functions which follow this topic.
|
Name |
Data type |
Is nullable? |
Primary Key |
|---|---|---|---|
|
Time |
DateTime |
No |
Yes |
|
Value |
Variant |
Yes |
No |
|
ValueInt |
Int64 |
Yes |
No |
|
ValueDbl |
Float64 |
Yes |
No |
|
ValueStr |
String |
Yes |
No |
|
ValueGuid |
GUID |
Yes |
No |
|
ValueDateTime |
DateTime |
Yes |
No |
|
Status * |
Int32 |
No |
No |
|
Annotated |
Boolean |
No |
No |
|
IsGood |
Boolean |
No |
No |
|
Questionable |
Boolean |
No |
No |
|
Substituted |
Boolean |
No |
No |
* For allowed values of the Status column, see the topic AFValueStatus Enumeration in AF SDK Reference documentation.
The following data tables and Table-Valued Functions show only the specific columns.