This simple view compiles information from the Incidents module into one convenient dataset. It includes all the relevant information about each Incident, including involved clients and staff, emergency service involvement, notes and recording staff.

This view contains the following columns, pulling data from all Incidents:

• IncidentID
  
• OrganizationID
  
• ServiceProvider
  
• InvolvedCount
  
• ClientIsInvolved
  
• InvolvedClientID
  
• StaffIsInvolved
  
• InvolvedPersonID
  
• InvolvedList
  
• WitnessCount
  
• WitnessList
  
• NatureOfIncident
  
• IncidentDateAndTime
  
• Location
  
• FireDept
  
• Paramedics
  
• OtherEmerg
  
• Police
  
• ChargesLaidTF
  
• PoliceBadge
  
• PoliceReportNo
  
• Disposition
  
• IncidentReport
  
• IncidentDocumentID
  
• Comments
  
• RecordedByUserID
  
• RecordedByName
  
• ViewVersion

Documentation

• vw_ACRE_Incidents - Schema.csv
• vw_ACRE_Incidents - Sample Output.csv