{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 89, "name": "Controles Genéricos de Regulació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": "MEASUREMENT_TYPE", "type": "esriFieldTypeString", "alias": "Tipo de Medición", "length": 5, "domain": { "type": "codedValue", "name": "RED027", "description": "Tipo Medida de Control [Text]", "codedValues": [ { "name": "ENERGIA ACTIVA", "code": "PE" }, { "name": "POTENCIA ACTIVA", "code": "P" }, { "name": "ADMITANCIA", "code": "Y" }, { "name": "ADMITANCIA POR LONGITUD", "code": "YL" }, { "name": "POTENCIA APARENTE", "code": "S" }, { "name": "TIEMPO ABSOLUTO", "code": "ADT" }, { "name": "FACTOR DE POTENCIA", "code": "FP" }, { "name": "CROSS SECTION", "code": "CS" }, { "name": "CORRIENTE", "code": "I" }, { "name": "ANGULO DE CORRIENTE", "code": "IA" }, { "name": "DISCRETO", "code": "D" }, { "name": "FAILURE RATE", "code": "FR" }, { "name": "FEELS LIKE", "code": "FL" }, { "name": "FRECUENCIA", "code": "F" }, { "name": "HOT SPOT TEMPERATURE", "code": "HST" }, { "name": "HUMEDAD", "code": "H" }, { "name": "IMPEDANCIA", "code": "X" }, { "name": "IMPEDANCIA POR LONGITUD", "code": "XL" }, { "name": "INSOLATION", "code": "INS" }, { "name": "LATITUD / LONGITUD", "code": "XY" }, { "name": "LONGITUD", "code": "L" }, { "name": "MASA", "code": "M" }, { "name": "TEMPERATURA ACEITE", "code": "OT" }, { "name": "PORCENTAJE", "code": "PC" }, { "name": "ENERGIA REACTIVA", "code": "QE" }, { "name": "POTECIA REACTIVA", "code": "Q" }, { "name": "VOLTAJE RELATIVO", "code": "RV" }, { "name": "VELOCIDAD DE ROTACION", "code": "RS" }, { "name": "SKY COVER", "code": "SC" }, { "name": "TEMPERATURA DEL SUELO", "code": "ST" }, { "name": "ESTADO", "code": "STAT" }, { "name": "SUNSHINE MINUTES", "code": "SSM" }, { "name": "SWITCH STATUS", "code": "SST" }, { "name": "TEMPERATURA", "code": "TEM" }, { "name": "TIEMPO", "code": "T" }, { "name": "UNITLESS VOLTAGE", "code": "ULV" }, { "name": "ANGULO DE VOLTAJE", "code": "VA" }, { "name": "VELOCIDAD DE VIENTO", "code": "WS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONTROL_SETTING_TYPE", "type": "esriFieldTypeString", "alias": "Tipo de Configuracion del Control", "length": 5, "domain": { "type": "codedValue", "name": "RED026", "description": "Tipo Ajuste de Control [Text]", "codedValues": [ { "name": "EMERGENCIA (EMERGENCY)", "code": "E" }, { "name": "FALLA DE SEGURIDAD (FAIL SAFE)", "code": "FS" }, { "name": "NORMAL", "code": "N" }, { "name": "REVERSA", "code": "R" }, { "name": "REDUCCION DE VOLTAJE", "code": "VR" }, { "name": "COGENERACION", "code": "CG" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TARGET_RANGE", "type": "esriFieldTypeDouble", "alias": "Rango objetivo", "domain": null }, { "name": "TARGET_VALUE", "type": "esriFieldTypeDouble", "alias": "Valor objetivo", "domain": null }, { "name": "MAX_VALUE", "type": "esriFieldTypeDouble", "alias": "Valor Maximo", "domain": null }, { "name": "MIN_VALUE", "type": "esriFieldTypeDouble", "alias": "Valor Minimo", "domain": null }, { "name": "DELAY", "type": "esriFieldTypeSingle", "alias": "Retraso", "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": "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": "EQUIPMENT_ID", "type": "esriFieldTypeString", "alias": "ID Equipo Controlado", "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": "I138PREDESIGN_ID", "fields": "PREDESIGN_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I138NAME", "fields": "NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I138LEGACY_ID", "fields": "LEGACY_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I138EQUIPMENT_ID", "fields": "EQUIPMENT_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I138CUSTOM_ID", "fields": "CUSTOM_ID", "isAscending": true, "isUnique": false, "description": "" } ], "types": [ { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"type": "inherited"} }, "id": 1, "name": "CAPACITIVO" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"type": "inherited"} }, "id": 2, "name": "INDUCTIVO" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"type": "inherited"} }, "id": 3, "name": "POTENCIA ACTIVA" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"type": "inherited"} }, "id": 4, "name": "POTENCIA REACTIVA" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"type": "inherited"} }, "id": 5, "name": "VOLTAJE" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"type": "inherited"} }, "id": 6, "name": "SVC - COMP. ESTATIVO DE VAR" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"type": "inherited"} }, "id": 7, "name": "CAMBIADOR DE TAPS" } ], "subtypes": [ { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"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.", "MEASUREMENT_TYPE": null, "CONTROL_SETTING_TYPE": null, "TARGET_RANGE": null, "TARGET_VALUE": null, "MAX_VALUE": null, "MIN_VALUE": null, "DELAY": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "EQUIPMENT_ID": null }, "code": 1, "name": "CAPACITIVO" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"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.", "MEASUREMENT_TYPE": null, "CONTROL_SETTING_TYPE": null, "TARGET_RANGE": null, "TARGET_VALUE": null, "MAX_VALUE": null, "MIN_VALUE": null, "DELAY": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "EQUIPMENT_ID": null }, "code": 2, "name": "INDUCTIVO" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"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.", "MEASUREMENT_TYPE": "P", "CONTROL_SETTING_TYPE": null, "TARGET_RANGE": null, "TARGET_VALUE": null, "MAX_VALUE": null, "MIN_VALUE": null, "DELAY": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "EQUIPMENT_ID": null }, "code": 3, "name": "POTENCIA ACTIVA" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"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.", "MEASUREMENT_TYPE": "Q", "CONTROL_SETTING_TYPE": null, "TARGET_RANGE": null, "TARGET_VALUE": null, "MAX_VALUE": null, "MIN_VALUE": null, "DELAY": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "EQUIPMENT_ID": null }, "code": 4, "name": "POTENCIA REACTIVA" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"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.", "MEASUREMENT_TYPE": null, "CONTROL_SETTING_TYPE": null, "TARGET_RANGE": null, "TARGET_VALUE": null, "MAX_VALUE": null, "MIN_VALUE": null, "DELAY": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "EQUIPMENT_ID": null }, "code": 5, "name": "VOLTAJE" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"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.", "MEASUREMENT_TYPE": null, "CONTROL_SETTING_TYPE": null, "TARGET_RANGE": null, "TARGET_VALUE": null, "MAX_VALUE": null, "MIN_VALUE": null, "DELAY": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "EQUIPMENT_ID": null }, "code": 6, "name": "SVC - COMP. ESTATIVO DE VAR" }, { "domains": { "OWNER": {"type": "inherited"}, "MEASUREMENT_TYPE": {"type": "inherited"}, "CONTROL_SETTING_TYPE": {"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.", "MEASUREMENT_TYPE": null, "CONTROL_SETTING_TYPE": null, "TARGET_RANGE": null, "TARGET_VALUE": null, "MAX_VALUE": null, "MIN_VALUE": null, "DELAY": null, "MANUFACTURE_DATE": null, "INSTALLATION_DATE": null, "COMMENTS": null, "LEGACY_VERSION": null, "HYPERLINK": null, "CREATOR_USER": null, "CREATION_DATE": null, "EDITOR_USER": null, "EDITION_DATE": null, "GLOBALID": null, "EQUIPMENT_ID": null }, "code": 7, "name": "CAMBIADOR DE TAPS" } ], "relationships": [ { "id": 90, "name": "Compensador SVC", "relatedTableId": 14, "role": "esriRelRoleDestination", "keyField": "EQUIPMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{E4BFB161-BFFA-4E8C-A4C3-FA092100EEBA}" }, { "id": 67, "name": "Punto de Generación", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "EQUIPMENT_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{AA70448B-9E95-41BA-BE7F-6C7E9177A3BD}" }, { "id": 160, "name": "Cambiador de TAP", "relatedTableId": 113, "role": "esriRelRoleDestination", "keyField": "EQUIPMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{8D7802AC-994A-4F0A-9A34-24303841EB53}" }, { "id": 81, "name": "Banco de Inductores", "relatedTableId": 11, "role": "esriRelRoleDestination", "keyField": "EQUIPMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{848E4C24-154E-40BB-A7CA-7E7833471600}" }, { "id": 110, "name": "Banco de Capacitores", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "EQUIPMENT_ID", "cardinality": "esriRelCardinalityOneToOne", "composite": false, "catalogID": "{E9E05615-9A65-4245-9048-17FBBF5E29E3}" } ], "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" }