| Name / Description | Type / Format | Example | |
|---|---|---|---|
name
Name of the Pay Spine
|
string
|
"string"
|
|
fullTimeHours
Maximum Full Time Hours on this Pay Spine
|
number
double
|
0.0
|
|
fullTimeWeeks
Maximum Full Time Weeks on this Pay Spine
|
number
double
|
0.0
|
|
salaryFormula
Formula used to derive annual salary
The salary formula is consisting of the following elements and Round functions: - PointValue (The value of an individual Spinal Point) - HoursWorked (The hours an employee is contracted to work for on their role) - FTHours (The full time hours specified for an employee on their role) - WeeksWorked (The contracted weeks an employee works on their role) - FTWeeks (The full weeks specified for an employee on their role) Round functions: - ROUND(Value,decimal places): Round the value to a specific decimal places. The maximum value is between 0 and 15, max. - ROUNDUP(Value) - ROUNDDOWN(Value) - TRUNCATE(Value) For example: "PointValue * ROUND(HoursWorked * WeeksWorked * (7/365),3) / FTHours" |
string
|
"string"
|
|
hourlyDivisor
Hours used to determine Hourly Rate
|
number
double
|
0.0
|
|
hourlyDecimals
Number of decimal places to calculate Hourly Rates
|
integer
int32
|
0
|
|
dailyDivisor
Days used to determine Full time Daily Rate
|
number
double
|
0.0
|
|
dailyDecimals
Number of decimal places to calculate Daily Rates
|
integer
int32
|
0
|
|
annualDecimals
Number of decimal places to calculate Annual Salaries
|
integer
int32
|
0
|
|
annualRoundingRule
|
string
|
"RoundOff"
"Exact"
"RoundUp"
"RoundDown"
|
|
incrementRule
|
string
|
"Manual"
"Annual"
"April"
"April6m"
|
|
requiresLondonAllowance
Requires LA column to be completed on the spine
|
boolean
|
true
|
|
gradeEffectiveDate
Effective date for applicable grades
|
string
date
|
"2024-04-27"
|
|
pointEffectiveDate
Effective date for applicable spinal points
|
string
date
|
"2024-04-27"
|
{
"name": "string",
"fullTimeHours": 0.0,
"fullTimeWeeks": 0.0,
"salaryFormula": "string",
"hourlyDivisor": 0.0,
"hourlyDecimals": 0,
"dailyDivisor": 0.0,
"dailyDecimals": 0,
"annualDecimals": 0,
"annualRoundingRule": "RoundOff",
"incrementRule": "Manual",
"requiresLondonAllowance": true,
"gradeEffectiveDate": "2024-04-27",
"pointEffectiveDate": "2024-04-27"
}- none -
- none -