Public Sector Evidence Management

This ERD (shown in the following figure) illustrates how evidence and supporting documents are related to the incident and case and acts as the trigger of the investigative lead. It shows how a party, such as a person, organization, or group, is included in the evidence and supporting documents. The ERD describes the positions of team members assigned to handle the incident and approve the documents. This ERD also shows how the items are supported by the documents. The location of the incident, physical object used in the incident, as well as the activity and service request related to the evidence are shown.

The following table lists the entities in this ERD and their corresponding tables.

Entity	Table
EVIDENCE/SUPPORTING DOCUMENT	S_EVIDENCE
PARTY	S_PARTY
PERSON	S_CONTACT, S_USER
ORGANIZATION/GROUP	S_ORG_EXT
POSITION	S_POSTN
ADDRESS	S_ADDR_PER
PHYSICAL OBJECT	S_ASSET
QUOTE ITEM	S_QUOTE_ITEM
ORDER ITEM	S_ORDER_ITEM
QUOTE	S_DOC_QUOTE
ORDER	S_ORDER
SERVICE REQUEST	S_SRV_REQ
ACTIVITY	S_EVT_ACT
INVESTIGATIVE LEAD	S_CASE_LEAD
INCIDENT	S_INCIDENT
CASE	S_CASE