<< Click to Display Table of Contents >> Navigation: Release Notes > EQuIS 7 > Build 20.2 (May 2020) > Alive (7.20.2) |
Alive Schema: Add TASK_CODE Field to DT_SURVEY Table [m148105]
Added TASK_CODE to DT_SURVEY with associated Foreign Key to the DT_TASK table in the Alive Schema.
Alive Survey Definition Form: Surveyed Species Tab Does Not Display TAXONOMY_CODE Values with More Than 20 Characters [m165173]
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.
New Reports: Survey Results (By Survey Type) II and Survey Results (Basic) II [m178187]
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).
Alive Schema: Recluster Survey Tables Based on Foreign Key Fields [m184697]
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 © 2022 EarthSoft, Inc • Modified: 19 May 2020