econservation module

FAQ | Q&A | ISSUES | LUTS | data cleanup

What does an econservation record represent?

The conservation module records the condition and treatment of objects in the database related to their long term survival and conditions and treatments pre, post and during Exhibition.

Current Sub class Status

Subclassed?: Yes

---

Tab Switching:

• Column Name: InfRecordType
• Lookup List: Conservation Record Type
• Tab switching: Yes

Record Types:

• Analysis Report - A description of a test run on an object to determine presence or absence of specific attributes (chemicals, eg arsenic etc.)
• Treatment Report - A description of the treatments an object has undergone during the process of conservation.
• Loan Condition Report - A formal report of the condition of an object of concern
• Loan Condition Report - Incoming - A formal report of the condition of an object of concern during the incoming leg of an Exhibit or Loan.
• **Loan Condition Report - Outgoing ** - A formal report of the condition of an object of concern during the outgoing leg of an Exhibit or Loan
• Loan Condition Report - Returning - A formal report of the condition of an object of concern upon return of an Exhibit or Loan
• Loan Condition Report - During - A formal report of the condition of an object of concern during an Exhibit or Loan
• Preparation - Documents the procedure used to extract fossils from their matrix.
• Condition Check - A description of the current condition of the object. Includes any damage or degradation to the object.

Record Structure:

Parent/Child->Hierarchical; Is a special case of a Parent/Child: Here there is a parent/child relationship inherent to the nature of the record and its data.The record itself inherits data from its parent and or there any logic that changes data, based on the presence of a parent/child attachment.

---

Fields

Mandatory

• InfConservator_tab
• InfRecordDate (When InfRecordType <> Preparation)
• InfRecordType
• ObjObjectsConserved_tab(When InfRecordType <> Preparation)

Unique

Ditto Skip

Insert Deafults

Query Defaults

---

Software Dependencies

---

Resources -> Tools

---

Summary String(s)

Requests and updates to the summary string should be submitted as issues and tagged econservation. When approved they should be documented in structural changes.

Default

ObjObjectsConserved_tab [DarCatalogNumber +” “ + DarRelatedInformation + “ “ + DarScientificName] + “-” + InfRecordType + “ [“ + InfRecordDate + “]”

e.g.(irn 24237) 20737 -- gauntlets -- Condition Report [8/20/1996]

InfRecordType = “Condition Check”

ObjObjectsConserved_tab [DarCatalogNumber +” “ + DarRelatedInformation + “ “ + DarScientificName] + “-” + InfRecordType + “ [“ + InfRecordDate + “ Checked: “ + (Most recent date in New Field “Date Checked”/New Checks Tab) + “]”

---

STRUCTURAL CHANGES: Rationale

Reason(s) for Change Request

Status

• Version 5.1
• Funded - In Live
• FMNH Specific customisation

Details