Name: WorkOrders

Display Field: scope_id

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -100992.429973635
YMin: -3298106.78992625
XMax: 1442501.45581259
YMax: 600942.795534106
Spatial Reference: PROJCS["TealeAlbersNAD83",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Albers"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",-4000000.0],PARAMETER["Central_Meridian",-120.0],PARAMETER["Standard_Parallel_1",34.0],PARAMETER["Standard_Parallel_2",40.5],UNIT["Meter",1.0]]

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[59,103,153,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• scope_id (type: esriFieldTypeString, alias: Scope ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• work_order_number (type: esriFieldTypeInteger, alias: Work Order Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• structure_number_sap (type: esriFieldTypeString, alias: SAP/Structure Number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• sap (type: esriFieldTypeInteger, alias: SAP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• structure_number (type: esriFieldTypeString, alias: Structure Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• hosttline (type: esriFieldTypeString, alias: Host TLine, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• host_etl (type: esriFieldTypeString, alias: Host ETL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• work_order_creation_date (type: esriFieldTypeDate, alias: Work Order Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• work_order_source_number (type: esriFieldTypeInteger, alias: Work Order Source Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• work_order_type (type: esriFieldTypeString, alias: Work Order Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Drone: Drone], [Helicopter: Helicopter], [Ground: Ground])
• assigned_company (type: esriFieldTypeString, alias: Assigned Company, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Cyber_Hawk: Cyber Hawk], [Precision_Hawk: Precision Hawk], [REY: REY], ... 2 more ...)
• assigned_company_transfer (type: esriFieldTypeString, alias: Assigned Company Transfer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [As_Planned: As Planned], [Reassigned: Reassigned])
• reason_for_company_reassignment (type: esriFieldTypeString, alias: Reason for Company Reassignment, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• planned_site_visit_date (type: esriFieldTypeDate, alias: Planned Site Visit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• site_visit_date (type: esriFieldTypeDate, alias: Date Site Visited, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• field_technician (type: esriFieldTypeString, alias: Field Technician, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• site_visit_results (type: esriFieldTypeString, alias: Site Visit Result, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Complete: Complete], [Assistance_Needed: Assistance Needed])
• site_visit_status (type: esriFieldTypeString, alias: Site Visit Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Assigned: Assigned], [Not_Assigned: Not Assigned], [Cancelled: Cancelled], ... 1 more ...)
• work_order_status (type: esriFieldTypeString, alias: Work Order Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Open: Open], [Closed: Closed])
• generate_new_work_order (type: esriFieldTypeString, alias: Generate New Work Order?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• reason_for_new_work_order (type: esriFieldTypeString, alias: Reason for New Work Order, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Wrong_Structure: Wrong Structure], [Incomplete_Shots: Incomplete Shots], [Did_Not_Receive_Imagery: Did Not Receive Imagery], ... 3 more ...)
• comments (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• current_record (type: esriFieldTypeSmallInteger, alias: Current Record, SQL Type: sqlTypeOther, nullable: true, editable: true)
• date_filter (type: esriFieldTypeSmallInteger, alias: Date Filter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• symbology (type: esriFieldTypeSmallInteger, alias: Symbology, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Clear Access], [1: Planning Required Prior to Access], [2: Not Accessible])
• Test (type: esriFieldTypeString, alias: Test, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• test2 (type: esriFieldTypeString, alias: test2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: WorkOrders
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/5/2024 7:18:25 PM

Schema Last Edit Date: 11/5/2024 7:06:44 PM

Data Last Edit Date: 11/5/2024 7:18:25 PM

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