3.8.13 PivotTable: BrtBeginPCDIRun
The BrtBeginPCDIRun (section 2.4.147) record specifies the sequence of PCDIDateTime (section 2.5.101) cache items (section 2.2.5.2.3), as specified in the following table.
|
Size |
Structure |
Value |
|---|---|---|
|
00A6 |
BrtBeginPCDIRun - BrtBeginPCDIRun |
|
|
0002 |
SHORT - mdSxoper |
0x0020 |
|
0004 |
DWORD - cItems |
0x00000014 |
|
00A0 |
PCDIDateTime - rgPCDIDatetime |
|
|
0008 |
PCDIDateTime - PCDIDatetime[0] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0005 |
|
0001 |
BYTE - dom |
0x06 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[1] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0005 |
|
0001 |
BYTE - dom |
0x0F |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[2] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0006 |
|
0001 |
BYTE - dom |
0x13 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[3] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0006 |
|
0001 |
BYTE - dom |
0x18 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[4] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0007 |
|
0001 |
BYTE - dom |
0x0F |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[5] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0007 |
|
0001 |
BYTE - dom |
0x1F |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[6] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0008 |
|
0001 |
BYTE - dom |
0x05 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[7] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0008 |
|
0001 |
BYTE - dom |
0x0E |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[8] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0009 |
|
0001 |
BYTE - dom |
0x04 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[9] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0009 |
|
0001 |
BYTE - dom |
0x0F |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[10] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x0009 |
|
0001 |
BYTE - dom |
0x16 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[11] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x000A |
|
0001 |
BYTE - dom |
0x10 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[12] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x000A |
|
0001 |
BYTE - dom |
0x1B |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[13] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x000B |
|
0001 |
BYTE - dom |
0x14 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[14] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x000B |
|
0001 |
BYTE - dom |
0x18 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[15] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x000B |
|
0001 |
BYTE - dom |
0x1C |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[16] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x000C |
|
0001 |
BYTE - dom |
0x17 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[17] |
|
|
0002 |
USHORT - yr |
0x07CD |
|
0002 |
USHORT - mon |
0x000C |
|
0001 |
BYTE - dom |
0x1A |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[18] |
|
|
0002 |
USHORT - yr |
0x07CE |
|
0002 |
USHORT - mon |
0x0001 |
|
0001 |
BYTE - dom |
0x06 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
|
0008 |
PCDIDateTime - PCDIDatetime[19] |
|
|
0002 |
USHORT - yr |
0x07CE |
|
0002 |
USHORT - mon |
0x0001 |
|
0001 |
BYTE - dom |
0x17 |
|
0001 |
BYTE - hr |
0x00 |
|
0001 |
BYTE - min |
0x00 |
|
0001 |
BYTE - sec |
0x00 |
Structure of BrtBeginPCDIRun
mdSxoper: 0x0020 specifies that the date-time type field is used to store cache items (section 2.2.5.2.3) and is defined by rgPCDIDateTime.
cItems: 0x00000014 specifies that the number of cache items in the array is 20.
rgPCDIDatetime: Specifies an array of 20 unique PCDIDateTime (section 2.5.101) fields, three of which are described following this sentence, that specify the date-time values of the cache items.
rgPCDIDatetime.PCDIDatetime[0]: specifies the value of May 6, 1997 00:00:00.
rgPCDIDatetime.PCDIDatetime[0].yr: 0x07CD specifies the year to be 1997.
rgPCDIDatetime.PCDIDatetime[0].mon: 0x0005 specifies the month to be May.
rgPCDIDatetime.PCDIDatetime[0].dom: 0x06 specifies the day of the month to be the 6th.
rgPCDIDatetime.PCDIDatetime[0].hr: 0x00 specifies the hour to be 0.
rgPCDIDatetime.PCDIDatetime[0].min: 0x00 specifies the minute to be 0.
rgPCDIDatetime.PCDIDatetime[0].sec: 0x00 specifies the second to be 0.
rgPCDIDatetime.PCDIDatetime[16]: Specifies the date-time value of December 23, 1997 00:00:00.
rgPCDIDatetime.PCDIDatetime[16].yr: 0x07CD specifies the year to be 1997.
rgPCDIDatetime.PCDIDatetime[16].mon: 0x000C specifies the month to be December.
rgPCDIDatetime.PCDIDatetime[16].dom: 0x17 specifies the date to be the 23rd.
rgPCDIDatetime.PCDIDatetime[16].hr: 0x00 specifies the hour to be 0.
rgPCDIDatetime.PCDIDatetime[16].min: 0x00 specifies the minute to be 0.
rgPCDIDatetime.PCDIDatetime[16].sec: 0x00 specifies the second to be 0.
rgPCDIDatetime.PCDIDatetime[17]: Specifies the date-time value of December 26, 1997 00:00:00
rgPCDIDatetime.PCDIDatetime[17].yr: 0x07CD specifies the year is 1997 in the date.
rgPCDIDatetime.PCDIDatetime[17].mon: 0x000C specifies the month to be December.
rgPCDIDatetime.PCDIDatetime[17].dom: 0x1A specifies the date to be the 26th.
rgPCDIDatetime.PCDIDatetime[17].hr: 0x00 specifies the hour to be 0.
rgPCDIDatetime.PCDIDatetime[17].min: 0x00 specifies the minute to be 0.
rgPCDIDatetime.PCDIDatetime[17].sec: 0x00 specifies the second to be 0.