Session Parameters Log

3. Description of Tables

The following tables are used to store the session parameters log:

Their relation is as follows:

The diagram depicts four master/detail relationships, where LOG_SESSIONS is the master table, and other tables are detail tables, containing many detail records for each master record. All four tables reside in the part of the database that is common for both WIS and test scenario tables options. During the export of table named <table name> to the other database, the target table is linked in MS Access under the name EXP_<table name>, because both tables have to be linked at the same time (example: LOG_SESSIONS and EXP_LOG_SESSIONS).

Here is a more detailed description of each table:

LOG_SESSIONS

Column name ORACLE type MS Access type Null Primary key Description
SESSION_ID VARCHAR2(30) Text(30) No Yes Session identifier.
USER_NAME VARCHAR2(30) Text(30) No User that saved the session.
DATE_SAVED DATE Date/Time No Date/time when the session was saved.
MODULE_TYPE VARCHAR2(1) Text(1) No M, T, I, L or W.
REF_YEAR NUMBER(4)IntegerNo Reference year.
CENSUS_YEAR NUMBER(4) Integer Yes Census year (used for municipal only, set to the reference year for other modules).
NOTES VARCHAR2(100) Text(100) Yes Free text description.
SESSION_TYPE VARCHAR2(1) Text(1) No P-production or T-test.

LOG_LOCATIONS

Column name ORACLE type MS Access type Null Primary key Description
SESSION_ID VARCHAR2(30) Text(30) No Yes Session identifier.
GIS_ID VARCHAR2(10) Text(10) No Yes ID of the selected spatial item (see section 4).

LOG_REF_VALUES

Column name ORACLE type MS Access type Null Primary key Description
SESSION_ID VARCHAR2(30) Text(30) No Yes Session identifier
PARAM_TYPE VARCHAR2(4) Text(4) No Yes Parameter type code (see section 4)
MONTH NUMBER(2) Long Integer No Yes Month corresponding to the parameter value
PARAM_VALUE NUMBER(15,5) Double No Value of the parameter

LOG_Y

Column name ORACLE type MS Access type Null Primary key Description
SESSION_ID VARCHAR2(30) Text(30) No Yes Session identifier
PARAM_TYPE VARCHAR2(4) Text(4) No Yes Parameter type code (see section 4)
SCENARIO NUMBER(1) Integer No Yes Scenario number (1, 2 or 3)
YEAR NUMBER(4) Integer No Yes Balancing year (currently 2005, 2010, …, 2040)
PARAM_VALUE NUMBER(15, 5) Double No Value of the parameter

LOG_M

Column name ORACLE type MS Access type Null Primary key Description
SESSION_ID VARCHAR2(30) Text(30) No Yes Session identifier
PARAM_TYPE VARCHAR2(4) Text(4) No Yes Parameter type code (see section 4)
SCENARIO NUMBER(1) Integer No Yes Scenario number (1, 2 or 3)
YEAR NUMBER(4) Integer No Yes Balancing year (currently 2005, 2010, …, 2040)
MONTH NUMBER(2) Integer No Yes Month corresponding to the parameter value
PARAM_VALUE NUMBER(15,5) Double No Value of the parameter