insert into mig_pres_prof_cat
select distinct df.id_comision as catedra,
    df.id_docente as profesor,
    case
        when ad.id_funcion_tipo in (3,7,20, 22,23,25,57)  then 'A'
        when ad.id_funcion_tipo in (4,8,10,11,12,13,14,17,24,28,29,31,33,35,37,38,39,40,41,42,43,44,46,51) then 'P'
        when ad.id_funcion_tipo in (9,15,18,27,36) then 'T'
        else  'P'
    end as tipo,
    ad.id_categoria as cargo,
    ad.carga_horaria as carga_horaria,
    case
        when ad.bnr_viatico = 0 then 1
        else 0
    end as paga_no_remunerativo, --preguntar de donde sale esta informacion
    0 as ctrl_presentismo, --preguntar donde sale esta informacion
    r.numero as ordenanza,
    0 as cant_clases_estimadas
from cargos_funciones.docentes_funciones df
inner join cargos_funciones.comisiones c on df.id_comision = c.id
left outer join cargos_funciones.asignaciones_designaciones ad on ad.id_comision = df.id_comision and ad.id_docente = df.id_docente
left outer join actos_administrativos.resoluciones r on ad.resolucion_funcion_nro::INTEGER=r.id
where df.confirmada = true and c.anio_academico = 2017 and c.id_periodo_academico = 2