Fields that are added only when a record is recorded in the Store database

Agent Host (DEVICEID)

Identifier including the name of the host where PFM - RM for Platform is running

string (256)

No

All

Agent Instance (PROD_INST)

Instance name of PFM - RM for Platform

string (256)

No

All

Agent Type (PRODID)

Product ID of PFM - RM for Platform, expressed as a 1-byte identifier

char

No

All

Date (DATE)

Record creation date, in GMT (Greenwich Mean Time)^{#1, #2}

char (3)

No

All

Date and Time (DATETIME)

Combination of the Date (DATE) and Time (TIME) fields^#2

char (6)

No

All

Drawer Type (DRAWER_TYPE)

For a record of the PI record type, the data summarization type.

char

No

All

GMT Offset (GMT_ADJUST)

Difference (in seconds) between Greenwich Mean Time and local time

long

No

All

Time (TIME)

Record creation time in GMT (Greenwich Mean Time)^{#1, #2}

char (3)

No

All

Minute

At the 0 second of the time when the record was created.

Hour

At the 0 minute and 0 second of the time when the record was created.

Day

At 00:00:00 of the day when the record was created.

Week

At 00:00:00 on Monday of the week when the record was created.

Month

At 00:00:00 on the first of the month when the record was created.

Year

At 00:00:00 on January 1st of the year when the record was created.