Database Answers Header

 

 

MAPPING SPECIFICATIONS FOR LAW ENFORCEMENT

These Specifications define mapping of Entities from Source to Target.

Source Area

Source Entity

Target Entity

Ref Data

Case Management

Addresses

MDM_Addresses

 

Case Management

Cases_Trials

 

 

Case Management

Organisations

MDM_Organisations

 

Case Management

Incidents

 

 

Case Management

Officers

 

 

Case Management

Address_Types

 

Ref

Case Management

Incident_Outcomes

 

Ref

Case Management

Incident_Status

 

Ref

Case Management

Incident_Types

 

Ref

Case Management

Ranks

 

Ref

Case Management

Roles

 

Ref

Police Departments

Addresses

 

 

Police Departments

Associates

 

 

Police Departments

Departments

 

 

Police Departments

Incidents

 

 

Police Departments

Officers

 

 

Police Departments

Address_Types

 

Ref

Police Departments

Incident_Outcomes

 

Ref

Police Departments

Incident_Status

 

Ref

Police Departments

Incident_Types

 

Ref

Police Departments

Ranks

 

Ref

Police Departments

Roles

 

Ref

Prisons and Prisoners

Associates

 

 

Prisons and Prisoners

Offences

 

 

Prisons and Prisoners

Prisons

 

 

Prisons and Prisoners

Prison_Staff

 

 

Prisons and Prisoners

Prisoners

 

 

Prisons and Prisoners

Staff

 

 

Prisons and Prisoners

Gender

 

Ref

Prisons and Prisoners

Offence_Category

 

Ref

Prisons and Prisoners

Probation_Status

 

Ref

Prisons and Prisoners

Staff_Roles

 

Ref

Traffic Cops and Tickets

Mailing Addresses

 

 

Traffic Cops and Tickets

Officers

Persons

 

Traffic Cops and Tickets

Tickets

 

 

Traffic Cops and Tickets

Vehicles

 

 

Traffic Cops and Tickets

Violaters

 

 

Traffic Cops and Tickets

Violations

 

 

Traffic Cops and Tickets

Document_Types

 

Ref

Traffic Cops and Tickets

Payment_Methods

 

Ref

Traffic Cops and Tickets

Ranks

 

Ref

Traffic Cops and Tickets

Ticket_Status

 

Ref

Traffic Cops and Tickets

Vehicle_Types

 

Ref