Added TASK_CODE to DT_SURVEY with associated Foreign Key to the DT_TASK table in the Alive Schema.
Resolved issue on the Surveyed Species tab in the Alive Survey Definition Form where more than 20 characters would not display for the TAXONOMY_CODE field despite a database limit of 40 characters.
Two new Alive reports have been added: Survey Result (by Survey Type) II and Survey Results Basic II. These reports have performance improvements and additional functionality (when compared to the original Alive reports).
To improve performance of Alive reporting, the CLUSTERED index is changed from the Primary to the Unique key for the following tables: DT_SURVEY, DT_SURVEY_PARAM, DT_SURVEY_OBSERV, and DT_SURVEY_OBSERV_PARAM.
Copyright © 2020 EarthSoft, Inc • Modified: 19 May 2020