Layer: Incident_Investigation

View In: Map Viewer

Name: Incident_Investigation_Report

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Incident Investigation Report","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
note (type: esriFieldTypeString, alias: To be completed by employee and supervisor within 24 hours of incident. SD First Report of Injury Form must also be filled out if an injury occurred. Be specific and include photos, drawings, additional narrative, as needed., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
IncidentType (type: esriFieldTypeString, alias: Type of Incident:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Injury: Injury], [Property Damage: Property Damage], [Near Miss: Near Miss], ... 2 more ...)
report_date (type: esriFieldTypeDate, alias: Date | Time of report:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
note1 (type: esriFieldTypeString, alias: CONTACT & INCIDENT INFORMATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
employee (type: esriFieldTypeString, alias: Employee Involved:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
title (type: esriFieldTypeString, alias: Employee Title:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
supervisor (type: esriFieldTypeString, alias: Supervisor:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
dept_division (type: esriFieldTypeString, alias: Department | Division:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
employment_years (type: esriFieldTypeString, alias: Time in Position:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
weather (type: esriFieldTypeString, alias: Weather Conditions:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
incident_time (type: esriFieldTypeDate, alias: Date | Time of incident, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
incident_location (type: esriFieldTypeString, alias: Location of Incident:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
notified (type: esriFieldTypeString, alias: Was Division Management & EHS Dept Notified immediately?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
others_involved (type: esriFieldTypeString, alias: Contractor or 3rd Party Involved?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
name_contact (type: esriFieldTypeString, alias: Name & Contact Information:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
note2 (type: esriFieldTypeString, alias: INJURY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PersonInjured (type: esriFieldTypeString, alias: Injured Person's Name | Contact Info:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InjurySource (type: esriFieldTypeString, alias: Object or Substance Causing Injury:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InjuryType (type: esriFieldTypeString, alias: Type of Injury(s):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InjuryPart (type: esriFieldTypeString, alias: Body Part(s) Injured:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InjuryLocation (type: esriFieldTypeString, alias: Injury Location:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [R: Right], [L: Left])
treatment (type: esriFieldTypeString, alias: Treatment:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [First-Aid_on-site: First-Aid_on-site], [Medical_ER_Clinic: Medical_ER_Clinic], [None: None])
workmissed (type: esriFieldTypeString, alias: Did employee miss work due to injury?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
note3 (type: esriFieldTypeString, alias: PROPERTY OR EQUIPMENT DAMAGE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Damage (type: esriFieldTypeString, alias: List Equipment | Property Damaged:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DamageDesc (type: esriFieldTypeString, alias: Describe Damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DamageCause (type: esriFieldTypeString, alias: Object or Substance Causing Damage:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DamageCost (type: esriFieldTypeInteger, alias: Approximate Cost:, SQL Type: sqlTypeOther, nullable: true, editable: true)
Trained (type: esriFieldTypeString, alias: Was the Operator Trained on the Equipment? Leave blank if not applicable, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
violation (type: esriFieldTypeString, alias: Did this result in a violation?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
note4 (type: esriFieldTypeString, alias: WITNESSES AND WITNESS STATEMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
witness (type: esriFieldTypeString, alias: Witnesses? (list name and contact information), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
policecontact (type: esriFieldTypeString, alias: Police Notified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
policereport (type: esriFieldTypeString, alias: Police Report Filed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
note5 (type: esriFieldTypeString, alias: DESCRIPTION OF INCIDENT, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
incident_desc (type: esriFieldTypeString, alias: Describe what happened. (Investigate scene of incident or conditions. Describe who was involved, when and where the incident happened, what happened, how, and what led up to the incident.), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
note6 (type: esriFieldTypeString, alias: Why did it happen? (Rood Cause Analysis) (What was the root cause of the incident?), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
acts (type: esriFieldTypeString, alias: Unsafe Acts:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
conditions (type: esriFieldTypeString, alias: Unsafe Conditions:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
deficiencies (type: esriFieldTypeString, alias: Management System Deficiencies:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
priorincident (type: esriFieldTypeString, alias: Has this incident occurred before? If so, explain. (same individual and/or locations), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
prevention (type: esriFieldTypeString, alias: How can a recurrence be prevented? (Be specific as to what would prevent the injury, incident or damage from occurring again), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
probability (type: esriFieldTypeString, alias: Probability of Injury or Illness:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NA: N/A], [Slight: Slight], [Moderate: Moderate], ... 2 more ...)
severity (type: esriFieldTypeString, alias: Severity of Potential Injury:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [NoLostTime: No Lost Time], [LostTime_RestrictedDuty: Lost Time/Restricted Duty], [PermenantlyDisabled: Permenantly Disabled], ... 2 more ...)
note7 (type: esriFieldTypeString, alias: CORRECTIVE ACTIONS TRACKING, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/19/2021 7:03:33 PM

Schema Last Edit Date: 7/19/2021 7:03:33 PM

Data Last Edit Date: 7/19/2021 7:03:33 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Query Attachments Add Features Update Features Apply Edits Calculate Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: Incident_Investigation_Report (ID:0)