{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 5,
 "name": "bdgc.sdp.registro_social",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "id_hogar",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "id_hogar",
   "type": "esriFieldTypeString",
   "alias": "ID Hogar",
   "length": 50,
   "domain": null
  },
  {
   "name": "pnombre",
   "type": "esriFieldTypeString",
   "alias": "Primer nombre",
   "length": 100,
   "domain": null
  },
  {
   "name": "snombre",
   "type": "esriFieldTypeString",
   "alias": "Segundo nombre",
   "length": 100,
   "domain": null
  },
  {
   "name": "papellido",
   "type": "esriFieldTypeString",
   "alias": "Primer apellido",
   "length": 100,
   "domain": null
  },
  {
   "name": "sapellido",
   "type": "esriFieldTypeString",
   "alias": "Segundo apellido",
   "length": 100,
   "domain": null
  },
  {
   "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"
   }
  },
  {
   "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"
   }
  },
  {
   "name": "id_beneficiario",
   "type": "esriFieldTypeString",
   "alias": "Identificación del beneficiario",
   "length": 50,
   "domain": null
  },
  {
   "name": "fnacimiento",
   "type": "esriFieldTypeDate",
   "alias": "Fecha de nacimiento",
   "length": 8,
   "domain": null
  },
  {
   "name": "direccion",
   "type": "esriFieldTypeString",
   "alias": "Dirección de la vivienda",
   "length": 150,
   "domain": null
  },
  {
   "name": "resolucion_asignacion",
   "type": "esriFieldTypeString",
   "alias": "Resolución de asignación",
   "length": 50,
   "domain": null
  },
  {
   "name": "año_resolucion",
   "type": "esriFieldTypeString",
   "alias": "Año de la resolución",
   "length": 4,
   "domain": null
  },
  {
   "name": "fecha_resolucion",
   "type": "esriFieldTypeDate",
   "alias": "Fecha de la resolución",
   "length": 8,
   "domain": null
  },
  {
   "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"
   }
  },
  {
   "name": "valor_subsidio",
   "type": "esriFieldTypeDouble",
   "alias": "Valor del subsidio",
   "domain": null
  },
  {
   "name": "parentesco",
   "type": "esriFieldTypeString",
   "alias": "Parentesco con el jefe de hogar",
   "length": 50,
   "domain": null
  },
  {
   "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"
   }
  },
  {
   "name": "loc_destino",
   "type": "esriFieldTypeString",
   "alias": "Localidad destino",
   "length": 2,
   "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"
   }
  },
  {
   "name": "loc_origen",
   "type": "esriFieldTypeString",
   "alias": "Localidad origen",
   "length": 2,
   "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"
   }
  },
  {
   "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"
   }
  },
  {
   "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"
   }
  },
  {
   "name": "chip",
   "type": "esriFieldTypeString",
   "alias": "chip",
   "length": 50,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "r1898_sde_rowid_uk",
   "fields": "objectid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": false
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": false,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "ba72c7c8827a449ba1c0fd1c6c6d0f0d"
}