[ https://issues.apache.org/jira/browse/OFBIZ-3825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12881651#action_12881651 ]
Swapnil Sawant commented on OFBIZ-3825: --------------------------------------- Hi BJ, At first, we will be starting with basic implementation and then will advance to higher level of implementation for this proposal. Taking this and your suggestions into consideration, we have following flow : - New term types will be added into DB for leaves e.g. sick leave term type, casual leave term type(Agreements tab) - Total number of leaves for each of term type will be mentioned under 'term value' field on 'Agreement Term' tab. - These term types will correspond to SICK_LEAVE and CASUAL_LEAVE benefits applicable for that employee. - When an agreement is selected during employment of an employee, corresponding 'term value' will be getting credited to Party Benefit table for that particular employee. - Hence, 'term values' mentioned in selected agreement will be inserted into 'Party Benefit' table for SICK_LEAVE and CASUAL_LEAVE benefits for that employee - Then we will have one to one mapping between 'leave reason type'and 'benefit type' - Using this mapping, whenever an employee applies for leave,based on leave reason type we would find out corresponding benefit ype and hence proceed with validations related to 'available time' and actual balance for that benefit (from party benefit table) > Proposal for adding new functionality in Leave sub tab under HR module > ---------------------------------------------------------------------- > > Key: OFBIZ-3825 > URL: https://issues.apache.org/jira/browse/OFBIZ-3825 > Project: OFBiz > Issue Type: Improvement > Components: humanres > Affects Versions: SVN trunk > Environment: Windows XP, JDK 1.6 > Reporter: Swapnil Sawant > Priority: Minor > Fix For: SVN trunk > > Original Estimate: 72h > Remaining Estimate: 72h > > I wish to do some enhancement in existing Leave functionality taking Party > benefits into consideration in OFBiz. > Existing functionalities : > - Currently employee can create leave by selecting his > approver. > - Approver will approve the leave applied by the > employee. > > New functionality : > - Admin party will credit leaves at the beginning of a financial year > for employees > - These leaves can be taken by employee under available benefits from > Party Benefit > - Party Benefits will be setup for each employee as per existing flow > - Whenever employee creates leave application, his/her benefits will be > checked for validation purpose(relation will be set between leave > reason type and benefit type) along with exclusion of weekend and > organization wide holidays. > - On leave approval, corresponding number of leaves would be deducted > from employee's leave account. > > For implementing this, following modifications are being > thought of : > - Adding foreign key column 'benefitTypeId' in 'EmplLeaveReasonType' > (reference from > benefitType.benefitTypeId) > By maintaining this relation, each time employee creates a leave > application (with some leave reason type Id),we can keep track of > 'availableTime' for this particular employee/party-benefitType combination > - We can have CreditEmplLeave,EmplLeave and Holiday tables as mention > in the below thread > http://ofbiz.135035.n4.nabble.com/Proposal-for-adding-new-functionality-in-Leave-sub-tab-under-HR-module-td2250139.html#a2250139 > Following is a demo flow of above mentioned functionality : > 1.Admin credits leaves for an employee. > 2.Employee applies for leave for first time with leave reason type as > 'Medical' (for time being lets assume 'Sick Leave' is benefit type for > this leave reason type in 'EmplLeaveReasonType' table) > 3.Before creating leave application, we would check following two > things : > - If that employee has enough leave balance > - If employee has not crossed 'availableTime' threshold for > benefit type 'Sick Leave'(using Party Benefits already setup through other > existing screen) > 4.After leave application is created, approver can > approve/reject it > 5.Corresponding updations will be made in 'EmplLeave'(changing status > to approve/rejected) and CreditEmplLeave tables(deduction if approved) > Thanks & Regards, > Swapnil Sawant -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.