Definition of STP

STP stands for Scenario Tables Pool. The idea is, that all
modelling results for resources and demands are stored in the STP,
which is a part of the central ORACLE database. From there, the data
are available for balancing.

Data are stored as monthly volumes in m³.

The STP contains both historic data and projected data. The months
are counting from the start of the hydrological year: Month 1 means
October. The years are the hydrological years, year 1998 would be year
1997/98, from October 1997 to September 1998.

Note: currently, each year in the STP tables contains 15 months, from October to December and again from January to December.

The projected data are for the years 2005, 2010, 2015, 2020, 2025,
2030, 2035 and 2040. As opposed to the irrigation module, different
hydrological conditions are not applied in the pre-processing module.

According to the individual sub-modules, the following 6 STP tables are used by the pre-processing module:

A typical example for a STP Table is the Table STP_MUNICIPAL (only a very small selection of records is shown):

SETT_ID

SCENARIO

YEAR

MONTH

DEMAND

SALINITY

LOG_SESSION

USER_NAME

DATE_SAVED

3

0

1998

3

434

0

3

0

1998

4

396

0

3

0

1998

5

396

0

3

0

1998

6

396

0

3

0

1998

7

382

0

1135

1

2005

1

332

1

Mpreproc20021104-231020

preproc

04/11/2002 23:11:27

1135

1

2005

2

332

1

Mpreproc20021104-231020

preproc

04/11/2002 23:11:27

1135

1

2005

3

332

1

Mpreproc20021104-231020

preproc

04/11/2002 23:11:27

1135

1

2005

4

332

1

Mpreproc20021104-231020

preproc

04/11/2002 23:11:27

1135

1

2005

5

332

1

Mpreproc20021104-231020

preproc

04/11/2002 23:11:27

Please note, that the results for all locations (= SETT_ID ), scenarios
(1, 2 or 3), months (1, 2 ... ) and years (both historical and
projections) are stored in the same database table. Historical years
have scenario 0. SALINITY indicates the salinity class.