Name: Inspection Form

Display Field: InspectorName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• OwnerContact ( type: esriFieldTypeString, alias: Owner / Contact, length: 255 )
• PhoneNo ( type: esriFieldTypeString, alias: Phone No, length: 255 )
• AddressLocation ( type: esriFieldTypeString, alias: Address, length: 255 )
• InspDate ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• InspectorName ( type: esriFieldTypeString, alias: Inspector's Name, length: 255 )
• InspType ( type: esriFieldTypeSmallInteger, alias: Inspection Type , Coded Values: [1: Initial Inspection] , [2: Renewal Inspection] , [3: Re-Inspection] )
• CCCPClass ( type: esriFieldTypeSmallInteger, alias: Class , Coded Values: [1: Residential] , [2: Commercial] , [3: Non-CCCP Lot] , ...1 more... )
• HazardType ( type: esriFieldTypeSmallInteger, alias: Hazard Type , Coded Values: [1: Low] , [2: High] )
• HeatSource ( type: esriFieldTypeSmallInteger, alias: Heat Source , Coded Values: [1: Forced Air] , [2: Boiler (protected)] , [3: Boiler (unprotected)] , ...1 more... )
• Question1 ( type: esriFieldTypeSmallInteger, alias: Question 1: Is there any type of secondary water supply within the property? , Coded Values: [0: No] , [1: Yes] )
• Q1SurfaceWater ( type: esriFieldTypeSmallInteger, alias: Surface Water , Coded Values: [0: No] , [1: Yes] )
• Q1WellSupply ( type: esriFieldTypeSmallInteger, alias: Well supply , Coded Values: [0: No] , [1: Yes] )
• Q1StorageTank ( type: esriFieldTypeSmallInteger, alias: Storage tank , Coded Values: [0: No] , [1: Yes] )
• Q1Recirculated ( type: esriFieldTypeSmallInteger, alias: Recirculated , Coded Values: [0: No] , [1: Yes] )
• Q1Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments , Coded Values: [0: No] , [1: Yes] )
• Question2 ( type: esriFieldTypeSmallInteger, alias: Question 2: Are there any cross connections by submerged inlet? , Coded Values: [0: No] , [1: Yes] )
• Q2Boiler ( type: esriFieldTypeSmallInteger, alias: Boilers , Coded Values: [0: No] , [1: Yes] )
• Q2Lab ( type: esriFieldTypeSmallInteger, alias: Laboratories , Coded Values: [0: No] , [1: Yes] )
• Q2Sprinkler ( type: esriFieldTypeSmallInteger, alias: Lawn sprinkling system , Coded Values: [0: No] , [1: Yes] )
• Q2Autopsy ( type: esriFieldTypeSmallInteger, alias: Autopsy / mortuary table , Coded Values: [0: No] , [1: Yes] )
• Q2Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments , Coded Values: [0: No] , [1: Yes] )
• Question3 ( type: esriFieldTypeSmallInteger, alias: Question 3: Are there any cross connections with piping which may contain sanitary water or a waste or a chemical contaminate? , Coded Values: [0: No] , [1: Yes] )
• Q3FireProtection ( type: esriFieldTypeSmallInteger, alias: Piping for fire protection , Coded Values: [0: No] , [1: Yes] )
• Q3Softner ( type: esriFieldTypeSmallInteger, alias: Equipment drained to sewer-water softner , Coded Values: [0: No] , [1: Yes] )
• Q3Refrigeration ( type: esriFieldTypeSmallInteger, alias: Refrigeration system , Coded Values: [0: No] , [1: Yes] )
• Q3Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments , Coded Values: [0: No] , [1: Yes] )
• Question4 ( type: esriFieldTypeSmallInteger, alias: Question 4: Are there any cross connections with piping immersed in a tank or vessel? , Coded Values: [0: No] , [1: Yes] )
• Q4ComLaundry ( type: esriFieldTypeSmallInteger, alias: Commerical laundry , Coded Values: [0: No] , [1: Yes] )
• Q4SteamLines ( type: esriFieldTypeSmallInteger, alias: Steam lines to keep storage tank from freezing , Coded Values: [0: No] , [1: Yes] )
• Q4Coils ( type: esriFieldTypeSmallInteger, alias: Coils within plating or rinse tanks , Coded Values: [0: No] , [1: Yes] )
• Q4Other ( type: esriFieldTypeSmallInteger, alias: Other, see comments , Coded Values: [0: No] , [1: Yes] )
• Question5 ( type: esriFieldTypeSmallInteger, alias: Question 5: Are any hoses connected to possible contaminates? , Coded Values: [1: No] , [2: Yes - Protected by an approved vacuum breaker] , [3: Yes - NOT protected] )
• Question6 ( type: esriFieldTypeSmallInteger, alias: Question 6: Is the potable water supply within the propert satisfactory? , Coded Values: [0: No] , [1: Yes] )
• AirGap ( type: esriFieldTypeSmallInteger, alias: Air Gaps , Coded Values: [0: No] , [1: Yes] )
• VacuumBr ( type: esriFieldTypeSmallInteger, alias: Vacuum Breakers , Coded Values: [0: No] , [1: Yes] )
• PressureVaccuumBr ( type: esriFieldTypeSmallInteger, alias: Pressure Vaccuum Breaker , Coded Values: [0: No] , [1: Yes] )
• DoubleCkValveAssy ( type: esriFieldTypeSmallInteger, alias: Double Check Valve Assy , Coded Values: [0: No] , [1: Yes] )
• VentedDouble_Ck ( type: esriFieldTypeSmallInteger, alias: Vented Double Check , Coded Values: [0: No] , [1: Yes] )
• RPZ ( type: esriFieldTypeSmallInteger, alias: RPZ , Coded Values: [0: No] , [1: Yes] )
• RPDA ( type: esriFieldTypeSmallInteger, alias: RPDA , Coded Values: [0: No] , [1: Yes] )
• Question8 ( type: esriFieldTypeSmallInteger, alias: Question 8: Any required protection? , Coded Values: [0: No] , [1: Yes] )
• ReqProtection ( type: esriFieldTypeString, alias: Required Protection:, length: 400 )
• InspFreq ( type: esriFieldTypeSmallInteger, alias: Inspection Frequency? , Coded Values: [1: 1] , [3: 3] , [10: 10] )
• MainLinContain ( type: esriFieldTypeSmallInteger, alias: Main Line Containment? , Coded Values: [0: No] , [1: Yes] )
• InspOutcome ( type: esriFieldTypeSmallInteger, alias: Inspection Outcome , Coded Values: [1: Approved] , [2: Failed] )
• HBVBTotal ( type: esriFieldTypeSmallInteger, alias: # HBVB Given , Coded Values: [0: 0] , [1: 1] , [2: 2] , ...8 more... )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 400 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Related_GlobalID ( type: esriFieldTypeGUID, alias: Related_GlobalID, length: 38 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Relationships:

• DBO.CCCPAccounts (1) -- Related To: CCCP Accounts (8)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata