Grade Rate Changes with time and location
Content
Hi,
I have the following requirements and am looking for a way to achieve it. Please let me know if there are any suggestions.
| 
			 Job  | 
			
			 Software Developer  | 
		
| 
			 Grade  | 
			
			 Grade Software Engineer  | 
		
| 
			 Position  | 
			
			 Java Developer-Location A  | 
			
			 
  | 
			
			 
  | 
		|
| 
			 
  | 
			
			 
  | 
			
			 Changes due to scale increase  | 
			
			 
  | 
		|
| 
			  ---> Eff. Date  | 
			
			 2019-01-01  | 
			
			 2019-07-01  | 
			
			 2019-11-01  | 
			
			 
  | 
		
| 
			 Step 1  | 
			
			 15.00  | 
			
			 15.30  | 
			
			 16.80  | 
			
			 
  | 
		
| 
			 Step 2 , 6mths  | 
			
			 15.50  | 
			
			 15.80  | 
			
			 17.20  | 
			
			 
  | 
		
| 
			 Step 3, 1 yr  | 
			
			 16.00  | 
			
			 16.32  | 
			
			 17.90  | 
			
			 
  | 
		
Java Developer at Location A - joins on 1/1/2019 at $15; progresses at 6 months to Step 2; scale rate has changed due to market, so now at $15.80; moves to $17.20 on 1/11/2019 due to scale rate change; at 1 year, 1/1/2020, moves to 17.90
| 
			 Java Developer -Location B  | 
			
			 
  | 
			
			 
  | 
			
			 
  | 
		
| 
			 Changes due to scale increase  | 
            Tagged:
            
        
1