{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 5,
 "name": "bdgc.sdp.registro_social",
 "type": "Table",
 "description": "",
 "copyrightText": "",
 "editFieldsInfo": null,
 "ownershipBasedAccessControlForFeatures": null,
 "syncCanReturnChanges": false,
 "relationships": [],
 "isDataVersioned": false,
 "isDataArchived": false,
 "infoInEstimates": [
  "count"
 ],
 "isDataBranchVersioned": false,
 "isDataReplicaTracked": false,
 "isCoGoEnabled": false,
 "supportsRollbackOnFailureParameter": true,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportsValidateSQL": true,
 "supportsCoordinatesQuantization": false,
 "supportsCalculate": true,
 "supportsASyncCalculate": true,
 "advancedQueryCapabilities": {
  "supportsPagination": true,
  "supportsTrueCurve": true,
  "supportsQueryWithDistance": true,
  "supportsReturningQueryExtent": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsQueryWithResultType": true,
  "supportsReturningGeometryCentroid": false,
  "supportsSqlExpression": true,
  "supportsLod": false,
  "supportsQueryWithLodSR": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": false
 },
 "advancedEditingCapabilities": {
  "supportedSqlFormatsInCalculate": [
   "standard"
  ],
  "supportsAsyncApplyEdits": true
 },
 "hasMetadata": false,
 "hasAttachments": false,
 "supportsApplyEditsWithGlobalIds": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "objectIdField": "objectid",
 "globalIdField": "",
 "displayField": "id_hogar",
 "typeIdField": "",
 "subtypeField": "",
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null,
   "editable": false,
   "nullable": false,
   "defaultValue": null,
   "modelName": "objectid"
  },
  {
   "name": "id_hogar",
   "type": "esriFieldTypeString",
   "alias": "ID Hogar",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "id_hogar"
  },
  {
   "name": "pnombre",
   "type": "esriFieldTypeString",
   "alias": "Primer nombre",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "pnombre"
  },
  {
   "name": "snombre",
   "type": "esriFieldTypeString",
   "alias": "Segundo nombre",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "snombre"
  },
  {
   "name": "papellido",
   "type": "esriFieldTypeString",
   "alias": "Primer apellido",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "papellido"
  },
  {
   "name": "sapellido",
   "type": "esriFieldTypeString",
   "alias": "Segundo apellido",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 100,
   "defaultValue": null,
   "modelName": "sapellido"
  },
  {
   "name": "sexo",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Sexo",
   "domain": {
    "type": "codedValue",
    "name": "d_rs_genero",
    "description": "Dominio de genero definido por la SDP para registro social",
    "codedValues": [
     {
      "name": "Hombre",
      "code": 1
     },
     {
      "name": "Mujer",
      "code": 2
     },
     {
      "name": "No responde",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "sexo"
  },
  {
   "name": "tipo_documento",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Tipo de documento",
   "domain": {
    "type": "codedValue",
    "name": "d_rs_tipo_identificacion",
    "description": "Dominio de tipo de identificacion definido por la SDP para el registro social",
    "codedValues": [
     {
      "name": "Cedula de ciudadania",
      "code": 1
     },
     {
      "name": "Tarjeta de identidad",
      "code": 2
     },
     {
      "name": "Cedula de extranjeria",
      "code": 3
     },
     {
      "name": "Registro civil",
      "code": 4
     },
     {
      "name": "DNI (pais origen)",
      "code": 5
     },
     {
      "name": "Pasaporte",
      "code": 6
     },
     {
      "name": "Salvoconducto para refugiados",
      "code": 7
     },
     {
      "name": "Permiso especial del permanencia PEP",
      "code": 8
     },
     {
      "name": "Permiso para proteccion temporal PPT",
      "code": 9
     },
     {
      "name": "Sin informacion",
      "code": 99
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "tipo_documento"
  },
  {
   "name": "id_beneficiario",
   "type": "esriFieldTypeString",
   "alias": "Identificación del beneficiario",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "id_beneficiario"
  },
  {
   "name": "fnacimiento",
   "type": "esriFieldTypeDate",
   "alias": "Fecha de nacimiento",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "fnacimiento"
  },
  {
   "name": "direccion",
   "type": "esriFieldTypeString",
   "alias": "Dirección de la vivienda",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 150,
   "defaultValue": null,
   "modelName": "direccion"
  },
  {
   "name": "resolucion_asignacion",
   "type": "esriFieldTypeString",
   "alias": "Resolución de asignación",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "resolucion_asignacion"
  },
  {
   "name": "año_resolucion",
   "type": "esriFieldTypeString",
   "alias": "Año de la resolución",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 4,
   "defaultValue": null,
   "modelName": "año_resolucion"
  },
  {
   "name": "fecha_resolucion",
   "type": "esriFieldTypeDate",
   "alias": "Fecha de la resolución",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 8,
   "defaultValue": null,
   "modelName": "fecha_resolucion"
  },
  {
   "name": "estado_proceso",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Estado del proceso",
   "domain": {
    "type": "codedValue",
    "name": "d_rs_estado_proceso",
    "description": "Dominio de estado de avance del proceso del hogar, generado por SDP para el registro social",
    "codedValues": [
     {
      "name": "Asignacion - Asignado",
      "code": 1
     },
     {
      "name": "Asignacion \u2013 Renuncia",
      "code": 2
     },
     {
      "name": "Asignacion \u2013 Perdida",
      "code": 3
     },
     {
      "name": "Asignacion \u2013 Revocado",
      "code": 4
     },
     {
      "name": "Asignacion - Vencido",
      "code": 5
     },
     {
      "name": "Asignacion - Desvinculación",
      "code": 6
     },
     {
      "name": "Asignacion - En Ejecucion",
      "code": 7
     },
     {
      "name": "Asignacion - Terminado",
      "code": 8
     },
     {
      "name": "Asignacion - Entregado a satisfaccion",
      "code": 9
     },
     {
      "name": "Desembolso \u2013 Legalizado",
      "code": 10
     },
     {
      "name": "Desembolso - Desembolso Total",
      "code": 11
     },
     {
      "name": "Desembolso - Reintegrado",
      "code": 12
     },
     {
      "name": "Desembolso - Pendiente Reintegro",
      "code": 13
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "estado_proceso"
  },
  {
   "name": "valor_subsidio",
   "type": "esriFieldTypeDouble",
   "alias": "Valor del subsidio",
   "domain": null,
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "valor_subsidio"
  },
  {
   "name": "parentesco",
   "type": "esriFieldTypeString",
   "alias": "Parentesco con el jefe de hogar",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "parentesco"
  },
  {
   "name": "tipo_solucion",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Tipo de solución",
   "domain": {
    "type": "codedValue",
    "name": "d_rs_tipo_solucion",
    "description": "Dominio del tipo de solucion de vivienda creado por SDP para el registro social",
    "codedValues": [
     {
      "name": "VIS",
      "code": 1
     },
     {
      "name": "VIP",
      "code": 2
     },
     {
      "name": "No aplica",
      "code": 3
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "tipo_solucion"
  },
  {
   "name": "loc_destino",
   "type": "esriFieldTypeString",
   "alias": "Localidad destino",
   "domain": {
    "type": "codedValue",
    "name": "d_loccodigo",
    "description": "Dominio Localidad",
    "codedValues": [
     {
      "name": "Usaquén",
      "code": "01"
     },
     {
      "name": "Chapinero",
      "code": "02"
     },
     {
      "name": "Santa Fe",
      "code": "03"
     },
     {
      "name": "San Cristóbal",
      "code": "04"
     },
     {
      "name": "Usme",
      "code": "05"
     },
     {
      "name": "Tunjuelito",
      "code": "06"
     },
     {
      "name": "Bosa",
      "code": "07"
     },
     {
      "name": "Kennedy",
      "code": "08"
     },
     {
      "name": "Fontibón",
      "code": "09"
     },
     {
      "name": "Engativá",
      "code": "10"
     },
     {
      "name": "Suba",
      "code": "11"
     },
     {
      "name": "Barrios Unidos",
      "code": "12"
     },
     {
      "name": "Teusaquillo",
      "code": "13"
     },
     {
      "name": "Los Mártires",
      "code": "14"
     },
     {
      "name": "Antonio Nariño",
      "code": "15"
     },
     {
      "name": "Puente Aranda",
      "code": "16"
     },
     {
      "name": "La Candelaria",
      "code": "17"
     },
     {
      "name": "Rafael Uribe Uribe",
      "code": "18"
     },
     {
      "name": "Ciudad Bolívar",
      "code": "19"
     },
     {
      "name": "Sumapaz",
      "code": "20"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 2,
   "defaultValue": null,
   "modelName": "loc_destino"
  },
  {
   "name": "loc_origen",
   "type": "esriFieldTypeString",
   "alias": "Localidad origen",
   "domain": {
    "type": "codedValue",
    "name": "d_loccodigo",
    "description": "Dominio Localidad",
    "codedValues": [
     {
      "name": "Usaquén",
      "code": "01"
     },
     {
      "name": "Chapinero",
      "code": "02"
     },
     {
      "name": "Santa Fe",
      "code": "03"
     },
     {
      "name": "San Cristóbal",
      "code": "04"
     },
     {
      "name": "Usme",
      "code": "05"
     },
     {
      "name": "Tunjuelito",
      "code": "06"
     },
     {
      "name": "Bosa",
      "code": "07"
     },
     {
      "name": "Kennedy",
      "code": "08"
     },
     {
      "name": "Fontibón",
      "code": "09"
     },
     {
      "name": "Engativá",
      "code": "10"
     },
     {
      "name": "Suba",
      "code": "11"
     },
     {
      "name": "Barrios Unidos",
      "code": "12"
     },
     {
      "name": "Teusaquillo",
      "code": "13"
     },
     {
      "name": "Los Mártires",
      "code": "14"
     },
     {
      "name": "Antonio Nariño",
      "code": "15"
     },
     {
      "name": "Puente Aranda",
      "code": "16"
     },
     {
      "name": "La Candelaria",
      "code": "17"
     },
     {
      "name": "Rafael Uribe Uribe",
      "code": "18"
     },
     {
      "name": "Ciudad Bolívar",
      "code": "19"
     },
     {
      "name": "Sumapaz",
      "code": "20"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "length": 2,
   "defaultValue": null,
   "modelName": "loc_origen"
  },
  {
   "name": "programa",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Programa",
   "domain": {
    "type": "codedValue",
    "name": "d_rs_programa",
    "description": "Dominio de programa definido por SDP para el registro social",
    "codedValues": [
     {
      "name": "Reactiva Tu Compra, Reactiva Tu Hogar",
      "code": 1
     },
     {
      "name": "Mi Casa Ya",
      "code": 2
     },
     {
      "name": "Oferta Preferente",
      "code": 3
     },
     {
      "name": "Mi ahorro, Mi hogar",
      "code": 4
     },
     {
      "name": "Mejoramiento de vivienda - Habitabilidad",
      "code": 5
     },
     {
      "name": "Mejoramiento de vivienda Rural - Habitabilidad",
      "code": 6
     },
     {
      "name": "Mejoramiento de vivienda Rural - Vivienda nueva",
      "code": 7
     },
     {
      "name": "Vivienda progresiva",
      "code": 8
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "programa"
  },
  {
   "name": "responsable",
   "type": "esriFieldTypeInteger",
   "alias": "Responsable SDHT",
   "domain": {
    "type": "codedValue",
    "name": "d_responsable_sdht",
    "description": "Dominio Responsable SDHT",
    "codedValues": [
     {
      "name": "Subdirección de Información Sectorial",
      "code": 100000
     },
     {
      "name": "Subdirección de Gestión del Suelo",
      "code": 100010
     },
     {
      "name": "Subdirección de Servicios Públicos",
      "code": 100020
     },
     {
      "name": "Subdirección de Recursos Públicos y Privados",
      "code": 100030
     },
     {
      "name": "Subdirección de Apoyo a la Construcción",
      "code": 100040
     },
     {
      "name": "Subdirección de Barrios",
      "code": 100050
     },
     {
      "name": "Subdirección de Operaciones",
      "code": 100070
     },
     {
      "name": "Subdirección de Participación y Relaciones con la Comunidad",
      "code": 100080
     },
     {
      "name": "Subdirección Prevención y Seguimiento",
      "code": 100090
     },
     {
      "name": "Subdirección de Investigaciones y Control de Vivienda",
      "code": 100100
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   },
   "editable": true,
   "nullable": true,
   "defaultValue": null,
   "modelName": "reponsable"
  },
  {
   "name": "chip",
   "type": "esriFieldTypeString",
   "alias": "chip",
   "domain": null,
   "editable": true,
   "nullable": true,
   "length": 50,
   "defaultValue": null,
   "modelName": "chip"
  }
 ],
 "indexes": [
  {
   "name": "r1898_sde_rowid_uk",
   "fields": "objectid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "datesInUnknownTimezone": false,
 "dateFieldsTimeReference": {
  "timeZone": "UTC",
  "respectsDaylightSaving": false
 },
 "preferredTimeReference": null,
 "types": [],
 "templates": [
  {
   "name": "bdgc.sdp.registro_social",
   "description": "",
   "prototype": {
    "attributes": {
     "responsable": null,
     "chip": null,
     "id_hogar": null,
     "pnombre": null,
     "snombre": null,
     "papellido": null,
     "sapellido": null,
     "sexo": null,
     "tipo_documento": null,
     "id_beneficiario": null,
     "fnacimiento": null,
     "direccion": null,
     "resolucion_asignacion": null,
     "año_resolucion": null,
     "fecha_resolucion": null,
     "estado_proceso": null,
     "valor_subsidio": null,
     "parentesco": null,
     "tipo_solucion": null,
     "loc_destino": null,
     "loc_origen": null,
     "programa": null
    }
   },
   "drawingTool": "esriFeatureEditToolNone"
  }
 ],
 "maxRecordCount": 1000,
 "supportedQueryFormats": "JSON, geoJSON, PBF",
 "supportedExportFormats": "sqlite,filegdb",
 "capabilities": "Query,Extract",
 "useStandardizedQueries": true,
 "standardMaxRecordCount": 32000,
 "tileMaxRecordCount": 1000,
 "maxRecordCountFactor": 1,
 "serviceItemId": "952b3a84ea72457586a75d6d410807c3"
}