Name: Consumer - Prepay

Display Field: Consumer.LASTNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: false

Supports Statistics: false

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 1754782.9952219725
YMin: 163744.2929635644
XMax: 1961241.8615028858
YMax: 388496.91629205644
Spatial Reference: 102722  (3734)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label:
Description:
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: false
Supports OrderBy: false
Supports Distinct: false
Supports Pagination: false
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: false
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: ConsumerType

Fields:

• Consumer.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• Consumer.MapNumber ( type: esriFieldTypeString, alias: MapNumber, length: 50 )
• Consumer.PhaseCode ( type: esriFieldTypeSmallInteger, alias: PhaseCode , Coded Values: [129: A] , [130: B] , [131: AB] , ...4 more... )
• Consumer.TransformerMapNumber ( type: esriFieldTypeString, alias: TransformerMapNumber, length: 50 )
• Consumer.ConstructionUnit ( type: esriFieldTypeString, alias: ConstructionUnit, length: 50 )
• Consumer.Feeder ( type: esriFieldTypeString, alias: Feeder, length: 50 , Coded Values: [Snyder_Sub: Snyder_Sub] , [Oxford_Sub: Oxford_Sub] , [Scioto_Sub: Scioto_Sub] , ...59 more... )
• Consumer.MeterType ( type: esriFieldTypeSmallInteger, alias: MeterType )
• Consumer.Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• Consumer.FuturaGUID ( type: esriFieldTypeString, alias: FuturaGUID, length: 50 )
• Consumer.DateCreated ( type: esriFieldTypeDate, alias: DateCreated, length: 8 )
• Consumer.DateModified ( type: esriFieldTypeDate, alias: DateModified, length: 8 )
• Consumer.LastModifiedBy ( type: esriFieldTypeString, alias: LastModifiedBy, length: 30 )
• Consumer.NetworkID ( type: esriFieldTypeString, alias: NetworkID, length: 20 )
• Consumer.Rotation ( type: esriFieldTypeDouble, alias: Rotation )
• Consumer.WorkOrderNumber ( type: esriFieldTypeString, alias: WorkOrderNumber, length: 50 )
• Consumer.Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Consumer.ConsumerType ( type: esriFieldTypeSmallInteger, alias: ConsumerType , Coded Values: [0: Primary] , [1: Secondary] )
• Consumer.KWH ( type: esriFieldTypeInteger, alias: KWH )
• Consumer.KW ( type: esriFieldTypeDouble, alias: KW )
• Consumer.X_Coord ( type: esriFieldTypeDouble, alias: X_Coord )
• Consumer.Y_Coord ( type: esriFieldTypeDouble, alias: Y_Coord )
• Consumer.Prikey ( type: esriFieldTypeInteger, alias: Prikey )
• Consumer.KVA ( type: esriFieldTypeDouble, alias: KVA )
• Consumer.FieldMeter ( type: esriFieldTypeString, alias: FieldMeter, length: 50 )
• Consumer.Parent_Map_Num ( type: esriFieldTypeString, alias: Parent_Map_Num, length: 50 )
• Consumer.SHAPE ( type: esriFieldTypeGeometry, alias: Shape )
• Consumer.CUSTNUMBER ( type: esriFieldTypeString, alias: CustNumber, length: 80 )
• Consumer.LASTNAME ( type: esriFieldTypeString, alias: lastName, length: 13 )
• Consumer.FIRSTNAME ( type: esriFieldTypeString, alias: firstName, length: 9 )
• Consumer.MNAME ( type: esriFieldTypeString, alias: mName, length: 9 )
• Consumer.DBANAME ( type: esriFieldTypeString, alias: dBAName, length: 30 )
• Consumer.HOMEPHONE ( type: esriFieldTypeString, alias: homePhone, length: 16 )
• Consumer.DAYPHONE ( type: esriFieldTypeString, alias: dayPhone, length: 16 )
• Consumer.BILLADDR1 ( type: esriFieldTypeString, alias: billAddr1, length: 80 )
• Consumer.BILLADDR2 ( type: esriFieldTypeString, alias: billAddr2, length: 80 )
• Consumer.CUSTID ( type: esriFieldTypeString, alias: CUSTID, length: 32 )
• Consumer.SERVADDR1 ( type: esriFieldTypeString, alias: SERVADDR1, length: 40 )
• Consumer.CONNECTDATE ( type: esriFieldTypeString, alias: CONNECTDATE, length: 32 )
• Consumer.DISCONNECTDATE ( type: esriFieldTypeString, alias: DISCONNECTDATE, length: 32 )
• Consumer.METERNO ( type: esriFieldTypeString, alias: meterNo, length: 80 )
• Consumer.LOCNUMBER ( type: esriFieldTypeString, alias: LocNumber, length: 16 )
• Consumer.MOBILEPHONE ( type: esriFieldTypeString, alias: mobilePhone, length: 7 )
• Consumer.ACCOUNTNUMBER ( type: esriFieldTypeString, alias: ACCOUNTNUMBER, length: 32 )
• Consumer.REVENUECLASS ( type: esriFieldTypeString, alias: REVENUECLASS, length: 20 )
• Consumer.SERVSTATUS ( type: esriFieldTypeString, alias: SERVSTATUS, length: 16 )
• Consumer.SPECIALNEEDS ( type: esriFieldTypeString, alias: SPECIALNEEDS, length: 40 )
• Consumer.FORM ( type: esriFieldTypeString, alias: form, length: 50 )
• Consumer.MULTIPLIER ( type: esriFieldTypeString, alias: multiplier, length: 20 )
• Consumer.DistributedGeneration ( type: esriFieldTypeSmallInteger, alias: DistributedGeneration , Coded Values: [0: No] , [1: Yes] )
• Consumer.MapNumberPhoto ( type: esriFieldTypeString, alias: MapNumberPhoto, length: 50 )
• Consumer.OldLocation ( type: esriFieldTypeString, alias: OldLocation, length: 16 )
• Consumer.HOMEAC ( type: esriFieldTypeString, alias: homeAc, length: 3 )
• Consumer.DAYAC ( type: esriFieldTypeString, alias: dayAc, length: 3 )
• Consumer.MOBILEAC ( type: esriFieldTypeString, alias: mobileAc, length: 3 )
• Consumer.SolarSite ( type: esriFieldTypeSmallInteger, alias: SolarSite , Coded Values: [0: No] , [1: Yes] )
• Consumer.FiberZone ( type: esriFieldTypeString, alias: FiberZone, length: 8 )
• Consumer.Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Consumer.Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• Consumer.FiberZoneSub ( type: esriFieldTypeString, alias: FiberZoneSub, length: 8 )
• Consumer.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• Consumer.UpdatePhotos ( type: esriFieldTypeString, alias: UpdatePhotos, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• Consumer.GlobalIDReference ( type: esriFieldTypeString, alias: GlobalIDReference, length: 100 )
• Consumer.GridID ( type: esriFieldTypeString, alias: GridID, length: 7 )
• Consumer.email ( type: esriFieldTypeString, alias: email, length: 75 )
• Consumer.ac_py_BoardDistrict ( type: esriFieldTypeString, alias: ac_py_BoardDistrict, length: 3 )
• Consumer.ac_py_ElectricFeeder ( type: esriFieldTypeString, alias: ac_py_ElectricFeeder, length: 5 )
• Consumer.ac_py_FiberFeeder ( type: esriFieldTypeString, alias: ac_py_FiberFeeder, length: 8 )
• Consumer.GRIDLOCATION ( type: esriFieldTypeString, alias: gridLocation, length: 50 )
• Consumer.County ( type: esriFieldTypeString, alias: County, length: 3 )
• Consumer.ac_sql_bCity ( type: esriFieldTypeString, alias: ac_sql_bCity, length: 50 )
• Consumer.ac_sql_bState ( type: esriFieldTypeString, alias: ac_sql_bState, length: 2 )
• Consumer.ac_sql_bZip ( type: esriFieldTypeString, alias: ac_sql_bZip, length: 5 )
• Consumer.ac_sql_sCity ( type: esriFieldTypeString, alias: ac_sql_sCity, length: 50 )
• Consumer.ac_sql_sState ( type: esriFieldTypeString, alias: ac_sql_sState, length: 2 )
• Consumer.ac_sql_sZip ( type: esriFieldTypeString, alias: ac_sql_sZip, length: 5 )
• Consumer.ac_py_Township ( type: esriFieldTypeString, alias: ac_py_Township, length: 28 )
• Consumer.EVCharger ( type: esriFieldTypeString, alias: EVCharger, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.ACCOUNT_NUMBER ( type: esriFieldTypeDouble, alias: ACCOUNT_NUMBER )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_NUMBER ( type: esriFieldTypeDouble, alias: CUSTOMER_NUMBER )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_TYPE ( type: esriFieldTypeString, alias: SERVICE_TYPE, length: 5 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.STATUS_NUMBER ( type: esriFieldTypeSmallInteger, alias: STATUS_NUMBER )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.STATUS_CODE ( type: esriFieldTypeString, alias: STATUS_CODE, length: 1 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.PRT_CODE ( type: esriFieldTypeSmallInteger, alias: PRT_CODE )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_ADDRESS ( type: esriFieldTypeString, alias: CUSTOMER_ADDRESS, length: 122 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_CITY ( type: esriFieldTypeString, alias: CUSTOMER_CITY, length: 18 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_STATE ( type: esriFieldTypeString, alias: CUSTOMER_STATE, length: 2 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_ZIP ( type: esriFieldTypeString, alias: CUSTOMER_ZIP, length: 6 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_EMAIL ( type: esriFieldTypeString, alias: CUSTOMER_EMAIL, length: 50 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CYCLE_CODE ( type: esriFieldTypeSmallInteger, alias: CYCLE_CODE )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.NEWS_CODE ( type: esriFieldTypeSmallInteger, alias: NEWS_CODE )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_FIRSTNAME ( type: esriFieldTypeString, alias: CUSTOMER_FIRSTNAME, length: 13 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_LASTNAME ( type: esriFieldTypeString, alias: CUSTOMER_LASTNAME, length: 17 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_MIDDLENAME ( type: esriFieldTypeString, alias: CUSTOMER_MIDDLENAME, length: 9 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_FULLNAME ( type: esriFieldTypeString, alias: CUSTOMER_FULLNAME, length: 36 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_HOMEPHONE ( type: esriFieldTypeString, alias: CUSTOMER_HOMEPHONE, length: 10 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_MOBILEPHONE ( type: esriFieldTypeString, alias: CUSTOMER_MOBILEPHONE, length: 10 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_BUSINESSPHONE ( type: esriFieldTypeString, alias: CUSTOMER_BUSINESSPHONE, length: 10 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_HOUSENUMBER ( type: esriFieldTypeString, alias: SERVICE_HOUSENUMBER, length: 5 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_HOMEADDRESS1 ( type: esriFieldTypeString, alias: SERVICE_HOMEADDRESS1, length: 40 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_CITY ( type: esriFieldTypeString, alias: SERVICE_CITY, length: 18 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_STATE ( type: esriFieldTypeString, alias: SERVICE_STATE, length: 2 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_ZIP ( type: esriFieldTypeString, alias: SERVICE_ZIP, length: 6 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.VOTING_DISTRICT ( type: esriFieldTypeString, alias: VOTING_DISTRICT, length: 3 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CAN_VOTE ( type: esriFieldTypeString, alias: CAN_VOTE, length: 1 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CURRENT_TRUSTEE ( type: esriFieldTypeString, alias: CURRENT_TRUSTEE, length: 30 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CONNECT_DATE ( type: esriFieldTypeDate, alias: CONNECT_DATE, length: 8 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.DISCONNECT_DATE ( type: esriFieldTypeDate, alias: DISCONNECT_DATE, length: 8 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.CUSTOMER_COUNTY ( type: esriFieldTypeString, alias: CUSTOMER_COUNTY, length: 30 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_COUNTY ( type: esriFieldTypeString, alias: SERVICE_COUNTY, length: 30 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_COUNTY_CD ( type: esriFieldTypeString, alias: SERVICE_COUNTY_CD, length: 3 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.PRIMARY_RATE_SCHEDULE ( type: esriFieldTypeString, alias: PRIMARY_RATE_SCHEDULE, length: 5 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICE_SUBDIVISION ( type: esriFieldTypeString, alias: SERVICE_SUBDIVISION, length: 40 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.ACCOUNT_NUMBER_STR ( type: esriFieldTypeString, alias: ACCOUNT_NUMBER_STR, length: 50 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_SRV_PT_SW ( type: esriFieldTypeString, alias: BI_SRV_PT_SW, length: 1 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_REV_CLASS_CD ( type: esriFieldTypeSmallInteger, alias: BI_REV_CLASS_CD )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_SRV_LOC_NBR ( type: esriFieldTypeDouble, alias: BI_SRV_LOC_NBR )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_ADDR1 ( type: esriFieldTypeString, alias: BI_ADDR1, length: 40 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_ADDR2 ( type: esriFieldTypeString, alias: BI_ADDR2, length: 40 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_ADDR3 ( type: esriFieldTypeString, alias: BI_ADDR3, length: 40 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_CONS_CLASS_CD ( type: esriFieldTypeString, alias: BI_CONS_CLASS_CD, length: 1 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICELOCATIONADDR ( type: esriFieldTypeString, alias: SERVICELOCATIONADDR, length: 40 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_EBILL_SW ( type: esriFieldTypeString, alias: BI_EBILL_SW, length: 1 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_SAL ( type: esriFieldTypeString, alias: BI_SAL, length: 6 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_GEN ( type: esriFieldTypeString, alias: BI_GEN, length: 3 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_CNTY_CD ( type: esriFieldTypeString, alias: BI_CNTY_CD, length: 3 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.SERVICEADDRESS2 ( type: esriFieldTypeString, alias: SERVICEADDRESS2, length: 40 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_X_COORD ( type: esriFieldTypeString, alias: BI_X_COORD, length: 15 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_Y_COORD ( type: esriFieldTypeString, alias: BI_Y_COORD, length: 15 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_TAX_EXEMPT_SW ( type: esriFieldTypeString, alias: BI_TAX_EXEMPT_SW, length: 1 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_BUDG_START_DT ( type: esriFieldTypeDate, alias: BI_BUDG_START_DT, length: 8 )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.BI_MO_BUDG_AMT ( type: esriFieldTypeDouble, alias: BI_MO_BUDG_AMT )
• AUTOMATION.WEBREADER.%AA_AllCustomerView.ESRI_OID ( type: esriFieldTypeInteger, alias: ESRI_OID )

Types:

ID: 0
Name: Primary
Domains:
• Consumer.PhaseCode:
  Inherited
• Consumer.Feeder:
  Inherited
• Consumer.MeterType:
  Coded Values: [0: Residential] , [1: SmallCommerical] , [2: LargeCommercial] , ...8 more...
• Consumer.Enabled:
  Inherited

---

ID: 1
Name: Secondary
Domains:
• Consumer.PhaseCode:
  Inherited
• Consumer.Feeder:
  Inherited
• Consumer.MeterType:
  Coded Values: [0: Residential] , [1: SmallCommerical] , [2: LargeCommercial] , ...8 more...
• Consumer.Enabled:
  Inherited
• Consumer.DistributedGeneration:
  Inherited

---

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata