Name: SIGELEC.CONEXIONCONSUMIDOR

Display Field: USUARIOREGISTRO

Type: Table

Geometry Type: N/A

Description:

Service Item Id: aa768f44123c458f81898834edde6c42

Copyright Text:

Default Visibility: false

MaxRecordCount: 5000

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: 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 )
• USUARIOREGISTRO ( type: esriFieldTypeString, alias: Usu Cre, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UsuarioRegistro )
• FECHAREGISTRO ( type: esriFieldTypeDate, alias: F Cre Sis, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FechaRegistro )
• FECHAMODIFICACIONREGISTRO ( type: esriFieldTypeDate, alias: F Mod Sis, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FechaModificacionRegistro )
• USUARIOMODIFICACIONREGISTRO ( type: esriFieldTypeString, alias: Usu Mod, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UsuarioModificacionRegistro )
• PUNTOCARGAOBJECTID ( type: esriFieldTypeInteger, alias: Punto Carga OId, editable: true, nullable: true, defaultValue: null, modelName: PuntoCargaObjectID )
• 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 )
• POS_T_HOR ( type: esriFieldTypeInteger, alias: POS_T_HOR, editable: true, nullable: true, defaultValue: 1, modelName: POS_T_HOR )
• POS_T_VER ( type: esriFieldTypeInteger, alias: POS_T_VER, editable: true, nullable: true, defaultValue: 1, modelName: POS_T_VER )
• MIPCRGCOD ( type: esriFieldTypeString, alias: MIPCRGCOD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MIPCRGCOD )
• MIPCRG_OID ( type: esriFieldTypeString, alias: MIPCRG_OID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MIPCRG_OID )
• CLIPRVCODP ( type: esriFieldTypeString, alias: CLIPRVCOD, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CLIPRVCODP )
• CLICANCODP ( type: esriFieldTypeString, alias: CLICANCODP, editable: true, nullable: true, length: 2, defaultValue: null, modelName: CLICANCODP )
• 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 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• CODIGOUNICO ( type: esriFieldTypeString, alias: Código Único, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODIGOUNICO )
• PUNTOCARGAGLOBALID ( type: esriFieldTypeGUID, alias: PUNTOCARGAGLOBALID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: PUNTOCARGAGLOBALID )
• FECHAMODIFICACION ( type: esriFieldTypeDate, alias: F Modificacion, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FECHAMODIFICACION )
• CODIGOEMPRESA ( type: esriFieldTypeString, alias: Codigo Empresa, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODIGOEMPRESA , Coded Values: [CNELMANABI: CNELEP-MANABI] , [CNELELORO: CNELEP-EL ORO] , [CNELSTODGO: CNELEP-SANTO DOMINGO] , ...17 more... )
• PROYECTOMODIFICACION ( type: esriFieldTypeString, alias: Proyecto Mod, editable: true, nullable: true, length: 32, defaultValue: null, modelName: PROYECTOMODIFICACION )
• PROVINCIA ( type: esriFieldTypeString, alias: Provincia, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PROVINCIA , Coded Values: [01: AZUAY] , [02: BOLIVAR] , [03: CANAR] , ...22 more... )
• CANTON ( type: esriFieldTypeString, alias: Canton, editable: true, nullable: true, length: 4, defaultValue: null, 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] , ...1408 more... )
• EXISTENOVEDAD ( type: esriFieldTypeSmallInteger, alias: Existe Novedad, editable: true, nullable: true, defaultValue: null, modelName: EXISTENOVEDAD , Coded Values: [1: Si] , [2: No] )
• ESTADO ( type: esriFieldTypeSmallInteger, alias: Estado, editable: true, nullable: true, defaultValue: null, modelName: ESTADO , Coded Values: [1: Buen Estado] , [2: Mal Estado] )
• OBSERVACIONES ( type: esriFieldTypeString, alias: COMENTARIOS, 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 )
• MIESTADO ( type: esriFieldTypeString, alias: MIESTADO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MIESTADO )
• MIGUID ( type: esriFieldTypeGUID, alias: MIGUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: MIGUID )
• MIOID ( type: esriFieldTypeInteger, alias: MIOID, editable: true, nullable: true, defaultValue: null, modelName: MIOID )
• SECUENCIAFASE ( type: esriFieldTypeString, alias: Secuencia Fase BV, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SECUENCIAFASE , Coded Values: [a: a] , [b: b] , [c: c] , ...4 more... )
• TIPOMEDIDOR ( type: esriFieldTypeString, alias: TIPOMEDIDOR, 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] , ...21 more... )
• MEDMAR ( type: esriFieldTypeString, alias: Codigo Medidor, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MEDMAR , Coded Values: [ACL: Aclara] , [ACT: Actaris] , [ABB: Asea Brown Boveri] , ...136 more... )
• PREPAGO ( type: esriFieldTypeString, alias: PREPAGO, editable: true, nullable: true, length: 2, defaultValue: N, modelName: PREPAGO , Coded Values: [N: No] , [S: Si] )
• CODIGOESTRUCTURA ( type: esriFieldTypeString, alias: CODIGOESTRUCTURA, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CODIGOESTRUCTURA , Coded Values: [MEC0001: 1E100_1AC] , [MED0001: 1D200_2SD] , [MED0002: 1E100_2AD] , ...62 more... )
• CLIRLSCOD ( type: esriFieldTypeString, alias: CLIRLSCOD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CLIRLSCOD )
• CLISLCCOD ( type: esriFieldTypeString, alias: CLISLCCOD, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CLISLCCOD )
• CLISECINM ( type: esriFieldTypeString, alias: CLISECINM, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CLISECINM )
• 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: F12, modelName: CIRCUITOS , Coded Values: [A: A] , [B: B] , [C: C] , ...7 more... )

Templates:

• Name: SIGELEC.CONEXIONCONSUMIDOR
  Description:
  Prototype:
  ORDENTRABAJO: null
  CLISECINM: null
  USUARIOREGISTRO: null
  FECHAREGISTRO: null
  FECHAMODIFICACIONREGISTRO: null
  USUARIOMODIFICACIONREGISTRO: null
  PUNTOCARGAOBJECTID: null
  CODIGOCLIENTE: null
  PROYECTOCONSTRUCCION: null
  FECHACONSTRUCCION: null
  POS_T_HOR: 1
  POS_T_VER: 1
  MIPCRGCOD: null
  MIPCRG_OID: null
  CLIPRVCODP: null
  CLICANCODP: null
  NOVEDADES: null
  CODRUT: null
  MDENUMFAB: null
  MDENUMEMP: null
  CIRCUITOS: F12
  CODIGOUNICO: null
  PUNTOCARGAGLOBALID: null
  FECHAMODIFICACION: null
  CODIGOEMPRESA: null
  PROYECTOMODIFICACION: null
  PROVINCIA: null
  CANTON: null
  PARROQUIA: null
  EXISTENOVEDAD: null
  ESTADO: null
  OBSERVACIONES: null
  COMENTARIOS: null
  MIESTADO: null
  MIGUID: null
  MIOID: null
  SECUENCIAFASE: null
  TIPOMEDIDOR: null
  MEDMAR: null
  PREPAGO: N
  CODIGOESTRUCTURA: null
  CLIRLSCOD: null
  CLISLCCOD: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Atributos de Consumidor (61) -- Related To: SIGELEC.ATRIBUTOSCONSUMIDOR (34)
• Punto Carga (1) -- Related To: Punto de Carga (1)

Capabilities: Query,Extract

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   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata