Name: Testing

Display Field: TesterName

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: dd8f3e86236f47efa6282038a0bb66d3

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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: false
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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• device_type ( type: esriFieldTypeString, alias: Device Type, length: 50 , Coded Values: [RP: RP] , [DCVA: DCVA] , [PVB: PVB] , ...5 more... )
• test_type ( type: esriFieldTypeString, alias: Test Type, length: 50 , Coded Values: [Annual: Annual Compliance] , [FollowUp: Follow-Up] , [Initial: Initial Install] , ...1 more... )
• test_result ( type: esriFieldTypeString, alias: Test Result, length: 10 , Coded Values: [Pass: Pass] , [Fail: Fail] )
• cert_number_snapshot ( type: esriFieldTypeString, alias: Cert Number (at test), length: 50 )
• cert_expiry_snapshot ( type: esriFieldTypeDate, alias: Cert Expiry (at test), length: 8 )
• cert_valid_at_test ( type: esriFieldTypeString, alias: Cert Valid at Test, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• check_valve_1_psid ( type: esriFieldTypeDouble, alias: Check Valve 1 (PSID) )
• check_valve_2_psid ( type: esriFieldTypeDouble, alias: Check Valve 2 (PSID) )
• relief_valve_open_psid ( type: esriFieldTypeDouble, alias: Relief Valve Opens (PSID) )
• air_inlet_open_psid ( type: esriFieldTypeDouble, alias: Air Inlet Opens (PSID) )
• pvb_check_valve_psid ( type: esriFieldTypeDouble, alias: PVB Check Valve (PSID) )
• air_gap_distance_in ( type: esriFieldTypeDouble, alias: Air Gap Distance (in) )
• air_gap_verified ( type: esriFieldTypeString, alias: Air Gap Verified, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• repair_actions ( type: esriFieldTypeString, alias: Repair Actions, length: 500 )
• notes ( type: esriFieldTypeString, alias: Notes, length: 255 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• DeviceGUID ( type: esriFieldTypeGUID, alias: DeviceGUID, length: 38 )
• TesterName ( type: esriFieldTypeString, alias: TesterName, length: 255 )
• test_date ( type: esriFieldTypeDate, alias: Test Date, length: 8 )
• CustomerGUID ( type: esriFieldTypeGUID, alias: CustomerGUID, length: 38 )
• Customer ( type: esriFieldTypeString, alias: Customer, length: 255 )
• GroupID ( type: esriFieldTypeString, alias: GroupID, length: 255 )
• CustomerOwnerName ( type: esriFieldTypeString, alias: CustomerOwnerName, length: 255 )
• CustomerEmail ( type: esriFieldTypeString, alias: CustomerEmail, length: 255 )
• CustomerPhone ( type: esriFieldTypeString, alias: CustomerPhone, length: 255 )
• TesterPosition ( type: esriFieldTypeString, alias: TesterPosition, length: 255 , Coded Values: [Owner: Owner] , [Manager: Manager] , [Staff: Staff] )
• OGCustomer ( type: esriFieldTypeString, alias: OGCustomer, length: 255 )

Relationships:

• BackflowDevice (2) -- Related To: BackflowDevice (0)

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

  Iteminfo   Thumbnail   Metadata