Name: database

Display Field: objectid

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2abeee6e6e524a5b9592862577ea8b25

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, alias: ObjectID, type: esriFieldTypeOID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• zonatra ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Zona, type: esriFieldTypeString )
• subzonatra ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subzona, type: esriFieldTypeString )
• distritotra ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Distrito, type: esriFieldTypeString )
• circuitotra ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Circuito, type: esriFieldTypeString )
• subcircuittra ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Subcircuito, type: esriFieldTypeString )
• fechatallertr ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Fecha de inicio, type: esriFieldTypeDate )
• fechataller1tr ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Fecha de finalización, type: esriFieldTypeDate )
• modalidadtr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Tipo de actividad, type: esriFieldTypeString , Coded Values: [Presencial: Presencial] , [Virtual: Virtual] )
• tallertr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Nombre de la actividad, type: esriFieldTypeString , Coded Values: ["I CAPACITACIÓN VIRTUAL PARA LA REHABILITACIÓN DE FALTAS ADMINISTRATIVAS DISCIPLINARIAS": "I CAPACITACIÓN VIRTUAL PARA LA REHABILITACIÓN DE FALTAS ADMINISTRATIVAS DISCIPLINARIAS"] , ["II CAPACITACIÓN VIRTUAL PARA LA REHABILITACIÓN DE FALTAS ADMINISTRATIVAS DISCIPLINARIAS": "II CAPACITACIÓN VIRTUAL PARA LA REHABILITACIÓN DE FALTAS ADMINISTRATIVAS DISCIPLINARIAS"] , ["III CAPACITACIÓN VIRTUAL PARA LA REHABILITACIÓN DE FALTAS ADMINISTRATIVAS DISCIPLINARIAS": "III CAPACITACIÓN VIRTUAL PARA LA REHABILITACIÓN DE FALTAS ADMINISTRATIVAS DISCIPLINARIAS"] , ...17 more... )
• grupotr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Grupo de participación, type: esriFieldTypeString , Coded Values: [Primer grupo: Primer grupo] , [Segundo grupo: Segundo grupo] , [Tercer grupo: Tercer grupo] , ...1 more... )
• cedula_sp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cédula, type: esriFieldTypeString )
• grado_sp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Grado, type: esriFieldTypeString )
• apellidos_nomb_sp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Apellidos y nombres, type: esriFieldTypeString )
• sexo_sp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Sexo, type: esriFieldTypeString )
• unidad_sp ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Unidad, type: esriFieldTypeString )
• unidad_servicio ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Servicio Policial, type: esriFieldTypeString )
• eje ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Eje, type: esriFieldTypeString )
• nacimiento ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Fecha de nacimiento, type: esriFieldTypeString )
• estado ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Estado del Servidor Policial dentro del taller, type: esriFieldTypeString , Coded Values: [Aprobado: Aprobado] , [No aprobado: No aprobado] , [No participo: No participo] , ...1 more... )
• falta ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Tipo de falta cometida, type: esriFieldTypeString , Coded Values: [FALTA LEVE: FALTA LEVE] , [FALTA GRAVE: FALTA GRAVE] )
• th ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Informe Talento Humano, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• certificacion ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Certificación de no haber sido sancionado, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• certificacion1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Certificado taller, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• capacitacion ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Certificado capacitación, type: esriFieldTypeString , Coded Values: [N/A: N/A] )
• certificacion2 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Certificado de no poseer rehabilitación de faltas, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• tiempo ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Tiempo que presenta solicitud máximo 6 meses, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• dnth ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Informe DNTH, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• informe ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Informe T.H. (2-3 años), type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• sancion ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cumplimiento sanción (Causado estado), type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• proceder ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Enmendado su proceder, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• conducta ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Mantener conducta intachable, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• reha ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Rehabilitación, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• fecha2 ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Fecha de delegación, type: esriFieldTypeDate )
• fecha3 ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Fecha de entrega de informe (max 5 días), type: esriFieldTypeDate )
• nota ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Analista que realiza el informe, type: esriFieldTypeString )
• cedula_sp1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Cédula, type: esriFieldTypeString )
• grado_sp1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Grado, type: esriFieldTypeString )
• apellidos_nomb_sp1 ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Apellidos y nombres, type: esriFieldTypeString )
• notificacion ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Notificación al Serv. Pol. Rehabilitado, type: esriFieldTypeString , Coded Values: [SI: SI] , [NO: NO] )
• resolu ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Estado de la resolución señor IGEN, type: esriFieldTypeString , Coded Values: [ACEPTA: ACEPTA] , [NO ACEPTA: NO ACEPTA] )
• 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:

• Rehabilitacion_de_Faltas_database (0) -- Related To: Rehabilitacion_de_Faltas (0)

Capabilities: Create,Editing,Uploads,Sync

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   Query Bins   Apply Edits   Add Features   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata