Name: CONEXIONCONSUMIDOR

Display Field: SIGELEC.CONEXIONCONSUMIDOR.USUARIOREGISTRO

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ca8abf2e5c334a5da46f490d2f300e76

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: false
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 )
• CODIGOCLIENTE ( type: esriFieldTypeString, alias: Codigo, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CodigoCliente )
• PROYECTOCONSTRUCCION ( type: esriFieldTypeString, alias: PROYECTOCONSTRUCCION, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROYECTOCONSTRUCCION )
• FECHACONSTRUCCION ( type: esriFieldTypeDate, alias: FECHACONSTRUCCION, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FECHACONSTRUCCION )
• NOVEDADES ( type: esriFieldTypeSmallInteger, alias: Novedades, editable: true, nullable: true, defaultValue: null, modelName: NOVEDADES , Coded Values: [5: Hurto] , [0: Sin Novedad] , [1: Medidor Alto (se requiere escalera)] , ...12 more... )
• CODRUT ( type: esriFieldTypeString, alias: Agencia_Ruta, editable: true, nullable: true, length: 9, defaultValue: null, modelName: CODRUT )
• MDENUMFAB ( type: esriFieldTypeString, alias: N. Serie Medidor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MDENUMFAB )
• MDENUMEMP ( type: esriFieldTypeString, alias: SR del Medidor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MDENUMEMP )
• CODIGOUNICO ( type: esriFieldTypeString, alias: Código Único, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODIGOUNICO )
• SECUENCIAFASE ( type: esriFieldTypeString, alias: Fase de Bajo Voltaje, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SECUENCIAFASE , Coded Values: [a: a] , [b: b] , [c: c] , ...4 more... )
• MEDMAR ( type: esriFieldTypeString, alias: Marca, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MEDMAR , Coded Values: [ACT: Actaris] , [ABB: Asea Brown Boveri] , [AEG: AEG] , ...124 more... )
• TIPOMEDIDOR ( type: esriFieldTypeString, alias: Tipo Medidor, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TIPOMEDIDOR , Coded Values: [0601: Eletromecánico-Directa-Bornera] , [0602: Eletromecánico-Directa-Socket] , [0603: Eletromec-Indirecta-Bornera] , ...20 more... )
• PREPAGO ( type: esriFieldTypeString, alias: Prepago, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PREPAGO , Coded Values: [N: No] , [S: Si] )
• CODIGOESTRUCTURA ( type: esriFieldTypeString, alias: Codigo Estructua, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODIGOESTRUCTURA , Coded Values: [MEC0001: 1E100_1AC] , [MED0001: 1D200_2SD] , [MED0002: 1E100_2AD] , ...53 more... )
• FECHAMODIFICACION ( type: esriFieldTypeDate, alias: Fecha Modificacion, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FECHAMODIFICACION )
• CODIGOEMPRESA ( type: esriFieldTypeString, alias: Codigo Empresa, editable: true, nullable: true, length: 10, defaultValue: EEA, modelName: CODIGOEMPRESA , Coded Values: [CNELMANABI: CNELEP-MANABI] , [CNELELORO: CNELEP-EL ORO] , [CNELSTODGO: CNELEP-SANTO DOMINGO] , ...17 more... )
• PROYECTOMODIFICACION ( type: esriFieldTypeString, alias: Proyecto Modificacion, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROYECTOMODIFICACION )
• OBSERVACIONES ( type: esriFieldTypeString, alias: Observaciones, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OBSERVACIONES )
• COMENTARIOS ( type: esriFieldTypeString, alias: Comentarios, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMENTARIOS )
• PROVINCIA ( type: esriFieldTypeString, alias: Provincia, editable: true, nullable: true, length: 2, defaultValue: 03, modelName: PROVINCIA , Coded Values: [01: AZUAY] , [02: BOLIVAR] , [03: CANAR] , ...22 more... )
• CANTON ( type: esriFieldTypeString, alias: Canton, editable: true, nullable: true, length: 4, defaultValue: 0301, modelName: CANTON , Coded Values: [0101: CUENCA] , [0102: GIRON] , [0103: GUALACEO] , ...221 more... )
• PARROQUIA ( type: esriFieldTypeString, alias: Parroquia, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PARROQUIA , Coded Values: [010101: BELLAVISTA] , [010102: CAÑARIBAMBA] , [010103: EL BATÁN] , ...1407 more... )
• ORDENTRABAJO ( type: esriFieldTypeString, alias: Orden de trabajo, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ORDENTRABAJO )
• CIRCUITOS ( type: esriFieldTypeString, alias: Circuitos, editable: true, nullable: true, length: 3, defaultValue: null, modelName: CIRCUITOS , Coded Values: [A: A] , [B: B] , [C: C] , ...7 more... )
• ESTADO ( type: esriFieldTypeSmallInteger, alias: Estdo, editable: true, nullable: true, defaultValue: null, modelName: ESTADO , Coded Values: [1: Buen Estado] , [2: Mal Estado] )
• EXISTENOVEDAD ( type: esriFieldTypeSmallInteger, alias: Existe Novedad, editable: true, nullable: true, defaultValue: null, modelName: EXISTENOVEDAD , Coded Values: [1: Si] , [2: No] )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: CONEXIONCONSUMIDOR
  Description:
  Prototype:
  ESTADO: null
  EXISTENOVEDAD: null
  CODIGOCLIENTE: null
  PROYECTOCONSTRUCCION: null
  FECHACONSTRUCCION: null
  NOVEDADES: null
  CODRUT: null
  MDENUMFAB: null
  MDENUMEMP: null
  CODIGOUNICO: null
  SECUENCIAFASE: null
  MEDMAR: null
  TIPOMEDIDOR: null
  PREPAGO: null
  CODIGOESTRUCTURA: null
  FECHAMODIFICACION: null
  CODIGOEMPRESA: EEA
  PROYECTOMODIFICACION: null
  OBSERVACIONES: null
  COMENTARIOS: null
  PROVINCIA: 03
  CANTON: 0301
  PARROQUIA: null
  ORDENTRABAJO: null
  CIRCUITOS: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Punto Carga (35) -- Related To: Punto de Carga (8)
• ATRIBUTOSCONSUMIDOR (62) -- Related To: ATRIBUTOSCONSUMIDOR (23)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata