Name: SGO.Z1_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:
[DZ1-Q66: Q66]
,
[DZ1-Q71: Q71]
,
[DZ1-Q85: Q85]
, ...25 more...
)
-
PLACA
(
type: esriFieldTypeString, alias: Pláca vehículo:, length: 7
,
Coded Values:
[OAJ783: OAJ783]
,
[OBB807: OBB807]
,
[OBD373: OBD373]
, ...27 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:
[31310E25: Bulldozer]
,
[31310E12-1: Retro Llanta]
,
[31310E14: 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:
[01: USAQUEN]
,
[02: CHAPINERO]
,
[10: ENGATIVA]
, ...3 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:
[37001257: Carlos Hector Moreno Gil]
,
[37000518: Gentil Muñoz Ortiz]
,
[37001313: Hector Hernando Sierra Garcia]
, ...21 more...
)
-
AYUDANTE_1
(
type: esriFieldTypeString, alias: Ayudante 1:, length: 10
,
Coded Values:
[37035631: Alvaro Quiroga Gonzalez]
,
[37035298: Bryan Alexis Caceres Gonzalez]
,
[37035366: Camilo Andres Gonzalez]
, ...38 more...
)
-
AYUDANTE_2
(
type: esriFieldTypeString, alias: Ayudante 2:, length: 10
,
Coded Values:
[37035631: Alvaro Quiroga Gonzalez]
,
[37035298: Bryan Alexis Caceres Gonzalez]
,
[37035366: Camilo Andres Gonzalez]
, ...38 more...
)
-
AYUDANTE_3
(
type: esriFieldTypeString, alias: Ayudante 3:, length: 10
,
Coded Values:
[37035631: Alvaro Quiroga Gonzalez]
,
[37035298: Bryan Alexis Caceres Gonzalez]
,
[37035366: Camilo Andres Gonzalez]
, ...38 more...
)
-
OTR_AYUD
(
type: esriFieldTypeString, alias: OTR_AYUD, length: 50
)
-
INSPEC
(
type: esriFieldTypeString, alias: Inspector:, length: 10
,
Coded Values:
[37003349: Carlos Uriel Milaguy Gil]
,
[37002332: Jhon Ivan Morales]
,
[37001199: Jose Jairo Prieto Diaz]
, ...2 more...
)
-
INGEN
(
type: esriFieldTypeString, alias: Ingeniero:, length: 10
,
Coded Values:
[37037399: Ginna Graciela Leiton Martinez]
,
[37001840: Jorge Enrique Florez Riveros]
,
[37003363: Wilson Pabon Martinez]
, ...8 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:
[31310E25: Bulldozer]
,
[31310E12-1: Retro Llanta]
,
[31310E14: 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]
)
Relationships:
Supported Operations:
Query
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata