Data Model Changes in Biotics 5

Fields changed from VARCHAR2(4000) to CLOB & updating Crystal Reports to reflect change
One field in EO and three in the Community Characterization tables (COMM_CAG, COMM_CAN, COMM_CAS, and COMM_CAL) were lengthened from 4000 characters to unli...
Tue, 25 Nov, 2014 at 1:36 PM
Data Dictionary
The attached spreadsheet lists all the tables and columns in Biotics 5, with datatype and column length. It also indicates primary key (PK) and foreign key ...
Fri, 9 Jan, 2015 at 4:44 PM
Data Model
The Biotics 5 Data Model can be accessed within the online help. The Biotics 4.1 data model diagrams are also available within the online help.
Wed, 6 Jun, 2018 at 12:49 PM
Rank Calculator spreadsheet number fields reformatted to date
PROBLEM: I opened my Element Rank Estimator (Rank Calculator) spreadsheet and found that a number of the fields had reformatted to date. They looked fine ...
Wed, 11 Mar, 2015 at 10:53 AM
Searching for invalid characters in COM_CAx_Composition, COM_CAx_Structure and Alliance_Structure tables
Changes were made in January 2017 to the COM_CAx_Composition, COM_CAx_Structure and Alliance_Structure tables to limit the values in min_percent_cover and m...
Wed, 8 Mar, 2017 at 11:32 AM
Removal of ELEMENT_SUBNATIONAL.ELCODE_BCD from the data model
 ELEMENT_SUBNATIONAL.ELCODE_BCD field was removed from the date model on December 21, 2016. While we are aware that many programs referred to this field, th...
Wed, 8 Mar, 2017 at 12:11 PM
Changes/Additions to DATA_SENSITIVE fields in EO, SOURCE_FEATURE and ELEMENT_SUBNATIONAL
Here are the changes made to the tables in regards to DATA_SENSITIVE fields in the Biotics 5.9.5 Release on March 22, 2017, and additional changes implement...
Thu, 25 May, 2017 at 10:47 AM
EO_SOURCE_FEATURE Table
QUESTION: I’m confused about how you’re supposed to link to SFs from EOs. You clearly link through table EO_SOURCE_FEATURE, but which fields to use is not ...
Mon, 11 Dec, 2017 at 12:39 PM
d_digitizing_base.D_DIGITIZING_BASE_CD field, and the associated unique constraint, dropped
This is to alert you that the D_DIGITIZING_BASE_CD field, and the associated unique constraint, will be dropped from the D_DIGITIZING_BASE table in the next...
Wed, 24 Jan, 2018 at 10:22 AM
Updates to D_NAME_CATEGORY & D_CLASSIFICATION_FRAMEWORK values
This is to notify you of upcoming changes to values within two domain tables: D_NAME_CATEGORY & D_CLASSIFICATION_FRAMEWORK.  D_NAME_CATEGORY:  ...
Thu, 10 May, 2018 at 2:18 PM