Name: SGO.Z3_ALC_CT_APYMAQ
Display Field: AVISO
Type: Table
Geometry Type: N/A
Description:
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: false
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
AVISO
(
type: esriFieldTypeString, alias: N° Aviso:, editable: true, nullable: false, length: 10, defaultValue: null, modelName: AVISO
)
-
ORDEN
(
type: esriFieldTypeString, alias: Orden:, editable: true, nullable: true, length: 12, defaultValue: null, modelName: ORDEN
)
-
FECHA
(
type: esriFieldTypeDate, alias: Fecha:, editable: true, nullable: false, length: 8, defaultValue: null, modelName: FECHA
)
-
SIMBOLO
(
type: esriFieldTypeString, alias: Simbolo:, editable: true, nullable: false, length: 10, defaultValue: null, modelName: SIMBOLO
,
Coded Values:
[DZ3-095: 095]
,
[DZ3-E05: E05]
,
[DZ3-MC19: MC19]
, ...16 more...
)
-
PLACA
(
type: esriFieldTypeString, alias: Pláca vehículo:, editable: true, nullable: false, length: 7, defaultValue: null, modelName: PLACA
,
Coded Values:
[EC14: EC14]
,
[OBD371: OBD371]
,
[OBD812: OBD812]
, ...27 more...
)
-
HORA_INI
(
type: esriFieldTypeDate, alias: Tiempo inicial:, editable: true, nullable: false, length: 8, defaultValue: null, modelName: HORA_INI
)
-
KM_INI
(
type: esriFieldTypeInteger, alias: Km inicio:, editable: true, nullable: false, defaultValue: null, modelName: KM_INI
)
-
T_MAQ_EQUI
(
type: esriFieldTypeString, alias: Tipo maquinaria y equipo de apoy:, editable: true, nullable: true, length: 10, defaultValue: null, modelName: T_MAQ_EQUI
,
Coded Values:
[33310E25: Bulldozer]
,
[33310E12-1: Retro Llanta]
,
[33310E14: Paladraga]
, ...10 more...
)
-
DIRECC
(
type: esriFieldTypeString, alias: Dirección:, editable: true, nullable: false, length: 80, defaultValue: null, modelName: DIRECC
)
-
BARRIO
(
type: esriFieldTypeString, alias: Barrio:, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BARRIO
)
-
LOCALIDAD
(
type: esriFieldTypeString, alias: Localidad:, editable: true, nullable: false, length: 3, defaultValue: 99, modelName: LOCALIDAD
,
Coded Values:
[02: CHAPINERO]
,
[03: SANTA FE]
,
[04: SAN CRISTOBAL]
, ...11 more...
)
-
MUNICIPIO
(
type: esriFieldTypeString, alias: Municipio:, editable: true, nullable: false, length: 6, defaultValue: 11001, modelName: MUNICIPIO
,
Coded Values:
[11001: BOGOTÁ, D.C.]
,
[25754: SOACHA]
,
[25175: CHÍA]
, ...3 more...
)
-
MATERIAL
(
type: esriFieldTypeString, alias: Material transportado:, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MATERIAL
,
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³):, editable: true, nullable: true, defaultValue: null, modelName: VOL_TTAL
)
-
ACTIVIDAD_1
(
type: esriFieldTypeString, alias: Actividad desarrollada 1:, editable: true, nullable: false, length: 8, defaultValue: null, modelName: ACTIVIDAD
,
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:, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OTR_ACTIVIDA
,
Coded Values:
[APYO-01: Escolta maquinaria]
,
[APYO-02: Visita a plantas]
,
[APYO-03: Tanqueos]
, ...9 more...
)
-
OBSERV
(
type: esriFieldTypeString, alias: Observaciones:, editable: true, nullable: true, length: 800, defaultValue: null, modelName: OBSERV
)
-
HORA_FIN
(
type: esriFieldTypeDate, alias: Hora fin:, editable: true, nullable: false, length: 8, defaultValue: null, modelName: HORA_FIN
)
-
T_TTAL
(
type: esriFieldTypeDouble, alias: Tiempo total:, editable: true, nullable: true, defaultValue: null, modelName: T_TTAL
)
-
KM_FIN
(
type: esriFieldTypeInteger, alias: Km fin:, editable: true, nullable: false, defaultValue: null, modelName: KM_FIN
)
-
OPERADOR
(
type: esriFieldTypeString, alias: Operador/Conductor:, editable: true, nullable: false, length: 10, defaultValue: null, modelName: OPERADOR
,
Coded Values:
[37000375: Alfonso Montilla Barbosa]
,
[37003423: Carlos Alberto Suarez Criales]
,
[37000547: Carlos Julio Reyes Mora]
, ...23 more...
)
-
AYUDANTE_1
(
type: esriFieldTypeString, alias: Ayudante 1:, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AYUDANTE_1
,
Coded Values:
[37035372: Alexander Camacho Riaño]
,
[37038086: Carlos Andres Pulido Martinez]
,
[38001683: Cristian Camilo Pineda Mojica]
, ...57 more...
)
-
AYUDANTE_2
(
type: esriFieldTypeString, alias: Ayudante 2:, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AYUDANTE_2
,
Coded Values:
[37035372: Alexander Camacho Riaño]
,
[37038086: Carlos Andres Pulido Martinez]
,
[38001683: Cristian Camilo Pineda Mojica]
, ...57 more...
)
-
AYUDANTE_3
(
type: esriFieldTypeString, alias: Ayudante 3:, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AYUDANTE_3
,
Coded Values:
[37035372: Alexander Camacho Riaño]
,
[37038086: Carlos Andres Pulido Martinez]
,
[38001683: Cristian Camilo Pineda Mojica]
, ...57 more...
)
-
OTR_AYUD
(
type: esriFieldTypeString, alias: OTR_AYUD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OTR_AYUD
)
-
INSPEC
(
type: esriFieldTypeString, alias: Inspector:, editable: true, nullable: true, length: 10, defaultValue: null, modelName: INSPEC
,
Coded Values:
[37002404: Jose Luis Diaz M]
,
[37001346: Juan Moises Castro B]
,
[37045200: Roberto Hurtado G]
, ...1 more...
)
-
INGEN
(
type: esriFieldTypeString, alias: Ingeniero:, editable: true, nullable: true, length: 10, defaultValue: null, modelName: INGEN
,
Coded Values:
[37000495: Fredy Guillermo Vasquez B]
,
[37003018: Geovanny Cabrera M]
,
[37073935: Jesus Antonio Ramos M]
, ...1 more...
)
-
ACTIVIDAD_2
(
type: esriFieldTypeString, alias: Actividad desarrollada 2:, editable: true, nullable: true, length: 8, defaultValue: APY-00, modelName: ACTIVIDAD_2
,
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:, editable: true, nullable: true, length: 8, defaultValue: APY-00, modelName: ACTIVIDAD_3
,
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:, editable: true, nullable: true, length: 10, defaultValue: null, modelName: T_MAQ_EQUI_2
,
Coded Values:
[33310E25: Bulldozer]
,
[33310E12-1: Retro Llanta]
,
[33310E14: Paladraga]
, ...10 more...
)
-
GLOBALID
(
type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID
)
-
CREATED_USER
(
type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER
)
-
CREATED_DATE
(
type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE
)
-
LAST_EDITED_USER
(
type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER
)
-
LAST_EDITED_DATE
(
type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE
)
-
VBO_INSPEC
(
type: esriFieldTypeString, alias: Vbo. Inspector:, editable: true, nullable: true, length: 8, defaultValue: SGO-N, modelName: VBO_INSPEC
,
Coded Values:
[SGO-S: SI]
,
[SGO-N: NO]
)
-
COM_STATUS
(
type: esriFieldTypeString, alias: Estado Aviso Comisión:, editable: true, nullable: true, length: 5, defaultValue: METRA, modelName: COM_STATUS
,
Coded Values:
[METRA: Aviso en tratamiento Comision]
,
[MECON: Aviso Concluido Comisión]
)
-
SGO_STATUS
(
type: esriFieldTypeString, alias: Estado Envío SAP:, editable: true, nullable: true, length: 5, defaultValue: MESGO, modelName: SGO_STATUS
,
Coded Values:
[MESGO: Pendiente Enviar a SAP]
,
[MESAP: Enviado a SAP]
)
Templates:
-
Name: SGO.Z3_ALC_CT_APYMAQ
Description:
Prototype:
COM_STATUS: METRA
VBO_INSPEC: SGO-N
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
SGO_STATUS: MESGO
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Query,Create,Update,Uploads,Editing,Sync,Extract
Sync Can Return Changes: true
Is Data Versioned: false
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: true
Edit Fields Info:
- Creation Date Field: created_date
- Creator Field: created_user
- Edit Date Field: last_edited_date
- Editor Field: last_edited_user
Supports Query With Historic Moment: true
Supports Coordinates Quantization: false
Supported Operations:
Query
Query Attachments
Query Related Records
Apply Edits
Add Features
Update Features
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata