Name: FinanceAndAdministration

Display Field: OBJECTID

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

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:

• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• MonthReporting (type: esriFieldTypeString, alias: Month Reporting, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• FireNumber (type: esriFieldTypeString, alias: Fire Number , SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• JobClass (type: esriFieldTypeString, alias: Job Classification, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [FR I: FR I], [FRII: FRII], [FRIII: FRIII], ... 7 more ...)
• FleetNumber (type: esriFieldTypeString, alias: Fleet Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• EquipType (type: esriFieldTypeString, alias: Equipment Type, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [3 Ton Truck Bed: 3 Ton Truck Bed], [5 Ton Truck Trailer/Bed: 5 Ton Truck Trailer/Bed], [Engine Type 6: Engine Type 6], ... 11 more ...)
• DispatchTime (type: esriFieldTypeDate, alias: Dispatch Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ReleaseTime (type: esriFieldTypeDate, alias: Release Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HourlyCostPer (type: esriFieldTypeDouble, alias: Hourly Cost Personnel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HourlyCostEquip (type: esriFieldTypeDouble, alias: Hourly Cost Equipment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cost (type: esriFieldTypeDouble, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherSource (type: esriFieldTypeString, alias: Others Source, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• NumPerson (type: esriFieldTypeSmallInteger, alias: Others Number of Personnel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CostPersHour (type: esriFieldTypeDouble, alias: Others Cost of Personnel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OtherEquipType (type: esriFieldTypeString, alias: Others Equipment Type, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Engine/Pumper: Engine/Pumper], [Deuce 1/2: Deuce 1/2], [Dozer/Grader: Dozer/Grader], ... 4 more ...)
• NumEquip (type: esriFieldTypeSmallInteger, alias: Others Number of Equipment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Hours (type: esriFieldTypeDouble, alias: Others Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HourlyCost (type: esriFieldTypeDouble, alias: Others Hourly Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OthersCost (type: esriFieldTypeDouble, alias: Others Hourly Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalHours (type: esriFieldTypeDouble, alias: TotalHours, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Personnel (type: esriFieldTypeString, alias: Personnel, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• ArrivedTime (type: esriFieldTypeDate, alias: ArrivedTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OthArrivedTime (type: esriFieldTypeDate, alias: OthArrivedTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OthReleaseTime (type: esriFieldTypeDate, alias: OthReleaseTime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OtherPersonnel (type: esriFieldTypeString, alias: OtherPersonnel, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• FireNumberGUID (type: esriFieldTypeGUID, alias: FireNumberGUID, SQL Type: sqlTypeOther, 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)
• IncidentName (type: esriFieldTypeString, alias: Incident Name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• YearReporting (type: esriFieldTypeString, alias: Year Reporting, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• ClockInTime (type: esriFieldTypeDate, alias: Clock In Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ClockOutTime (type: esriFieldTypeDate, alias: Clock Out Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CallSign (type: esriFieldTypeString, alias: Call Sign, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Role (type: esriFieldTypeString, alias: Role, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)

Templates:

Name: Finance and Administration
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• HistoricalFireOccurrence (0) -- Related To: HistoricalFireOccurrence (31)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/25/2026 9:03:28 PM

Schema Last Edit Date: 9/25/2026 9:03:28 PM

Data Last Edit Date: 9/25/2026 9:03:28 PM

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