List of ODBC key fields

Some ODBC key fields are common to all records, and some are specific to each record. This section presents the ODBC key fields common to all records. You need the ODBC key fields to use record data stored in the Store database by using SQL statements with PFM - Manager.

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

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

ODBC key fieldODBC formatDataDescription
record-ID_DATESQL_INTEGERInternalKey in the record that indicates the record creation date
record-ID_DATETIMESQL_INTEGERInternalCombination of the record-ID_DATE and record-ID_TIME fields
record-ID_DEVICEIDSQL_VARCHARInternalinstance-name[host-name]
record-ID_DRAWER_TYPESQL_VARCHARInternalType. 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 - RM for Oracle
record-ID_PRODIDSQL_VARCHARInternalProduct ID of PFM - RM for Oracle
record-ID_RECORD_TYPESQL_VARCHARInternalIdentifier indicating the record type (4 bytes)
record-ID_TIMESQL_INTEGERInternalRecord creation time (Greenwich mean time (GMT))