Share this page

# WIA_TEMPLATES

This table stores what-if analysis templates. The templates define display layout for scenarios.

In this topic:

## Foreign keys

There are no foreign keys for this table.

## Column descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TEMPLATE_ID | NOT NULL | NUMBER | Identifier for the scenario template.
NAME | NOT NULL | VARCHAR2(200 CHAR) | Name of the scenario template.
DESCRIPTION | NULLABLE | VARCHAR2(2000 CHAR) | Description of the scenario template.
TEMPLATE | NOT NULL | CLOB | Contents of the scenario template.
STATUS | NULLABLE | VARCHAR2(30 CHAR) | Status of the scenario template. Available values: DRAFT, PUBLISHED, PUBLISHED_MODIFYING, DISABLED
VERSION | NOT NULL | NUMBER | System-generated version, used for version control.
SOURCE | NULLABLE | NUMBER | As if this template is a published template, the source value refers to its master template.
DISABLE_DATE | NULLABLE | DATE | Date when the scenario template was make unavailable.
CREATION_DATE | NOT NULL | DATE | Date when the scenario template was created.
CREATED_BY | NULLABLE | NUMBER | User that created the scenario template.
LAST_UPDATE_DATE | NOT NULL | DATE | Date when the scenario template was last updated.
LAST_UPDATED_BY | NULLABLE | NUMBER | User that last updated the scenario template.
REFERENCE_CODE | NULLABLE | VARCHAR2(200 CHAR) | Unique code for the scenario template.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
NAME, SOURCE | UNIQUE |  | NAME, SOURCE

## Sequences

Sequence Name | Sequence Type
--- | ---
WIA_TEMPLATES_S |

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: