Layers:

Layer: PRE_ACTA_MENSUAL_INVERSION_SOCIAL (0)

Name: PRE_ACTA_MENSUAL_INVERSION_SOCIAL

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: dc41f6133f5444f881f7e7f2ebf00ad1

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [255, 0, 0, 255]
Size: 8.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[255, 255, 0, 255] Width: 1
Label: PRE-ACTA MENSUAL INVERSION SOCIAL
Description: Survey Data Locations
Transparency: 0
Labeling 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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• uniquerowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: RowID, type: esriFieldTypeGUID )
• tipodocumentoinversionsocial ( nullable: true, editable: true, defaultValue: null, length: 255, alias: TIPO DE DOCUMENTO, type: esriFieldTypeString , Coded Values: [Pre-acta: Pre-acta] , [Seguimiento final: Seguimiento final] )
• numeropreacta ( nullable: true, editable: true, defaultValue: null, alias: PRE-ACTA MENSUAL DE INVERSIÓN SOCIAL No., type: esriFieldTypeInteger )
• fechadiligenciaminento ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FECHA, type: esriFieldTypeDate )
• objetocontrato ( nullable: true, editable: true, defaultValue: null, length: 500, alias: OBJETO DEL CONTRATO, type: esriFieldTypeString )
• numerocontratobra ( nullable: true, editable: true, defaultValue: null, length: 5, alias: No. CONTRATO DE OBRA Y AÑO, type: esriFieldTypeString )
• noinforme ( nullable: true, editable: true, defaultValue: null, length: 255, alias: No.INFORME, type: esriFieldTypeString )
• fechainforme ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FECHA DEL INFORME, type: esriFieldTypeDate )
• numerobalancesocioambiental ( nullable: true, editable: true, defaultValue: null, alias: N°., type: esriFieldTypeInteger )
• fechabalancesocioambiental ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FECHA, type: esriFieldTypeDate )
• numerobalancesociopredial ( nullable: true, editable: true, defaultValue: null, alias: N°., type: esriFieldTypeInteger )
• fechabalancesociopredial ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FECHA, type: esriFieldTypeDate )
• valorpreactatramitadoreembolsoa ( nullable: true, editable: true, defaultValue: null, length: 255, alias: VALOR PRE-ACTA TRAMITADO POR REEMBOLSO DE GASTOS, type: esriFieldTypeString )
• valorbasicopreacta ( nullable: true, editable: true, defaultValue: null, length: 255, alias: VALOR BÁSICO PRE-ACTA, type: esriFieldTypeString )
• valorivamensual ( nullable: true, editable: true, defaultValue: null, length: 5, alias: VALOR IVA MENSUAL, type: esriFieldTypeString )
• valortotalpreeactamensualinvers ( nullable: true, editable: true, defaultValue: null, length: 10, alias: VALOR TOTAL PRE-ACTA MENSUAL DE INVERSIÓN SOCIAL, type: esriFieldTypeString )
• recursoremanenteporejecutar ( nullable: true, editable: true, defaultValue: null, alias: RECURSO REMANENTE (VALOR POR EJECUTAR), type: esriFieldTypeDouble )
• valorprovisionsocialincluido ( nullable: true, editable: true, defaultValue: null, alias: VALOR PROVISIÓN SOCIAL INCLUIDO IVA, type: esriFieldTypeDouble )
• valorpreactatramitadoitemnoprev ( nullable: true, editable: true, defaultValue: null, alias: VALOR PROVISIÓN SOCIAL INCLUIDO IVA, type: esriFieldTypeDouble )
• otroscostosrelacionadoacionados ( nullable: true, editable: true, defaultValue: null, alias: OTROS COSTOS RELACIONADOS CON REEMBOLSO DE GASTOS EN LA PRE-ACTA, type: esriFieldTypeDouble )
• valortotalmesgestionsocioambien ( nullable: true, editable: true, defaultValue: null, alias: VALOR TOTAL MES GESTIÓN SOCIOAMBIENTAL, type: esriFieldTypeDouble )
• valortotalmesgestionsociopredia ( nullable: true, editable: true, defaultValue: null, alias: VALOR TOTAL MES GESTIÓN SOCIOPREDIAL, type: esriFieldTypeDouble )
• valortotalejecutadoacumulado ( nullable: true, editable: true, defaultValue: null, alias: VALOR TOTAL EJECUTADO ACUMULADO, type: esriFieldTypeDouble )
• ejecucionrecursosocialasignado ( nullable: true, editable: true, defaultValue: null, alias: EJECUCIÓN DEL RECURSO SOCIAL ASIGNADO (%), type: esriFieldTypeDouble )
• observacionesconclusiones ( nullable: true, editable: true, defaultValue: null, length: 500, alias: OBSERVACIONES, type: esriFieldTypeString )
• nombrereperesentantelegalcpontr ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Representante Legal Contratista, type: esriFieldTypeString )
• matriculareperesentantelegalcon ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Matrícula Profesional No.:, type: esriFieldTypeString )
• esapoderadocontratista ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Es apoderado?, type: esriFieldTypeString , Coded Values: [Si: Si] , [No: No] )
• nombreprofesionalsocialcontrati ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Profesional Social Contratista, type: esriFieldTypeString )
• matriculaprofesionalsocialcontr ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Matrícula Profesional No.:, type: esriFieldTypeString )
• matricularepresentantelegalinte ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Representante Legal Interventoría, type: esriFieldTypeString )
• matriculainterventoria ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Matrícula Profesional No.:, type: esriFieldTypeString )
• esapoderadointereventorial ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Es apoderado?, type: esriFieldTypeString , Coded Values: [Si: Si] , [No: No] )
• nombrprofesionalsociaintervento ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Profesional Social Interventoría, type: esriFieldTypeString )
• matriculaprofesionalsociainterv ( nullable: true, editable: true, defaultValue: null, length: 20, alias: Matrícula Profesional No.:, type: esriFieldTypeString )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
Templates:
• Name: New Feature
  Description:
  Prototype:
  Drawing Tool: N/A

Relationships:

• PRE_ACTA_MENSUAL_INVERSION_SOCIAL_insumoitem (0) -- Related To: insumoitem (1)
• PRE_ACTA_MENSUAL_INVERSION_SOCIAL_insumoitem2 (1) -- Related To: insumoitem2 (2)

Tables:

Table: insumoitem (1)

Name: insumoitem

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: dc41f6133f5444f881f7e7f2ebf00ad1

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• nombreisumoproyectosocioambien ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROYECTO, type: esriFieldTypeString )
• nombreisumoactividadsocioambien ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ACTIVIDAD, type: esriFieldTypeString )
• unidadsocioambiental ( nullable: true, editable: true, defaultValue: null, length: 255, alias: UNIDAD, type: esriFieldTypeString )
• cantidadsocioambiental ( nullable: true, editable: true, defaultValue: null, alias: CANTIDAD, type: esriFieldTypeInteger )
• valorunitariosocioambiental ( nullable: true, editable: true, defaultValue: null, alias: VALOR UNITARIO ($), type: esriFieldTypeDouble )
• valorbasicogestionsocioambienta ( nullable: true, editable: true, defaultValue: null, alias: VALOR BÁSICO GESTIÓN SOCIOAMBIENTAL($), type: esriFieldTypeDouble )
• rembolsoitemambien ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SELECCIONE SE TRATA DE UN REEMBOLSO O DE UN ITEM, type: esriFieldTypeString , Coded Values: [reembolso: reembolso] , [item: ítem] )
• valorotrosgestionsocioambiental ( nullable: true, editable: true, defaultValue: null, alias: VALOR GESTIÓN SOCIOAMBIENTAL, type: esriFieldTypeDouble )
• cantidadejucutadomessocioambien ( nullable: true, editable: true, defaultValue: null, alias: CANTIDAD EJECUTADO MES, type: esriFieldTypeInteger )
• valorbasicoejecutadomessocioamb ( nullable: true, editable: true, defaultValue: null, alias: VALOR BÁSICO EJECUTADO MES ($), type: esriFieldTypeDouble )
• porcentajeotrosocioambiental ( nullable: true, editable: true, defaultValue: null, alias: OTROS * (%), type: esriFieldTypeDouble )
• valorotrosmessocioambiental ( nullable: true, editable: true, defaultValue: null, alias: VALOR OTROS MES ($), type: esriFieldTypeDouble )
• valormesgesionsocioambiental ( nullable: true, editable: true, defaultValue: null, alias: VALOR MES GESTIÓN SOCIOAMBIENTAL, type: esriFieldTypeDouble )
• cantacumuladoejucutadoambi ( nullable: true, editable: true, defaultValue: null, alias: CANTIDAD EJECUTADO. ACUMULADO. **, type: esriFieldTypeInteger )
• valoracumuladoejucutadosocioamb ( nullable: true, editable: true, defaultValue: null, alias: VALOR EJECUTADO ACUMULADO ($) **, type: esriFieldTypeDouble )
• valorporejecutarsocioambiental ( nullable: true, editable: true, defaultValue: null, alias: VALOR POR EJECUTAR ($), type: esriFieldTypeDouble )
• obsercacionesbalancesocioambien ( nullable: true, editable: true, defaultValue: null, length: 255, alias: OBSERVACIONES, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Relationships:

• PRE_ACTA_MENSUAL_INVERSION_SOCIAL_insumoitem (0) -- Related To: PRE_ACTA_MENSUAL_INVERSION_SOCIAL (0)

Table: insumoitem2 (2)

Name: insumoitem2

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: dc41f6133f5444f881f7e7f2ebf00ad1

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
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: false
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: ObjectID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• nombreisumoproyectosociopredial ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROYECTO, type: esriFieldTypeString )
• nombreisumoactividadsociopredia ( nullable: true, editable: true, defaultValue: null, length: 255, alias: ACTIVIDAD, type: esriFieldTypeString )
• unidadsociopredial ( nullable: true, editable: true, defaultValue: null, alias: UNIDAD, type: esriFieldTypeInteger )
• cantidadsociopredial ( nullable: true, editable: true, defaultValue: null, alias: CANTIDAD, type: esriFieldTypeInteger )
• valorunitariosociopredial ( nullable: true, editable: true, defaultValue: null, alias: VALOR UNITARIO ($), type: esriFieldTypeDouble )
• valorbasicogestionsociopredial ( nullable: true, editable: true, defaultValue: null, alias: VALOR BÁSICO GESTIÓN SOCIOPREDIAL($), type: esriFieldTypeDouble )
• rembolsoitemsociopre ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SELECCIONE SE TRATA DE UN REEMBOLSO O DE UN ITEM, type: esriFieldTypeString , Coded Values: [reembolso: reembolso] , [item: ítem] )
• valorotrosgestionsociopredial ( nullable: true, editable: true, defaultValue: null, alias: VALOR GESTIÓN SOCIOPREDIAL, type: esriFieldTypeDouble )
• cantidadejucutadomessociopredia ( nullable: true, editable: true, defaultValue: null, alias: CANTIDAD EJECUtADA MES, type: esriFieldTypeInteger )
• valorbasicoejecutadomessociopre ( nullable: true, editable: true, defaultValue: null, alias: VALOR BÁSICO EJECUTADO MES ($), type: esriFieldTypeDouble )
• porcentajeotrosociopredial ( nullable: true, editable: true, defaultValue: null, alias: OTROS * (%), type: esriFieldTypeDouble )
• valorotrosmessociopredial ( nullable: true, editable: true, defaultValue: null, alias: VALOR OTROS MES ($), type: esriFieldTypeDouble )
• valormesgesionsociopredial ( nullable: true, editable: true, defaultValue: null, alias: VALOR MES GESTIÓN SOCIOPREDIAL, type: esriFieldTypeDouble )
• cantidadacumuladoejucutadosocio ( nullable: true, editable: true, defaultValue: null, alias: CANTIDAD EJECUTADA ACUMULADA. **, type: esriFieldTypeInteger )
• valoracumuladoejucutadosociopre ( nullable: true, editable: true, defaultValue: null, alias: VALOR EJECUTADO ACUMULADO ($) **, type: esriFieldTypeDouble )
• valorporejecutarsociopredial ( nullable: true, editable: true, defaultValue: null, alias: VALOR POR EJECUTAR ($), type: esriFieldTypeDouble )
• obsercacionesbalancesociopredia ( nullable: true, editable: true, defaultValue: null, length: 255, alias: OBSERVACIONES, type: esriFieldTypeString )
• parentrowid ( nullable: true, editable: true, defaultValue: null, length: 38, alias: ParentRowID, type: esriFieldTypeGUID )
• created_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, editable: false, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, editable: false, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )

Relationships:

• PRE_ACTA_MENSUAL_INVERSION_SOCIAL_insumoitem2 (1) -- Related To: PRE_ACTA_MENSUAL_INVERSION_SOCIAL (0)