View In:   ArcGIS Online Map Viewer

Name: All Requests

Display Field: CompletedByFirstName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: dbo.GIS_Requests_207

Service Item Id: a5a2c776d0eb45df820c32d8601e21c7

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

Supports Datum Transformation: true

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326  (4326)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [104, 44, 160, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• RequestID ( type: esriFieldTypeOID, alias: RequestID, editable: false, nullable: false, defaultValue: null, modelName: RequestID )
• RequestTypeID ( type: esriFieldTypeInteger, alias: RequestTypeID, editable: true, nullable: false, defaultValue: null, modelName: RequestTypeID )
• RequestType ( type: esriFieldTypeString, alias: RequestType, editable: true, nullable: false, length: 500, defaultValue: null, modelName: RequestType )
• RequestStatusID ( type: esriFieldTypeInteger, alias: RequestStatusID, editable: true, nullable: false, defaultValue: null, modelName: RequestStatusID )
• RequestStatus ( type: esriFieldTypeString, alias: RequestStatus, editable: true, nullable: false, length: 500, defaultValue: null, modelName: RequestStatus )
• DivisionID ( type: esriFieldTypeInteger, alias: DivisionID, editable: true, nullable: false, defaultValue: null, modelName: DivisionID )
• Division ( type: esriFieldTypeString, alias: Division, editable: true, nullable: false, length: 250, defaultValue: null, modelName: Division )
• SubmissionBy ( type: esriFieldTypeString, alias: SubmissionBy, editable: true, nullable: false, length: 2500, defaultValue: null, modelName: SubmissionBy )
• SubmissionByEmail ( type: esriFieldTypeString, alias: SubmissionByEmail, editable: true, nullable: true, length: 2500, defaultValue: null, modelName: SubmissionByEmail )
• Subject ( type: esriFieldTypeString, alias: Subject, editable: true, nullable: false, length: 2500, defaultValue: null, modelName: Subject )
• Problem ( type: esriFieldTypeString, alias: Problem, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Problem )
• Resolution ( type: esriFieldTypeString, alias: Resolution, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Resolution )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: false, length: 8, defaultValue: null, precision: 1, modelName: DateCreated )
• LastUpdated ( type: esriFieldTypeDate, alias: LastUpdated, editable: true, nullable: false, length: 8, defaultValue: null, precision: 1, modelName: LastUpdated )
• Completed ( type: esriFieldTypeSmallInteger, alias: Completed, editable: true, nullable: false, defaultValue: null, modelName: Completed )
• DateCompleted ( type: esriFieldTypeDate, alias: DateCompleted, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: DateCompleted )
• CompletedByFirstName ( type: esriFieldTypeString, alias: CompletedByFirstName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CompletedByFirstName )
• CompletedByLastName ( type: esriFieldTypeString, alias: CompletedByLastName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CompletedByLastName )
• Cancelled ( type: esriFieldTypeSmallInteger, alias: Cancelled, editable: true, nullable: false, defaultValue: null, modelName: Cancelled )
• LocationNo ( type: esriFieldTypeString, alias: LocationNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LocationNo )
• 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 )
• CustomerNo ( type: esriFieldTypeString, alias: CustomerNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CustomerNo )
• CUST_Name ( type: esriFieldTypeString, alias: CUST_Name, editable: true, nullable: true, length: 500, defaultValue: null, modelName: CUST_Name )
• CUST_Phone1 ( type: esriFieldTypeString, alias: CUST_Phone1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CUST_Phone1 )
• Service ( type: esriFieldTypeString, alias: Service, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Service )
• 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 )
• GISAssetNo ( type: esriFieldTypeString, alias: GISAssetNo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GISAssetNo )
• GISFeatureLabel ( type: esriFieldTypeString, alias: GISFeatureLabel, editable: true, nullable: true, length: 500, defaultValue: null, modelName: GISFeatureLabel )
• EXSLayerID ( type: esriFieldTypeInteger, alias: EXSLayerID, editable: true, nullable: true, defaultValue: null, modelName: EXSLayerID )
• EXSLayerName ( type: esriFieldTypeString, alias: EXSLayerName, editable: true, nullable: true, length: 250, defaultValue: null, modelName: EXSLayerName )
• 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 )
• FacilityID ( type: esriFieldTypeInteger, alias: FacilityID, editable: true, nullable: true, defaultValue: null, modelName: FacilityID )
• Facility ( type: esriFieldTypeString, alias: Facility, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Facility )
• Facility_Full_Location ( type: esriFieldTypeString, alias: Facility_Full_Location, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Facility_Full_Location )
• BillableLaborHoursTotal ( type: esriFieldTypeDouble, alias: BillableLaborHoursTotal, editable: true, nullable: true, defaultValue: null, modelName: BillableLaborHoursTotal )
• BillableLaborTotal ( type: esriFieldTypeDouble, alias: BillableLaborTotal, editable: true, nullable: true, defaultValue: null, modelName: BillableLaborTotal )
• NonBillableLaborHoursTotal ( type: esriFieldTypeDouble, alias: NonBillableLaborHoursTotal, editable: true, nullable: true, defaultValue: null, modelName: NonBillableLaborHoursTotal )
• NonBillableLaborTotal ( type: esriFieldTypeDouble, alias: NonBillableLaborTotal, editable: true, nullable: true, defaultValue: null, modelName: NonBillableLaborTotal )
• LaborHoursTotal ( type: esriFieldTypeDouble, alias: LaborHoursTotal, editable: true, nullable: true, defaultValue: null, modelName: LaborHoursTotal )
• LaborTotal ( type: esriFieldTypeDouble, alias: LaborTotal, editable: true, nullable: true, defaultValue: null, modelName: LaborTotal )
• LaborCostTotal ( type: esriFieldTypeDouble, alias: LaborCostTotal, editable: true, nullable: true, defaultValue: null, modelName: LaborCostTotal )
• BillableInventoryTotal ( type: esriFieldTypeDouble, alias: BillableInventoryTotal, editable: true, nullable: true, defaultValue: null, modelName: BillableInventoryTotal )
• NonBillableInventoryTotal ( type: esriFieldTypeDouble, alias: NonBillableInventoryTotal, editable: true, nullable: true, defaultValue: null, modelName: NonBillableInventoryTotal )
• InventoryTotal ( type: esriFieldTypeDouble, alias: InventoryTotal, editable: true, nullable: true, defaultValue: null, modelName: InventoryTotal )
• InventoryCostTotal ( type: esriFieldTypeDouble, alias: InventoryCostTotal, editable: true, nullable: true, defaultValue: null, modelName: InventoryCostTotal )
• BillableContractorTotal ( type: esriFieldTypeDouble, alias: BillableContractorTotal, editable: true, nullable: true, defaultValue: null, modelName: BillableContractorTotal )
• NonBillableContractorTotal ( type: esriFieldTypeDouble, alias: NonBillableContractorTotal, editable: true, nullable: true, defaultValue: null, modelName: NonBillableContractorTotal )
• ContractorTotal ( type: esriFieldTypeDouble, alias: ContractorTotal, editable: true, nullable: true, defaultValue: null, modelName: ContractorTotal )
• BillableEquipmentTotal ( type: esriFieldTypeDouble, alias: BillableEquipmentTotal, editable: true, nullable: true, defaultValue: null, modelName: BillableEquipmentTotal )
• NonBillableEquipmentTotal ( type: esriFieldTypeDouble, alias: NonBillableEquipmentTotal, editable: true, nullable: true, defaultValue: null, modelName: NonBillableEquipmentTotal )
• EquipmentTotal ( type: esriFieldTypeDouble, alias: EquipmentTotal, editable: true, nullable: true, defaultValue: null, modelName: EquipmentTotal )
• BillableRequestTotal ( type: esriFieldTypeDouble, alias: BillableRequestTotal, editable: true, nullable: true, defaultValue: null, modelName: BillableRequestTotal )
• NonBillableRequestTotal ( type: esriFieldTypeDouble, alias: NonBillableRequestTotal, editable: true, nullable: true, defaultValue: null, modelName: NonBillableRequestTotal )
• RequestTotal ( type: esriFieldTypeDouble, alias: RequestTotal, editable: true, nullable: true, defaultValue: null, modelName: RequestTotal )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• SRID ( type: esriFieldTypeInteger, alias: SRID, editable: true, nullable: true, defaultValue: null, modelName: SRID )

Templates:

• Name: All Requests
  Description:
  Prototype:
  Y_COORD: null
  RequestTypeID: 0
  RequestType:
  RequestStatusID: 0
  RequestStatus:
  DivisionID: 0
  Division:
  SubmissionBy:
  SubmissionByEmail: null
  Subject:
  Problem: null
  Resolution: null
  DateCreated: -2209161600000
  LastUpdated: -2209161600000
  Completed: 0
  DateCompleted: null
  CompletedByFirstName: null
  CompletedByLastName: null
  Cancelled: 0
  LocationNo: null
  LOC_Address: null
  LOC_City: null
  CustomerNo: null
  CUST_Name: null
  CUST_Phone1: null
  Service: null
  MeterID: null
  MeterNo: null
  GISAssetNo: null
  GISFeatureLabel: null
  EXSLayerID: null
  EXSLayerName: null
  AssetNo: null
  ASSET_AssetTag: null
  FacilityID: null
  Facility: null
  Facility_Full_Location: null
  BillableLaborHoursTotal: null
  BillableLaborTotal: null
  NonBillableLaborHoursTotal: null
  NonBillableLaborTotal: null
  LaborHoursTotal: null
  LaborTotal: null
  LaborCostTotal: null
  BillableInventoryTotal: null
  NonBillableInventoryTotal: null
  InventoryTotal: null
  InventoryCostTotal: null
  BillableContractorTotal: null
  NonBillableContractorTotal: null
  ContractorTotal: null
  BillableEquipmentTotal: null
  NonBillableEquipmentTotal: null
  EquipmentTotal: null
  BillableRequestTotal: null
  NonBillableRequestTotal: null
  RequestTotal: null
  X_COORD: null
  SRID: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Child Resources:   Field Groups   Contingent Values

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