Data Model Changes in Biotics 5

Removal of Obsolete Domain Tables from the Database
We will be removing a series of columns and tables from program and central databases in our January sprint which will end in mid-January. Although we don’t...
Tue, 11 Dec, 2018 at 6:07 PM
Central Biotics only: If you make a change to the structure of a table or view...
If you make a change to the structure of a table or view within Central Biotics (including extensible tables) at any point in the future, please run the fol...
Tue, 21 Apr, 2020 at 2:09 PM
New values added to D_LOCATION_USE_CLASS
Three new domain values were added to D_LOCATION_USE_CLASS to accommodate the updated EO_Specs for Caribou. One term was also updated: Summer Range: Displ...
Fri, 13 Nov, 2020 at 3:22 PM
EO_SPECS_DETAIL.VERSION_AUTHOR_NAME
The field length for EO_SPECS_DETAIL.VERSION_AUTHOR_NAME was increased to 400 characters.
Fri, 13 Nov, 2020 at 3:36 PM
Addition of D_DATASET domain table
A new domain table, d_dataset was added to the database, containing the following columns: d_dataset_id - number. Automatically assigned primary key. dat...
Wed, 10 Feb, 2021 at 3:02 PM
BX-4377: Update Informal_tax and informal_group functions
Improvements to the INFORMAL_GRP and INFORMAL_TAX functions which assign each Element_global record to an informal group (Informal_tax is a finer group than...
Tue, 30 Mar, 2021 at 4:19 PM
Addition to USESA domain values & new value to Ranking field (D_RANK_METHOD_USED)
We are planning to ADD a new value to USESA Code, Description, and Display Value in the table D_USESA to conform with the Species Status Codes assigned by t...
Mon, 28 Mar, 2022 at 8:33 AM
Changes to Record Copy functionality
We are planning to modify the Biotics Record Copy functionality for Tracking records so that the External Identifiers grid is included in fields that are co...
Wed, 20 Apr, 2022 at 10:17 AM
Change General Comments, Management Comments, Additional Topics EO fields to CLOBs
General Comments, Management Comments, and Additional Topics will be changed from Varchar(4000) to a CLOB field (unlimited) in the June 15th, 2022 release, ...
Mon, 6 Jun, 2022 at 1:09 PM
IVC (International Vegetation Classification) upper hierarchy revisions in Biotics
See the attached pdf for article content. 
Tue, 6 Feb, 2024 at 1:51 PM