{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 109, "name": "Unidades de Supresores de Sobretensión", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": "SUBTYPE", "subtypeFieldName": "SUBTYPE", "subtypeField": "SUBTYPE", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SUBTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Subtipo", "domain": null }, { "name": "CUSTOM_ID", "type": "esriFieldTypeString", "alias": "Custom ID", "length": 15, "domain": null }, { "name": "LEGACY_ID", "type": "esriFieldTypeString", "alias": "ID Sistema Anterior", "length": 50, "domain": null }, { "name": "PREDESIGN_ID", "type": "esriFieldTypeString", "alias": "ID Prediseño", "length": 15, "domain": null }, { "name": "SERIAL_NUMBER", "type": "esriFieldTypeString", "alias": "Número Serial", "length": 50, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Matricula", "length": 50, "domain": null }, { "name": "ALIAS", "type": "esriFieldTypeString", "alias": "Matricula Alternativa", "length": 50, "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Descripcion", "length": 250, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Propietario", "length": 5, "domain": { "type": "codedValue", "name": "RED003", "description": "Propietarios [Text]", "codedValues": [ { "name": "OPERADOR DE RED", "code": "OR" }, { "name": "TERCERO PARTICULAR", "code": "TP" }, { "name": "TERCERO OFICIAL", "code": "TO" }, { "name": "MIXTO O.R. Y OFICIAL", "code": "MORF" }, { "name": "MIXTO O.R. Y PARCULAR", "code": "MORP" }, { "name": "MIXTO PARTICULAR Y OFICIAL", "code": "MPF" }, { "name": "PLATAFORMA DE INVERSION CAOBA", "code": "PKOBA" }, { "name": "PLATAFORMA DE INVERSION TESORITO", "code": "PTSTO" }, { "name": "PLATAFORMA DE INVERSION CUBICO", "code": "PCUBO" }, { "name": "PLATAFORMA DE INVERSION LAUREL", "code": "PLRL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OWNER_NAME", "type": "esriFieldTypeString", "alias": "Nombre del Propietario", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Tipo Proteccion", "length": 5, "domain": { "type": "codedValue", "name": "RED033", "description": "Tipos de Supresor [Text]", "codedValues": [ { "name": "BARRA TIPO FRANKLIN", "code": "FB" }, { "name": "DRENADORES DE SOBRE TENSION", "code": "DPS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PHASES_SEQUENCE", "type": "esriFieldTypeString", "alias": "Secuencia de Fases", "length": 5, "domain": { "type": "codedValue", "name": "RED013", "description": "Secuencia de Fases [Text]", "codedValues": [ { "name": "FASE R [A]", "code": "R" }, { "name": "FASE S [B]", "code": "S" }, { "name": "FASE T [C]", "code": "T" }, { "name": "FASES RS [AB]", "code": "RS" }, { "name": "FASES SR [BA]", "code": "SR" }, { "name": "FASES RT [AC]", "code": "RT" }, { "name": "FASES TR [CA]", "code": "TR" }, { "name": "FASES ST [BC]", "code": "ST" }, { "name": "FASES TS [CB]", "code": "TS" }, { "name": "FASES RST [ABC]", "code": "RST" }, { "name": "FASES RTS [ACB]", "code": "RTS" }, { "name": "FASES SRT [BAC]", "code": "SRT" }, { "name": "FASES STR [BCA]", "code": "STR" }, { "name": "FASES TSR [CBA]", "code": "TSR" }, { "name": "FASES TRS [CAB]", "code": "TRS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "BIL_RATING", "type": "esriFieldTypeDouble", "alias": "BIL - Nivel Básico Aislamiento (kV)", "domain": null }, { "name": "MANUFACTURE_DATE", "type": "esriFieldTypeDate", "alias": "Fecha de Fabricacion", "length": 8, "domain": null }, { "name": "INSTALLATION_DATE", "type": "esriFieldTypeDate", "alias": "Fecha de Instalacion", "length": 8, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Observaciones y Comentarios", "length": 1000, "domain": null }, { "name": "SURGE_ARRESTER_ID", "type": "esriFieldTypeString", "alias": "ID Punto de Montaje", "length": 15, "domain": null }, { "name": "LEGACY_VERSION", "type": "esriFieldTypeString", "alias": "Versión Sistema Anterior", "length": 15, "domain": null }, { "name": "HYPERLINK", "type": "esriFieldTypeString", "alias": "Hipervínculo", "length": 1000, "domain": null }, { "name": "CREATOR_USER", "type": "esriFieldTypeString", "alias": "Usuario de Alta", "length": 30, "domain": null }, { "name": "CREATION_DATE", "type": "esriFieldTypeDate", "alias": "Fecha de Alta", "length": 8, "domain": null }, { "name": "EDITOR_USER", "type": "esriFieldTypeString", "alias": "Usuario de Modificacion", "length": 30, "domain": null }, { "name": "EDITION_DATE", "type": "esriFieldTypeDate", "alias": "Fecha de Modificacion", "length": 8, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "INTEGRATION_ID", "type": "esriFieldTypeString", "alias": "ID Integración", "length": 15, "domain": null }, { "name": "REPORT_ID", "type": "esriFieldTypeString", "alias": "ID Reporte", "length": 20, "domain": null }, { "name": "INVESTMENT_TYPE", "type": "esriFieldTypeString", "alias": "Tipo de inversion", "length": 20, "domain": null }, { "name": "IUA", "type": "esriFieldTypeString", "alias": "Codigo IUA", "length": 25, "domain": null }, { "name": "REPLACED_IUA", "type": "esriFieldTypeString", "alias": "IUA Reemplazada", "length": 25, "domain": null }, { "name": "COST_FRACTION", "type": "esriFieldTypeSingle", "alias": "Fraccion de costo (%)", "domain": null }, { "name": "IUS", "type": "esriFieldTypeString", "alias": "Codigo IUS", "length": 15, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GLOBALID", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I127SURGE_ARREST", "fields": "SURGE_ARRESTER_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I127PREDESIGN_ID", "fields": "PREDESIGN_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I127NAME", "fields": "NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I127LEGACY_ID", "fields": "LEGACY_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I127INTEGRATION_", "fields": "INTEGRATION_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I127CUSTOM_ID", "fields": "CUSTOM_ID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "OWNER": {"type": "inherited"}, "TYPE": {"type": "inherited"}, "PHASES_SEQUENCE": {"type": "inherited"} }, "id": 1, "name": "PROTECCIÓN DE SOBRETENSIÓN" } ], "subtypes": [ { "domains": { "OWNER": {"type": "inherited"}, "TYPE": {"type": "inherited"}, "PHASES_SEQUENCE": {"type": "inherited"} }, "defaultValues": { "SUBTYPE": null, "CUSTOM_ID": null, "LEGACY_ID": null, "PREDESIGN_ID": null, "SERIAL_NUMBER": "SIN INFORMACIÓN", "NAME": null, "ALIAS": null, "DESCRIPTION": null, "OWNER": "OR", "OWNER_NAME": "CELSIA COLOMBIA S.A. E.S.P.", "TYPE": null, "PHASES_SEQUENCE": null, "BIL_RATING": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "SURGE_ARRESTER_ID": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "INTEGRATION_ID": null, "REPORT_ID": null, "INVESTMENT_TYPE": null, "IUA": null, "REPLACED_IUA": null, "COST_FRACTION": null, "IUS": null }, "code": 1, "name": "PROTECCIÓN DE SOBRETENSIÓN" } ], "relationships": [ { "id": 1, "name": "Supresor de Sobretensión AT-MT", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "SURGE_ARRESTER_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{9F60AE92-14F2-4539-A46F-365D13F3DF69}" } ], "capabilities": "Query,Map,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": false }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "8ecf11c35f0c405abf6c59cc0c0676b7" }