Name: MaintenanceRecords

Display Field: ContractorName

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ContractorName (type: esriFieldTypeString, alias: Contractor Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Rapid Response: Rapid Response])
• sharps_box_globalid (type: esriFieldTypeString, alias: Sharps Boxes ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SharpsBoxName (type: esriFieldTypeString, alias: Name of Sharps Box, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• MaintenanceDate (type: esriFieldTypeDate, alias: Date Serviced, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MaintenanceStatus (type: esriFieldTypeString, alias: MaintenanceStatus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new: new], [reviewed: reviewed], [approved: approved])
• ServiceType (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [standard: Standard Service], [installation: Installation of sharps collection box], [remove: Remove sharps collection box], ... 4 more ...)
• HoursWorked (type: esriFieldTypeDouble, alias: Hours Worked, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SharpsBoxAccess (type: esriFieldTypeString, alias: Collection Box Is Operational and Accessible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• Condition (type: esriFieldTypeString, alias: Condition of Box, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [good: Good], [fair: Fair], [poor: Poor])
• Blockage (type: esriFieldTypeString, alias: Blockage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Yes], [0: No])
• Graffiti (type: esriFieldTypeString, alias: Graffiti, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BoxCleaning (type: esriFieldTypeString, alias: BoxCleaning, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Litter (type: esriFieldTypeString, alias: Litter, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Disinfectant (type: esriFieldTypeString, alias: Disinfectant, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Disposal (type: esriFieldTypeString, alias: Bin Removed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SharpsPercent (type: esriFieldTypeDouble, alias: Percent Full, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0%], [0.125: less than 25%], [0.25: more than 25%], ... 3 more ...)
• GarbagePercent (type: esriFieldTypeDouble, alias: Percent Garbage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0%], [0.125: less than 25%], [0.25: 25%], ... 3 more ...)
• SharpsApprox (type: esriFieldTypeInteger, alias: SharpsApprox, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• ServiceCharge (type: esriFieldTypeDouble, alias: Service Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransportCharge (type: esriFieldTypeDouble, alias: Transport Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DisposalCharge (type: esriFieldTypeDouble, alias: Disposal Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GraffitiCharge (type: esriFieldTypeDouble, alias: Graffiti Removal Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EmergencyCharge (type: esriFieldTypeDouble, alias: Emergency Service Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InstallationCharge (type: esriFieldTypeDouble, alias: Installation Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RemovalCharge (type: esriFieldTypeDouble, alias: Removal Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RepairCharge (type: esriFieldTypeDouble, alias: Repair Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TotalCharge (type: esriFieldTypeDouble, alias: Total Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SurveyVersion (type: esriFieldTypeDouble, alias: SurveyVersion, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IsActive (type: esriFieldTypeString, alias: IsActive, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• ServiceSchedule (type: esriFieldTypeString, alias: Service Schedule, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Monday/Thursday: Monday/Thursday], [Monday/Thursday/Saturday: Monday/Thursday/Saturday])
• SharpsLoose (type: esriFieldTypeString, alias: Sharps Loose, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CustodialCharge (type: esriFieldTypeDouble, alias: Custodial Charge, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: MaintenanceRecords
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/22/2026 3:07:23 PM

Schema Last Edit Date: 4/22/2026 9:16:44 PM

Data Last Edit Date: 5/22/2026 3:07:23 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