Before you delete ANY Element Tracking record, remember:
You will not be able to delete the record if it has any related EOs. If you try to delete an Element Tracking record that has EOs, a message will be displayed, indicating that the prior to deleting the element record, you must first either change the element associated with the EOs, as well as any independent Source Features, or delete them.
The following records, if they exist for the element, will be deleted with the EST: Element Subnational Ranking (ESR), Element Subnational Characterization (CAS), Element Subnational Ecoregion.
If the EST is on a centrally-maintained ENT, a second dialog box will appear where you must select a reason the record is being deleted.
Select a reason from the drop-down menu in the Delete Element Subnational dialog box.
Possible Deleted Reasons:
Complete the deletion by selecting Delete.
Values entered are not visible in the Subnational Element Tracking window once the record is deleted, but are available via SQL. They are sent to Central Biotics in Local to Central Data Exchange and will be displayed in the Central Data Exchange Alerts Workbench message for the EST-Deleted;MatchActive alert. This allows central staff to add any relevant information to central records about why a local program no longer maintains an EST for a particular Element.
Note: you will not be prompted to enter a reason for deleting an EST on a locally-maintained ENT (National Element Tracking Maintained By Status is L: Locally), such as a local community type or a champion tree, because Central does not need to know the reason. The field does still exist in the data model and could be populated via SQL if it would be useful for the local program.
The deletion reason fields are in both the live and deleted schemas, but will only be populated in the deleted schema (deleted records), so the deleted schema table name (with schema) is shown here.
|
Window: none Section: none Field: Deleted Reason Database Table: biotics_del.ELEMENT_SUBNATIONAL_DEL Column: d_deleted_reason_id Data Type: NUMBER Optionality: NULL Default Value: Foreign Key from: D_DELETED_REASON Column Name: d_deleted_reason_id Display Column: display_value |
|
Window: none Section: none Field: Deleted Reason Comment Database Table: biotics_del.ELEMENT_SUBNATIONAL_DEL Column: deleted_reason_com Data Type: VARCHAR2(255) Optionality:NULL Default Value: Foreign Key from: Column Name: Display Column: |
The following records, if they exist for the element, will be deleted with the ENT: Element National Ranking (ENR), Element National Characterization (CAN), Element National Ecoregion, and any ESTs with all their related records listed above.
NOTE: Centrally-maintained ENTs cannot be deleted in local (program) databases.
In Biotics 5, centrally-maintained Element Global Tracking records cannot be deleted from or inactivated in a local (program) database. Only EGTs which were created locally (Global Element Tracking Maintained By Status is L: Locally) can be deleted.
Deleting an element tracking record in Biotics causes a cascade delete, i.e., all related child records are also deleted. These are EGR, CAG, CCAL, Element Management, EO Specs, EO Rank Specs, Element Global Ecoregion, and any ENTs and ESTs with all their related records.
An alternative to deleting an Element Tracking record is to make it inactive. When an Element Global Tracking (EGT) record is inactivated, it remains in the database, as do all its related global, national, and subnational element data, so that these records can be accessed easily for reference. See the Inactivate an Element help topic for more information. This option is only available in EGTs; you can only delete—not inactivate—an EST or ENT. (But ESTs and ENTs of inactive EGTs are also inactive.)
Recommendation: Unless your installation has defined a clear intent to maintain an archive of inactive elements, you should use Delete rather than Inactivate to remove an entire element from your database. The primary reason for this recommendation is that you will need to remember to specify in all queries that only active records should be included in the query results if you have inactive records in your database.
The following records, if they exist for the element, will be deleted with the EGT: EGR, CAG, CCAL, Element Management, EO Specs, EO Rank Specs, Element Global Ecoregion, and any ENTs and ESTs with all their related records (as listed above). The system may prompt you to remove some relationships before you can proceed. The EGT cannot be deleted until the relationships are manually removed.
