Name: Incidents

Display Field: name

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• alias (type: esriFieldTypeString, alias: Alias, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unique_number (type: esriFieldTypeSmallInteger, alias: Unique Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• incident_date (type: esriFieldTypeDate, alias: Date of Incident, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• report_date (type: esriFieldTypeDate, alias: Date of Report, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• class (type: esriFieldTypeString, alias: Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Near-Miss: Near-Miss], [No Treatment: No Treatment], [First Aid: First Aid], ... 3 more ...)
• description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• patient_name (type: esriFieldTypeString, alias: Patient Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• contact_number (type: esriFieldTypeString, alias: Contact Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_of_birth (type: esriFieldTypeDate, alias: Date of Birth, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• pronouns (type: esriFieldTypeString, alias: Pronouns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [She/her: She/her], [He/him: He/him], [They/them: They/them], ... 1 more ...)
• address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• job_title (type: esriFieldTypeString, alias: Job Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• employment_status (type: esriFieldTypeString, alias: Employment Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Permanent: Permanent], [Casual: Casual], [Contractor: Contractor], ... 1 more ...)
• hours_at_work (type: esriFieldTypeSmallInteger, alias: Hours at Work, SQL Type: sqlTypeOther, nullable: true, editable: true)
• prevention_details (type: esriFieldTypeString, alias: Prevention Details, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• vehicle_involvement (type: esriFieldTypeString, alias: Vehicle Involvement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• parent_access_points_id (type: esriFieldTypeGUID, alias: Parent access points ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• parent_devices_id (type: esriFieldTypeGUID, alias: Parent devices ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• parent_objects_id (type: esriFieldTypeGUID, alias: Parent objects ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• parent_structures_id (type: esriFieldTypeGUID, alias: Parent structures ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• parent_network_id (type: esriFieldTypeGUID, alias: Parent network ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• parent_zones_id (type: esriFieldTypeGUID, alias: Parent zones ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• parent_blocks_id (type: esriFieldTypeGUID, alias: Parent blocks ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• creation_date (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_editor (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edit_date (type: esriFieldTypeDate, alias: Last Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: Incidents
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• injuries (29) -- Related To: Injuries (12)
• access_points (0) -- Related To: Access Points (0)
• zones (17) -- Related To: Zones (5)
• devices (3) -- Related To: Devices (1)
• objects (6) -- Related To: Objects (2)
• blocks (20) -- Related To: Blocks (6)
• structures (9) -- Related To: Structures (3)
• network (14) -- Related To: Network (4)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/27/2022 9:57:43 PM

Schema Last Edit Date: 10/27/2022 9:57:43 PM

Data Last Edit Date: 10/27/2022 9:57:43 PM

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