Name: Export_Output

Display Field: Customer_Name

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: 313234.943
YMin: 4363268.7716
XMax: 538324.597066491
YMax: 4631023.7346
Spatial Reference: 26917 (26917)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[97,0,133,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: 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)
• PaperworkATTACH (type: esriFieldTypeString, alias: Egnyte Paperwork URL, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• House_Number (type: esriFieldTypeString, alias: House Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit (A, B, Suite, Shop), SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 25, 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: 8, nullable: true, editable: true)
• Customer_Name (type: esriFieldTypeString, alias: Proj / Cust Name, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PhoneNumber1 (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Office (type: esriFieldTypeString, alias: Office, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Customer_Status (type: esriFieldTypeString, alias: Customer Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Work_Required (type: esriFieldTypeString, alias: Work Required, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Gas_Required_Date (type: esriFieldTypeDate, alias: Gas Required Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• To_Sales (type: esriFieldTypeDate, alias: Sales Department, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comments1 (type: esriFieldTypeString, alias: Customer Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Sales_Assignment (type: esriFieldTypeString, alias: Sales Person, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Spoken_to_Customer (type: esriFieldTypeString, alias: Spoken to Customer, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• Contact_Made (type: esriFieldTypeDate, alias: Contact Made, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Schd_Site_Visit (type: esriFieldTypeDate, alias: Sales Appointments, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• System_Number (type: esriFieldTypeString, alias: System Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• MAOP (type: esriFieldTypeString, alias: MAOP System Pressure, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MLXWORKORDERID (type: esriFieldTypeString, alias: MLX Work Order ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Tie_in_Pipe_Size (type: esriFieldTypeString, alias: Main Size, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Tie_in_Pipe_Material (type: esriFieldTypeString, alias: Main Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Distance_for_MLX (type: esriFieldTypeString, alias: Distance for MLX, 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)
• Well_Gas (type: esriFieldTypeString, alias: 3-Way Valve / Well Gas, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• To_Engineering (type: esriFieldTypeDate, alias: Engineering Department, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Project_Designed (type: esriFieldTypeDate, alias: Project Designed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Design_Specifications (type: esriFieldTypeString, alias: Design Specifications, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Cost (type: esriFieldTypeInteger, alias: Actual Cost - old, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PA_Sent (type: esriFieldTypeDate, alias: PA Sent, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PA_Recvd (type: esriFieldTypeDate, alias: PA Received, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GL_Code (type: esriFieldTypeString, alias: GL Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Project_Type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fiscalyr (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Estimated_Cost (type: esriFieldTypeString, alias: Estimated Cost - Old, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Tax_Code (type: esriFieldTypeString, alias: Tax Code, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Budget_Prepared_By (type: esriFieldTypeString, alias: Budget Prepared By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Budget_Prepared_Date (type: esriFieldTypeDate, alias: Budget Prepared Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Budget_App_Records (type: esriFieldTypeString, alias: Budget App Records, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Questionaire_Private_ROW (type: esriFieldTypeString, alias: Budget Private ROW, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Budget_Road_ROW (type: esriFieldTypeString, alias: Budget Road ROW, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• App_Sent_to_Cust (type: esriFieldTypeDate, alias: App Sent to Customer, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Cust_App_Recvd (type: esriFieldTypeDate, alias: Customer App Received, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• App_Approved (type: esriFieldTypeDate, alias: App Approved, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Meter_Rate_Base (type: esriFieldTypeString, alias: Meter Rate Base, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Permit_Sent (type: esriFieldTypeDate, alias: Permit Sent, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Permit_Recvd (type: esriFieldTypeDate, alias: Permit Received, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OUPS_Called (type: esriFieldTypeDate, alias: OUPS Called, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• App_to_Processing (type: esriFieldTypeDate, alias: CSR Department, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BPID (type: esriFieldTypeString, alias: BP #, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• BAID (type: esriFieldTypeString, alias: BA #, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• To_Operations (type: esriFieldTypeDate, alias: Operations Department, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• To_Construction (type: esriFieldTypeDate, alias: Construction Department, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Meterset_Cost (type: esriFieldTypeInteger, alias: Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Ordered_Meterset (type: esriFieldTypeDate, alias: Ordered Meterset, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MS_Built_Recvd (type: esriFieldTypeDate, alias: MS Built / Received, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MS_to_Construction (type: esriFieldTypeString, alias: MS to Construction Department, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• LS_SS (type: esriFieldTypeString, alias: LS / SS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Bore_Required (type: esriFieldTypeString, alias: Bore Required, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• 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)
• SLO_Mailed_Pickup (type: esriFieldTypeDate, alias: Paperwork Mailed / Pickup, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Material_Pickup (type: esriFieldTypeDate, alias: Material Pickup, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Schd_SL_Start (type: esriFieldTypeDate, alias: Scheduled Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SL_Start_Date (type: esriFieldTypeDate, alias: Actual Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FDRNumber (type: esriFieldTypeString, alias: FDR #, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• GLRNumber (type: esriFieldTypeString, alias: GLR #, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Paperwork_Recvd (type: esriFieldTypeDate, alias: Paperwork Received, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Questionaire_New_Info (type: esriFieldTypeString, alias: Questionaire - New Information, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Questionaire_Replacement_Info (type: esriFieldTypeString, alias: Questionaire Replacement Info, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Questionaire_Retire_Info (type: esriFieldTypeString, alias: Questionaire Retire Information, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• SVC_EFV (type: esriFieldTypeString, alias: Installed EFV, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SVC_Curb_Valve (type: esriFieldTypeString, alias: Installed Curb Valve , SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SVC_Material (type: esriFieldTypeString, alias: Installed Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SVC_Size (type: esriFieldTypeDouble, alias: Installed Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SVC_SDR (type: esriFieldTypeString, alias: Installed SDR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SVC_Length (type: esriFieldTypeInteger, alias: Installed Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BILLABLEFOOTAGE (type: esriFieldTypeInteger, alias: Billable Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REPLACEMENTFOOTAGE (type: esriFieldTypeInteger, alias: Replacement Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REPLACEMENTMATERIAL (type: esriFieldTypeString, alias: Replacement Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• REPLACEMENTSDRWALL (type: esriFieldTypeString, alias: Replacement SDR / Wall, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RETIREFOOTAGE (type: esriFieldTypeInteger, alias: Retire Footage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RETIREMATERIAL (type: esriFieldTypeString, alias: Retire Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RETIRESDRWALL (type: esriFieldTypeString, alias: Retire SDR / Wall, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RETIRE_Abandoned_in_Place (type: esriFieldTypeString, alias: Abandoned in Place, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RETIREUSEDASCARRIER (type: esriFieldTypeString, alias: Pipe used as carrier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RETIREMETERREMOVED (type: esriFieldTypeString, alias: Meter Removed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RETIREDIAMETER (type: esriFieldTypeDouble, alias: Retired Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• REPLACEMENTDIAMETER (type: esriFieldTypeDouble, alias: Replacement Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENTIRESERVICEREPLACED (type: esriFieldTypeString, alias: Entire Service Replaced, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ENTIRESERVICEABANDONED (type: esriFieldTypeString, alias: Entire Service Abandoned, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SL_Finished_Date (type: esriFieldTypeDate, alias: Service Finished Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Tied_In_to_System (type: esriFieldTypeDate, alias: Tied-In To System, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_METER_SET (type: esriFieldTypeDate, alias: Date Meter Set, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATETURNEDON (type: esriFieldTypeDate, alias: Date Turned On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• InstallationID (type: esriFieldTypeString, alias: SAP Installation ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• To_Mapping (type: esriFieldTypeDate, alias: Mapping Department, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Mapped_Date (type: esriFieldTypeDate, alias: Mapped Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GPS_Completed (type: esriFieldTypeDate, alias: GPS Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Assignment_Status (type: esriFieldTypeString, alias: Assignment Status, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Questionaire_For_a_Service (type: esriFieldTypeString, alias: Is this for a service? (Yes/No), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Questionaire_Within_Tiein (type: esriFieldTypeString, alias: Is this within Tie-in Range (Yes/No), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Questionaire_Require_Permit (type: esriFieldTypeString, alias: Questionaire_Require_Permit, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Questionaire_Require_OUPS (type: esriFieldTypeString, alias: Questionaire_Require_OUPS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Survey123GlobalID (type: esriFieldTypeGUID, alias: Survey123GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• 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)
• Engineering_person (type: esriFieldTypeString, alias: Engineering person, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Lancaster_Operators (type: esriFieldTypeString, alias: Lancaster Operators, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Strasburg_Operators (type: esriFieldTypeString, alias: Strasburg Operators, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Mentor_Operators (type: esriFieldTypeString, alias: Mentor Operators, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Operation_Department_Notes (type: esriFieldTypeString, alias: Operation Department Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Scheduled_Turn_on_Date (type: esriFieldTypeDate, alias: Scheduled Turn-on Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Response_Started_Date (type: esriFieldTypeDate, alias: Response_Started_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Assigned_Date (type: esriFieldTypeDate, alias: Assigned_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Enroute_Date (type: esriFieldTypeDate, alias: Enroute_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Arrived_At_Scene_Date (type: esriFieldTypeDate, alias: Arrived_At_Scene_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Call_Cleared_Date (type: esriFieldTypeDate, alias: Call_Cleared_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Priority_Description (type: esriFieldTypeString, alias: Priority_Description, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• battalion (type: esriFieldTypeString, alias: battalion, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• radio_name (type: esriFieldTypeString, alias: radio_name, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Problem (type: esriFieldTypeString, alias: Problem, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• color3 (type: esriFieldTypeString, alias: color3, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• Sales_Notes (type: esriFieldTypeString, alias: Sales_Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• ActualCost (type: esriFieldTypeInteger, alias: Actual Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EstimatedCost (type: esriFieldTypeInteger, alias: Estimated Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Export_Output
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/2/2022 6:18:08 PM

Schema Last Edit Date: 6/2/2022 6:18:08 PM

Data Last Edit Date: 6/2/2022 6:18:08 PM

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