HPM_EXPD_DRIVER
The HPM_EXPD_DRIVER view retrieves details about the driver, including driver type, display order and formula.
Table 14-3 HPM_EXPD_DRIVER
Field | SQL Server Data Type | Oracle Data Type | Description |
---|---|---|---|
application_name | nvarchar (80) | varchar2(80 CHAR) | Name of the selected application |
id | identity | integer(38,0) | Unique record ID |
name | nvarchar (80) | varchar2(80 CHAR) | Name of the selected driver |
description | nvarchar (255) | varchar2 (255 CHAR) | Description of the purpose for the selected driver |
display_order | integer(38,0) | integer(38,0) | Display position of the driver within the list of all drivers in the model |
formula | nvarchar (4000) | varchar2 (4000 CHAR) | Formula created for the driver by a user. This formula must be created using SQL syntax, and mathematically correct operations. |
allow_idle_cost | nvarchar (1) | varchar2 (1 CHAR) | Flag determining whether idle costs are allowed for this driver:
|
priority | integer | number (38,0) | Enter the calculation priority of a driver so that allocations within a stage can be run in the specified order.
The driver with the lowest priority is processed first. By default, the priority is set to 100, and the highest priority is 1. Numbers need not be sequential. Drivers with the same priority are executed in no particular order. Only whole, positive numbers are valid. |
volume_formula | nvarchar (4000) | varchar2(4000 CHAR) | For Rate-Based drivers only, the formula which has both the Rate and Volume formulas defined. |
dst_measure_member_ name | nvarchar (2000) | varchar2(2000 CHAR) | Name of the measure on the Destination table |
tdv_measure_member_ name | nvarchar (80) | varchar2(2000 CHAR) | Measure that is used as the denominator in the allocation formula: Driver Value/TotalDriverValue (DV/TDV )
|
operation_type | nvarchar (80) | varchar2(80 CHAR) | The operation type selected for the driver:
|