The HPM_STG_ASGN_RULE_SELECTION table stores details about the source stage and dimension members for a rule controlling the assignments for the selected stage.
Dependencies:
HPM_STG_POV
HPM_STG_STAGE
HPM_STG_DRIVER
Table 18. HPM_STG_ASSGN_RULE_SELECTION
| Field | SQL Server Data Type | Oracle Data Type | Required | Description |
|---|---|---|---|---|
| id | identity | integer | Yes | Unique record ID |
| pov_dim1_member_name | nvarchar (80) | varchar2 (80) | Yes | Name of the first dimension member in the selected point of view. |
| pov_dim2_member_name | nvarchar (80) | varchar2 (80) | Name of the second dimension member in the point of view, if applicable. | |
| pov_dim3_member_name | nvarchar (80) | varchar2 (80) | Name of the third dimension member in the point of view, if applicable. | |
| pov_dim4_member_name | nvarchar (80) | varchar2 (80) | Name of the fourth dimension member in the point of view, if applicable. | |
| layer_name | nvarchar (80) | varchar2 (80) | Yes | Name of the selected layer for the point of view:
|
| src_stage_name | nvarchar (80) | varchar2 (80) | Yes | Name of the source stage for the assignment rule. |
| src_dim1_member_name | nvarchar (80) | varchar2 (80) | Yes, if the source stage has the appropriate dimension. | Name of the first dimension member in the source stage. |
| src_dim2_member_name | nvarchar (80) | varchar2 (80) | Yes, if the source stage has the appropriate dimension. | Name of the second dimension member in the source stage, if available. |
| src_dim3_member_name | nvarchar (80) | varchar2 (80) | Yes, if the source stage has the appropriate dimension. | Name of the third dimension member in the source stage, if available. |
| rule_name | nvarchar (80) | varchar2 (80) | Yes | Name of the rule controlling the selected assignment. The rule must be present in the target database. |
| last_upload_date | date | date | Date of the last import. | |
| exception | nvarchar (255) | varchar2 (255) | Message detailing errors that occurred during the import of this table. | |
| created_timestamp | datetime | date | Populated by the import program upon update. | The date and time of the last import. |
| created_userid | nvarchar (32) | varchar2 (32) | Populated by the import program upon update. | ID of the user who initiated the last import. |
| modified_userid | nvarchar (32) | varchar2 (32) | Populated by the import program upon update. | ID of the user who initiated the reimport. |
| modified_timestamp | date, time | date | Populated by the import program upon update. | The date and time of the reimport. |