Data Model Changes in Biotics 5
See the attached document which identifies data model changes between Biotics 4 and Biotics 5.5.
EGR/ENR/ESR data model changes are included.
...
Fri, 10 Oct, 2014 at 10:57 AM
Several changes were made to ELEMENT_GLOBAL_RANK, ELEMENT_NATIONAL_RANK, and ELEMENT_SUBNATL_RANK in Biotics 5 to make these tables compatible with the Rank...
Fri, 10 Oct, 2014 at 1:50 PM
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
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
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
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
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
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
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
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