sql:
select
employee_id x_employee_id,
min(case when payroll_archive.code='contract_bs' then payroll_archive. amount end) x_contract_bs,
min(case when payroll_archive.code='position_allw' then payroll_archive. amount end) x_position_allw,
min(case when payroll_archive.code='addion_allw' then payroll_archive. amount end) x_addion_allw,
min(case when payroll_archive.code='rate' then payroll_archive. amount end) x_rate,
min(case when payroll_archive.code='transportation_allowance' then payroll_archive. amount end) x_transportation_allowance,
min(case when payroll_archive.code='cash_allow' then payroll_archive. amount end) x_cash_allow,
min(case when payroll_archive.code='F_S_P' then payroll_archive. amount end) x_F_S_P,
min(case when payroll_archive.code='cola' then payroll_archive. amount end) x_cola,
min(case when payroll_archive.code='Family_allow' then payroll_archive. amount end) x_Family_allow,
min(case when payroll_archive.code='Child-care_Subsidy' then payroll_archive. amount end) x_Child_care_Subsidy,
min(case when payroll_archive.code='Bonus' then payroll_archive. amount end) x_Bonus,
min(case when payroll_archive.code='hypo_tax_rate' then payroll_archive. amount end) x_hypo_tax_rate,
min(case when payroll_archive.code='rz_bonus' then payroll_archive. amount end) x_rz_bonus,
min(case when payroll_archive.code='zinv_allw' then payroll_archive. amount end) x_zinv_allw,
min(case when payroll_archive.code='One-Child_Allowance' then payroll_archive. amount end) x_one_Child_Allowance
from payroll_archive
left join hr_employee on payroll_archive.employee_id=hr_employee.id
where hr_employee.active=True
and (payroll_archive.effective_date<=current_date and (payroll_archive.expired_date is null or payroll_archive.expired_date>=current_date))
group by payroll_archive.employee_id