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. The ODBC key fields are necessary to use the data retrieved from records stored in the Store database on 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.
|
ODBC key field |
ODBC format |
Data |
Description |
|---|---|---|---|
|
record-ID_DATE |
SQL_INTEGER |
Internal |
Key in the record that indicates the record creation date |
|
record-ID_DATETIME |
SQL_INTEGER |
Internal |
Combination of the record-ID_DATE and record-ID_TIME fields |
|
record-ID_DEVICEID |
SQL_VARCHAR |
Internal |
instance-name[host-name] |
|
record-ID_DRAWER_TYPE |
SQL_VARCHAR |
Internal |
Type. Valid values are as follows: m: Minute H: Hour D: Day W: Week M: Month Y: Year |
|
record-ID_PROD_INST |
SQL_VARCHAR |
Internal |
Instance name of PFM - RM for Oracle |
|
record-ID_PRODID |
SQL_VARCHAR |
Internal |
Product ID of PFM - RM for Oracle |
|
record-ID_RECORD_TYPE |
SQL_VARCHAR |
Internal |
Identifier indicating the record type (4 bytes) |
|
record-ID_TIME |
SQL_INTEGER |
Internal |
Record creation time (Greenwich mean time (GMT)) |