SELECT 
  d.nombre, 
  d.apellido1, 
  d.apellido2, 
  d.sexo as genero, 
  un.descrip as unidad, 
  ISNULL(cca.descrip, 'Desconocido') as CA, 
  d.grado_acad as grado, 
  c.descrip as estado, 
  d.cedula as cedula, 
  d.bitnet as email, 
  d.fec_nacimi as nacimiento, 
  p.descrip as pais_nacimiento, 
  pn.descrip as nacionalidad 
From 
  sip.dbo.datos_per d 
  LEFT JOIN sip.dbo.codigos c on c.codigo = d.estado 
  and c.tipo = 4 
  LEFT JOIN sip.dbo.paises p on p.pais = d.pais_nacim 
  LEFT JOIN sip.dbo.paises pn on pn.pais = d.pais_nacio 
  LEFT JOIN sip.dbo.unidades un on un.unidad = d.unidad_base 
  LEFT JOIN sip.dbo.codigos cca on cca.codigo = d.categ_ra 
  and cca.tipo = 3 
WHERE 
  d.cedula = '115070248'

SELECT 
                d.nombre, 
                d.apellido1, 
                d.apellido2, 
                d.sexo as genero, 
                un.descrip as unidad, 
                ISNULL(cca.descrip, 'Desconocido') as CA, 
                d.grado_acad as grado, 
                c.descrip as estado, 
                d.cedula as cedula, 
                d.bitnet as email, 
                d.fec_nacimi as nacimiento, 
                p.descrip as pais_nacimiento, 
                pn.descrip as nacionalidad 
            From 
                sip.dbo.datos_per d 
                LEFT JOIN sip.dbo.codigos c on c.codigo = d.estado and c.tipo = 4
                LEFT JOIN sip.dbo.paises p on p.pais = d.pais_nacim
                LEFT JOIN sip.dbo.paises pn on pn.pais = d.pais_nacio
                LEFT JOIN sip.dbo.unidades un on un.unidad = d.unidad_base
                LEFT JOIN sip.dbo.codigos cca on cca.codigo = d.categ_ra and cca.tipo = 3 
            WHERE 
                d.cedula = '115070248';

SELECT 
  p.descrip as pais, 
  e.descrip as entidad, 
  year(b.fec_inicio) as anio_inicio, 
  year(b.fec_final) as anio_final, 
  b.descrip as descripcion 
FROM 
  sip.dbo.becas b 
  inner join sip.dbo.paises p on p.pais = b.pais 
  inner join sip.dbo.entidades e on e.entidad = b.entidad 
where 
  b.cedula = '115070248'

SELECT p.descrip as pais, e.descrip as entidad, year(b.fec_inicio) as anio_inicio, year(b.fec_final) as anio_final, b.descrip as descripcion FROM sip.dbo.becas b 
                inner join sip.dbo.paises p on p.pais = b.pais
                inner join sip.dbo.entidades e on e.entidad = b.entidad
                where b.cedula = '115070248';

Select 
  CD.descrip AS distincion, 
  year(fecha) as anio, 
  entidades.descrip as entidad, 
  CA.descrip as ambito, 
  distinciones.descrip as descripcion 
From 
  distinciones, 
  entidades, 
  codigos AS CD, 
  codigos AS CA 
where 
  cedula = '115070248' 
  and CD.tipo = 6 
  and CD.codigo = distinciones.distincion 
  and CA.tipo = 7 
  and CA.codigo = distinciones.ambito 
  and entidades.entidad = distinciones.entidad 
order by 
  fecha

Select CD.descrip AS distincion,
					year(fecha) as anio,
					entidades.descrip as entidad, 
					CA.descrip as ambito ,distinciones.descrip as descripcion 
					From distinciones, entidades, codigos AS CD, codigos AS CA
					where cedula = '115070248'
					and CD.tipo = 6 
					and CD.codigo = distinciones.distincion 
					and CA.tipo = 7 
					and CA.codigo = distinciones.ambito 
					and entidades.entidad = distinciones.entidad 
					order by fecha;

Select 
  entidades.descrip as entidad, 
  cast(
    year(fec_inicio) as varchar(04)
  ) as anio_inicio, 
  cast(
    year(fec_final) as varchar(04)
  ) as anio_final, 
  disciplinas.descrip as disciplina, 
  codigos.descrip as titulo 
From 
  estudios, 
  Disciplinas, 
  entidades, 
  codigos 
where 
  cedula = '115070248' 
  and Disciplinas.Disciplina = estudios.Disciplina 
  and entidades.entidad = estudios.universidad 
  and codigos.codigo = estudios.titulo 
  and codigos.tipo = 8 
order by 
  fec_inicio

Select entidades.descrip as entidad, 
					cast(year(fec_inicio)as varchar(04)) as anio_inicio, 
					cast(year(fec_final)as varchar(04)) as anio_final, 
					disciplinas.descrip as disciplina, codigos.descrip as titulo 
					 From estudios, Disciplinas, entidades, codigos 
					 where cedula = '115070248'
					 and Disciplinas.Disciplina = estudios.Disciplina 
					 and entidades.entidad = estudios.universidad 
					 and codigos.codigo = estudios.titulo 
					 and codigos.tipo = 8 
					 order by fec_inicio;

select 
  paises.descrip AS pais, 
  cast(
    year(fecha) as varchar(04)
  ) as anio, 
  partic_activa, 
  CF.descrip as funcion, 
  reuniones.descrip as capacitacion 
From 
  reuniones, 
  paises, 
  codigos AS CR, 
  codigos AS CA, 
  codigos AS CF 
where 
  cedula = '115070248' 
  and CR.tipo = 11 
  and CR.codigo = reuniones.reunion 
  and CF.tipo = 10 
  and CF.codigo = reuniones.funcion 
  and CA.tipo = 7 
  and CA.codigo = reuniones.ambito 
  and paises.pais = reuniones.pais 
order by 
  fecha

select paises.descrip AS pais,
				   cast(year(fecha)as varchar(04)) as anio, 
				   partic_activa,CF.descrip as funcion,
				   reuniones.descrip as capacitacion
				   From reuniones,paises,codigos AS CR, codigos AS CA, codigos AS CF
				   where cedula = '115070248'
				   and CR.tipo = 11 
				   and CR.codigo = reuniones.reunion 
				   and CF.tipo = 10 
				   and CF.codigo = reuniones.funcion 
				   and CA.tipo = 7 
				   and CA.codigo = reuniones.ambito 
				   and paises.pais = reuniones.pais 
				   order by fecha;

SELECT 
  DISTINCT codigo_proyecto as codigo, 
  nombre_proyecto as nombre, 
  nombre_unidad_base as unidad, 
  pri.codigo_unidad_responsable_vi as unidad_c, 
  estado_proyecto as estado, 
  c.codigo as cestado 
FROM 
  sip.dbo.Proyectos_Investigadores pri 
  join sip.dbo.codigos c on pri.estado_proyecto = c.descrip 
  and c.tipo = 12 
where 
  cedula_empleado = '115070248' 
  and (
    c.codigo = 7 
    or c.codigo = 4 
    or c.codigo = 3
  ) 
order by 
  codigo_proyecto desc

SELECT DISTINCT codigo_proyecto as codigo
                                ,nombre_proyecto as nombre
                                ,nombre_unidad_base as unidad
				,pri.codigo_unidad_responsable_vi as unidad_c                           
                                ,estado_proyecto as estado
                                ,c.codigo as cestado
                FROM sip.dbo.Proyectos_Investigadores pri join sip.dbo.codigos c on pri.estado_proyecto = c.descrip and c.tipo = 12 
                where cedula_empleado = '115070248' and (c.codigo = 7 or c.codigo = 4 or c.codigo = 3)  order by codigo_proyecto desc;

select 
  EP.descrip as estado, 
  EP.codigo as codigo 
From 
  sip.dbo.codigos as EP 
where 
  EP.tipo = 12 
  and (
    EP.codigo = 7 
    or EP.codigo = 4 
    or EP.codigo = 3
  )

select EP.descrip as estado, EP.codigo as codigo From sip.dbo.codigos as EP where EP.tipo = 12 and (EP.codigo = 7 or EP.codigo = 4 or EP.codigo = 3) ;