Name: personal

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1de6acbb9d514e91a77a77609813cfec

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 )
• tipodocumentotrabajor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: TIPO DE DOCUMENTO, type: esriFieldTypeString , Coded Values: [Cedula: Cedula] , [Cedula Extraería: Cedula Extraería] , [Tarjeta de identidad: Tarjeta de identidad] , ...1 more... )
• numerodocumentotrabajor ( nullable: true, editable: true, defaultValue: null, length: 20, alias: No. DE DOCUMENTO, type: esriFieldTypeString )
• primernombretrabajor ( nullable: true, editable: true, defaultValue: null, length: 50, alias: PRIMER NOMBRE DEL TRABAJADOR, type: esriFieldTypeString )
• segundonombretrabajor ( nullable: true, editable: true, defaultValue: null, length: 50, alias: SEGUNDO NOMBRE DEL TRABAJADOR, type: esriFieldTypeString )
• primerapellidotrabajor ( nullable: true, editable: true, defaultValue: null, length: 50, alias: PRIMER APELLIDO DEL TRABAJADOR, type: esriFieldTypeString )
• segundoapellidotrabajor ( nullable: true, editable: true, defaultValue: null, length: 50, alias: SEGUNDO APELLIDO DEL TRABAJADOR, type: esriFieldTypeString )
• edad ( nullable: true, editable: true, defaultValue: null, alias: EDAD, type: esriFieldTypeInteger )
• sexoalnacer ( nullable: true, editable: true, defaultValue: null, length: 255, alias: SEXO AL NACER, type: esriFieldTypeString , Coded Values: [Maculino: Maculino] , [Femenino: Femenino] , [Indeterminado: Indeterminado] )
• genero ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GENERO, type: esriFieldTypeString , Coded Values: [Hombre: Hombre] , [Mujer: Mujer] , [Hombre trans: Hombre trans] , ...1 more... )
• grupoetnico ( nullable: true, editable: true, defaultValue: null, length: 255, alias: GRUPO ÉTNICO, type: esriFieldTypeString , Coded Values: [Indígena: Indígena] , [Gitano (a) o Rrom: Gitano (a) o Rrom] , [Raizal del Archipiélago de San Andrés, Providencia y Santa Catalina: Raizal del Archipiélago de San Andrés, Providencia y Santa Catalina] , ...3 more... )
• cabezafamilia ( nullable: true, editable: true, defaultValue: null, length: 255, alias: CABEZA DE FAMILIA, type: esriFieldTypeString , Coded Values: [Si: Si] , [No: No] )
• personavinculadaprocesoreintegr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PERSONA VINCULADA A PROCESO DE REINTEGRACIÓN/REINCORPORACIÓN, type: esriFieldTypeString , Coded Values: [Si: Si] , [No: No] )
• discapacidad ( nullable: true, editable: true, defaultValue: null, length: 255, alias: DISCAPACIDAD, type: esriFieldTypeString , Coded Values: [intelectual (cognitiva): intelectual (cognitiva)] , [fisica: fisica] , [psicosocial (mental): psicosocial (mental)] , ...6 more... )
• victimaconflictoarmado ( nullable: true, editable: true, defaultValue: null, length: 255, alias: VÍCTIMA DE CONFLICTO, type: esriFieldTypeString , Coded Values: [Si: Si] , [No: No] )
• localizaciongeografica ( nullable: true, editable: true, defaultValue: null, length: 255, alias: LOCALIZACIÓN GEOGRÁFICA, type: esriFieldTypeString , Coded Values: [Rural disperso: Rural disperso] , [Urbana: Urbana] )
• nombrempioresidencia ( nullable: true, editable: true, defaultValue: null, length: 255, alias: MUNICIPIO DE RESIDENCIA, type: esriFieldTypeString , Coded Values: [MEDELLÍN: MEDELLÍN] , [ABEJORRAL: ABEJORRAL] , [ABRIAQUÍ: ABRIAQUÍ] , ...1034 more... )
• procedenciamanoobra ( nullable: true, editable: true, defaultValue: null, length: 255, alias: PROCEDENCIA MANO DE OBRA, type: esriFieldTypeString , Coded Values: [Local: Local] , [Foránea: Foránea] )
• tipovinculacionproyecto ( nullable: true, editable: true, defaultValue: null, length: 255, alias: TIPO DE VINCULACIÓN AL PROYECTO, type: esriFieldTypeString , Coded Values: [Contrato de obra: Contrato de obra] , [Contrato de interventoría: Contrato de interventoría] , [Administrador vial: Administrador vial] , ...2 more... )
• porcentajededicacion2 ( nullable: true, editable: true, defaultValue: null, alias: PORCENTAJE DE DEDICACIÓN, type: esriFieldTypeDouble )
• clasificacionocupacion ( nullable: true, editable: true, defaultValue: null, length: 255, alias: CLASIFICACIÓN DE OCUPACIÓN, type: esriFieldTypeString , Coded Values: [1. Directores y gerentes: 1. Directores y gerentes] , [2. Profesionales, científicos e intelectuales: 2. Profesionales, científicos e intelectuales] , [3. Técnicos y profesionales del nivel medio: 3. Técnicos y profesionales del nivel medio] , ...6 more... )
• fechaingreso ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FECHA DE INGRESO, type: esriFieldTypeDate )
• fecharetiro ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: FECHA DE RETIRO, type: esriFieldTypeDate )
• tipocontratolaboral ( nullable: true, editable: true, defaultValue: null, length: 255, alias: TIPO DE CONTRATO LABORAL, type: esriFieldTypeString , Coded Values: [Contrato por obra labor: Contrato por obra labor] , [Contrato de trabajo a término fijo: Contrato de trabajo a término fijo] , [Contrato de trabajo a término indefinido: Contrato de trabajo a término indefinido] , ...3 more... )
• remuneracionsalarialsmmlv ( nullable: true, editable: true, defaultValue: null, length: 255, alias: REMUNERACIÓN SALARIAL SMMLV, type: esriFieldTypeString , Coded Values: [1 SMMLV: 1 SMMLV] , [> 1 SMMLV < 2 SMMLV: > 1 SMMLV < 2 SMMLV] , [> 2 SMMLV < 3 SMMLV: > 2 SMMLV < 3 SMMLV] , ...8 more... )
• 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:

• INCLUSION_SOCIAL_EN_LA_GESTION_DE_PROYECTOS_personal (4) -- Related To: INCLUSION_SOCIAL_EN_LA_GESTION_DE_PROYECTOS (0)

Capabilities: Create,Editing,Sync,Uploads

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

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

Ownership Based Access Control:

• Allow Others to Update: true
• Allow Others to Delete: true
• Allow Others to Query: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata