Allow Negative G&S Differential for Mercer, ORC & AIRINC compensation calculations
There is a system preference available at both the system and company level that will allow the user to allow a negative Goods and Services Differential amount. When this system preference is turned off, if the ORC G&S Differential calculation result is negative then the amount will be adjusted to 0. When turned on, the amount will not be adjusted. This preference is used by comp worksheets & cost estimates. The default is No.
Importing AIRINC Data
These imports can be accessed from the Company Menu in the Processes section under Import Data.
Once the imports are complete you will see the status change to Processed.
Most AIRINC data can be imported using AirInc File Format 1. If the AIRINC data is provided to be similar to ORC data format, it can be imported via AIR INC Home Norm Data and/or AIR INC Home/Host Data. File extensions will be ".cl". File Format 2 which lists data by Salary Grade is not currently supported by the Equus Platform.
The supported Air Inc. Data tables and calculations are listed below. The First line of each Air Inc. data file includes the Table Name. This table name is required to match one of the values below or the data will not be imported.
Danger Pay
Foreign Service Premium
Host Country Goods and Services Cost
Goods and Services Differential
Home Country Goods and Services Norm (Spendable)
Hardship Allowance
Home Country Hypothetical Income Tax (Fed+State)
Home Country Hypothetical Federal Tax
Host Country Hypothetical Federal Tax
Host Country Housing Cost
Housing Differential
Home Country Housing Norm
Home Country Hypothetical Local/City Tax
Host Country Hypothetical Local/City Tax
Home Country Hypothetical State/Provincial Tax
Host Country Hypothetical State/Provincial Tax
Home Country Hypothetical Social Tax
Host Country Hypothetical Social Tax
Host Country Housing and Utilities Cost
Housing and Utilities Differential
Home Country Housing and Utilities Norm
Lodging Per Diem
Other Per Diem
Host Country Transportation Cost
Transportation Differential
Home Country Transportation Norm
Host Country Utilities Cost
Utilities Differential
Home Country Utilities Norm
FILE OPTION 1 (Most Data):
Data will be provided in one file per table. Lines irrelevant to that table type will be blank. The contents are described with 10 header lines, with the following information:
Line
|
Data
|
Data Type
|
Data Length
|
1
|
Table Name
|
string (varchar)
|
255
|
2
|
Home Location
Can be country name, or Country name followed by a comma (,) followed by more information (such as state or province)
|
string (varchar)
|
50
|
3
|
Host Location
Can be country name, or Country name followed by a comma (,) followed by more information (such as state or province)
|
string (varchar)
|
50
|
4
|
Exchange Rate
|
string (varchar)
|
50
|
5
|
Filing Status (Tax Table Only)
|
string (varchar)
|
3
|
5
|
or HCP (G&S Table only)
|
decimal
|
precision=5; scale=3
|
6
|
Effective Date (MM/DD/YYYY)
|
datetime
|
8
|
7
|
Salary Multiplier
|
int
|
32 bit
|
8
|
Salary Currency ISO
|
string (char)
|
3
|
9
|
Data Multiplier
|
int
|
32 bit
|
10
|
Data Currency ISO
|
string (char)
|
3
|
From line 11 on will be data. A data line will consist of comma-delimited numbers with the following structure:
Position
|
Data
|
Data Type
|
Data Length
|
1
|
"At least" Salary lookup amount
|
int
|
32 bit
|
2
|
"Less than" Salary lookup amount
|
int
|
32 bit
|
3
|
Single amount
|
int
|
32 bit
|
4
|
Married amount
|
int
|
32 bit
|
5
|
M+1 amount
|
int
|
32 bit
|
6
|
M+2 amount
|
int
|
32 bit
|
7
|
M+3 amount
|
int
|
32 bit
|
8
|
M+4 amount
|
int
|
32 bit
|
9
|
M+5 amount
|
int
|
32 bit
|
All salary and data amounts will be in annual numbers.
This file option can also be produced in a concatenated format, one table after the other in one file, with a table delimiter “END OF TABLE” at the end of each table.