Agreed on the following design on 29/11/2016 Alvis/Sanjay

1. Add ID column to leave allocation table and use this as the primary key - Completed
2. Add index for CompanyID, EmployeeID, LeaveType, ForYear, void - Completed
3. Add service history tab to employee maintenance and review screen size - Completed
   1. Menu 321 
      
   2. Menu 421
4. Add business rules to start date change - Completed
   1. Start date can be changed when there is no active leave allocation
5. Powerbuilder changes to handle 1. above - Completed
   1. Leave allocation screen - show active allocations
   2. leave transaction screen - show transactions for active allocations 
   3. Leave transaction processing - show transactions for active allocations 
   4. Leave lookup screen - shows leaves that for active allocations 
   5. Leave Balance History screen - shows active allocations
   6. Leave Balance History detail button - show transactions for active allocations 
6. SQL Procedure changes to handle 1. above - Completed

   1. dbo.LT_PAY_GetLeaveAccrued_fx	scalar function
      dbo.LT_PAY_GetLeaveAdjustmentAccrual_fx	scalar function
      dbo.LT_PAY_GetLeaveAdjustmentBFWD_fx	scalar function
      dbo.LT_PAY_GetLeaveAdjustmentTaken_fx	scalar function
      LT_ESS_TimesheetImport_GetTotalHoursConsecutiveDays_fx	scalar function
      LT_ESS_TimesheetImport_HasWorkedConsecutiveDays_fx	scalar function
      LT_HRM_CheckLeaveHasBalance	scalar function
      LT_HRM_GetLeaveTransactionTotal_fx	scalar function
      LT_PAY_GetLeaveAvailableBalanceAsAt_fx	scalar function
      LT_PAY_GetLeaveTaken_fx	scalar function
      LT_PAY_GetTotalHoursConsecutiveDays_fx	scalar function
      LT_PAY_HasPaidLeaveOnDay_fx	scalar function
      dbo.LT_ESS_LeaveAdjustments_APPROVE	stored procedure
      dbo.LT_ESS_TimeEntry_Process	stored procedure
      dbo.LT_HRM_LEAVE_ACCRUAL_INSERT	stored procedure
      dbo.LT_HRM_LEAVE_ACCRUAL_UPDATE	stored procedure
      dbo.LT_HRM_UTILITY_LeaveTransactionsRebuild_CreateTransactions	stored procedure
      dbo.LT_HRM_UTILITY_LeaveTransactionsRebuild_DeleteSystemEntries	stored procedure
      dbo.LT_HRM_UTILITY_LeaveTransactionsRebuild_XXXXX	stored procedure
      dbo.LT_HRM_UTILITY_LeaveTransactionsRebuild_LTA	stored procedure
      dbo.LT_HRM_UTILITY_LeaveTransactionsRebuild_Transactions	stored procedure
      dbo.LT_PAY_RPT_LeaveTransaction	stored procedure
      LBS_Alert_EmployeeLeaveStatus_sp	stored procedure
      LT_ESS_BI_LeaveAnalysis	stored procedure
      LT_ESS_CreateLeaveForInvalidTimeEntries	stored procedure
      LT_ESS_GetLeave_Edit	stored procedure
      LT_ESS_GetLeave_Manage	stored procedure
      LT_ESS_GetLeave_View	stored procedure
      LT_ESS_GetLeaveApplications	stored procedure
      LT_ESS_LeaveCalendar_SELECT	stored procedure
      LT_ESS_LeaveDetails_Select	stored procedure
      LT_ESS_RPT_LeaveCalendarViewSubReport	stored procedure
      LT_ESS_RPT_TimesheetImportLog	stored procedure
      LT_ESS_RPT_TimesheetImportLog_LeaveDetails	stored procedure
      LT_ESS_SaveLeaveApplication	stored procedure
      LT_HRM_LEAVE_HIST_PreUpdateValidation	stored procedure
      LT_HRM_LEAVE_HIST_UPDATE	stored procedure
      LT_HRM_LEAVE_ROLLOVER_EndOfYear	stored procedure
      LT_HRM_LEAVE_ROLLOVER_PROCESS	stored procedure
      LT_HRM_LEAVE_UPDATE_SickDaysWithoutNotice	stored procedure
      LT_HRM_LEAVE_UPDATE_SplitLeaveIntoPayPeriod	stored procedure
      LT_HRM_LeaveAccrual	stored procedure
      LT_HRM_LeaveAllocation_DELETE	stored procedure
      LT_HRM_UTILITY_LeaveTransactionsRebuild_CreateTransactions	stored procedure
      LT_HRM_UTILITY_LeaveTransactionsRebuild_Transactions	stored procedure
      LT_LINKSOFT_Attachment_Integrate	stored procedure
      LT_PAY_AddEmployeePay	stored procedure
      LT_PAY_EditRosterSchedule	stored procedure
      LT_PAY_RPT_LeaveTransaction	stored procedure
      LT_PAY_RPT_Timesheet	stored procedure
      RPT_HR_LeaveHistory_sp	stored procedure
      LT_ESS_GetEmployeeCommitments_fx	table function
      LT_HRM_GetLeaveTransactionAge_fx	table function
      dbo.LT_HRM_EMP_LEAVE_INSERT	trigger
      dbo.LT_HRM_LEAVE_TRANSACTIONS_vw	view
      LT_HRM_LEAVE_TRANSACTIONS_vw	view
      LT_HRM_Leave_vw	view

      
      
      
7. Report changes to handle 1. above -  Completed
   1. 448-1-Leave Balance
   2. 448-2-Leave Due
   3. 448-3-Leave History
   4. 448-4-Leave Liability
   5. 448-5-Leave Transaction
   6. 448-6-Employee Leave Analysis
   7. 448-7-Leave Liability Analysis - Detail
   8. 448-8-Leave Liability Analysis - Summary

------------------

When an employee rejoins the organisation, customers are asking for the ability to use the same employee profile. The reason for this is as follows:

1. It is easier to change employee start date as opposed to creating a new employee.
2. Employee history is maintained

Concerns:

1. If we use the same employee profile, any outstanding leave transactions, as well as rebuild utilities, will not work as the start date is a single field in the profile
2. Original start date is lost.
3. Pay transactions will not reconcile with start date.

Option 1:

1: Reinstate employee. Prompt for New employee number, start date, position

Option 2:

Add design for employment service date.

1. Add a new table to store service dates ID, startdate, terminate date, terminate reason
2. Move service details into new tab
3. Add business rules as follows:
   1. To terminate/inactive an employee, all leave balance must be zero
   2. Make the line read only once an employee is terminated.
   3. Check overlapping start and termination date
   4. ??????

   
   

Agreed to build a copy employee feature that will perform the following:

1. Employee code will be same as before with Dash 1 at the end
2. Copy all HR records and employee master file data
3. Link the two employee codes
4. Validate: to be decided later

High level design:

1. We change the service tab to list all the service contracts. 
2. To add a new service contract, the following steps to be done:
   1. Zeroise the current leave balance, this is done by passing adjustment
   2. Terminate the current service. This option will check if leave balance is zero then it will move Leave allocation, accruals and transactions to an archive table tagged with the current service id.
   3. New service can now be added, then allocate new leave

Agreed on the following design on 29/11/2016 Alvis/Sanjay

1. Add ID column to leave allocation table and use this as the primary key
2. Add index for CompanyID, EmployeeID, LeaveType, ForYear, void
3. Add service history tab to employee maintenance and review screen size
   1. Menu 321 
      
   2. Menu 421
4. Add business rules to start date change
5. Start date can be changed when there is no active leave allocation
6. Powerbuilder changes to handle 1. above - Completed
   1. Leave allocation screen - show active allocations
   2. leave transaction screen - show transactions for active allocations 
   3. Leave transaction processing - show transactions for active allocations 
   4. Leave lookup screen - shows leaves that for active allocations 
   5. Leave Balance History screen - shows active allocations
   6. Leave Balance History detail button - show transactions for active allocations 
7. SQL Procedure changes to handle 1. above

1. Report changes to handle 1. above
   1. 448-1-Leave Balance
   2. 448-2-Leave Due
   3. 448-3-Leave History
   4. 448-4-Leave Liability
   5. 448-5-Leave Transaction
   6. 448-6-Employee Leave Analysis
   7. 448-7-Leave Liability Analysis - Detail
   8. 448-8-Leave Liability Analysis - Summary

Completed the following items:

1. Add ID column to leave allocation table and use this as the primary key - Completed
2. Add index for CompanyID, EmployeeID, LeaveType, ForYear, void - Completed
3. Add service history tab to employee maintenance and review screen size - Completed
4. Add business rules to start date change - Completed

1. Powerbuilder changes to handle 1. above - Completed
   1. Leave allocation screen - show active allocations
   2. leave transaction screen - show transactions for active allocations 
   3. Leave transaction processing - show transactions for active allocations 
   4. Leave lookup screen - shows leaves that for active allocations 
   5. Leave Balance History screen - shows active allocations
   6. Leave Balance History detail button - show transactions for active allocations 
2. SQL Procedure changes to handle 1. above - Completed

Meeting Sanjay/Alvis agreed to proceed with comment 13.

Sanjeet and Vineet were not available to attend the meeting.

Tested scenarios

1. Scenario 1 - Employee leaves and returns at a later date
2. Scenario 2 - Employee service changes

Notes:

1. Employee Terminate Date does not have any restrictions as employee can be terminated and pay processed at a later date.
2. When employee is terminated, change the message "Changing the status ..."  replace the word REMOVED to VOID and INACTIVE to INACTIVE/Terminated

Can we make the following changes to Employee Terminate: The current state required 15 + steps to terminate an employee

1. Set the Employee Terminate Date before the pay is processed
2. The system will use this to determine the payout amounts
3. Pay clerk can verify the details in the "Pay edit form"
4. When the pay is updated, the employee status is changed to TERMINATED if the Pay end date is after the TERMINATE Date.

1. Leave Liability Report - Does not filter by Leve From and Leave To
2. Service History - Show by Service date ASC
3. Investigate Pay Edit screen 8 decimal places - look at reducing this to 4DP.
4. Employee Profile - Current Service - Width of Reason