HPM_STGD_ASGN_RULE_SEL
The HPM_STGD_ASGN_RULE_SEL table provides details about the assignment rule selections.
Table 15-5 HPM_STGD_ASGN_RULE_SEL
Field | SQL Server Data Type | Oracle Data Type | Required | Description |
---|---|---|---|---|
id | identity | integer(38,0) | Yes | Unique record ID |
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 | |
src_dim1_member_ name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the first dimension member in the source stage |
src_dim2_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the second dimension member in the source stage, if applicable | |
src_dim3_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the third dimension member in the source stage, if applicable | |
src_dim4_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the fourth dimension member in the source stage, if applicable | |
src_dim5_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the fifth dimension member in the source stage, if applicable | |
rule_name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the rule controlling the selected assignment. The rule must be present in the target database. |
last_upload_date | timestamp (6) | timestamp (6) | The date and time of the last import | |
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 |