Data Model Changes in Biotics 5

Detected field in Visit grid with default value of 'Y'
Detected will be added as a single checkbox field to the Visit grid in the Source Feature record, with a default value of Yes.  Previous feedback (Forum to...
Wed, 27 May, 2020 at 9:22 AM
D_LANGUAGE.languge_desc
D_LANGUAGE.language_desc column increased from 20 to 25 characters.
Tue, 19 May, 2020 at 2:03 PM
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, 6 Jun, 2018 at 12:49 PM