Name: DigAlertTickets

Display Field: TicketNumber

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -118.4516295
YMin: 34.420610176
XMax: -118.446291058
YMax: 34.4222960000001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[135,0,119,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}},"label":"","description":""},"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• TicketNumber (type: esriFieldTypeString, alias: TicketNumber, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• TicketType (type: esriFieldTypeString, alias: TicketType, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [NEW: New], [REMK: Remark request], [CNCL: Cancel], ... 5 more ...)
• TicketDate (type: esriFieldTypeDate, alias: TicketDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TicketExpiration (type: esriFieldTypeDate, alias: TicketExpiration, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MemberCode (type: esriFieldTypeString, alias: MemberCode, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SiteAddress (type: esriFieldTypeString, alias: SiteAddress, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• CrossStreet (type: esriFieldTypeString, alias: CrossStreet, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• TicketStatus (type: esriFieldTypeSmallInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Open], [1: In Progress], [3: Duplicate], ... 1 more ...)
• Company (type: esriFieldTypeString, alias: Company, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Zip (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• CreatedBy (type: esriFieldTypeString, alias: CreatedBy, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OfficePhone (type: esriFieldTypeString, alias: OfficePhone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Extension (type: esriFieldTypeString, alias: Extension, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• OfficeEmail (type: esriFieldTypeString, alias: OfficeEmail, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Revision (type: esriFieldTypeString, alias: Revision, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SitePlace (type: esriFieldTypeString, alias: SitePlace, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SiteCounty (type: esriFieldTypeString, alias: SiteCounty, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Instruct (type: esriFieldTypeString, alias: Instruct, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AssignedTo (type: esriFieldTypeString, alias: AssignedTo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TicketPriority (type: esriFieldTypeString, alias: TicketPriority, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [NORM: Normal], [RUSH: Rush], [EMER: Emergency], ... 2 more ...)
• ClearedBy (type: esriFieldTypeString, alias: ClearedBy, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ClearedOn (type: esriFieldTypeDate, alias: ClearedOn, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Work_ (type: esriFieldTypeString, alias: Work_, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• TicketNotes (type: esriFieldTypeSmallInteger, alias: TicketNotes, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Called and cleared], [2: Insufficient information], ... 4 more ...)
• UniqueID (type: esriFieldTypeString, alias: UniqueID, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• MapsLink (type: esriFieldTypeString, alias: MapsLink, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• ResponseSendCode (type: esriFieldTypeString, alias: ResponseSendCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ResponseSendDate (type: esriFieldTypeDate, alias: ResponseSendDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ResponseReturnCode (type: esriFieldTypeString, alias: ResponseReturnCode, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SiteContact (type: esriFieldTypeString, alias: SiteContact, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SitePhone (type: esriFieldTypeString, alias: SitePhone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SiteSMS (type: esriFieldTypeString, alias: SiteSMS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SiteEmail (type: esriFieldTypeString, alias: SiteEmail, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• RemarksRequired (type: esriFieldTypeString, alias: RemarksRequired, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)

Templates:

Name: DigAlertTickets
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• TicketNotes: 0
• AssignedTo: NA
• UniqueID:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/14/2019 8:18:37 PM

Schema Last Edit Date: 2/14/2019 8:18:37 PM

Data Last Edit Date: 2/14/2019 8:18:37 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat