The Group What-If Cost Estimate (WICE) Import allows you to generate a Group WICE efficiently. Since multiple details are required for each role within the group, using the import can be especially useful for saving and reviewing information before finalizing the Group WICE.
Overview
This is only available at the company level. To use the import, make sure the import should be active. Standard conventions for this sort of import apply, including (but not limited to):
The import will INSERT for each row.
Everything is case insensitive.
A blank column means “do not touch”. It does NOT mean “blank out”
The magic value <BLANK> means “save NULL to this column.”
Blank lines above the header row are skipped without error.
Each row of data is processed in a separate transaction.
If one row errors, execution proceeds to the next row.
Unlike other import types, the Group WICE Import does not require a command action column or a record identifier column.
Upon successful import, a Group Estimate record is created, with each row in the import file generating a new Individual Estimate record. Successfully imported individual WICEs will also appear under My Estimates.
Supported Tables and Fields
WHAT_IF_COST_ESTIMATE
DEPENDENT_COUNT
DEPENDENTS_ACCOMPANYING_ON_ASSIGNMENT
START_DATE
END_DATE
FROM_CITY
FROM_COUNTRY_TAX_ESTIMATOR_ID
FROM_STATE_PROVINCE_TAX_ESTIMATOR_ID
TO_CITY
TO_COUNTRY_TAX_ESTIMATOR_ID
HEADCOUNT
PROJECT_ID
RELOCATION_POLICY_ID
ROLE
SALARY_GRADE
SPOUSE_ACCOMPANYING_ON_ASSIGNMENT
TO_STATE_PROVINCE_TAX_ESTIMATOR_ID
WORK_TIME_IN_HOME_COUNTRY
WORK_TIME_IN_HOST_COUNTRY
COST_ESTIMATE
COST_ESTIMATE!BASE_CURRENCY
COST_ESTIMATE!COST_ESTIMATE_TEMPLATE_ID
DESCRIPTION
INITIAL_BASE_SALARY
HOST_FAMILY_SIZE
MARITAL_STATUS
HOME_FAMILY_SIZE
COST_ESTIMATE_CF
Specific Field Requirements/Sample File
Click here for the sample file, which contains information on optional and required fields on the Group What-If Cost Estimate Import.
Things to Note
ID and lookup fields such as but not limited to RELOCATION_POLICY_ID, TO_COUNTRY_TAX_ESTIMATOR_ID, and MARITAL_STATUS will only accept the corresponding displayed values from the Group WICE Wizard.
Examples of values accepted for the FROM_STATE_PROVINCE_TAX_ESTIMATOR_ID and TO_STATE_PROVINCE_TAX_ESTIMATOR_ID fields:
USA Alabama
Canada Ontario
Canada British Columbia
USA Arizona
USA Colorado
USA Texas
CHE Geneva
CHE Zurich
CHE Berne
Boolean fields such as WHAT_IF_COST_ESTIMATE!SPOUSE_ACCOMPANYING_ON_ASSIGNMENT will only accept the corresponding display values from the Group WICE Wizard.
100 individual records can be imported via the Group WICE Import.
Additional Inputs are also supported in the import. These must be provided at the end of the header row with the field tag name “INPUTS!NAME”
Any name can be provided to each input, as long as it does not match an existing field name from the supported tables
The order of the inputs is important, it must match the order that the inputs are displayed in the WICE screen
Example:
If a WICE has 3 inputs and they are displayed in the WICE Wizard as:
Input A
Input B
Input C
Then a way to set the header columns to submit their values in the Group WICE Import would be:
(…),INPUTS!VALUE_A,INPUTS!VALUE_B,INPUTS!VALUE_C
The values would then be followed to all import rows in the template