The HPM_STG_POV table stores the states of each combination of dimension members included in a point of view (POV).
Dependencies: None
Table 14. HPM_STG_POV
| 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 POV dimension member. |
| pov_dim2_member_name | nvarchar (80) | varchar2 (80) | Name of the second POV dimension member, if available. | |
| pov_dim3_member_name | nvarchar (80) | varchar2 (80) | Name of the third POV dimension member, if available. Additional dimensions and member names may be added, as required. | |
| pov_dim4_member_name | nvarchar (80) | varchar2 (80) | Name of the fourth POV dimension member, if available. Additional dimensions and member names may be added, as required. | |
| pov_state | nvarchar (80) | varchar2 (80) | Yes | The current status of the POV:
|
| last_upload_date | datetime | date | The date and time of the last import. | |
| exception | nvarchar (255) | varchar2 (255) | Message detailing errors that occurred during the import of this table. | |
| created_userid | nvarchar (32) | varchar2 (32) | Populated by the import program upon update. | The ID of the user who initiated the last import. |
| created_timestamp | datetime | date | 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) | Populated by the import program upon update. | The ID of the user who modified the last import. |
| modified_timestamp | datetime | date | Populated by the import program upon update. | The date and time of the modified import. |