Name: Deficiency Predictor

Display Field: deficiency_parent_record

Type: Table

Geometry Type: N/A

Description:

Service Item Id: fbda163d146947cb9ecc07cb7582358c

Copyright Text:

Default Visibility: false

MaxRecordCount: 4000

Supported Query Formats: JSON, geoJSON, PBF

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

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• globalid ( type: esriFieldTypeGUID, alias: globalid, editable: true, nullable: false, length: 38, defaultValue: {00000000-0000-0000-0000-000000000000}, modelName: globalid )
• deficiency_parent_record ( type: esriFieldTypeString, alias: deficiency_parent_record, editable: true, nullable: true, length: 255, defaultValue: null, modelName: deficiency_parent_record )
• site_id ( type: esriFieldTypeString, alias: site_id, editable: true, nullable: true, length: 255, defaultValue: null, modelName: site_id )
• site ( type: esriFieldTypeString, alias: site, editable: true, nullable: true, length: 256, defaultValue: null, modelName: site )
• building_id ( type: esriFieldTypeString, alias: building_id, editable: true, nullable: true, length: 255, defaultValue: null, modelName: building_id )
• building ( type: esriFieldTypeString, alias: building, editable: true, nullable: true, length: 256, defaultValue: null, modelName: building )
• assessment ( type: esriFieldTypeString, alias: assessment, editable: true, nullable: true, length: 255, defaultValue: null, modelName: assessment )
• reporting_system ( type: esriFieldTypeString, alias: reporting_system, editable: true, nullable: true, length: 255, defaultValue: null, modelName: reporting_system )
• system ( type: esriFieldTypeString, alias: system, editable: true, nullable: true, length: 255, defaultValue: null, modelName: system )
• subsystem ( type: esriFieldTypeString, alias: subsystem, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subsystem )
• input_component ( type: esriFieldTypeString, alias: input_component, editable: true, nullable: true, length: 255, defaultValue: null, modelName: input_component )
• subcategory ( type: esriFieldTypeString, alias: subcategory, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subcategory )
• deficiencyitem ( type: esriFieldTypeString, alias: deficiencyitem, editable: true, nullable: true, length: 255, defaultValue: null, modelName: deficiencyitem )
• unitofmeasurement ( type: esriFieldTypeString, alias: unitofmeasurement, editable: true, nullable: true, length: 255, defaultValue: null, modelName: unitofmeasurement )
• quantity ( type: esriFieldTypeInteger, alias: quantity, editable: true, nullable: true, defaultValue: null, modelName: quantity )
• UnitCost ( type: esriFieldTypeDouble, alias: UnitCost, editable: true, nullable: true, defaultValue: null, modelName: UnitCost )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost, editable: true, nullable: true, defaultValue: null, modelName: TotalCost )
• locationnote ( type: esriFieldTypeString, alias: locationnote, editable: true, nullable: true, length: 500, defaultValue: null, modelName: locationnote )
• def_comments ( type: esriFieldTypeString, alias: def_comments, editable: true, nullable: true, length: 1000, defaultValue: null, modelName: def_comments )
• priority ( type: esriFieldTypeString, alias: priority, editable: true, nullable: true, length: 255, defaultValue: null, modelName: priority )
• def_code ( type: esriFieldTypeString, alias: def_code, editable: true, nullable: true, length: 255, defaultValue: null, modelName: def_code )
• def_date_collected ( type: esriFieldTypeDate, alias: def_date_collected, editable: true, nullable: true, length: 8, defaultValue: null, modelName: def_date_collected )
• parentrowid ( type: esriFieldTypeGUID, alias: parentrowid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: parentrowid )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: Deficiency Predictor
  Description:
  Prototype:
  last_edited_user: null
  last_edited_date: null
  globalid: {00000000-0000-0000-0000-000000000000}
  deficiency_parent_record: null
  site_id: null
  site: null
  building_id: null
  building: null
  assessment: null
  reporting_system: null
  system: null
  subsystem: null
  input_component: null
  subcategory: null
  deficiencyitem: null
  unitofmeasurement: null
  quantity: null
  UnitCost: null
  TotalCost: null
  locationnote: null
  def_comments: null
  priority: null
  def_code: null
  def_date_collected: null
  parentrowid: null
  created_user: null
  created_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata