List of ODBC key fields

Some ODBC key fields are common to all records, and some are specific to particular records. This section explains the ODBC key fields that are common to all records. You need ODBC key fields when you use SQL statements with PFM - Manager to access record data stored in the Store database.

The table below lists the ODBC key fields common to all records. For details about the ODBC key fields specific to particular records, see the descriptions of the records.

Table 9-2 List of ODBC key fields common to all records

ODBC key fieldODBC formatDataDescription
record-ID_DATESQL_INTEGERInternalRecord key field that indicates the record's creation date
record-ID_DATETIMESQL_INTEGERInternalCombination of the two fields record-ID_DATE and record-ID_TIME
record-ID_DEVICEIDSQL_VARCHARInternalName of the host where PFM - Agent is running
record-ID_DRAWER_TYPESQL_VARCHARInternal
Type. Valid values are as follows:
m: Minute
H: Hour
D: Day
W: Week
M: Month
Y: Year
record-ID_PROD_INSTSQL_VARCHARInternalInstance name of PFM - Agent
record-ID_PRODIDSQL_VARCHARInternalProduct ID of PFM - Agent
record-ID_RECORD_TYPESQL_VARCHARInternalIdentifier indicating the record type (4 bytes)
record-ID_TIMESQL_INTEGERInternalRecord creation time (Greenwich mean time (GMT))