Name: jobs

Display Field: job_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1a2f034f406f4353b59b1f19961c0b92

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: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• job_id ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: jobId, alias: jobId )
• job_name ( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: jobName, alias: jobName )
• parent_job ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: parent_job, alias: parent_job )
• description ( nullable: true, editable: true, defaultValue: null, length: 2000, type: esriFieldTypeString, modelName: description, alias: description )
• notes ( nullable: true, editable: true, defaultValue: null, length: 5000, type: esriFieldTypeString, modelName: notes, alias: notes )
• owned_by ( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: ownedBy, alias: ownedBy )
• created_by ( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: createdBy, alias: createdBy )
• start_date ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: start_date, alias: start_date )
• started_date ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: started_date, alias: started_date )
• due_date ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: due_date, alias: due_date )
• end_date ( nullable: true, editable: true, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: end_date, alias: end_date )
• percent_complete ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeDouble, modelName: percentComplete, alias: percentComplete )
• priority_rank ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeSmallInteger, modelName: priorityRank, alias: priorityRank )
• job_status ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: jobStatus, alias: jobStatus )
• diagram ( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: diagram, alias: diagram )
• diagram_version ( nullable: true, editable: true, defaultValue: null, type: esriFieldTypeInteger, modelName: diagramVersion, alias: diagramVersion )
• job_template_id ( nullable: true, editable: true, defaultValue: null, length: 50, type: esriFieldTypeString, modelName: featureLayerSchemaId, alias: jobTemplateId )
• closed ( nullable: false, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: closed, alias: closed , Coded Values: [0: No] , [1: Yes] )
• active_versions ( nullable: true, editable: true, defaultValue: null, length: 10000, type: esriFieldTypeString, modelName: activeVersions, alias: active_versions )
• has_location ( nullable: true, editable: true, defaultValue: 0, type: esriFieldTypeSmallInteger, modelName: has_location, alias: hasLocation , Coded Values: [0: No] , [1: Yes] )
• parent_job_ref_id ( nullable: true, editable: true, defaultValue: null, length: 200, type: esriFieldTypeString, modelName: parent_job_ref_id, alias: parentJobRefId )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: created_user, alias: created_user )
• created_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: created_date, alias: created_date )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, type: esriFieldTypeString, modelName: last_edited_user, alias: last_edited_user )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, length: 29, type: esriFieldTypeDate, modelName: last_edited_date, alias: last_edited_date )

Templates:

• Name: jobs
  Description:
  Prototype:
  end_date: null
  priority_rank: null
  notes: null
  parent_job: null
  due_date: null
  description: null
  owned_by: null
  parent_job_ref_id: null
  started_date: null
  created_by: null
  job_template_id: null
  percent_complete: null
  active_versions: null
  diagram: null
  job_status: null
  diagram_version: null
  job_name: null
  job_id: null
  closed: 0
  has_location: 0
  start_date: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata