Name: SGO.Z4_ALC_CT_APYMAQ
Display Field: AVISO
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
-
AVISO
(
type: esriFieldTypeString, alias: N° Aviso:, length: 10
)
-
ORDEN
(
type: esriFieldTypeString, alias: Orden:, length: 12
)
-
FECHA
(
type: esriFieldTypeDate, alias: Fecha:, length: 8
)
-
SIMBOLO
(
type: esriFieldTypeString, alias: Simbolo:, length: 10
,
Coded Values:
[DZ4-075: 075]
,
[XZ4-094: 094]
,
[DZ4-114: 114]
, ...18 more...
)
-
PLACA
(
type: esriFieldTypeString, alias: Pláca vehículo:, length: 7
,
Coded Values:
[OBG307: OBG307]
,
[OBF941: OBF941]
,
[OBI246: OBI246]
, ...24 more...
)
-
HORA_INI
(
type: esriFieldTypeDate, alias: Tiempo inicial:, length: 8
)
-
KM_INI
(
type: esriFieldTypeInteger, alias: Km inicio:
)
-
T_MAQ_EQUI
(
type: esriFieldTypeString, alias: Tipo maquinaria y equipo de apoy:, length: 10
,
Coded Values:
[34310E25: Bulldozer]
,
[34310E12-1: Retro Llanta]
,
[34310E14: Paladraga]
, ...10 more...
)
-
DIRECC
(
type: esriFieldTypeString, alias: Dirección:, length: 80
)
-
BARRIO
(
type: esriFieldTypeString, alias: Barrio:, length: 50
)
-
LOCALIDAD
(
type: esriFieldTypeString, alias: Localidad:, length: 3
,
Coded Values:
[03: SANTA FE]
,
[04: SAN CRISTOBAL]
,
[05: USME]
, ...7 more...
)
-
MUNICIPIO
(
type: esriFieldTypeString, alias: Municipio:, length: 6
,
Coded Values:
[11001: BOGOTÁ, D.C.]
,
[25754: SOACHA]
,
[25175: CHÍA]
, ...3 more...
)
-
MATERIAL
(
type: esriFieldTypeString, alias: Material transportado:, length: 15
,
Coded Values:
[SGO-0001: Cemento]
,
[SGO-0002: Arena de Peña]
,
[SGO-0003: Arena de Rio]
, ...11 more...
)
-
VOL_TTAL
(
type: esriFieldTypeDouble, alias: Volumen Total (m³):
)
-
ACTIVIDAD_1
(
type: esriFieldTypeString, alias: Actividad desarrollada 1:, length: 8
,
Coded Values:
[APY-01-1: Apoyo a otra zona (Operador)]
,
[APY-01-2: Apoyo a otra zona (Maquinaria)]
,
[APY-02: Transporte de material]
, ...6 more...
)
-
OTR_ACTIVIDA
(
type: esriFieldTypeString, alias: Otra Actividad:, length: 50
,
Coded Values:
[APYO-01: Escolta maquinaria]
,
[APYO-02: Visita a plantas]
,
[APYO-03: Tanqueos]
, ...9 more...
)
-
OBSERV
(
type: esriFieldTypeString, alias: Observaciones:, length: 800
)
-
HORA_FIN
(
type: esriFieldTypeDate, alias: Hora fin:, length: 8
)
-
T_TTAL
(
type: esriFieldTypeDouble, alias: Tiempo total:
)
-
KM_FIN
(
type: esriFieldTypeInteger, alias: Km fin:
)
-
OPERADOR
(
type: esriFieldTypeString, alias: Operador/Conductor:, length: 10
,
Coded Values:
[37002731: Gerardo Lagos]
,
[37002552: Hector Raul Barbosa]
,
[37000998: Hector Zuluaga]
, ...17 more...
)
-
AYUDANTE_1
(
type: esriFieldTypeString, alias: Ayudante 1:, length: 10
,
Coded Values:
[37035211: Andres Rios]
,
[38001193: Breiner Rodriguez]
,
[37035224: Campo Elias Perdomo]
, ...56 more...
)
-
AYUDANTE_2
(
type: esriFieldTypeString, alias: Ayudante 2:, length: 10
,
Coded Values:
[37035211: Andres Rios]
,
[38001193: Breiner Rodriguez]
,
[37035224: Campo Elias Perdomo]
, ...56 more...
)
-
AYUDANTE_3
(
type: esriFieldTypeString, alias: Ayudante 3:, length: 10
,
Coded Values:
[37035211: Andres Rios]
,
[38001193: Breiner Rodriguez]
,
[37035224: Campo Elias Perdomo]
, ...56 more...
)
-
OTR_AYUD
(
type: esriFieldTypeString, alias: OTR_AYUD, length: 50
)
-
INSPEC
(
type: esriFieldTypeString, alias: Inspector:, length: 10
,
Coded Values:
[37002736: Hugo Larrota Mendez]
,
[37003466: Luis Angel Alvarez Alarcon]
,
[37000869: Manuel Torres]
, ...1 more...
)
-
INGEN
(
type: esriFieldTypeString, alias: Ingeniero:, length: 10
,
Coded Values:
[37002641: Eduard Alberto Pacheco Silva]
,
[37034906: Javier Eduardo Vega Vega]
,
[37034423: Lina Maria Ojeda Rojas]
, ...3 more...
)
-
ACTIVIDAD_2
(
type: esriFieldTypeString, alias: Actividad desarrollada 2:, length: 8
,
Coded Values:
[APY-01-1: Apoyo a otra zona (Operador)]
,
[APY-01-2: Apoyo a otra zona (Maquinaria)]
,
[APY-02: Transporte de material]
, ...6 more...
)
-
ACTIVIDAD_3
(
type: esriFieldTypeString, alias: Actividad desarrollada 3:, length: 8
,
Coded Values:
[APY-01-1: Apoyo a otra zona (Operador)]
,
[APY-01-2: Apoyo a otra zona (Maquinaria)]
,
[APY-02: Transporte de material]
, ...6 more...
)
-
T_MAQ_EQUI_2
(
type: esriFieldTypeString, alias: Tipo maquinaria y equipo de apoy 2:, length: 10
,
Coded Values:
[34310E25: Bulldozer]
,
[34310E12-1: Retro Llanta]
,
[34310E14: Paladraga]
, ...10 more...
)
-
GLOBALID
(
type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38
)
-
CREATED_USER
(
type: esriFieldTypeString, alias: CREATED_USER, length: 255
)
-
CREATED_DATE
(
type: esriFieldTypeDate, alias: CREATED_DATE, length: 8
)
-
LAST_EDITED_USER
(
type: esriFieldTypeString, alias: LAST_EDITED_USER, length: 255
)
-
LAST_EDITED_DATE
(
type: esriFieldTypeDate, alias: LAST_EDITED_DATE, length: 8
)
-
VBO_INSPEC
(
type: esriFieldTypeString, alias: Vbo. Inspector:, length: 8
,
Coded Values:
[SGO-S: SI]
,
[SGO-N: NO]
)
-
COM_STATUS
(
type: esriFieldTypeString, alias: Estado Aviso Comisión:, length: 5
,
Coded Values:
[METRA: Aviso en tratamiento Comision]
,
[MECON: Aviso Concluido Comisión]
)
-
SGO_STATUS
(
type: esriFieldTypeString, alias: Estado Envío SAP:, length: 5
,
Coded Values:
[MESGO: Pendiente Enviar a SAP]
,
[MESAP: Enviado a SAP]
)
-
OTR_OPER
(
type: esriFieldTypeString, alias: Otro Operador ¿Cuál?:, length: 100
)
Relationships:
Supported Operations:
Query
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata