Obsolete Tables & Views from Biotics 4 are being dropped from the Biotics 5 database in version 5.13.16 as they are no longer used.
The following tables are being removed from the core Biotics data model and dropped from the database:
CA_KEYWORD_USED_BY
CONTACT_KEYWORD_USED_BY
EO_KEYWORD_USED_BY
MA_KEYWORD_USED_BY
MGMT_KEYWORD_USED_BY
REF_KEYWORD_USED_BY
SITE_KEYWORD_USED_BY
COMM_CAG_SUB_ASSOC
ELEMENT_SITE
EL_SITE_CURR_OCCURRENCE
EL_SITE_CURR_REFERENCE
EL_SITE_HIST_OCCURRENCE
EL_SITE_HIST_REFERENCE
EL_SITE_STATUS_REFERENCE
D_CONC_FEAT_LOC_UNCERT
Due to these changes, the following stored procedures are being dropped:
COPY_EL_SITE
WL_ELE_SIT
WL_SIT_ELE
Due to these changes, the following stored procedures are being modified to no longer process the ELEMENT_SITE table:
COPY_EGT_DEEP
COPY_PKG - CASCADEINSERT PROCEDURE
INACTIVATE_ELEMENT
The following stored procedures are being modified to no longer process the COMM_CAG_SUB_ASSOC table:
COPY_CAG
The following view is being modified to longer query the EL_SITE_*_REFERENCE tables:
REFERENCE_USAGE_VW
The following system tables are being removed and dropped. These tables were holdovers from Biotics 4 and have never been used within Biotics 5.
AD_APP_PALETTES
AD_DEFER_CALC_SPAT_ATT_LOC
AD_PALETTE_CONTENTS
AD_PALETTE_DEF
AD_SPATIAL_VALIDATION
CATALOG
DATA_LOC
DATASET
DB_UPGRADE_HISTORY
DB_UPGRADE_HISTORY_POWERPACK
DB_VERSION
DB_VERSION_POWERPACK
DDE
FK_DISPLAY
GUI_DEF
GUI_PROP
HELP_INDEX
LIBRARY
LAYER
MAPPLABL
MAPPLEGENDS
MAPPLIST
MAPPLOT
MAPPTYPE
MAPPVALU
MAPPVARS
MAPPVARS_SQL
MESSAGES
NAV_INDEX_MAP
NAV_METADATA
NEXT_SEQ
PB_ARC_COMM
PRIMARYENTITY
QB_OBJECT_EXCLUSION
SAVED_FILTER
SCENE
SCENE_X_THEME
SECURITY_FUNCTION_CONTROL
SYSTEM_CONTROL
SYSTEM_WORKING_LIST
SYSTEM_WORKING_LIST_BASE_TABLE
SYSTEM_WORKING_LIST_MENU
SYSTEM_WL_DATA_TABLE
THEME
THEME_DATA
THEME_FIELDS
THEME_FILTERS
THEME_LEGENDS
THEME_LOCATION
THEME_PROPERTIES
ZOOM_BY
ZOOM_BY_INDEX
The following function is being dropped due to a dependency on the FK_DISPLAY table: FKLOOKUP(tbl VARCHAR2, val NUMBER)
The following tables will be removed if they exist. Prior to this release, they were not present across all databases. These tables were used for several purposes:
Some supported BCD to Biotics 4 conversion
Some were Biotics 4 tables for which the table registration was deleted but the table was left intact
Some were Biotics 4 exchanger tables
BCD_CODE_BCD
COMM_CAG_SUB_TEMP_SE
ENTCODE_BCD
EOCODE_BCD
ESTCODE_BCD
HDMSRUNLOG
HDMSERRORLOG
HDMSCONVERSIONLOG
HDMSTABLESLOG
HOLD_COL_AUDIT
ID2CODEMAP
IMPORT_CANDIDATE_MATCH
IMPORT_COL_CLOB
IMPORT_DETAIL
IMPORT_DETAIL_COL
IMPORT_PROJECT
IMPORT_TASK
IMPORT_UNMATCHED_TARGET
IMPORTED_AUDIT
IMPORTED_COL_AUDIT
MU_LOCK
MU_MOD
MU_POST_HISTORY
NAV_DOMAIN_TABLE
SELECTED_DATA
SELECTED_KEYWORDS
SELECTED_THEMES
RANKPATTERNS
SOURCE_FEATURE_BCD
SYNCODE_BCD
WORK_AREA
The following functions will be removed if they exist. These depend upon some of the IMPORT_* tables which are being dropped.
GETDATEIMPORTCOL
GETIMPORTCOL
GETNUMIMPORTCOL
GETTEXTIMPORTCOL
HA_D_LOOKUP
HA_EST_LOOKUP
HA_FK_DISP
HA_FK_LOOKUP
HA_LOOKUP
Within the UI, the “Element Sites 1:n” option is being removed from the “Related Records” menu for element records. Previously, it was present but disabled.
The following views are being dropped, which rely upon obsolete system tables which are being dropped.
ALL_DATASET_VIEW
ALL_LAYER_VIEW
ALL_LIBRARY_VIEW
MU_POST_HISTORY_DETAILS_VIEW
MU_POST_HISTORY_SUMMARY_VIEW
THEME_VIEW
D_CONC_FEAT_SPAT_UNCERTAINTY
The following tables are being dropped from the deleted schema. These correspond to tables which are being dropped from the main schema, as well as a few COMM_CAL tables that correspond to tables that were removed from the data model years ago in the 5.5 release.
CA_KEYWORD_USED_BY_DEL
CONTACT_KEYWORD_USED_BY_DEL
EO_KEYWORD_USED_BY_DEL
MA_KEYWORD_USED_BY_DEL
MGMT_KEYWORD_USED_BY_DEL
REF_KEYWORD_USED_BY_DEL
SITE_KEYWORD_USED_BY_DEL
COMM_CAG_SUB_ASSOC_DEL
ELEMENT_SITE_DEL
EL_SITE_CURR_OCCURRENCE_DEL
EL_SITE_CURR_REFERENCE_DEL
EL_SITE_HIST_OCCURRENCE_DEL
EL_SITE_HIST_REFERENCE_DEL
EL_SITE_STATUS_REFERENCE_DEL
COMM_CAL_EMAP_DEL
COMM_CAL_HYDRO_MODIFIER_DEL
COMM_CAL_LATITUDE_ZONE_DEL
COMM_CAL_SPATIAL_PATTERN_DEL
COMM_CAL_WATERSHED_DEL