Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

OpenERP HR Attendance affect Table [Closed]

By
priyankahdp
on 4/23/13, 1:23 PM 1,021 views

The Question has been closed

by
priyankahdp
on 04/30/2013 10:23:58

I want to know which table used to save records regarding the attendance and leaves in OpenERP ver 7. I found that resource_resource table,res_users and hr_employee tables used to keep employee's records.but which one used to keep above records.?

0

priyankahdp

--priyankahdp--
1089
| 5 5 6
Colombo, Sri Lanka
--priyankahdp--
Java Developer ORACLE Python J2EE Spring Hibernate Struts & Jquery............. :-)
priyankahdp
On 4/23/13, 3:28 PM
select
h.id as employee_id,h.name as leave_reason,
e.resource_id,e.name_related,s.name,r.id as resource,r.name as res_name
from 
hr_holidays h,hr_employee e,hr_holidays_status s,
resource_resource r
where 
h.employee_id=e.id and 
h.holiday_status_id=s.id and
e.resource_id=r.id

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 4/23/13, 1:23 PM
Seen: 1021 times
Last updated: 3/16/15, 8:10 AM