H95: Tech Resources/Applications |
| Schema | Table | Prefix | Columns | Indexes | Description | Type | Report | Category |
---|
1 | 910 | F95961 | PS | 27 | 12 | PM Transaction History (PSPMTRANSHIST) | Files | H95: Tech Resources/Applications | System Tables |
Number | Description |
---|
1 | Primary (Primary/Unique) |
| Element | Alias | Description | Sequence |
---|
1 | PMINSTID | PM Instance ID | Ascending |
|
2 | Trans Set |
| Element | Alias | Description | Sequence |
---|
1 | PMTRNSET | PM Trans Definition Set | Ascending | 2 | PMTRNID | PM Trans Definition ID | Ascending | 3 | PMAID | PM Agent ID | Ascending | 4 | PMMSTRUT | PM Monitor Start UTime | Ascending |
|
3 | User |
| Element | Alias | Description | Sequence |
---|
1 | USER | User ID | Ascending | 2 | PMAID | PM Agent ID | Ascending | 3 | PMMSTRUT | PM Monitor Start UTime | Ascending |
|
4 | Trace |
| Element | Alias | Description | Sequence |
---|
1 | PMPERFTR | PM Performance Trace | Ascending | 2 | PMMSTRUT | PM Monitor Start UTime | Ascending |
|
5 | Top Inst |
| Element | Alias | Description | Sequence |
---|
1 | PMTOPID | PM Top Instance ID | Ascending |
|
6 | Context Value 1 |
| Element | Alias | Description | Sequence |
---|
1 | PMCONV1 | PM Context Value 1 | Ascending | 2 | PMAID | PM Agent ID | Ascending | 3 | PMMSTRUT | PM Monitor Start UTime | Ascending |
|
7 | Context Value 2 |
| Element | Alias | Description | Sequence |
---|
1 | PMCONV2 | PM Context Value 2 | Ascending | 2 | PMAID | PM Agent ID | Ascending | 3 | PMMSTRUT | PM Monitor Start UTime | Ascending |
|
8 | Agent |
| Element | Alias | Description | Sequence |
---|
1 | PMAID | PM Agent ID | Ascending | 2 | PMMSTRUT | PM Monitor Start UTime | Ascending | 3 | PMTRNDUR | PM Trans Duration | Ascending |
|
9 | Parent |
| Element | Alias | Description | Sequence |
---|
1 | PMPINSID | PM Parent Instance ID | Ascending |
|
10 | PMU |
| Element | Alias | Description | Sequence |
---|
1 | PMTRNSET | PM Trans Definition Set | Ascending | 2 | PMTRNID | PM Trans Definition ID | Ascending | 3 | PMASTRUT | PM Agent Start UTime | Ascending |
|
11 | Past Hour |
| Element | Alias | Description | Sequence |
---|
1 | PMASTRUT | PM Agent Start UTime | Ascending |
|
12 | Agent AgentStart |
| Element | Alias | Description | Sequence |
---|
1 | PMAID | PM Agent ID | Ascending | 2 | PMASTRUT | PM Agent Start UTime | Ascending |
|