Name: reportinforepeat

Display Field: objectid

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• reportinfodates (type: esriFieldTypeString, alias: Report Dates Covered, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [FY2020: January 1, 2020 through December 31, 2020], [FY2021: January 1, 2021 through December 31, 2021], [FY2022: January 1, 2022 through December 31, 2022], ... 2 more ...)
• reporthours (type: esriFieldTypeInteger, alias: Hours Equipment Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• reportmiles (type: esriFieldTypeInteger, alias: Miles Equipment Driven, SQL Type: sqlTypeOther, nullable: true, editable: true)
• reportmaintcomplete (type: esriFieldTypeDate, alias: Date of Last Maintenance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reportmaintcompleteitem (type: esriFieldTypeString, alias: Items maintained, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• reportequipuse (type: esriFieldTypeString, alias: How has the equipment been used in this reporting period?, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• reportloan (type: esriFieldTypeString, alias: Has the equipment been loaned to another agency or jurisdiction?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)
• reportloaninfo (type: esriFieldTypeString, alias: What agency was the equipment loaned to, for what duration, and for what reason?, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Please add any success stories or other information you'd like to provide to the SPIRE program., SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• reportsubmit (type: esriFieldTypeString, alias: Submit report to OEM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes, Submit Now], [no: No, I'm saving a draft copy for myself])
• reportingpartyemail (type: esriFieldTypeString, alias: Please enter your email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reportinfoagency (type: esriFieldTypeString, alias: Agency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reportinfoequip (type: esriFieldTypeString, alias: Equipment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• reportinfoequipdescript (type: esriFieldTypeString, alias: Equipment Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:

• SPIREEquipment_reportinforepeat (1) -- Related To: SPIREEquipment (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/31/2025 5:33:39 PM

Schema Last Edit Date: 6/25/2025 2:42:34 PM

Data Last Edit Date: 7/31/2025 5:33:39 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat