HPM_STG_ASSIGNMENT
The HPM_STG_ASSIGNMENT table provides details about each assignment, including the source stage, POV, layer, source dimension members, destination stage, and destination dimension members.
Dependencies:
-
HPM_STG_POV
-
HPM_STG_STAGE
-
HPM_STG_DRIVER
Table 7-6 HPM_STG_ASSIGNMENT
| 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 point of view. |
| pov_dim2_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the second dimension member in the point of view, if applicable. | |
| pov_dim3_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the third dimension member in the point of view, if applicable. | |
| pov_dim4_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the fourth dimension member in the point of view, if applicable. | |
| layer_name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the selected layer for the point of view:
|
| src_stage_name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the source stage for the assignment. |
| 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) | Yes, if stage source/destination stage have this dimension | Name of the second dimension member in the source stage, if available. |
| src_dim3_member_ name | nvarchar (80) | varchar2(80 CHAR) | Yes, if stage source/destination stage have this dimension | Name of the third dimension member in the source stage, if available. |
| dst_stage_name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the destination stage for the assignment. |
| dst_dim1_member_ name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the first dimension member in the destination stage. |
| dst_dim2_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the second dimension member in the destination stage, if available. | |
| dst_dim3_member_ name | nvarchar (80) | varchar2(80 CHAR) | Name of the third dimension member in the destination stage, if available. | |
| 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) | Populated by the import program upon update. | The date and time when the last import was initiated. 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. |