CHARGEBACK_RATE
The CHARGEBACK_RATE table contains charge back rate definition for the Charge Back Explorer report, which calculates the slot charge back amounts for EGO allocated resources over time (hours, days, weeks, or months). This Explorer report helps to determine charging for slot based scheduling, not multidimensional based scheduling.
| Column name | Data type | Null (Y or N) | Key (PK or FK) | Comment |
|---|---|---|---|---|
| START_TIME | TIMESTAMP | N | PK | The start date and the start time in hours. The specified start and end range must include the full date, and the time should not include minutes or seconds. The format should follow YYYY-MM-DD HH:00:00 (for example, 2017-01-01 01:00:00). IBM® Spectrum Symphony generates Explorer reports using a default date query range from midnight (00:00 o'clock) of the start date, to midnight (00:00 o'clock) of the end date. For example, if you select to create a report from 2017-1-1 to 2017-1-7, the report will use data from 2017-1-1 00:00 (midnight on January 1, 2017) to 2017-1-7 00:00 (midnight on January 7, 2017). |
| END_TIME | TIMESTAMP | N | Not applicable | The end date and the end time in hours. The specified start and end range must include the full date, and the time should not include minutes or seconds. The format should follow YYYY-MM-DD HH:00:00 (for example, 2017-01-01 01:00:00). |
| CLUSTER_NAME | VARCHAR(128) | N | PK | The name of the cluster. |
| RESOURCE_GROUP | VARCHAR(256) | N | PK | The name of the resource group. |
| CHARGEBACK_RATE | NUMERIC(20,4) | N | Not applicable | The charge back rate. IBM Spectrum Symphony provides a default charge back rate of 1 per hour. |
- CALC_CHARGE_BACK stored procedure
- Aggregates data records from the CHARGEBACK_RATE database table, and returns the charge back data results for a specified duration.
- ALLOCATION_EVENT_VIEW view
- Created based on the ALLOCATION_EVENT database table. This view provides extra columns to represent slot allocation numbers.