All Layers and Tables (service_c95001ad9a974010bafc91f9d652d24a)

Layers:

Layer: Service_Request_v411 (0)

Name:

Display Field:

Type:

Geometry Type:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"Service Request - March Edition 2023","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
House_Number (type: esriFieldTypeString, alias: House Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
Unit (type: esriFieldTypeString, alias: Unit (A, B, Suite, Shop), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
Township (type: esriFieldTypeString, alias: Township, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
Initial_Call (type: esriFieldTypeDate, alias: Initial Call, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Customer_Name (type: esriFieldTypeString, alias: Customer / Project Description, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
PhoneNumber1 (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
Comments1 (type: esriFieldTypeString, alias: Customer Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Assignment_Status (type: esriFieldTypeString, alias: Choose a status for your assignment:, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Assigned: Assigned], [Canceled: Canceled], [Completed: Completed], ... 3 more ...)
Priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [STD: Standard], [PRIO: Priority])
Gas_Required_Date (type: esriFieldTypeDate, alias: Gas Required Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Office (type: esriFieldTypeString, alias: Office, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Strasburg_Office: Strasburg Office], [Mentor_Office: Mentor Office], [Lancaster_Office: Lancaster Office])
Department (type: esriFieldTypeString, alias: Choose a department:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Work_Required (type: esriFieldTypeString, alias: Choose a type of work:, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
office_worker (type: esriFieldTypeString, alias: Assign people to work on tasks, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
PaperworkATTACH (type: esriFieldTypeString, alias: Please provide your project Egnyte Link., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
System_Number (type: esriFieldTypeString, alias: System Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [NEO_9: NEO_9 New Bedford], [NEO_10: NEO_10 West Wooster], [NEO_12: NEO_12 Summitville Tile], ... 309 more ...)
MAOP (type: esriFieldTypeString, alias: MAOP System Pressure, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: 0], [0.5: 0.5], [5: 5], ... 25 more ...)
MLXWORKORDERID (type: esriFieldTypeString, alias: Existing MLX Tie-in WO, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Tie_in_Pipe_Size (type: esriFieldTypeString, alias: Tie-in Size, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [0: 0], [0.25: 0.25], [0.5: 0.5], ... 10 more ...)
Tie_in_Pipe_Material (type: esriFieldTypeString, alias: Tie-in Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bare Steel: Bare Steel], [Coated Steel: Coated Steel], [Plastic PE: Plastic PE], ... 8 more ...)
newbusinesstype (type: esriFieldTypeString, alias: How will you use this new business request?, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true, Coded Values: [Proposed_Project: Engineering MLX Request], [No_MLX: Infill Customer Request], [MLX_Required: Customer Waiting on MLX Extension])
Contact_Made (type: esriFieldTypeDate, alias: Provide a date for the sales callback:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Spoken_to_Customer (type: esriFieldTypeString, alias: Did you speak directly with the customer?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Callback_Options (type: esriFieldTypeString, alias: Callback_Options, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
Sales_Notes (type: esriFieldTypeString, alias: Provide additional callback information., SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Schd_Site_Visit (type: esriFieldTypeDate, alias: Schedule a site visit appointment with customer:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Distance_for_MLX (type: esriFieldTypeString, alias: Distance for Existing MLX Tie-in, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Building_Status (type: esriFieldTypeString, alias: Building Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Existing: Existing], [Not Started: Not Started], [Foundation: Foundation], ... 4 more ...)
Well_Gas (type: esriFieldTypeString, alias: 3-Way Valve / Well Gas, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Questionaire_Engineering_Services (type: esriFieldTypeString, alias: Does this require engineering?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
To_Engineering (type: esriFieldTypeDate, alias: Assign work to engineering:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Project_Designed (type: esriFieldTypeDate, alias: Project Designed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Design_Specifications (type: esriFieldTypeString, alias: Design Specifications, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
EstimatedCost (type: esriFieldTypeInteger, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
PROPOSED_2_INCH (type: esriFieldTypeInteger, alias: 2" Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
PROPOSED_4_INCH (type: esriFieldTypeInteger, alias: 4" Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
PROPOSED_6_INCH (type: esriFieldTypeInteger, alias: 6" Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true)
Questionaire_MLXCIAC (type: esriFieldTypeString, alias: Requires a pre-installation payment?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Questionaire_MLXCIAC_Cost (type: esriFieldTypeDouble, alias: Provide a CIAC Cost $0.00, SQL Type: sqlTypeOther, nullable: true, editable: true)
Questionaire_MLXCIAC_Prepaid (type: esriFieldTypeString, alias: Has the CIAC been Pre-paid?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Tax_Code (type: esriFieldTypeString, alias: Tax Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
GL_Code (type: esriFieldTypeString, alias: GL Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
fiscalyr1 (type: esriFieldTypeDate, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Questionaire_preliminary_Approval (type: esriFieldTypeString, alias: Requires Preliminary Approval?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Questionaire_CIAC (type: esriFieldTypeString, alias: Requires a pre-installation payment, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CIAC_Cost (type: esriFieldTypeDouble, alias: Provide a CIAC Cost $0.00, SQL Type: sqlTypeOther, nullable: true, editable: true)
CIAC_Prepaid (type: esriFieldTypeString, alias: CIAC Pre-paid?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Built_Manifold (type: esriFieldTypeString, alias: Is a manifold build or manifold pre-order requried?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Questionaire_Require_Permit (type: esriFieldTypeString, alias: Do you need a permit?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Permit_Sent (type: esriFieldTypeDate, alias: Permit Sent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Permit_Recvd (type: esriFieldTypeDate, alias: Permit Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Questionaire_Require_OUPS (type: esriFieldTypeString, alias: Does OUPS need contacted?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
OUPS_Called (type: esriFieldTypeDate, alias: OUPS Called, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Questionaire_ROW (type: esriFieldTypeString, alias: Do you need a private right-of-way, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
ROW_Sent (type: esriFieldTypeDate, alias: ROW Sent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ROW_Recvd (type: esriFieldTypeDate, alias: ROW Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Private_right_of_way (type: esriFieldTypeString, alias: Private_right_of_way, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Meter_Rate_Base (type: esriFieldTypeString, alias: Meter Rate Base, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [SGS: SGS], [GS1: GS1], [GS2: GS2], ... 2 more ...)
PA_Sent (type: esriFieldTypeDate, alias: PA Sent, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
PA_Recvd (type: esriFieldTypeDate, alias: PA Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
App_Sent_to_Cust (type: esriFieldTypeDate, alias: Sent Customer Application, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Cust_App_Recvd (type: esriFieldTypeDate, alias: Received Customer Application, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
App_Approved (type: esriFieldTypeDate, alias: Final Approval, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
App_to_Processing (type: esriFieldTypeDate, alias: CSR Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CIAC_Received (type: esriFieldTypeString, alias: CIAC Payment Received?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
InstallationID (type: esriFieldTypeString, alias: InstallationID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
To_Operations (type: esriFieldTypeDate, alias: Operations Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
To_Construction (type: esriFieldTypeDate, alias: Construction Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Ordered_Meterset (type: esriFieldTypeDate, alias: Ordered Meter Set, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MS_Built_Recvd (type: esriFieldTypeDate, alias: MS Built / Received, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MS_to_Construction (type: esriFieldTypeString, alias: MS to Construction Department? (Yes / No), SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
To_Construction1 (type: esriFieldTypeDate, alias: To Construction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LS_SS (type: esriFieldTypeString, alias: LS / SS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [LS: LS], [SS: SS])
Bore_Required (type: esriFieldTypeString, alias: Bore Required, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Proposed_Length (type: esriFieldTypeInteger, alias: Estimated Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
Proposed_Size (type: esriFieldTypeDouble, alias: Proposed Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
Installer (type: esriFieldTypeString, alias: Installer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Northeast Ohio Natural Gas: Northeast Ohio Natural Gas], [Buckeye Pipeline: Buckeye Pipeline], [Yoder Trenching: Yoder Trenching], ... 7 more ...)
SLO_Mailed_Pickup (type: esriFieldTypeDate, alias: SLO_Mailed_Pickup, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Material_Pickup (type: esriFieldTypeDate, alias: Material_Pickup, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Schd_SL_Start (type: esriFieldTypeDate, alias: Scheduled Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SL_Start_Date (type: esriFieldTypeDate, alias: Actual Start Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Construction_Notes (type: esriFieldTypeString, alias: Construction Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
SL_Finished_Date (type: esriFieldTypeDate, alias: Construction Finished Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Paperwork_QA (type: esriFieldTypeString, alias: As-built QA, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
QA_Correction_Sent (type: esriFieldTypeDate, alias: Sent As-built Revision, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
QA_Correction_Complete (type: esriFieldTypeString, alias: Corrected As-built, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
QC_Date (type: esriFieldTypeDate, alias: Review As-built on, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Require_UTI_Services (type: esriFieldTypeString, alias: Send to UTI, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
To_UTI (type: esriFieldTypeDate, alias: Sent on, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Mapped_Questionnaire (type: esriFieldTypeString, alias: Requesting an as-built drawing in mapping, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
GPS_Questionnaire (type: esriFieldTypeString, alias: Request a field survey, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
Mapped_Date (type: esriFieldTypeDate, alias: Mapped Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GPS_Completed (type: esriFieldTypeDate, alias: GPS Completed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
mapped_edited_user (type: esriFieldTypeString, alias: Mapped edited user, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
mapped_edited_date (type: esriFieldTypeDate, alias: mapped edited date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gps_edited_user (type: esriFieldTypeString, alias: gps edited user, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
gps_edited_date (type: esriFieldTypeDate, alias: gps edited date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
GIS_QC (type: esriFieldTypeString, alias: GIS Final Review, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: