# AppColumnCodes

CodeLabel:
Boundary plot.  Plot contains two distinct age classes


CodeLabel:
Root disease present within 50 ft but no evidence on plot


CodeLabel:
TU5-Very High Load, Dry Climate Timber-Shrub


CodeLabel:
Indian Paint Fungus (Echinodontium tinctorium)


CodeLabel:
GR3-Low Load, Very Coarse, Humid Climate Grass


CodeLabel:
Brown Trunk Rot / Quinine (Fomitopsis officinalis)


CodeLabel:
50 to 75 percent canopy reduction with most of ground considered infected.


CodeLabel:
TU2-Moderate Load, Humid Climate Timber-Shrub


CodeLabel:
GS4-High Load, Humid Climate Grass-Shrub


CodeLabel:
True fir / hemlock >= 60% PSF MH WH ES GF


CodeLabel:
Brown Cubical Rot (Polyporus schweinitzii)


CodeLabel:
Dead 50+ Years, Sapwood Soft or Gone, Heartwood Soft


CodeLabel:
Contains an abandoned road or major skidtrail.


CodeLabel:
TU1-Low Load, Dry Climate Timber-Grass-Shrub


CodeLabel:
Minor evidence of root disease on plot - Minor part of overstory showing symptoms.


CodeLabel:
SB2-Moderate Load Activity Fuel or Low Load Blowdown


CodeLabel:
No evidence of root disease visible within 50 ft.


CodeLabel:
GR8-High Load, Very Coarse, Humid Climate Grass


CodeLabel:
Moisture Deficiency (Heat / Drought Caused)


CodeLabel:
The plot contains some other feature. Describe in Remarks.


CodeLabel:
Canopy reduction to 20 percent - death of one codominant tree


CodeLabel:
Dead 5-50 Years, No Fine Banches, Sapwood Soft


CodeLabel:
SB3-High Load Activity Fuel or Moderate Load Blowdown


CodeLabel:
Entire plot falls within a definite root disease; no overstory trees present.


CodeLabel:
GS3-Moderate Load, Humid Climate Grass-Shrub


CodeLabel:
Canopy reduction 30 to 50 percent - with evidence of root disease killed trees.


CodeLabel:
SH4-Low Load, Humid Climate Timber-Shrub


CodeLabel:
Salvage - Not 100% commercial forest land


CodeLabel:
Contains swamp  spring  other riparian area.


CodeLabel:
Entire plot falls within a definite root disease patch; only a few trees left


CodeLabel:
GS2-Moderate Load, Dry Climate Grass-Shrub


CodeLabel:
TU3-Moderate Load, Humid Climate Timber-Grass-Shrub


CodeLabel:
Canopy reduction 20 to 30 percent - live trees with advance symptoms.


# FVS_GroupAddFilesAndKeywords

FVSKeywords:
Database
DSNIn
Blank_Database.mdb
StandSQL
SELECT *
FROM FVS_StandInit
WHERE Stand_ID = '%StandID%'
EndSQL
TreeSQL
SELECT *
FROM FVS_TreeInit
WHERE Stand_ID = '%StandID%'
EndSQL
END


FVSKeywords:
Database
DSNIn
Blank_Database.mdb
StandSQL
SELECT *
FROM FVS_PlotInit
WHERE StandPlot_ID = '%StandID%'
EndSQL
TreeSQL
SELECT *
FROM FVS_TreeInit
WHERE StandPlot_ID = '%StandID%'
EndSQL
END


# InventoryDesign

DesignComments:
Timber CFI.  All live, dead, mortality, and harvest timber species GT EQ 5.0" dbh recorded on 1/5 acre plot.         Sound, dead woodland species >= 3.0DRC recorded on 1/5 acre plot.      Live woodland species >=3.0DRC measured in the NE quad (1/20th acre plot).  Live timber species < 5.0" and live woodland species <3.0 DRC measured on 1/100th acre plot.   SI trees may or may not have been on the actual plot…..    There were 56 plots measured at M1.  We aren't clear if they number-tagged snags in the field or if a number was assigned just to go thru the inventory program. (I would like to put snags in a separate table without assigning a number to them - get them out of the database).

Questions:
see Zuni TIA of 2000 in BOFRP Library for methods.

CommentsClarification:
I tried to convert their codes to our present codes as best I could.  See 1996 AllTreeData table for original data as well as my conversions.


DesignComments:
All trees (woodland and timber) >=5.0" DBH or DRC will be recorded on the 1/5th acre plot.  There will not be a growth relationship for the trees outside the NE quad (FYI for Analysis).  MP code 2 = timber species throughout plot; code 2 for >=5.0" DRC woodland species that are in the NE quad; and code 5 for large woodland species outside the NE quad.  (these will basically be new to the measurement).     Including the 3 - 4.9 inch trees in the tree table so the field crew can find them; then they will pull nails of any tree still <5.0 at M2.    These trees will be given a problem code 97 and severity 9 which means BOFRP needs to delete these trees.     Besides the 56 remeasure, there will be 199 new installs.

Questions:
Zuni will be searching for the plots to try to determine what 4- or 6-digit number relates to the plot numbers in this database.


# ProjectTypes

Description:
Represents  and indicates a continuous forest inventory project type


# Species

SpeciesName:
East Side and Rockey Mountain Douglas-fir


SpeciesName:
West Side Douglas-fir in R-6 and on Klamath and Six Rivers NFs in R-5


SpeciesName:
Group of Yellow Poplar, Basswood and Cucumber


SpeciesName:
True Firs (excl. Noble Fir in R-6 west side from Williamette and Northerly)


# ValidationRules

ValidationDescription:
Slope Pct > 0 (parent rule), Aspect must be code 1 - 8


ValidationDescription:
stand class 2 (parent rule), Stand age should be at least 40


ValidationDescription:
Sapling trees in Minor Plot 2 (parent rule), no height required


ValidationDescription:
Poletimber  and Sawtimber trees in Minor Plot 2 (parent rule), height required


ValidationDescription:
Slope Pct 0 (parent rule), Aspect must be 0


ValidationDescription:
Stockability Factor not 1 (parent rule), Pct must be less than 100


ValidationDescription:
Harvest, Mortality, Thinned, Missing, Old Mortality, Old Harvest, or Incorrectly Included Tree


ValidationDescription:
Tree History is 0 or 5 (parent rule), Base Code Check


ValidationDescription:
Minor Plot 1 (parent rule), DBH of Sawtimber trees


ValidationDescription:
Poletimber trees in Minor Plot 1 (parent rule),  no height required


ValidationDescription:
Minor Plot 2 (parent rule), DBH of Poletimber and Sawtimber trees collected


ValidationDescription:
Tree history is 1,2,3,4,6,7,8  (parent rule), no height required


ValidationDescription:
Tree Problem1 present (parent rule), Severity1 required


ValidationDescription:
Tree History 0 or 5 (parent rule), CrownRatio required


ValidationDescription:
Tree History 0 or 5 (parent rule), Base Range Check


ValidationDescription:
Tree Problem2 present (parent rule), Severity2 required


ValidationDescription:
Minor Plot 0 (parent rule), only sawtimber trees require IDBH


ValidationDescription:
Minor Plot 1 (parent rule), DBH of Poletimber trees


ValidationDescription:
Sawtimber trees in Minor Plot 1 (parent rule),  height required


ValidationDescription:
Minor Plot 2 (parent rule), DBH of Sapling trees collected


ValidationDescription:
Tree History is 2 or 3 (parent rule), Problem1 required


# ValidationRuleTypes

Description:
Integer must be equal to or greater than a minimum


Description:
Integer must be equal to or less than a maximum


Description:
Value must be within a range inclusively


Description:
Value must be in a list of data entry codes


Description:
Value must be in a specified list of values


Description:
String or number value must be equal to a specified value


Description:
String or number value must not be equal to a specified value


Description:
String or number value must less than a specified value


Description:
String or number value must greater than a specified value


Description:
Designated data element must increase over time


Description:
Previous value must be in a specified list of values


# zstblDBVersionInfo

Description:
Updated species table and fixed Definition table.


Description:
Combined database variants into on new master DB version. Added calculation lookup tables.


Description:
Added Report Generation tables. Filled in Species_Codes table with all species. Adjusted Species_Codes table structure.


Description:
Added tbl_Regions table.

 Added tbl_Agencies table.

 Added tbl_Reservations table.

 Renamed  existing ReservationID field of the tblProject table to ReservationCode.

 Added the ReservationID field to the tblProject table as a replicationID number type.

 Added CFIDEER_GetProjectPlots query to fetch abreviated plot information for a project.

 Modified CFIDEER_GetProject to include the ReservationCode field.

 Modified CFIDEER_GetProjectInfo to include the ReservationCode field.

 Added tblAnalysisRuns table.

 Added PRESUP_GetProjectAnalysisRuns select query.

 Added PRESUP_GetAnalysisRun select query.

 Added PRESUP_AddAnalysisRun append query.

 Added PRESUP_UpdateAnalysisRun update query.

 Added PRESUP_DeleteAnalysisRun delete query.


Description:
Changed data type of the Species_Code field of the tlkpSpecies_Codes table from Double to Integer.

 Removed the following fields from the tlkpSpecies_Codes table:





 
  RMStand_Code - text(255)

  FVS_AK - double

  FVS_BM - double

  FVS_CA - double

  FVS_CI - double

  FVS_CR - double

  FVS_CS - text(255)

  FVS_EC - double

  FVS_EM - text(255)

  FVS_IE - double

  FVS_KT - double

  FVS_LS - double

  FVS_NC - double

  FVS_NE - double

  FVS_NI - double

  FVS_PN - double

  FVS_SN - double

  FVS_SO - double

  FVS_TT - text(255)

  FVS_UT - double

  FVS_WC - double

  FVS_WS - double


Description:
Made the following modifications to tblPlotMeasurementsProject:





 
  Changed BIAProjectPlotMeasID field data type from AutoNumber to Number It is still a ReplicationID.

  Deleted BIAProjectPlotID(ReplicationID)  field.

  Deleted ProjectPeriodID(ReplicationID) field.

 





 Made the following modifications to tblAnalysisRuns:





 
  Changed Description field data type from Text to Memo.

  Added UseAllPlots(Yes/No) field.


Description:
tblPlotMeasurementsProject edits:





 
  Added BIAProjectPlotID guid field back into table.

  Added ProjectPeriodID guid field back into table.

 





  Added tblAnalysisRunSpecifications table.

  Changed tlkpPerAcreExpansions.Minor_Plot field data type from Text to Number:Long Integer.

 Added BIAProjectPlotSummaryID guid  as the primary key to the tblPlotSummary table.


Description:
Added CFIDEER_GetReservation query.

 Added CFIDEER_ReservationExists query.


Description:
Added tlkpProjectTypes lookup table.

 Added TypeID foreign key to tblProjects table to link to tlkpProjectTypes.

 Added TypeID to CFIDEER_GetProject query.


Description:
Added Plot_Label text field to tblPlot table.

 Added ContentType long integer field to tblFieldName_Definitions table.


Description:
Added values in ContentType field for existing records in tblFieldName_Definitions table.


Description:
Added test error check table, Hahn and bare volume coefficient table


Description:
Added FVS Grouping table, Revised Error check table. Added lookup tables listing all Site Index and volume equations


Description:
Changed tblTreeMeasurements.Period_Number's field format content from TEXT,5  to {0,6:n0}.

 Changed tblRegnMeasurements.Period_Number's field format content from TEXT,6 to {0,6:n0}.


Description:
Changed the names of the following tables:





 
  tbl_Regions to Regions

  tbl_Agencies to Agencies

  tbl_Reservations to Reservations


Description:
Changed the names of the following tables:





 
  tblProject to Projects

  tblProjectMeasurementPeriods to ProjectMeasurementPeriods


Description:
Changed the names of the following tables:





 
  tblPlot to Plots

  tblPlotMeasurements to PlotMeasurements

  tblPlotMeasurementsProject to CustomPlotMeasurements

 





 Changed the names of the following queries:





 
  CFIDEER_UpdatePlotMeasurementProject to CFIDEER_UpdateCustomPlotMeasurements

 





 Changed the following field names:





 
  Plots.BIAProjectPlotID to Plots.PlotID

  Plots.BIAProjectID to Plots.ProjectID

  Projects.Created_Date to Projects.Created

  Projects.Updated_Date to Projects.Updated

  ProjectMeasurementPeriods.CreatedDate to ProjectMeasurementPeriods.Created

  ProjectMeasurementPeriods.Updated_Date to ProjectMeasurmentPeriods.Updated

 





 Removed the following indexes:





 
  Regions.RetrievalID

  Agencies.RetrievalID

  Reservations.RetrievalID


Description:
Changed the following field names:





 
  Plots.Plot_Number to Plots.PlotNumber

  Plots.Plot_Label to Plots.PlotLabel

  Plots.Plot_Type to Plots.PlotType

  Plots.State_Code to Plots.StateCode

  Plots.County_Code to Plots.CountyCode

  Plots.Management_Unit to Plots.ManagementUnit

  Plots.Quad_Sheet to Plots.QuadSheet

  Plots.Slope_Percent to Plots.SlopePercent

  Plots.Slope_Position to Plots.SlopePosition

  Plots.Habitat_Type to Plots.HabitatType

  Plots.Soil_Code to Plots.SoilCode

  Plots.UTM_Northing_Coordinate to Plots.UTMNorthingCoordinate

  Plots.UTM_Easting_Coordinate to Plots.UTMEastingCoordinate

  Plots.UTM_Zone to Plots.UTMZone

  Plots.Per_Acre_Expansion to Plots.PerAcreExpansion

  Plots.Created_Date to Plots.Created

  Plots.Updated_Date to Plots.Updated

  Plots.Retrieval_ID to Plots.RetrievalID


Description:
Changed the following field names:





 
  PlotMeasurements.BIAProjectPlotMeasID to PlotMeasurements.MeasurementID

  PlotMeasurements.BIAProjectPlotID to PlotMeasurements.PlotID

  PlotMeasurements.Period_Number to PlotMeasurements.PeriodNumber

  PlotMeasurements.Plot_Status to PlotMeasurements.PlotStatus

  PlotMeasurements.Forest_Classification to PlotMeasurements.ForestClassification

  PlotMeasurements.Aerial_Photo_Number to PlotMeasurements.AerialPhotoNumber

  PlotMeasurements.Measurement_Date to PlotMeasurements.MeasurementDate

  PlotMeasurements.Last_Growing_Season to PlotMeasurements.LastGrowingSeason

  PlotMeasurements.Cut_Treatment to PlotMeasurements.CutTreatment

  PlotMeasurements.Cut_Date to PlotMeasurements.CutDate

  PlotMeasurements.Followup_Treatment to PlotMeasurements.FollowupTreatment

  PlotMeasurements.Followup_Date to PlotMeasurements.FollowupDate

  PlotMeasurements.Stand_Class to PlotMeasurements.StandClass

  PlotMeasurements.Stand_Age to PlotMeasurements.StandAge

  PlotMeasurements.Stockability_Factor to PlotMeasurements.StockabilityFactor

  PlotMeasurements.Stockability_Pct to PlotMeasurements.StockabilityPct

  PlotMeasurements.SI_Species to PlotMeasurements.SISpecies

  PlotMeasurements.SI_DBH to PlotMeasurements.SIDBH

  PlotMeasurements.SI_Total_Height to PlotMeasurements.SITotalHeight

  PlotMeasurements.SI_Age to PlotMeasurements.SIAge

  PlotMeasurements.SI_Growth to PlotMeasurements.SIGrowth

  PlotMeasurements.SI_Base_Age to PlotMeasurements.SIBaseAge

  PlotMeasurements.Calc_Site_Index to PlotMeasurements.CalcSiteIndex

  PlotMeasurements.Plot_Remarks to PlotMeasurements.PlotRemarks

  PlotMeasurements.Created_Date to PlotMeasurements.Created

  PlotMeasurements.Updated_Date to PlotMeasurements.Updated

  PlotMeasurements.Retrieval_ID to PlotMeasurements.RetrievalID


Description:
Changed the following field names:





 
  CustomPlotMeasurements.BIAProjectPlotMeasID to CustomPlotMeasurements.MeasurementID

  CustomPlotMeasurements.Created_Date to CustomPlotMeasurements.Created

  CustomPlotMeasurements.Updated_Date to CustomPlotMeasurements.Updated

  CustomPlotMeasurements.Retrieval_ID to CustomPlotMeasurements.RetrievalID

 





 Removed the following fields:





 
  CustomPlotMeasurements.BIAProjectPlotID

  CustomPlotMeasurements.ProjectPeriodID

  CustomPlotMeasurements.Map_Cover_Type

  CustomPlotMeasurements.Map_Size

  CustomPlotMeasurements.Map_Density

  CustomPlotMeasurements.Field_Cover_Type

  CustomPlotMeasurements.Field_Size

  CustomPlotMeasurements.Field_Density

  CustomPlotMeasurements.Physiographic_Class

  CustomPlotMeasurements.Soil_Class

  CustomPlotMeasurements.RP_UTM_N_ACTUAL

  CustomPlotMeasurements.RP_UTM_E_ACTUAL

  CustomPlotMeasurements.PC_UTM_N_ACTUAL

  CustomPlotMeasurements.PC_UTM_E_ACTUAL

  CustomPlotMeasurements.Operability

  CustomPlotMeasurements.Stand_Treat_Hist

  CustomPlotMeasurements.Map_Timber_Type

  CustomPlotMeasurements.Field_Timber_Type

  CustomPlotMeasurements.Trend_Plot

 





 Added the following fields:





 
  CustomPlotMeasurements.CustomField


Description:
Added the following queries:





 
  GetProjectID

  GetProjectInformation

 





 Removed old sample fields from CFIDEER_GetPlotMeasurmentsForPeriod and added CustomField as a sample.

 Changed the name of the following queries:





 
  CFIDEER_AddPlotMeasurementProject to CFIDEER_AddCustomPlotMeasurement

  CFIDEER_UpdatePlotMeasurementProject to CFIDEER_UpdateCustomPlotMeasurement

 





 Changed the names of the following query parameters:





 
  CFIDEER_UpdatePlot.CreatedDate to CFIDEER_UpdatePlot.Created

  CFIDEER_UpdatePlot.UpdatedDate to CFIDEER_UpdatePlot.Updated

  CFIDEER_AddPlotMeasurement.PlotMeasurementID to  CFIDEER_AddPlotMeasurement.MeasurementID

  CFIDEER_AddPlotMeasurement.CreatedDate to CFIDEER.AddPlotMeaurement.Created

  CFIDEER_AddPlotMeasurement.UpdatedDate to CFIDEER_AddPlotMeasurement.Updated

  CFIDEER_AddCustomPlotMeasurement.PlotMeasurementID to CFIDEER_AddCustomPlotMeasurement.MeasurementID

  CFIDEER_AddCustomPlotMeasurement.CreatedDate to  CFIDEER_AddCustomPlotMeasurement.Created

  CFIDEER_AddCustomPlotMeasurement.UpdatedDate to  CFIDEER_AddCustomPlotMeasurement.Updated

 





 Removed the following fields from CFIDEER_AddCustomPlotMeasurement:





 
  BIAProjectPlotID

  BIAProjectPeriodID

 





 Removed the following parameters from CFIDEER_AddCustomPlotMeasurement:





 
  PlotID

  PeriodID


Description:
Changed the names of the following CFIDEER_UpdatePlotMeasurement parameters:





 
  CreatedDate to Created

  UpdatedDate to Updated

 





 Added the following fields to the CFIDEER_UpdatePlotMeasurement:





 
  Created

  Updated

  UpdUser

  RetrievalID

 





 Removed the sample fields and parameters from CFIDEER_UpdateCustomPlotMeasurement.

 Changed the names of the following CFIDEER_UpdateCustomPlotMeasurement parameters:





 
  CreatedDate to Created

  UpdatedDate to Updated


Description:
Added all available data fields from PlotMeasurements to CFIDEER_GetPlotMeasurementsForPeriod.

 Added fields and respective parameters to CFIDEER_UpdatePlotMeasurement to match data fields added above.

 Added CustomPlotMeasurements table to CFIDEER_UpdatePlotMeasurement and added its Custom field and parameter.

 Deleted obsolete CFIDEER_UpdateCustomPlotMeasurement query.

 Removed the following fields from CustomPlotMeasurements:





 
  Created

  Updated

  UpdUser

  RetrievalID


Description:
Deleted obsolete CFIDEER_GetProjectInfo query.

 Deleted obsolete CFIDEER_GetRegenMeasurementsForPeriod query.

 Deleted obsolete CFIDEER_PlotExistsInPeriod query.


Description:
Changed the name of the following tables:





 
   CustomPlotMeasurements to PlotCustomMeasurements

  tblPlotSummary to PlotSummaries

  tlkpPlotTypeCodes to PlotTypeCodes

 





 Changed the name of the following fields in PlotSummaries:





 
  BIAProjectPlotSummaryID to SummaryID

  BIAProjectPlotCalcID to CalculationID

  BIAProjectPlotMeasID to MeasurementID

  Volume_Key to VolumeKey

  Trees_Per_Acre to TreesPerAcre

  Basal_Area_Acre to BasalAreaAcre

  CUFT_Volume to CUFTVolume

  CUFT_Sawtimber to CUFTSawtimber

  BDFT_Volume to BDFTVolume

  CUFT_Growth to CUFTGrowth

  BDFT_Growth to BDFTGrowth

  Timb_Seed_Acre to TimbSeedAcre

  Timb_Sap2_Acre to TimbSap2Acre

  Timb_Sap4_Acre to TimbSap4Acre

  Wood_Seed_Acre to WoodSeedAcre

  Wood_Sap2_Acre to WoodSap2Acre

  Wood_Sap4_Acre to WoodSap4Acre

  Created_Date to Created

  Updated_Date to Updated

  Retrieval_ID to RetrievalID

 





 Added GetPlotSummaryForPlotAndPeriod query.


Description:
Renamed the following tables:





 
  tblTree to Trees

  tblTreeMeasurements to TreeMeasurements

  tblTreeMeasurementsProject to TreeCustomMeasurements

 





 Renamed the following queries:

 CFIDEER_AddTreeMeasurementProject to CFIDEER_AddTreeCustomMeasurement

 CFIDEER_AddTreeMeasurementProject to CFIDEER_AddTreeCustomMeasurement

 Removed obsolete CFIDEER_UpdateTreeMeasurementProject query.

 Changed the name of the following fields in Trees:





 
  BIAProjectTreeID to TreeID

  BIAProjectPlotID to PlotID

  Plot_Number to PlotNumber

  Tree_Number to TreeNumber

  Species_Code to SpeciesCode

  Created_Date to Created

  Updated_Date to Updated

  Retrieval_ID to RetrievalID

 





 Changed the name of the following fields in TreeMeasurements:





 
  BIAProjectTreeMeasID to MeasurementID

  BIAProjectTreeID to TreeID

  Period_Number to PeriodNumber

  Minor_Plot to MinorPlot

  Tree_History to TreeHistory

  Tree_Class to TreeClass

  Tree_Status to TreeStatus

  Stem_Count to StemCount

  BDFT_Defect to BDFTDefect

  Tree_Age to TreeAge

  Total_Height to TotalHeight

  Problem_1 to Problem1

  Severity_1 to Severity1

  Problem_2 to Problem2

  Severity_2 to Severity2

  Problem_3 to Problem3

  Severity_3 to Severity3

  DM_U_M_L to DMUML

  DM_Rating to DMRating

  Crown_Ratio to CrownRatio

  Per_Acre_Expansion to PerAcreExpansion

  Tree_Remarks to TreeRemarks

  Created_Date to Created

  Updated_Date to Updated

  Retrieval_ID to RetrievalID

 





 Renamed the following fields in TreeCustomMeasurements:





 
  BIAProjectTreeMeasID to MeasurementID

 





 Removed the following fields from TreeCustomMeasurements:





 
  Created

  Updated

  UpdUser

  RetrievalID

 





 Removed the sample fields and parameters from TreeCustomMeasurements and added CustomField.


Description:
Renamed the following tables:





 
  tblTreeCalculations to TreeCalculations

 





 Removed the following fields from TreeCalculations:





 
  BIAProjectTreeMeasID

  BIAProjectTreeID

  ProjectPeriodID

  Period_Number

 





 Changed the name of the following fields in TreeCalculations:





 
  BIAProjectTreeCalcID to CalculationID

  Calc_DBH to CalcDBH

  Calc_BA to CalcBA

  Calc_Total_Height to CalcTotalHeight

  Calc_CUFT_Height to CalcCUFTHeight

  Calc_CUFT_Defect to CalcCUFTDefect

  Calc_CUFT_Top_DOB to CalcCUFTTopDOB

  Calc_CUFT_GrossVol to CalcCUFTGrossVol

  Calc_BDFT_Height to CalcBDFTHeight

  Calc_BDFT_Defect to CalcBDFTDefect

  Calc_BDFT_Top_DOB to CalcBDFTTopDOB

  Calc_BDFT_GrossVol to CalcBDFTGrossVol

  Calc_Form_Class to CalcFormClass

  Calc_Tree_SDI to CalcTreeSDI

  Norm_DBH to NormDBH

  Norm_BA to NormBA

  Norm_Total_Height to NormTotalHeight

  Norm_CUFT_Height to NormCUFTHeight

  Norm_CUFT_Defect to NormCUFTDefect

  Norm_CUFT_Top_DOB to NormCUFTTopDOB

  Norm_CUFT_GrossVol to NormCUFTGrossVol

  Norm_BDFT_Height to NormBDFTHeight

  Norm_BDFT_Defect to NormBDFTDefect

  Norm_BDFT_Top_DOB to NormBDFTTopDOB

  Norm_BDFT_GrossVol to NormBDFTGrossVol

  Norm_Form_Class to NormFormClass

  Norm_Tree_SDI to NormTreeSDI

  Created_Date to Created

  Updated_Date to Updated

  Retrieval_ID to RetrievalID


Description:
Deleted tblFuels_Transect_Plots table.

 Edited relationship diagram.


Description:
Renamed the following tables:





 
  tblRegnMeasurements to RegenMeasurements

  tblRegnMeasurementsProject to RegenCustomMeasurements

  tblRegnCalculations to RegenCalculations

 





 Renamed the following queries:





 
  CFIDEER_AddRegenMeasurementProject to CFIDEER_AddRegenCustomMeasurement.

 





 Deleted obsolete CFIDEER_UpdateRegenMeasurementProject query.

 Changed the following field names in RegenMeasurements:





 
  BIAProjectRegnMeasID to MeasurementID

  BIAProjectPlotID to PlotID

  Plot_Number to PlotNumber

  Minor_Plot to MinorPlot

  Species_Code to SpeciesCode

  Stem_Count to StemCount

  Per_Acre_Expansion to PerAcreExpansion

  Created_Date to Created

  Updated_Date to Updated

  Retrieval_ID to RetrievalID

 





 Changed the following field names in RegenCustomMeasurements:





 
  BIAProjectRegnMeasID to MeasurementID

 





 Deleted the following fields from RegenCustomMeasurements:





 
  BIAProjectPlotMeasID

  ProjectPeriodID

  Created_Date

  Updated_Date

  UpdUser

  Retrieval_ID

 





 Added sample CustomField to RegenCustomMeasurements

 Changed the following field names in RegenCalculations:





 
  BIAProjectRegnMeasID to CalculationID

  Calc_DBH to CalcDBH

  Calc_BA to CalcBA

  Calc_Regen_SDI to CalcRegenSDI

  Created_Date to Created

  Updated_Date to Updated

  Retrieval_ID to RetrievalID


Description:
Renamed the following tables:





 
  tblAnalysisRuns to AnalysisRuns

  tblAnalysisRunSpecifications to AnalysisRunSpecifications

  tblAnalysis_ProjectParameters to AnalysisProjectParameters

 





 Changed the following field names in AnalysisProjectParameters:





 
  TUN_Size to TUNSize

  TUN_FileName to TUNFileName

  REF_FileName to REFFileName

  CFIData_PathName to CFIDataPathName

 





 Added the following fields to AnalysisProjectParameters:





 
  ProjectPathName

  Created

  Updated

  UpdUser

  RetrievalID

 





 Added the following fields to AnalysisRuns:





 
  SeedlingMaxDBH

  SaplingMaxDBH

  PoletimberMaxDBH

  SmallSawMaxDBH

  LargeSawMaxDBH

  ReportOption

 





 Added the following fields to AnalysisRunSpecifications:





 
  ProjectPeriodID

  SpecificationNumber

  Created

  Updated

  UpdUser

  RetrievalID


Description:
Content Change:





 
  Changed the ID value of the record in AnalysisProjectParameters to the project ID value of the record in Projects.

 





 Modified the relational diagram layout.


Description:
Changed the name of the following tables:





 
  tblFuelsTransect to FuelsTransects

  tblFuelsTransect1000HrPieces to FuelsTransect1000HrPieces

 





 Added the following fields to FuelsTransects:





 
  IsDeleted

  Created

  Updated

  UpdUser

  RetrievalID

 





 Removed the following fields from FuelsTransects:





 
  Plot_Number

 





 Renamed the following fields in FuelsTransects:





 
  BIAProjectFuelTransectID to FuelTransectID

  BIAProjectPlotID to PlotID

  Transect_Number to TransectNumber

  Direction_to_Fuel_Trans to DirectionToTransect

  Distance_to_Fuel_Trans to DistanceToTransect

  Direction_of_Fuel_Trans to DirectionOfTransect

  Transect_Slope to TransectSlope

  Duff_Depth_1 to DuffDepth1

  Duff_Depth_2 to DuffDepth2

  Litter_Height_1 to LitterHeight1

  Litter_Height_2 to LitterHeight2

  Litter_Height_3 to LitterHeight3

  Fuel_Depth_1 to FuelDepth1

  Fuel_Depth_2 to FuelDepth2

  Fuel_Depth_3 to FuelDepth3

  Brush_Pct_Cover to BrushPctCover

  Brush_Species_1 to BrushSpecies1

  Brush_Height_1 to BrushHeight1

  Brush_Species_2 to BrushSpecies2

  Brush_Height_2 to BrushHeight2

  Brush_Species_3 to BrushSpecies3

  Brush_Height_3 to BrushHeight3

  Brush_Species_4 to BrushSpecies4

  Brush_Height_4 to BrushHeight4

  Brush_Species_5 to BrushSpecies5

  Brush_Height_5 to BrushHeight5

  Grass_Pct_Cover to GrassPctCover

  Grass_Species_1 to GrassSpecies1

  Grass_Height_1 to GrassHeight1

  Grass_Species_2 to GrassSpecies2

  Grass_Height_2 to GrassHeight2

  Grass_Species_3 to GrassSpecies3

  Grass_Height_3 to GrassHeight3

  Grass_Species_4 to GrassSpecies4

  Grass_Height_4 to GrassHeight4

  Grass_Species_5 to GrassSpecies5

  Grass_Height_5 to GrassHeight5

  Fuels_1_Hour_Tally to Fuels1HourTally

  Fuels_10_Hour_Tally to Fuels10HourTally

  Fuels_100_Hour_Tally to Fuels100HourTally

  Transect_Total_Tons_Acre to TransectTotalTonsAcre

  Transect_Tons_1_Hour to TransectTons1Hour

  Transect_Tons_10_Hour to TransectTons10Hour

  Transect_Tons_100_Hour to TransectTons100Hour

  Transect_Tons_1000S_Hour to TransectTons1000SHour

  Transect_Tons_1000R_Hour to TransectTons1000RHour

  Transect_Average_Litter_Depth to TransectAverageLitterDepth

  Transect_Average_Duff_Depth to TransectAverageDuffDepth

 





 Added the following fields to FuelsTransect1000Pieces:





 
  IsDeleted

  Created

  Updated

  UpdUser

  RetrievalID

 





 Renamed the following fields in FuelsTransect1000Pieces:





 
  BIAProjectFuelPieceID to FuelPieceID

  BIAProjectFuelTransectID to FuelTransectID

  Tally_Number to TallyNumber

  Species_Code to SpeciesCode

  Fuels_Soundness to FuelsSoundness

  1000_Hour_Piece_Diameter to Diameter

  1000_Hour_Tons to Tons


Description:
Created  the following queries:





 
  PRESUP_GetAnalysisProject

  PRESUP_AddAnalysisProject

  PRESUP_UpdateAnalysisProject

  PRESUP_DeleteAnalysisProject

  PRESUP_AnalysisProjectExists


Description:
Added the following tables:





 
  AnalysisProjectGenerators


Description:
Added the following queries:





 
  PRESUP_GetAnalysisProjectGenerators

  PRESUP_AddAnalysisProjectGenerator

  PRESUP_UpdateAnalysisProjectGenerator

  PRESUP_DeleteAnalysisProjectGenerator


Description:
Added the following tables:





 
  ValidationRules

  ValidationRuleTypes

 





 Added the following queries:





 
  GetSecondaryValidationRules

  GetValidationRules


Description:
Removed the SecondaryCheckValue column reference from GetValidationRules and GetSecondaryValidationRules queries as this column was deleted from the ValidationsRules table.


Description:
Removed the following tables:





 
  tblFieldErrorChecks


Description:
Added the following tables:





 
  AppTables

  AppColumns

  AppColumnDataTypes

  AppColumnCategoryTypes

  AppColumnCodes

 





 Modified the following queries to reference the above tables:





 
  GetValidationRules

  GetSecondaryValidationRules

  CFIDEER_FieldCodes

 





 Added the following queries:





 
  CFIDEER_TreeMeasurementsColumns

 





 Deleted the following tables:





 
  tblFieldName_Codes

  tblFieldName_Definitions

 





 Deleted the following queries:





 
  CFIDEER_ErrorChecks

  CFIDEER_TreeMeasurementFieldList

 





 Modified the following fields of ValidationRules:





 
  FieldName to ColumnName


Description:
Changed the name of the following tables:





 
  tblFieldReport_Headers to ReportHeaders

  tblFieldReport to ReportColumns

 





 Changed the following field names of ReportHeaders:





 
  Report_Section to ReportSection

  Report_Group to ReportGroup

  Header_Line_Number to LineNumber

 





 Changed the following field names of ReportColumns





 
  Report_Section to ReportSection

  Report_Group to ReportGroup

  Report_Index to ReportIndex

  Data_Table to DataTable

  Field_Name to FieldName

  Field_Format to FieldFormat

  Tally_Format to TallyFormat


Description:
Added the following fields to Plots table:





 
  PlotKey

 





 Added the following fields to Trees table:





 
  TreeKey


Description:
Added the following tables:





 
  ComparatorTypes

 





 Added the following queries:





 
  CFIDEER_GetProcessPlotList

  CFIDEER_GetProcessTreeList

  CFIDEER_GetProcessRegenList


Description:
Added the following queries:





 
  APPCOLUMN_GetAppColumn

  APPCOLUMN_GetAppColumns

 





 Added the following columns to AppColumns table:





 
  Active as a yes/no data type


Description:
Added the following queries:





 
  PRESUP_AddAnalysisRunSpecification

  PRESUP_GetAnalysisRunSpecification

  PRESUP_UpdateAnalysisRunSpecification

  PRESUP_DeleteAnalysisRunSpecification

  PRESUP_GetAnalysisRunSpecifications


Description:
Added the following tables:





 
  CFIFielderColumns

 





 Added the following relationships to CFIFielderColumns:





 
  AppColumns to CFIFielderColumns

 





 Added the following columns to CFIFielderColumns:





 
  ShowPastData as a boolean

 





 Added the following columns to AppColumnCodes:





 
  ShowInFDR as a boolean defaulting to true


Description:
Added the following queries:





 
  GetAppColumnCodes

 





 Replaced the following queries





 
  CFIDEER_TreeMeasurementsColumns

  APPCOLUMN_GetAppColumns

  GetValidationRules

  GetSecondaryValidationRules

 





 Added the following fields to ValidationRules:





 
  ProjectID as a foreign key

  RuleEnabled as a boolean

  ValidationNumber as a text field

  ValidationSequenceNumber as an integer

  ValidationDescription as a text field

 





 Added the following fields to ReportColumns:





 
  ColumnID as a foreign key

 





 Emptied and repopulated the following tables:





 
  AppColumns

  AppColumnCodes

  ReportColumns

  ValidationRules


Description:
Added additional records to AppColumns from Kalispel


Description:
Renamed the following columns in AnaysisRunSpecifications:





 
  FieldNameID to ColumnID

 





 Renamed the following parameters in PRESUP_UpdateAnalysisRun:





 
  FieldNameID to ColumnID

 





 Renamed the following parameters in PRESUP_AddAnalysisRunSpecification:





 
  FieldNameID to ColumnID


Description:
Modified AnalysisProjectGenerators table





 
  Changed the datatype of ID field from Long Integer to ReplicationID

 





 Modified PRESUP_DeleteAnalysisProjectGenerator





 
  Changed the datatype of the ID parameter to ReplicationID

 





 Modified PRESUP_UpdateAnalysisProjectGenerator





 
  Changed the datatype of the ID parameter to ReplicationID

 





 Modified PRESUP_AddAnalysisProjectGenerator





 
  Added ID field

  Added ID parameter


Description:
Renamed the following tables:





 
  tlkpFVS_InitData to FVSInitializationData

  tlkpSpecies_RegressionsCriteria to SpeciesRegressionCriteria

 





 Added the following fields to FVSInitializationData table:





 
  ColumnID as foreign key to AppColumns table

 





 Added the following fields to SpeciesRegressionCriteria table:





 
  ColumnID as foreign key to AppColumns table

 





 Removed the following fields from FVSInitializationData table:





 
  CFI_TableName

  CFI_FieldName

 





 Removed the following fields from SpeciesRegressionCriteria table:





 
  CheckTableName

  CheckFieldName

 





 Changed the name of the following fields in FVSInitializationData table:





 
  Field_Number to FieldNumber

  FVS_TableName to FVSTableName

  FVS_FieldName to FVSFieldName

  FVS_Field_Data_Type to FVSFieldDataType

  FVS_Value to FVSValue

  Measurement_Number to MeasurementNumber

  FVS_Lookup_Table to FVSLookupTable

 





  Changed name of the following fields in SpeciesRegressionCriteria table:





 
  Species_Code to SpeciesCode

  Data_Item to DataItem

  Record_Number to RecordNumber


Description:
Removed the following tables:





 
  tblAnalysis_RunData

  tblAnalysis_Criteria

  tblAnalysis_RunPlotList

  tlkpFDR_Fields

  tblFieldName_CFIFielder

  tlkpTable_Name


Description:
Added the following querys:





 
  CFIDEER_GetSpecies

 





 Changed the name of the following tables:





 
  tlkpSpecies_Codes to Species

 





 Changed the name of the following columns in Species table:





 
  Species_Code to SpeciesCode

  Species_Name to SpeciesName

  Coop_Species_Code to CoopSpeciesCode


Description:
Added the following queries:





 
  CFIDEER_GetMerchStandards

 





 Renamed the following tables:





 
  tlkpSpecies_Merch_Standards to SpeciesMerchantabilityStandards

 





 Renamed the following columns in SpeciesMerchantabilityStandards table:





 
  Species_Code to SpeciesCode

  BIAProjectID to ProjectID

  Woodland_Key to WoodlandKey

  CFI_Index to CFIIndex

  CUFT_Top_DOB to CUFTTopDOB

  BDFT_Top_DOB to BDFTTopDOB

  DBH_Frequency_Min to DBHFrequencyMin

  DBH_BasalArea_Min to DBHBasalAreaMin

  CUFT_Min_DBH to CUFTMinDBH

  BDFT_Min_DBH to BDFTMinDBH

  Log_Length to LogLength

  Volume_Equation to VolumeEquation

  Scale_Rule to ScaleRule

  Taper_Coop to TaperCoop

  Taper_Coop_Subregion to TaperCoopSubregion

  Site_Index_Equation to SiteIndexEquation

  Form_Class_Equation to FormClassEquation

  Total_Height_Equation to TotalHeightEquation

  CUFT_Height_Equation to CUFTHeightEquation

  BDFT_Height_Equation to BDFTHeightEquation


Description:
Added data record to ValidationRuleTypes table





 
  Added Increasing Trend validation rule type record.

 





 Added the following fields to ValidationRules table:





 
  ApplicablePeriods as type Text.

 





 Added the following fields to GetValidationRules query:





 
  ApplicablePeriods

 





 Added the following fields to GetSecondaryValidationRules query:





 
  ApplicablePeriods


Description:
Added the following fields to GetValidationRules query:





 
  ValidationNumber

  ValidationSequenceNumber

 





 Added the following fields to GetSecondaryValidationRules query:





 
  ValidationNumber

  ValidationSequenceNumber

 





 Added data record to ValidationRuleTypes table





 
  Added Past Value List validation rule type record


Description:
Changed the name of the following tables:





 
  tlkpSpecies_Regressions to SpeciesRegressions

 





 Changed the name of the following fields of SpeciesRegressions table:





 
  BIAProjectID to ProjectID

  Species_Code to SpeciesCode

  Data_Item to DataItem

  Eqn_Description to EqnDescription

  Regression_CoeffA to CoefficientA

  Regression_CoeffB to CoefficientB

  Regression_CoeffC to CoefficientC

  Regression_CoeffD to CoefficientD

  Default_Value to DefaultValue


Description:
Added the following fields to SpeciesRegressions table:





 
  Comments as Text(255)


Description:
Added the following queries:





 
  GetValidationRulesList


Description:
Added the following queries:





 
  BO_GetValidationRules

  BO_GetSecondaryValidationRules


Description:
Deleted all records from ValidationRules table.


Description:
Removed unnecessary fields from BO_GetSecondaryValidationRules query.


Description:
Added new sample validation rule records to ValidationRules table.


Description:
Deleted and replaced all records in AppColumns with the current recordset.


Description:
Removed the following indexes from AppColumns table





 
  FiledNameID


Description:
Deleted the following fields from PlotCustomMeasurements table:





 
  CustomField

 





 Deleted the following indexes from PlotCustomMeasurements table:





 
  BIAProjectPlotMeasD1

 





 Deleted following fields from CFIDEER_GetPlotMeasurementsForPeriod query:





 
  CustomField

 





 Deleted unnecessary fields from CFIDEER_GetProcessPlotList

 Deleted unnecessary field from CFIDEER_UpdatePlotMeasurement


Description:
Deleted unnecessary fields from CFIDEER_GetProcessTreeList

 Deleted unnecessary field from CFIDEER_UpdateTreeMeasurement

 Deleted the following indexes from TreeCustomMeasurements table:





 
  BIAProjectTreeMeasD1

 





 Deleted following fields from CFIDEER_GetTreeMeasurementsForPeriod query:





 
  CustomField


Description:
Deleted unnecessary fields from CFIDEER_GetProcessRegenList

 Deleted unnecessary field from CFIDEER_UpdateRegenMeasurement

 Deleted the following indexes from RegenCustomMeasurements table:





 
  BIAProjectRegnMeasID1

 





 Deleted following fields from CFIDEER_GetTreeMeasurements query:





 
  
      CustomField


Description:
Updated miscellaneous sample data content


Description:
Renamed the following table:





 
  tlkpSpecies_NationalVolumeParms to SpeciesNationalVolumeParms


Description:
Added the following fields to the following tables:





 
  PlotKey to PlotMeasurements

  PlotMeasKey to PlotMeasurements

  PlotMeasKey to PlotCustomMeasurements

  PlotMeasKey  to PlotSummaries

  PlotKey to Trees

  TreeKey to TreeMeasurements

  TreeMeasKey to TreeMeasurements

  TreeMeasKey to TreeCustomMeasurements

  TreeMeasKey to TreeCalculations

  PlotKey to RegenMeasurements

  RegenMeasKey to RegenMeasurements

  RegenMeasKey to RegenCustomMeasurements

 





 Modified relationships of the following queries to use new key fields:





 
  CFIDEER_GetProcessPlotList

  CFIDEER_GetProcessTreeList

  CFIDEER_GetProcessRegenList


Description:
Added the following fields to BO_GetValidationRules query:





 
  TableName

 





 Added the following fields to BO_GetSecondaryValidationRules query:





 
  TableName


Description:
Added the following queries:





 
  BO_UpdateAppColumns

 





 Added the following fields to APPCOLUMN_GetAppColumn:





 
  Active

 





 Added the following fields to APPCOLUMN_GetAppColumns:





 
  Active


Description:
Added TreeCalculations table to CFIDEER_GetProcessTreeList query.

 Added calculations fields to CFIDEER_GetProcessTreeList query.

 Changed plot type code 1  from 'Fixed Radius' to 'Fixed Plot'.


Description:
Added TreeMeasKey to CFIDEER_GetProcessTreeList query.

 Made the following modifications to CFIDEER_UpdateTreeCalculation:





 
  Added the normalization fields.

  Set TreeMeasKey as the relational link between TreeMeasurements and TreeCalculations tables.

  Renamed the calculation field parameters to the calculation field names.

  Added parameters for the normalization fields.

  Removed the unnecessary parameter entries.

  Set TreeMeasKey as the lookup key for the query.

 





 Made the following modifications to CFIDEER_AddTreeCalculation:





 
  Removed Updated field.

  Removed UpdUser field.

  Added TreeMeasKey field.

  Removed unneccessary parameters.

  Added parameter for TreeMeasKey.


Description:
Added the following fields to CFIDEER_GetPlot:





 
  PlotKey

 





 Added the following fields to  CFIDEER_GetTree:





 
  TreeKey


Description:
Renamed the following field in ProjectMeasurementPeriods:





 
  updUser to UpdUser

 





 Added ascending sort to 'PeriodYear' field of CFIDEER_GetPlotRegen

 Removed subdatasheet reference from Plots table properties

 Removed the extra index for PlotID field in Plots table


Description:
Added the following field to CFIDEER_GetProcessPlotList:





 
  PlotMeasKey


Description:
Added the following query:





 
  CFIDEER_GetPlotProcessTrees


Description:
Deleted the following field from TreeMeasurements:





 
  PerAcreExpansion

 





 Added the following field to TreeCalculations:





 
  PerAcreExpansion as Single

 





 Modified the following field in CFIDEER_GetProcessTreeList:





 
  PerAcreExpansion of TreeMeasurements to PerAcreExpansion of TreeCalculations

 





 Added the following field to CFIDEER_GetTreeCalculationsForPeriod:





 
  PerAcreExpansion

 





 Deleted the following field from CFIDEER_GetTreeMeasurementsForPeriod:





 
  PerAcreExpansion

 





 Added the following field to CFIDEER_UpdateTreeCalculation:





 
  PerAcreExpansion

 





 Deleted the following field from CFIDEER_UpdateTreeMeasurement:





 
  PerAcreExpansion


Description:
Deleted the following field from RegenMeasurements:





 
  PerAcreExpansion

 





 Added the following fields to RegenCalculations:





 
  PerAcreExpansion as Single

  RegenMeasKey as Text

 





 Added the PerAcreExpansion field to the following queries:





 
   CFIDEER_GetRegenCalculations

  CFIDEER_UpdateRegenCalculation

 





 Deleted the PerAcreExpansion field from the following queries:





 
  CFIDEER_GetProcessRegenList

  CFIDEER_GetRegenMeasurements

  CFIDEER_UpdateRegenMeasurement

 





 Added the RegenMeasKey field to the following queries:





 
  CFIDEER_AddRegenCalculation

  CFIDEER_GetProcessRegenList


Description:
Deleted the following table:





 
  zstblProcessingStepStatus

 





 Renamed the following table:





 
  tlkpPerAcreExpansions to PerAcreExpansions


Description:
Renamed the following queries:





 
  CFIDEER_GetProcessPlotList to _prjCFIDEER_GetProcessPlotList

  CFIDEER_GetPlotMeasurementsForPeriod to _prjCFIDEER_GetPlotMeasurementsForPeriod

  CFIDEER_UpdatePlotMeasurement to _prjCFIDEER_UpdatePlotMeasurement

  CFIDEER_GetProcessTreeList to _prjCFIDEER_GetProcessTreeList

  CFIDEER_GetTreeMeasurementsForPeriod to _prjCFIDEER_GetTreeMeasurementsForPeriod

  CFIDEER_UpdateTreeMeasurement to _prjCFIDEER_UpdateTreeMeasurement

  CFIDEER_GetProcessRegenList to _prjCFIDEER_GetProcessRegenList

  CFIDEER_GetRegenMeasurements to _prjCFIDEER_GetRegenMeasurements

  CFIDEER_UpdateRegenMeasurement to _prjCFIDEER_UpdateRegenMeasurement


Description:
Delete the following fields from _prjCFIDEER_GetTreeMeasurementsForPeriod





 
  PeriodNumber

 





 Added the following fields to _prjCFIDEER_GetTreeMeasurementsForPeriod





 
  DMRating


Description:
Added the calculation fields to _prjCFIDEER_GetProcessRegenList query.


Description:
Modified the following fields in PlotSummaries table:





 
  SummaryID from Long Integer to Replication ID

 





 Added the following fields to PlotSummaries table:





 
  PlotSDI


Description:
Renamed the following fields in SpeciesMerchantabilityStandards:





 
  DBHFrequencyMin to FrequencyMinDBH

  DBHBasalAreaMin to BasalAreaMinDBH


Description:
Added the following queries:

 
  Region:

 





 
  
   DeleteRegion

   GetRegion

   UpdateRegion

   AddRegion

   RegionExists

  

 





 
  Agency:

 





 
  
   DeleteAgency

   GetAgency

   UpdateAgency

   AddAgency

   AgencyExists

  

 





 
  Reservation:

 





 
  
   DeleteReservation

   GetReservation

   UpdateReservation

   AddReservation

   ReservationExists


Description:
Added the following queries:





 
  BO_DeleteValidationRule

  BO_UpdateValidationRules

  BO_AddValidationRules


Description:
Made the following modifications to BO_GetValidationRules query:





 
  Changed the criteria for ParentRuleID column from 'Is Null' to '{guid {00000000-0000-0000-0000-000000000000}}'


Description:
Made the following changes to PlotSummaries table:





 
  Changed field PlotSDI fieldname to ReinekeSDI

  Added SummationSDI field of type Single


Description:
Made the following modifications to GetValidationRules query:





 
  Changed the criteria for ParentRuleID column from 'Is Null' to '{guid {00000000-0000-0000-0000-000000000000}}'


Description:
Added the following fields to AnalysisRuns table:





 
  Added ReportBySpecies boolean field.

  Added IsFVSGrouping boolean field.


Description:
Made the following modifications to PerAcreExpansions





 
  Changed Minor_Plot to MinorPlot

  Changed Per_Acre_Expansion to PerAcreExpansion


Description:
Renamed tlkpDBH_Class_Limits to DBHClassLimits

 Made the following modifications to DBHClassLimits





 
  Renamed Seedling Limit to SeedlingLimit

  Renamed Sapling Limit to SaplingLimit

  Renamed Pole Limit to PoleLimit

  Renamed Small Sawlog Limit to SmallSawlogLimit

  Renamed Large Sawlog Limit to LargeSawlowLimit


Description:
Renamed tlkpSiteIndexEquationLookup to SiteIndexEquations

 Made the following modifications to SiteIndexEquations table





 
  Renamed SI_Equation to SIEquation

  Renamed Equation_Description to EquationDescription

  Renamed Equation_Reference to EquationReference


Description:
Renamed tlkpVolumeEquationLookup to VolumeEquations

 Made the following modifications to VolumeEquations table





 
  Renamed Volume_Equation to VolumeEquation

  Renamed Equation_Description to EquationDescription

  Renamed Equation_Reference to EquationReference


Description:
Made the following modifications to _prjCFIDEER_GetProcessPlotList query





 
  Moved PlotMeasKey to right of PeriodNumber


Description:
Made the following modifications to _prjCFIDEER_GetRegenMeasurements query





 
  Removed ProjectMeasurementPeriods table


Description:
Made the following modifications to CFIDEER_GetRegenCalculations query





 
  Removed the ProjectMeasurementPeriods table


Description:
Made the following modifications to CFIDEER_GetPlotNumberList query





 
  Removed the PlotMeasurements table

  Removed the PeriodID parameter


Description:
Added the following table:





 
  FVS_GroupAddFilesAndKeywords


Description:
Added the following queries:





 
  _dbMakePlotKey

  _dbMakePlotMeasKey

  _dbMakePlotCustomKey

  _dbMakePlotSummaryKey

  _dbMakeTreeKey

  _dbMakeTreeMeasKey

  _dbMakeTreeCustomKey

  _dbMakeRegenKey

  _dbMakeRegenCustomKey


Description:
Added the following query:





 
  _dbMakeTreeCalculationKey

 





 Renamed _dbMakeTreeCustomKey query to _dbMakeTreeCustomMeasKey

 Made the following modifications to _dbMakeTreeCustomMeasKey query:





 
   Replaced TreeCalculations table with TreeCustomMeasurements table


Description:
Made the following changes to FVSInitializationData table:





 
  Deleted all records

  Added 123 new records


Description:
Made following modifications to _prjCFIDEER_GetProcessRegenList query:





 
  Removed RegenMeasKey table relationships from RegenMeasurements table to RegenCustomMeasurements and RegenCalculations tables

  Added relationship from RegenMeasurements.MeasurementID to RegenCustomMeasurements.MeasurementID

  Added relationship from RegenMeasurements.MeasurementID to RegenCalculations.CalculationID.


Description:
Made following modifications to _prjCFIDEER_GetProcessRegenList query:





 
  Changed join properties to All RegenMeasurements and only equal RegenCustomMeasurements and RegenCalculations.


Description:
Made following modifications to CFIDEER_UpdatePlot:





 
  Added PlotKey as text

 





 Made following modifications to CFIDEER_AddPlot:





 
  Added PlotKey as text


Description:
Made following modifications to _prjCFIDEER_UpdatePlotMeasurement:





 
  Added PlotMeasKey as text

  Added PlotKey as text

 





 Made following modifications to CFIDEER_AddPlotMeasurement:





 
  Added PlotMeasKey as text

  Added PlotKey as text


Description:
Made following modifications to CFIDEER_AddPlotCustomMeasurement:





 
  Added PlotMeasKey as text

 





 Made following modifications to _prjCFIDEER_UpdatePlotMeasurement:





 
  Added PlotCustomMeasurements.PlotMeasKey


Description:
Made following modifications to CFIDEER_GetTree:





 
  Added PlotKey to data set

  Removed ascending sort from PlotNumber

  Removed ascending sort from TreeNumber


Description:
Made following modifications to CFIDEER_AddTree





 
  Added PlotKey as text

  Added TreeKey as text

 





 Made following modifications to CFIDEER_UpdateTree





 
  Added PlotKey as text

  Added TreeKey as text


Description:
Made following modifications to CFIDEER_AddTreeMeasurement





 
  Added TreeMeasKey as text

  Added TreeKey as text

 





 Made following modifications to _prjCFIDEER_UpdateTreeMeasurement





 
  Added TreeMeasKey as text

  Added TreeKey as text


Description:
Made following modifications to CFIDEER_AddTreeCustomMeasurement





 
  Added TreeMeasKey as text

 





 Made following modifications to _prjCFIDEER_UpdateTreeMeasurement





 
  Added TreeCustomMeasurements.TreeMeasKey


Description:
Made following modifications to CFIDEER_GetRegen:





 
  Added PlotKey to dataset


Description:
Made following modifications to CFIDEER_AddRegenMeasurement:





 
  Added PlotKey as text

 





 Made following modifications to _prjCFIDEER_UpdateRegenMeasurement:





 
  Added PlotKey as text


Description:
Added the following table:





 
  FVSDamageCodes

 





 Deleted the following table:





 
  tlkpFVSDamageCodes


Description:
Renamed the 'Make' queries with numbered names to indicate execution sequence.

 Added the following queries:





 
  _GetTreeMeasurementsForPeriodById

  _GetTreeMeasurementsForPeriodByKey

  CFIDEER_UpdateTreeById

  CFIDEER_UpdateTreeByKey

  _prjCFIDEER_UpdateTreeMeasurementById

  _prjCFIDEER_UpdateTreeMeasurementByKey

  CFIDEER_GetTreeById

   CFIDEER_GetTreeByKey

 





 Renamed the following queries:





 
  tlkpSI_Alexander to SiteIndex-Alexander

  tlkpSI_Meyer to SiteIndex-Meyer

  tlkpSI_NC128 to SiteIndex-NC128

  tlkpHannBareVolumeCoefficients to VolumeHannBareCoefficients


Description:
Made the following modifications to SiteIndex-Alexander:





 
  Renamed Age_Class to AgeClass

  Renamed Height_Row to HeightRow

  Renamed Site_Index to SiteIndex

 





 Made the following modifications to SiteIndex-Meyer:





 
  Renamed Age_Class to AgeClass

  Renamed AA_Coef to AACoef

  Renamed BB_Coef to BBCoef

  Renamed CC_Coef to CCCoef

  Renamed DD_Coef to DDCoef

 





 Made the following modifications to SiteIndex-NC128:





 
  Renamed Species_Code to SpeciesCode

  Renamed Eqn_Description to EqnDescription

  Renamed Regression_CoeffA to RegressionCoeffA

  Renamed Regression_CoeffB to RegressionCoeffB

  Renamed Regression_CoeffC to RegressionCoeffC

  Renamed Regression_CoeffD to RegressionCoeffD

  Renamed Regression_CoeffE to RegressionCoeffE


Description:
Updated the data of AppColumnCodes

 Updated the data of AppColumns


Description:
Updated the data of AppTables

 Updated the data of SiteIndex-Alexander

 Updated the data of SiteIndex-Meyer

 Updated the data of VolumeEquations


Description:
Added FVSCrossWalk table

 Added LANDFIREXWalk table

 Added CFIDEER_Rpt_ReportColumns query

 Added CFIDEER_Rpt_ValidationRulesQuery query

 Added CFIDEER_Rpt_ValidationRulesQuery-Parents query

 Added ListFVSInitialization query

 Added ListLANDFIREColumns query

 Added ListLANDFIREColumns report

 Added ValidationRules report


Description:
Added ReportSourceLastMeasurement select query

 Added ReportSourceLastThreeMeasurements select query


Description:
Added CFIDEER_GetTreeCalculationsForPeriodById select query

 
     Added CFIDEER_GetTreeCalculationsForPeriodByKey select query


Description:
Added following fields to SpeciesNationalVolumeParms





 
   MerchantabilityRulesCorrectionFactor as Short Text 

 








a) Set Default to 'Y'









 
  MerchantabilityRulesEvenOdd as Long Integer

  MerchantabilityRulesOptionalVariable as Long Integer

  MerchantabilityRulesMaximumLength as Long Integer

  MerchantabilityRulesMinimumLength as Long Integer

  MerchantabilityRulesMerchantableLength as Long Integer

  MerchantabilityRulesMinimumTopDiaInsideBarkPrimary as Long Integer

  MerchantabilityRulesMinimumTopDiaInsideBarkSecondary as Long Integer

  MerchantabilityRulesStumpHeight as Long Integer

  MerchantabilityRulesTrimAllowance as Long Integer

  MerchantabilityRulesMinimumDBHtoCalcBoardFoot as Long Integer

  MerchantabilityRulesDoubleBarkThicknessBreastHeight as Long Integer

  MerchantabilityRulesMinimumLengthReqForTopwood as Long Integer

  MerchantabilityRulesBarkThicknessRatio as Long Integer


Description:
Made changes to SpeciesNationalVolumeParms





 
  Set default value for Species_Code field to 0

  Set default value for Parm_Description to "<Species Name>"

  Changed data type of Region to Integer from Short Text

  Set default value for Region field to 0

  Set default value for Forest to "00"

  Set default value for Volume_Equation to "Equation Name"

  Set default value for Merch_DBH_Primary to 0

  Set default value for Merch_DBH_Secondary to 0

  Added TotalTreeHeight as Data Type Single

  Set default value for TotalTreeHeight to 0

  Set default value for Height_Min_TopDOB_Primary to 0

  Set default value for Height_Min_TopDOB_Secondary to 0

   Set default value for Height_Type to "F"

  Added field Height_Log_Length as Data Type Integer

  Set default value for Height_Log_Length to 16

  Set default value for Upper_Stem_Height1 to 0

  Set default value for Upper_Stem_Height2 to 0

  Set default value for Upper_Stem_Diameter1 to 0

  Set default value for Upper_Stem_Diameter2 to 0

  Changed Reference_height Data Type from Single to Integer

  Set default value for Reference_height to 0

  Set default value for Flewelling_AVGZ1 to 0

  Set default value for Flewelling_AVGZ2 to 0

  Changed Girard_Form_Class Data Type from Single to Integer

  Set default value for Girard_Form_Class to 0

  Set default value for DBT_DBH to 0

  Set default value for DBT_Ratio to 0

  Set default value for Contract_Species to "0000"

  Changed Height_First_Live_Limb Type from Single to Integer

  Set default value for Height_First_Live_Limb to 0

  Changed Merch_Top_Primary Data Type from Integer to Single

  Set default value for Merch_Top_Primary to 0

  Set default value for Merch_Top_Secondary to 0

  Set default value for Stump_Height to 0

  Set default value for Total_CUFT_Volume_Flag to 1

  Set default value for Board_Foot_Volume_Flag to 1

  Set default value for Merch_CUFT_Volume_Flag to 1

  Set default value for Cordwood_Volume_Flag to 0

  Set default value for Merch_CUFT_Secondary_Flag to 0

  Set default value for Cordwood_Secondary_Flag to 0

  Set default value for Secondary_Product_Flag to 0

  Deleted field Total_Logs

  Deleted field Number_16ft_Logs_Primary

  Deleted field Number_16ft_Logs_Secondary

  Set default value for PROD to "01"

   Set default value for Live_Flag to "L"

  Changed Basal_Area_Acre Type from Single to Integer

  Set default value for Basal_Area_Acre to 0

   Set default value for Site_Index to 0

  Set default value for sCTYPE to "F"

   Deleted field CTYPE_LEN


Description:
Made changes to SpeciesRegressions





 
  Changed DefaultValue fieldsize from Double to Single

 





 Made changes to SpeciesNationalVolumeParms





 
  Changed Species_Code to SpeciesCode

  Changed Parm_Description to ParmDescription (not selected)

  Changed Volume_Equation to VolumeEquation

  Changed Merch_DBH_Primary to MerchDBHPrimary

  Changed Merch_DBH_Secondary to MerchDBHSecondary

  Changed Height_Min_TopDOB_Primary to HeightMinTopDOBPrimary

  Changed Height_Min_TopDOB_Secondary to HeightMinTopDOBSecondary

  Changed Height_Type to HeightType

  Changed Height_Log_Length to HeightLogLength (not selected)

  Changed Upper_Stem_Height1 to UpperStemHeight1

  Changed Upper_Stem_Height2 to UpperStemHeight2

  Changed Upper_Stem_Diameter1 to UpperStemDiameter1

  Changed Upper_Stem_Diameter2 to UpperStemDiameter2

  Changed Reference_height to ReferenceHeight (also in code)

  Changed Flewelling_AVGZ1 to FlewellingAVGZ1

  Changed Flewelling_AVGZ2 to FlewellingAVGZ2

  Changed Girard_Form_Class to GirardFormClass

  Changed DBT_DBH to DBTDBH

  Changed DBT_Ratio to DBTRatio

  Changed Contract_Species to ContractSpecies

  Changed Height_First_Live_Limb to HeightFirstLiveLimb

  Changed Merch_Top_Primary to MerchTopPrimary

  Changed Merch_Top_Secondary to MerchTopSecondary

  Changed Stump_Height to StumpHeight

  Changed Total_CUFT_Volume_Flag to TotalCUFTVolumeFlag

  Changed Board_Foot_Volume_Flag to BoardFootVolumeFlag

  Changed Board_Foot_Volume_Flag to BoardFootVolumeFlag

  Changed Cordwood_Volume_Flag to CordwoodVolumeFlag

  Changed Merch_CUFT_Secondary_Flag to MerchCUFTSecondaryFlag

  Changed Cordwood_Secondary_Flag to CordwoodSecondaryFlag

  Changed Secondary_Product_Flag to SecondaryProductFlag

  Changed Live_Flag to LiveFlag

  Changed Basal_Area_Acre to BasalAreaAcre

  Changed Site_Index to SiteIndex

  Changed sCTYPE to CruiseType (also in code)


Description:
Made schema changes to TreeCalculations table





 
  Added CalcCuFtTotalVol as Single datatype 2 decimals

  Added CalcGrnBioAboveGroundTotLB as Single datatype 2 decimals

  Added CalcGrnBioMerchStemWoodLB as Single datatype 2 decimals

  Added CalcGrnBioMerchStemBarkLB as Single datatype 2 decimals

  Added CalcGrnBioFoliageLB as Single datatype 2 decimals

  Added CalcGrnBioRootsLB as Single datatype 2 decimals

  Added CalcGrnBioBranchesLB as Single datatype 2 decimals

  Added CalcGrnBioCrownLB as Single datatype 2 decimals

  Added CalcGrnBioMerchStemWoodBarkLB as Single datatype 2 decimals


Description:
Made schema changes to TreeCalculations table





 
  Re-ordered CalcCuFtTotalVol(array 1), CalcBDFTGrossVol(array 2), CalcCUFTGrossVol(array 4) (would Like to rename this field to CalcCUFTGrossMerchVol)

  Added CalcBDFTNetVol as Single datatype 2 decimals (array 3)

  Added CalcCUFTNetMerchVol as Single datatype 2 decimals

  Added CalcMerchCordwoodVol as Single datatype 2 decimals

  Added CalcCUFTGrossSecondMerchVol as Single datatype 2 decimals

  Added CalcCUFTNetSecondMerchVol as Single datatype 2 decimals    

  Added CalcSecondCordwoodVol as Single datatype 2 decimals        

  Added CalcGrossInterNatQtrBDFTVol as Single datatype 2 decimals  

  Added CalcNetInterNatQtrBDFTVol as Single datatype 2 decimals

  Added CalcGrossSecondBDFTVol as Single datatype 2 decimals       

  Added CalcNetSecondBDFTVol as Single datatype 2 decimals

  Added CalcTStumpVol as Single datatype 2 decimals

  Added CalcTipVol as Single datatype 2 decimals


Description:
modify treeCalculations table





 
    change field Calc StumpVol to CalcStumpVol

 





 modify CFIDEER_UpdateTreeCalculation query





 
    add CalcBDFTNetVol

    add CalcCUFTNetMerchVol

    add CalcMerchCordwoodVol

    add CalcCUFTGrossSecondMerchVol

    add CalcCUFTNetSecondMerchVol

    add CalcSecondCordwoodVol

    add CalcGrossInterNatQtrBDFTVol

    add CalcNetInterNatQtrBDFTVol

    add CalcGrossSecondBDFTVol

    add CalcNetSecondBDFTVol

    add CalcStumpVol

    add CalcTipVol  

    add CalcGrnBioAboveGroundTotLB

    add CalcGrnBioMerchStemWoodLB

    add CalcGrnBioMerchStemBarkLB

    add CalcGrnBioFoliageLB

    add CalcGrnBioRootsLB

    add CalcGrnBioBranchesLB

    add CalcGrnBioCrownLB

    add CalcGrnBioMerchStemWoodBarkLB


Description:
modify  _prj CFIDEER_GetProcessTreeList  query





 
  reorder CalcCUFTGrossVol behind CalcBDFTGrossVol


Description:
modify _prj CFIDEER_GetProcessTreeList query





 
     add CalcCuFtTotalVol

     add CalcBDFTNetVol

     add CalcCUFTNetMerchVol

     add CalcMerchCordwoodVol

     add CalcCUFTGrossSecondMerchVol

     add CalcCUFTNetSecondMerchVol

     add CalcSecondCordwoodVol

     add CalcGrossInterNatQtrBDFTVol

     add CalcNetInterNatQtrBDFTVol

     add CalcGrossSecondBDFTVol

     add CalcNetSecondBDFTVol

     add CalcStumpVol

     add CalcTipVol  

     add CalcGrnBioAboveGroundTotLB

     add CalcGrnBioMerchStemWoodLB

     add CalcGrnBioMerchStemBarkLB

     add CalcGrnBioFoliageLB

     add CalcGrnBioRootsLB

     add CalcGrnBioBranchesLB

     add CalcGrnBioCrownLB

     add CalcGrnBioMerchStemWoodBarkLB


Description:
modify _prj CFIDEER_GetProcessTreeList query





 
   reordered the following fields in the select to reflect sequential structure order

 





 
  
      CalcCuFtTotalVol

      CalcBDFTNetVol

      CalcCUFTNetMerchVol

      CalcMerchCordwoodVol

      CalcCUFTGrossSecondMerchVol

      CalcCUFTNetSecondMerchVol

      CalcSecondCordwoodVol

      CalcGrossInterNatQtrBDFTVol

      CalcNetInterNatQtrBDFTVol

      CalcGrossSecondBDFTVol

      CalcNetSecondBDFTVol

      CalcStumpVol

      CalcTipVol  

      CalcGrnBioAboveGroundTotLB

      CalcGrnBioMerchStemWoodLB

      CalcGrnBioMerchStemBarkLB

      CalcGrnBioFoliageLB

      CalcGrnBioRootsLB

      CalcGrnBioBranchesLB

      CalcGrnBioCrownLB

      CalcGrnBioMerchStemWoodBarkLB


Description:
modify CFIDEER_UpdateTreeCalculation query





 
     reordered the following fields in the Update clause to reflect sequential structure order

 





 
  
      CalcCuFtTotalVol

      CalcBDFTNetVol

      CalcCUFTNetMerchVol

      CalcMerchCordwoodVol

      CalcCUFTGrossSecondMerchVol

      CalcCUFTNetSecondMerchVol

      CalcSecondCordwoodVol

      CalcGrossInterNatQtrBDFTVol

      CalcNetInterNatQtrBDFTVol

      CalcGrossSecondBDFTVol

      CalcNetSecondBDFTVol

      CalcStumpVol

      CalcTipVol  

      CalcGrnBioAboveGroundTotLB

      CalcGrnBioMerchStemWoodLB

      CalcGrnBioMerchStemBarkLB

      CalcGrnBioFoliageLB

      CalcGrnBioRootsLB

      CalcGrnBioBranchesLB

      CalcGrnBioCrownLB

      CalcGrnBioMerchStemWoodBarkLB


Description:
Modified Schema of SpeciesNationalVolumeParms table





 
  Recreated ReferenceHeight field (Integer) as fieldname was displaying as '0' as noticed by Dave Stitt

 





 Added three default records to SpeciesNationalVolumeParms table





 
  Western Larch

  Ponderosa Pine

  Loblolly Pine


Description:
Modified TreeCalculations table





 
  added units to description of Stump and Tip volume for consistency


Description:
AppColumnCodes Table edited





 
  Record {92BA6EF8-8D7A-4D80-AD9F-4C1E3379AAF4} deleted as it was causing an error within the BOFRP Shell application when the default Test CFI database was selected as it had a duplicate Code = 10 record for Tree Class


Description:
AppColumns table edited





 
  TreeClass records checked as 'Active' for both TreeMeasurements and RegenCustomMeasurements tables per Dave Stitt & Stacie Holmes


Description:
AppColumns table edited





 
  TreeClass record for RegenCustomMeasurements un-checked as 'Active' (Should only be active for TreeMeasurements)


Description:
modified  _prjCFIDEER_GetTreeMeasurementsForPeriodByKey       





 
   removed TreeHistory, TreeStatus, Problem3, Severity3, Vigor, DMRating

 





 modified _prjCFIDEER_GetTreeMeasurementsForPeriodById





 
   removed TreeHistory, TreeStatus, Problem3, Severity3, Vigor, DMRating

 





 modified _prjCFIDEER_GetTreeMeasurementsForPeriod  





 
   changed TreeHistory to TreeClass

 





  modified _prjCFIDEER_UpdateTreeMeasurment      





 
   removed Problem3, Severity3, Vigor, DMRating,

   removed TreeHistory, TreeStatus from parameters

 





 modified _prjCFIDEER_UpdateTreeMeasurmentById





 
   removed TreeHistory, TreeStatus from parameters

 





 modified _prjCFIDEER_UpdateTreeMeasurmentByKey





 
   changed TreeHistory to TreeClass

   removed crownClass & snagStage from parameters

 





 modified CFIDEER_UpdateTreeCalculation





 
   added all new fields to parameters


Description:
Modified Schema of SpeciesNationalVolumeParms





 
  Renamed MerchantabilityRulesMinimumLength as MerchantabilityRulesMinimumLengthCuFt

  Renamed MerchantabilityRulesMerchantableLength as MerchantabilityRulesMerchantableLengthCuFt

  Added field MerchantabilityRulesMinimumLengthBdFt

  Added field MerchantabilityRulesMerchantableLengthBdFt


Description:
Deleted the Following tables 





 
  FuelsTransect      

  FuelsTransect1000HrPieces

  DBHClassLimits table

  LANDFIREXWalk


Description:
PlotMeasurements





 
   Added 2 additional measurements : 10/25/1910 & 10/25/1920

 





 PlotCustomMeasurements





 
  Schema change -added YuccaBananaCount as Number

  inserted Field Descriptions

  Added two records with corresponding PlotMeasKey

 





 Altered corresponding Get/Update queries





 
  _prjCFIDEER_GetPlotMeasurementsForPeriod

  _prjCFIDEER_GetProcessPlotList

  _prjCFIDEER_UpdatePlotMeasurement


Description:
TreeCustomMeasurements Schema change





 
    added CUFTDefect as Number (integer)

    added CrownRatioPercent as Number (integer)

    added CrownClass as Number (integer)

 





 TreeCustomMeasurements - added Field Descriptions  





 
  "Required Field Do Not Delete"                       

  "Optional Field Replace Per Project Requirements"

 





 TreeCustomMeasurements





 
  Added two additional measurements with appropriate TreeMeasKey

 





 TreeMeasurements





 
  Data added to 3 periods for one tree

 





 Altered Get/Update queries 





 
   _prjCFIDEER_GetProcessTreeList

   _prjCFIDEER_GetTreeMeasurementsForPeriodByKey

   _prjCFIDEER_UpdateTreeMeasurement

 





 Deleted the following unused queries





 
  _prjCFIDEER_UpdateTreeMeasurementById       

  _prjCFIDEER_UpdateTreeMeasurementByKey      

  _prjCFIDEER_GetTreeMeasurementsForPeriod    

  _prjCFIDEER_GetTreeMeasurementsForPeriodById


Description:
RegenCustomMeasurements Schema change





 
   added CropCount as Number (integer)

 





  RegenCustomMeasurements  - added Field Descriptions






 1.	"Required Field Do Not Delete"                       


 2.	"Optional Field Replace Per Project Requirements"






 RegenCustomMeasurements 





 
  Added two additional measurements with appropriate RegenMeasKey

 





  RegenMeasurements 






 1.	Added two additional measurements with appropriate RegenMeasKey 






 altered Get/Update queries   






  1. _prjCFIDEER_GetProcessRegenList


  2. _prjCFIDEER_GetRegenMeasurements


  3. _prjCFIDEER_UpdateRegenMeasurement


Description:
ReportHeaders Table





 
  Rows & Columns reformated for generic presentation

 





 ReportColumns Table





 
  Plot, Tree & Regen Columns formated to fit generic ReportHeaders

 





 AppColumnCodes Table





 
  Added five CrownClass records; ColumnID = {DC75596F-6E74-40A0-AC81-631207F695D0} representing:  Open Grown, Dominant, Codominant, Intermediate & Overtopped


Description:
SpeciesMerchantabilityStandards Table created two records





 
   species code 122 for measured example

  species code 202 for regen example

 





 AnalysisProjectGenerators Table pared down to one example record





 
  filename field value set to "SelectFortranModule(s).exe"


Description:
ValidationRules Table





 
  Custom and Non-Standard record rules deleted


Description:
ProjectMeasurementPeriods Table





 
  Added records for 1910 & 1920

 





 Appropriate ProjectPeriodID GUIDs copied from:





 
   ProjectMeasurementPeriods to PlotMeasurements

  ProjectMeasurementPeriods to TreeMeasurements

  ProjectMeasurementPeriods to RegenMeasurements

 





 Appropriate MeasurementID GUIDs copied from:





 
  PlotMeasurements to PlotCustomMeasurements

  TreeMeasurements to TreeCustomMeasurements

  RegenMeasurements to RegenCustomMeasurements

 





 UpdUser changed to "sample" in the following tables:





 
   PlotMeasurements

  TreeMeasurements

  RegenMeasurements


Description:
SiteIndexEquations Table deleted

 Display order of "Tables and Related Views"





 
  ReportHeaders moved ahead of ReportColumns

  InventoryDesign moved directly below FVSCrossWalk

 





 UpdUser set to "system" in the following tables:





 
  Regions 

  Agencies 

  Reservations 

  Projects 

  ProjectTypes


Description:
SpeciesRegressions Table; Sample record added





 
  RegressionID = {E1E4D5E6-058E-43BB-84EE-00E2F067FE33}

  SpeciesCode = 122	       

  DataItem = Form_Class

  EqnDescription = WYKOFF

  CoefficientA = 4.968895271

  CoefficientB = -8.15594866


Description:
SpeciesRegressionCriteria table - extraneous records deleted 






1. Remaining record corresponds to single record in SpeciesRegressions table


Description:
SpeciesRegressionCriteria table - extraneous records deleted





 
  Remaining record corresponds to single record in SpeciesRegressions table


Description:
FVS_StandInit Table





 
  Add Field PlotNumber Long Integer description = CFI Plot Number for use with queries to CFI data


Description:
AppColumns Table - Append TreeMeasurements Records for the following fields:





 
  Created

  RegenKey

  RetrievalID

  TreeAgeClass

 





 TreeMeasurements table structure change





 
  Add Field TreeAgeClass Integer after TreeAge


Description:
The following changes are to correct for Version 1.36.30 commit:

 TreeMeasurements table structure change





 
  TreeAgeClass field deleted

 





 AppColumns Table data changes





 
  TreeAgeClass reclassified as TreeCustomMeasurements TableID 11

  Created columnName deleted

  RegenKey columnName deleted

  RetrievalID columnName deleted


Description:
CFIDEER_UpdateTreeCalculation query modified






1. Last field TreeMeasKey changed from 'Update To:' to 'Criteria'






 SpeciesRegressionCriteria Schema change






1. Added ID Primary Key AutoNumber


2. Changed RegressionID to Number. 






 SpeciesRegressions Schema change






1. Established RegressionID as the Primary Key






 Relationship Tools Design






1. Default relationship established between SpeciesRegressionCriteria and SpeciesRegressions based upon RegressionID






 Example Data Added






1. SpeciesRegressionCriteria and SpeciesRegressions data inserted for Total_Height by Plot Habitat Type


Description:
Table SiteIndex-Alexander renamed to SiteIndex_Alexander 

 Table SiteIndex-Meyer table renamed to SiteIndex_Meyer 

 Table SiteIndex-NC128 table renamed to SiteIndex_NC128


Description:
Renamed table SiteIndex_Alexander to SiteIndexAlexander.

 Renamed table SiteIndex_Meyer to SiteIndexMeyer.

 Renamed table SiteIndex_NC128 to SiteIndexNC128.


Description:
Added table VolumeNC250.

 
   Added column ID as primary key auto number of type ReplicationID.

  Added column SpeciesCode as number of type Integer.

  Added column Stone1 as number of type Double.

  Added column Stone2 as number of type Double.

  Added column Int2Scrib1 as number of type Double.

  Added column Int2Scrib2 as number of type Double.

  Added column Int2Scrib3 as number of type Double.

  Added column Int2Scrib4 as number of type Double.


Description:
SpeciesMerchantabilityStandards table





 
    VolumeEquation values for two sample records set to 'NatVolEq'


Description:
(Amended 08-30-2018 - DWS: added replacement step.)



 VolumeEquation Table





 
  Replaced Woodland volume equation text with Woodland339

  Added volume equation records for: Woodland363, Woodland379, Woodland391 & Woodland471

 





 ValidationRuleTypes Table






1. IntegerMaximum Description corrected


Description:
(Amended 08-30-2018 - DWS: Added detail to query descriptions.)



 when new RegenMeasurement record is created





 
   CFIDEER_GetRegen

 





 
  
   Added SpeciesCode field after PlotNumber field.

   Added SpeciesName field after SpeciesCode field.

  

 





 
  CFIDEER_AddRegenMeasurement:

 





 
  
   Added RegenMeasKey field after RegenMeasurementID field.

   Added SpeciesCode field after PlotNumber field.

   Renumbered Expr<n> convienience field names (n = 1 thru 11).

   Added RegenMeasKey as Short Text to parameter list after RegenMeasurementID.

   Added SpeciesCode as Integer to parameter list after PlotNumber.


Description:
(Amended 08-30-2018 - DWS: Added SpeciesName step (2).)



 _prjCFIDEER_GetProcessRegenList query modified





 
  Added inner join to Species table on SpeciesCode returning SpeciesName necessary for correct functioning of Fetch method on the BusinessCfiDeer\RegenProcessListItem related to CO-12.

  Added SpeciesName field from Species table after SpeciesCode field.


Description:
VolumeNC250 table design change





 
  Int2Scrip4 column renamed Int2Scrib4


Description:
added CustomValidationMessage to ValidationRules table Data Type Short Text (255)

 Edited CFIDEER_Rpt_ValidationRulesQuery adding reference to CustomValidationMessage 

 Edited CFIDEER_Rpt_ValidationRulesQuery-Parents adding  reference toCustomValidationMessage


Description:
Modified _prjCFIDEER_UpdateRegenMeasurements action query to add     newly formed RegenMeasKey as a parameter updatable in both RegenMeasurements and RegenCustomMeasurements tables


Description:
The following unused queries have been removed….  





 
  CFIDEER_Rpt_ValidationRulesQuery

  CFIDEER_Rpt_ValidationRulesQuery-Parents

  BO_AddValidationRules

  BO_DeleteValidationRule

  BO_GetSecondaryValidationRules

  BO_GetValidationRules

  BO_UpdateValidationRules

  GetValidationRulesList        

  GetValidationRules            

  GetSecondaryValidationRules

 





 The following unused reports have been removed….





 
  ValidationRules

  ListANDFIREColumns 

  CFIDEER_Rpt_ReportColumns


Description:
VolumeEquations table clean-up





 
  Deleted record for "Gevorkianz_1109"


Description:
VolumeEquations table clean-up






1. Deleted record for "NC250" as its use is not properly cited






 Deleted support table VolumeNC250 as it is currently unused


Description:
TreeMeasurements table





 
  Delete DMRating field

  Add DMR field Integer after DMUML

 





 Alter _prjCFIDEER_GetProcessTreeList, _prjCFIDEER_GetTreeMeasurementsForPeriodByKey and _prjCFIDEER_UpdateTreeMeasurement queries adding




DMR field


Description:
TreeCalculations table





 
  Added CalcBDFTTopDIB field Single

  Added CalcCUFTTopDIB filed Single

 





 AppColumns table  1. Added record CalcBDFTTopDIB, TableID:9, DataTypeID:5






  2  Added record CalcCUFTTopDIB, TableID:9, DataTypeID:5






 _prjCFIDEER_GetProcessTreeList Query

   1. Added fields TreeCalculations.CalcCUFTTopDIB & TreeCalculations.CalcBDFTTopDIB to SELECT statement






 






 CFIDEER_UpdateTreeCalculation Query






  1. Added fields CalcCUFTTopDIB IEEESingle & CalcBDFTTopDIB as IEEESingles to parameters and Update Clause






 CFIDEER_GetTreeCalculationsForPeriodByKey Query






  1. Added TreeCalculations.CalcCUFTTopDIB & TreeCalculations.CalcBDFTTopDIB to SELECT statement






 CFIDEER_GetTreeCalculationsForPeriod Query deleted as it was unused in Business.Cfideer

 CFIDEER_GetTreeCalculationsForPeriodById deleted as it was unused in Business.Cfideer


Description:
Update CFIDEER_UpdateTreeCalculation action query





 
  Reorder parameters; place CalcBDFTNetVol between CalcBDFTGrossVol & CalcCUFTGrossVol


Description:
Added volume equation title and species locations to the woodland species in the VolumeEquations table for the following equations:





 
  SWHardwoods

  Woodland339

  Woodland363

  Woodland379

  Woodland391

  Woodland471

 





 Changed the following record in AppColumns:





 
  {9899166C-785B-4B6A-8B2C-473235F8F1B4} TreeAgeClass table ID from 11 to 10.


Description:
Modified _db09MakeRegenKey query to include Minor Plot in update to value of RegenMeasKey field. It now has the following components:





 
  Plot key*

  Period number*

  Minor plot

  Species code

  IDBH

 




* Part of PlotMeasKey


Description:
Changed CFIDEER_GetRegen RegenMeasurements to Species SpeciesCode relationship to option 2 (All RegenMeasurements/Only equal Species).


