Name: Crossconnection_GIS_ExcelToTable

Display Field: BUSINESS_NAME__CIS_

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• c_account__billing_ (type: esriFieldTypeString, alias: c_account (billing), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Active_Inactive_for__Survey_Req (type: esriFieldTypeString, alias: Active/Inactive for Survey Requirement, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BUSINESS_NAME__CIS_ (type: esriFieldTypeString, alias: BUSINESS NAME (CIS), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Updated_Business_Names (type: esriFieldTypeString, alias: Updated Business Names , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Service_Address__Text_ (type: esriFieldTypeString, alias: Service Address (Text), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_Contact (type: esriFieldTypeString, alias: Primary Contact, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_Email (type: esriFieldTypeString, alias: Primary Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Primary_Phone_Number (type: esriFieldTypeString, alias: Primary Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Owner_Name (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Owner_Email (type: esriFieldTypeString, alias: Owner Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Owner_Phone_Number (type: esriFieldTypeString, alias: Owner Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Owner_Address (type: esriFieldTypeString, alias: Owner Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Property_Manager (type: esriFieldTypeString, alias: Property Manager, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PM_Email (type: esriFieldTypeString, alias: PM Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Property_Manager_Phone (type: esriFieldTypeString, alias: Property Manager Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PM_Mailing_Address (type: esriFieldTypeString, alias: PM Mailing Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c_town (type: esriFieldTypeString, alias: c_town, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c_prov (type: esriFieldTypeString, alias: c_prov, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c_postcode (type: esriFieldTypeString, alias: c_postcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_Survey_Completed (type: esriFieldTypeString, alias: Date Survey Completed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Survey_Completed_By (type: esriFieldTypeString, alias: Survey Completed By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• No__of_Bldgs (type: esriFieldTypeString, alias: No. of Bldgs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• No__of_Stories (type: esriFieldTypeString, alias: No. of Stories, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• No__of_Units (type: esriFieldTypeString, alias: No, of Units, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Business_Risk_Type (type: esriFieldTypeString, alias: Business Risk Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Type_of_Business (type: esriFieldTypeString, alias: Type of Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Bldg_Type (type: esriFieldTypeString, alias: Bldg Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Customer_form___No__CCs (type: esriFieldTypeString, alias: Customer form - No. CCs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Customer_Form___BF_Devices (type: esriFieldTypeString, alias: Customer Form - BF Devices, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• No__Confirmed_Uncontrolled_CC (type: esriFieldTypeString, alias: No. Confirmed Uncontrolled CC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• No__BSI_Devices (type: esriFieldTypeString, alias: No. BSI Devices, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Type_of_BF_Device_in_BSI (type: esriFieldTypeString, alias: Type of BF Device in BSI, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Initial_Data_for_Customer_Surve (type: esriFieldTypeString, alias: Initial Data for Customer Survey/Inspections., SQL Type: sqlTypeOther, length: 492, nullable: true, editable: true)
• Language_for_Letters_Mailer (type: esriFieldTypeString, alias: Language for Letters/Mailer, SQL Type: sqlTypeOther, length: 638, nullable: true, editable: true)
• Description_of_Inspections___Fi (type: esriFieldTypeString, alias: Description of Inspections - Final Review - Narrative, SQL Type: sqlTypeOther, length: 635, nullable: true, editable: true)
• Contained_Isolated_No_Hazard (type: esriFieldTypeString, alias: Contained/Isolated/No Hazard, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_CC_Confirmed__NOT_USED_ (type: esriFieldTypeString, alias: Date CC Confirmed (NOT USED), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Number_of_Backflow_Methods_at_P (type: esriFieldTypeString, alias: Number of Backflow Methods at Property (ex. air gap, vac breaker, rpv), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_Methods_Inpected__if_appli (type: esriFieldTypeString, alias: Date Methods Inpected (if applicable), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COE___Risk_Level__None_0__Low_1 (type: esriFieldTypeInteger, alias: COE - Risk Level (None 0, Low 1, Med 2 , Med High 3, High 4), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Date_Risk_Level_Categorized__no (type: esriFieldTypeString, alias: Date Risk Level Categorized (not necessary to track anymore), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_Customer_Informed_of__Unco (type: esriFieldTypeString, alias: Date Customer Informed of Uncontrolled CC or upgrade, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_Uncontroled_CC_Resolved (type: esriFieldTypeString, alias: Date Uncontroled CC Resolved, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Days_Until_Controlled__ (type: esriFieldTypeString, alias: Days Until Controlled - , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Date_Survey_Completed___Complia (type: esriFieldTypeString, alias: Date Survey Completed & Compliant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1555, nullable: true, editable: true)
• Follow_Up_Inspections (type: esriFieldTypeString, alias: Follow Up Inspections, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Response_Category (type: esriFieldTypeString, alias: Response Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Action_Needed_by_Bob_or_COE (type: esriFieldTypeString, alias: Action Needed by Bob or COE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: Crossconnection_GIS_ExcelToTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/29/2023 3:17:29 PM

Schema Last Edit Date: 9/29/2023 3:17:29 PM

Data Last Edit Date: 9/29/2023 3:17:29 PM

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