Name: StormTrak Costing G3

Display Field: TIER_TYPE

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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 )
• ID ( type: esriFieldTypeInteger, alias: ID, editable: true, nullable: false, defaultValue: null, modelName: ID )
• TIER_TYPE ( type: esriFieldTypeString, alias: TIER_TYPE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TIER_TYPE )
• SEASON ( type: esriFieldTypeString, alias: SEASON, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SEASON )
• EVENT_ID ( type: esriFieldTypeString, alias: EVENT_ID, editable: true, nullable: true, length: 200, defaultValue: null, modelName: EVENT_ID )
• GROUP1 ( type: esriFieldTypeString, alias: GROUP1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: GROUP1 )
• GROUP2 ( type: esriFieldTypeString, alias: GROUP2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: GROUP2 )
• GROUP3 ( type: esriFieldTypeString, alias: GROUP3, editable: true, nullable: true, length: 100, defaultValue: null, modelName: GROUP3 )
• RESOURCE_ASSETS ( type: esriFieldTypeInteger, alias: RESOURCE_ASSETS, editable: true, nullable: true, defaultValue: null, modelName: RESOURCE_ASSETS )
• DEPLOYED_OPEN_SHIFT ( type: esriFieldTypeDouble, alias: DEPLOYED_OPEN_SHIFT, editable: true, nullable: true, defaultValue: null, modelName: DEPLOYED_OPEN_SHIFT )
• COST_OPEN_SHIFT ( type: esriFieldTypeDouble, alias: COST_OPEN_SHIFT, editable: true, nullable: true, defaultValue: null, modelName: COST_OPEN_SHIFT )
• DEPLOYED_PRIOR_SHIFTS ( type: esriFieldTypeInteger, alias: DEPLOYED_PRIOR_SHIFTS, editable: true, nullable: true, defaultValue: null, modelName: DEPLOYED_PRIOR_SHIFTS )
• COST_PRIOR_SHIFTS ( type: esriFieldTypeDouble, alias: COST_PRIOR_SHIFTS, editable: true, nullable: true, defaultValue: null, modelName: COST_PRIOR_SHIFTS )
• CUMULATIVE_REGULAR_TIME_COSTS ( type: esriFieldTypeDouble, alias: CUMULATIVE_REGULAR_TIME_COSTS, editable: true, nullable: true, defaultValue: null, modelName: CUMULATIVE_REGULAR_TIME_COSTS )
• CUMULATIVE_OVERTIME_COSTS ( type: esriFieldTypeDouble, alias: CUMULATIVE_OVERTIME_COSTS, editable: true, nullable: true, defaultValue: null, modelName: CUMULATIVE_OVERTIME_COSTS )
• INVENTORY_BALANCE ( type: esriFieldTypeDouble, alias: INVENTORY_BALANCE, editable: true, nullable: true, defaultValue: null, modelName: INVENTORY_BALANCE )
• INVENTORY_VALUE ( type: esriFieldTypeDouble, alias: INVENTORY_VALUE, editable: true, nullable: true, defaultValue: null, modelName: INVENTORY_VALUE )
• ROAD_TREATMENT_QUANTITY_USED ( type: esriFieldTypeDouble, alias: ROAD_TREATMENT_QUANTITY_USED, editable: true, nullable: true, defaultValue: null, modelName: ROAD_TREATMENT_QUANTITY_USED )
• ROAD_TREATMENT_COST ( type: esriFieldTypeDouble, alias: ROAD_TREATMENT_COST, editable: true, nullable: true, defaultValue: null, modelName: ROAD_TREATMENT_COST )
• VEHICLE_REPAIRS ( type: esriFieldTypeInteger, alias: VEHICLE_REPAIRS, editable: true, nullable: true, defaultValue: null, modelName: VEHICLE_REPAIRS )
• TOTAL_COST ( type: esriFieldTypeDouble, alias: TOTAL_COST, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_COST )
• CHART_QUANTITY ( type: esriFieldTypeDouble, alias: CHART_QUANTITY, editable: true, nullable: true, defaultValue: null, modelName: CHART_QUANTITY )
• CHART_COST ( type: esriFieldTypeDouble, alias: CHART_COST, editable: true, nullable: true, defaultValue: null, modelName: CHART_COST )
• SWITCH ( type: esriFieldTypeString, alias: SWITCH, editable: true, nullable: true, length: 5, defaultValue: null, modelName: SWITCH )

Templates:

• Name: StormTrak Costing G3
  Description:
  Prototype:
  CHART_COST: null
  SWITCH: null
  ID: 0
  TIER_TYPE: null
  SEASON: null
  EVENT_ID: null
  GROUP1: null
  GROUP2: null
  GROUP3: null
  RESOURCE_ASSETS: null
  DEPLOYED_OPEN_SHIFT: null
  COST_OPEN_SHIFT: null
  DEPLOYED_PRIOR_SHIFTS: null
  COST_PRIOR_SHIFTS: null
  CUMULATIVE_REGULAR_TIME_COSTS: null
  CUMULATIVE_OVERTIME_COSTS: null
  INVENTORY_BALANCE: null
  INVENTORY_VALUE: null
  ROAD_TREATMENT_QUANTITY_USED: null
  ROAD_TREATMENT_COST: null
  VEHICLE_REPAIRS: null
  TOTAL_COST: null
  CHART_QUANTITY: 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