View In:   ArcGIS Online Map Viewer

Name: All Completed Tasks

Display Field: CompletedByFirstName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 8348677b4e5c4e8086fa667781164e82

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 2168851.325165479
YMin: 1231111.3871512376
XMax: 2172074.416122341
YMax: 1238211.009146838
Spatial Reference: 102667  (2240)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• ServiceOrderDetailID ( type: esriFieldTypeInteger, alias: ServiceOrderDetailID, editable: true, nullable: false, defaultValue: null, modelName: ServiceOrderDetailID )
• CreatedByID ( type: esriFieldTypeInteger, alias: CreatedByID, editable: true, nullable: true, defaultValue: null, modelName: CreatedByID )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: false, length: 8, defaultValue: null, modelName: DateCreated )
• ScheduledStartDate ( type: esriFieldTypeDate, alias: ScheduledStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ScheduledStartDate )
• ScheduledEndDate ( type: esriFieldTypeDate, alias: ScheduledEndDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ScheduledEndDate )
• ActualStartDate ( type: esriFieldTypeDate, alias: ActualStartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ActualStartDate )
• ActualEndDate ( type: esriFieldTypeDate, alias: ActualEndDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ActualEndDate )
• Priority ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Priority )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status )
• TaskType ( type: esriFieldTypeString, alias: TaskType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TaskType )
• Completed ( type: esriFieldTypeSmallInteger, alias: Completed, editable: true, nullable: false, defaultValue: null, modelName: Completed )
• IsWorkItemType ( type: esriFieldTypeSmallInteger, alias: IsWorkItemType, editable: true, nullable: true, defaultValue: null, modelName: IsWorkItemType )
• ServiceOrderNumber ( type: esriFieldTypeString, alias: ServiceOrderNumber, editable: true, nullable: false, length: 50, defaultValue: null, modelName: ServiceOrderNumber )
• ServiceOrderID ( type: esriFieldTypeInteger, alias: ServiceOrderID, editable: true, nullable: false, defaultValue: null, modelName: ServiceOrderID )
• IsLocation ( type: esriFieldTypeSmallInteger, alias: IsLocation, editable: true, nullable: true, defaultValue: null, modelName: IsLocation )
• LocationID ( type: esriFieldTypeString, alias: LocationID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: LocationID )
• LocationNo ( type: esriFieldTypeString, alias: LocationNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationNo )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Location )
• IsCustomer ( type: esriFieldTypeSmallInteger, alias: IsCustomer, editable: true, nullable: true, defaultValue: null, modelName: IsCustomer )
• CustomerID ( type: esriFieldTypeString, alias: CustomerID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CustomerID )
• CustomerNo ( type: esriFieldTypeString, alias: CustomerNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CustomerNo )
• Customer ( type: esriFieldTypeString, alias: Customer, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Customer )
• IsService ( type: esriFieldTypeSmallInteger, alias: IsService, editable: true, nullable: true, defaultValue: null, modelName: IsService )
• ServiceID ( type: esriFieldTypeString, alias: ServiceID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ServiceID )
• Service ( type: esriFieldTypeString, alias: Service, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Service )
• IsMeter ( type: esriFieldTypeSmallInteger, alias: IsMeter, editable: true, nullable: true, defaultValue: null, modelName: IsMeter )
• MeterID ( type: esriFieldTypeString, alias: MeterID, editable: true, nullable: true, length: 250, defaultValue: null, modelName: MeterID )
• MeterNo ( type: esriFieldTypeString, alias: MeterNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MeterNo )
• IsGISAsset ( type: esriFieldTypeSmallInteger, alias: IsGISAsset, editable: true, nullable: true, defaultValue: null, modelName: IsGISAsset )
• GISFileID ( type: esriFieldTypeInteger, alias: GISFileID, editable: true, nullable: true, defaultValue: null, modelName: GISFileID )
• GISLayer ( type: esriFieldTypeString, alias: GISLayer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GISLayer )
• IsAsset ( type: esriFieldTypeSmallInteger, alias: IsAsset, editable: true, nullable: true, defaultValue: null, modelName: IsAsset )
• SchemaDocGuid ( type: esriFieldTypeGUID, alias: SchemaDocGuid, editable: true, nullable: true, length: 38, defaultValue: null, modelName: SchemaDocGuid )
• UtilityBillingServiceCodeTypeID ( type: esriFieldTypeInteger, alias: UtilityBillingServiceCodeTypeID, editable: true, nullable: true, defaultValue: null, modelName: UtilityBillingServiceCodeTypeID )
• IsUtilityBillingServiceOrder ( type: esriFieldTypeSmallInteger, alias: IsUtilityBillingServiceOrder, editable: true, nullable: true, defaultValue: null, modelName: IsUtilityBillingServiceOrder )
• FeePosted ( type: esriFieldTypeSmallInteger, alias: FeePosted, editable: true, nullable: true, defaultValue: null, modelName: FeePosted )
• PriorityColor ( type: esriFieldTypeString, alias: PriorityColor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PriorityColor )
• FeeAmount ( type: esriFieldTypeDouble, alias: FeeAmount, editable: true, nullable: true, defaultValue: null, modelName: FeeAmount )
• BillToAccount ( type: esriFieldTypeString, alias: BillToAccount, editable: true, nullable: true, length: 250, defaultValue: null, modelName: BillToAccount )
• CompletedByFirstName ( type: esriFieldTypeString, alias: CompletedByFirstName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CompletedByFirstName )
• CompletedByLast ( type: esriFieldTypeString, alias: CompletedByLast, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CompletedByLast )
• LastModifiedByID ( type: esriFieldTypeInteger, alias: LastModifiedByID, editable: true, nullable: true, defaultValue: null, modelName: LastModifiedByID )
• LastModified ( type: esriFieldTypeDate, alias: LastModified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastModified )
• PriorityID ( type: esriFieldTypeInteger, alias: PriorityID, editable: true, nullable: true, defaultValue: null, modelName: PriorityID )
• StatusID ( type: esriFieldTypeInteger, alias: StatusID, editable: true, nullable: true, defaultValue: null, modelName: StatusID )
• TaskTypeID ( type: esriFieldTypeInteger, alias: TaskTypeID, editable: true, nullable: true, defaultValue: null, modelName: TaskTypeID )
• ServiceOrderDetailTypeID ( type: esriFieldTypeInteger, alias: ServiceOrderDetailTypeID, editable: true, nullable: true, defaultValue: null, modelName: ServiceOrderDetailTypeID )
• LOC_Address ( type: esriFieldTypeString, alias: LOC_Address, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LOC_Address )
• LOC_City ( type: esriFieldTypeString, alias: LOC_City, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LOC_City )
• CUST_Name ( type: esriFieldTypeString, alias: CUST_Name, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CUST_Name )
• GIS_AssetTag ( type: esriFieldTypeString, alias: GIS_AssetTag, editable: true, nullable: true, length: 500, defaultValue: null, modelName: GIS_AssetTag )
• AssetNo ( type: esriFieldTypeInteger, alias: AssetNo, editable: true, nullable: true, defaultValue: null, modelName: AssetNo )
• ASSET_AssetTag ( type: esriFieldTypeString, alias: ASSET_AssetTag, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ASSET_AssetTag )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetID )
• AssetLocation ( type: esriFieldTypeString, alias: AssetLocation, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: AssetLocation )
• AssetStatus ( type: esriFieldTypeString, alias: AssetStatus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetStatus )
• AssetType ( type: esriFieldTypeString, alias: AssetType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetType )
• TaskAssignmentCrews ( type: esriFieldTypeString, alias: TaskAssignmentCrews, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TaskAssignmentCrews )
• TaskAssignmentUsers ( type: esriFieldTypeString, alias: TaskAssignmentUsers, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TaskAssignmentUsers )
• TaskAssignmentContacts ( type: esriFieldTypeString, alias: TaskAssignmentContacts, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TaskAssignmentContacts )
• GISAssetNo ( type: esriFieldTypeString, alias: GISAssetNo, editable: true, nullable: true, length: 250, defaultValue: null, modelName: GISAssetNo )
• DivisionID ( type: esriFieldTypeInteger, alias: DivisionID, editable: true, nullable: false, defaultValue: null, modelName: DivisionID )
• Expr1 ( type: esriFieldTypeInteger, alias: Expr1, editable: true, nullable: true, defaultValue: null, modelName: Expr1 )
• NoteCount ( type: esriFieldTypeInteger, alias: NoteCount, editable: true, nullable: true, defaultValue: null, modelName: NoteCount )
• Division ( type: esriFieldTypeString, alias: Division, editable: true, nullable: false, length: 250, defaultValue: null, modelName: Division )
• Problem ( type: esriFieldTypeString, alias: Problem, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Problem )
• ResourcesCount ( type: esriFieldTypeInteger, alias: ResourcesCount, editable: true, nullable: true, defaultValue: null, modelName: ResourcesCount )
• ServiceOrderCategory ( type: esriFieldTypeString, alias: ServiceOrderCategory, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ServiceOrderCategory )
• ServiceOrderDescription ( type: esriFieldTypeString, alias: ServiceOrderDescription, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ServiceOrderDescription )
• Type ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Type )
• Resolution ( type: esriFieldTypeString, alias: Resolution, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Resolution )
• Total_Labor_Hours ( type: esriFieldTypeDouble, alias: Total_Labor_Hours, editable: true, nullable: true, defaultValue: null, modelName: Total_Labor_Hours )
• Total_Labor_Cost ( type: esriFieldTypeDouble, alias: Total_Labor_Cost, editable: true, nullable: true, defaultValue: null, modelName: Total_Labor_Cost )
• Total_Inventory_fCost ( type: esriFieldTypeDouble, alias: Total_Inventory_fCost, editable: true, nullable: true, defaultValue: null, modelName: Total_Inventory_fCost )
• TaskID ( type: esriFieldTypeOID, alias: TaskID, editable: false, nullable: false, defaultValue: null, modelName: TaskID )

Templates:

• Name: All Completed Tasks
  Description:
  Prototype:
  Total_Inventory_fCost: null
  ServiceOrderDetailID: 0
  CreatedByID: null
  DateCreated: -2209161600000
  ScheduledStartDate: null
  ScheduledEndDate: null
  ActualStartDate: null
  ActualEndDate: null
  Priority: null
  Status: null
  TaskType: null
  Completed: 0
  IsWorkItemType: null
  ServiceOrderNumber:
  ServiceOrderID: 0
  IsLocation: null
  LocationID: null
  LocationNo: null
  Location: null
  IsCustomer: null
  CustomerID: null
  CustomerNo: null
  Customer: null
  IsService: null
  ServiceID: null
  Service: null
  IsMeter: null
  MeterID: null
  MeterNo: null
  IsGISAsset: null
  GISFileID: null
  GISLayer: null
  IsAsset: null
  SchemaDocGuid: null
  UtilityBillingServiceCodeTypeID: null
  IsUtilityBillingServiceOrder: null
  FeePosted: null
  PriorityColor: null
  FeeAmount: null
  BillToAccount: null
  CompletedByFirstName: null
  CompletedByLast: null
  LastModifiedByID: null
  LastModified: null
  PriorityID: null
  StatusID: null
  TaskTypeID: null
  ServiceOrderDetailTypeID: null
  LOC_Address: null
  LOC_City: null
  CUST_Name: null
  GIS_AssetTag: null
  AssetNo: null
  ASSET_AssetTag: null
  AssetID: null
  AssetLocation: null
  AssetStatus: null
  AssetType: null
  TaskAssignmentCrews: null
  TaskAssignmentUsers: null
  TaskAssignmentContacts: null
  GISAssetNo: null
  DivisionID: 0
  Expr1: null
  NoteCount: null
  Division:
  Problem: null
  ResourcesCount: null
  ServiceOrderCategory: null
  ServiceOrderDescription: null
  Type: null
  Resolution: null
  Total_Labor_Hours: null
  Total_Labor_Cost: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata