Layer: Horas_Extras (ID:0)

View In: Map Viewer

Name: Horas_Extras

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"F-AL-14 Relación de horas extras","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Global ID Field: globalid

Type ID Field:

Fields:

objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
F_AL_14 (type: esriFieldTypeString, alias: F_AL_14, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
identificacion (type: esriFieldTypeString, alias: Identificación, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
nombre (type: esriFieldTypeString, alias: Nombre, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cargo (type: esriFieldTypeString, alias: Cargo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
correo (type: esriFieldTypeString, alias: Correo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
fecha (type: esriFieldTypeDate, alias: Fecha, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
id_mes_ (type: esriFieldTypeInteger, alias: Id mes, SQL Type: sqlTypeOther, nullable: true, editable: true)
mes (type: esriFieldTypeString, alias: Mes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ano_novedad (type: esriFieldTypeInteger, alias: Año Novedad, SQL Type: sqlTypeOther, nullable: true, editable: true)
empresa (type: esriFieldTypeString, alias: Empresa, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CONSORCIO CJ 2020: CONSORCIO CJ 2020], [CONSORCIO INFRACOL: CONSORCIO INFRACOL], [CONSORCIO INTERVIAL ANDINO: CONSORCIO INTERVIAL ANDINO], ... 10 more ...)
centro_costos (type: esriFieldTypeString, alias: Centro de Costos, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
area_proyecto (type: esriFieldTypeString, alias: Área o Proyecto, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
correo_aprobador (type: esriFieldTypeString, alias: Correo aprobador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
colaborador (type: esriFieldTypeString, alias: Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
n_identificacion_colaborador (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
cargo_colaborador (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
corro_colaborador (type: esriFieldTypeString, alias: Correo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tipo_HE_Recargos (type: esriFieldTypeString, alias: Tipo de Horas extras y Recargos, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
Hora_Extra_Diurna_Ordinaria (type: esriFieldTypeDouble, alias: Hora Extra Diurna Ordinaria (1.25), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Extra_Diurna_Ordinaria_ (type: esriFieldTypeDouble, alias: Hora Extra Diurna Ordinaria (1.25), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Extra_Nocturna (type: esriFieldTypeDouble, alias: Hora Extra Nocturna (1.75), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Extra_Nocturna_ (type: esriFieldTypeDouble, alias: Hora Extra Nocturna (1.75), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Extra_Diurna_Dominical_y_Festivos (type: esriFieldTypeDouble, alias: Hora Extra Diurna Dominical y Festivos (2.00), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Extra_Diurna_Dominical_y_Festivos_ (type: esriFieldTypeDouble, alias: Hora Extra Diurna Dominical y Festivos (2.00), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Extra_Nocturna_Dominical_y_Festivos (type: esriFieldTypeDouble, alias: Hora Extra Nocturna Dominical y Festivos (2.50), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Extra_Nocturna_Dominical_y_Festivos_ (type: esriFieldTypeDouble, alias: Hora Extra Nocturna Dominical y Festivos (2.50), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Recargo_Diruno_Dominical_Y_Festivos_Habitual (type: esriFieldTypeDouble, alias: Hora Recargo Diruno Dominical Y Festivos Habitual (1.75), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Recargo_Diruno_Dominical_Y_Festivos_Habitual_ (type: esriFieldTypeDouble, alias: Hora Recargo Diruno Dominical Y Festivos Habitual (1.75), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Recargo_Diurno_Dominical_Y_Festivos_No_Habitual (type: esriFieldTypeDouble, alias: Hora Recargo Diurno Dominical Y Festivos No Habitual (0.75), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Recargo_Diurno_Dominical_Y_Festivos_No_Habitual_ (type: esriFieldTypeDouble, alias: Hora Recargo Diurno Dominical Y Festivos No Habitual (0.75), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Recargo_Nocturno (type: esriFieldTypeDouble, alias: Hora Recargo Nocturno (0.35), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Recargo_Nocturno_ (type: esriFieldTypeDouble, alias: Hora Recargo Nocturno (0.35), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Recargo_Nocturno_Dominical_Y_Festivos (type: esriFieldTypeDouble, alias: Hora Recargo Nocturno Dominical Y Festivos (1.10), SQL Type: sqlTypeOther, nullable: true, editable: true)
Hora_Recargo_Nocturno_Dominical_Y_Festivos_ (type: esriFieldTypeDouble, alias: Hora Recargo Nocturno Dominical Y Festivos (1.10), SQL Type: sqlTypeOther, nullable: true, editable: true)
total_he (type: esriFieldTypeDouble, alias: Total Horas extras, SQL Type: sqlTypeOther, nullable: true, editable: true)
total_Recargos (type: esriFieldTypeDouble, alias: Total Recargos, SQL Type: sqlTypeOther, nullable: true, editable: true)
CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/17/2025 6:51:40 PM

Schema Last Edit Date: 7/17/2025 6:51:40 PM

Data Last Edit Date: 7/17/2025 6:51:40 PM

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