SALUS Data Base Structures

Database Table
CDB
Complex_Cultivar
Complex_Species_Base
Complex_Species_Phases
Complex_Species_TempFactors
N_Fix
Simple_Crop
Version_Control
DDB
Data_Dictionary
Data_Field_Choices
GDB
Chart-Fields
Chart-Modules
Charts
Crop_Par
Fert_Par
HelpFiles
Irr_Par
Residue_Par
Soil_Bio_Kinetic_Par
Till_Par
RDB
Results
Results_Layer
Results_Seasonal
Version_Control
SDB
Soil_Base
Soil_Layers
Version_Control
UDB
Chart-Fields
Chart-Modules
Charts
WDB
Stations
Storm_Intensity
Version_Control
Weather
XDB
Experiments
Experiments_Notes
Measured_Data
Measured_Data_Notes
Mgt_Chemical_App
Mgt_EnvMod_App
Mgt_Fertilizer_App
Mgt_Fertilizer_Auto
Mgt_Harvest_App
Mgt_Harvest_Auto
Mgt_InitialCond
Mgt_InitialCond_Lay
Mgt_Irrigation_App
Mgt_Irrigation_Auto
Mgt_Planting
Mgt_Planting_Auto
Mgt_Residue_App
Mgt_Residue_Auto
Mgt_SoilAnalysis
Mgt_SoilAnalysis_Lay
Mgt_Tillage_App
Rotation_Components
Version_Control

Database: CDB

Table: Complex_Cultivar

Field Name	Type	Length	Description
SpeciesID	Text	2	2-character crop name
CultivarID	Text	10	Cultivar code
Name	Text	50	Cultivar name
Vcoef	Single	4	Vernalization coefficient for winter cereals
LT50c	Single	4	Coefficient for low temperature tolerance
PhLow	Single	4	Photoperiod low limit [h] [Range: 6-24]
PhHig	Single	4	Photoperiod high limit [h] [Range: 6-24]
DelpH	Single	4	Delay per 1h of photoperiod increase (slope of curve) [d h-1]
LEJuv	Single	4	Leaf equivalents to end of juvenile stage [leaf eq.] [Range:
krNPt	Single	4	Potential (maximum) kernel number per ear [Range: 1-800]
SnkBr	Single	4	Abovegrnd sink during ear growth that produces barren ears [g
LEgg	Single	4	Leaf equivalents for grain growth [leaf eq.] [Range:
krPGR	Single	4	Daily rate of kernel fill at optimum temperature[g kernel-1
phyll	Single	4	Phyllochron [Cd leaf-1] [Range: 5-80]
Phy14	Single	4	Phyllochron at 14 h daylength [Cd leaf-1] [Range: 5-80]

Table: Complex_Species_Base

Field Name	Type	Length	Description
SpeciesID	Text	2	2-character crop name
Species	Text	50	Full crop name
LEtg	Single	4	leaf equivalents to germinate [leaf eq.] [Range: 0.01-1]
TbaseD	Single	4	base temperature for development calculation [C] [Range:0-12]
ToptD	Single	4	optimal temperature for development calculation [C]
ToptP	Single	4	optimal temperature for photosynthesis [C] [Range: 10-30]
RUE	Single	4	radiation use efficiency [g MJ-1] [Range: ]
LEsec	Single	4	leaf equivalent when first leaf starts senescing [leaf eq.]
lncsf	Single	4	factor for daily rate of leaf senescence [unitless] [Range:
SLWmax	Single	4	maximum specific leaf weight [g cm-2] [Range: 0.001-0.01]
Phase3	Single	4	leaf equivalents duration for phase 3 [leaf eq.] [Range:
LEear	Single	4	leaf equivalents for ear growth [leaf eq.] [Range: 2.9-12.5]
Kf	Single	4	constant used in light interception calculation [unitless]
glfmat	Single	4	fraction of green leaves at maturity/green leaf number at the
EmgInt	Single	4	the intercept of the emgergence leaf equivalents calculation
EmgSlp	Single	4	the slope of the emgergence leaf equivalents calculation [leaf
PhotoC	Single	4	photoperiod vs. phyllochron relationship species-specific
MxNLf	Single	4	Maximum concentration of N in leaf [g g-1] [Range: 0.005-0.05]
MxNSt	Single	4	Maximum concentration of N in stem [g g-1] [Range: 0.005-0.05]
MxNRt	Single	4	Maximum concentration of N in root [g g-1] [Range: 0.005-0.05]
MxNKr	Single	4	Maximum concentration of N in grain [g g-1] [Range:
MnNMlt	Single	4	multiplier for minimum N concentration [unitless] [Range:
ISWSYM	Text	1	Symbiotic switch (Y = fix N, N = do not fix N)
MxPLf	Single	4	Maximum concentration of P in leaf [g g-1] [Range:
MxPSt	Single	4	Maximum concentration of P in stem [g g-1] [Range:
MxPRt	Single	4	Maximum concentration of P in root [g g-1] [Range:
MxPKr	Single	4	Maximum concentration of P in grain [g g-1] [Range:
MnPMlt	Single	4	multiplier for minimum P concentration [unitless] [Range:

Table: Complex_Species_Phases

Field Name	Type	Length	Description
SpeciesID	Text	2	2-character crop name
Label	Text	6	Leaf equivalent or phase fraction [L: Leaf equivalent, FL-:
PhylF	Single	4	Phyllochron fraction for first few leaves [unitless] [Range:
Tswch	Text	1	Development Temperature Selection Switch [C for crown, A for
TopSk	Single	4	Potential tops sink [g plant-1 leaf eq.-1] [Range: 0-50]
Slwf	Single	4	Specific leaf weight fraction
LeafF	Single	4	Leaf partitioning coefficient [g g-1] [Range: 0-1]
StemF	Single	4	Stem partitioning coefficient [g g-1] [Range: 0-1]
GRF	Single	4	Grain partitioning coefficient [g g-1] [Range: 0-1]
RTF	Single	4	Root fraction of tops sink [g g-1] [Range: 0-1]
ResF	Single	4	Reserve fraction of stem mass [g g-1] [Range: 0-1]
MxTiS	Single	4	Relative max. potential size of tillers
MxNLf	Single	4	Rel. maximum N concentration in leaves [g g-1 N] [Range: 0-1]
MxNSt	Single	4	Rel. maximum N concentration in stem [g g-1 N] [Range: 0-1]
MxPLf	Single	4	Rel. maximum P concentration in leaves [g g-1 N] [Range: 0-1]
MxPSt	Single	4	Rel. maximum P concentration in stem [g g-1 N] [Range: 0-1]

Table: Complex_Species_TempFactors

Field Name	Type	Length	Description
SpeciesID	Text	2	2-character crop name
TRF	Text	20	Temperature Reduction Factor label
X	Single	4	X coordinate of polygon vertex [C] [Range: -oo - +oo]
Y	Single	4	Y coordinate of polygon vertex [unitless] [Range:0-1]

Table: N_Fix

Field Name	Type	Length	Description
SpeciesID	Text	2	2-character crop name
Species_Name	Text	255	Species name
Source	Text	50	Source of parameters
TTFIX	Single	4	Thermal time to start N-fixing (degree-days)
RFIXN	Single	4	Respiration parameter related to N-fixing
CtoNod	Single	4	Fraction of the assimilate C allocated to root growth that is

Table: Simple_Crop

Field Name	Type	Length	Description
SpeciesID	Text	255	Species code
Species_Name	Text	255	Species name
Source	Text	50	Source of parameters
relTT@P1	Single	4	Rel. thermal time at point 1 on the potential LAI S-curve (0
relLAI@P1	Single	4	Rel. LAI at point 1 on the potential LAI S-curve (0 - 1)
relTT@P2	Single	4	Rel. thermal time at point 2 on the potential LAI S-curve (0
relLAI@P2	Single	4	Rel. LAI at point 2 on the potential LAI S-curve (0 - 1)
LAImax	Single	4	Maximum expected Leaf Area Index (m2 m-2)
RUEmax	Single	4	Maximum expected Radiation Use Efficiency (g MJ-1)
relTT@Sn	Single	4	Rel. thermal time at beginning of senescence (LAI starts
SnParLAI	Single	4	Parameter for shape of potential LAI curve after beginning of
SnParRUE	Single	4	Parameter for shape of potential RUE curve after beginning of
TbaseDev	Single	4	Base temperature for development (C)
ToptDev	Single	4	Optimum temperature for development (C)
TTtoGerm	Single	4	Thermal time planting to germination (degree-days)
TTtoMatr	Single	4	Thermal time planting to maturity (degree-days)
EmgInter	Single	4	Intercept of emergence thermal time calculation
EmgSlope	Single	4	Slope of emergence thermal time calculation
HrvIndex	Single	4	Harvest Index (kg kg-1)
PlntN@Em	Single	4	Optimum N concentration in whole plant at emergence [kg kg-1]
PlntN@Hf	Single	4	Optimum N concentration in whole plant halfway through
PlntN@Mt	Single	4	Optimum N concentration in whole plant at maturity [kg kg-1]
GrnN@Mt	Single	4	Optimum N concentration in grain at maturity [kg kg-1]
PlntP@Em	Single	4	Optimum P concentration in whole plant at emergence [kg kg-1]
PlntP@Hf	Single	4	Optimum P concentration in whole plant halfway through
PlntP@Mt	Single	4	Optimum P concentration in whole plant at maturity [kg kg-1]
GrnP@Mt	Single	4	Optimum P concentration in grain at maturity [kg kg-1]
ISWSYM	Text	1	Symbiotic switch (Y = fix N, N = do not fix N)

Table: Version_Control

Field Name	Type	Length	Description
Version	Single	4
ReleaseDate	Date/Time	8
Notes	Text	50

Database: DDB

Table: Data_Dictionary

Field Name	Type	Length	Description
Table	Text	50	Table or Category
Field	Text	50	Field name
Short	Text	30	Short Name for Variables
Units	Text	25	Units
Min	Double	8	Minimum value for a variable
Max	Double	8	Maximum value for a variable
Default	Text	50	Default value for a variable
Module	Text	50	Module used for reporting
GraphType	Text	10	Which graphing unit to be listed under
Comments	Text	255	Comments

Table: Data_Field_Choices

Field Name	Type	Length	Description
Field	Text	50	Field name
ValueStr	Text	50	Possible choice for a field
Desc	Text	50	Long description for a choice

Database: GDB

Table: Chart-Fields

Field Name	Type	Length	Description
ChartID	Double	8
Field	Text	50	The short name of the selected field

Table: Chart-Modules

Field Name	Type	Length	Description
ChartID	Double	8
Module	Text	50

Table: Charts

Field Name	Type	Length	Description
ChartID	Double	8	Unique ID for the chart
Title	Text	255
XAxis	Text	50	The x axis field name
Type	Integer	2
3D	Integer	2

Table: Crop_Par

Field Name	Type	Length	Description
Code	Text	50	Two letter code for crop
Name	Text	50	Full name of crop
Lignin%	Double	8	Percent lignin in the crop residue
RootC	Single	4	C content of roots [% dry wt.]
RootSloC	Single	4	Percent of total C in slowly decomposing root tissue such as
RootIntC	Single	4	Percent of total C in intermediate decomposing root tissue
RootSloN	Single	4	Percent of total N in slowly decomposing root tissue such as
VegC	Single	4	C content of vegetative tops+roots at maturity [% dry wt.]
VegSloC	Single	4	Percent of total C in slowly decomposing vegetative tops+roots
VegIntC	Single	4	Percent of total C in intermediate decomposing vegetative
VegSloN	Single	4	Percent of total N in slowly decomposing vegetative
KnDnFrac	Single	4	Knock-Down Fraction, fraction of the non-harvested by-product

Table: Fert_Par

Field Name	Type	Length	Description
Code	Text	9	Code for fertilizer type
Name	Text	34	Name of fertilizer
NO3Frac	Double	8	Fraction of N in nitrate form (0.0-1.0)
NH4Frac	Double	8	Fraction of N in ammonium
UreaFrac	Double	8	Fraction of N in urea
FerDecRt	Single	4	Fertilizer decomposition rate constant under optimum
VolN	Single	4	Percent of total N that can readily volatilize if
VolNRate	Single	4	Rate constant for percent of total N that can readily

Table: HelpFiles

Field Name	Type	Length	Description
HelpID	Integer	2
HelpFile	Text	50
Topic	Text	255

Table: Irr_Par

Field Name	Type	Length	Description
Code	Text	10	Code for irrigation type
Name	Text	30	Name of irrigation type

Table: Residue_Par

Field Name	Type	Length	Description
Code	Text	7	Code for residue type
Name	Text	17	Name of residue type
ResC	Single	4	C content of residues [% dry wt.]
ResN	Single	4	N content of residues [% dry wt.]
ResP	Single	4	P content of residues [% dry wt.]
SlowC	Single	4	Percent of total C in slowly decomposing material such as
IntermdC	Single	4	Percent of total C in intermediate decomposing material such
SlowN	Single	4	Percent of total N in slowly decomposing material such as
VolN	Single	4	Percent of FOM pool N that can readily volatilize if
VolNRate	Single	4	Rate constant for percent of FOM pool N that can readily

Table: Soil_Bio_Kinetic_Par

Field Name	Type	Length	Description
Element	Text	1	Element name
ActInorg	Single	4	Active inorganic decomposition constant [d-1]
ActIn2Lb	Single	4	Active inorganic to labile constant [d-1]
SloInorg	Single	4	Slow inorganic decomposition constant [d-1]
ActOrg	Single	4	Active organic decomposition constant [d-1]
SloFOMAb	Single	4	Slow FOM decomposition constant above ground [d-1]
SloFOMBl	Single	4	Slow FOM decomposition constant below ground [d-1]
Labile	Single	4	Labile decomposition constant [d-1]
LabInSol	Single	4	Fraction of labile in solution
ActI2CO2	Single	4	Fraction of delta active inorganic to CO2 [d-1]
ActO2CO2	Single	4	Fraction of delta active organic to CO2 [d-1]
SloO2CO2	Single	4	Fraction of delta slow organic to CO2 [d-1]
Rapd2CO2	Single	4	Fraction of delta rapid residue to CO2 [d-1]
Intr2CO2	Single	4	Fraction of delta intermediate residue to CO2 [d-1]
Slow2CO2	Single	4	Fraction of delta slow residue to CO2 [d-1]
Mlch2Sl	Single	4	Mulch to top soil layer constant, on dry days [d-1]

Table: Till_Par

Field Name	Type	Length	Description
Code	Text	7	Code for tillage type
Name	Text	25	Name of tillage implement
KnDnFrac	Single	4	Knock-Down Fraction, fraction of the standing dead that drops
MixFrac	Double	8	Mixing fraction for the implement
DecomFac	Double	8	Tillage effect on soil biochemistry pools decomposition rates
BDFac	Double	8	Tillage effect on bulk density
KsMcFac	Double	8	Tillage effect on saturated hydraulic conductivity (Macropore)
PondFac	Double	8	Tillage effect on ponding

Database: RDB

Table: Results

Field Name	Type	Length	Description
ExpID	Double	8	Sequential ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Year	Integer	2	Year
leafEq	Single	4	Thermal time in leaf equivalents since emergence
PhaseDes	Text	15	Growth phase description
DOY	Integer	2	Day of year 1 - 366
CDay	Long	Integer	Cumulative day
Date	Date/Time	8
DAP	Long	Integer	Days after planting
LAI	Single	4	Leaf area index, daily
LWAD	Long	Integer	Dry Weight - Leaf (kg/ha)
LWAT	Single	4	Dry Weight - Leaf - Tillers only (kg/ha)
SWAD	Long	Integer	Dry Weight - Stem (kg/ha)
SWAT	Single	4	Dry Weight - Stem - Tillers only (kg/ha)
StemResAD	Long	Integer	Dry Weight - Stem reserves (kg/ha)
StemResAT	Long	Integer	Dry Weight - Stem reserves - Tillers only (kg/ha)
GWAD	Long	Integer	Dry Weight - Grain (kg/ha)
GWAT	Single	4	Dry Weight - Grain - Tillers only (kg/ha)
RWAD	Long	Integer	Dry Weight - Root (kg/ha)
RWAT	Single	4	Dry Weight - Root - Tillers only (kg/ha)
CWAD	Long	Integer	Dry Weight -Crop (kg/ha)
CWAT	Single	4	Dry Weight -Crop - Tillers only (kg/ha)
EPAA	Single	4	Plant transpiration, mm/d, average
EPAD	Single	4	Plant transpiration, mm/d, daily
EPAC	Single	4	Plant transpiration, mm/d, cumulative
ETAA	Single	4	Evapotranspiration, mm/d, average
ETAD	Single	4	Evapotranspiration, mm/d, daily
ETAC	Single	4	Evapotranspiration, mm/d, cumultative
ESAA	Single	4	Soil evaporation, mm/d, average
ESAD	Single	4	Soil evaporation, mm/d, daily
ESAC	Single	4	Soil evaporation, mm/d, cumulative
EOAD	Single	4	Potential Evaporation, mm/d, daily
EOAC	Single	4	Potential Evaporation, mm/d, cumulative
EOAA	Single	4	Potential Evaporation, mm/d, average
SWXD	Single	4	Potentially extractable water, cm
ROFC	Single	4	Cumaltive runoff, mm
DRNC	Single	4	Cumulative drainage, mm
Rain	Single	4	Rain for the day (units?)
PREC	Single	4	Cumulative precipitation, mm
IRRC	Single	4	Cumulative irrigation, mm
SRAA	Single	4	Average solar radiation, MJ/m^2
TMXA	Single	4	Average maximum temperature, deg C
TMNA	Single	4	Average minumum temperature, deg C
NLCC	Long	Integer	Cumulative N leached, kg/ha
NIAD	Long	Integer	Inorganic N in soil, kg/ha
NOAD	Long	Integer	Organic N in soil, kg/ha
CET	Single	4	Cumulative Evap. loss
RelatvTT	Single	4	Relative thermal time [unitless] [Range: 0-1]
dThrTime	Single	4	daily thermal time increment [Cd] [Range: 0-50]
RadUseEf	Single	4	Radiation use efficiency [g MJ-1]
dBiomass	Single	4	daily biomass increment [g m-2 d-1]
RootDep	Single	4	Depth of rooting [cm]
ColdFac	Single	4	Low temperature reduction factor [unitless] [Range: 0-1]
DrghtFac	Single	4	Drought reduction factor [unitless] [Range: 0-1]
HeatFac	Single	4	High temperature reduction factor [unitless] [Range: 0-1]
NitroFac	Single	4	Low N reduction factor [unitless] [Range: 0-1]
PhosFac	Single	4	Low P reduction factor [unitless] [Range: 0-1]
PhotoFac	Single	4	Photoperiod reduction factor [unitless] [Range: 0-1]
C_FertBl	Single	4	Total below ground Fertilizer C, i.e., lime [kg ha-1]
C_ActInoBl	Single	4	Total below ground Active inorganic C [kg ha-1]
C_SloInoBl	Single	4	Total below ground Slow inorganic C [kg ha-1]
C_ActOrgBl	Single	4	Total below ground Active organic C [kg ha-1]
C_SloOrgBl	Single	4	Total below ground Slow organic C [kg ha-1]
C_ResOrgBl	Single	4	Total below ground Resistant organic C [kg ha-1]
C_RapFOMBl	Single	4	Total below ground Rapid decomposing FOM C (soluble) [kg
C_IntFOMBl	Single	4	Total below ground Intermediate decomposing FOM C
C_SloFOMBl	Single	4	Total below ground Slow decomposing FOM C (lignin) [kg ha-1]
C_RapFOMAb	Single	4	Total above ground Rapid decomposing FOM C (soluble) [kg
C_IntFOMAb	Single	4	Total above ground Intermediate decomposing FOM C
C_SloFOMAb	Single	4	Total above ground Slow decomposing FOM C (lignin) [kg ha-1]
C_StDead	Single	4	Recognizeable standing dead C [kg ha-1]
C_CO2	Single	4	C in cumulative CO2 evolved [kg ha-1]
C_In	Single	4	Total C additions [kg ha-1]
C_Out	Single	4	Total C withdrawals [kg ha-1]
C_Net	Single	4	Net C change [kg ha-1]
N_FertBl	Single	4	Total below ground Fertilizer N [kg ha-1]
N_ActInoBl	Single	4	Total below ground Active inorganic N [kg ha-1]
N_SloInoBl	Single	4	Total below ground Slow inorganic N [kg ha-1]
N_LabileBl	Single	4	Total below ground Labile [includes Solution] N [kg ha-1]
N_Sol	Single	4	Total below ground Solution [included in Labile] N [kg ha-1]
N_ActOrgBl	Single	4	Total below ground Active organic N [kg ha-1]
N_SloOrgBl	Single	4	Total below ground Slow organic N [kg ha-1]
N_ResOrgBl	Single	4	Total below ground Resistant organic N [kg ha-1]
N_RapFOMBl	Single	4	Total below ground Rapid decomposing FOM N (carbo., prot.,
N_SloFOMBl	Single	4	Total below ground Slow decomposing FOM N (lign., cell.,
N_Vol	Single	4	Total N that can readily volatilize from surface-applied FOM
N_Harvst	Single	4	Cumulative harvested plant N [kg ha-1]
N_Plants	Single	4	Cumulative whole plant uptake N [kg ha-1]
N_RapFOMAb	Single	4	Total above ground Rapid decomposing FOM N (soluble) [kg
N_SloFOMAb	Single	4	Total above ground Slow decomposing FOM N (lignin) [kg ha-1]
N_StDead	Single	4	Recognizeable standing dead N [kg ha-1]
N_Fix	Single	4	Cumulative N fixed [kg ha-1]
N_In	Single	4	Total N additions [kg ha-1]
N_Out	Single	4	Total N withdrawals [kg ha-1]
N_Net	Single	4	Net N change [kg ha-1]
P_FertBl	Single	4	Total below ground Fertilizer P [kg ha-1]
P_ActInoBl	Single	4	Total below ground Active inorganic P [kg ha-1]
P_SloInoBl	Single	4	Total below ground Slow inorganic P [kg ha-1]
P_LabileBl	Single	4	Total below ground Labile [includes Solution] P [kg ha-1]
P_Sol	Single	4	Total below ground Solution [included in Labile] P [kg
P_ActOrgBl	Single	4	Total below ground Active organic P [kg ha-1]
P_SloOrgBl	Single	4	Total below ground Slow organic P [kg ha-1]
P_ResOrgBl	Single	4	Total below ground Resistant organic P [kg ha-1]
P_RapFOMBl	Single	4	Total below ground Rapid decomposing FOM P (carbo., prot.,
P_Harvst	Single	4	Cumulative harvested plant P [kg ha-1]
P_Plants	Single	4	Cumulative whole plant uptake P [kg ha-1]
P_RapFOMAb	Single	4	Total above ground Rapid decomposing FOM P (carbo., prot.,
P_StDead	Single	4	Recognizeable standing dead P [kg ha-1]
P_In	Single	4	Total P additions [kg ha-1]
P_Out	Single	4	Total P withdrawals [kg ha-1]
P_Net	Single	4	Net P change [kg ha-1]

Table: Results_Layer

Field Name	Type	Length	Description
ExpID	Double	8	Sequential ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Layer	Integer	2	Soil Layer (numbered from surface)
Date	Date/Time	8	Date of ouput
RtWt	Single	4	Root mass per layer (g m-2)
CActInorgKg	Double	8	Carbon Active Inorganic (kg/ha)
CSloInorgKg	Double	8	Carbon Slow Inorganic (kg/ha)
NActInorgKg	Double	8	Nitrogen Active Inorganic (kg/ha)
NSloInorgKg	Double	8	Nitrogen Slow Inorganic (kg/ha)
SW	Double	8	Soil Water (cm^3/cm^3)
ST	Single	4	Soil Temperature (C)

Table: Results_Seasonal

Field Name	Type	Length	Description
ExpID	Double	8	Sequential ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
PlntYear	Integer	2	Planting Year
PlntDOY	Integer	2	Planting Day of year 1 - 366
HrvYear	Integer	2	Harvest Year
HrvDOY	Integer	2	Harvest Day of year 1 - 366
CDay	Long	Integer	Cumulative day
DAP	Long	Integer	Days after planting
HIAM	Double	8	Harvest Index at Maturity [g g-1] [Range: 0-1]
LAI	Single	4	Leaf area index, daily [m2 m-2]
LWAD	Long	Integer	Dry Weight - Leaf (kg/ha)
LWAT	Single	4	Dry Weight - Leaf - Tillers only (kg/ha)
SWAD	Long	Integer	Dry Weight - Stem (kg/ha)
SWAT	Single	4	Dry Weight - Stem - Tillers only (kg/ha)
StemResAD	Long	Integer	Dry Weight - Stem reserves (kg/ha)
StemResAT	Long	Integer	Dry Weight - Stem reserves - Tillers only (kg/ha)
GWAD	Long	Integer	Dry Weight - Grain (kg/ha)
GWAT	Single	4	Dry Weight - Grain - Tillers only (kg/ha)
RWAD	Long	Integer	Dry Weight - Root (kg/ha)
RWAT	Single	4	Dry Weight - Root - Tillers only (kg/ha)
CWAD	Long	Integer	Dry Weight -Crop (kg/ha)
CWAT	Single	4	Dry Weight -Crop - Tillers only (kg/ha)
RtWt01	Single	4	Root mass per layer (g m-2)
RtWt02	Single	4	Root mass per layer (g m-2)
RtWt03	Single	4	Root mass per layer (g m-2)
RtWt04	Single	4	Root mass per layer (g m-2)
RtWt05	Single	4	Root mass per layer (g m-2)
RtWt06	Single	4	Root mass per layer (g m-2)
RtWt07	Single	4	Root mass per layer (g m-2)
RtWt08	Single	4	Root mass per layer (g m-2)
RtWt09	Single	4	Root mass per layer (g m-2)
RtWt10	Single	4	Root mass per layer (g m-2)
EPAA	Single	4	Plant transpiration, mm/d, average
EPAC	Single	4	Plant transpiration, mm/d, cumulative
ETAA	Single	4	Evapotranspiration, mm/d, average
ETAC	Single	4	Evapotranspiration, mm/d, cumutative
ESAA	Single	4	Soil evaporation, mm/d, average
ESAC	Single	4	Soil evaporation, mm/d, cumulative
EOAC	Single	4	Potential Evaporation, mm/d, cumulative
EOAA	Single	4	Potential Evaporation, mm/d, average
SWXD	Single	4	Potentially extractable water, cm
ROFC	Single	4	Cumulative runoff, mm
DRNC	Single	4	Cumulative drainage, mm
PREC	Single	4	Cumulative precipitation, mm
IRRC	Single	4	Cumulative irrigation, mm
SRAA	Single	4	Average solar radiation, MJ/m^2
TMXA	Single	4	Average maximum temperature, deg C
TMNA	Single	4	Average minumum temperature, deg C
SW01	Single	4	Soil water in layer n (cm^3/cm^3)
SW02	Single	4	Soil water in layer n (cm^3/cm^3)
SW03	Single	4	Soil water in layer n (cm^3/cm^3)
SW04	Single	4	Soil water in layer n (cm^3/cm^3)
SW05	Single	4	Soil water in layer n (cm^3/cm^3)
SW06	Single	4	Soil water in layer n (cm^3/cm^3)
SW07	Single	4	Soil water in layer n (cm^3/cm^3)
SW08	Single	4	Soil water in layer n (cm^3/cm^3)
SW09	Single	4	Soil water in layer n (cm^3/cm^3)
SW10	Single	4	Soil water in layer n (cm^3/cm^3)
ST01	Single	4	Soil temperature in layer n, deg C
ST02	Single	4	Soil temperature in layer n, deg C
ST03	Single	4	Soil temperature in layer n, deg C
ST04	Single	4	Soil temperature in layer n, deg C
ST05	Single	4	Soil temperature in layer n, deg C
ST06	Single	4	Soil temperature in layer n, deg C
ST07	Single	4	Soil temperature in layer n, deg C
ST08	Single	4	Soil temperature in layer n, deg C
ST09	Single	4	Soil temperature in layer n, deg C
ST10	Single	4	Soil temperature in layer n, deg C
NLCC	Long	Integer	Cumulative N leached, kg/ha
NIAD	Long	Integer	Inorganic N in soil, kg/ha
NOAD	Long	Integer	Organic N in soil, kg/ha
CET	Single	4	Cumulative Evap. loss
ColdFac	Single	4	Low temperature reduction factor [unitless] [Range: 0-1]
DrghtFac	Single	4	Drought reduction factor [unitless] [Range: 0-1]
HeatFac	Single	4	High temperature reduction factor [unitless] [Range: 0-1]
NitroFac	Single	4	Low N reduction factor [unitless] [Range: 0-1]
PhosFac	Single	4	Low P reduction factor [unitless] [Range: 0-1]
PhotoFac	Single	4	Photoperiod reduction factor [unitless] [Range: 0-1]
leafEq	Single	4	Thermal time in leaf equivalents since emergence
PhaseDes	Text	15	Growth phase description
C_FertBl	Single	4	Total below ground Fertilizer C, i.e., lime [kg ha-1]
C_ActInoBl	Single	4	Total below ground Active inorganic C [kg ha-1]
C_SloInoBl	Single	4	Total below ground Slow inorganic C [kg ha-1]
C_ActOrgBl	Single	4	Total below ground Active organic C [kg ha-1]
C_SloOrgBl	Single	4	Total below ground Slow organic C [kg ha-1]
C_ResOrgBl	Single	4	Total below ground Resistant organic C [kg ha-1]
C_RapFOMBl	Single	4	Total below ground Rapid decomposing FOM C (soluble) [kg
C_IntFOMBl	Single	4	Total below ground Intermediate decomposing FOM C
C_SloFOMBl	Single	4	Total below ground Slow decomposing FOM C (lignin) [kg ha-1]
C_RapFOMAb	Single	4	Total above ground Rapid decomposing FOM C (soluble) [kg
C_IntFOMAb	Single	4	Total above ground Intermediate decomposing FOM C
C_SloFOMAb	Single	4	Total above ground Slow decomposing FOM C (lignin) [kg ha-1]
C_StDead	Single	4	Recognizeable standing dead C [kg ha-1]
C_CO2	Single	4	C in cumulative CO2 evolved [kg ha-1]
C_In	Single	4	Total C additions [kg ha-1]
C_Out	Single	4	Total C withdrawals [kg ha-1]
C_Net	Single	4	Net C change [kg ha-1]
N_FertBl	Single	4	Total below ground Fertilizer N [kg ha-1]
N_ActInoBl	Single	4	Total below ground Active inorganic N [kg ha-1]
N_SloInoBl	Single	4	Total below ground Slow inorganic N [kg ha-1]
N_LabileBl	Single	4	Total below ground Labile [includes Solution] N [kg ha-1]
N_Sol	Single	4	Total below ground Solution [included in Labile] N [kg ha-1]
N_ActOrgBl	Single	4	Total below ground Active organic N [kg ha-1]
N_SloOrgBl	Single	4	Total below ground Slow organic N [kg ha-1]
N_ResOrgBl	Single	4	Total below ground Resistant organic N [kg ha-1]
N_RapFOMBl	Single	4	Total below ground Rapid decomposing FOM N (carbo., prot.,
N_SloFOMBl	Single	4	Total below ground Slow decomposing FOM N (lign., cell.,
N_Vol	Single	4	Total N that can readily volatilize from surface-applied FOM
N_Harvst	Single	4	Cumulative harvested plant N [kg ha-1]
N_Plants	Single	4	Cumulative whole plant uptake N [kg ha-1]
N_RapFOMAb	Single	4	Total above ground Rapid decomposing FOM N (soluble) [kg
N_SloFOMAb	Single	4	Total above ground Slow decomposing FOM N (lignin) [kg ha-1]
N_StDead	Single	4	Recognizeable standing dead N [kg ha-1]
N_Fix	Single	4	Cumulative N fixed [kg ha-1]
N_In	Single	4	Total N additions [kg ha-1]
N_Out	Single	4	Total N withdrawals [kg ha-1]
N_Net	Single	4	Net N change [kg ha-1]
P_FertBl	Single	4	Total below ground Fertilizer P [kg ha-1]
P_ActInoBl	Single	4	Total below ground Active inorganic P [kg ha-1]
P_SloInoBl	Single	4	Total below ground Slow inorganic P [kg ha-1]
P_LabileBl	Single	4	Total below ground Labile [includes Solution] P [kg ha-1]
P_Sol	Single	4	Total below ground Solution [included in Labile] P [kg
P_ActOrgBl	Single	4	Total below ground Active organic P [kg ha-1]
P_SloOrgBl	Single	4	Total below ground Slow organic P [kg ha-1]
P_ResOrgBl	Single	4	Total below ground Resistant organic P [kg ha-1]
P_RapFOMBl	Single	4	Total below ground Rapid decomposing FOM P (carbo., prot.,
P_Harvst	Single	4	Cumulative harvested plant P [kg ha-1]
P_Plants	Single	4	Cumulative whole plant uptake P [kg ha-1]
P_RapFOMAb	Single	4	Total above ground Rapid decomposing FOM P (carbo., prot.,
P_StDead	Single	4	Recognizeable standing dead P [kg ha-1]
P_In	Single	4	Total P additions [kg ha-1]
P_Out	Single	4	Total P withdrawals [kg ha-1]
P_Net	Single	4	Net P change [kg ha-1]

Table: Version_Control

Field Name	Type	Length	Description
Version	Single	4
ReleaseDate	Date/Time	8
Notes	Text	255

Database: SDB

Table: Soil_Base

Field Name	Type	Length	Description
SoilID	Text	10	Identifier (Insitute + Site + Year + Soil)
Slsour	Text	11	Source
Sltx	Text	5	Texture, code
Sldp	Integer	2	Depth, cm.
SlDesc	Text	50	Description or local classification.
SSite	Text	11	Site name
SCount	Text	11	Country name
SLat	Single	4	Latitude
SLong	Single	4	Longitude
Tacon	Text	100	Family, SCS system
Scom	Text	5	Color, moist, Munsell hue
Salb	Single	4	Albedo, fraction
U	Integer	2	Evaporation limit, cm.
SWCON	Single	4	Drainage rate, fraction/day
CN2	Integer	2	Runoff curve number (Soil Conservation Service)
Slnf	Single	4	Mineralization factor, 0 to 1 scale
Slpf	Single	4	Photosynthesis factor, 0 to 1 scale
Smhb	Text	5	pH in buffer determination method
Smpx	Text	5	Phosphorous, extractible, determination code
Smke	Text	5	Phosphorous determination method, code
Fldd	Single	4	Drainage depth
PondMax	Single	4	mm

Table: Soil_Layers

Field Name	Type	Length	Description
SoilID	Text	10
ZLYR	Single	4	Depth, base of layer, cm.
MH	Text	5	Master horizon
LL	Single	4	Lower limit. cm^3/cm^3
DUL	Single	4	Upper limit. drained, cm^3/cm^3
SAT	Single	4	Upper limit. saturated, cm^3/cm^3
SHF	Single	4	Root growth factor, 0 to 1
SWCN	Single	4	Sat. hydraulic conductivity, macropore, cm/h
BD	Single	4	Bulk density, moist, g/cm^3
OC	Single	4	organic carbon, %
Clay	Single	4	Clay (<.002 mm), %
Silt	Single	4	Silt (0.05 to 0.002 mm), %
Stones	Single	4	Coarse fraction (>2mm), %
TotN	Single	4	Total nitrogen, %
pH	Single	4	pH in water
pHKcl	Single	4	pH in buffer
CEC	Single	4	Cation exchange capacity, cmol/kg
CaCo	Single	4	CaCo3 content, g kg^-1
ExtAl	Single	4	Aluminum
ExtFe	Single	4	Iron
ExtMn	Single	4	Manganese
TotBas	Single	4	Base saturation, cmol kg^-1
ExK	Single	4	Potassium, cmol kg^-1
ExMg	Single	4	Magnesium, cmol kg^-1
ExNa	Single	4	Sodium, cmol kg^-1
ExTs	Single	4	Sulfur
Slec	Single	4	Electric conductivity, Seimen
KsMtrx	Single	4	Matrix Hydraulic Conductivity, cm d-1
SBioDepF	Single	4	0-1 depth factor that restricts kinetics
TotP	Single	4	Phosphorous, total, mg kg^ -1
P_ActIno	Single	4	Active inorganic P [kg ha-1]
P_SloIno	Single	4	Slow inorganic P [kg ha-1]
P_Labile	Single	4	Labile [includes Solution] P [kg ha-1]

Table: Version_Control

Field Name	Type	Length	Description
Version	Single	4
ReleaseDate	Date/Time	8
Notes	Text	50

Database: UDB

Table: Chart-Fields

Field Name	Type	Length	Description
ChartID	Double	8
Field	Text	50	The short name of the selected field

Table: Chart-Modules

Field Name	Type	Length	Description
ChartID	Double	8
Module	Text	50

Table: Charts

Field Name	Type	Length	Description
ChartID	Double	8	Unique ID for the chart
Title	Text	255
XAxis	Text	50	The x axis field name
Type	Integer	2
3D	Integer	2

Database: WDB

Table: Stations

Field Name	Type	Length	Description
StationID	Text	4
Station_Name	Text	50
Place_Name	Text	10	State, Province, or Country
Lat	Single	4	Latitude
Long	Single	4	Longitude
Elev	Single	4	Elevation
Tav	Single	4	Air temperature average, deg C
Amp	Single	4	Air temperature amplitude, monthly averages, deg C
Tmht	Single	4	Height of temperature measurements, m
Wmht	Single	4	Height of wind measurements, m

Table: Storm_Intensity

Field Name	Type	Length	Description
StationID	Text	4
Month	Integer	2
SIValue	Single	4

Table: Version_Control

Field Name	Type	Length	Description
Version	Single	4
ReleaseDate	Date/Time	8
Notes	Text	255

Table: Weather

Field Name	Type	Length	Description
StationID	Text	4
Year	Integer	2
DOY	Integer	2
SRAD	Single	4	Solar radiation, MJ/m^2/d
TMax	Single	4	Air temperature max, deg C
TMin	Single	4	Air temperature min, deg C
Rain	Single	4	Precipitation, mm
DewP	Single	4	Dewpoint temperature, deg C
Wind	Single	4	Wind run, km/d
Par	Single	4	Photosynthetically active radiation, moles/m^2/d

Database: XDB

Table: Experiments

Field Name	Type	Length	Description
ExpID	Double	8	Sequential ID for the simulation
Title	Text	255
Person	Text	255
Address	Text	255	Contact address
Location	Text	255
SoilID	Text	10	The associated soil, see Soils database (*Sdb)
StationID	Text	4	Weather station ID
NYrs	Integer	2	Number of Years of Simulation
NRrepSq	Integer	2	Number of Replications
ISimI	Text	1	Start of Simulaton, Code
SYear	Integer	2	Starting year of simulation (if needed)
SDOY	Integer	2	Starting day of year (if needed)
ISwWat	Text	1	Water Switch (Y=Yes, N=No)
ISwNit	Text	1	Nitrogen Switch (Y=Yes, N=No)
ISwSym	Text	1	Symbiosis Switch (Y=Yes, N=No, U=Unlimited)
ISwPho	Text	1	Phosphorus Switch (Y=Yes, N=No)
ISwPot	Text	1	Potassium Switch (Y=Yes, N=No)
ISwDis	Text	1	Disease and other pests Switch (Y=Yes, N=No)
MeWth	Text	1	Method used for weather
MeSIC	Text	1	Method for determaining Initial Soil Conditions
MeSLi	Text	1	Method for calculating Light interception
MeEvp	Text	1	Method for calculating Evaporation
MeInf	Text	1	Method for calculating Infiltration
MePho	Text	1	Method for calculating Photosynthesis
IOX	Text	1	Use experiment file name for output files (Y/N)
IDetO	Text	1	Print overview file? (Y/N/(A)ppend)
IDetS	Text	1	Print summary file? (Y/N/(A)ppend)
Frop	Integer	2	Frequency of Output, Days
IDetG	Text	1	Print growth file? (Y/N)
IDetC	Text	1	Print carbon file? (Y/N)
IDetN	Text	1	Print nitrogen file? (Y/N)
IDetP	Text	1	Print phosphorous file? (Y/N)
IDetD	Text	1	Print Diseases and other pest file? (Y/N)
IDetL	Text	1	Print wide file format (Y/N)

Table: Experiments_Notes

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for experiment
Notes	Memo	-	The notes field

Table: Measured_Data

Field Name	Type	Length	Description
RecordID	Long	Integer
ExpID	Double	8	Related to simulation table
FieldName	Text	25
Date	Date/Time	8
Value	Single	4

Table: Measured_Data_Notes

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for experiment
Notes	Memo	-	The notes field

Table: Mgt_Chemical_App

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the experiment
RcID	Double	8	Unique ID for the rotation component
Year	Integer	2	Year Chemical event takes place (if needed)
DOY	Integer	2	Day of yearChemical event takes place (if needed)
DAP	Integer	2	Days after plantingChemical event takes place (if needed)
ChCod	Text	5	Chemical material code
ChAmt	Double	8	Chemical application amount, kg/ha
ChMet	Text	5	Chemical application method
ChDep	Double	8	Chemical application depth, cm
ChT	Text	5	Chemical targets

Table: Mgt_EnvMod_App

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Year	Integer	2	Year environmental modification event takes place (if needed)
DOY	Integer	2	Day of year environmental modification event takes place (if
DAP	Integer	2	Days after planting environmental modification event takes
DayFac	Text	1	Daylight adjustment factor (A,S,M,R)
DayAdj	Double	8	Daylight adjustment, hours
RadFac	Text	1	Radiation adjustment factor (A,S,M,R)
RadAdj	Double	8	Radiation adjustment, MJ/m**2/d
TxFac	Text	1	Temperature (maximum) adjustment factor (A,S,M,R)
TxAdj	Double	8	Temperature (maximum)adjustment, degree C
TnFac	Text	1	Temperature (minimum) adjustment factor (A,S,M,R)
TnAdj	Double	8	Temperature (minimum) adjustment, degree C
PrcFac	Text	1	Precip. adjustment factor (A,S,M,R)
PrcAdj	Double	8	Precip. adjustment, mm
CO2Fac	Text	1	CO2 adjustment factor (A,S,M,R)
CO2Adj	Double	8	CO2 adjustment, ppm
DptFac	Text	1	Dew Point adjustment factor (A,S,M,R)
DptAdj	Double	8	Dew Point adjustment, degree C
WndFac	Text	1	Wind adjustment factor (A,S,M,R)
WndAdj	Double	8	Wind adjustment, km/day

Table: Mgt_Fertilizer_App

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Year	Integer	2	Year fertilizer event takes place (if needed)
DOY	Integer	2	Day of year fertilizer event takes place (if needed)
DAP	Integer	2	Days after planting fertilizer event takes place (if needed)
IFType	Text	5	Fertilizer material code
FerCode	Text	5	Fertilizer application/placement code
FInP	Single	4	Fertilizer incorporation percent
DFert	Double	8	Fertilizer application/placement depth, cm
ACrbFer	Double	8	C in applied fertilizer, kg/ha
ANFer	Double	8	N in applied fertilizer, kg/ha
APFer	Long	Integer	P in applied fertilizer, kg/ha
AKFer	Long	Integer	K in applied fertilizer, kg/ha
ACFer	Long	Integer	Ca in applied fertilizer, kg/ha
AOFer	Double	8	Other elements in applied fertilizer, kg/ha
FOCod	Text	5	Other element code
FerDecRt	Single	4	Fertilizer decomposition rate constant under optimum
VolN	Single	4	Percent of total N that can readily volatilize if
VolNRate	Single	4	Rate constant for percent of total N that can readily

Table: Mgt_Fertilizer_Auto

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
DSoilN	Double	8	Application depth, cm
SoilNC	Double	8	Threshold, N stress factor, %
SoilNX	Double	8	Amount per application, kg N/ha
NCode	Text	5	Material code
NEnd	Text	5	End of applications, growth stage

Table: Mgt_Harvest_App

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Year	Integer	2	Yearharvest event takes place (if needed)
DOY	Integer	2	Day of year harvest event takes place (if needed)
DAP	Integer	2	Days after planting harvest event takes place (if needed)
HStg	Text	5	Harvest Stage, Code
HCom	Text	5	Harvest Component, Code
HSiz	Text	5	Harvest Size Group, Code
HPc	Double	8	Harvest Percentage, %
HBPc	Double	8	Percent of byproduct harvested, %
HKnDnPc	Single	4	Percent of stalk/leaves knocked down at harvest, %

Table: Mgt_Harvest_Auto

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
HDlay	Integer	2	Earliest, days after maturity
HLYear	Integer	2	Year for end of harvest window
HLDOY	Integer	2	Day of year for end of harvest window
HPP	Double	8	Percentage of product harvested, %
HRP	Double	8	Percentage of residue harvested, %

Table: Mgt_InitialCond

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
Year	Integer	2	Year soil analysis takes place (if needed)
DOY	Integer	2	Day of year soil analysis takes place (if needed)
PrCrop	Text	2	Previous crop code
WResR	Double	8	Root weight from previous crop, kg/ha
WResNd	Double	8	Nodule weight from previous crop, kg/ha
EfInoc	Double	8	Rhizobia number, 0 to 1 scale (default = 1)
EfNFix	Double	8	Rhizobia effectiveness, 0 to 1 scale (default =1)
FlDD	Single	4	Drain Depth, cm
SFDrn	Long	Integer	Drain spacing, m

Table: Mgt_InitialCond_Lay

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
DLayrI	Double	8	Depth, base of layer, cm
SWInit	Double	8	Water, cm3/cm3
INinorg	Double	8	Initial inorganic N, mg kg-1
TotP	Single	4	Phosphorous, total, mg kg^ -1
P_ActIno	Single	4	Active inorganic P [kg ha-1]
P_SloIno	Single	4	Slow inorganic P [kg ha-1]
P_Labile	Single	4	Labile [includes Solution] P [kg ha-1]

Table: Mgt_Irrigation_App

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Year	Integer	2	Yearirrigation event takes place (if needed)
DOY	Integer	2	Day of year irrigation event takes place (if needed)
DAP	Integer	2	Days after planting irrigation event takes place (if needed)
IrrCod	Text	50	Irrigation operation code
Amt	Double	8	Irrigation amount, depth of water/water table, bund height, or
DFDrn	Text	5	Drainage type
FLDD	Double	8	Drain depth, cm
SFDrn	Double	8	Drain Spacing, m

Table: Mgt_Irrigation_Auto

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
EffIrr	Double	8	Irrigation application efficiency, fraction
DSoil	Double	8	Management Depth for automatic application, cm
ThetaC	Double	8	Threshold for automatci application % of max. available
IEPt	Double	8	End point for automatic applicaiont, % of max. available
IOff	Text	5	End of applications, growth stage
IAMe	Text	5	Method for Automatic applications, code
AIrAm	Double	8	Amount per irrigation if fixed, mm

Table: Mgt_Planting

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
CropMod	Text	1	Crop model to be used
SpeciesID	Text	2	Crop Code (see crops table)
CultivarID	Text	10	Cultivar ID (see cultivar table)
Year	Integer	2	Planting year
DOY	Integer	2	Planting day of year
EYear	Integer	2	Emergence year
EDOY	Integer	2	Emergence day of year
Ppop	Single	4	Plant population at seeding, plants/sq. meter
Ppoe	Single	4	Plant population at emergence, plants/sq. meter
PlMe	Text	1	Planting method, Transplant (T), seed (S), pregerminated seed
PlDs	Text	1	Planting distribution, row (R), broadcast (B) or hill (H)
RowSpc	Double	8	Row spacing, cm
AziR	Double	8	Row direction, degrees from N
SDepth	Double	8	Planting Depth, cm
SdWtPl	Double	8	Planting material dry weight, kg/ha
SdAge	Double	8	Transplant age, days
ATemp	Double	8	Temp. of transplant environment, degree C
PlPH	Double	8	Plants per hill

Table: Mgt_Planting_Auto

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
FYear	Integer	2	Year for beginning of planting window
FDOY	Integer	2	Day of year for beginning of planting window
LYear	Integer	2	Year for end of planting window
LDOY	Integer	2	Day of year for end of planting window
SwPltL	Double	8	Lowermost soil water, %
SwPltH	Double	8	Uppermost soil water, %
SwPltD	Double	8	Management depth for water, cm
PTx	Double	8	Max. soil temp. (10 cm average), degree C
PTTn	Double	8	Max. soil temp. (10 cm average), degree C

Table: Mgt_Residue_App

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Year	Integer	2	Year residue event takes place (if needed)
DOY	Integer	2	Day of year residue event takes place (if needed)
DAP	Integer	2	Days after planting residue event takes place (if needed)
ResCode	Text	50	Residue material, code
Residue	Double	8	Residue amount, kg/ha dry wt.
RInP	Double	8	Residue incorporation percentage, %
DepRes	Double	8	Residue incorporation depth, cm
ResC	Single	4	C content of residues [% dry wt.]
ResN	Single	4	N content of residues [% dry wt.]
ResP	Single	4	P content of residues [% dry wt.]
SlowC	Single	4	Percent of total C in slowly decomposing material such as
IntermdC	Single	4	Percent of total C in intermediate decomposing material such
SlowN	Single	4	Percent of total N in slowly decomposing material such as
VolN	Single	4	Percent of FOM pool N that can readily volatilize if
VolNRate	Single	4	Rate constant for percent of FOM pool N that can readily
SloFOMAb	Single	4	Slow FOM decomposition constant above ground [d-1]
SloFOMBl	Single	4	Slow FOM decomposition constant below ground [d-1]
IntFOMAb	Single	4	Intermediate FOM decomposition constant above ground [d-1]
IntFOMBl	Single	4	Intermediate FOM decomposition constant below ground [d-1]
RapFOMAb	Single	4	Rapid FOM decomposition constant above ground [d-1]
RapFOMBl	Single	4	Rapid FOM decomposition constant below ground [d-1]

Table: Mgt_Residue_Auto

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
RIP	Double	8	Incorporation percentage, % of remaining
NResDL	Integer	2	Incorporation time, days after harvest
DResMG	Double	8	Incorporation depth, cm

Table: Mgt_SoilAnalysis

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Year	Integer	2	Year soil analysis takes place (if needed)
DOY	Integer	2	Day of year soil analysis takes place (if needed)
SMHB	Text	5	pH in buffer determination method, code
SMPX	Text	5	Phosphorus determination method, code
SMKE	Text	5	Potassium determination method, code

Table: Mgt_SoilAnalysis_Lay

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
SABL	Double	8	Depth, base of layer, cm
SADM	Double	8	Bulk densityk moist, g/cm**3
SAOC	Double	8	Organic carbon, g/kg
SANI	Double	8	Total nitrogen, g/kg
SApHW	Double	8	pH in water
SApHB	Double	8	pH in buffer
SAPX	Double	8	Phosphorus, extractable, mg/kg
SAKE	Double	8	Potassium, exchangeable, cmol/kg

Table: Mgt_Tillage_App

Field Name	Type	Length	Description
ExpID	Double	8	Unique ID for the simulation
RcID	Double	8	Unique ID for the treatment (see treatment table)
Year	Integer	2	Year tillage event takes place (if needed)
DOY	Integer	2	Day of year tillage event takes place (if needed)
DAP	Integer	2	Days after planting tillage event takes place (if needed)
TImpl	Text	5	Tillage Implement code
TDep	Double	8	Tillage depth, cm

Table: Rotation_Components

Field Name	Type	Length	Description
ExpID	Double	8	Related to Simulation table
RcID	Double	8	Unique ID for this component
OrderNum	Integer	2	Order of the treatment (1, 2, 3...)
Title	Text	50	Treatment title
IPltI	Text	1	Planting/Transplant management [(A)uto or (R)eported Date]
IIrrI	Text	1	Irrigation management [(A)uto, (N)ot Irrigated, Auto with
IferI	Text	1	Fertilizer management [(A)uto, (N)o Fertilizer, Auto with
IResI	Text	1	Residue management [(A)uto for crop sequence, (N)o residue,
ITilI	Text	1	Tillage management [(A)uto for crop sequence, (N)o tillage,
IHarI	Text	1	Harvest management [(A)uto, auto at (G)rowth stages, at

Table: Version_Control

Field Name	Type	Length	Description
Version	Single	4
ReleaseDate	Date/Time	8
Notes	Text	255

Return to Nowlin Chair Home Page

Database	Table
CDB
	Complex_Cultivar
	Complex_Species_Base
	Complex_Species_Phases
	Complex_Species_TempFactors
	N_Fix
	Simple_Crop
	Version_Control
DDB
	Data_Dictionary
	Data_Field_Choices
GDB
	Chart-Fields
	Chart-Modules
	Charts
	Crop_Par
	Fert_Par
	HelpFiles
	Irr_Par
	Residue_Par
	Soil_Bio_Kinetic_Par
	Till_Par
RDB
	Results
	Results_Layer
	Results_Seasonal
	Version_Control
SDB
	Soil_Base
	Soil_Layers
	Version_Control
UDB
	Chart-Fields
	Chart-Modules
	Charts
WDB
	Stations
	Storm_Intensity
	Version_Control
	Weather
XDB
	Experiments
	Experiments_Notes
	Measured_Data
	Measured_Data_Notes
	Mgt_Chemical_App
	Mgt_EnvMod_App
	Mgt_Fertilizer_App
	Mgt_Fertilizer_Auto
	Mgt_Harvest_App
	Mgt_Harvest_Auto
	Mgt_InitialCond
	Mgt_InitialCond_Lay
	Mgt_Irrigation_App
	Mgt_Irrigation_Auto
	Mgt_Planting
	Mgt_Planting_Auto
	Mgt_Residue_App
	Mgt_Residue_Auto
	Mgt_SoilAnalysis
	Mgt_SoilAnalysis_Lay
	Mgt_Tillage_App
	Rotation_Components
	Version_Control