The following table lists the fields that are added only when data is stored in the Store database:

Table 5-7 Fields added only when data is stored in the Store database

PFM - View name (PFM - Manager name)	Description	Format	Delta	Supported versions	Data source
Agent Host (DEVICEID)	Name of host where PFM - RM for Oracle is running	string (256)	No	All	N/A
Agent Instance (PROD_INST)	Instance name of PFM - RM for Oracle	string (256)	No	All	N/A
Agent Type (PROD_ID)	Product ID of PFM - RM for Oracle (1-byte identifier)	char	No	All	N/A
Date (DATE)	Record creation date in (GMT)#1	char (3)	No	All	N/A
Date and Time (DATETIME)	Combination of the Date (DATE) and Time (TIME) fields	char (6)	No	All	N/A
Drawer Type (DRAWER_TYPE)	For a PI record, the data summarization type. The type displayed in PFM - Web Console reports differs from the type displayed using the ODBC driver.#2	char	No	All	N/A
GMT Offset (GMT_ADJUST)	Difference (in seconds) between Greenwich Mean Time and local time	long	No	All	N/A
Time (TIME)	Record creation time (GMT)#1	char (3)	No	All	N/A

Legend:

N/A: The field value is specified without processing the performance data acquired from Oracle.

#1

A basic value is set because records of the PI record type are summarized. The following table shows the setting values for each record type.

Table 5-8 Setting value for each record type

Type	Setting value for each record type
Minute	0 second of the time when the record was created.
Hour	0 minute and 0 second of the time when the record was created.
Day	0:00 and 0 second of the day when the record was created.
Week	0:00 and 0 second on Monday of the week when the record was created.
Month	0:00 and 0 second on the 1st day of the month when the record was created.
Year	0:00 and 0 second on January 1st of the year when the record was created.

#2

The following table shows the type displayed in PFM - Web Console reports and the type displayed using the ODBC driver:

Table 5-9 Difference of displayed types made by PFM - Web Console and ODBC driver

Type	PFM - Web Console	ODBC driver
Minute	Minute	m
Hour	Hour	H
Day	Day	D
Week	Week	W
Month	Month	M
Year	Year	Y