{
 "currentVersion": 10.71,
 "id": 3,
 "name": "SGO.Z5_ALC_CT_APYMAQ",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": {
  "creationDateField": "created_date",
  "creatorField": "created_user",
  "editDateField": "last_edited_date",
  "editorField": "last_edited_user"
 },
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": true,
 "relationships": [
  {
   "id": 2,
   "name": "C_Z5_ALC_VERIF",
   "relatedTableId": 0,
   "cardinality": "esriRelCardinalityOneToMany",
   "role": "esriRelRoleDestination",
   "keyField": "AVISO",
   "composite": true
  }
 ],
 "isDataVersioned": false,
 "isDataArchived": true,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": true,
  "startArchivingMoment": 1567115714000
 },
 "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": true,
 "supportsAttachmentsByUploadId": true,
 "supportsApplyEditsWithGlobalIds": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "OBJECTID",
 "globalIdField": "GLOBALID",
 "displayField": "AVISO",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "OBJECTID"
  },
  {
   "name": "AVISO",
   "type": "esriFieldTypeString",
   "alias": "N° Aviso:",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 10,
   "defaultValue": null,
   "modelName": "AVISO"
  },
  {
   "name": "ORDEN",
   "type": "esriFieldTypeString",
   "alias": "Orden:",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 12,
   "defaultValue": null,
   "modelName": "ORDEN"
  },
  {
   "name": "FECHA",
   "type": "esriFieldTypeDate",
   "alias": "Fecha:",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 8,
   "defaultValue": null,
   "modelName": "FECHA"
  },
  {
   "name": "SIMBOLO",
   "type": "esriFieldTypeString",
   "alias": "Simbolo:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_PTRAB_MQ",
    "description": "Placas Vehiculos DZ5",
    "codedValues": [
     {
      "name": "C124",
      "code": "DZ5-C124"
     },
     {
      "name": "MC22",
      "code": "XZ5-MC22"
     },
     {
      "name": "MC34",
      "code": "XZ5-MC34"
     },
     {
      "name": "MC36",
      "code": "XZ5-MC36"
     },
     {
      "name": "Q80",
      "code": "DZ5-Q80"
     },
     {
      "name": "Q109",
      "code": "DZ5-Q109"
     },
     {
      "name": "Q118",
      "code": "DZ5-Q118"
     },
     {
      "name": "Q151",
      "code": "DZ5-Q151"
     },
     {
      "name": "RC09",
      "code": "XZ5-RC09"
     },
     {
      "name": "R15",
      "code": "XZ5-R15"
     },
     {
      "name": "RMC25",
      "code": "XZ5-RMC25"
     },
     {
      "name": "Otro / Sin Símbolo",
      "code": "NO-SIMB"
     },
     {
      "name": "Barcaza",
      "code": "XZ5-BARCA"
     },
     {
      "name": "BD58",
      "code": "XZ5-BD58"
     },
     {
      "name": "BD60",
      "code": "XZ5-BD60"
     },
     {
      "name": "BD59",
      "code": "XZ5-BD59"
     },
     {
      "name": "BD34",
      "code": "XZ5-BD34"
     },
     {
      "name": "BD35",
      "code": "XZ5-BD35"
     },
     {
      "name": "BD36",
      "code": "XZ5-BD36"
     },
     {
      "name": "BD37",
      "code": "XZ5-BD37"
     },
     {
      "name": "UP",
      "code": "XZ5-UP01"
     },
     {
      "name": "080",
      "code": "XZ5-080"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "length": 10,
   "defaultValue": null,
   "modelName": "SIMBOLO"
  },
  {
   "name": "PLACA",
   "type": "esriFieldTypeString",
   "alias": "Pláca vehículo:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_PLACA",
    "description": "Placas Vehiculos DZ5",
    "codedValues": [
     {
      "name": "OBD362",
      "code": "OBD362"
     },
     {
      "name": "OBG367",
      "code": "OBG367"
     },
     {
      "name": "ODT142",
      "code": "ODT142"
     },
     {
      "name": "OLN096",
      "code": "OLN096"
     },
     {
      "name": "OLN097",
      "code": "OLN097"
     },
     {
      "name": "ODT075",
      "code": "ODT075"
     },
     {
      "name": "OCJ886",
      "code": "OCJ886"
     },
     {
      "name": "OKZ988",
      "code": "OKZ988"
     },
     {
      "name": "ONG496",
      "code": "ONG496"
     },
     {
      "name": "OBD818",
      "code": "OBD818"
     },
     {
      "name": "OCK778",
      "code": "OCK778"
     },
     {
      "name": "OBF963",
      "code": "OBF963"
     },
     {
      "name": "OBF950",
      "code": "OBF950"
     },
     {
      "name": "OBI213",
      "code": "OBI213"
     },
     {
      "name": "OBI249",
      "code": "OBI249"
     },
     {
      "name": "OBI300",
      "code": "OBI300"
     },
     {
      "name": "OBG974",
      "code": "OBG974"
     },
     {
      "name": "OBG481",
      "code": "OBG481"
     },
     {
      "name": "OBG737",
      "code": "OBG737"
     },
     {
      "name": "OBG409",
      "code": "OBG409"
     },
     {
      "name": "OBD821",
      "code": "OBD821"
     },
     {
      "name": "OBH870",
      "code": "OBH870"
     },
     {
      "name": "OBH841",
      "code": "OBH841"
     },
     {
      "name": "OBH900",
      "code": "OBH900"
     },
     {
      "name": "OBH808",
      "code": "OBH808"
     },
     {
      "name": "OBH809",
      "code": "OBH809"
     },
     {
      "name": "OBH810",
      "code": "OBH810"
     },
     {
      "name": "OBH847",
      "code": "OBH847"
     },
     {
      "name": "OBF824",
      "code": "OBF824"
     },
     {
      "name": "OBH903",
      "code": "OBH903"
     },
     {
      "name": "OBH868",
      "code": "OBH868"
     },
     {
      "name": "Sin Placa/No Aplica",
      "code": "NPLACA"
     },
     {
      "name": "Otra Placa",
      "code": "OTRPLK"
     },
     {
      "name": "OBG702",
      "code": "OBG702"
     },
     {
      "name": "OBG762",
      "code": "OBG762"
     },
     {
      "name": "GCW828",
      "code": "GCW828"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "length": 7,
   "defaultValue": null,
   "modelName": "PLACA"
  },
  {
   "name": "HORA_INI",
   "type": "esriFieldTypeDate",
   "alias": "Tiempo inicial:",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 8,
   "defaultValue": null,
   "modelName": "HORA_INI"
  },
  {
   "name": "KM_INI",
   "type": "esriFieldTypeInteger",
   "alias": "Km inicio:",
   "domain": null,
   "editable": true,
   "nullable": false,
   "defaultValue": null,
   "modelName": "KM_INI"
  },
  {
   "name": "T_MAQ_EQUI",
   "type": "esriFieldTypeString",
   "alias": "Tipo maquinaria y equipo de apoy:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_EQUIP_RR",
    "description": "Equipos Reconstr-Repos Alc. Z5",
    "codedValues": [
     {
      "name": "Bulldozer",
      "code": "35310E25"
     },
     {
      "name": "Retro Llanta",
      "code": "35310E12"
     },
     {
      "name": "Paladraga",
      "code": "35310E14"
     },
     {
      "name": "Mini Cargador",
      "code": "35310E30"
     },
     {
      "name": "Retro Oruga",
      "code": "35310E20"
     },
     {
      "name": "Compresor",
      "code": "35310E11"
     },
     {
      "name": "Remolque",
      "code": "35310E13"
     },
     {
      "name": "Mini Compactador",
      "code": "35310E40"
     },
     {
      "name": "Motoniveladora",
      "code": "35310E16"
     },
     {
      "name": "Grúa",
      "code": "35310E19"
     },
     {
      "name": "Camabaja",
      "code": "35310E31"
     },
     {
      "name": "Motobomba",
      "code": "35310E26"
     },
     {
      "name": "Volqueta doble troque",
      "code": "35310E46"
     },
     {
      "name": "Volqueta Sensiclla",
      "code": "35310E10"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "T_MAQ_EQUI"
  },
  {
   "name": "DIRECC",
   "type": "esriFieldTypeString",
   "alias": "Dirección:",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 80,
   "defaultValue": null,
   "modelName": "DIRECC"
  },
  {
   "name": "BARRIO",
   "type": "esriFieldTypeString",
   "alias": "Barrio:",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "BARRIO"
  },
  {
   "name": "LOCALIDAD",
   "type": "esriFieldTypeString",
   "alias": "Localidad:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_LOCALI",
    "description": "Localidades Zona 5",
    "codedValues": [
     {
      "name": "BOSA",
      "code": "07"
     },
     {
      "name": "KENNEDY",
      "code": "08"
     },
     {
      "name": "SIN DATO",
      "code": "99"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "length": 3,
   "defaultValue": "99",
   "modelName": "LOCALIDAD"
  },
  {
   "name": "MUNICIPIO",
   "type": "esriFieldTypeString",
   "alias": "Municipio:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_MUNI_EAAB",
    "description": "Municipio Operación EAAB",
    "codedValues": [
     {
      "name": "BOGOTÁ, D.C.",
      "code": "11001"
     },
     {
      "name": "SOACHA",
      "code": "25754"
     },
     {
      "name": "CHÍA",
      "code": "25175"
     },
     {
      "name": "GACHANCIPÁ",
      "code": "25295"
     },
     {
      "name": "SOPÓ",
      "code": "25758"
     },
     {
      "name": "TOCANCIPÁ",
      "code": "25817"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "length": 6,
   "defaultValue": "11001",
   "modelName": "MUNICIPIO"
  },
  {
   "name": "MATERIAL",
   "type": "esriFieldTypeString",
   "alias": "Material transportado:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_AL_MATER_RR",
    "description": "Materiales Reconstruccion AL",
    "codedValues": [
     {
      "name": "Cemento",
      "code": "SGO-0001"
     },
     {
      "name": "Arena de Peña",
      "code": "SGO-0002"
     },
     {
      "name": "Arena de Rio",
      "code": "SGO-0003"
     },
     {
      "name": "Varillas",
      "code": "SGO-0004"
     },
     {
      "name": "Impermeabilizante",
      "code": "SGO-0005"
     },
     {
      "name": "Acelerante",
      "code": "SGO-0006"
     },
     {
      "name": "Ladrillos",
      "code": "SGO-0007"
     },
     {
      "name": "Triturado",
      "code": "SGO-0008"
     },
     {
      "name": "Recebo",
      "code": "SGO-0009"
     },
     {
      "name": "Grava",
      "code": "SGO-0010"
     },
     {
      "name": "Rajón",
      "code": "SGO-0011"
     },
     {
      "name": "Anilina",
      "code": "SGO-0012"
     },
     {
      "name": "Señalización",
      "code": "SGO-0013"
     },
     {
      "name": "0tro, ¿Cual?",
      "code": "SGO-9999"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 15,
   "defaultValue": null,
   "modelName": "MATERIAL"
  },
  {
   "name": "VOL_TTAL",
   "type": "esriFieldTypeDouble",
   "alias": "Volumen Total (m³):",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "VOL_TTAL"
  },
  {
   "name": "ACTIVIDAD_1",
   "type": "esriFieldTypeString",
   "alias": "Actividad desarrollada 1:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_AL_ACTMAQUI",
    "description": "Actividades Apoyo de Maquinaria",
    "codedValues": [
     {
      "name": "Apoyo a otra zona (Operador)",
      "code": "APY-01-1"
     },
     {
      "name": "Apoyo a otra zona (Maquinaria)",
      "code": "APY-01-2"
     },
     {
      "name": "Transporte de material",
      "code": "APY-02"
     },
     {
      "name": "Transporte de maquinaria",
      "code": "APY-03"
     },
     {
      "name": "Manejo maquinaria",
      "code": "APY-04"
     },
     {
      "name": "Conductor",
      "code": "APY-05"
     },
     {
      "name": "Cargue de materiales",
      "code": "APY-06"
     },
     {
      "name": "Otra ¿Cuál?",
      "code": "APY-07"
     },
     {
      "name": "No Aplica",
      "code": "APY-00"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "length": 8,
   "defaultValue": null,
   "modelName": "ACTIVIDAD"
  },
  {
   "name": "OTR_ACTIVIDA",
   "type": "esriFieldTypeString",
   "alias": "Otra Actividad:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_AL_ACTMQ_OTR",
    "description": "Otras actividades Apoyo a Maquinaria",
    "codedValues": [
     {
      "name": "Escolta maquinaria",
      "code": "APYO-01"
     },
     {
      "name": "Visita a plantas",
      "code": "APYO-02"
     },
     {
      "name": "Tanqueos",
      "code": "APYO-03"
     },
     {
      "name": "Recoger sobrantes",
      "code": "APYO-04"
     },
     {
      "name": "Apoyo a otras entidades",
      "code": "APYO-05"
     },
     {
      "name": "Transporte de lodos",
      "code": "APYO-06"
     },
     {
      "name": "Tanqueo",
      "code": "APYO-07"
     },
     {
      "name": "Encendido y apagado",
      "code": "APYO-08"
     },
     {
      "name": "Apoyo a planta",
      "code": "APYO-09"
     },
     {
      "name": "Apoyo a acueducto",
      "code": "APYO-10"
     },
     {
      "name": "Apoyo a comercial",
      "code": "APYO-11"
     },
     {
      "name": "Investigación",
      "code": "APYO-12"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "OTR_ACTIVIDA"
  },
  {
   "name": "OBSERV",
   "type": "esriFieldTypeString",
   "alias": "Observaciones:",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 800,
   "defaultValue": null,
   "modelName": "OBSERV"
  },
  {
   "name": "HORA_FIN",
   "type": "esriFieldTypeDate",
   "alias": "Hora fin:",
   "domain": null,
   "editable": true,
   "nullable": false,
   "length": 8,
   "defaultValue": null,
   "modelName": "HORA_FIN"
  },
  {
   "name": "T_TTAL",
   "type": "esriFieldTypeDouble",
   "alias": "Tiempo total:",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "T_TTAL"
  },
  {
   "name": "KM_FIN",
   "type": "esriFieldTypeInteger",
   "alias": "Km fin:",
   "domain": null,
   "editable": true,
   "nullable": false,
   "defaultValue": null,
   "modelName": "KM_FIN"
  },
  {
   "name": "OPERADOR",
   "type": "esriFieldTypeString",
   "alias": "Operador/Conductor:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_OPER_MQ",
    "description": "Operadores Maquinaria DZ5",
    "codedValues": [
     {
      "name": "Froilan Galeano Ariza",
      "code": "37001063"
     },
     {
      "name": "Giovanny Rey Rey",
      "code": "37035785"
     },
     {
      "name": "Ronald Castillo Pinzon",
      "code": "37034919"
     },
     {
      "name": "Armando Gomez Paez",
      "code": "37000486"
     },
     {
      "name": "Luis Alberto Sabogal L",
      "code": "37001979"
     },
     {
      "name": "Pedro Vicente Plazas",
      "code": "37000929"
     },
     {
      "name": "Saul Ramirez Sogamoso",
      "code": "37001451"
     },
     {
      "name": "David Leonardo López D",
      "code": "37034917"
     },
     {
      "name": "Otro Operador",
      "code": "99999999"
     },
     {
      "name": "Henry Alberto Pérez A",
      "code": "37035782"
     },
     {
      "name": "Arley Rojas",
      "code": "37038684"
     },
     {
      "name": "Jefferson Rua",
      "code": "37035278"
     },
     {
      "name": "Juan José Castellanos",
      "code": "37002776"
     },
     {
      "name": "Cesar A Jimenez R",
      "code": "37035716"
     },
     {
      "name": "Alfredo Porras Piñeros",
      "code": "37002933"
     },
     {
      "name": "Carlos Moreno P",
      "code": "37057781"
     },
     {
      "name": "Luis Armando Peña",
      "code": "37001954"
     },
     {
      "name": "Carlos O Gonzalez",
      "code": "37000499"
     },
     {
      "name": "Miguel Angel Otalora V",
      "code": "37002616"
     },
     {
      "name": "Carlos Augusto Penagos Padilla",
      "code": "37035467"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": false,
   "length": 10,
   "defaultValue": null,
   "modelName": "OPERADOR"
  },
  {
   "name": "AYUDANTE_1",
   "type": "esriFieldTypeString",
   "alias": "Ayudante 1:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_AYUD",
    "description": "Ayudantes AL Z5",
    "codedValues": [
     {
      "name": "Cesar A Parra Marroquin",
      "code": "37035736"
     },
     {
      "name": "Daniel Parra Ibañez",
      "code": "37035686"
     },
     {
      "name": "David Leonardo Lopez Diaz",
      "code": "37034917"
     },
     {
      "name": "Eduardo Moreno H",
      "code": "37002569"
     },
     {
      "name": "Edwin Mauricio Medina",
      "code": "'7036053"
     },
     {
      "name": "Fernando Osorio L",
      "code": "37037340"
     },
     {
      "name": "German Bernal",
      "code": "38002363"
     },
     {
      "name": "Helio Ortega Linares",
      "code": "37035676"
     },
     {
      "name": "Henry Pérez Avila",
      "code": "37035782"
     },
     {
      "name": "Jefersson A Rua Sanchez",
      "code": "37035278"
     },
     {
      "name": "Jerson Buritica",
      "code": "38001662"
     },
     {
      "name": "Jimmy O Escobar Gomez",
      "code": "37035810"
     },
     {
      "name": "Jose Arledi Rojas Morales",
      "code": "37038684"
     },
     {
      "name": "Jose Guiobany Rey Rey",
      "code": "37035785"
     },
     {
      "name": "José Hernando Faqua",
      "code": "37003421"
     },
     {
      "name": "Jose Leonel Jaramillo M",
      "code": "37001137"
     },
     {
      "name": "José Otoniel Fuentes",
      "code": "37034930"
     },
     {
      "name": "Jose Salomon Zuñiga C",
      "code": "37035766"
     },
     {
      "name": "Joselito E Mendieta B",
      "code": "37037944"
     },
     {
      "name": "Josue Eccehomo Rubiano",
      "code": "37001013"
     },
     {
      "name": "Julio Cesar Rincon",
      "code": "37034921"
     },
     {
      "name": "Julio E Contreras Acero",
      "code": "37035616"
     },
     {
      "name": "Luis Armando Riofrio G",
      "code": "37035646"
     },
     {
      "name": "Luis Carlos Rodriguez",
      "code": "38002261"
     },
     {
      "name": "Pedro Alexander Guerrero",
      "code": "37035342"
     },
     {
      "name": "Rafael H Parra Castillo",
      "code": "37035225"
     },
     {
      "name": "Richard Nixon Moreno M",
      "code": "38002111"
     },
     {
      "name": "Roberto A Jimenez G",
      "code": "3801586"
     },
     {
      "name": "William Cubillos Ruiz",
      "code": "37001133"
     },
     {
      "name": "Otro Ayudante",
      "code": "99999999"
     },
     {
      "name": "José Manuel Huertas",
      "code": "37001065"
     },
     {
      "name": "Fernando Capera Poloche",
      "code": "37035946"
     },
     {
      "name": "Jose Reinaldo Tunarosa",
      "code": "38003338"
     },
     {
      "name": "Jesus David Quintero Contreras",
      "code": "38003430"
     },
     {
      "name": "Elkin Yesid Alvarez Soto",
      "code": "38003774"
     },
     {
      "name": "Walter Huertas Gaitan",
      "code": "37038438"
     },
     {
      "name": "José Justino Lara Martinez",
      "code": "38003802"
     },
     {
      "name": "Juan José Catellanos Coba",
      "code": "37002776"
     },
     {
      "name": "Juan Camilo Parra B",
      "code": "38003762"
     },
     {
      "name": "Andres Flores Aroca",
      "code": "38004053"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "AYUDANTE_1"
  },
  {
   "name": "AYUDANTE_2",
   "type": "esriFieldTypeString",
   "alias": "Ayudante 2:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_AYUD",
    "description": "Ayudantes AL Z5",
    "codedValues": [
     {
      "name": "Cesar A Parra Marroquin",
      "code": "37035736"
     },
     {
      "name": "Daniel Parra Ibañez",
      "code": "37035686"
     },
     {
      "name": "David Leonardo Lopez Diaz",
      "code": "37034917"
     },
     {
      "name": "Eduardo Moreno H",
      "code": "37002569"
     },
     {
      "name": "Edwin Mauricio Medina",
      "code": "'7036053"
     },
     {
      "name": "Fernando Osorio L",
      "code": "37037340"
     },
     {
      "name": "German Bernal",
      "code": "38002363"
     },
     {
      "name": "Helio Ortega Linares",
      "code": "37035676"
     },
     {
      "name": "Henry Pérez Avila",
      "code": "37035782"
     },
     {
      "name": "Jefersson A Rua Sanchez",
      "code": "37035278"
     },
     {
      "name": "Jerson Buritica",
      "code": "38001662"
     },
     {
      "name": "Jimmy O Escobar Gomez",
      "code": "37035810"
     },
     {
      "name": "Jose Arledi Rojas Morales",
      "code": "37038684"
     },
     {
      "name": "Jose Guiobany Rey Rey",
      "code": "37035785"
     },
     {
      "name": "José Hernando Faqua",
      "code": "37003421"
     },
     {
      "name": "Jose Leonel Jaramillo M",
      "code": "37001137"
     },
     {
      "name": "José Otoniel Fuentes",
      "code": "37034930"
     },
     {
      "name": "Jose Salomon Zuñiga C",
      "code": "37035766"
     },
     {
      "name": "Joselito E Mendieta B",
      "code": "37037944"
     },
     {
      "name": "Josue Eccehomo Rubiano",
      "code": "37001013"
     },
     {
      "name": "Julio Cesar Rincon",
      "code": "37034921"
     },
     {
      "name": "Julio E Contreras Acero",
      "code": "37035616"
     },
     {
      "name": "Luis Armando Riofrio G",
      "code": "37035646"
     },
     {
      "name": "Luis Carlos Rodriguez",
      "code": "38002261"
     },
     {
      "name": "Pedro Alexander Guerrero",
      "code": "37035342"
     },
     {
      "name": "Rafael H Parra Castillo",
      "code": "37035225"
     },
     {
      "name": "Richard Nixon Moreno M",
      "code": "38002111"
     },
     {
      "name": "Roberto A Jimenez G",
      "code": "3801586"
     },
     {
      "name": "William Cubillos Ruiz",
      "code": "37001133"
     },
     {
      "name": "Otro Ayudante",
      "code": "99999999"
     },
     {
      "name": "José Manuel Huertas",
      "code": "37001065"
     },
     {
      "name": "Fernando Capera Poloche",
      "code": "37035946"
     },
     {
      "name": "Jose Reinaldo Tunarosa",
      "code": "38003338"
     },
     {
      "name": "Jesus David Quintero Contreras",
      "code": "38003430"
     },
     {
      "name": "Elkin Yesid Alvarez Soto",
      "code": "38003774"
     },
     {
      "name": "Walter Huertas Gaitan",
      "code": "37038438"
     },
     {
      "name": "José Justino Lara Martinez",
      "code": "38003802"
     },
     {
      "name": "Juan José Catellanos Coba",
      "code": "37002776"
     },
     {
      "name": "Juan Camilo Parra B",
      "code": "38003762"
     },
     {
      "name": "Andres Flores Aroca",
      "code": "38004053"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "AYUDANTE_2"
  },
  {
   "name": "AYUDANTE_3",
   "type": "esriFieldTypeString",
   "alias": "Ayudante 3:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_AYUD",
    "description": "Ayudantes AL Z5",
    "codedValues": [
     {
      "name": "Cesar A Parra Marroquin",
      "code": "37035736"
     },
     {
      "name": "Daniel Parra Ibañez",
      "code": "37035686"
     },
     {
      "name": "David Leonardo Lopez Diaz",
      "code": "37034917"
     },
     {
      "name": "Eduardo Moreno H",
      "code": "37002569"
     },
     {
      "name": "Edwin Mauricio Medina",
      "code": "'7036053"
     },
     {
      "name": "Fernando Osorio L",
      "code": "37037340"
     },
     {
      "name": "German Bernal",
      "code": "38002363"
     },
     {
      "name": "Helio Ortega Linares",
      "code": "37035676"
     },
     {
      "name": "Henry Pérez Avila",
      "code": "37035782"
     },
     {
      "name": "Jefersson A Rua Sanchez",
      "code": "37035278"
     },
     {
      "name": "Jerson Buritica",
      "code": "38001662"
     },
     {
      "name": "Jimmy O Escobar Gomez",
      "code": "37035810"
     },
     {
      "name": "Jose Arledi Rojas Morales",
      "code": "37038684"
     },
     {
      "name": "Jose Guiobany Rey Rey",
      "code": "37035785"
     },
     {
      "name": "José Hernando Faqua",
      "code": "37003421"
     },
     {
      "name": "Jose Leonel Jaramillo M",
      "code": "37001137"
     },
     {
      "name": "José Otoniel Fuentes",
      "code": "37034930"
     },
     {
      "name": "Jose Salomon Zuñiga C",
      "code": "37035766"
     },
     {
      "name": "Joselito E Mendieta B",
      "code": "37037944"
     },
     {
      "name": "Josue Eccehomo Rubiano",
      "code": "37001013"
     },
     {
      "name": "Julio Cesar Rincon",
      "code": "37034921"
     },
     {
      "name": "Julio E Contreras Acero",
      "code": "37035616"
     },
     {
      "name": "Luis Armando Riofrio G",
      "code": "37035646"
     },
     {
      "name": "Luis Carlos Rodriguez",
      "code": "38002261"
     },
     {
      "name": "Pedro Alexander Guerrero",
      "code": "37035342"
     },
     {
      "name": "Rafael H Parra Castillo",
      "code": "37035225"
     },
     {
      "name": "Richard Nixon Moreno M",
      "code": "38002111"
     },
     {
      "name": "Roberto A Jimenez G",
      "code": "3801586"
     },
     {
      "name": "William Cubillos Ruiz",
      "code": "37001133"
     },
     {
      "name": "Otro Ayudante",
      "code": "99999999"
     },
     {
      "name": "José Manuel Huertas",
      "code": "37001065"
     },
     {
      "name": "Fernando Capera Poloche",
      "code": "37035946"
     },
     {
      "name": "Jose Reinaldo Tunarosa",
      "code": "38003338"
     },
     {
      "name": "Jesus David Quintero Contreras",
      "code": "38003430"
     },
     {
      "name": "Elkin Yesid Alvarez Soto",
      "code": "38003774"
     },
     {
      "name": "Walter Huertas Gaitan",
      "code": "37038438"
     },
     {
      "name": "José Justino Lara Martinez",
      "code": "38003802"
     },
     {
      "name": "Juan José Catellanos Coba",
      "code": "37002776"
     },
     {
      "name": "Juan Camilo Parra B",
      "code": "38003762"
     },
     {
      "name": "Andres Flores Aroca",
      "code": "38004053"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "AYUDANTE_3"
  },
  {
   "name": "OTR_AYUD",
   "type": "esriFieldTypeString",
   "alias": "OTR_AYUD",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "OTR_AYUD"
  },
  {
   "name": "INSPEC",
   "type": "esriFieldTypeString",
   "alias": "Inspector:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_INSPEC",
    "description": "Inspectores AL Zona 5",
    "codedValues": [
     {
      "name": "Alberto O Parra Ruiz",
      "code": "37000983"
     },
     {
      "name": "José Fener Gonzalez",
      "code": "37039195"
     },
     {
      "name": "Edgar F Correa Q",
      "code": "37000765"
     },
     {
      "name": "Michael U Gómez Siabato",
      "code": "37035354"
     },
     {
      "name": "Omar G Caballero C",
      "code": "37002592"
     },
     {
      "name": "Otro Inspector",
      "code": "99999999"
     },
     {
      "name": "Jose Otoniel Fuentes B",
      "code": "37034930"
     },
     {
      "name": "Oscar Gonzalez Bejarano",
      "code": "37002946"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "INSPEC"
  },
  {
   "name": "INGEN",
   "type": "esriFieldTypeString",
   "alias": "Ingeniero:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_INGEN",
    "description": "Ingeniero Alcatarillado Zona 5",
    "codedValues": [
     {
      "name": "Javier Bernanrdo Berdugo Hernandez",
      "code": "37033516"
     },
     {
      "name": "Jose Benicio Ladino Garcia",
      "code": "37001348"
     },
     {
      "name": "Francisco Jose Toro Beleño",
      "code": "37014296"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "INGEN"
  },
  {
   "name": "ACTIVIDAD_2",
   "type": "esriFieldTypeString",
   "alias": "Actividad desarrollada 2:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_AL_ACTMAQUI",
    "description": "Actividades Apoyo de Maquinaria",
    "codedValues": [
     {
      "name": "Apoyo a otra zona (Operador)",
      "code": "APY-01-1"
     },
     {
      "name": "Apoyo a otra zona (Maquinaria)",
      "code": "APY-01-2"
     },
     {
      "name": "Transporte de material",
      "code": "APY-02"
     },
     {
      "name": "Transporte de maquinaria",
      "code": "APY-03"
     },
     {
      "name": "Manejo maquinaria",
      "code": "APY-04"
     },
     {
      "name": "Conductor",
      "code": "APY-05"
     },
     {
      "name": "Cargue de materiales",
      "code": "APY-06"
     },
     {
      "name": "Otra ¿Cuál?",
      "code": "APY-07"
     },
     {
      "name": "No Aplica",
      "code": "APY-00"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": "APY-00",
   "modelName": "ACTIVIDAD_2"
  },
  {
   "name": "ACTIVIDAD_3",
   "type": "esriFieldTypeString",
   "alias": "Actividad desarrollada 3:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_AL_ACTMAQUI",
    "description": "Actividades Apoyo de Maquinaria",
    "codedValues": [
     {
      "name": "Apoyo a otra zona (Operador)",
      "code": "APY-01-1"
     },
     {
      "name": "Apoyo a otra zona (Maquinaria)",
      "code": "APY-01-2"
     },
     {
      "name": "Transporte de material",
      "code": "APY-02"
     },
     {
      "name": "Transporte de maquinaria",
      "code": "APY-03"
     },
     {
      "name": "Manejo maquinaria",
      "code": "APY-04"
     },
     {
      "name": "Conductor",
      "code": "APY-05"
     },
     {
      "name": "Cargue de materiales",
      "code": "APY-06"
     },
     {
      "name": "Otra ¿Cuál?",
      "code": "APY-07"
     },
     {
      "name": "No Aplica",
      "code": "APY-00"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": "APY-00",
   "modelName": "ACTIVIDAD_3"
  },
  {
   "name": "T_MAQ_EQUI_2",
   "type": "esriFieldTypeString",
   "alias": "Tipo maquinaria y equipo de apoy 2:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_DZ5_EQUIP_RR",
    "description": "Equipos Reconstr-Repos Alc. Z5",
    "codedValues": [
     {
      "name": "Bulldozer",
      "code": "35310E25"
     },
     {
      "name": "Retro Llanta",
      "code": "35310E12"
     },
     {
      "name": "Paladraga",
      "code": "35310E14"
     },
     {
      "name": "Mini Cargador",
      "code": "35310E30"
     },
     {
      "name": "Retro Oruga",
      "code": "35310E20"
     },
     {
      "name": "Compresor",
      "code": "35310E11"
     },
     {
      "name": "Remolque",
      "code": "35310E13"
     },
     {
      "name": "Mini Compactador",
      "code": "35310E40"
     },
     {
      "name": "Motoniveladora",
      "code": "35310E16"
     },
     {
      "name": "Grúa",
      "code": "35310E19"
     },
     {
      "name": "Camabaja",
      "code": "35310E31"
     },
     {
      "name": "Motobomba",
      "code": "35310E26"
     },
     {
      "name": "Volqueta doble troque",
      "code": "35310E46"
     },
     {
      "name": "Volqueta Sensiclla",
      "code": "35310E10"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 10,
   "defaultValue": null,
   "modelName": "T_MAQ_EQUI_2"
  },
  {
   "name": "VBO_INSPEC",
   "type": "esriFieldTypeString",
   "alias": "Vbo. Inspector:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_SiNo",
    "description": "Selección valores Si / No",
    "codedValues": [
     {
      "name": "SI",
      "code": "SGO-S"
     },
     {
      "name": "NO",
      "code": "SGO-N"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": "SGO-N",
   "modelName": "VBO_INSPEC"
  },
  {
   "name": "GLOBALID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GLOBALID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "length": 38,
   "defaultValue": null,
   "modelName": "GlobalID"
  },
  {
   "name": "CREATED_USER",
   "type": "esriFieldTypeString",
   "alias": "CREATED_USER",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "created_user"
  },
  {
   "name": "CREATED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "CREATED_DATE",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "created_date"
  },
  {
   "name": "LAST_EDITED_USER",
   "type": "esriFieldTypeString",
   "alias": "LAST_EDITED_USER",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 255,
   "defaultValue": null,
   "modelName": "last_edited_user"
  },
  {
   "name": "LAST_EDITED_DATE",
   "type": "esriFieldTypeDate",
   "alias": "LAST_EDITED_DATE",
   "domain": null,
   "editable": false,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "last_edited_date"
  },
  {
   "name": "COM_STATUS",
   "type": "esriFieldTypeString",
   "alias": "Estado Aviso Comisión:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_STATUSCOM",
    "description": "Estatus Aviso Comision",
    "codedValues": [
     {
      "name": "Aviso en tratamiento Comision",
      "code": "METRA"
     },
     {
      "name": "Aviso Concluido Comisión",
      "code": "MECON"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 5,
   "defaultValue": "METRA",
   "modelName": "COM_STATUS"
  },
  {
   "name": "SGO_STATUS",
   "type": "esriFieldTypeString",
   "alias": "Estado Envío SAP:",
   "domain": {
    "type": "codedValue",
    "name": "dom_SGO_STATUSSINC",
    "description": "Estatus Sincronización SAP",
    "codedValues": [
     {
      "name": "Pendiente Enviar a SAP",
      "code": "MESGO"
     },
     {
      "name": "Enviado a SAP",
      "code": "MESAP"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 5,
   "defaultValue": "MESGO",
   "modelName": "SGO_STATUS"
  }
 ],
 "indexes": [
  {
   "name": "G48154AVISO",
   "fields": "AVISO",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R1876621_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_1876621",
   "fields": "GLOBALID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "types": [],
 "templates": [
  {
   "name": "SGO.Z5_ALC_CT_APYMAQ",
   "description": "",
   "prototype": {
    "attributes": {
     "COM_STATUS": "METRA",
     "SGO_STATUS": "MESGO",
     "AVISO": " ",
     "ORDEN": null,
     "FECHA": -2209161600000,
     "SIMBOLO": " ",
     "PLACA": " ",
     "HORA_INI": -2209161600000,
     "KM_INI": 0,
     "T_MAQ_EQUI": null,
     "DIRECC": " ",
     "BARRIO": null,
     "LOCALIDAD": "99",
     "MUNICIPIO": "11001",
     "MATERIAL": null,
     "VOL_TTAL": null,
     "ACTIVIDAD_1": " ",
     "OTR_ACTIVIDA": null,
     "OBSERV": null,
     "HORA_FIN": -2209161600000,
     "T_TTAL": null,
     "KM_FIN": 0,
     "OPERADOR": " ",
     "AYUDANTE_1": null,
     "AYUDANTE_2": null,
     "AYUDANTE_3": null,
     "OTR_AYUD": null,
     "INSPEC": null,
     "INGEN": null,
     "ACTIVIDAD_2": "APY-00",
     "ACTIVIDAD_3": "APY-00",
     "T_MAQ_EQUI_2": null,
     "VBO_INSPEC": "SGO-N"
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 1000,
 "supportedQueryFormats": "JSON, geoJSON",
 "capabilities": "Query,Create,Update,Uploads,Editing,Sync,Extract",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 1000,
 "tileMaxRecordCount": 1000,
 "maxRecordCountFactor": 1
}