Name: tc_permit_details

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: JOBID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EXTERNALFILENUM (type: esriFieldTypeString, alias: Permit Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PERMITTYPE (type: esriFieldTypeString, alias: PERMITTYPE, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• COMMERCIALORRESIDENTIAL (type: esriFieldTypeString, alias: COMMERCIALORRESIDENTIAL, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATUSDESCRIPTION (type: esriFieldTypeString, alias: STATUSDESCRIPTION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CREATEDDATE (type: esriFieldTypeDate, alias: CREATEDDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ISSUEDATE (type: esriFieldTypeDate, alias: ISSUEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COMPLETEDDATE (type: esriFieldTypeDate, alias: COMPLETEDDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EXPIRATIONDATE (type: esriFieldTypeDate, alias: EXPIRATIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROWREQUESTEDSTARTDATE (type: esriFieldTypeDate, alias: ROWREQUESTEDSTARTDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROWESTIMATEDCOMPLETIONDATE (type: esriFieldTypeDate, alias: ROWESTIMATEDCOMPLETIONDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ROWISEMERGENCYREPAIR (type: esriFieldTypeString, alias: ROWISEMERGENCYREPAIR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SPECIFICLOCATION (type: esriFieldTypeString, alias: SPECIFICLOCATION, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• WORKDESCRIPTION (type: esriFieldTypeString, alias: WORKDESCRIPTION, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• APPLICANTNAMESTORED (type: esriFieldTypeString, alias: APPLICANTNAMESTORED, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• APPLICANTCOMPANYNAMESTORED (type: esriFieldTypeString, alias: APPLICANTCOMPANYNAMESTORED, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ALLCONTRACTORSNAME (type: esriFieldTypeString, alias: ALLCONTRACTORSNAME, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• TCREASONFORJOB (type: esriFieldTypeString, alias: TCREASONFORJOB, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ROWNUMBEROFLANESCLOSED (type: esriFieldTypeString, alias: ROWNUMBEROFLANESCLOSED, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LOCATIONNAMES (type: esriFieldTypeString, alias: LOCATIONNAMES, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• CASEID (type: esriFieldTypeString, alias: CASEID, 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: tc_permit_details
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/25/2025 12:11:53 PM

Schema Last Edit Date: 11/25/2025 12:11:53 PM

Data Last Edit Date: 11/25/2025 12:11:53 PM

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