HPM_STGD_DRIVER
The HPM_STGD_DRIVER table provides details about the driver, including driver type, display order and formula.
Table 15-2 HPM_STGD_DRIVER
| Field | SQL Server Data Type | Oracle Data Type | Required | Description |
|---|---|---|---|---|
| id | identity | integer(38,0) | Yes | Unique record ID |
| name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the selected driver |
| description | nvarchar (255) | varchar2(255 CHAR) | Description of the purpose for the selected driver | |
| formula | nvarchar (500) | varchar2(500 CHAR) | Yes | 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) | Enter the appropriate value to determine whether idle costs are allowed for this driver:
|
|
| priority | integer(38,0) | integer(38,0) | Yes | 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, which formula has both the Rate and Volume formulas defined. | |
| dst_measure_ member_name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the measure on the Destination table |
| tdv_measure_ member_name | nvarchar (80) | varchar2(80 CHAR) | Measure that is used as the denominator in the allocation formula:P Driver Value/TotalDriverValue (DV/TDV)
|
|
| operation_type | nvarchar (80) | varchar2(80 CHAR) | Yes | The operation type selected for the driver:
|
| last_upload_date | timestamp (6) | timestamp (6) | The date and time of the last import | |
| exception | nvarchar (255) | varchar2(255 CHAR) | Message detailing errors that occurred during the import of this table. | |
| created_userid | nvarchar (32) | varchar2(32 CHAR) | Populated by the import program upon update | The ID of the user who initiated the last import |
| created_timestamp | timestamp (6) | timestamp (6) | The date and time of the last import | |
| modified_userid | nvarchar (32) | varchar2(32 CHAR) | Populated by the import program upon update | The ID of the user who modified the last import |
| modified_timestamp | timestamp (6) | timestamp (6) | The date and time of the modified import |