I Will Create Serial Number by Employee Number Concatenation Year YYYY,For Every Employee to

When Create New Transaction Auto Generating Serial Number by Employee number and When Termination Year and begin new year 01-01-YYYY Create new Serial For All Employee

Note :-

3 Categories

Serial_number-Employee_Number-YYYY

1- Serial_number:Auto Generate For Every Employee when Create New Transaction : Max(Serial_number) For Every Employee and When Start new Year YYYY Create Start From new Serial Number Regenerating Numbers .
2- Employee_Number : read Employee number From Data Base.
3- YYYY : Read Format Year By sysdate : And When start Year new Auto Generate For All Employees (Serial_Number) ...