Name: PermitInspectionHistory

Display Field: PERMITID

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

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• permitid (type: esriFieldTypeString, alias: Permit ID, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• permittype (type: esriFieldTypeString, alias: Permit Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Biosolids: Biosolids], [Construction: Construction], [Hydrostatic: Hydrostatic], ... 12 more ...)
• permitdesc (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• constructionstatus (type: esriFieldTypeString, alias: Construction Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• wells (type: esriFieldTypeString, alias: Wells, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• surfacewatermgt (type: esriFieldTypeString, alias: Surface Water Management, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• dischargestructures (type: esriFieldTypeString, alias: Discharge Structures, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• filterstrenches (type: esriFieldTypeString, alias: Underdrain Filters or Exfiltration Trenches, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• storageareas (type: esriFieldTypeString, alias: Storage areas for Treatment and Attenuation, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• grading (type: esriFieldTypeString, alias: System Grading, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• divconvease (type: esriFieldTypeString, alias: Diversions Conveyance Easements, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• floodplaincomp (type: esriFieldTypeString, alias: Floodplain Comp, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• wetlandrestoration (type: esriFieldTypeString, alias: Wetland Mitigation or Restoration Areas, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• soc (type: esriFieldTypeString, alias: SOC/As-built request letter, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• constructionletter (type: esriFieldTypeString, alias: Construction Letter Required, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• expirationletter (type: esriFieldTypeString, alias: Expiration Letter, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• es (type: esriFieldTypeString, alias: ES, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• permcondletter (type: esriFieldTypeString, alias: Permit Condition Letter, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• inspectiondate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• compliance (type: esriFieldTypeString, alias: Compliance, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Pending: Pending])
• inspectionstatus (type: esriFieldTypeString, alias: Inspection Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Complete: Complete], [Re-inspection: Re-inspection], [Underway: Underway], ... 1 more ...)
• inspectionid (type: esriFieldTypeGUID, alias: Inspection ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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)

Templates:

Name: PermitInspectionHistory
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• permitid:

Relationships:

• Permits (0) -- Related To: Permits (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/8/2020 5:48:04 PM

Schema Last Edit Date: 5/8/2020 5:48:04 PM

Data Last Edit Date: 5/8/2020 5:48:04 PM

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