List of ODBC key fields
Some ODBC key fields are common to all records while others are unique to some records. This section shows the ODBC key fields that are common to all records. For PFM - Manager to use the record data stored in the Store database, ODBC key fields are required.
The table below shows a list of ODBC key fields common to all records. For details about the ODBC key fields unique to each record, see the explanation of each record.
ODBC key fields |
ODBC format |
Data |
Explanation |
---|---|---|---|
record-id_DATE |
SQL_INTEGER |
Internal |
Record key indicating the date on which the record was created |
record-id_DATETIME |
SQL_INTEGER |
Internal |
Combination of the record-id_DATE field and the record-id_TIME field |
record-id_DEVICEID |
SQL_VARCHAR |
Internal |
Name of the host on which PFM - Agent is running |
record-id_DRAWER_TYPE |
SQL_VARCHAR |
Internal |
Category. The following values are valid: m: Minute H: Hour D: Day W: Week M: Month Y: Year |
record-id_PROD_INST |
SQL_VARCHAR |
Internal |
Name of the PFM - Agent instance |
record-id_PRODID |
SQL_VARCHAR |
Internal |
PFM - Agent's product ID |
record-id_RECORD_TYPE |
SQL_VARCHAR |
Internal |
Record type identifier (4 bytes) |
record-id_TIME |
SQL_INTEGER |
Internal |
Time at which the record was created (Greenwich Mean Time) |