Name: Customers

Display Field: NAME

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)
• Company (type: esriFieldTypeString, alias: Company, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Op_Area (type: esriFieldTypeString, alias: Op Area, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PDZ_Area_Abbr (type: esriFieldTypeString, alias: PDZ_Area Abbr, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PDZ_Area_Name (type: esriFieldTypeString, alias: PDZ_Area Name, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Name_Comments (type: esriFieldTypeString, alias: Name_Comments, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Critical_SIC_lookup (type: esriFieldTypeString, alias: Critical SIC lookup, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ACCOUNT_NO (type: esriFieldTypeDouble, alias: ACCOUNT_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CADOPS_SOURCE (type: esriFieldTypeString, alias: CADOPS_SOURCE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CONSUMER_NAME (type: esriFieldTypeString, alias: CONSUMER_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PHONE_AREA_CODE (type: esriFieldTypeInteger, alias: PHONE_AREA_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHONE_NUMBER (type: esriFieldTypeInteger, alias: PHONE_NUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZIP (type: esriFieldTypeInteger, alias: ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADDRESS_NOTE (type: esriFieldTypeString, alias: ADDRESS_NOTE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SECTION (type: esriFieldTypeString, alias: SECTION, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• POLE_ID (type: esriFieldTypeString, alias: POLE_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SERVICE_STREET_ADDRESS (type: esriFieldTypeString, alias: SERVICE_STREET_ADDRESS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SERVICE_CITY (type: esriFieldTypeString, alias: SERVICE_CITY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SERVICE_STATE (type: esriFieldTypeString, alias: SERVICE_STATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PHASE_CODES (type: esriFieldTypeInteger, alias: PHASE_CODES, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOTE (type: esriFieldTypeString, alias: NOTE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SERVICE_XFMR_ID (type: esriFieldTypeString, alias: SERVICE_XFMR_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ALTERNATE_NAME (type: esriFieldTypeString, alias: ALTERNATE_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ALTERNATE_PHONE_AREA_CODE (type: esriFieldTypeString, alias: ALTERNATE_PHONE_AREA_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ALTERNATE_PHONE_NUMBER (type: esriFieldTypeString, alias: ALTERNATE_PHONE_NUMBER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SERVICE_ADDRESS_DIRECTIONS (type: esriFieldTypeString, alias: SERVICE_ADDRESS_DIRECTIONS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_NAME (type: esriFieldTypeString, alias: CSS_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_SERVICE_ZIP (type: esriFieldTypeInteger, alias: CSS_SERVICE_ZIP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_SERVICE_ZIP_EXTN (type: esriFieldTypeInteger, alias: CSS_SERVICE_ZIP_EXTN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_UPDATE_FLAG (type: esriFieldTypeString, alias: CSS_UPDATE_FLAG, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_LAST_UPDATE_TMSTMP (type: esriFieldTypeDate, alias: CSS_LAST_UPDATE_TMSTMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CSS_AOR (type: esriFieldTypeString, alias: CSS_AOR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_SERVICE_STREET (type: esriFieldTypeString, alias: CSS_SERVICE_STREET, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_XFMR_CONNECT_CONFIDENCE_CD (type: esriFieldTypeString, alias: CSS_XFMR_CONNECT_CONFIDENCE_CD, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CUSTOMER_CONTACT_INFO (type: esriFieldTypeDouble, alias: CUSTOMER_CONTACT_INFO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCORP_MAP_LAT_TEXT (type: esriFieldTypeDouble, alias: PCORP_MAP_LAT_TEXT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PCORP_MAP_LONG_TEXT (type: esriFieldTypeDouble, alias: PCORP_MAP_LONG_TEXT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_SITE_ID (type: esriFieldTypeInteger, alias: CSS_SITE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_SITE_SERV_SEQ (type: esriFieldTypeInteger, alias: CSS_SITE_SERV_SEQ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_PARCEL_MATCH_FLAG (type: esriFieldTypeString, alias: CSS_PARCEL_MATCH_FLAG, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_PARCEL_MATCH_TMSTMP (type: esriFieldTypeString, alias: CSS_PARCEL_MATCH_TMSTMP, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_IN_PARCEL_FLAG (type: esriFieldTypeString, alias: CSS_IN_PARCEL_FLAG, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_IN_PARCEL_TMSTMP (type: esriFieldTypeString, alias: CSS_IN_PARCEL_TMSTMP, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CTL_ASSIGNED_TMSTMP (type: esriFieldTypeString, alias: CTL_ASSIGNED_TMSTMP, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CADOPS_FEEDER_NAME (type: esriFieldTypeString, alias: CADOPS_FEEDER_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CADOPS_FEEDER_NAME_X (type: esriFieldTypeDouble, alias: CADOPS_FEEDER_NAME_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CADOPS_FEEDER_NAME_Y (type: esriFieldTypeDouble, alias: CADOPS_FEEDER_NAME_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CADOPS_SUBSTATION_NAME (type: esriFieldTypeString, alias: CADOPS_SUBSTATION_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CADOPS_DISTRICT_NAME (type: esriFieldTypeString, alias: CADOPS_DISTRICT_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_LATITUDE (type: esriFieldTypeDouble, alias: CSS_LATITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_LONGITUDE (type: esriFieldTypeDouble, alias: CSS_LONGITUDE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GEOMETRY_ACTION_CD (type: esriFieldTypeString, alias: GEOMETRY_ACTION_CD, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOCATION_QUALITY_CODE (type: esriFieldTypeString, alias: LOCATION_QUALITY_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CONNECTIVITY_QUALITY_CODE (type: esriFieldTypeString, alias: CONNECTIVITY_QUALITY_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CARTOGRAPHY_SYMBOL (type: esriFieldTypeString, alias: CARTOGRAPHY_SYMBOL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• METER_NO (type: esriFieldTypeInteger, alias: METER_NO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_RATE_SCHEDULE (type: esriFieldTypeString, alias: CSS_RATE_SCHEDULE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BILLING_ADDR1 (type: esriFieldTypeString, alias: BILLING_ADDR1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BILLING_ADDR2 (type: esriFieldTypeString, alias: BILLING_ADDR2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BILLING_ADDR3 (type: esriFieldTypeString, alias: BILLING_ADDR3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BILLING_ADDR4 (type: esriFieldTypeString, alias: BILLING_ADDR4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ACCNO (type: esriFieldTypeDouble, alias: ACCNO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AREA (type: esriFieldTypeInteger, alias: AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHONE (type: esriFieldTypeInteger, alias: PHONE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SSN (type: esriFieldTypeString, alias: SSN, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LOC (type: esriFieldTypeString, alias: LOC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• RANK (type: esriFieldTypeString, alias: RANK, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CLASS (type: esriFieldTypeInteger, alias: CLASS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• RATE (type: esriFieldTypeString, alias: RATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• KVA (type: esriFieldTypeInteger, alias: KVA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• KWH (type: esriFieldTypeInteger, alias: KWH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISC (type: esriFieldTypeString, alias: DISC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BAL (type: esriFieldTypeString, alias: BAL, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ADDR1 (type: esriFieldTypeString, alias: ADDR1, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ADDR2 (type: esriFieldTypeString, alias: ADDR2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ADDR3 (type: esriFieldTypeString, alias: ADDR3, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ADDR4 (type: esriFieldTypeString, alias: ADDR4, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SECT (type: esriFieldTypeString, alias: SECT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NODE (type: esriFieldTypeString, alias: NODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SAREA (type: esriFieldTypeString, alias: SAREA, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BREAK_ (type: esriFieldTypeString, alias: BREAK, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• POLE (type: esriFieldTypeString, alias: POLE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SERV (type: esriFieldTypeString, alias: SERV, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: CITY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CNTY (type: esriFieldTypeString, alias: CNTY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• XCOOR (type: esriFieldTypeDouble, alias: XCOOR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YCOOR (type: esriFieldTypeDouble, alias: YCOOR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• XFMER (type: esriFieldTypeString, alias: XFMER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• FEED (type: esriFieldTypeInteger, alias: FEED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUBS (type: esriFieldTypeInteger, alias: SUBS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DELPT (type: esriFieldTypeString, alias: DELPT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DISTR (type: esriFieldTypeInteger, alias: DISTR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PHASE (type: esriFieldTypeInteger, alias: PHASE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LMS (type: esriFieldTypeString, alias: LMS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• HEAT (type: esriFieldTypeInteger, alias: HEAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AIR (type: esriFieldTypeInteger, alias: AIR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOTE2 (type: esriFieldTypeString, alias: NOTE2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PRIORITY (type: esriFieldTypeString, alias: PRIORITY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• LO_KEY (type: esriFieldTypeString, alias: LO_KEY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• XFMR_ID (type: esriFieldTypeString, alias: XFMR_ID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• NAME2 (type: esriFieldTypeString, alias: NAME2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AREA2 (type: esriFieldTypeString, alias: AREA2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• PHONE2 (type: esriFieldTypeString, alias: PHONE2, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• DIRECTIONS (type: esriFieldTypeString, alias: DIRECTIONS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• METER_CYCLE (type: esriFieldTypeInteger, alias: METER_CYCLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BILL_ACCNO (type: esriFieldTypeString, alias: BILL_ACCNO, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• METER_LOC (type: esriFieldTypeString, alias: METER_LOC, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• AGRMT_STATUS (type: esriFieldTypeString, alias: AGRMT_STATUS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• CSS_REVENUE_CLASS (type: esriFieldTypeString, alias: CSS_REVENUE_CLASS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SIC_CODE (type: esriFieldTypeInteger, alias: SIC_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_PHASE (type: esriFieldTypeInteger, alias: CSS_PHASE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METER_ROUTE (type: esriFieldTypeInteger, alias: METER_ROUTE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METER_ROUTE_SEQ (type: esriFieldTypeInteger, alias: METER_ROUTE_SEQ, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METER_VOLTAGE (type: esriFieldTypeInteger, alias: METER_VOLTAGE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• METER_FORM_CODE (type: esriFieldTypeString, alias: METER_FORM_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• METER_INTERNAL_ID (type: esriFieldTypeInteger, alias: METER_INTERNAL_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_REVENUE (type: esriFieldTypeDouble, alias: CSS_REVENUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CSS_REVENUE_DATE (type: esriFieldTypeDate, alias: CSS_REVENUE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• COST_CENTER (type: esriFieldTypeInteger, alias: COST_CENTER, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Customers
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/25/2019 5:51:20 PM

Schema Last Edit Date: 7/25/2019 5:51:20 PM

Data Last Edit Date: 7/25/2019 5:51:20 PM

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