Name: PermitHistory

Display Field: contractorname

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, editable: true, nullable: true, length: 20, defaultValue: null, modelName: AssetID )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkActivity )
• attachmentid1 ( type: esriFieldTypeInteger, alias: AttachmentID1, editable: true, nullable: true, defaultValue: null, modelName: AttachmentID1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID2, editable: true, nullable: true, defaultValue: null, modelName: AttachmentID2 )
• workdate ( type: esriFieldTypeDate, alias: WorkDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkDate )
• workby ( type: esriFieldTypeString, alias: WorkBy, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WorkBy )
• worktype ( type: esriFieldTypeString, alias: worktype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: worktype )
• comments ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: comments )
• permittype ( type: esriFieldTypeString, alias: permittype, editable: true, nullable: true, length: 30, defaultValue: null, modelName: permittype , Coded Values: [Connection: Connection] , [Disconnection: Disconnection] , [Repair: Repair] )
• permitnum ( type: esriFieldTypeString, alias: permitnum, editable: true, nullable: true, length: 20, defaultValue: null, modelName: permitnum )
• bldgtype ( type: esriFieldTypeString, alias: bldgtype, editable: true, nullable: true, length: 30, defaultValue: null, modelName: bldgtype , Coded Values: [Commercial: Commercial] , [Industrial: Industrial] , [School: School] , ...10 more... )
• numberunits ( type: esriFieldTypeSmallInteger, alias: numberunits, editable: true, nullable: true, defaultValue: null, modelName: numberunits )
• jobtype ( type: esriFieldTypeString, alias: jobtype, editable: true, nullable: true, length: 30, defaultValue: null, modelName: jobtype , Coded Values: [New Construction: New Construction] , [Addition: Addition] , [Repairs Only: Repairs Only] , ...3 more... )
• address ( type: esriFieldTypeString, alias: address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: address )
• hub_used ( type: esriFieldTypeString, alias: hub_used, editable: true, nullable: true, length: 50, defaultValue: null, modelName: hub_used )
• sewermap ( type: esriFieldTypeDouble, alias: sewermap, editable: true, nullable: true, defaultValue: null, modelName: sewermap )
• contractorname ( type: esriFieldTypeString, alias: contractorname, editable: true, nullable: true, length: 100, defaultValue: null, modelName: contractorname )
• contractoraddr ( type: esriFieldTypeString, alias: contractoraddr, editable: true, nullable: true, length: 150, defaultValue: null, modelName: contractoraddr )
• contractorphone ( type: esriFieldTypeString, alias: contractorphone, editable: true, nullable: true, length: 20, defaultValue: null, modelName: contractorphone )
• installer ( type: esriFieldTypeString, alias: installer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: installer )
• feepaid ( type: esriFieldTypeString, alias: feepaid, editable: true, nullable: true, length: 10, defaultValue: null, modelName: feepaid , Coded Values: [Yes: Yes] , [No: No] )
• sketchadded ( type: esriFieldTypeString, alias: sketchadded, editable: true, nullable: true, length: 10, defaultValue: null, modelName: sketchadded , Coded Values: [Yes: Yes] , [No: No] )
• connectfeepaid ( type: esriFieldTypeString, alias: connectfeepaid, editable: true, nullable: true, length: 10, defaultValue: null, modelName: connectfeepaid , Coded Values: [Yes: Yes] , [No: No] )
• connected ( type: esriFieldTypeDate, alias: connected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: connected )
• asbuiltrecvd ( type: esriFieldTypeDate, alias: asbuiltrecvd, editable: true, nullable: true, length: 8, defaultValue: null, modelName: asbuiltrecvd )
• occ_cert ( type: esriFieldTypeDate, alias: occ_cert, editable: true, nullable: true, length: 8, defaultValue: null, modelName: occ_cert )
• repairtype ( type: esriFieldTypeString, alias: repairtype, editable: true, nullable: true, length: 30, defaultValue: null, modelName: repairtype , Coded Values: [Corrective Maintenance: Corrective Maintenance] , [Preventative Maintenance: Preventative Maintenance] )
• wocomments ( type: esriFieldTypeString, alias: wocomments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: wocomments )
• wodescription ( type: esriFieldTypeString, alias: wodescription, editable: true, nullable: true, length: 255, defaultValue: null, modelName: wodescription )
• attachmentid3 ( type: esriFieldTypeInteger, alias: attachmentid3, editable: true, nullable: true, defaultValue: null, modelName: attachmentid3 )
• Work_Origin ( type: esriFieldTypeString, alias: Work_Origin, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Work_Origin , Coded Values: [Emergency: Emergency] , [Long-Term Maintenance Plan: Long-Term Maintenance Plan] )
• Inspection_Type ( type: esriFieldTypeString, alias: Inspection_Type`, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspection_Type , Coded Values: [Internal: Internal] , [External: External] )
• Street_Name ( type: esriFieldTypeString, alias: Street_Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Street_Name )
• Street_No ( type: esriFieldTypeString, alias: Street_No, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Street_No )
• Building_Type ( type: esriFieldTypeString, alias: Building_Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Building_Type , Coded Values: [Single Family: Single Family] , [Multi Family: Multi Family] , [Apartment: Apartment] , ...2 more... )
• Sewer_SubArea ( type: esriFieldTypeString, alias: Sewer_SubArea, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Sewer_SubArea )
• Map_No ( type: esriFieldTypeString, alias: Map_No, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Map_No )
• Line_Segment ( type: esriFieldTypeString, alias: Line_Segment, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Line_Segment )
• Upstream_MH ( type: esriFieldTypeString, alias: Upstream_MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Upstream_MH )
• Downstream_MH ( type: esriFieldTypeString, alias: Downstream_MH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Downstream_MH )
• Owner_Contact_Name ( type: esriFieldTypeString, alias: Owner_Contact_Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Owner_Contact_Name )
• Owner_Contact_Number ( type: esriFieldTypeString, alias: Owner_Contact_Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Owner_Contact_Number )
• Inspection_Attempt ( type: esriFieldTypeString, alias: Inspection_Attempt, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Inspection_Attempt , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...1 more... )
• Date_Historical_Flooding ( type: esriFieldTypeString, alias: Date_Historical_Flooding, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Date_Historical_Flooding )
• Source_Historical_Flooding ( type: esriFieldTypeString, alias: Source_Historical_Flooding, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Source_Historical_Flooding )
• Actions_Take_After_Flooding ( type: esriFieldTypeString, alias: Actions_Take_After_Flooding, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Actions_Take_After_Flooding )
• Foundation_Type ( type: esriFieldTypeString, alias: Foundation_Typep, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Foundation_Type , Coded Values: [Slab: Slab] , [Crawl Space: Crawl Space] , [Unfinished Basement: Unfinished Basement] , ...3 more... )
• RoofDrain_Discharge_to_SS ( type: esriFieldTypeString, alias: RoofDrain_Discharge_to_SS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: RoofDrain_Discharge_to_SS )
• FoundationDrain_Discharge_to_SS ( type: esriFieldTypeString, alias: FoundationDrain_Discharge_to_SS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FoundationDrain_Discharge_to_SS )
• Curb_Box_Present ( type: esriFieldTypeString, alias: Curb_Box_Present, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Curb_Box_Present , Coded Values: [1: Yes] , [2: No] )
• PatioDrain_Discharges_to_SS ( type: esriFieldTypeString, alias: PatioDrain_Discharges_to_SS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PatioDrain_Discharges_to_SS )
• DrivewayDrain_Discharges_to_SS ( type: esriFieldTypeString, alias: DrivewayDrain_Discharges_to_SS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DrivewayDrain_Discharges_to_SS )
• WindowWellDrain_to_SS ( type: esriFieldTypeString, alias: WindowWellDrain_Discharges_to_SS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WindowWellDrain_to_SS )
• StairwellSidewalkDrain_to_SS ( type: esriFieldTypeString, alias: StairwellSidewalkDrain_Discharges_to_SS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StairwellSidewalkDrain_to_SS )
• Diverter_Valve_On_Storm_Water ( type: esriFieldTypeString, alias: Diverter_Valve_On_Storm_Water, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Diverter_Valve_On_Storm_Water )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Comment )
• Picture1 ( type: esriFieldTypeInteger, alias: Picture1, editable: true, nullable: true, defaultValue: null, modelName: Picture1 )
• Picture2 ( type: esriFieldTypeInteger, alias: Picture2, editable: true, nullable: true, defaultValue: null, modelName: Picture2 )
• Combination_Pump ( type: esriFieldTypeString, alias: Combination_Pump, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Combination_Pump )
• YardDrain_Discharges_SS ( type: esriFieldTypeString, alias: YardDrain_Discharges_SS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: YardDrain_Discharges_SS )
• SuspectConnection ( type: esriFieldTypeString, alias: SuspectConnection, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SuspectConnection )
• PermissionGranted ( type: esriFieldTypeString, alias: PermissionGranted, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PermissionGranted )
• Dye_Test_Results ( type: esriFieldTypeString, alias: Dye_Test_Results, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Dye_Test_Results )
• Dye_test_comments ( type: esriFieldTypeString, alias: Dye_test_comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: Dye_test_comments )

Templates:

• Name: PermitHistory
  Description:
  Prototype:
  Dye_Test_Results: null
  Dye_test_comments: null
  assetkey: null
  workorderid: null
  attachmentid1: null
  attachmentid2: null
  workdate: null
  workby: null
  worktype: null
  comments: null
  permittype: null
  permitnum: null
  bldgtype: null
  numberunits: null
  jobtype: null
  address: null
  hub_used: null
  sewermap: null
  contractorname: null
  contractoraddr: null
  contractorphone: null
  installer: null
  feepaid: null
  sketchadded: null
  connectfeepaid: null
  connected: null
  asbuiltrecvd: null
  occ_cert: null
  repairtype: null
  wocomments: null
  wodescription: null
  attachmentid3: null
  Work_Origin: null
  Inspection_Type: null
  Street_Name: null
  Street_No: null
  Building_Type: null
  Sewer_SubArea: null
  Map_No: null
  Line_Segment: null
  Upstream_MH: null
  Downstream_MH: null
  Owner_Contact_Name: null
  Owner_Contact_Number: null
  Inspection_Attempt: null
  Date_Historical_Flooding: null
  Source_Historical_Flooding: null
  Actions_Take_After_Flooding: null
  Foundation_Type: null
  RoofDrain_Discharge_to_SS: null
  FoundationDrain_Discharge_to_SS: null
  Curb_Box_Present: null
  PatioDrain_Discharges_to_SS: null
  DrivewayDrain_Discharges_to_SS: null
  WindowWellDrain_to_SS: null
  StairwellSidewalkDrain_to_SS: null
  Diverter_Valve_On_Storm_Water: null
  Comment: null
  Picture1: null
  Picture2: null
  Combination_Pump: null
  YardDrain_Discharges_SS: null
  SuspectConnection: null
  PermissionGranted: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata