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.

Back to top

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.

Back to top

Indexes

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

Back to top

Sequences

Sequence Name	Sequence Type
WIA_TEMPLATES_S

Back to top