View source for Appendix 5: Database objects/CGMS14xxx


{{expert}}
__NOTOC__
{{TocTable|content=
{{TocRow|#CROP-datasets|1. CROP-datasets}}
{{TocRow|#GLOBAL-datasets|2. GLOBAL-datasets}}
{{TocRow|#LINK-datasets|3. LINK-datasets}}
{{TocRow|#SIM-datasets|4. SIM-datasets}}
{{TocRow|#SOIL-datasets|5. SOIL-datasets}}
{{TocRow|#WEATHER-datasets|6. WEATHER-datasets}}
{{TocRow|#other datasets|7. other datasets}}
}}




== CROP-datasets ==
{{TocTable|content=
{{TocRow|#CROP_AGGREGATIONS|1.1 CROP_AGGREGATIONS}}
{{TocRow|#CROP_CALENDARS|1.2 CROP_CALENDARS}}
{{TocRow|#CROP_CALENDARS_OLD|1.3 CROP_CALENDARS_OLD}}
{{TocRow|#CROP_PARAMETRIZATIONS|1.4 CROP_PARAMETRIZATIONS}}
{{TocRow|#CROP_PARAMETRIZATION_PARAMETER|1.5 CROP_PARAMETRIZATION_PARAMETER}}
{{TocRow|#CROP_REGIMES|1.6 CROP_REGIMES}}
{{TocRow|#CROP_SPATIALIZATIONS|1.7 CROP_SPATIALIZATIONS}}
{{TocRow|#CROP_SUITABILITY_RULES|1.8 CROP_SUITABILITY_RULES}}
{{TocRow|#CROP_VARIETIES|1.9 CROP_VARIETIES}}
{{TocRow|#CROP_VARIETY_PARAMETERS|1.10 CROP_VARIETY_PARAMETERS}}
{{TocRow|#CROP_VARIETY_PARAMETERS_OLD|1.11 CROP_VARIETY_PARAMETERS_OLD}}
{{TocRow|#CROP_VARIETY_REGIMES|1.12 CROP_VARIETY_REGIMES}}
}}




<!-- start -->
=== CROP_AGGREGATIONS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_CALENDARS ===
* Description: ''where'' and ''when'' crops are grown. crop, crop variety and growing season per grid.
* Use: determines which crops are simulated for a grid, and simulation period
* Type: ''Table''
* Remarks: user defined, one of the ‘driving’ tables of the system
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) || - || calendar year
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  || 
|-
| END_PERIOD || NOT NULL || VARCHAR2(20) ||  || 
|-
| EMERGENCE ||  || DATE ||  || 
|-
| SOWING ||  || DATE ||  || 
|-
| HARVESTING ||  || DATE ||  || 
|-
| MATURITY ||  || DATE ||  || 
|-
| DURATION ||  || NUMBER(22) ||  || 
|-
| START_DOY ||  || NUMBER(22) ||  || 
|-
|}
<nowiki>*</nowiki> possible values: VARIABLE_SOWING, FIXED_SOWING or FIXED_EMERGENCE (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).<br>
<nowiki>**</nowiki> possible values: HARVEST, MATURITY, EARLIEST (see [[Crop_parameters#Crop_parameters_for_the_CGMS|Spatial/temporal variation category]]).
|}
<!-- end -->



<!-- start -->
=== CROP_CALENDARS_OLD ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  || 
|-
| END_PERIOD || NOT NULL || VARCHAR2(20) ||  || 
|-
| EMERGENCE ||  || DATE ||  || 
|-
| SOWING ||  || DATE ||  || 
|-
| HARVESTING ||  || DATE ||  || 
|-
| MATURITY ||  || DATE ||  || 
|-
| DURATION ||  || NUMBER(22) ||  || 
|-
| START_DOY ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_PARAMETRIZATIONS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| ACTIVE_PARAMETRIZATION || NOT NULL || VARCHAR2(1) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| DESCRIPTOR ||  || VARCHAR2(255) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_PARAMETRIZATION_PARAMETER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  || 
|-
| YVALUE ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_REGIMES ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_REGIME || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 2) ||  || 
|-
| SOWING_REGIME || NOT NULL || VARCHAR2(30) ||  || 
|-
| REGIME_DETAIL || NOT NULL || VARCHAR2(30) ||  || 
|-
| DETAIL_VALUE || NOT NULL || VARCHAR2(30) ||  || 
|-
| DETAIL_DIMENSION || NOT NULL || VARCHAR2(60) ||  || 
|-
| DESCRIPTION ||  || VARCHAR2(256) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_SPATIALIZATIONS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_SUITABILITY_RULES ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| VALUEC ||  || VARCHAR2(30) ||  || 
|-
| VALUEN_MIN ||  || NUMBER(22) ||  || 
|-
| VALUEN_MAX ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_VARIETIES ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_VARIETY_PARAMETERS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  || 
|-
| YVALUE ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_VARIETY_PARAMETERS_OLD ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  || 
|-
| YVALUE ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== CROP_VARIETY_REGIMES ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DECADE || NOT NULL || NUMBER(22) ||  || 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



== GLOBAL-datasets ==
{{TocTable|content=
{{TocRow|#GLOBAL_CATEGORIES|2.1 GLOBAL_CATEGORIES}}
{{TocRow|#GLOBAL_COVERS|2.2 GLOBAL_COVERS}}
{{TocRow|#GLOBAL_COVER_SOURCES|2.3 GLOBAL_COVER_SOURCES}}
{{TocRow|#GLOBAL_CROPS|2.4 GLOBAL_CROPS}}
{{TocRow|#GLOBAL_CROP_PARAMETERS|2.5 GLOBAL_CROP_PARAMETERS}}
{{TocRow|#GLOBAL_GRIDS|2.6 GLOBAL_GRIDS}}
{{TocRow|#GLOBAL_GRID_SOURCES|2.7 GLOBAL_GRID_SOURCES}}
{{TocRow|#GLOBAL_LINK_COVERWINDOW_SOURCE|2.8 GLOBAL_LINK_COVERWINDOW_SOURCE}}
{{TocRow|#GLOBAL_MODELS|2.9 GLOBAL_MODELS}}
{{TocRow|#GLOBAL_REGIONS|2.10 GLOBAL_REGIONS}}
{{TocRow|#GLOBAL_REGION_ELEMENTS|2.11 GLOBAL_REGION_ELEMENTS}}
{{TocRow|#GLOBAL_REGION_SOURCES|2.12 GLOBAL_REGION_SOURCES}}
{{TocRow|#GLOBAL_SOIL_SOURCES|2.13 GLOBAL_SOIL_SOURCES}}
{{TocRow|#GLOBAL_STATISTIC_SOURCES|2.14 GLOBAL_STATISTIC_SOURCES}}
{{TocRow|#GLOBAL_SUITABILITY_PROPERTIES|2.15 GLOBAL_SUITABILITY_PROPERTIES}}
{{TocRow|#GLOBAL_THRESHOLDS|2.16 GLOBAL_THRESHOLDS}}
{{TocRow|#GLOBAL_TIME_DIMENSIONS|2.17 GLOBAL_TIME_DIMENSIONS}}
{{TocRow|#GLOBAL_TREATMENTS|2.18 GLOBAL_TREATMENTS}}
{{TocRow|#GLOBAL_WINDOWS|2.19 GLOBAL_WINDOWS}}
}}




<!-- start -->
=== GLOBAL_CATEGORIES ===
* Description: 
* Use: 
* Type: ''Materialized View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  || 
|-
|}


'''definition:'''
 select
     idcategory
   , category
   , descriptor
 from categories@CGMS14SYS_ASSISTSAN
|}
<!-- end -->



<!-- start -->
=== GLOBAL_COVERS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  || 
|-
|}


'''definition:'''
 select
     c.idcover
   , c.cover
   , c.descriptor
 from covers@CGMS14SYS_ASSISTSAN c
|}
<!-- end -->



<!-- start -->
=== GLOBAL_COVER_SOURCES ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR ||  || VARCHAR2(255) ||  || 
|-
| UNC ||  || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
   c.idcover_source
   , c.cover_source
   , c.descriptor
   , c.unc
 from cover_sources@CGMS14SYS_ASSISTSAN c
|}
<!-- end -->



<!-- start -->
=== GLOBAL_CROPS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| EUROSTAT || NOT NULL || VARCHAR2(30) ||  || 
|-
|}


'''definition:'''
 select
     c.idcrop
   , c.crop
   , c.descriptor
   , c.eurostat
 from crops@CGMS14SYS_ASSISTSAN c
|}
<!-- end -->



<!-- start -->
=== GLOBAL_CROP_PARAMETERS ===
* Description: 
* Use: 
* Type: ''Materialized View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| MULTI || NOT NULL || VARCHAR2(1) ||  || 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  || 
|-
|}


'''definition:'''
 select
     cp.idcrop_parameter
   , cp.crop_parameter
   , cp.descriptor
   , cp.multi
   , cp.idcategory
   , c.category
 from
     crop_parameters@CGMS14SYS_ASSISTSAN cp
   , categories@CGMS14SYS_ASSISTSAN c
 where cp.idcategory = c.idcategory
|}
<!-- end -->



<!-- start -->
=== GLOBAL_GRIDS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  || 
|-
| LATITUDE || NOT NULL || NUMBER(22) ||  || 
|-
| LONGITUDE || NOT NULL || NUMBER(22) ||  || 
|-
| ALTITUDE || NOT NULL || NUMBER(22) ||  || 
|-
| ALTITUDE_16 ||  || NUMBER(22) ||  || 
|-
| ALTITUDE_25 ||  || NUMBER(22) ||  || 
|-
| X || NOT NULL || NUMBER(22) ||  || 
|-
| Y || NOT NULL || NUMBER(22) ||  || 
|-
| DISTANCE_FROM_COAST ||  || NUMBER(22) ||  || 
|-
| CLIMATE_BARRIER ||  || NUMBER(22) ||  || 
|-
| HAS_LAND || NOT NULL || VARCHAR2(1) ||  || 
|-
| GRID_SOURCE || NOT NULL || VARCHAR2(20) ||  || 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  || 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  || 
|-
|}


'''definition:'''
 select
     g.idgrid
   , g.idgrid_source
   , idoriginal_code
   , latitude
   , longitude
   , altitude
   , altitude_16
   , altitude_25
   , x
   , y
   , distance_from_coast
   , climate_barrier
   , has_land
   , grid_source
   , resolution
   , unit
 from grids@CGMS14SYS_ASSISTSAN g
   , windows@CGMS14SYS_ASSISTSAN w
   , grid_sources@CGMS14SYS_ASSISTSAN gs
 where g.idgrid_source = gs.idgrid_source
   and gs.idwindow = w.idwindow
|}
<!-- end -->



<!-- start -->
=== GLOBAL_GRID_SOURCES ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  || 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  || 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  || 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  || 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  || 
|-
| DESCRIPTION ||  || VARCHAR2(255) ||  || 
|-
| UNC ||  || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
     idgrid_source
   , gs.idwindow
   , w.window
   , w.name
   , gs.resolution
   , gs.unit
   , gs.description
   , gs.unc
 from grid_sources@CGMS14SYS_ASSISTSAN gs
   , windows@CGMS14SYS_ASSISTSAN w
 where gs.idwindow = w.idwindow
|}
<!-- end -->



<!-- start -->
=== GLOBAL_LINK_COVERWINDOW_SOURCE ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  || 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  || 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCOVER_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER_SOURCE || NOT NULL || VARCHAR2(30) ||  || 
|-
| COVER_SOURCE_DESCRIPTOR ||  || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
     lcws.idwindow
   , w.window
   , w.name
   , lcws.idcover
   , c.cover
   , lcws.idcover_source
   , cover_source
   , cs.descriptor as cover_source_descriptor
 from link_cover_window_source@CGMS14SYS_ASSISTSAN lcws
   , windows@CGMS14SYS_ASSISTSAN w
   , covers@CGMS14SYS_ASSISTSAN c
   , cover_sources@CGMS14SYS_ASSISTSAN cs
 where lcws.idwindow = w.idwindow
   and lcws.idcover = c.idcover
   and lcws.idcover_source = cs.idcover_source
 order by w.idwindow
   , c.idcover
   , cs.idcover_source
|}
<!-- end -->



<!-- start -->
=== GLOBAL_MODELS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  || 
|-
|}


'''definition:'''
 select
     m.idmodel
   , m.model
   , m.descriptor
 from models@CGMS14SYS_ASSISTSAN m
|}
<!-- end -->



<!-- start -->
=== GLOBAL_REGIONS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  || 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  || 
|-
| POPULATION ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     r.idregion
   , r.region
   , r.name
   , r.continent
   , r.population
 from regions@CGMS14SYS_ASSISTSAN r
|}
<!-- end -->



<!-- start -->
=== GLOBAL_REGION_ELEMENTS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION_ELEMENT || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  || 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| GLOBAL_NAME || NOT NULL || VARCHAR2(255) ||  || 
|-
| LOCAL_NAME ||  || VARCHAR2(255) ||  || 
|-
| REGION_LEVEL || NOT NULL || NUMBER(22) ||  || 
|-
| POPULATION ||  || NUMBER(22) ||  || 
|-
| STANDARD || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDFATHER ||  || NUMBER(22, 12) ||  || 
|-
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  || 
|-
|}


'''definition:'''
 select
     re.idregion_element
   , re.idoriginal_code
   , re.idregion
   , r.continent
   , r.region
   , r.name global_name
   , re.name local_name
   , re.region_level
   , r.population
   , re.standard
   , re.idfather
   , re.idregion_source
   , rs.region_source
 from region_elements@CGMS14SYS_ASSISTSAN re
   , regions@CGMS14SYS_ASSISTSAN r
   , region_sources@CGMS14SYS_ASSISTSAN rs
 where re.idregion = r.idregion
   and re.idregion_source = rs.idregion_source
|}
<!-- end -->



<!-- start -->
=== GLOBAL_REGION_SOURCES ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| REGION_SOURCE || NOT NULL || VARCHAR2(20) ||  || 
|-
| DESCRIPTION ||  || VARCHAR2(255) ||  || 
|-
| UNC ||  || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
     r.idregion_source
   , r.region_source
   , r.description
   , r.unc
 from region_sources@CGMS14SYS_ASSISTSAN r
 order by idregion_source
|}
<!-- end -->



<!-- start -->
=== GLOBAL_SOIL_SOURCES ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| SOIL_SOURCE || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
     s.idsoil_source
   , s.soil_source
   , s.descriptor
 from soil_sources@CGMS14SYS_ASSISTSAN s
|}
<!-- end -->



<!-- start -->
=== GLOBAL_STATISTIC_SOURCES ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATISTIC_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| STATISTIC_SOURCE || NOT NULL || VARCHAR2(60) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
     s.idstatistic_source
   , s.statistic_source
   , s.descriptor
 from statistic_sources@CGMS14SYS_ASSISTSAN s
|}
<!-- end -->



<!-- start -->
=== GLOBAL_SUITABILITY_PROPERTIES ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
     p.idsuitability_property
   , p.suitability_property
   , p.descriptor
 from suitability_properties@CGMS14SYS_ASSISTSAN p
|}
<!-- end -->



<!-- start -->
=== GLOBAL_THRESHOLDS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDTHRESHOLD || NOT NULL || NUMBER(22, 12) ||  || 
|-
| THRESHOLD || NOT NULL || VARCHAR2(30) ||  || 
|-
| INDICATOR || NOT NULL || VARCHAR2(30) ||  || 
|-
| OPERATOR || NOT NULL || VARCHAR2(30) ||  || 
|-
| VALUE_MIN || NOT NULL || NUMBER(22) ||  || 
|-
| VALUE_MAX || NOT NULL || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     t.idthreshold
   , t.threshold
   , t.indicator
   , t.operator
   , t.value_min
   , t.value_max
 from thresholds@CGMS14SYS_ASSISTSAN t
   , windows@CGMS14SYS_ASSISTSAN w
 where t.idwindow = w.idwindow
|}
<!-- end -->



<!-- start -->
=== GLOBAL_TIME_DIMENSIONS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| DAY || NOT NULL || DATE ||  || 
|-
| DECADE ||  || NUMBER(22) ||  || 
|-
| DECADE_ID ||  || NUMBER(22) ||  || 
|-
| MONTH ||  || NUMBER(22) ||  || 
|-
| MONTH_ID ||  || NUMBER(22) ||  || 
|-
| QUARTER ||  || NUMBER(22) ||  || 
|-
| QUARTER_ID ||  || NUMBER(22) ||  || 
|-
| YEAR ||  || NUMBER(22) ||  || 
|-
| LAST_DAY_DECADE ||  || VARCHAR2(1) ||  || 
|-
|}


'''definition:'''
 select
     t.day
   , t.decade
   , t.decade_id
   , t.month
   , t.month_id
   , t.quarter
   , t.quarter_id
   , t.year
   , t.last_day_decade
 from time_dimensions@CGMS14SYS_ASSISTSAN t
|}
<!-- end -->



<!-- start -->
=== GLOBAL_TREATMENTS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDTREATMENT || NOT NULL || NUMBER(22, 12) ||  || 
|-
| TREATMENT || NOT NULL || VARCHAR2(60) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
     t.idtreatment
   , t.treatment
   , t.descriptor
 from treatments@cgms14sys_assistsan t
|}
<!-- end -->



<!-- start -->
=== GLOBAL_WINDOWS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDWINDOW || NOT NULL || NUMBER(22, 12) ||  || 
|-
| WINDOW || NOT NULL || VARCHAR2(10) ||  || 
|-
| NAME || NOT NULL || VARCHAR2(255) ||  || 
|-
| REFERENCE_SYSTEM || NOT NULL || VARCHAR2(2000) ||  || 
|-
| DESCRIPTOR ||  || VARCHAR2(255) ||  || 
|-
| MAX_LAT || NOT NULL || NUMBER(22) ||  || 
|-
| MAX_LON || NOT NULL || NUMBER(22) ||  || 
|-
| MIN_LAT || NOT NULL || NUMBER(22) ||  || 
|-
| MIN_LON || NOT NULL || NUMBER(22) ||  || 
|-
| MAX_X || NOT NULL || NUMBER(22) ||  || 
|-
| MAX_Y || NOT NULL || NUMBER(22) ||  || 
|-
| MIN_X || NOT NULL || NUMBER(22) ||  || 
|-
| MIN_Y || NOT NULL || NUMBER(22) ||  || 
|-
| ROI ||  || NUMBER(22, 3) ||  || 
|-
|}


'''definition:'''
 select
     w.idwindow
   , w.window
   , w.name
   , w.reference_system
   , w.descriptor
   , w.max_lat
   , w.max_lon
   , w.min_lat
   , w.min_lon
   , w.max_x
   , w.max_y
   , w.min_x
   , w.min_y
   , w.roi
 from windows@CGMS14SYS_ASSISTSAN w
|}
<!-- end -->



== LINK-datasets ==
{{TocTable|content=
{{TocRow|#LINK_CROP_AGGREGATION|3.1 LINK_CROP_AGGREGATION}}
{{TocRow|#LINK_CROP_CALENDARS|3.2 LINK_CROP_CALENDARS}}
{{TocRow|#LINK_CROP_PARAMETERS|3.3 LINK_CROP_PARAMETERS}}
{{TocRow|#LINK_CROP_PARAMETERS_CROP|3.4 LINK_CROP_PARAMETERS_CROP}}
{{TocRow|#LINK_CROP_PARAMETERS_MODEL|3.5 LINK_CROP_PARAMETERS_MODEL}}
{{TocRow|#LINK_CROP_PARAMETRIZATION|3.6 LINK_CROP_PARAMETRIZATION}}
{{TocRow|#LINK_CROP_SPATIALIZATIONS|3.7 LINK_CROP_SPATIALIZATIONS}}
{{TocRow|#LINK_CROP_STU|3.8 LINK_CROP_STU}}
{{TocRow|#LINK_CROP_VARIETY_PARAMETERS|3.9 LINK_CROP_VARIETY_PARAMETERS}}
{{TocRow|#LINK_GRID_COVER|3.10 LINK_GRID_COVER}}
{{TocRow|#LINK_GRID_REGION_COVER|3.11 LINK_GRID_REGION_COVER}}
{{TocRow|#LINK_REGION_COVER|3.12 LINK_REGION_COVER}}
{{TocRow|#LINK_SIMULATION_UNIT|3.13 LINK_SIMULATION_UNIT}}
{{TocRow|#LINK_SIMULATION_UNIT_CROP|3.14 LINK_SIMULATION_UNIT_CROP}}
{{TocRow|#LINK_SMU_GRID_COVER|3.15 LINK_SMU_GRID_COVER}}
{{TocRow|#LINK_SMU_GRID_REGION_COVER|3.16 LINK_SMU_GRID_REGION_COVER}}
{{TocRow|#LINK_SMU_STU|3.17 LINK_SMU_STU}}
{{TocRow|#LINK_STU_HORIZONS|3.18 LINK_STU_HORIZONS}}
{{TocRow|#LINK_STU_WEIGHTED_PARAMETERS|3.19 LINK_STU_WEIGHTED_PARAMETERS}}
{{TocRow|#LINK_SUITABILITY_RULES|3.20 LINK_SUITABILITY_RULES}}
}}




<!-- start -->
=== LINK_CROP_AGGREGATION ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  || 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  || 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  || 
|-
|}


'''definition:'''
 select
     ca.idcrop_aggregation
   , ca.idcrop
   , c.crop
   , c.descriptor
   , cp.idmodel
   , m.model
   , m.descriptor
   , ca.idcrop_parametrization
   , cp.crop_parametrization
   , cp.descriptor as parametrization_descriptor
 from cgms14chn.crop_aggregations ca
   , cgms14chn.crop_parametrizations cp
   , cgms14chn.global_models m
   , cgms14chn.global_crops c
 where ca.idcrop = c.idcrop
   and   ca.idcrop_parametrization = cp.idcrop_parametrization
   and   cp.idmodel = m.idmodel
 order by ca.idcrop_aggregation
|}
<!-- end -->



<!-- start -->
=== LINK_CROP_CALENDARS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| START_PERIOD || NOT NULL || VARCHAR2(20) ||  || 
|-
| START_DATE ||  || DATE ||  || 
|-
| END_DATE ||  || DATE ||  || 
|-
| DURATION ||  || NUMBER(22) ||  || 
|-
| START_DOY ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     cp.idcrop_parametrization
   , cp.crop_parametrization
   , m.idmodel
   , m.model
   , c.idcover
   , c.cover
   , cc.idgrid
   , cc.year
   , cc.start_period
   ,
   case
      when start_period = 'emergence' then emergence
      when start_period = 'sowing' then sowing
   end
     start_date
   ,
   case
      when end_period = 'harvesting' then harvesting
      when end_period = 'maturity' then maturity
   end
     end_date
   , cc.duration
   , cc.start_doy
 from global_models m
   , global_covers c
   , crop_parametrizations cp
   , crop_calendars cc
 where cc.idcrop_parametrization = cp.idcrop_parametrization
   and cp.idmodel = m.idmodel
   and cp.idcover = c.idcover
   and cp.active_parametrization = 'Y'
  order by cc.idcrop_parametrization
    , cc.idgrid
    , cc.year
|}
<!-- end -->



<!-- start -->
=== LINK_CROP_PARAMETERS ===
* Description: 
* Use: 
* Type: ''Materialized View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| IDCATEGORY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CATEGORY || NOT NULL || VARCHAR2(30) ||  || 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  || 
|-
| YVALUE ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     cp.idcrop_parametrization
   , cp.crop_parametrization
   , m.idmodel
   , m.model
   , c.idcover
   , c.cover
   , cps.idcrop_parameter
   , cps.crop_parameter
   , cps.descriptor
   , cps.idcategory
   , cps.category
   , cpp.xvalue
   , cpp.yvalue
 from
     global_models m
   , global_covers c
   , crop_parametrization_parameter cpp
   , crop_parametrizations cp
   , global_crop_parameters cps
 where cpp.idcrop_parametrization = cp.idcrop_parametrization
 and   cpp.idcrop_parameter       = cps.idcrop_parameter
 and   cp.idcover                 = c.idcover
 and   cp.idmodel                 = m.idmodel
 and   cp.active_parametrization  = 'Y'
 
|}
<!-- end -->



<!-- start -->
=== LINK_CROP_PARAMETERS_CROP ===
* Description: 
* Use: 
* Type: ''Materialized View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  || 
|-
| YVALUE ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     cp.idcrop_parametrization
   , cp.crop_parametrization
   , m.idmodel
   , m.model
   , c.idcover
   , c.cover
   , cps.idcrop_parameter
   , cps.crop_parameter
   , cps.descriptor
   , cpp.xvalue
   , cpp.yvalue
 from
     global_models m
   , global_covers c
   , crop_parametrization_parameter cpp
   , crop_parametrizations cp
   , global_crop_parameters cps
 where cpp.idcrop_parametrization = cp.idcrop_parametrization
 and   cpp.idcrop_parameter       = cps.idcrop_parameter
 and   cp.idcover                 = c.idcover
 and   cp.idmodel                 = m.idmodel
 and   cp.active_parametrization  = 'Y'
 and   cps.category               = 'CROP'
 
|}
<!-- end -->



<!-- start -->
=== LINK_CROP_PARAMETERS_MODEL ===
* Description: 
* Use: 
* Type: ''Materialized View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  || 
|-
| YVALUE ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     cp.idcrop_parametrization
   , cp.crop_parametrization
   , m.idmodel
   , m.model
   , c.idcover
   , c.cover
   , cps.idcrop_parameter
   , cps.crop_parameter
   , cps.descriptor
   , cpp.xvalue
   , cpp.yvalue
 from
     global_models m
   , global_covers c
   , crop_parametrization_parameter cpp
   , crop_parametrizations cp
   , global_crop_parameters cps
 where cpp.idcrop_parametrization = cp.idcrop_parametrization
 and   cpp.idcrop_parameter       = cps.idcrop_parameter
 and   cp.idcover                 = c.idcover
 and   cp.idmodel                 = m.idmodel
 and   cp.active_parametrization  = 'Y'
 and   cps.category               = 'MODEL'
 
|}
<!-- end -->



<!-- start -->
=== LINK_CROP_PARAMETRIZATION ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| COVER_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  || 
|-
|}


'''definition:'''
 select
     cp.idcrop_parametrization
   , cp.crop_parametrization
   , cp.descriptor
   , cp.idmodel
   , m.model
   , m.descriptor
   , c.idcover
   , c.cover
   , c.descriptor
 from crop_parametrizations cp
   , global_models m
   , global_covers c
 where cp.idmodel = m.idmodel
   and   cp.idcover = c.idcover
 order by cp.idcrop_parametrization
|}
<!-- end -->



<!-- start -->
=== LINK_CROP_SPATIALIZATIONS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  || 
|-
| YVALUE ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     cp.idcrop_parametrization
   , cp.crop_parametrization
   , m.idmodel
   , m.model
   , c.idcover
   , c.cover
   , cs.idgrid
   , v.idvariety
   , v.variety
   , cps.idcrop_parameter
   , cps.crop_parameter
   , cps.descriptor
   , cvp.xvalue
   , cvp.yvalue
 from global_models m
   , global_covers c
   , crop_varieties v
   , crop_parametrizations cp
   , crop_spatializations cs
   , global_crop_parameters cps
   , crop_variety_parameters cvp
 where cs.idcrop_parametrization = cp.idcrop_parametrization
   and cp.idcover = c.idcover
   and cs.idvariety = v.idvariety
   and cp.idmodel = m.idmodel
   and cs.idvariety = cvp.idvariety
   and cvp.idcrop_parameter = cps.idcrop_parameter
   and cp.active_parametrization = 'y'
 order by cs.idcrop_parametrization
   , cs.idgrid
   , cps.crop_parameter
|}
<!-- end -->



<!-- start -->
=== LINK_CROP_STU ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== LINK_CROP_VARIETY_PARAMETERS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COVER || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDVARIETY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| VARIETY || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDCROP_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETER || NOT NULL || VARCHAR2(40) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| XVALUE || NOT NULL || NUMBER(22) ||  || 
|-
| YVALUE ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     "IDCROP_PARAMETRIZATION","CROP_PARAMETRIZATION","IDMODEL","MODEL","IDCOVER","COVER","IDVARIETY","VARIETY","IDCROP_PARAMETER","CROP_PARAMETER","DESCRIPTOR","XVALUE","YVALUE"
   from
     (
     select distinct
         cp.idcrop_parametrization
       , cp.crop_parametrization
       , m.idmodel
       , m.model
       , c.idcover
       , c.cover
       , v.idvariety
       , v.variety
       , cps.idcrop_parameter
       , cps.crop_parameter
       , cps.descriptor
       , cvp.xvalue
       , cvp.yvalue
     from cgms14chn.global_models m
       , global_covers c
       , crop_varieties v
       , crop_parametrizations cp
       , crop_spatializations cs
       , global_crop_parameters cps
       , crop_variety_parameters cvp
     where cs.idcrop_parametrization = cp.idcrop_parametrization
       and cp.idcover = c.idcover
       and cs.idvariety = v.idvariety
       and cp.idmodel = m.idmodel
       and cs.idvariety = cvp.idvariety
       and cvp.idcrop_parameter = cps.idcrop_parameter
       and cp.active_parametrization = 'Y'
     ) a
   order by idcrop_parametrization
     , idvariety
     , crop_parameter
|}
<!-- end -->



<!-- start -->
=== LINK_GRID_COVER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| AREA || NOT NULL || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== LINK_GRID_REGION_COVER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| AREA || NOT NULL || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== LINK_REGION_COVER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| AREA || NOT NULL || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== LINK_SIMULATION_UNIT ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
|}


'''definition:'''
 select
     distinct lgsc.idgrid
   , lss.idstu
 from link_crop_stu lcs
   , link_smu_grid_cover lgsc
   , link_smu_stu lss
   , crop_aggregations ca
   , crop_parametrizations cp
 where lcs.idstu = lss.idstu
   and   lss.idsmu = lgsc.idsmu
   and   lcs.idcrop = ca.idcrop
   and   ca.idcrop_parametrization = cp.idcrop_parametrization
   and   cp.idcover = lgsc.idcover
 order by lgsc.idgrid
   , lss.idstu
|}
<!-- end -->



<!-- start -->
=== LINK_SIMULATION_UNIT_CROP ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
|}


'''definition:'''
 select
 distinct
     ca.idcrop_parametrization
   , lgsc.idgrid
   , lss.idstu
 from
     link_crop_stu lcs
   , link_smu_grid_cover lgsc
   , link_smu_stu lss
   , crop_aggregations ca
   , crop_parametrizations cp
 where lcs.idstu                 = lss.idstu
 and   lss.idsmu                 = lgsc.idsmu
 and   lcs.idcrop                = ca.idcrop
 and   ca.idcrop_parametrization = cp.idcrop_parametrization
 and   cp.idcover                = lgsc.idcover
 order by
     ca.idcrop_parametrization
   , lgsc.idgrid
   , lss.idstu
|}
<!-- end -->



<!-- start -->
=== LINK_SMU_GRID_COVER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| AREA || NOT NULL || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== LINK_SMU_GRID_REGION_COVER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| AREA || NOT NULL || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== LINK_SMU_STU ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| PERCENTAGE || NOT NULL || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== LINK_STU_HORIZONS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DEPTH_MIN || NOT NULL || NUMBER(22, 5) ||  || 
|-
| DEPTH_MAX || NOT NULL || NUMBER(22, 5) ||  || 
|-
| HORIZON_LEVEL || NOT NULL || NUMBER(22, 1) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== LINK_STU_WEIGHTED_PARAMETERS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| SAND ||  || NUMBER(22) ||  || 
|-
| SILT ||  || NUMBER(22) ||  || 
|-
| CLAY ||  || NUMBER(22) ||  || 
|-
| SOIL_MOISTURE_WP ||  || NUMBER(22) ||  || 
|-
| SOIL_MOISTURE_FC ||  || NUMBER(22) ||  || 
|-
| SOIL_MOISTURE_SAT ||  || NUMBER(22) ||  || 
|-
| BULK_DENSITY ||  || NUMBER(22) ||  || 
|-
| ORGANIC_CARBON ||  || NUMBER(22) ||  || 
|-
| DEPTH ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     idstu                                                                                 idstu
   , sum(sand                      * (depth_max - depth_min)) / sum(depth_max - depth_min) sand
   , sum(silt                      * (depth_max - depth_min)) / sum(depth_max - depth_min) silt
   , sum(clay                      * (depth_max - depth_min)) / sum(depth_max - depth_min) clay
   , sum(soil_moisture_content_wp  * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_wp
   , sum(soil_moisture_content_fc  * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_fc
   , sum(soil_moisture_content_sat * (depth_max - depth_min)) / sum(depth_max - depth_min) soil_moisture_sat
   , sum(bulk_density              * (depth_max - depth_min)) / sum(depth_max - depth_min) bulk_density
   , sum(organic_carbon            * (depth_max - depth_min)) / sum(depth_max - depth_min) organic_carbon
   , sum(depth_max - depth_min)                                                            depth
 from
     link_stu_horizons  lsh
   , soil_horizons      sh
 where lsh.idhorizon = sh.idhorizon
 group by idstu
|}
<!-- end -->



<!-- start -->
=== LINK_SUITABILITY_RULES ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP || NOT NULL || VARCHAR2(30) ||  || 
|-
| CROP_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| IDMODEL || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MODEL || NOT NULL || VARCHAR2(30) ||  || 
|-
| MODEL_DESCRIPTOR || NOT NULL || VARCHAR2(1000) ||  || 
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| CROP_PARAMETRIZATION || NOT NULL || VARCHAR2(20) ||  || 
|-
| PARAMETRIZATION_DESCRIPTOR ||  || VARCHAR2(255) ||  || 
|-
| IDSUITABILITY_PROPERTY || NOT NULL || NUMBER(22, 12) ||  || 
|-
| SUITABILITY_PROPERTY || NOT NULL || VARCHAR2(30) ||  || 
|-
| SUITABILITY_DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| SUITABILITY_PROPERTY_MIN ||  || NUMBER(22) ||  || 
|-
| SUITABILITY_PROPERTY_MAX ||  || NUMBER(22) ||  || 
|-
| SUITABILITY_PROPERTY_VALUE ||  || VARCHAR2(30) ||  || 
|-
|}


'''definition:'''
 select
     ca.idcrop_aggregation
   , ca.idcrop
   , c.crop
   , c.descriptor
   , cp.idmodel
   , m.model
   , m.descriptor
   , ca.idcrop_parametrization
   , cp.crop_parametrization
   , cp.descriptor
   , sp.idsuitability_property
   , sp.suitability_property
   , sp.descriptor
   , csr.valuen_min
   , csr.valuen_max
   , csr.valuec
 from global_suitability_properties sp
   , crop_suitability_rules         csr
   , global_crops                   c
   , crop_aggregations              ca
   , crop_parametrizations          cp
   , global_models                  m
 where   ca.idcrop                  = c.idcrop
   and   ca.idcrop_parametrization  = cp.idcrop_parametrization
   and   cp.idmodel                 = m.idmodel
   and   ca.idcrop                  = csr.idcrop
   and   csr.idsuitability_property = sp.idsuitability_property
 order by ca.idcrop_aggregation
   , ca.idcrop
   , csr.idsuitability_property
|}
<!-- end -->



== SIM-datasets ==
{{TocTable|content=
{{TocRow|#SIM_BLAST_HRES_GRID|4.1 SIM_BLAST_HRES_GRID}}
{{TocRow|#SIM_BLAST_HRES_GRID_LTA|4.2 SIM_BLAST_HRES_GRID_LTA}}
{{TocRow|#SIM_BLAST_HRES_REGION|4.3 SIM_BLAST_HRES_REGION}}
{{TocRow|#SIM_BLAST_HRES_REGION_LTA|4.4 SIM_BLAST_HRES_REGION_LTA}}
{{TocRow|#SIM_WARM_HRES_GRID|4.5 SIM_WARM_HRES_GRID}}
{{TocRow|#SIM_WARM_HRES_GRID_LTA|4.6 SIM_WARM_HRES_GRID_LTA}}
{{TocRow|#SIM_WARM_HRES_REGION|4.7 SIM_WARM_HRES_REGION}}
{{TocRow|#SIM_WARM_HRES_REGION_LTA|4.8 SIM_WARM_HRES_REGION_LTA}}
{{TocRow|#SIM_WOFOST_HRES_EMU|4.9 SIM_WOFOST_HRES_EMU}}
{{TocRow|#SIM_WOFOST_HRES_EMU_LTA|4.10 SIM_WOFOST_HRES_EMU_LTA}}
{{TocRow|#SIM_WOFOST_HRES_GRID|4.11 SIM_WOFOST_HRES_GRID}}
{{TocRow|#SIM_WOFOST_HRES_GRID_LTA|4.12 SIM_WOFOST_HRES_GRID_LTA}}
{{TocRow|#SIM_WOFOST_HRES_REGION|4.13 SIM_WOFOST_HRES_REGION}}
{{TocRow|#SIM_WOFOST_HRES_REGION_LTA|4.14 SIM_WOFOST_HRES_REGION_LTA}}
{{TocRow|#SIM_WOFOST_HRES_STU|4.15 SIM_WOFOST_HRES_STU}}
}}




<!-- start -->
=== SIM_BLAST_HRES_GRID ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_BLAST_HRES_GRID_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| AVG_BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| AVG_BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| AVG_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  || 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| AVG_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| AVG_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| MIN_BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| MIN_BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| MIN_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  || 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MIN_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| MIN_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| MAX_BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| MAX_BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| MAX_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  || 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MAX_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| MAX_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| STD_BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| STD_BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  || 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_GAIPOTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_GAIWITHBLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_AGBPOTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_AGBWITHBLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RUE_WITH_BLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_HUMIDITYMINIMUM ||  || NUMBER(22, 2) ||  || 
|-
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_BLAST_HRES_REGION ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| DAYSWITHMEDIUMINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_BLAST_HRES_REGION_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| AVG_BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| AVG_BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| AVG_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| AVG_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  || 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| AVG_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| AVG_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| AVG_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| MIN_BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| MIN_BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| MIN_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MIN_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  || 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MIN_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MIN_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| MIN_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| MAX_BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| MAX_BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| MAX_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MAX_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  || 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MAX_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| MAX_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| MAX_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLASTRISKLEVEL ||  || NUMBER(22, 8) ||  || 
|-
| STD_BLASTINFECTION ||  || NUMBER(22, 1) ||  || 
|-
| STD_BLASTSPORULATION ||  || NUMBER(22, 1) ||  || 
|-
| STD_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_GAIPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_GAIWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_AGBPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_AGBWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| STD_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 8) ||  || 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| STD_RUE_POTENTIAL ||  || NUMBER(22, 12) ||  || 
|-
| STD_RUE_WITH_BLAST ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 12) ||  || 
|-
| STD_HUMIDITYMINIMUM ||  || NUMBER(22, 12) ||  || 
|-
| STD_HUMIDITYMAXIMUM ||  || NUMBER(22, 12) ||  || 
|-
| NUM_BLASTRISKLEVEL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLASTINFECTION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLASTSPORULATION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LEAVESBIOMASSPOTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LEAVESBIOMASSWITHBLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_GAIPOTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_GAIWITHBLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_AGBPOTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_AGBWITHBLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_STORAGEORGANSPOTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_STORAGEORGANSWITHBLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DAYSWITHLOWINFECTIONRISK ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DAYSWITHMEDIUMINFECTIONRSK ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RUE_POTENTIAL ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RUE_WITH_BLAST ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_EFFECT_ON_RUE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_HUMIDITYMINIMUM ||  || NUMBER(22, 2) ||  || 
|-
| NUM_HUMIDITYMAXIMUM ||  || NUMBER(22, 2) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WARM_HRES_GRID ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WARM_HRES_GRID_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  || 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  || 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  || 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  || 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  || 
|-
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WARM_HRES_REGION ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_ABIOTIC_LIM_YI_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| BLAST_ABIOTIC_LIM_YI_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| FORC_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| FORC_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| FORC_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WARM_HRES_REGION_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| AVG_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| AVG_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  || 
|-
| AVG_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| AVG_TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MIN_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MIN_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  || 
|-
| MIN_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MIN_TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| MAX_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| MAX_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  || 
|-
| MAX_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| MAX_TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 12) ||  || 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_SPIKELET_STERILITY ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 12) ||  || 
|-
| STD_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 12) ||  || 
|-
| STD_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 12) ||  || 
|-
| STD_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 8) ||  || 
|-
| STD_TRANSPIRATION ||  || NUMBER(22, 12) ||  || 
|-
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_ABIOTIC_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_ABIOTIC_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_SPIKELET_STERILITY ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_ABIOTIC_LIMYIBIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_BLAST_ABIOTIC_LIMYISTORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FORC_POTENTIAL_YIBIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FORC_POTENTIAL_YISTORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FORC_POTENTIAL_LEAFAREAIDX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DAYSWITHHIGHINFECTIONRISK ||  || NUMBER(22, 2) ||  || 
|-
| NUM_TRANSPIRATION ||  || NUMBER(22, 2) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WOFOST_HRES_EMU ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| FSM ||  || NUMBER(22, 3) ||  || 
|-
| FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WOFOST_HRES_EMU_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| AVG_FSM ||  || NUMBER(22, 3) ||  || 
|-
| AVG_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| MIN_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| MIN_FSM ||  || NUMBER(22, 3) ||  || 
|-
| MIN_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| MIN_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| MIN_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MAX_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| MAX_FSM ||  || NUMBER(22, 3) ||  || 
|-
| MAX_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| MAX_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| MAX_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| MAX_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| MAX_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| STD_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| STD_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| STD_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| STD_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| STD_FSM ||  || NUMBER(22, 3) ||  || 
|-
| STD_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| STD_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| STD_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FSM ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FSMUR ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  || 
|-
| NUM_SOIL_EVAPORATION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LOSS_TO_SUBSOIL ||  || NUMBER(22, 2) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WOFOST_HRES_GRID ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| FSM ||  || NUMBER(22, 3) ||  || 
|-
| FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WOFOST_HRES_GRID_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| AVG_FSM ||  || NUMBER(22, 3) ||  || 
|-
| AVG_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| MIN_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| MIN_FSM ||  || NUMBER(22, 3) ||  || 
|-
| MIN_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| MIN_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| MIN_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MAX_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| MAX_FSM ||  || NUMBER(22, 3) ||  || 
|-
| MAX_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| MAX_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| MAX_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| MAX_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| MAX_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| STD_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| STD_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| STD_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| STD_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| STD_FSM ||  || NUMBER(22, 3) ||  || 
|-
| STD_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| STD_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| STD_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FSM ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FSMUR ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  || 
|-
| NUM_SOIL_EVAPORATION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LOSS_TO_SUBSOIL ||  || NUMBER(22, 2) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WOFOST_HRES_REGION ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| FSM ||  || NUMBER(22, 3) ||  || 
|-
| FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WOFOST_HRES_REGION_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_AGGREGATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| AVG_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| AVG_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| AVG_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| AVG_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| AVG_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| AVG_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| AVG_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| AVG_FSM ||  || NUMBER(22, 3) ||  || 
|-
| AVG_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| AVG_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| AVG_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| AVG_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| AVG_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MIN_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MIN_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MIN_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| MIN_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| MIN_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| MIN_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| MIN_FSM ||  || NUMBER(22, 3) ||  || 
|-
| MIN_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| MIN_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| MIN_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| MIN_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| MIN_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| MAX_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MAX_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| MAX_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| MAX_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| MAX_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| MAX_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| MAX_FSM ||  || NUMBER(22, 3) ||  || 
|-
| MAX_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| MAX_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| MAX_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| MAX_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| MAX_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| STD_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| STD_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| STD_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| STD_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| STD_DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| STD_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| STD_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| STD_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| STD_FSM ||  || NUMBER(22, 3) ||  || 
|-
| STD_FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| STD_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| STD_RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| STD_SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| STD_LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
| NUM_POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 2) ||  || 
|-
| NUM_DEVELOPMENT_STAGE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 2) ||  || 
|-
| NUM_TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FSM ||  || NUMBER(22, 2) ||  || 
|-
| NUM_FSMUR ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LEAVES_DIED_BY_COLD ||  || NUMBER(22, 2) ||  || 
|-
| NUM_RUNOFF ||  || NUMBER(22, 2) ||  || 
|-
| NUM_SOIL_EVAPORATION ||  || NUMBER(22, 2) ||  || 
|-
| NUM_LOSS_TO_SUBSOIL ||  || NUMBER(22, 2) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SIM_WOFOST_HRES_STU ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| IDSERIES || NOT NULL || NUMBER(22, 12) ||  || 
|-
| POTENTIAL_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| POTENTIAL_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| WATER_LIM_YIELD_BIOMASS ||  || NUMBER(22, 8) ||  || 
|-
| WATER_LIM_YIELD_STORAGE ||  || NUMBER(22, 8) ||  || 
|-
| POTENTIAL_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| WATER_LIM_LEAF_AREA_INDEX ||  || NUMBER(22, 5) ||  || 
|-
| DEVELOPMENT_STAGE ||  || NUMBER(22, 4) ||  || 
|-
| RELATIVE_SOIL_MOISTURE ||  || NUMBER(22, 8) ||  || 
|-
| TOTAL_WATER_CONSUMPTION ||  || NUMBER(22, 8) ||  || 
|-
| TOTAL_WATER_REQUIREMENT ||  || NUMBER(22, 8) ||  || 
|-
| FSM ||  || NUMBER(22, 3) ||  || 
|-
| FSMUR ||  || NUMBER(22, 3) ||  || 
|-
| LEAVES_DIED_BY_COLD ||  || NUMBER(22, 8) ||  || 
|-
| RUNOFF ||  || NUMBER(22, 8) ||  || 
|-
| SOIL_EVAPORATION ||  || NUMBER(22, 8) ||  || 
|-
| LOSS_TO_SUBSOIL ||  || NUMBER(22, 8) ||  || 
|-
|}

|}
<!-- end -->



== SOIL-datasets ==
{{TocTable|content=
{{TocRow|#SOIL_HORIZONS|5.1 SOIL_HORIZONS}}
{{TocRow|#SOIL_INITIAL_WATER|5.2 SOIL_INITIAL_WATER}}
{{TocRow|#SOIL_SMU|5.3 SOIL_SMU}}
{{TocRow|#SOIL_STU|5.4 SOIL_STU}}
}}




<!-- start -->
=== SOIL_HORIZONS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDHORIZON || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| HORIZON || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| ORIGINAL_LEVEL ||  || NUMBER(22, 1) ||  || 
|-
| SOIL_MOISTURE_CONTENT_WP ||  || NUMBER(22) ||  || 
|-
| SOIL_MOISTURE_CONTENT_FC ||  || NUMBER(22) ||  || 
|-
| SOIL_MOISTURE_CONTENT_SAT ||  || NUMBER(22) ||  || 
|-
| DEPTH ||  || NUMBER(22, 5) ||  || 
|-
| USDA_CLASS# ||  || NUMBER(22, 3) ||  || 
|-
| USDA_CLASS ||  || VARCHAR2(8) ||  || 
|-
| GRAVEL ||  || NUMBER(22, 3) ||  || 
|-
| SAND ||  || NUMBER(22, 3) ||  || 
|-
| SILT ||  || NUMBER(22, 3) ||  || 
|-
| CLAY ||  || NUMBER(22, 3) ||  || 
|-
| BULK_DENSITY ||  || NUMBER(22, 5) ||  || 
|-
| ORGANIC_CARBON ||  || NUMBER(22, 5) ||  || 
|-
| PH_H2O ||  || NUMBER(22, 5) ||  || 
|-
| CLAY_CATION_EXCNG_CAPCTY ||  || NUMBER(22, 3) ||  || 
|-
| SOIL_CATION_EXCNG_CAPCTY ||  || NUMBER(22, 3) ||  || 
|-
| SOIL_BASE_SATURATION ||  || NUMBER(22, 3) ||  || 
|-
| TOTAL_EXCHANGEABLE_BASE ||  || NUMBER(22, 5) ||  || 
|-
| CALCIUM_CARBONATE ||  || NUMBER(22, 5) ||  || 
|-
| CALCIUM_SULPHATE ||  || NUMBER(22, 5) ||  || 
|-
| EXCHANGEABLE_SODIUM ||  || NUMBER(22, 3) ||  || 
|-
| ELECTRICAL_CONDUCTIVITY ||  || NUMBER(22, 5) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SOIL_INITIAL_WATER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP_PARAMETRIZATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| INITIAL_DEPTH_GROUND_WATER ||  || NUMBER(22, 4) ||  || 
|-
| DRAINAGE_DEPTH ||  || NUMBER(22, 3) ||  || 
|-
| ROOTING_DEPTH_POTENTIAL_WATER ||  || NUMBER(22, 3) ||  || 
|-
| POTENTIAL_WATER_STARTDATE ||  || DATE ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SOIL_SMU ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSMU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SOIL_STU ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTU || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(30) ||  || 
|-
| IDSOIL_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| STU || NOT NULL || VARCHAR2(30) ||  || 
|-
| DESCRIPTOR || NOT NULL || VARCHAR2(255) ||  || 
|-
| SOIL_WRB ||  || VARCHAR2(8) ||  || 
|-
| SOIL_WRB_CL ||  || VARCHAR2(1) ||  || 
|-
| SOIL_FAO90 ||  || VARCHAR2(8) ||  || 
|-
| SOIL_FAO90_CL ||  || VARCHAR2(1) ||  || 
|-
| SOIL_FAO85 ||  || VARCHAR2(8) ||  || 
|-
| SOIL_FAO85_CL ||  || VARCHAR2(1) ||  || 
|-
| SLOPE ||  || VARCHAR2(1) ||  || 
|-
| TEXTURE ||  || VARCHAR2(1) ||  || 
|-
| PHASE ||  || VARCHAR2(2) ||  || 
|-
| LAYERS ||  || NUMBER(22, 1) ||  || 
|-
| CALCULATED_ROOTING_DEPTH ||  || NUMBER(22, 5) ||  || 
|-
| DRAINAGE ||  || NUMBER(22, 1) ||  || 
|-
| LIMITATION_TO_AGRIC_USE1 ||  || NUMBER(22, 2) ||  || 
|-
| LIMITATION_TO_AGRIC_USE2 ||  || NUMBER(22, 2) ||  || 
|-
| OBSTACLE_TO_ROOTS ||  || NUMBER(22, 1) ||  || 
|-
| IMPERMEABLE_DEPTH_LAYER ||  || NUMBER(22, 1) ||  || 
|-
| SOIL_WATER_REGIME ||  || NUMBER(22, 1) ||  || 
|-
| DEPTH_TO_BEDROCK ||  || VARCHAR2(8) ||  || 
|-
| SOIL_FAO74 ||  || VARCHAR2(8) ||  || 
|-
| SOIL_FAO74_CL ||  || VARCHAR2(1) ||  || 
|-
|}

|}
<!-- end -->



== WEATHER-datasets ==
{{TocTable|content=
{{TocRow|#WEATHER_ERA_GRID|6.1 WEATHER_ERA_GRID}}
{{TocRow|#WEATHER_ERA_GRID_LTA|6.2 WEATHER_ERA_GRID_LTA}}
{{TocRow|#WEATHER_ERA_REGIONCOVER|6.3 WEATHER_ERA_REGIONCOVER}}
{{TocRow|#WEATHER_ERA_REGIONCOVER_LTA|6.4 WEATHER_ERA_REGIONCOVER_LTA}}
{{TocRow|#WEATHER_HIS_GRID|6.5 WEATHER_HIS_GRID}}
{{TocRow|#WEATHER_HIS_REGIONCOVER|6.6 WEATHER_HIS_REGIONCOVER}}
{{TocRow|#WEATHER_HRES_GRID|6.7 WEATHER_HRES_GRID}}
{{TocRow|#WEATHER_HRES_REGIONCOVER|6.8 WEATHER_HRES_REGIONCOVER}}
{{TocRow|#WEATHER_OBS_GRID|6.9 WEATHER_OBS_GRID}}
{{TocRow|#WEATHER_OBS_GRID_INFO|6.10 WEATHER_OBS_GRID_INFO}}
{{TocRow|#WEATHER_OBS_GRID_LTA|6.11 WEATHER_OBS_GRID_LTA}}
{{TocRow|#WEATHER_OBS_GRID_LTA_MISS|6.12 WEATHER_OBS_GRID_LTA_MISS}}
{{TocRow|#WEATHER_OBS_REGCOV_LTA_THRSHLD|6.13 WEATHER_OBS_REGCOV_LTA_THRSHLD}}
{{TocRow|#WEATHER_OBS_REGCOV_THRESHOLDS|6.14 WEATHER_OBS_REGCOV_THRESHOLDS}}
{{TocRow|#WEATHER_OBS_REGIONCOVER|6.15 WEATHER_OBS_REGIONCOVER}}
{{TocRow|#WEATHER_OBS_REGIONCOVER_LTA|6.16 WEATHER_OBS_REGIONCOVER_LTA}}
{{TocRow|#WEATHER_OBS_STATION|6.17 WEATHER_OBS_STATION}}
{{TocRow|#WEATHER_OBS_STATION_AVAIL|6.18 WEATHER_OBS_STATION_AVAIL}}
{{TocRow|#WEATHER_OBS_STATION_CALCULATED|6.19 WEATHER_OBS_STATION_CALCULATED}}
{{TocRow|#WEATHER_OBS_STATION_ERRAIN|6.20 WEATHER_OBS_STATION_ERRAIN}}
{{TocRow|#WEATHER_OBS_STATION_ERRORS|6.21 WEATHER_OBS_STATION_ERRORS}}
{{TocRow|#WEATHER_OBS_STATION_INFO|6.22 WEATHER_OBS_STATION_INFO}}
{{TocRow|#WEATHER_OBS_STATION_LTA|6.23 WEATHER_OBS_STATION_LTA}}
{{TocRow|#WEATHER_OBS_STATION_RAW|6.24 WEATHER_OBS_STATION_RAW}}
{{TocRow|#WEATHER_OPE_GRID|6.25 WEATHER_OPE_GRID}}
{{TocRow|#WEATHER_OPE_REGIONCOVER|6.26 WEATHER_OPE_REGIONCOVER}}
}}




<!-- start -->
=== WEATHER_ERA_GRID ===
* Description: forecasted weather per day and grid point in 25x25km climate grid resolution.
* Use: input for crop simulation.
* Type: ''Table''
* Remarks: The products from ECMWF (see [[Weather_Monitoring#Forecasted weather|Forecasted weather]]) are stored in separate tables. Replace <MODEL> with one of the product abbreviations (HIS, OPE, EPS, MON or SEA) to get the table name.
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || False || NUMBER ||  || 
|-
| DAY || False || DATE ||  || 
|-
| TEMPERATURE_MAX || False || NUMBER || °C || maximum air temperature at 2 m height
|-
| TEMPERATURE_MIN || False || NUMBER || °C || minimum air temperature at 2 m height
|-
| TEMPERATURE_AVG || False || NUMBER || °C || average air temperature at 2 m height
|-
| TEMPERATURE_DEW || False || NUMBER || °C || dewpoint air temperature at 2 m height
|-
| VAPOURPRESSURE || False || NUMBER || hPa || mean daily vapour pressure
|-
| WINDSPEED || False || NUMBER || m.s-1 || mean daily wind speed at 10 m height
|-
| PRECIPITATION || False || NUMBER || mm.d-1 || daily rainfall
|-
| E0 || False || NUMBER || mm.d-1 || daily transpiration of water surface
|-
| ES0 || False || NUMBER || mm.d-1 || daily transpiration of wet bare soil
|-
| ET0 || False || NUMBER || mm.d-1 || daily transpiration of crop canopy
|-
| RADIATION || False || NUMBER || kJ.m-2.d-1 || daily radiation at surface
|-
| SNOWWEQ || True || NUMBER || cm || daily mean snow water equivalent
|-
| SNOWDEPTH || True || NUMBER || cm || daily mean snow depth**
|-
| TOTALCLOUD || True || NUMBER ||  || 
|-
|}
<nowiki>*</nowiki> Not available (relevant) in HIS product<br>
<nowiki>**</nowiki> Not available in EPS, MON and SEA products<br>
|}
<!-- end -->



<!-- start -->

=== WEATHER_ERA_GRID_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| AVG_TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| MIN_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| MIN_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| MIN_TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| MAX_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| MAX_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| MAX_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| MAX_TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| STD_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| STD_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| STD_TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_ET0 || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| NUM_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| NUM_TOTALCLOUD ||  || NUMBER(22, 6) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_ERA_REGIONCOVER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| TOTALCLOUD ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_ERA_REGIONCOVER_LTA ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| AVG_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| AVG_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| AVG_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| AVG_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| AVG_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| AVG_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVG_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| AVG_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| AVG_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| AVG_TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
| MIN_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MIN_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MIN_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MIN_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MIN_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| MIN_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MIN_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| MIN_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| MIN_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| MIN_TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
| MAX_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MAX_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MAX_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MAX_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| MAX_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| MAX_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| MAX_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| MAX_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| MAX_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| MAX_TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
| STD_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| STD_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| STD_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| STD_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| STD_VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| STD_PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| STD_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| STD_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| STD_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| STD_TOTALCLOUD ||  || NUMBER(22) ||  || 
|-
| NUM_TEMPERATURE_MAX || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_TEMPERATURE_MIN || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_TEMPERATURE_AVG || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_TEMPERATURE_DEW || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_VAPOURPRESSURE || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_WINDSPEED || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_PRECIPITATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_E0 || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_ES0 || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_ET0 || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| NUM_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| NUM_SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| NUM_TOTALCLOUD ||  || NUMBER(22, 6) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_HIS_GRID ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| TOTALCLOUD ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_HIS_REGIONCOVER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_HRES_GRID ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID ||  || NUMBER(22, 12) ||  || 
|-
| DAY ||  || DATE ||  || 
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_AVG ||  || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_DEW ||  || NUMBER(22, 3) ||  || 
|-
| VAPOURPRESSURE ||  || NUMBER(22, 4) ||  || 
|-
| WINDSPEED ||  || NUMBER(22, 5) ||  || 
|-
| PRECIPITATION ||  || NUMBER(22, 4) ||  || 
|-
| E0 ||  || NUMBER(22, 4) ||  || 
|-
| ES0 ||  || NUMBER(22, 4) ||  || 
|-
| ET0 ||  || NUMBER(22, 4) ||  || 
|-
| RADIATION ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDENSITY ||  || VARCHAR2 ||  || 
|-
| TOTALCLOUD ||  || NUMBER(22) ||  || 
|-
| GEOPOTENTIAL350 ||  || VARCHAR2 ||  || 
|-
| GEOPOTENTIAL500 ||  || VARCHAR2 ||  || 
|-
| GEOPOTENTIAL800 ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_06H ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_09H ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_12H ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_15H ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_18H ||  || VARCHAR2 ||  || 
|-
|}


'''definition:'''
 select
     idgrid
   , day
   , temperature_max
   , temperature_min
   , temperature_avg
   , temperature_dew
   , vapourpressure
   , windspeed
   , precipitation
   , e0
   , es0
   , et0
   , radiation
   , snowdepth
   , snowweq
   , null snowdensity
   , totalcloud
   , null geopotential350
   , null geopotential500
   , null geopotential800
   , null humidity_06h
   , null humidity_09h
   , null humidity_12h
   , null humidity_15h
   , null humidity_18h
 from weather_era_grid
 where day <= to_date('31-12-2013','dd-mm-yyyy')
 union all
  select
     idgrid
   , day
   , temperature_max
   , temperature_min
   , temperature_avg
   , temperature_dew
   , vapourpressure
   , windspeed
   , precipitation
   , e0
   , es0
   , et0
   , radiation
   , snowdepth
   , snowweq
   , null snowdensity
   , totalcloud
   , null geopotential350
   , null geopotential500
   , null geopotential800
   , null humidity_06h
   , null humidity_09h
   , null humidity_12h
   , null humidity_15h
   , null humidity_18h
 from weather_his_grid
 where day > to_date('31-12-2013','dd-mm-yyyy')
 union all
 select
     idgrid
   , day + dayoffset day
   , temperature_max
   , temperature_min
   , temperature_avg
   , temperature_dew
   , vapourpressure
   , windspeed
   , precipitation
   , e0
   , es0
   , et0
   , radiation
   , snowdepth
   , snowweq
   , null snowdensity
   , totalcloud
   , null geopotential350
   , null geopotential500
   , null geopotential800
   , null humidity_06h
   , null humidity_09h
   , null humidity_12h
   , null humidity_15h
   , null humidity_18h
 from weather_ope_grid
 where day+dayoffset > (select max(day) from weather_his_grid)
|}
<!-- end -->



<!-- start -->
=== WEATHER_HRES_REGIONCOVER ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID ||  || NUMBER(22, 12) ||  || 
|-
| DAY ||  || DATE ||  || 
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_AVG ||  || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_DEW ||  || NUMBER(22, 3) ||  || 
|-
| VAPOURPRESSURE ||  || NUMBER(22, 4) ||  || 
|-
| WINDSPEED ||  || NUMBER(22, 5) ||  || 
|-
| PRECIPITATION ||  || NUMBER(22, 4) ||  || 
|-
| E0 ||  || NUMBER(22, 4) ||  || 
|-
| ES0 ||  || NUMBER(22, 4) ||  || 
|-
| ET0 ||  || NUMBER(22, 4) ||  || 
|-
| RADIATION ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDENSITY ||  || VARCHAR2 ||  || 
|-
| TOTALCLOUD ||  || NUMBER(22) ||  || 
|-
| GEOPOTENTIAL350 ||  || VARCHAR2 ||  || 
|-
| GEOPOTENTIAL500 ||  || VARCHAR2 ||  || 
|-
| GEOPOTENTIAL800 ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_06H ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_09H ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_12H ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_15H ||  || VARCHAR2 ||  || 
|-
| HUMIDITY_18H ||  || VARCHAR2 ||  || 
|-
|}


'''definition:'''
 select
     idgrid
   , day
   , temperature_max
   , temperature_min
   , temperature_avg
   , temperature_dew
   , vapourpressure
   , windspeed
   , precipitation
   , e0
   , es0
   , et0
   , radiation
   , snowdepth
   , snowweq
   , null snowdensity
   , totalcloud
   , null geopotential350
   , null geopotential500
   , null geopotential800
   , null humidity_06h
   , null humidity_09h
   , null humidity_12h
   , null humidity_15h
   , null humidity_18h
 from weather_his_grid
 union all
 select
     idgrid
   , day + dayoffset day
   , temperature_max
   , temperature_min
   , temperature_avg
   , temperature_dew
   , vapourpressure
   , windspeed
   , precipitation
   , e0
   , es0
   , et0
   , radiation
   , snowdepth
   , snowweq
   , null snowdensity
   , totalcloud
   , null geopotential350
   , null geopotential500
   , null geopotential800
   , null humidity_06h
   , null humidity_09h
   , null humidity_12h
   , null humidity_15h
   , null humidity_18h
 from weather_ope_grid
 where idmember = 0
 and day+dayoffset > (select max(day) from weather_his_grid)
|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_GRID ===
* Description: interpolated weather data per grid per day
* Use: output for level 1, input for level 2
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE || - || calendar day
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || °C || maximum air temperature
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || °C || minimum air temperature
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || °C || average air temperature
|-
| HUMIDITY_06H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_09H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_12H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_15H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_18H ||  || NUMBER(22, 6) ||  || 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || m.s-1 || mean daily vapour pressure
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) || hPa || mean daily wind speed at 10 m height
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily rainfall
|-
| E0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of water surface
|-
| ES0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of wet bare soil
|-
| ET0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of crop canopy
|-
| RADIATION || NOT NULL || NUMBER(22, 6) || KJ.m-2.d-1 || daily radiation at surface
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || cm || daily mean snow depth
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_GRID_INFO ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE || - || 
|-
| TEMPERATURE_GROUP_SOURCE || NOT NULL || VARCHAR2(10) ||  || 
|-
| TEMPERATURE_STATION_1 || NOT NULL || NUMBER(22, 7) ||  || 
|-
| TEMPERATURE_STATION_2 ||  || NUMBER(22, 7) ||  || 
|-
| TEMPERATURE_STATION_3 ||  || NUMBER(22, 7) ||  || 
|-
| TEMPERATURE_STATION_4 ||  || NUMBER(22, 7) ||  || 
|-
| TEMPERATURE_SCORE || NOT NULL || NUMBER(22, 6) ||  || 
|-
| PRECIPITATION_SOURCE || NOT NULL || VARCHAR2(10) ||  || 
|-
| PRECIPITATION_STATION || NOT NULL || NUMBER(22, 7) ||  || 
|-
| PRECIPITATION_SCORE || NOT NULL || NUMBER(22, 6) ||  || 
|-
| SNOWDEPTH_SOURCE ||  || VARCHAR2(10) ||  || 
|-
| SNOW_STATION ||  || NUMBER(22, 7) ||  || 
|-
| SNOW_SCORE ||  || NUMBER(22, 6) ||  || 
|-
| HUMIDITY_GROUP_SOURCE ||  || VARCHAR2(10) ||  || 
|-
| HUMIDITY_STATION ||  || NUMBER(22, 7) ||  || 
|-
| HUMIDITY_SCORE ||  || NUMBER(22, 6) ||  || 
|-
| REST_GROUP_SOURCE || NOT NULL || VARCHAR2(10) ||  || 
|-
| REST_STATION_1 || NOT NULL || NUMBER(22, 7) ||  || 
|-
| REST_STATION_2 ||  || NUMBER(22, 7) ||  || 
|-
| REST_STATION_3 ||  || NUMBER(22, 7) ||  || 
|-
| REST_STATION_4 ||  || NUMBER(22, 7) ||  || 
|-
| REST_SCORE || NOT NULL || NUMBER(22, 6) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_GRID_LTA ===
* Description: long term average interpolated weather data per grid cell per day
* Use: Monitoring extreme weather events
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 3) || °C || average maximum air temperature
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 3) || °C || average minimum air temperature
|-
| TEMPERATURE_AVG ||  || NUMBER(22, 3) || °C || average mean air temperature
|-
| PRECIPITATION ||  || NUMBER(22, 4) || mm.d-1 || average daily rainfall
|-
| RADIATION ||  || NUMBER(22, 7) || KJ.m-2.d-1 || average daily radiation at surface
|-
| VAPOURPRESSURE ||  || NUMBER(22, 4) || hPa || average mean daily vapour pressure
|-
| WINDSPEED ||  || NUMBER(22, 5) || m.s-1 || average mean daily wind speed at 10 m height
|-
| E0 ||  || NUMBER(22, 4) || mm.d-1 || average daily transpiration of water surface
|-
| ES0 ||  || NUMBER(22, 4) || mm.d-1 || average daily transpiration of wet bare soil
|-
| ET0 ||  || NUMBER(22, 4) || mm.d-1 || average daily transpiration of crop canopy
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || cm || average daily mean snow depth
|-
| MIN_TEMPERATURE_MIN ||  || NUMBER(22, 3) || °C || minimum minimum air temperature
|-
| MIN_TEMPERATURE_MAX ||  || NUMBER(22, 3) || °C || minimum maximum air temperature
|-
| MIN_TEMPERATURE_AVG ||  || NUMBER(22, 3) || °C || minimum mean air temperature
|-
| MIN_PRECIPITATION ||  || NUMBER(22, 4) || mm.d-1 || minimum daily rainfall
|-
| MIN_RADIATION ||  || NUMBER(22, 6) || KJ.m-2.d-1 || minimum daily radiation at surface
|-
| MIN_VAPOURPRESSURE ||  || NUMBER(22, 4) || hPa || minimum mean daily vapour pressure
|-
| MIN_WINDSPEED ||  || NUMBER(22, 5) || m.s-1 || minimum mean daily wind speed at 10 m height
|-
| MIN_E0 ||  || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of water surface
|-
| MIN_ES0 ||  || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of wet bare soil
|-
| MIN_ET0 ||  || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of crop canopy
|-
| MIN_SNOWDEPTH ||  || NUMBER(22, 6) || cm || minimum daily mean snow depth
|-
| MAX_TEMPERATURE_MIN ||  || NUMBER(22, 3) || °C || maximum maximum air temperature
|-
| MAX_TEMPERATURE_MAX ||  || NUMBER(22, 3) || °C || maximum maximum air temperature
|-
| MAX_TEMPERATURE_AVG ||  || NUMBER(22, 3) || °C || maximum mean air temperature
|-
| MAX_PRECIPITATION ||  || NUMBER(22, 4) || mm.d-1 || maximum daily rainfall
|-
| MAX_RADIATION ||  || NUMBER(22, 6) || KJ.m-2.d-1 || maximum daily radiation at surface
|-
| MAX_VAPOURPRESSURE ||  || NUMBER(22, 4) || hPa || maximum mean daily vapour pressure
|-
| MAX_WINDSPEED ||  || NUMBER(22, 5) || m.s-1 || maximum mean daily wind speed at 10 m height
|-
| MAX_E0 ||  || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of water surface
|-
| MAX_ES0 ||  || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of wet bare soil
|-
| MAX_ET0 ||  || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of crop canopy
|-
| MAX_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| STD_TEMPERATURE_MIN ||  || NUMBER(22, 4) || °C || standard deviation of minimum air temperature
|-
| STD_TEMPERATURE_MAX ||  || NUMBER(22, 4) || °C || standard deviation of maximum air temperature
|-
| STD_TEMPERATURE_AVG ||  || NUMBER(22, 4) || °C || standard deviation of mean air temperature
|-
| STD_PRECIPITATION ||  || NUMBER(22, 5) || mm.d-1 || standard deviation of daily rainfall
|-
| STD_RADIATION ||  || NUMBER(22, 8) || KJ.m-2.d-1 || standard deviation of daily radiation at surface
|-
| STD_VAPOURPRESSURE ||  || NUMBER(22, 6) || hPa || standard deviation of mean daily vapour pressure
|-
| STD_WINDSPEED ||  || NUMBER(22, 6) || m.s-1 || standard deviation of mean daily wind speed at 10 m height
|-
| STD_E0 ||  || NUMBER(22, 4) || mm.d-1 || standard deviation of daily transpiration of water surface
|-
| STD_ES0 ||  || NUMBER(22, 4) || mm.d-1 || standard deviation of daily transpiration of wet bare soil
|-
| STD_ET0 ||  || NUMBER(22, 4) || mm.d-1 || standard deviation of daily transpiration of crop canopy
|-
| STD_SNOWDEPTH ||  || NUMBER(22, 7) || cm || standard deviation of daily mean snow depth
|-
| NUM_TEMPERATURE_MIN ||  || NUMBER(22, 6) || - || count of air temperature
|-
| NUM_TEMPERATURE_MAX ||  || NUMBER(22, 6) || - || count of maximum air temperature
|-
| NUM_TEMPERATURE_AVG ||  || NUMBER(22, 6) || - || count of mean air temperature
|-
| NUM_PRECIPITATION ||  || NUMBER(22, 6) || - || count of daily rainfall
|-
| NUM_RADIATION ||  || NUMBER(22, 6) || - || count of daily radiation at surface
|-
| NUM_VAPOURPRESSURE ||  || NUMBER(22, 6) || - || count of mean daily vapour pressure
|-
| NUM_WINDSPEED ||  || NUMBER(22, 6) || - || count of mean daily wind speed at 10 m height
|-
| NUM_E0 ||  || NUMBER(22, 6) || - || count of daily transpiration of water surface
|-
| NUM_ES0 ||  || NUMBER(22, 6) || - || count of daily transpiration of wet bare soil
|-
| NUM_ET0 ||  || NUMBER(22, 6) || - || count of daily transpiration of crop canopy
|-
| NUM_SNOWDEPTH ||  || NUMBER(22, 6) || - || count of daily mean snow depth
|-
|}
<nowiki>*</nowiki> In script changed to 4,2. Not yet installed.
|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_GRID_LTA_MISS ===
* Description: long term average number of grid cells per country.
* Use: input for check on {{Object|WEATHER_OBS_GRID}} table (see section [[Interpolation of observed weather#Check_on_missing_grid_weather|Check on missing grid weather]]).
* Type: ''Table''
* Remarks: filled with procedure lta_missing_grid_weather.sql
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| TOTAL_GRIDS ||  || NUMBER(22, 10) || - || total number of grid cells
|-
| TOTAL_GRIDS_CC ||  || NUMBER(22, 10) || - || total number of grid cells with at least 1 crop calendar
|-
| MISSING_GRIDS ||  || NUMBER(22, 10) ||  || 
|-
| MISSING_GRIDS_CC ||  || NUMBER(22, 10) || - || total number of missing grid cells with at least 1 crop calendar
|-
| MISSING_GRIDS_ORIGINAL ||  || NUMBER(22, 10) || - || total number of missing grid cells
|-
|}
<nowiki>*</nowiki> When this threshold is passed every day, it can be manually increased to prevent triggering an email alert every day. In that case the original number is stored under MISSING_GRIDS_ORIGINAL.
|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_REGCOV_LTA_THRSHLD ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || NUMBER(22, 10) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDTHRESHOLD || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| VALUE || NOT NULL || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_REGCOV_THRESHOLDS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || NUMBER(22, 10) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDTHRESHOLD || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| VALUE || NOT NULL || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_REGIONCOVER ===
* Description: interpolated weather data per grid per administrative region
* Use: input for monitoring extreme weather events
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| DAY || NOT NULL || DATE || - || calendar day
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) || °C || maximum daily air temperature
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) || °C || minimum daily air temperature
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) || °C || average daily air temperature
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) || hPa || mean daily vapour pressure
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) || m.s-1 || mean daily wind speed at 10 m height
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily rainfall
|-
| E0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of water surface
|-
| ES0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of wet bare soil
|-
| ET0 || NOT NULL || NUMBER(22, 4) || mm.d-1 || daily transpiration of crop canopy
|-
| RADIATION || NOT NULL || NUMBER(22, 6) || KJ.m-2.d-1 || daily radiation at surface
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || cm || daily mean snow depth
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_REGIONCOVER_LTA ===
* Description: long term average interpolated weather data per administrative region per day
* Use: Monitoring extreme weather events
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 3) || °C || average maximum air temperature
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 3) || °C || average minimum air temperature
|-
| TEMPERATURE_AVG ||  || NUMBER(22, 3) || °C || average mean air temperature
|-
| PRECIPITATION ||  || NUMBER(22, 4) || mm.d-1 || average daily rainfall
|-
| RADIATION ||  || NUMBER(22, 7) || KJ.m-2.d-1 || average daily radiation at surface
|-
| VAPOURPRESSURE ||  || NUMBER(22, 4) || hPa || average mean daily vapour pressure
|-
| WINDSPEED ||  || NUMBER(22, 5) || m.s-1 || average mean daily wind speed at 10 m height
|-
| E0 ||  || NUMBER(22, 4) || mm.d-1 || average daily transpiration of water surface
|-
| ES0 ||  || NUMBER(22, 4) || mm.d-1 || average daily transpiration of wet bare soil
|-
| ET0 ||  || NUMBER(22, 4) || mm.d-1 || average daily transpiration of crop canopy
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || cm || average daily mean snow depth
|-
| MIN_TEMPERATURE_MIN ||  || NUMBER(22, 3) || °C || minimum minimum air temperature
|-
| MIN_TEMPERATURE_MAX ||  || NUMBER(22, 3) || °C || minimum maximum air temperature
|-
| MIN_TEMPERATURE_AVG ||  || NUMBER(22, 3) || °C || minimum mean air temperature
|-
| MIN_PRECIPITATION ||  || NUMBER(22, 4) || mm.d-1 || minimum daily rainfall
|-
| MIN_RADIATION ||  || NUMBER(22, 6) || KJ.m-2.d-1 || minimum daily radiation at surface
|-
| MIN_VAPOURPRESSURE ||  || NUMBER(22, 4) || hPa || minimum mean daily vapour pressure
|-
| MIN_WINDSPEED ||  || NUMBER(22, 5) || m.s-1 || minimum mean daily wind speed at 10 m height
|-
| MIN_E0 ||  || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of water surface
|-
| MIN_ES0 ||  || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of wet bare soil
|-
| MIN_ET0 ||  || NUMBER(22, 4) || mm.d-1 || minimum daily transpiration of crop canopy
|-
| MIN_SNOWDEPTH ||  || NUMBER(22, 6) || cm || minimum daily mean snow depth
|-
| MAX_TEMPERATURE_MIN ||  || NUMBER(22, 3) || °C || maximum maximum air temperature
|-
| MAX_TEMPERATURE_MAX ||  || NUMBER(22, 3) || °C || maximum maximum air temperature
|-
| MAX_TEMPERATURE_AVG ||  || NUMBER(22, 3) || °C || maximum mean air temperature
|-
| MAX_PRECIPITATION ||  || NUMBER(22, 4) || mm.d-1 || maximum daily rainfall
|-
| MAX_RADIATION ||  || NUMBER(22, 6) || KJ.m-2.d-1 || maximum daily radiation at surface
|-
| MAX_VAPOURPRESSURE ||  || NUMBER(22, 4) || hPa || maximum mean daily vapour pressure
|-
| MAX_WINDSPEED ||  || NUMBER(22, 5) || m.s-1 || maximum mean daily wind speed at 10 m height
|-
| MAX_E0 ||  || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of water surface
|-
| MAX_ES0 ||  || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of wet bare soil
|-
| MAX_ET0 ||  || NUMBER(22, 4) || mm.d-1 || maximum daily transpiration of crop canopy
|-
| MAX_SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| STD_TEMPERATURE_MIN ||  || NUMBER(22, 4) || °C || standard deviation of minimum air temperature
|-
| STD_TEMPERATURE_MAX ||  || NUMBER(22, 4) || °C || standard deviation of maximum air temperature
|-
| STD_TEMPERATURE_AVG ||  || NUMBER(22, 4) || °C || standard deviation of mean air temperature
|-
| STD_PRECIPITATION ||  || NUMBER(22, 5) || mm.d-1 || standard deviation of daily rainfall
|-
| STD_RADIATION ||  || NUMBER(22, 8) || KJ.m-2.d-1 || standard deviation of daily radiation at surface
|-
| STD_VAPOURPRESSURE ||  || NUMBER(22, 6) || hPa || standard deviation of mean daily vapour pressure
|-
| STD_WINDSPEED ||  || NUMBER(22, 6) || m.s-1 || standard deviation of mean daily wind speed at 10 m height
|-
| STD_E0 ||  || NUMBER(22, 4) || mm.d-1 || standard deviation of daily transpiration of water surface
|-
| STD_ES0 ||  || NUMBER(22, 4) || mm.d-1 || standard deviation of daily transpiration of wet bare soil
|-
| STD_ET0 ||  || NUMBER(22, 4) || mm.d-1 || standard deviation of daily transpiration of crop canopy
|-
| STD_SNOWDEPTH ||  || NUMBER(22, 7) || cm || standard deviation of daily mean snow depth
|-
| NUM_TEMPERATURE_MIN ||  || NUMBER(22, 6) || - || count of air temperature
|-
| NUM_TEMPERATURE_MAX ||  || NUMBER(22, 6) || - || count of maximum air temperature
|-
| NUM_TEMPERATURE_AVG ||  || NUMBER(22, 6) || - || count of mean air temperature
|-
| NUM_PRECIPITATION ||  || NUMBER(22, 6) || - || count of daily rainfall
|-
| NUM_RADIATION ||  || NUMBER(22, 6) || - || count of daily radiation at surface
|-
| NUM_VAPOURPRESSURE ||  || NUMBER(22, 6) || - || count of mean daily vapour pressure
|-
| NUM_WINDSPEED ||  || NUMBER(22, 6) || - || count of mean daily wind speed at 10 m height
|-
| NUM_E0 ||  || NUMBER(22, 6) || - || count of daily transpiration of water surface
|-
| NUM_ES0 ||  || NUMBER(22, 6) || - || count of daily transpiration of wet bare soil
|-
| NUM_ET0 ||  || NUMBER(22, 6) || - || count of daily transpiration of crop canopy
|-
| NUM_SNOWDEPTH ||  || NUMBER(22, 6) || - || count of daily mean snow depth
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_STATION ===
* Description: contains the station based daily meteorological data
* Use: input for level 1
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE || - || calendar day
|-
| CLOUD_TOTAL_24H ||  || NUMBER(22, 6) || oktas || not used in CGMS
|-
| CLOUD_LOW_24H ||  || NUMBER(22, 6) || oktas || not used in CGMS
|-
| CLOUD_MIDDLE_24H ||  || NUMBER(22, 6) || oktas || not used in CGMS
|-
| CLOUD_HIGH_24H ||  || NUMBER(22, 6) || oktas || not used in CGMS
|-
| SUNSHINE ||  || NUMBER(22, 6) || h || daily sunshine duration (2
|-
| RADIATION ||  || NUMBER(22, 11) || KJ.m-2.d-1 || daily global radiation at surface (1
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 6) || °C || minimum air temperature (3,4
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 6) || °C || maximum air temperature (3,4
|-
| VAPOURPRESSURE ||  || NUMBER(22, 6) || hPa || daily mean vapour pressure
|-
| WINDSPEED ||  || NUMBER(22, 6) || m.s-1 || not used in CGMS
|-
| WINDSPEED_10M ||  || NUMBER(22, 6) || m.s-1 || daily mean wind speed at 10 m height
|-
| PRECIPITATION ||  || NUMBER(22, 6) || mm.d-1 || daily rainfall
|-
| TEMPERATURE_06H ||  || NUMBER(22, 6) || °C || air temperature 6 UTC
|-
| HUMIDITY_06H ||  || NUMBER(22, 6) || % || humidity 6 UTC
|-
| TEMPERATURE_09H ||  || NUMBER(22, 6) || °C || air temperature 9 UTC
|-
| HUMIDITY_09H ||  || NUMBER(22, 6) || % || humidity 9 UTC
|-
| TEMPERATURE_12H ||  || NUMBER(22, 6) || °C || air temperature 12 UTC
|-
| HUMIDITY_12H ||  || NUMBER(22, 6) || % || humidity 12 UTC
|-
| TEMPERATURE_15H ||  || NUMBER(22, 6) || °C || air temperature 15 UTC
|-
| HUMIDITY_15H ||  || NUMBER(22, 6) || % || humidity 15 UTC
|-
| TEMPERATURE_18H ||  || NUMBER(22, 6) || °C || air temperature 18 UTC
|-
| HUMIDITY_18H ||  || NUMBER(22, 6) || % || humidity 18 UTC
|-
| STATE_SOIL ||  || NUMBER(22, 6) || - || not used in CGMS
|-
| VAPOURPRESSURE_DEF ||  || NUMBER(22, 6) || hPa || not used in CGMS
|-
| SLOPE_VP_VS_T ||  || NUMBER(22, 6) || hPa.°C-1 || not used in CGMS
|-
| CLOUD_TOTAL_DAYTIME ||  || NUMBER(22, 6) || oktas || daily mean of total cloud cover (3
|-
| CLOUD_LOW_DAYTIME ||  || NUMBER(22, 6) || oktas || not used in CGMS
|-
| CLOUD_SHADOW ||  || NUMBER(22, 6) || oktas || not used in CGMS
|-
| VISIBILITY ||  || NUMBER(22, 6) || - || not used in CGMS
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || cm || daily mean snow depth
|-
|}
1 this variable returns directly radiation<br>
2 this variable can be used to derive radiation via the angstrom formula<br>
3 these variables can be used to derive radiation via the Supit formula<br>
4 these variables can be used to derive radiation via the Hargreaves formula<br>
|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_STATION_AVAIL ===
* Description: available weather stations for interpolation per station and per year.
* Use: output of the weather data availability calculation, used by the grid weather interpolation
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| YEAR || NOT NULL || NUMBER(22, 4) || - || historic year
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| AVAILABILITY_TYPE || NOT NULL || VARCHAR2(30) || - || class e.g. temperature
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_STATION_CALCULATED ===
* Description: daily weather derived from other variables. Calculated/estimated potential evaporation and global radiation per station.
* Use: output table for additional weather calculation, input for grid weather
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE || - || calendar day
|-
| E0 ||  || NUMBER(22, 4) || mm.d-1 || daily transpiration of water surface
|-
| ES0 ||  || NUMBER(22, 4) || mm.d-1 || daily transpiration of wet bare soil
|-
| ET0 ||  || NUMBER(22, 4) || mm.d-1 || daily transpiration of crop canopy
|-
| RADIATION ||  || NUMBER(22, 9) || KJ.m-2.d-1 || daily radiation at surface
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_STATION_ERRAIN ===
* Description: contains deleted wrongly rain records of the station based daily meteorological data
* Use: archive reasons
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE || - || 
|-
| PRECIPITATION ||  || NUMBER(22, 6) || - || 
|-
| REASON ||  || VARCHAR2(4000) || - || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_STATION_ERRORS ===
* Description: contains deleted wrongly weather records of the station based daily meteorological data
* Use: archive reasons
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE || - || 
|-
| CLOUD_TOTAL_24H ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_LOW_24H ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_MIDDLE_24H ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_HIGH_24H ||  || NUMBER(22, 6) || - || 
|-
| SUNSHINE ||  || NUMBER(22, 6) || - || 
|-
| RADIATION ||  || NUMBER(22, 11) || - || 
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 6) || - || 
|-
| VAPOURPRESSURE ||  || NUMBER(22, 6) || - || 
|-
| WINDSPEED ||  || NUMBER(22, 6) || - || 
|-
| WINDSPEED_10M ||  || NUMBER(22, 6) || - || 
|-
| PRECIPITATION ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_06H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_06H ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_09H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_09H ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_12H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_12H ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_15H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_15H ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_18H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_18H ||  || NUMBER(22, 6) || - || 
|-
| STATE_SOIL ||  || NUMBER(22, 6) || - || 
|-
| VAPOURPRESSURE_DEF ||  || NUMBER(22, 6) || - || 
|-
| SLOPE_VP_VS_T ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_TOTAL_DAYTIME ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_LOW_DAYTIME ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_SHADOW ||  || NUMBER(22, 6) || - || 
|-
| VISIBILITY ||  || NUMBER(22, 6) || - || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || - || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_STATION_INFO ===
* Description: table for storing specific metadata on daily weather data (flags)
* Use: meta data
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE || - || calendar day
|-
| CLOUD_TOTAL_24H ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_LOW_24H ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_MIDDLE_24H ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_HIGH_24H ||  || NUMBER(22, 2) || - || 
|-
| SUNSHINE ||  || NUMBER(22, 2) || - || 
|-
| RADIATION ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 2) || - || 
|-
| VAPOURPRESSURE ||  || NUMBER(22, 2) || - || 
|-
| WINDSPEED ||  || NUMBER(22, 2) || - || 
|-
| WINDSPEED_10M ||  || NUMBER(22, 2) || - || 
|-
| PRECIPITATION ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_06H ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_06H ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_09H ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_09H ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_12H ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_12H ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_15H ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_15H ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_18H ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_18H ||  || NUMBER(22, 2) || - || 
|-
| STATE_SOIL ||  || NUMBER(22, 2) || - || 
|-
| VAPOURPRESSURE_DEF ||  || NUMBER(22, 2) || - || 
|-
| SLOPE_VP_VS_T ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_TOTAL_DAYTIME ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_LOW_DAYTIME ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_SHADOW ||  || NUMBER(22, 2) || - || 
|-
| VISIBILITY ||  || NUMBER(22, 2) || - || 
|-
| SNOWDEPTH ||  || NUMBER(22, 2) || - || 
|-
|}
In case of precipitation:
* 0=real observation 06-06 UTC
* 1=MOS estimate     06-06 UTC
* 2=real observation 00-00 UTC
* 3=real observation 03-03 UTC
* 4=real observation 12-12 UTC
* 5=real observation 18-18 UTC
|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_STATION_LTA ===
* Description: contains the long term average weather data per station per day
* Use: substitute data in case of missing data during level 1 processing
* Type: ''Table''
* Remarks: filled by software tool [[Software Tools#ReferenceWeather|ReferenceWeather]]
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYMONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 6) || °C || maximum air temperature
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 6) || °C || minimum air temperature
|-
| VAPOURPRESSURE ||  || NUMBER(22, 6) || hPa || mean daily vapour pressure
|-
| WINDSPEED ||  || NUMBER(22, 6) || m.s-1 || mean daily wind speed at 10 m height
|-
| PRECIPITATION ||  || NUMBER(22, 6) || mm.d-1 || daily rainfall
|-
| E0 ||  || NUMBER(22, 4) || mm.d-1 || daily transpiration of water surface
|-
| ES0 ||  || NUMBER(22, 4) || mm.d-1 || daily transpiration of wet bare soil
|-
| ET0 ||  || NUMBER(22, 4) || mm.d-1 || daily transpiration of closed crop canopy
|-
| RADIATION ||  || NUMBER(22, 9) || KJ.m-2.d-1 || daily radiation at surface
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || cm || daily mean snow depth
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OBS_STATION_RAW ===
* Description: temporary storage before inserting data into WEATHER_OBS_STATION(_INFO)
* Use: input level 1
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DOY || NOT NULL || NUMBER(22, 3) ||  || 
|-
| DAY ||  || DATE || - || 
|-
| CLOUD_TOTAL_24H ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_LOW_24H ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_MIDDLE_24H ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_HIGH_24H ||  || NUMBER(22, 6) || - || 
|-
| SUNSHINE ||  || NUMBER(22, 6) || - || 
|-
| RADIATION ||  || NUMBER(22, 11) || - || 
|-
| TEMPERATURE_MIN ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_MAX ||  || NUMBER(22, 6) || - || 
|-
| VAPOURPRESSURE ||  || NUMBER(22, 6) || - || 
|-
| WINDSPEED ||  || NUMBER(22, 6) || - || 
|-
| WINDSPEED_10M ||  || NUMBER(22, 6) || - || 
|-
| PRECIPITATION ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_06H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_06H ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_09H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_09H ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_12H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_12H ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_15H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_15H ||  || NUMBER(22, 6) || - || 
|-
| TEMPERATURE_18H ||  || NUMBER(22, 6) || - || 
|-
| HUMIDITY_18H ||  || NUMBER(22, 6) || - || 
|-
| STATE_SOIL ||  || NUMBER(22, 6) || - || 
|-
| VAPOURPRESSURE_DEF ||  || NUMBER(22, 6) || - || 
|-
| SLOPE_VP_VS_T ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_TOTAL_DAYTIME ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_LOW_DAYTIME ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_SHADOW ||  || NUMBER(22, 6) || - || 
|-
| VISIBILITY ||  || NUMBER(22, 6) || - || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) || - || 
|-
| CLOUD_TOTAL_24H_INFO ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_LOW_24H_INFO ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_MIDDLE_24H_INFO ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_HIGH_24H_INFO ||  || NUMBER(22, 2) || - || 
|-
| SUNSHINE_INFO ||  || NUMBER(22, 2) || - || 
|-
| RADIATION_INFO ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_MIN_INFO ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_MAX_INFO ||  || NUMBER(22, 2) || - || 
|-
| VAPOURPRESSURE_INFO ||  || NUMBER(22, 2) || - || 
|-
| WINDSPEED_INFO ||  || NUMBER(22, 2) || - || 
|-
| WINDSPEED_10M_INFO ||  || NUMBER(22, 2) || - || 
|-
| PRECIPITATION_INFO ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_06H_INFO ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_06H_INFO ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_09H_INFO ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_09H_INFO ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_12H_INFO ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_12H_INFO ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_15H_INFO ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_15H_INFO ||  || NUMBER(22, 2) || - || 
|-
| TEMPERATURE_18H_INFO ||  || NUMBER(22, 2) || - || 
|-
| HUMIDITY_18H_INFO ||  || NUMBER(22, 2) || - || 
|-
| STATE_SOIL_INFO ||  || NUMBER(22, 2) || - || 
|-
| VAPOURPRESSURE_DEF_INFO ||  || NUMBER(22, 2) || - || 
|-
| SLOPE_VP_VS_T_INFO ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_TOTAL_DAYTIME_INFO ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_LOW_DAYTIME_INFO ||  || NUMBER(22, 2) || - || 
|-
| CLOUD_SHADOW_INFO ||  || NUMBER(22, 2) || - || 
|-
| VISIBILITY_INFO ||  || NUMBER(22, 2) || - || 
|-
| SNOWDEPTH_INFO ||  || NUMBER(22, 2) || - || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OPE_GRID ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| DAYOFFSET || NOT NULL || NUMBER(22, 2) ||  || 
|-
| IDMEMBER || NOT NULL || NUMBER(22, 2) ||  || 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| TOTALCLOUD ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WEATHER_OPE_REGIONCOVER ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDCOVER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| DAYOFFSET || NOT NULL || NUMBER(22, 2) ||  || 
|-
| IDMEMBER || NOT NULL || NUMBER(22, 2) ||  || 
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22, 3) ||  || 
|-
| TEMPERATURE_DEW || NOT NULL || NUMBER(22, 3) ||  || 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22, 4) ||  || 
|-
| WINDSPEED || NOT NULL || NUMBER(22, 5) ||  || 
|-
| PRECIPITATION || NOT NULL || NUMBER(22, 4) ||  || 
|-
| E0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ES0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ET0 || NOT NULL || NUMBER(22, 4) ||  || 
|-
| RADIATION || NOT NULL || NUMBER(22, 6) ||  || 
|-
| SNOWWEQ ||  || NUMBER(22, 6) ||  || 
|-
| SNOWDEPTH ||  || NUMBER(22, 6) ||  || 
|-
| TOTALCLOUD ||  || NUMBER(22, 3) ||  || 
|-
|}

|}
<!-- end -->



== other datasets ==
{{TocTable|content=
{{TocRow|#CGMS_SYSLOG|7.1 CGMS_SYSLOG}}
{{TocRow|#DATES_75_15|7.2 DATES_75_15}}
{{TocRow|#GRIDS|7.3 GRIDS}}
{{TocRow|#HRES_YEARS|7.4 HRES_YEARS}}
{{TocRow|#INTERPOLATION_PARAMETERS|7.5 INTERPOLATION_PARAMETERS}}
{{TocRow|#REGIONS|7.6 REGIONS}}
{{TocRow|#STATIONS|7.7 STATIONS}}
{{TocRow|#STAT_REGION_AREAS|7.8 STAT_REGION_AREAS}}
{{TocRow|#SYSTABLES|7.9 SYSTABLES}}
{{TocRow|#TASKS|7.10 TASKS}}
{{TocRow|#WOG|7.11 WOG}}
{{TocRow|#WOSC|7.12 WOSC}}
}}




<!-- start -->
=== CGMS_SYSLOG ===
* Description: logging of run options.
* Use: output table containing information on the run executed
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| RUNID || NOT NULL || NUMBER(22) || - || identification number of run
|-
| DBUSER ||  || VARCHAR2(20) || - || username
|-
| RUNDATE ||  || DATE || - || run date
|-
| RUNINFO ||  || VARCHAR2(50) || - || codes explaining kind of run executed
|-
| CAMPAIGN_START ||  || VARCHAR2(20) || - || start month of campaign (agricultural season
|-
| WEATHER_START ||  || DATE || - || start date of weather calculations
|-
| WEATHER_END ||  || DATE || - || end date of weather calculations
|-
| START_YEAR || NOT NULL || NUMBER(22) || - || year for which simulation is executed
|-
| CAMPAIGN_YEARS || NOT NULL || NUMBER(22) || - || number of campaign years the model is run for
|-
| RUNSTATUS ||  || VARCHAR2(20) || - || final status of run
|-
| WEATHER_DATA_SOURCE ||  || VARCHAR2(20) || - || source type used for simulation crop yield
|-
| INITIALISATION_WATER_BALANCE || NOT NULL || NUMBER(22) || - || code indication type of water balance initialisations
|-
| GROUND_WATER_BALANCE || NOT NULL || NUMBER(22) || - || code indication usage of ground water balance
|-
|}

|}
<!-- end -->



<!-- start -->
=== DATES_75_15 ===
* Description: synonym to oracle package
* Use: view on [[DATE_GENERATOR]] package
* Type: ''Table''
* Remarks: none
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| DAY || NOT NULL || DATE ||  || 
|-
| DAYNO_WK || NOT NULL || NUMBER(22, 1) ||  || 
|-
| WEEK || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYNO_MON || NOT NULL || NUMBER(22, 2) ||  || 
|-
| MONTH || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DAYNO_YR || NOT NULL || NUMBER(22, 3) ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| DAYNO_DEC || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DECADE || NOT NULL || NUMBER(22, 2) ||  || 
|-
| DEC_MONTH || NOT NULL || VARCHAR2(10) ||  || 
|-
| JULIAN || NOT NULL || NUMBER(22) || |- || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== GRIDS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  || 
|-
| LATITUDE || NOT NULL || NUMBER(22) ||  || 
|-
| LONGITUDE || NOT NULL || NUMBER(22) ||  || 
|-
| ALTITUDE || NOT NULL || NUMBER(22) ||  || 
|-
| ALTITUDE_16 ||  || NUMBER(22) ||  || 
|-
| ALTITUDE_25 ||  || NUMBER(22) ||  || 
|-
| HAS_LAND || NOT NULL || VARCHAR2(1) ||  || 
|-
| DISTANCE_FROM_COAST ||  || NUMBER(22) ||  || 
|-
| CLIMATE_BARRIER ||  || NUMBER(22) ||  || 
|-
| RESOLUTION || NOT NULL || NUMBER(22) ||  || 
|-
| UNIT || NOT NULL || VARCHAR2(20) ||  || 
|-
|}


'''definition:'''
 select
     g.idgrid
   , g.idoriginal_code
   , g.latitude
   , g.longitude
   , g.altitude
   , g.altitude_16
   , g.altitude_25
   , g.has_land
   , g.distance_from_coast
   , g.climate_barrier
   , g.resolution
   , g.unit
 from global_grids g
 where grid_source = 'CHN'
 order by idgrid
|}
<!-- end -->



<!-- start -->
=== HRES_YEARS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| YEAR ||  || NUMBER(22) ||  || 
|-
|}


'''definition:'''
 select
     1988 + level year
 from dual
 connect by level <= (to_number (to_char (sysdate, 'yyyy')) - 1988)
|}
<!-- end -->



<!-- start -->
=== INTERPOLATION_PARAMETERS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDINTERPOLATION_PARAMETER || NOT NULL || NUMBER(22, 12) ||  || 
|-
| NAME || NOT NULL || VARCHAR2(30) ||  || 
|-
| VALUE || NOT NULL || VARCHAR2(30) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== REGIONS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| IDFATHER ||  || NUMBER(22, 12) ||  || 
|-
| REGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| GLOBAL_NAME || NOT NULL || VARCHAR2(255) ||  || 
|-
| LOCAL_NAME ||  || VARCHAR2(255) ||  || 
|-
| REGION_LEVEL || NOT NULL || NUMBER(22) ||  || 
|-
| CONTINENT || NOT NULL || VARCHAR2(20) ||  || 
|-
| POPULATION ||  || NUMBER(22) ||  || 
|-
| IDREGION_ELEMENT || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDORIGINAL_CODE || NOT NULL || VARCHAR2(20) ||  || 
|-
|}


'''definition:'''
 select
     lrc.idregion
   , idfather
   , region
   , global_name
   , local_name
   , region_level
   , continent
   , population
   , idregion_element
   , idoriginal_code
 from
     global_region_elements re
   , link_region_cover      lrc
 where region_source = 'GAUL'
 and lrc.idregion    = re.idregion
 and lrc.idcover     = 1000
|}
<!-- end -->



<!-- start -->
=== STATIONS ===
* Description: 
* Use: 
* Type: ''View''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22, 12) ||  || 
|-
| STATION || NOT NULL || VARCHAR2(32) ||  || 
|-
| ORGANIZATION || NOT NULL || VARCHAR2(32) ||  || 
|-
| IDWMO ||  || NUMBER(22, 12) ||  || 
|-
| WMO ||  || VARCHAR2(32) ||  || 
|-
| LATITUDE || NOT NULL || NUMBER(22, 7) ||  || 
|-
| LONGITUDE || NOT NULL || NUMBER(22, 8) ||  || 
|-
| Y_COORDINATE || NOT NULL || NUMBER(22, 13) ||  || 
|-
| X_COORDINATE || NOT NULL || NUMBER(22, 13) ||  || 
|-
| ALTITUDE || NOT NULL || NUMBER(22, 5) ||  || 
|-
| IDCLIMATE_ZONE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| COUNTRY || NOT NULL || VARCHAR2(26) ||  || 
|-
| DISTANCE_TO_COAST || NOT NULL || NUMBER(22, 4) ||  || 
|-
| ANGSTROM_A || NOT NULL || NUMBER(22, 18) ||  || 
|-
| ANGSTROM_B || NOT NULL || NUMBER(22, 18) ||  || 
|-
| SUPIT_A || NOT NULL || NUMBER(22, 18) ||  || 
|-
| SUPIT_B || NOT NULL || NUMBER(22, 18) ||  || 
|-
| SUPIT_C || NOT NULL || NUMBER(22, 18) ||  || 
|-
| HARGREAVES_A || NOT NULL || NUMBER(22, 18) ||  || 
|-
| HARGREAVES_B || NOT NULL || NUMBER(22, 18) ||  || 
|-
| RELIABLE_STATIONS || NOT NULL || NUMBER(22, 1) ||  || 
|-
| ACTIVE_STATIONS || NOT NULL || NUMBER(22, 1) ||  || 
|-
| AVAIL_PRECIPITATION_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVAIL_SNOWDEPTH_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVAIL_TEMPERATURE_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVAIL_HUMIDITY_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  || 
|-
| AVAIL_REST_THRESHOLD || NOT NULL || NUMBER(22, 4) ||  || 
|-
|}


'''definition:'''
 select
        idstation
      , station
      , organization
      , idwmo
      , wmo
      , latitude
      , longitude
      , y_coordinate
      , x_coordinate
      , altitude
      , idclimate_zone
      , country
      , distance_to_coast
      , angstrom_a
      , angstrom_b
      , supit_a
      , supit_b
      , supit_c
      , hargreaves_a
      , hargreaves_b
      , reliable_stations
      , active_stations
      , avail_precipitation_threshold
      , avail_snowdepth_threshold
      , avail_temperature_threshold
      , avail_humidity_threshold
      , avail_rest_threshold
 from stations@cgms14sys_assistsan
|}
<!-- end -->



<!-- start -->
=== STAT_REGION_AREAS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDCROP || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDREGION || NOT NULL || VARCHAR2(20) ||  || 
|-
| YEAR || NOT NULL || NUMBER(22, 4) ||  || 
|-
| IDSTATISTIC_SOURCE || NOT NULL || NUMBER(22, 12) ||  || 
|-
| IDTREATMENT || NOT NULL || NUMBER(22, 12) ||  || 
|-
| AREA_CALCULATED || NOT NULL || NUMBER(22) ||  || 
|-
| AREA_ORIGINAL ||  || NUMBER(22) ||  || 
|-
| NOTE ||  || VARCHAR2(255) ||  || 
|-
| ELABORATION || NOT NULL || DATE ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== SYSTABLES ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| TABLE_NAME || NOT NULL || VARCHAR2(31) || - || 
|-
| HIGHEST_ID || NOT NULL || NUMBER(22, 38) || - || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== TASKS ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| TASK_ID || NOT NULL || NUMBER(22, 8) || - || 
|-
| MODEL || NOT NULL || VARCHAR2(12) || - || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| STATUS || NOT NULL || NUMBER(22, 2) ||  || 
|-
| TIMESTAMP || NOT NULL || DATE ||  || 
|-
| FRACTION ||  || NUMBER(22) ||  || 
|-
| MCOMMENT ||  || VARCHAR2(255) || - || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WOG ===
* Description: table for storing temporary results during interpolation of grid weather as part of the  [[Weather Monitoring ]] module. When the calculation is finshed, all records are inserted into {{Object|WEATHER_OBS_GRID}}.
* Use: temporary output table for the calculation of weather indicators. Output for level 1, input for level 2
* Type: ''Table''
* Remarks: The table is created by cgms.exe each time the crop indicators are calculated.
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDGRID || NOT NULL || NUMBER(22) ||  || 
|-
| DAY || NOT NULL || DATE || - || calendar day
|-
| TEMPERATURE_MAX || NOT NULL || NUMBER(22) ||  || 
|-
| TEMPERATURE_MIN || NOT NULL || NUMBER(22) ||  || 
|-
| TEMPERATURE_AVG || NOT NULL || NUMBER(22) ||  || 
|-
| VAPOURPRESSURE || NOT NULL || NUMBER(22) ||  || 
|-
| WINDSPEED || NOT NULL || NUMBER(22) || m.s-1 || mean daily wind speed at 10 m height
|-
| PRECIPITATION || NOT NULL || NUMBER(22) ||  || 
|-
| E0 || NOT NULL || NUMBER(22) || mm.d-1 || daily transpiration of water surface
|-
| ES0 || NOT NULL || NUMBER(22) || mm.d-1 || daily transpiration of wet bare soil
|-
| ET0 || NOT NULL || NUMBER(22) || mm.d-1 || daily transpiration of crop canopy
|-
| RADIATION || NOT NULL || NUMBER(22) ||  || 
|-
| SNOWDEPTH ||  || NUMBER(22) ||  || 
|-
| HUMIDITY_06H ||  || NUMBER(22) ||  || 
|-
| HUMIDITY_09H ||  || NUMBER(22) ||  || 
|-
| HUMIDITY_12H ||  || NUMBER(22) ||  || 
|-
| HUMIDITY_15H ||  || NUMBER(22) ||  || 
|-
| HUMIDITY_18H ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->



<!-- start -->
=== WOSC ===
* Description: 
* Use: 
* Type: ''Table''
* Remarks: 
{|class="collapsing_table collapsible collapsed"
!Structure
|-
|
{|class="wikitable"
! WIDTH=250| Attribute !! WIDTH=80| Constraint !! WIDTH=120 | Type !! WIDTH=80| Unit !! WIDTH=300 | Comment
|-
| IDSTATION || NOT NULL || NUMBER(22) ||  || 
|-
| DAY || NOT NULL || DATE ||  || 
|-
| E0 ||  || NUMBER(22) ||  || 
|-
| ES0 ||  || NUMBER(22) ||  || 
|-
| ET0 ||  || NUMBER(22) ||  || 
|-
| RADIATION ||  || NUMBER(22) ||  || 
|-
|}

|}
<!-- end -->