Name: DigTicketHistory

Display Field: contactname

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• ticketid ( type: esriFieldTypeString, alias: TicketID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TicketID )
• revision ( type: esriFieldTypeString, alias: StartDate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Revision )
• accountid ( type: esriFieldTypeString, alias: AccountID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AccountID )
• startdate ( type: esriFieldTypeDate, alias: StartDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StartDate )
• hoursnotice ( type: esriFieldTypeSmallInteger, alias: HoursNotice, editable: true, nullable: true, defaultValue: null, modelName: HoursNotice )
• responserequired ( type: esriFieldTypeString, alias: ResponseRequired, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ResponseRequired )
• responseduedate ( type: esriFieldTypeDate, alias: ResponseDueDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ResponseDueDate )
• priority ( type: esriFieldTypeString, alias: Priority, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Priority )
• prioritytype ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type )
• fromaddress ( type: esriFieldTypeString, alias: FromAddress, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FromAddress )
• toaddress ( type: esriFieldTypeString, alias: ToAddress, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ToAddress )
• street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Street )
• crossstreet ( type: esriFieldTypeString, alias: CrossStreet, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CrossStreet )
• delineated ( type: esriFieldTypeString, alias: Delineated, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Delineated )
• delineationtype ( type: esriFieldTypeString, alias: DelineationType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DelineationType )
• instructions ( type: esriFieldTypeString, alias: Instructions, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Instructions )
• constructiontype ( type: esriFieldTypeString, alias: WorkorderKey, editable: true, nullable: true, length: 255, defaultValue: null, modelName: WorkorderKey )
• contactname ( type: esriFieldTypeString, alias: ContactName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ContactName )
• address1 ( type: esriFieldTypeString, alias: Address1, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Address1 )
• address2 ( type: esriFieldTypeString, alias: Address2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Address2 )
• city ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: City )
• state ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 50, defaultValue: null, modelName: State )
• zip ( type: esriFieldTypeString, alias: Zip, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Zip )
• phone ( type: esriFieldTypeString, alias: Phone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Phone )
• email ( type: esriFieldTypeString, alias: Email, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Email )
• location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Location )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: Comments )
• tickettext ( type: esriFieldTypeString, alias: TicketText, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TicketText )
• assetkey ( type: esriFieldTypeString, alias: assetkey, editable: true, nullable: true, length: 20, defaultValue: null, modelName: assetkey )
• workorderkey ( type: esriFieldTypeString, alias: workorderkey, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workorderkey )
• workdate ( type: esriFieldTypeDate, alias: workdate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: workdate )
• workby ( type: esriFieldTypeString, alias: workby, editable: true, nullable: true, length: 50, defaultValue: null, modelName: workby )
• worktype ( type: esriFieldTypeString, alias: worktype, editable: true, nullable: true, length: 50, defaultValue: null, modelName: worktype )
• assetsin ( type: esriFieldTypeString, alias: assetsin, editable: true, nullable: true, length: 50, defaultValue: null, modelName: assetsin , Coded Values: [Yes: Yes] , [No: No] )
• needfieldverification ( type: esriFieldTypeString, alias: needfieldverification, editable: true, nullable: true, length: 50, defaultValue: null, modelName: needfieldverification , Coded Values: [Yes: Yes] , [No: No] )
• attachmentid ( type: esriFieldTypeInteger, alias: attachmentid, editable: true, nullable: true, defaultValue: null, modelName: attachmentid )
• status ( type: esriFieldTypeString, alias: status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: status , Coded Values: [Marked: Marked] , [Work Already Completed: Work Already Completed] , [No Conflict: No Conflict] , ...1 more... )
• attachmentid2 ( type: esriFieldTypeInteger, alias: attachmentid2, editable: true, nullable: true, defaultValue: null, modelName: attachmentid2 )
• attachmentid3 ( type: esriFieldTypeInteger, alias: attachmentid3, editable: true, nullable: true, defaultValue: null, modelName: attachmentid3 )

Templates:

• Name: DigTicketHistory
  Description:
  Prototype:
  attachmentid2: null
  attachmentid3: null
  ticketid: null
  revision: null
  accountid: null
  startdate: null
  hoursnotice: null
  responserequired: null
  responseduedate: null
  priority: null
  prioritytype: null
  fromaddress: null
  toaddress: null
  street: null
  crossstreet: null
  delineated: null
  delineationtype: null
  instructions: null
  constructiontype: null
  contactname: null
  address1: null
  address2: null
  city: null
  state: null
  zip: null
  phone: null
  email: null
  location: null
  comments: null
  tickettext: null
  assetkey: null
  workorderkey: null
  workdate: null
  workby: null
  worktype: null
  assetsin: null
  needfieldverification: null
  attachmentid: null
  status: null
  
  Drawing Tool: esriFeatureEditToolNone

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

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