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.638458591
YMin: 34.3724765000001
XMax: -118.3962445
YMax: 34.4917299580001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[156,0,16,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: TicketStatus, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [NEW: New], [UPDT: Update], [REMK: Remark request], ... 4 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)
• Caller (type: esriFieldTypeString, alias: Caller, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Phone (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Extension (type: esriFieldTypeString, alias: Extension, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CallBack (type: esriFieldTypeString, alias: CallBack, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Revision (type: esriFieldTypeString, alias: LinkID, 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, Coded Values: [FS: Fred], [NA: Unassigned], [gurunathan: Guru], ... 4 more ...)
• TicketPriority (type: esriFieldTypeString, alias: TicketPriority, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [NORM: Normal], [RUSH: Rush], [REMK: Remark], ... 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)
• SMS (type: esriFieldTypeString, alias: SMS, SQL Type: sqlTypeOther, length: 20, nullable: true, 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)

Templates:

Name: DigAlertTickets
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AssignedTo: NA
• UniqueID:
• TicketNotes: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/3/2018 9:16:28 PM

Schema Last Edit Date: 10/3/2018 9:16:28 PM

Data Last Edit Date: 10/3/2018 9:16:28 PM

Supported Operations:   Query   Query Top Features   Query Analytic   Query Bins   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat