Name: Permit Detail

Display Field: APPLICANTNAMESTORED

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: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• JOBID (type: esriFieldTypeInteger, alias: Job ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EXTERNALFILENUM (type: esriFieldTypeString, alias: Permit ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PERMITTYPE (type: esriFieldTypeString, alias: Permit Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• COMMERCIALORRESIDENTIAL (type: esriFieldTypeString, alias: Permit Business Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATUSDESCRIPTION (type: esriFieldTypeString, alias: Permit Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATEDDATE (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ISSUEDATE (type: esriFieldTypeDate, alias: Issue Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMPLETEDDATE (type: esriFieldTypeDate, alias: Completed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EXPIRATIONDATE (type: esriFieldTypeDate, alias: Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROWREQUESTEDSTARTDATE (type: esriFieldTypeDate, alias: Requested Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROWESTIMATEDCOMPLETIONDATE (type: esriFieldTypeDate, alias: Estimated Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WARRANTYEXPIRATION (type: esriFieldTypeDate, alias: Warranty Expiration Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROWREASONFORJOB (type: esriFieldTypeString, alias: Reason for Job, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ROWIMPROVEMENTREPAIR (type: esriFieldTypeString, alias: Improvements/Repairs, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROWISEMERGENCYREPAIR (type: esriFieldTypeString, alias: Emergency Repair Activity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SPECIFICLOCATION (type: esriFieldTypeString, alias: Specific Location, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• WORKDESCRIPTION (type: esriFieldTypeString, alias: Work Description, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• APPLICANTNAMESTORED (type: esriFieldTypeString, alias: Owners Representative Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• APPLICANTCOMPANYNAMESTORED (type: esriFieldTypeString, alias: Owners Company Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ALLCONTRACTORSNAME (type: esriFieldTypeString, alias: Contractor Names, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• LOCATIONNAMES (type: esriFieldTypeString, alias: Location Names, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CASEID (type: esriFieldTypeString, alias: Case ID, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• COUNCIL_DISTRICTS (type: esriFieldTypeString, alias: Council Districts, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• INSPECTION_DISTRICTS (type: esriFieldTypeString, alias: Inspection Districts, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Templates:

Name: Permit Detail
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/23/2026 11:25:17 AM

Schema Last Edit Date: 5/23/2026 11:25:17 AM

Data Last Edit Date: 5/23/2026 11:25:17 AM

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