{ "currentVersion": 10.91, "id": 33, "name": "SIGEL.CONTROLALQUILERTRAFO", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 7, "name": "SIGEL.Transformer", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleOrigin", "keyField": "NUMALQUILER", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "SOLICITANTE", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SOLICITANTE", "type": "esriFieldTypeString", "alias": "Solicitante", "domain": { "type": "codedValue", "name": "SolicitAlquilTransf", "description": "Solicictante Alquiler de transformador", "codedValues": [ { "name": "Representante Legal", "code": "Representante Legal" }, { "name": "Dueno de la localizacion", "code": "SolictDuenodelaLocalizacion" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "SOLICITANTE" }, { "name": "IDENTIFICACION", "type": "esriFieldTypeString", "alias": "Tipo de Identificacion", "domain": { "type": "codedValue", "name": "IDENTIFALQUILERTRNSF", "description": "Identificacion quien solicita alquiler Transf", "codedValues": [ { "name": "Cedula Fisica", "code": "Cedula Fisica" }, { "name": "cedula Juridica", "code": "cedula Juridica" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "IDENTIFICACION" }, { "name": "NOMBRESOLICTANTE", "type": "esriFieldTypeString", "alias": "Nombre Solicitante", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "NOMBRESOLICTANTE" }, { "name": "TELEFONO_1", "type": "esriFieldTypeString", "alias": "Telefono_1", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "TELEFONO_1" }, { "name": "TELEFONO_2", "type": "esriFieldTypeString", "alias": "Telefono_2", "domain": null, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "TELEFONO_2" }, { "name": "CORREOELECTRONICO", "type": "esriFieldTypeString", "alias": "Correo Electronico", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "CORREOELECTRONICO" }, { "name": "SERVICALQUILERPOR", "type": "esriFieldTypeString", "alias": "Sericio Alquiler Por", "domain": { "type": "codedValue", "name": "SERVICALQUILERTRANSF", "description": "Servicio Alquiler Transformador", "codedValues": [ { "name": "Averia", "code": "Averia" }, { "name": "Servicio Provisional", "code": "Servicio Provisional" }, { "name": "Servicio Provisional construccion", "code": "Servicio Provis construcc" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SERVICALQUILERPOR" }, { "name": "DOCUMENTREFERENCIA", "type": "esriFieldTypeString", "alias": "Documento de Referencia", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "DOCUMENTREFERENCIA" }, { "name": "DIRECCINSTALACION", "type": "esriFieldTypeString", "alias": "Direcion de la Instalacion", "domain": null, "editable": true, "nullable": true, "length": 160, "defaultValue": null, "modelName": "DIRECCINSTALACION" }, { "name": "TIEMPALQIILER", "type": "esriFieldTypeString", "alias": "Tiempo del Alquiler", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "TIEMPALQIILER" }, { "name": "FECHAINST", "type": "esriFieldTypeDate", "alias": "Fecha Instalacion", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FECHAINST" }, { "name": "FECHAFINAL", "type": "esriFieldTypeDate", "alias": "Fecha Finalizacion", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FECHAFINAL" }, { "name": "SISTEMAMEDICION", "type": "esriFieldTypeString", "alias": "Sistema de Medicion", "domain": { "type": "codedValue", "name": "SistemAlquilermediciones", "description": "Sistema de mediciones ", "codedValues": [ { "name": "Monofasico", "code": "1F" }, { "name": "Bifasico", "code": "2F" }, { "name": "Trifasico", "code": "3F" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "SISTEMAMEDICION" }, { "name": "CODIGO", "type": "esriFieldTypeInteger", "alias": "Codigo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CODIGO" }, { "name": "NUM_TRAFO_1", "type": "esriFieldTypeString", "alias": "N° Trafo Fase A", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "NUM_TRAFO_1" }, { "name": "NUM_TRAFO_2", "type": "esriFieldTypeString", "alias": "N° Trafo Fase B", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "NUM_TRAFO_2" }, { "name": "NUM_TRAFO_3", "type": "esriFieldTypeString", "alias": "N° Trafo Fase C", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "NUM_TRAFO_3" }, { "name": "NUM_TRAFODIS", "type": "esriFieldTypeString", "alias": "Nº Trafo Disipador", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "NUM_TRAFODIS" }, { "name": "EQUIPPROTECASOCI", "type": "esriFieldTypeString", "alias": "Equipos de proteccion asociados", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "EQUIPPROTECASOCI" }, { "name": "MONTFACTALQUILER", "type": "esriFieldTypeInteger", "alias": "Monto Alquiler Mensual", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MONTFACTALQUILER" }, { "name": "MONTFACTGARNTALQUILER", "type": "esriFieldTypeInteger", "alias": "Monto Garantia del Alquiler", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MONTFACTGARNTALQUILER" }, { "name": "TIPOFACTGARANTUTILIZADA", "type": "esriFieldTypeString", "alias": "Tipo de Garantia Utilizada", "domain": { "type": "codedValue", "name": "TIPOGARANTALQUILER", "description": "Tipo Garantia Utilizada en Alquiler Transf", "codedValues": [ { "name": "712006 Garantia bancaria", "code": "712006 Garantia bancaria" }, { "name": "263550 Garantia en efectivo", "code": "263550 Garantia en efectivo" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "TIPOFACTGARANTUTILIZADA" }, { "name": "FACTNUM_MEDIDOR", "type": "esriFieldTypeString", "alias": "Numero Medidor", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "FACTNUM_MEDIDOR" }, { "name": "FACTLOCALIZACION", "type": "esriFieldTypeString", "alias": "Localizacion", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACTLOCALIZACION" }, { "name": "PRGTIEMPOALQUILER", "type": "esriFieldTypeString", "alias": "Tiempo de Prorroga Alquiler", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PRGTIEMPOALQUILER" }, { "name": "PRGFECHINST", "type": "esriFieldTypeDate", "alias": "Fecha Instalacion Alquiler Prorroga", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PRGFECHINST" }, { "name": "PRGFECHFINIC", "type": "esriFieldTypeDate", "alias": "Inicia Fecha Prorroga", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PRGFECHFINIC" }, { "name": "PRGFECHFINAL", "type": "esriFieldTypeDate", "alias": "Finaliza Fecha Prorroga", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PRGFECHFINAL" }, { "name": "PRGMONTAQLUILERMES", "type": "esriFieldTypeInteger", "alias": "Monto Alquiler Mensual Prorroga", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PRGMONTAQLUILERMES" }, { "name": "PRGTIPOGARANTALQUILER", "type": "esriFieldTypeString", "alias": "Tipo Garantia Utilizada Prorroga", "domain": { "type": "codedValue", "name": "TIPOGARANTALQUILER", "description": "Tipo Garantia Utilizada en Alquiler Transf", "codedValues": [ { "name": "712006 Garantia bancaria", "code": "712006 Garantia bancaria" }, { "name": "263550 Garantia en efectivo", "code": "263550 Garantia en efectivo" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PRGTIPOGARANTALQUILER" }, { "name": "USUARIOCREADOR", "type": "esriFieldTypeString", "alias": "Usuario Creador", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "USUARIOCREADOR" }, { "name": "USUARIOMODIFICADOR", "type": "esriFieldTypeString", "alias": "Usuario Modificado", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "USUARIOMODIFICADOR" }, { "name": "FECHACREADO", "type": "esriFieldTypeDate", "alias": "Fecha Creado", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FECHACREADO" }, { "name": "FECHAMODIFICADO", "type": "esriFieldTypeDate", "alias": "Fecha Modificado", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FECHAMODIFICADO" }, { "name": "SUCURSAL", "type": "esriFieldTypeString", "alias": "Sucursal", "domain": { "type": "codedValue", "name": "NombreSucursal", "description": "Nombre Sucursal", "codedValues": [ { "name": "Sucursal Central", "code": "SucCentral" }, { "name": "Sucursal Escazu", "code": "SucEscazu" }, { "name": "Sucursal Desamparados", "code": "SucDesamp" }, { "name": "Sucursal Heredia", "code": "SucHeredia" }, { "name": "Sucursal Guadalupe", "code": "SucGuadalupe" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "SUCURSAL" }, { "name": "NUMALQUILER", "type": "esriFieldTypeString", "alias": "N° Alquiler", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "NUMALQUILER" }, { "name": "APROBACIONCLIENTE", "type": "esriFieldTypeString", "alias": "Aprobacion del Cliente", "domain": { "type": "codedValue", "name": "AprobSolicAlquiTransf", "description": "Aprobacion Solicitud Alquiler Transf", "codedValues": [ { "name": "Aprobada", "code": "Aprobada" }, { "name": "No Aprobada", "code": "NoAprobada" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "APROBACIONCLIENTE" }, { "name": "NUMIDENTIFICACION", "type": "esriFieldTypeString", "alias": "N° Identificacion", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "NUMIDENTIFICACION" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" } ], "indexes": [ { "name": "GDB_74806_NUMALQ", "fields": "NUMALQUILER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R6222_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_6222", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_6222", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SIGEL.CONTROLALQUILERTRAFO", "description": "", "prototype": { "attributes": { "NUMIDENTIFICACION": null, "APROBACIONCLIENTE": null, "SOLICITANTE": null, "IDENTIFICACION": null, "NOMBRESOLICTANTE": null, "TELEFONO_1": null, "TELEFONO_2": null, "CORREOELECTRONICO": null, "SERVICALQUILERPOR": null, "DOCUMENTREFERENCIA": null, "DIRECCINSTALACION": null, "TIEMPALQIILER": null, "FECHAINST": null, "FECHAFINAL": null, "SISTEMAMEDICION": null, "CODIGO": null, "NUM_TRAFO_1": null, "NUM_TRAFO_2": null, "NUM_TRAFO_3": null, "NUM_TRAFODIS": null, "EQUIPPROTECASOCI": null, "MONTFACTALQUILER": null, "MONTFACTGARNTALQUILER": null, "TIPOFACTGARANTUTILIZADA": null, "FACTNUM_MEDIDOR": null, "FACTLOCALIZACION": null, "PRGTIEMPOALQUILER": null, "PRGFECHINST": null, "PRGFECHFINIC": null, "PRGFECHFINAL": null, "PRGMONTAQLUILERMES": null, "PRGTIPOGARANTALQUILER": null, "USUARIOCREADOR": null, "USUARIOMODIFICADOR": null, "FECHACREADO": null, "FECHAMODIFICADO": null, "SUCURSAL": null, "NUMALQUILER": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "df904f7e7a73445fb5b47afc3cd56fc2" }