Name: FreshServiceTickets

Display Field: AgentName

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 100000

Supported Query Formats: JSON, PBF

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: esriFieldTypeOID, alias: ID )
• Service_ID ( type: esriFieldTypeString, alias: Service_ID, length: 20 )
• Priority ( type: esriFieldTypeString, alias: Priority, length: 20 )
• LastUpdatedDate ( type: esriFieldTypeDate, alias: LastUpdatedDate, length: 8 )
• AgentName ( type: esriFieldTypeString, alias: AgentName, length: 100 )
• Urgency ( type: esriFieldTypeString, alias: Urgency, length: 20 )
• Status ( type: esriFieldTypeString, alias: Status, length: 20 )
• FirstResponseDate ( type: esriFieldTypeDate, alias: FirstResponseDate, length: 8 )
• Category ( type: esriFieldTypeString, alias: Category, length: 20 )
• ItemCategory ( type: esriFieldTypeString, alias: ItemCategory, length: 50 )
• AgentGroupName ( type: esriFieldTypeString, alias: AgentGroupName, length: 50 )
• ChildTicketsCount ( type: esriFieldTypeInteger, alias: ChildTicketsCount )
• Impact ( type: esriFieldTypeString, alias: Impact, length: 20 )
• AssignedDate ( type: esriFieldTypeDate, alias: AssignedDate, length: 8 )
• PublicNotesCount ( type: esriFieldTypeInteger, alias: PublicNotesCount )
• AgentReplyCount ( type: esriFieldTypeInteger, alias: AgentReplyCount )
• TotalQuantity ( type: esriFieldTypeInteger, alias: TotalQuantity )
• Subject ( type: esriFieldTypeString, alias: Subject, length: 1000 )
• FtContactResolutionViolated ( type: esriFieldTypeString, alias: FtContactResolutionViolated, length: 20 )
• FtResponseEscalated ( type: esriFieldTypeString, alias: FtResponseEscalated, length: 20 )
• CustomerReplyCount ( type: esriFieldTypeInteger, alias: CustomerReplyCount )
• ResolutionTimeinBhrs ( type: esriFieldTypeDouble, alias: ResolutionTimeinBhrs )
• AgentReassignCount ( type: esriFieldTypeInteger, alias: AgentReassignCount )
• GroupReassignCount ( type: esriFieldTypeInteger, alias: GroupReassignCount )
• TotalCost ( type: esriFieldTypeDouble, alias: TotalCost )
• SubCategory ( type: esriFieldTypeString, alias: SubCategory, length: 50 )
• PrivateNotesCount ( type: esriFieldTypeInteger, alias: PrivateNotesCount )
• Dueby ( type: esriFieldTypeDate, alias: Dueby, length: 8 )
• TaskCount ( type: esriFieldTypeInteger, alias: TaskCount )
• Source ( type: esriFieldTypeString, alias: Source, length: 20 )
• FtResponseTimeinChrs ( type: esriFieldTypeDouble, alias: FtResponseTimeinChrs )
• Type ( type: esriFieldTypeString, alias: Type, length: 50 )
• FirstResponseduein ( type: esriFieldTypeDate, alias: FirstResponseduein, length: 8 )
• ResolutionEscalated ( type: esriFieldTypeString, alias: ResolutionEscalated, length: 20 )
• ReopenCount ( type: esriFieldTypeInteger, alias: ReopenCount )
• AvgResponseTimeinBhrs ( type: esriFieldTypeDouble, alias: AvgResponseTimeinBhrs )
• MergedTicket ( type: esriFieldTypeString, alias: MergedTicket, length: 20 )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, length: 8 )
• AvgResponseTime ( type: esriFieldTypeDouble, alias: AvgResponseTime )
• FtResponseStatus ( type: esriFieldTypeString, alias: FtResponseStatus, length: 50 )
• FtResponseTimeinBhrs ( type: esriFieldTypeDouble, alias: FtResponseTimeinBhrs )
• AssociatedAssetsCount ( type: esriFieldTypeInteger, alias: AssociatedAssetsCount )
• ApprovalStatus ( type: esriFieldTypeString, alias: ApprovalStatus, length: 50 )
• ResolvedDate ( type: esriFieldTypeDate, alias: ResolvedDate, length: 8 )
• ClosedDate ( type: esriFieldTypeDate, alias: ClosedDate, length: 8 )
• AlternateContactNumber ( type: esriFieldTypeString, alias: AlternateContactNumber, length: 20 )
• ResolutionStatus ( type: esriFieldTypeString, alias: ResolutionStatus, length: 50 )
• Tags ( type: esriFieldTypeString, alias: Tags, length: 50 )
• ElpTimeinCalendarHours ( type: esriFieldTypeDouble, alias: ElpTimeinCalendarHours )
• ElpTimeSinceSLABreachinCalrs ( type: esriFieldTypeDouble, alias: ElpTimeSinceSLABreachinCalrs )
• AgentGroupAssignmentTime ( type: esriFieldTypeDouble, alias: AgentGroupAssignmentTime )
• AgentGroupCreatedDate ( type: esriFieldTypeDate, alias: AgentGroupCreatedDate, length: 8 )
• AgentGroupTicketAssigType ( type: esriFieldTypeString, alias: AgentGroupTicketAssigType, length: 100 )
• AgentEmails ( type: esriFieldTypeString, alias: AgentEmails, length: 100 )
• RequesterName ( type: esriFieldTypeString, alias: RequesterName, length: 100 )
• RequesterEmails ( type: esriFieldTypeString, alias: RequesterEmails, length: 100 )
• DepartmentName ( type: esriFieldTypeString, alias: DepartmentName, length: 100 )
• RequestedForName ( type: esriFieldTypeString, alias: RequestedForName, length: 100 )
• RequestedForEmails ( type: esriFieldTypeString, alias: RequestedForEmails, length: 100 )
• AssocSurveyRating ( type: esriFieldTypeString, alias: AssocSurveyRating, length: 20 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata