Name: CONSUMER

Display Field: FeederName

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 8a58241f922e4beca1071a64f3b91d97

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ConsumerAccountNumber ( type: esriFieldTypeString, alias: ConsumerAccountNumber, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ConsumerAccountNumber )
• Consumerinformationnumber ( type: esriFieldTypeString, alias: Consumerinformationnumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Consumerinformationnumber )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Address )
• PhonenumberMobile ( type: esriFieldTypeString, alias: PhonenumberMobile, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PhonenumberMobile )
• ConnectedToPoleID ( type: esriFieldTypeString, alias: ConnectedToPoleID, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ConnectedToPoleID )
• ConnectedDTCCode ( type: esriFieldTypeString, alias: ConnectedDTCCode, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ConnectedDTCCode )
• FeederID ( type: esriFieldTypeString, alias: FeederID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FeederID )
• FeederName ( type: esriFieldTypeString, alias: FeederName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FeederName )
• SubstationCode ( type: esriFieldTypeString, alias: SubstationCode, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SubstationCode )
• SubstationName ( type: esriFieldTypeString, alias: SubstationName, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SubstationName )
• ConsumerStatus ( type: esriFieldTypeString, alias: ConsumerStatus, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ConsumerStatus )
• ConnectionStatus ( type: esriFieldTypeString, alias: ConnectionStatus, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ConnectionStatus )
• Typeofsupply ( type: esriFieldTypeString, alias: Typeofsupply, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Typeofsupply )
• ConnectedPhase ( type: esriFieldTypeSmallInteger, alias: ConnectedPhase, editable: true, nullable: true, defaultValue: null, modelName: ConnectedPhase )
• CustomerSupplyVoltage ( type: esriFieldTypeSmallInteger, alias: CustomerSupplyVoltage, editable: true, nullable: true, defaultValue: null, modelName: CustomerSupplyVoltage )
• ConsumerClass ( type: esriFieldTypeString, alias: ConsumerClass, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ConsumerClass )
• TariffCategory ( type: esriFieldTypeString, alias: TariffCategory, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TariffCategory )
• MeterOwnership ( type: esriFieldTypeString, alias: MeterOwnership, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MeterOwnership )
• MeterSerialNumber ( type: esriFieldTypeString, alias: MeterSerialNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MeterSerialNumber )
• MeterManufacturer ( type: esriFieldTypeString, alias: MeterManufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MeterManufacturer )
• TypeofMeter ( type: esriFieldTypeString, alias: TypeofMeter, editable: true, nullable: true, length: 20, defaultValue: null, modelName: TypeofMeter )
• ConnectionDate ( type: esriFieldTypeString, alias: ConnectionDate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConnectionDate )
• SanctionedLoad ( type: esriFieldTypeDouble, alias: SanctionedLoad, editable: true, nullable: true, defaultValue: null, modelName: SanctionedLoad )
• ConnectedLoad ( type: esriFieldTypeString, alias: ConnectedLoad, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ConnectedLoad )
• NOCScode ( type: esriFieldTypeString, alias: NOCScode, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOCScode )
• Circlecode ( type: esriFieldTypeString, alias: Circlecode, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Circlecode )
• Zonecode ( type: esriFieldTypeString, alias: Zonecode, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Zonecode )
• BookNumber ( type: esriFieldTypeString, alias: BookNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BookNumber )
• XLocation ( type: esriFieldTypeDouble, alias: XLocation, editable: true, nullable: true, defaultValue: null, modelName: XLocation )
• YLocation ( type: esriFieldTypeDouble, alias: YLocation, editable: true, nullable: true, defaultValue: null, modelName: YLocation )
• ConsumerName ( type: esriFieldTypeString, alias: ConsumerName, editable: true, nullable: true, length: 250, defaultValue: null, modelName: ConsumerName )
• BuildingID ( type: esriFieldTypeString, alias: BuildingID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BuildingID )
• Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype, editable: true, nullable: true, defaultValue: null, modelName: Subtype )
• BillGroup ( type: esriFieldTypeString, alias: BillGroup, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BillGroup )
• CustomerType ( type: esriFieldTypeString, alias: CustomerType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CustomerType )
• ConsumerNumber ( type: esriFieldTypeString, alias: ConsumerNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ConsumerNumber )
• StrucID_SP ( type: esriFieldTypeString, alias: StrucID_SP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StrucID_SP )
• Remarks ( type: esriFieldTypeString, alias: Remarks, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Remarks )
• Floor ( type: esriFieldTypeSmallInteger, alias: Floor, editable: true, nullable: true, defaultValue: null, modelName: Floor )
• IsAdminApprove ( type: esriFieldTypeInteger, alias: IsAdminApprove, editable: true, nullable: true, defaultValue: null, modelName: IsAdminApprove )
• ApprovedBy ( type: esriFieldTypeString, alias: ApprovedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ApprovedBy )
• ShiftedBy ( type: esriFieldTypeString, alias: ShiftedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ShiftedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• ApproveDate ( type: esriFieldTypeDate, alias: ApproveDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ApproveDate )
• UpdatedDate ( type: esriFieldTypeDate, alias: UpdatedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UpdatedDate )
• SurveyedBy ( type: esriFieldTypeString, alias: SurveyedBy, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SurveyedBy )
• SurveyedDate ( type: esriFieldTypeDate, alias: SurveyedDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SurveyedDate )
• ShiftedToMainDabase ( type: esriFieldTypeInteger, alias: ShiftedToMainDabase, editable: true, nullable: true, defaultValue: null, modelName: ShiftedToMainDabase )
• TrackingNumber ( type: esriFieldTypeString, alias: TrackingNumber, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TrackingNumber )
• SurveyID ( type: esriFieldTypeString, alias: SurveyID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SurveyID )
• NOCSName ( type: esriFieldTypeString, alias: NOCSName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOCSName )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: CONSUMER
  Description:
  Prototype:
  NOCSName: null
  SurveyID: null
  ConsumerAccountNumber: null
  Consumerinformationnumber: null
  Address: null
  PhonenumberMobile: null
  ConnectedToPoleID: null
  ConnectedDTCCode: null
  FeederID: null
  FeederName: null
  SubstationCode: null
  SubstationName: null
  ConsumerStatus: null
  ConnectionStatus: null
  Typeofsupply: null
  ConnectedPhase: null
  CustomerSupplyVoltage: null
  ConsumerClass: null
  TariffCategory: null
  MeterOwnership: null
  MeterSerialNumber: null
  MeterManufacturer: null
  TypeofMeter: null
  ConnectionDate: null
  SanctionedLoad: null
  ConnectedLoad: null
  NOCScode: null
  Circlecode: null
  Zonecode: null
  BookNumber: null
  XLocation: null
  YLocation: null
  ConsumerName: null
  BuildingID: null
  Subtype: null
  BillGroup: null
  CustomerType: null
  ConsumerNumber: null
  StrucID_SP: null
  Remarks: null
  Floor: null
  IsAdminApprove: null
  ApprovedBy: null
  ShiftedBy: null
  CreatedDate: null
  ApproveDate: null
  UpdatedDate: null
  SurveyedBy: null
  SurveyedDate: null
  ShiftedToMainDabase: null
  TrackingNumber: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ServicePoint (0) -- Related To: ServicePoint (0)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata