HPM_STG_DRIVER
The HPM_STG_DRIVER table provides details about the driver, including driver type, display order, layer and certain members from the Measures dimension.
Dependencies: None
Table 7-3 HPM_STG_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 driver. |
| description | nvarchar (255) | varchar2(255 CHAR) | Description of the purpose for the selected driver. | |
| driver_type | nvarchar (80) | varchar2(80 CHAR) | Yes | Type of driver:
|
| fixed_member | nvarchar (80) | varchar2(80) | Member in the Measures dimension that corresponds to the standard driver measure "FixedDriverValue." | |
| fixed_location | nvarchar (30) | varchar2(30) | Location of the standard driver measure "FixedDriverValue." | |
| rate_member | nvarchar (80) | varchar2(80) | Member in the Measures dimension that corresponds to the standard driver measure "Rate." | |
| rate_location | nvarchar (30) | varchar2(30) | Location of the standard driver measure "Rate." | |
| weight_member | nvarchar (80) | varchar2(80) | Member in the Measures dimension that corresponds to the standard driver measure "Weight." | |
| weight_location | nvarchar (30) | varchar2(30) | Location of the standard driver measure "Weight." | |
| volume_member | nvarchar (80) | varchar2(80) | Member in the Measures dimension that corresponds to the standard driver measure "Volume." | |
| volume_location | nvarchar (30) | varchar2(30) | Location of the standard driver measure "Volume." | |
| custom_formula | nvarchar (500) | varchar2(500 CHAR) | Formula created for the driver by a user. This formula must be created using Oracle Essbase calculation script syntax. See the Oracle Hyperion Profitability and Cost Management User's Guide. | |
| cost_layer | nvarchar (30) | varchar2(30 CHAR) | Enter "Yes" to set the driver layer to Cost. It contains the cost values for the model.
Note: Either the cost_layer, revenue_layer, or both must be selected. |
|
| revenue_layer | nvarchar (30) | varchar2(30 CHAR) | Enter "Yes" to set the driver layer to Revenue. It contains the revenue values for the model.
Note: Either the cost_layer, revenue_layer, or both must be selected. |
|
| allow_idle_cost | nvarchar (1) | varchar2(1 CHAR) | Enter the appropriate value to determine whether idle costs are allowed for this driver:
|
|
| driver_basis_type | nvarchar (80) | varchar2(80 CHAR) | Yes | Select the required driver basis:
Note: The Standard Basis driver cannot be used with Even or Percentage driver types. |
| priority | identity | 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. |
| 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) | Populated by the import program upon update. | The date and time of the last import. This value is populated by the import program upon update. |
| 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) | Populated by the import program upon update. | The date and time of the modified import. |