Data Model Changes in Biotics 5

Observation table renamed Visit
 The table in Biotics 4 formerly known as OBSERVATION (displayed as a grid in the Source Feature record) was renamed VISIT in Biotics 5. The columns in the ...
Mon, 2 Jun, 2014 at 4:46 PM
Columns added to EO_SOURCE_FEATURE table
The EO_SOURCE_FEATURE table is the database link between EO and Source Feature records. In addition to the "foreign key" columns eo_shape_id and s...
Mon, 2 Jun, 2014 at 4:45 PM
Rank Calculator Export for Biotics5
As of 28 Aug 2014, the rank calculator available on the NatureServe website contains export scripts for Biotics 5. They are also attached here in a ...
Wed, 11 Mar, 2015 at 10:55 AM
Data Model changes between Biotics 4 and Biotics 5.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
Changes to Element Ranking tables
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
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, 21 Dec, 2016 at 2:35 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