{ "currentVersion": 10.71, "id": 3, "name": "SGO.Z4_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": 0, "name": "C_Z4_ALC_VERIF", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "AVISO", "composite": true } ], "isDataVersioned": false, "isDataArchived": true, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1560386150000 }, "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_DZ4_PTRAB_MQ", "description": "Comisiones Apoyo Maquinaria DZ4", "codedValues": [ { "name": "075", "code": "DZ4-075" }, { "name": "094", "code": "XZ4-094" }, { "name": "114", "code": "DZ4-114" }, { "name": "F28", "code": "XZ4-F28" }, { "name": "F32", "code": "DZ4-F32" }, { "name": "MC20", "code": "DZ4-MC20" }, { "name": "MC35", "code": "XZ4-MC35" }, { "name": "MC42", "code": "XZ4-MC42" }, { "name": "Q112", "code": "DZ4-Q112" }, { "name": "Q119", "code": "DZ4-Q119" }, { "name": "Q147", "code": "DZ4-Q147" }, { "name": "Q148", "code": "DZ4-Q148" }, { "name": "R14", "code": "DZ4-R-14" }, { "name": "RC05", "code": "DZ4-RC05" }, { "name": "RC08", "code": "DZ4-RE08" }, { "name": "RE16", "code": "DZ4-RE16" }, { "name": "RE22", "code": "XZ4-RE22" }, { "name": "C114", "code": "DZ4-C114" }, { "name": "C094", "code": "DZ4-C094" }, { "name": "Otro / Sin Símbolo", "code": "NO-SIMB" }, { "name": "405", "code": "DZ4-405" } ], "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_DZ4_PLACA", "description": "Placas Vehiculos DZ4", "codedValues": [ { "name": "OBG307", "code": "OBG307" }, { "name": "OBF941", "code": "OBF941" }, { "name": "OBI246", "code": "OBI246" }, { "name": "OBI245", "code": "OBI245" }, { "name": "OCK777", "code": "OCK777" }, { "name": "OBG364", "code": "OBG364" }, { "name": "OBG362", "code": "OBG362" }, { "name": "OBG765", "code": "OBG765" }, { "name": "Sin Placa/No Aplica", "code": "NPLACA" }, { "name": "Otra Placa", "code": "OTRPLK" }, { "name": "OBD363", "code": "OBD363" }, { "name": "OLN094", "code": "OLN094" }, { "name": "OLN095", "code": "OLN095" }, { "name": "OBG701", "code": "OBG701" }, { "name": "OTD143", "code": "OTD143" }, { "name": "OCK068", "code": "OCK068" }, { "name": "OKZ987", "code": "OKZ987" }, { "name": "OBG955", "code": "OBG955" }, { "name": "OCJ887", "code": "OCJ887" }, { "name": "OCK800", "code": "OCK800" }, { "name": "OBD816", "code": "OBD816" }, { "name": "OBD819", "code": "OBD819" }, { "name": "OBD866", "code": "OBD866" }, { "name": "OBI094", "code": "OBI094" }, { "name": "OBG736", "code": "OBG736" }, { "name": "OCK581", "code": "OCK581" }, { "name": "GCW859", "code": "GCW589" } ], "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_DZ4_EQUIP_RR", "description": "Equipos Reconstruccion AL Z4", "codedValues": [ { "name": "Bulldozer", "code": "34310E25" }, { "name": "Retro Llanta", "code": "34310E12-1" }, { "name": "Paladraga", "code": "34310E14" }, { "name": "Volqueta", "code": "34310V10" }, { "name": "Mini Cargador", "code": "34310E30" }, { "name": "Retro Oruga", "code": "34310E12-2" }, { "name": "Compresor", "code": "34310E35" }, { "name": "Remolque", "code": "34310E13" }, { "name": "Mini Compactador", "code": "34310E18" }, { "name": "Retro Cargador", "code": "34310E12" }, { "name": "Motobomba", "code": "34310E26" }, { "name": "Grúa", "code": "34310E19" }, { "name": "Volqueta Brazo Grúa", "code": "34310E44" } ], "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_DZ4_LOCALI", "description": "Localidades Zona 4", "codedValues": [ { "name": "SANTA FE", "code": "03" }, { "name": "SAN CRISTOBAL", "code": "04" }, { "name": "USME", "code": "05" }, { "name": "TUNJUELITO", "code": "06" }, { "name": "BOSA", "code": "07" }, { "name": "KENNEDY", "code": "08" }, { "name": "RAFAEL URIBE URIBE", "code": "18" }, { "name": "CIUDAD BOLIVAR", "code": "19" }, { "name": "PUENTE ARANDA", "code": "16" }, { "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_DZ4_OPER_MQ", "description": "Operadores Maquinaria DZ4", "codedValues": [ { "name": "Gerardo Lagos", "code": "37002731" }, { "name": "Hector Raul Barbosa", "code": "37002552" }, { "name": "Hector Zuluaga", "code": "37000998" }, { "name": "Jaime Ricardo Lozano", "code": "37001035" }, { "name": "Jairo Acosta", "code": "37003467" }, { "name": "Jorge Eliecer Conde", "code": "37000559" }, { "name": "Jose Reynaldo Rey", "code": "37001139" }, { "name": "Jose Vicente Rincon", "code": "37002555" }, { "name": "Juan de Jesus Gamba", "code": "37000525" }, { "name": "Juan F Paez Ramirez", "code": "37000471" }, { "name": "Luis H Gonzalez", "code": "37003465" }, { "name": "Pedro Ramirez", "code": "37002772" }, { "name": "Harvey Leonardo Garzon", "code": "37003470" }, { "name": "Michel Estiben Paez Rico", "code": "37038033" }, { "name": "Mabel Liliana Martinez", "code": "37035454" }, { "name": "Otro", "code": "99999999" }, { "name": "José Facundo Rodriguez P", "code": "37035327" }, { "name": "Campo Elias Perdomo", "code": "37035224" }, { "name": "Juan Fernado Castañeda", "code": "37035280" }, { "name": "Jonathan Ernesto Alfonso Velosa", "code": "38003615" } ], "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_DZ4_AYUD", "description": "Ayudantes AL Z4", "codedValues": [ { "name": "Andres Rios", "code": "37035211" }, { "name": "Breiner Rodriguez", "code": "38001193" }, { "name": "Campo Elias Perdomo", "code": "37035224" }, { "name": "Carlos Anzola", "code": "37035329" }, { "name": "David Orlando Bernal", "code": "37035162" }, { "name": "Diana Milena Lima", "code": "37035762" }, { "name": "Diana Moreno", "code": "37002154" }, { "name": "Edixon Martinez", "code": "37035784" }, { "name": "Evaristo Ayala", "code": "37002565" }, { "name": "Fernando Mora", "code": "37002801" }, { "name": "Florencio Moreno", "code": "37035891" }, { "name": "Fredy Aldemar Davila", "code": "37035373" }, { "name": "Henry Nelson Cañon", "code": "37035865" }, { "name": "Hugo Ardila", "code": "37035903" }, { "name": "Javier Murcia", "code": "37002209" }, { "name": "Jorge Sanchez Nova", "code": "38001229" }, { "name": "Jose Diego Jimenez", "code": "37035977" }, { "name": "Jose Facundo Rodriguez", "code": "37035327" }, { "name": "Jose Salomon Parra", "code": "37003373" }, { "name": "Juan Fernando Castañeda", "code": "37035864" }, { "name": "Julio Hernando Orozco", "code": "37034252" }, { "name": "Luis Eduardo Linares", "code": "37001068" }, { "name": "Luis Henry Gonzalez", "code": "37003465" }, { "name": "Mabel Liliana Martinez", "code": "37035454" }, { "name": "Mauricio Vanegas", "code": "37002939" }, { "name": "Orlando Morales", "code": "38000081" }, { "name": "Oscar Alberto Romero", "code": "37037030" }, { "name": "Oscar Baron Peralta", "code": "37035804" }, { "name": "Oscar Leonardo Sanchez", "code": "37034900" }, { "name": "Over Palomino", "code": "37035803" }, { "name": "Pedro Mancipe", "code": "37035642" }, { "name": "Peter Albert Marinez", "code": "37035862" }, { "name": "Ricardo Bejarano", "code": "37000480" }, { "name": "Wenceslao Martinez", "code": "37035908" }, { "name": "Wilfer Fernando Reyes", "code": "38001192" }, { "name": "Wilinton Quiroga", "code": "37035158" }, { "name": "Jaime A Sepulveda D", "code": "38002311" }, { "name": "Jonnathan Daniel Salazar C", "code": "38002364" }, { "name": "Luis Moncaleano", "code": "38002353" }, { "name": "Otro Ayudante", "code": "99999999" }, { "name": "Omar Felipe Zabala C", "code": "37038129" }, { "name": "Carlos Hector Macias N", "code": "37037352" }, { "name": "Pedro Granados Velandia", "code": "37038242" }, { "name": "Oscar Giovanni Gomez Caballero", "code": "38003370" }, { "name": "Hernan Espinosa Mogollón", "code": "38003334" }, { "name": "Pedro Luis Pinzón Valero", "code": "38003288" }, { "name": "Wilson Roa", "code": "38003351" }, { "name": "Juan Carlos Delgadillo", "code": "38003343" }, { "name": "Wilfer Reyes", "code": "38003326" }, { "name": "Carlos Enrique Barbosa Rosales", "code": "38003300" }, { "name": "Jorge Francisco Ramos Velasquez", "code": "38003275" }, { "name": "Duerney Cifuentes Prieto", "code": "38003297" }, { "name": "Cesar Parra Marroquín", "code": "37035736" }, { "name": "Leonel Lopez Ruiz", "code": "38003513" }, { "name": "Jonathan Ernesto Alfonso Velosa", "code": "38003615" }, { "name": "Eduardo Norberto Lancheros Parada", "code": "38003827" }, { "name": "Gustavo Adolfo Torres Duran", "code": "38004004" }, { "name": "Herney Morales", "code": "38003757" }, { "name": "Pedro Julio Bernal Luna", "code": "38004180" } ], "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_DZ4_AYUD", "description": "Ayudantes AL Z4", "codedValues": [ { "name": "Andres Rios", "code": "37035211" }, { "name": "Breiner Rodriguez", "code": "38001193" }, { "name": "Campo Elias Perdomo", "code": "37035224" }, { "name": "Carlos Anzola", "code": "37035329" }, { "name": "David Orlando Bernal", "code": "37035162" }, { "name": "Diana Milena Lima", "code": "37035762" }, { "name": "Diana Moreno", "code": "37002154" }, { "name": "Edixon Martinez", "code": "37035784" }, { "name": "Evaristo Ayala", "code": "37002565" }, { "name": "Fernando Mora", "code": "37002801" }, { "name": "Florencio Moreno", "code": "37035891" }, { "name": "Fredy Aldemar Davila", "code": "37035373" }, { "name": "Henry Nelson Cañon", "code": "37035865" }, { "name": "Hugo Ardila", "code": "37035903" }, { "name": "Javier Murcia", "code": "37002209" }, { "name": "Jorge Sanchez Nova", "code": "38001229" }, { "name": "Jose Diego Jimenez", "code": "37035977" }, { "name": "Jose Facundo Rodriguez", "code": "37035327" }, { "name": "Jose Salomon Parra", "code": "37003373" }, { "name": "Juan Fernando Castañeda", "code": "37035864" }, { "name": "Julio Hernando Orozco", "code": "37034252" }, { "name": "Luis Eduardo Linares", "code": "37001068" }, { "name": "Luis Henry Gonzalez", "code": "37003465" }, { "name": "Mabel Liliana Martinez", "code": "37035454" }, { "name": "Mauricio Vanegas", "code": "37002939" }, { "name": "Orlando Morales", "code": "38000081" }, { "name": "Oscar Alberto Romero", "code": "37037030" }, { "name": "Oscar Baron Peralta", "code": "37035804" }, { "name": "Oscar Leonardo Sanchez", "code": "37034900" }, { "name": "Over Palomino", "code": "37035803" }, { "name": "Pedro Mancipe", "code": "37035642" }, { "name": "Peter Albert Marinez", "code": "37035862" }, { "name": "Ricardo Bejarano", "code": "37000480" }, { "name": "Wenceslao Martinez", "code": "37035908" }, { "name": "Wilfer Fernando Reyes", "code": "38001192" }, { "name": "Wilinton Quiroga", "code": "37035158" }, { "name": "Jaime A Sepulveda D", "code": "38002311" }, { "name": "Jonnathan Daniel Salazar C", "code": "38002364" }, { "name": "Luis Moncaleano", "code": "38002353" }, { "name": "Otro Ayudante", "code": "99999999" }, { "name": "Omar Felipe Zabala C", "code": "37038129" }, { "name": "Carlos Hector Macias N", "code": "37037352" }, { "name": "Pedro Granados Velandia", "code": "37038242" }, { "name": "Oscar Giovanni Gomez Caballero", "code": "38003370" }, { "name": "Hernan Espinosa Mogollón", "code": "38003334" }, { "name": "Pedro Luis Pinzón Valero", "code": "38003288" }, { "name": "Wilson Roa", "code": "38003351" }, { "name": "Juan Carlos Delgadillo", "code": "38003343" }, { "name": "Wilfer Reyes", "code": "38003326" }, { "name": "Carlos Enrique Barbosa Rosales", "code": "38003300" }, { "name": "Jorge Francisco Ramos Velasquez", "code": "38003275" }, { "name": "Duerney Cifuentes Prieto", "code": "38003297" }, { "name": "Cesar Parra Marroquín", "code": "37035736" }, { "name": "Leonel Lopez Ruiz", "code": "38003513" }, { "name": "Jonathan Ernesto Alfonso Velosa", "code": "38003615" }, { "name": "Eduardo Norberto Lancheros Parada", "code": "38003827" }, { "name": "Gustavo Adolfo Torres Duran", "code": "38004004" }, { "name": "Herney Morales", "code": "38003757" }, { "name": "Pedro Julio Bernal Luna", "code": "38004180" } ], "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_DZ4_AYUD", "description": "Ayudantes AL Z4", "codedValues": [ { "name": "Andres Rios", "code": "37035211" }, { "name": "Breiner Rodriguez", "code": "38001193" }, { "name": "Campo Elias Perdomo", "code": "37035224" }, { "name": "Carlos Anzola", "code": "37035329" }, { "name": "David Orlando Bernal", "code": "37035162" }, { "name": "Diana Milena Lima", "code": "37035762" }, { "name": "Diana Moreno", "code": "37002154" }, { "name": "Edixon Martinez", "code": "37035784" }, { "name": "Evaristo Ayala", "code": "37002565" }, { "name": "Fernando Mora", "code": "37002801" }, { "name": "Florencio Moreno", "code": "37035891" }, { "name": "Fredy Aldemar Davila", "code": "37035373" }, { "name": "Henry Nelson Cañon", "code": "37035865" }, { "name": "Hugo Ardila", "code": "37035903" }, { "name": "Javier Murcia", "code": "37002209" }, { "name": "Jorge Sanchez Nova", "code": "38001229" }, { "name": "Jose Diego Jimenez", "code": "37035977" }, { "name": "Jose Facundo Rodriguez", "code": "37035327" }, { "name": "Jose Salomon Parra", "code": "37003373" }, { "name": "Juan Fernando Castañeda", "code": "37035864" }, { "name": "Julio Hernando Orozco", "code": "37034252" }, { "name": "Luis Eduardo Linares", "code": "37001068" }, { "name": "Luis Henry Gonzalez", "code": "37003465" }, { "name": "Mabel Liliana Martinez", "code": "37035454" }, { "name": "Mauricio Vanegas", "code": "37002939" }, { "name": "Orlando Morales", "code": "38000081" }, { "name": "Oscar Alberto Romero", "code": "37037030" }, { "name": "Oscar Baron Peralta", "code": "37035804" }, { "name": "Oscar Leonardo Sanchez", "code": "37034900" }, { "name": "Over Palomino", "code": "37035803" }, { "name": "Pedro Mancipe", "code": "37035642" }, { "name": "Peter Albert Marinez", "code": "37035862" }, { "name": "Ricardo Bejarano", "code": "37000480" }, { "name": "Wenceslao Martinez", "code": "37035908" }, { "name": "Wilfer Fernando Reyes", "code": "38001192" }, { "name": "Wilinton Quiroga", "code": "37035158" }, { "name": "Jaime A Sepulveda D", "code": "38002311" }, { "name": "Jonnathan Daniel Salazar C", "code": "38002364" }, { "name": "Luis Moncaleano", "code": "38002353" }, { "name": "Otro Ayudante", "code": "99999999" }, { "name": "Omar Felipe Zabala C", "code": "37038129" }, { "name": "Carlos Hector Macias N", "code": "37037352" }, { "name": "Pedro Granados Velandia", "code": "37038242" }, { "name": "Oscar Giovanni Gomez Caballero", "code": "38003370" }, { "name": "Hernan Espinosa Mogollón", "code": "38003334" }, { "name": "Pedro Luis Pinzón Valero", "code": "38003288" }, { "name": "Wilson Roa", "code": "38003351" }, { "name": "Juan Carlos Delgadillo", "code": "38003343" }, { "name": "Wilfer Reyes", "code": "38003326" }, { "name": "Carlos Enrique Barbosa Rosales", "code": "38003300" }, { "name": "Jorge Francisco Ramos Velasquez", "code": "38003275" }, { "name": "Duerney Cifuentes Prieto", "code": "38003297" }, { "name": "Cesar Parra Marroquín", "code": "37035736" }, { "name": "Leonel Lopez Ruiz", "code": "38003513" }, { "name": "Jonathan Ernesto Alfonso Velosa", "code": "38003615" }, { "name": "Eduardo Norberto Lancheros Parada", "code": "38003827" }, { "name": "Gustavo Adolfo Torres Duran", "code": "38004004" }, { "name": "Herney Morales", "code": "38003757" }, { "name": "Pedro Julio Bernal Luna", "code": "38004180" } ], "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_DZ4_INSPEC", "description": "Inspectores AL Z4", "codedValues": [ { "name": "Hugo Larrota Mendez", "code": "37002736" }, { "name": "Luis Angel Alvarez Alarcon", "code": "37003466" }, { "name": "Manuel Torres", "code": "37000869" }, { "name": "Marco Arturo Suarez", "code": "37002935" } ], "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_DZ4_INGEN", "description": "Ingenieros AL Z4", "codedValues": [ { "name": "Eduard Alberto Pacheco Silva", "code": "37002641" }, { "name": "Javier Eduardo Vega Vega", "code": "37034906" }, { "name": "Lina Maria Ojeda Rojas", "code": "37034423" }, { "name": "Oscar Raul Sarralde Sanchez", "code": "37001230" }, { "name": "Juan Carlos López Rodríguez", "code": "37000278" }, { "name": "Hugo Larrota Mendoza", "code": "37002739" } ], "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_DZ4_EQUIP_RR", "description": "Equipos Reconstruccion AL Z4", "codedValues": [ { "name": "Bulldozer", "code": "34310E25" }, { "name": "Retro Llanta", "code": "34310E12-1" }, { "name": "Paladraga", "code": "34310E14" }, { "name": "Volqueta", "code": "34310V10" }, { "name": "Mini Cargador", "code": "34310E30" }, { "name": "Retro Oruga", "code": "34310E12-2" }, { "name": "Compresor", "code": "34310E35" }, { "name": "Remolque", "code": "34310E13" }, { "name": "Mini Compactador", "code": "34310E18" }, { "name": "Retro Cargador", "code": "34310E12" }, { "name": "Motobomba", "code": "34310E26" }, { "name": "Grúa", "code": "34310E19" }, { "name": "Volqueta Brazo Grúa", "code": "34310E44" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "T_MAQ_EQUI_2" }, { "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": "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": "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" }, { "name": "OTR_OPER", "type": "esriFieldTypeString", "alias": "Otro Operador ¿Cuál?:", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "OTR_OPER" } ], "indexes": [ { "name": "G43924AVISO", "fields": "AVISO", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1716249_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1716249", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "SGO.Z4_ALC_CT_APYMAQ", "description": "", "prototype": { "attributes": { "SGO_STATUS": "MESGO", "COM_STATUS": "METRA", "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, "OTR_OPER": 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 }