Name: Legacy Service Request Table

Display Field: Name

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: 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: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: null

Fields:

• ID ( type: esriFieldTypeDouble, alias: ID )
• SubmitDate ( type: esriFieldTypeDate, alias: SubmitDate, length: 8 )
• Division ( type: esriFieldTypeString, alias: Division, length: 255 )
• Name ( type: esriFieldTypeString, alias: Name, length: 255 )
• Email ( type: esriFieldTypeString, alias: Email, length: 255 )
• Phone ( type: esriFieldTypeString, alias: Phone, length: 255 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• StreetNum ( type: esriFieldTypeString, alias: StreetNum, length: 255 )
• Street ( type: esriFieldTypeString, alias: Street, length: 255 )
• CrossStreet ( type: esriFieldTypeString, alias: CrossStreet, length: 255 )
• SecondStreet ( type: esriFieldTypeString, alias: SecondStreet, length: 255 )
• Service ( type: esriFieldTypeString, alias: Service, length: 255 )
• Landmark ( type: esriFieldTypeString, alias: Landmark, length: 255 )
• DateAssigned ( type: esriFieldTypeDate, alias: DateAssigned, length: 8 )
• DateWorkStarted ( type: esriFieldTypeDate, alias: DateWorkStarted, length: 8 )
• DateDue ( type: esriFieldTypeDate, alias: DateDue, length: 8 )
• DateResolved ( type: esriFieldTypeDate, alias: DateResolved, length: 8 )
• ActionTaken ( type: esriFieldTypeString, alias: ActionTaken, length: 255 )
• CloseComments ( type: esriFieldTypeString, alias: CloseComments, length: 255 )
• Responder ( type: esriFieldTypeString, alias: Responder, length: 255 )
• Status ( type: esriFieldTypeString, alias: Status, length: 255 )
• UserName ( type: esriFieldTypeString, alias: UserName, length: 255 )
• AssignedTo ( type: esriFieldTypeDouble, alias: AssignedTo )
• Equipment ( type: esriFieldTypeString, alias: Equipment, length: 255 )
• Labor ( type: esriFieldTypeString, alias: Labor, length: 255 )
• Billing ( type: esriFieldTypeDouble, alias: Billing )
• Billed ( type: esriFieldTypeDouble, alias: Billed )
• Materials ( type: esriFieldTypeString, alias: Materials, length: 255 )
• ConAdd ( type: esriFieldTypeString, alias: ConAdd, length: 255 )
• ObjectID ( type: esriFieldTypeOID, alias: ObjectID )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Relationships:

• EastLongmeadowGIS.dbo.IMC_JOINGEOCODE (0) -- Related To: Legacy Service Request (0)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata