HPM_STGD_CALCRULE_MULTISRC
The HPM_STGD_CALCRULE_MULTISRC table provides details about creating or updating a multi source calculation rule.
Table 15-8 HPM_STGD_CALCRULE_CALCMSRS
Field | SQL Server Data Type | Oracle Data Type | Required | Description |
---|---|---|---|---|
id | identity | number(38,0) | Yes | Unique identifier for each row. This can come from any sequence generator. |
name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the calculation rule. |
description | nvarchar (255) | varchar2(255 CHAR) | Long description of the calculation rule. | |
pov_dim1_member_ name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the first dimension member in the selected POV |
pov_dim2_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the second dimension member in the selected POV | |
pov_dim3_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the third dimension member in the selected POV | |
pov_dim4_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the fourth dimension member in the selected POV | |
calculation_sequence | number | number(4,0) | Yes | Numeric value designating the relative order in which the calculation rule will be processed during calculation. This must be > 0 or you will get a check constraint error during insert. |
tag | nvarchar (255) | varchar2(255) | Specify search tags for the calculation rule in this column. | |
enabled_flag | nvarchar (1) | varchar2(1 CHAR) | Yes | |
driver_name | nvarchar (80) | varchar2(80 CHAR) | Yes | Driver name to be associated with this calculation rule. |
src_assign_rule_ name1 | nvarchar (80) | varchar2(80 CHAR) | Yes | Source assignment rule to be associated with this calculation rule. |
src_assign_rule_ name2 | nvarchar (80) | varchar2(80 CHAR) | Source assignment rule to be associated with this calculation rule. | |
src_assign_rule_ name3 | nvarchar (80) | varchar2(80 CHAR) | Source assignment rule to be associated with this calculation rule. | |
src_assign_rule_ name4 | nvarchar (80) | varchar2(80 CHAR) | Source assignment rule to be associated with this calculation rule. | |
src_assign_rule_ name5 | nvarchar (80) | varchar2(80 CHAR) | Source assignment rule to be associated with this calculation rule. | |
dest_assign_rule_ name1 | nvarchar (80) | varchar2(80 CHAR) | Yes | Destination assignment rule to be associated with this calculation rule. |
dest_assign_rule_ name2 | nvarchar (80) | varchar2(80 CHAR) | Destination Assignment Rule to be associated with this calculation rule. | |
dest_assign_rule_ name3 | nvarchar (80) | varchar2(80 CHAR) | Destination assignment rule to be associated with this calculation rule. | |
dest_assign_rule_ name4 | nvarchar (80) | varchar2(80 CHAR) | Destination assignment rule to be associated with this calculation rule. | |
dest_assign_rule_ name5 | nvarchar (80) | varchar2(80 CHAR) | Destination assignment rule to be associated with this calculation rule. | |
last_upload_date | timestamp (6) | timestamp | This column will be populated by the import showing the most recent date that the import was performed. | |
import_exception | nvarchar (255) | VARCHAR2(255 CHAR) | Contains the error code indicating if there was a problem with the import of the row. Null means the import was successful. | |
created_userid | nvarchar (32) | varchar2(32 CHAR) | Identifies the user who originally created the row in this table. This is not used by Profitability and Cost Management. | |
created_timestamp | timestamp (6) | timestamp | Identifies the date/time on which the row was originally created. This is not used by Profitability and Cost Management. | |
modified_userid | nvarchar (32) | varchar2(32 CHAR) | Identifies the user who originally created the row in this table. This is not used by Profitability and Cost Management. | |
modified_timestamp | timestamp (6) | timestamp | Identifies the date/time on which the row was originally created. This is not used by Profitability and Cost Management. |