Layers:

Layer: F_AL_13_Reporte_de_Novedades (0)


Name: F_AL_13_Reporte_de_Novedades

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:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)


Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"F-AL-13 Reporte de Novedades","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:

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• identificacion (type: esriFieldTypeString, alias: Identificación, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fecha_actual (type: esriFieldTypeDate, alias: Fecha actual, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fecha_actual_decimal (type: esriFieldTypeInteger, alias: Fecha actual decimal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fecha_final (type: esriFieldTypeInteger, alias: fecha_final, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fecha_final_ (type: esriFieldTypeDate, alias: fecha_final, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fecha_diligenciamiento (type: esriFieldTypeDate, alias: Fecha diligenciamiento, 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_director (type: esriFieldTypeString, alias: Correo director, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Tipo_novedad (type: esriFieldTypeString, alias: Tipo de novedad, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• reportes (type: esriFieldTypeString, alias: Seleccione los reportes que se presentaron durante el mes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• colaboradores_ingreso (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_ingreso (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• datos_ingreso_count (type: esriFieldTypeString, alias: datos_ingreso_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• colaboradores_retiro (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_retiro (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• datos_retiro_count (type: esriFieldTypeString, alias: datos_retiro_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• colaboradores_is (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_is (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• datos_is_count (type: esriFieldTypeString, alias: datos_is_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• colaboradores_ipr (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_ipr (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• datos_ipr_count (type: esriFieldTypeString, alias: datos_ipr_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• colaboradores_itef (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_itef (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• datos_itef_count (type: esriFieldTypeString, alias: datos_itef_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• colaboradores_ans (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_ans (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• datos_ans_count (type: esriFieldTypeString, alias: datos_ans_count, SQL Type: sqlTypeOther, length: 255, 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)
• correo_aprobador (type: esriFieldTypeString, alias: Correo aprobador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:


Relationships:
• F_AL_13_Reporte_de_Novedades_licencias (1) -- Related To: licencias (1)
• F_AL_13_Reporte_de_Novedades_permisos (3) -- Related To: permisos (3)
• F_AL_13_Reporte_de_Novedades_incapacidades (5) -- Related To: incapacidades (5)
• F_AL_13_Reporte_de_Novedades_vacaciones_disfrutadas (7) -- Related To: vacaciones_disfrutadas (7)
• F_AL_13_Reporte_de_Novedades_datos_ingreso (9) -- Related To: datos_ingreso (9)
• F_AL_13_Reporte_de_Novedades_datos_retiro (10) -- Related To: datos_retiro (10)
• F_AL_13_Reporte_de_Novedades_datos_is (11) -- Related To: datos_is (11)
• F_AL_13_Reporte_de_Novedades_datos_ipr (12) -- Related To: datos_ipr (12)
• F_AL_13_Reporte_de_Novedades_datos_itef (13) -- Related To: datos_itef (13)
• F_AL_13_Reporte_de_Novedades_datos_ans (14) -- Related To: datos_ans (14)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 1:34:05 PM

Data Last Edit Date: 9/10/2024 1:34:05 PM

Tables:

licencias (1)


Name: licencias

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• tipo_de_liciencia (type: esriFieldTypeString, alias: Tipo de Liciencia, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Licencia: Licencia], [Licencia No remunerada: Licencia No remunerada], [Licencia por Luto: Licencia por Luto], ... 8 more ...)
• colaboradores_l (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_l (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• relacion_personal_l_count (type: esriFieldTypeString, alias: relacion_personal_l_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• observaciones_justificacion (type: esriFieldTypeString, alias: Observaciones - Justificación, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)
• tipo_de_licencia (type: esriFieldTypeString, alias: Tipo de Licencia, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Licencia: Licencia], [Licencia No remunerada: Licencia No remunerada], [Licencia por Luto: Licencia por Luto], ... 1 more ...)

Relationships:
• F_AL_13_Reporte_de_Novedades_licencias (1) -- Related To: F_AL_13_Reporte_de_Novedades (0)
• licencias_relacion_personal_l (2) -- Related To: relacion_personal_l (2)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 1:34:05 PM

Data Last Edit Date: 9/10/2024 1:34:05 PM

relacion_personal_l (2)


Name: relacion_personal_l

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_l (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_l (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_l (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• duracion_dias__l (type: esriFieldTypeDouble, alias: Duración (días), SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)
• tipo_de_licencia_ (type: esriFieldTypeString, alias: Tipo de Licencia, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:
• licencias_relacion_personal_l (2) -- Related To: licencias (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 1:34:05 PM

Data Last Edit Date: 9/10/2024 1:34:05 PM

permisos (3)


Name: permisos

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• tipo_de_permisos (type: esriFieldTypeString, alias: Tipo de Permisos, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Beneficio bicijoyco: Beneficio bicijoyco], [Beneficio cumpleaños: Beneficio cumpleaños], [Beneficio graduación: Beneficio graduación], ... 4 more ...)
• colaboradores_p (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_p (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• relacion_personal_p_count (type: esriFieldTypeString, alias: relacion_personal_p_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• observaciones_justificacion_p (type: esriFieldTypeString, alias: Observaciones - Justificación, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:
• F_AL_13_Reporte_de_Novedades_permisos (3) -- Related To: F_AL_13_Reporte_de_Novedades (0)
• permisos_relacion_personal_p (4) -- Related To: relacion_personal_p (4)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

relacion_personal_p (4)


Name: relacion_personal_p

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_p (type: esriFieldTypeString, alias: Nombre 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)
• duracion_dias_p (type: esriFieldTypeDouble, alias: Duración (días), SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)
• duracion_horas_l (type: esriFieldTypeDouble, alias: Duración (horas), SQL Type: sqlTypeOther, nullable: true, editable: true)
• tipo_de_permisos_ (type: esriFieldTypeString, alias: Tipo de Permisos, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:
• permisos_relacion_personal_p (4) -- Related To: permisos (3)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

incapacidades (5)


Name: incapacidades

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• tipo_incapacidad (type: esriFieldTypeString, alias: Tipo de Incapacidad, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Incapacidad por enfermedad general: Incapacidad por enfermedad general], [Incapacidad por enfermedad laboral o accidente: Incapacidad por enfermedad laboral o accidente], [Licencia de Maternidad: Licencia de Maternidad], ... 1 more ...)
• colaboradores_i (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_i (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• relacion_personal_i_count (type: esriFieldTypeString, alias: relacion_personal_i_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• observaciones_justificacion_i (type: esriFieldTypeString, alias: Observaciones - Justificación, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:
• F_AL_13_Reporte_de_Novedades_incapacidades (5) -- Related To: F_AL_13_Reporte_de_Novedades (0)
• incapacidades_relacion_personal_i (6) -- Related To: relacion_personal_i (6)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

relacion_personal_i (6)


Name: relacion_personal_i

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_i (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_i (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_i (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• duracion_dias_i (type: esriFieldTypeDouble, alias: Duración (días), SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)
• tipo_incapacidad_ (type: esriFieldTypeString, alias: Tipo de Incapacidad, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:
• incapacidades_relacion_personal_i (6) -- Related To: incapacidades (5)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

vacaciones_disfrutadas (7)


Name: vacaciones_disfrutadas

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• colaboradores_v (type: esriFieldTypeString, alias: Colaboradores, SQL Type: sqlTypeOther, length: 1000000, nullable: true, editable: true)
• n_personas_v (type: esriFieldTypeInteger, alias: N° de personas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• relacion_personal_v_count (type: esriFieldTypeString, alias: relacion_personal_v_count, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• observaciones_justificacion_v (type: esriFieldTypeString, alias: Observaciones - Justificación, SQL Type: sqlTypeOther, length: 5000, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:
• F_AL_13_Reporte_de_Novedades_vacaciones_disfrutadas (7) -- Related To: F_AL_13_Reporte_de_Novedades (0)
• vacaciones_disfrutadas_relacion_personal_v (8) -- Related To: relacion_personal_v (8)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

relacion_personal_v (8)


Name: relacion_personal_v

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_v (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_v (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_v (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• duracion_dias_v (type: esriFieldTypeDouble, alias: Duración (días), SQL Type: sqlTypeOther, nullable: true, editable: true)
• vacaciones_dinero (type: esriFieldTypeDouble, alias: Vacaciones en Dinero, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:
• vacaciones_disfrutadas_relacion_personal_v (8) -- Related To: vacaciones_disfrutadas (7)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

datos_ingreso (9)


Name: datos_ingreso

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_ingreso (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_ingreso (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_ingreso (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fecha_ingreso (type: esriFieldTypeDate, alias: Fecha de ingreso, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)
• salario (type: esriFieldTypeDouble, alias: Salario (Valor), SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_sp (type: esriFieldTypeString, alias: num_sp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• salario_miles (type: esriFieldTypeString, alias: Salario (miles), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• auxilios_no_salariales_ (type: esriFieldTypeString, alias: Auxilios No Salariales, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• valor_aux_alimentacion1 (type: esriFieldTypeDouble, alias: Valor Aux. Alimentación, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_alimentacion1_ (type: esriFieldTypeDouble, alias: Valor Aux. Alimentación, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_comunicacion1 (type: esriFieldTypeDouble, alias: Valor Aux. Comunicación, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_comunicacion1_ (type: esriFieldTypeDouble, alias: Valor Aux. Comunicación, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_localizacion1 (type: esriFieldTypeDouble, alias: Valor Aux. Localización, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_localizacion1_ (type: esriFieldTypeDouble, alias: Valor Aux. Localización, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_extralegal1 (type: esriFieldTypeDouble, alias: Valor Auxilio Extralegal TPTE., SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_extralegal1_ (type: esriFieldTypeDouble, alias: Valor Auxilio Extralegal TPTE., SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_rodamiento1 (type: esriFieldTypeDouble, alias: Valor Rodamiento, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_rodamiento1_ (type: esriFieldTypeDouble, alias: Valor Rodamiento, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_auxilio1 (type: esriFieldTypeDouble, alias: valor_auxilio1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_va1 (type: esriFieldTypeString, alias: num_va1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• valor_auxilios_miles1 (type: esriFieldTypeString, alias: Valor total auxilios, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prima_regional1 (type: esriFieldTypeString, alias: Prima regional, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Si: Si], [No: No])
• valor_prima_regional1 (type: esriFieldTypeDouble, alias: Valor prima regional, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_pr1 (type: esriFieldTypeString, alias: num_pr1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prima_regional_miles1 (type: esriFieldTypeString, alias: prima_regional_miles1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tiempo_extra_fijo1 (type: esriFieldTypeString, alias: Tiempo extra fijo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Si: Si], [No: No])
• valor_tiempo_extra_fijo1 (type: esriFieldTypeDouble, alias: Valor Tiempo extra fijo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fecha_ingreso_ (type: esriFieldTypeString, alias: Fecha de ingreso, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:
• F_AL_13_Reporte_de_Novedades_datos_ingreso (9) -- Related To: F_AL_13_Reporte_de_Novedades (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 1:34:05 PM

Data Last Edit Date: 9/10/2024 1:34:05 PM

datos_retiro (10)


Name: datos_retiro

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_retiro (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_retiro (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_retiro (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fecha_retiro (type: esriFieldTypeDate, alias: Fecha de retiro, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• motivo_retiro (type: esriFieldTypeString, alias: Motivo del retiro, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Renuncia Voluntaria: Renuncia Voluntaria], [Terminación de la Obra o Labor: Terminación de la Obra o Labor], [No Renovación del Contrato: No Renovación del Contrato], ... 5 more ...)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)
• he_pendientes (type: esriFieldTypeString, alias: Tiene horas extras pendientes por pagar, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Si: Si], [No: No])
• n_horas (type: esriFieldTypeString, alias: ¿Cuantas horas?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• descuentos_pendientes (type: esriFieldTypeString, alias: Tiene descuentos penientes por realizar, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Si: Si], [No: No])
• valor (type: esriFieldTypeDouble, alias: Valor, SQL Type: sqlTypeOther, nullable: true, editable: true)
• concepto (type: esriFieldTypeString, alias: Concepto, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• novedad_ausentismo (type: esriFieldTypeString, alias: Tiene alguna novedad de ausentismo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Si: Si], [No: No])
• novedad (type: esriFieldTypeString, alias: Indique la novedad, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fecha_retiro_ (type: esriFieldTypeString, alias: Fecha de retiro, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:
• F_AL_13_Reporte_de_Novedades_datos_retiro (10) -- Related To: F_AL_13_Reporte_de_Novedades (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

datos_is (11)


Name: datos_is

Display Field: objectid

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_is (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_is (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_is (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incremento_salarial (type: esriFieldTypeDouble, alias: Valor incremento Salarial, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:
• F_AL_13_Reporte_de_Novedades_datos_is (11) -- Related To: F_AL_13_Reporte_de_Novedades (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

datos_ipr (12)


Name: datos_ipr

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_ipr (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_ipr (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_ipr (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Incremento_Prima_R (type: esriFieldTypeDouble, alias: Valor incremento Prima Regional, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:
• F_AL_13_Reporte_de_Novedades_datos_ipr (12) -- Related To: F_AL_13_Reporte_de_Novedades (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

datos_itef (13)


Name: datos_itef

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_itef (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_itef (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_itef (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• incremento_tiempo_extra_F (type: esriFieldTypeDouble, alias: Incremento de Valor Tiempo Extra Fijo, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:
• F_AL_13_Reporte_de_Novedades_datos_itef (13) -- Related To: F_AL_13_Reporte_de_Novedades (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM

datos_ans (14)


Name: datos_ans

Display Field: objectid

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: false

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• nombre_colaborador_ans (type: esriFieldTypeString, alias: Nombre Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• n_identificacion_colaborador_ans (type: esriFieldTypeString, alias: No. Identificación Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cargo_colaborador_ans (type: esriFieldTypeString, alias: Cargo Colaborador, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• auxilios_no_salariales_ (type: esriFieldTypeString, alias: Auxilios No Salariales, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Auxilio de Comunicación: Auxilio de Comunicación], [Auxilio de Alimentación: Auxilio de Alimentación], [Auxilio de Localización: Auxilio de Localización], ... 3 more ...)
• valor_aux_alimentacion (type: esriFieldTypeDouble, alias: Valor Aux. Alimentación, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_alimentacion_ (type: esriFieldTypeDouble, alias: Valor Aux. Alimentación, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_comunicacion (type: esriFieldTypeDouble, alias: Valor Aux. Comunicación, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_comunicacion_ (type: esriFieldTypeDouble, alias: Valor Aux. Comunicación, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_localizacion (type: esriFieldTypeDouble, alias: Valor Aux. Localización, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_localizacion_ (type: esriFieldTypeDouble, alias: Valor Aux. Localización, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_extralegal (type: esriFieldTypeDouble, alias: Valor Auxilio Extralegal TPTE., SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_aux_extralegal_ (type: esriFieldTypeDouble, alias: Valor Auxilio Extralegal TPTE., SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_rodamiento (type: esriFieldTypeDouble, alias: Valor Rodamiento, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_rodamiento_ (type: esriFieldTypeDouble, alias: Valor Rodamiento, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_viaticos (type: esriFieldTypeDouble, alias: Valor Viáticos, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_viaticos_ (type: esriFieldTypeDouble, alias: Valor Viáticos, SQL Type: sqlTypeOther, nullable: true, editable: true)
• valor_auxilio (type: esriFieldTypeDouble, alias: valor_auxilio, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_va (type: esriFieldTypeString, alias: num_va, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• valor_auxilios_miles (type: esriFieldTypeString, alias: Valor total auxilios, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)
• auxilios_no_salariales (type: esriFieldTypeString, alias: Auxilios No Salariales, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:
• F_AL_13_Reporte_de_Novedades_datos_ans (14) -- Related To: F_AL_13_Reporte_de_Novedades (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/10/2024 1:34:05 PM

Schema Last Edit Date: 9/10/2024 4:32:38 AM

Data Last Edit Date: 9/10/2024 1:34:05 PM