Name: Scheduled Audits

Display Field: AUDITORNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

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

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• AUDIT_ID ( type: esriFieldTypeDouble, alias: Audit ID )
• SITE_ID ( type: esriFieldTypeDouble, alias: Related Site ID )
• JOBDATE ( type: esriFieldTypeDate, alias: Date of Audit Job, length: 8 )
• JOBTYPE ( type: esriFieldTypeString, alias: Job Type, length: 200 )
• WARD ( type: esriFieldTypeString, alias: Ward, length: 200 )
• AUDITNUMBER ( type: esriFieldTypeString, alias: Audit Number, length: 200 )
• RELATEDACCOUNT ( type: esriFieldTypeDouble, alias: Related Account ID )
• AUDITORNAME ( type: esriFieldTypeString, alias: Auditor Name, length: 200 , Coded Values: [ANDREW OETMAN: ANDREW OETMAN] , [ALEX SANTOS: ALEX SANTOS] , [LAUREN LINVILLE: LAUREN LINVILLE] , ...4 more... )
• DOWNSPOUTSHAPE ( type: esriFieldTypeString, alias: Downspout Shape, length: 200 , Coded Values: [Rectangular Large: Rectangular Large] , [Rectangular small: Rectangular Small] , [Round: Round] , ...2 more... )
• DOWNSPOUTCOLOR ( type: esriFieldTypeString, alias: Downspout Color, length: 200 , Coded Values: [White: White] , [Brown: Brown] , [Tan: Tan] , ...5 more... )
• WATERSHED ( type: esriFieldTypeString, alias: Watershed, length: 200 )
• SUBWATERSHED ( type: esriFieldTypeString, alias: Sub-watershed, length: 200 )
• CASESTARTDATE ( type: esriFieldTypeDate, alias: Date Case Started, length: 8 )
• NUMBEROFDOWNSPOUTSONHOUSE ( type: esriFieldTypeDouble, alias: Number of Downspouts on House )
• NUMBEROFADDITIONALDOWNSPOUTS ( type: esriFieldTypeDouble, alias: Number of Added Downspouts )
• DOWNPOUTDRAINCONDITION ( type: esriFieldTypeString, alias: Downspout Drain Condition, length: 200 , Coded Values: [Ready for Install: Ready for Install] , [Needs Repair: Needs Repair] )
• STORMWATERMANAGEMENTPRACTICE ( type: esriFieldTypeString, alias: Stormwater Management Practice, length: 200 , Coded Values: [Yes: Yes] , [No: No] )
• STORMWATERMANAGEMENTNOTES ( type: esriFieldTypeString, alias: Stormwater Management Notes, length: 200 )
• SLOPE ( type: esriFieldTypeString, alias: Slope, length: 200 , Coded Values: [Yes: Yes] , [No: No] )
• SLOPENOTES ( type: esriFieldTypeString, alias: Slope Notes, length: 200 )
• RETAININGWALL ( type: esriFieldTypeString, alias: Retaining Wall, length: 200 , Coded Values: [Yes: Yes] , [No: No] )
• RETAININGWALLNOTES ( type: esriFieldTypeString, alias: Retaining Wall Notes, length: 200 )
• SUMPPUMP ( type: esriFieldTypeString, alias: Sump Pump, length: 200 , Coded Values: [Yes: Yes] , [No: No] )
• SUMPPUMPNOTES ( type: esriFieldTypeString, alias: Sump Pump Notes, length: 200 )
• ROOFAREA ( type: esriFieldTypeDouble, alias: Roof Area (ft) )
• IMPERVIOUSSURFACEAREA ( type: esriFieldTypeDouble, alias: Impervious Surface Area (ft) )
• DRIVEWAYSURFACETYPE ( type: esriFieldTypeString, alias: Driveway Surface Type, length: 200 , Coded Values: [Concrete: Concrete] , [Asphalt: Asphalt] , [Gravel: Gravel] , ...4 more... )
• DRIVEWAYSURFACENOTES ( type: esriFieldTypeString, alias: Driveway Surface Notes, length: 200 )
• BUILDINGTYPE ( type: esriFieldTypeString, alias: Building Type, length: 200 , Coded Values: [Single Family: Single Family] , [Row House: Row House] , [Duplex: Duplex] , ...5 more... )
• SEWERSHED ( type: esriFieldTypeString, alias: Sewershed, length: 200 )
• DOWNSPOUTDRAINAGENOTES ( type: esriFieldTypeString, alias: Downspout Drainage Notes, length: 200 )
• CONNECTDDOWNSPOUTNUMBER ( type: esriFieldTypeDouble, alias: Number Connected Downspouts )
• ISDOWNSPOUTDISCONNTOGARDEN ( type: esriFieldTypeString, alias: Downspout Garden Disconnected , length: 200 , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( type: esriFieldTypeString, alias: General Notes, length: 200 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• UPDATE_FLAG ( type: esriFieldTypeString, alias: UPDATE_FLAG, length: 1 )
• REQUESTED_BMPS ( type: esriFieldTypeString, alias: REQUESTED_BMPS, length: 200 )

Relationships:

• RS_BMPS (5) -- Related To: BMP (1)
• RS_SITES (4) -- Related To: RiverSmart Homes (0)

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

  Iteminfo   Thumbnail   Metadata