Name: SGO.SGO_T_COMMON_INFO_ALC

Display Field: OPERATOR_NAME

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GLOBALID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• REL_AVISO (type: esriFieldTypeString, alias: No. Aviso origen, SQL Type: sqlTypeOther, length: 12, nullable: false, editable: true)
• REL_GLOBALID (type: esriFieldTypeString, alias: REL_GLOBALID, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• ACTIVITY_TYPE (type: esriFieldTypeString, alias: Tipo de actividad, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• ZONE_CODE (type: esriFieldTypeString, alias: Cód. Zona, SQL Type: sqlTypeOther, length: 6, nullable: false, editable: true)
• ZONE_DESC (type: esriFieldTypeString, alias: Zona, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• STORY (type: esriFieldTypeString, alias: ¿Aviso con historia?, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• START_DATE_UTC (type: esriFieldTypeDate, alias: Fecha/Hora inicio (UTC), SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• START_DATE_LTC (type: esriFieldTypeDate, alias: Fecha/Hora inicio (LTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ORDER_NUMBER (type: esriFieldTypeString, alias: No. orden, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• VEHICLE_PLATE (type: esriFieldTypeString, alias: Placa vehículo, SQL Type: sqlTypeOther, length: 12, nullable: false, editable: true)
• WORK_GROUP_ID (type: esriFieldTypeString, alias: Cód. ERP Comisión, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• WORK_GROUP (type: esriFieldTypeString, alias: Comisión, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• CITY_CODE (type: esriFieldTypeString, alias: Cód. Ciudad, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• CITY_DESC (type: esriFieldTypeString, alias: Ciudad, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• LOCALITIE_COD (type: esriFieldTypeString, alias: Cód. Localidad, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LOCALITIE_DESC (type: esriFieldTypeString, alias: Localidad, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NEIGHBORHOOD_COD (type: esriFieldTypeString, alias: Cód. Barrio, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• NEIGHBORHOOD_DESC (type: esriFieldTypeString, alias: Barrio, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: Dirección, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• DAMAGE_GROUP (type: esriFieldTypeString, alias: Cód. grupo ERP, SQL Type: sqlTypeOther, length: 12, nullable: false, editable: true)
• DAMAGE_CODE (type: esriFieldTypeString, alias: Cód. Daño ERP, SQL Type: sqlTypeOther, length: 12, nullable: false, editable: true)
• DAMAGE_DESC (type: esriFieldTypeString, alias: Trabajo Solicitado, SQL Type: sqlTypeOther, length: 80, nullable: false, editable: true)
• WORK_TYPE (type: esriFieldTypeString, alias: Tipo de trabajo, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• SYSTEM_TYPE (type: esriFieldTypeString, alias: Sistema, SQL Type: sqlTypeOther, length: 25, nullable: false, editable: true)
• PRIORITY_DESC (type: esriFieldTypeString, alias: Prioridad, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• OPERATOR_CODE (type: esriFieldTypeString, alias: ID Operador, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• OPERATOR_NAME (type: esriFieldTypeString, alias: Operador, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true)
• OPERATOR_USER_NAME (type: esriFieldTypeString, alias: Nombre usuario operador, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true)
• INSPECTOR_ID (type: esriFieldTypeString, alias: ID Inspector, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• INSPECTOR_NAME (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ENGINEER_ID (type: esriFieldTypeString, alias: ID Ingeniero, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ENGINEER (type: esriFieldTypeString, alias: Ingeniero, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• INITIAL_KM (type: esriFieldTypeDouble, alias: Kilómetro inicio, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FINAL_KM (type: esriFieldTypeDouble, alias: Kilómetro fin, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PENDING_JOB (type: esriFieldTypeString, alias: ¿Trabajo pendiente?, SQL Type: sqlTypeOther, length: 2, nullable: false, editable: true)
• OBSERVATIONS (type: esriFieldTypeString, alias: Observaciones, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• USER_ACCORDING (type: esriFieldTypeString, alias: ¿Usuario de acuerdo?, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• USER_WITNESS (type: esriFieldTypeString, alias: Usuario/testigo, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• USER_NAME (type: esriFieldTypeString, alias: Nombre usuario, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• USER_ID (type: esriFieldTypeString, alias: C.C/NIT, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• USER_PHONE (type: esriFieldTypeString, alias: Teléfono, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• END_DATE_UTC (type: esriFieldTypeDate, alias: Fecha/Hora fin (UTC), SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• END_DATE_LTC (type: esriFieldTypeDate, alias: Fecha/Hora fin (LTC), SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• WORK_GROUP_STATUS_CODE (type: esriFieldTypeString, alias: Cód. Atención comisión, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• WORK_GROUP_STATUS_DESC (type: esriFieldTypeString, alias: Estado atención comisión, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• TOTAL_TIME (type: esriFieldTypeDouble, alias: Tiempo total (min), SQL Type: sqlTypeOther, nullable: true, editable: true)
• INSPECTOR_APPROVAL (type: esriFieldTypeString, alias: Vbo. Inspector, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• INSPECTOR_OBSERV (type: esriFieldTypeString, alias: Obs. Inspector, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• ENGINEER_APPROVAL (type: esriFieldTypeString, alias: Vbo. Ingeniero, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ENGINEER_OBSERV (type: esriFieldTypeString, alias: Obs. Ingeniero, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• SYNC_ERP_CODE (type: esriFieldTypeString, alias: Cód. Sincronización SAP, SQL Type: sqlTypeOther, length: 10, nullable: false, editable: true)
• SYNC_ERP_DESC (type: esriFieldTypeString, alias: Estado sincronización ERP, SQL Type: sqlTypeOther, length: 50, nullable: false, editable: true)
• CAPTURE_LOCATION_X (type: esriFieldTypeDouble, alias: Lon Captura, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CAPTURE_LOCATION_Y (type: esriFieldTypeDouble, alias: Lat Captura, SQL Type: sqlTypeOther, nullable: false, editable: true)
• CAPTURE_DATE_UTC (type: esriFieldTypeDate, alias: Fecha/Hora Captura, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• GLOBALID (type: esriFieldTypeGlobalID, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CREATED_USER (type: esriFieldTypeString, alias: CREATED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LAST_EDITED_USER (type: esriFieldTypeString, alias: LAST_EDITED_USER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: LAST_EDITED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• USER_SIGNATURE (type: esriFieldTypeString, alias: Firma del usuario, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• OPERATOR_SIGNATURE (type: esriFieldTypeString, alias: Firma operador, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• INSPECTOR_SIGNATURE (type: esriFieldTypeString, alias: Firma del Inspector, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• ENGINEER_SIGNATURE (type: esriFieldTypeString, alias: Firma del Ingeniero, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• DAMAGE_GROUP_DESC (type: esriFieldTypeString, alias: Grupo daño en ERP, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INSPECTOR_APPROVAL_DATE (type: esriFieldTypeDate, alias: Fecha aprobación inspector, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
• ENGINEER_APPROVAL_DATE (type: esriFieldTypeDate, alias: Fecha aprobación ingeniero, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)

Templates:

Name: SGO.SGO_T_COMMON_INFO_ALC
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• REL_AVISO:
• REL_GLOBALID:
• ACTIVITY_TYPE:
• ZONE_CODE:
• ZONE_DESC:
• STORY:
• START_DATE_UTC: -2209161600000
• VEHICLE_PLATE:
• WORK_GROUP_ID:
• WORK_GROUP:
• CITY_CODE:
• CITY_DESC:
• ADDRESS:
• DAMAGE_GROUP:
• DAMAGE_CODE:
• DAMAGE_DESC:
• WORK_TYPE:
• SYSTEM_TYPE:
• OPERATOR_CODE:
• OPERATOR_NAME:
• OPERATOR_USER_NAME:
• INSPECTOR_ID:
• PENDING_JOB:
• END_DATE_UTC: -2209161600000
• END_DATE_LTC: -2209161600000
• WORK_GROUP_STATUS_CODE:
• WORK_GROUP_STATUS_DESC:
• SYNC_ERP_CODE:
• SYNC_ERP_DESC:
• CAPTURE_LOCATION_X: 0
• CAPTURE_LOCATION_Y: 0
• CAPTURE_DATE_UTC: -2209161600000

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/13/2021 8:32:26 PM

Schema Last Edit Date: 4/13/2021 8:32:26 PM

Data Last Edit Date: 4/13/2021 8:32:26 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat