HPM_STG_STAGE
The HPM_STG_STAGE table provides a list of the stages within the model, and identifies the display order, prefix, associated dimensions and driver dimension for each stage.
Dependencies: None
Table 7-1 HPM_STG_STAGE
| Field | SQL Server Data Type | Oracle Data Type | Required | Description |
|---|---|---|---|---|
| id | identity | integer(38,0) | Yes | Unique record ID |
| name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the model stage. |
| description | nvarchar (255) | varchar2(255 CHAR) | Brief explanation of the purpose of the stage. | |
| stage_order | identity (38,0) | integer(38,0) | Yes | The sequence position in which the selected stage is to be used within the model while modeling (assignments and rules creation), in calc script generation and calculation. |
| stage_prefix | nvarchar (80) | varchar2(80 CHAR) | Yes | Differentiating prefix for the stage name. |
| dim1_name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the first dimension included in the stage. |
| dim2_name | nvarchar (80) | varchar2(80 CHAR) | Name of the second dimension included in the stage, if available. | |
| dim3_name | nvarchar (80) | varchar2(80 CHAR) | Name of the third dimension included in the stage, if available. | |
| driver_dim_name | nvarchar (80) | varchar2(80 CHAR) | Yes | Name of the dimension selected as the driver for the stage. |
| Is_intra | nvarchar (1) | varchar2(255 CHAR) | Yes | Enter "Y" (Yes) to enable intrastage assignments within the model stage.
Default is "N" (No). This field is populated from the application. |
| last_upload_date | timestamp (6) | timestamp (6) | The date and time of the last 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 of the last import. 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. |