In 2019, Cornerstone will remove the option to load Compensation data via the Data Load Wizard (DLW). The exact timing of this is yet to be determined but will be announced in advance to give clients time to plan.
- To load Compensation data, clients will need to use the new Edge Import Employee Salary Load tool which was made available in the August '18 Release to clients with Compensation or Cornerstone HR and Data Load Wizard (DLW).
The options that are available vary, depending on which type of compensation data is being loaded:
Employee Salary Processing Options
The following processing options are available for employee salary data:
Dates are in International (dd/mm/yyyy or dd-mm-yyyy) format
Select this option if the dates within the file are in International format. This allows the system to properly read and interpret the date values when loading them into the system. Many date formats are supported in both American and International versions. Consult the Helpful Hints documents for a full list.
If file is error free, automatically load into system
Select this option to automatically load the data into the system if the data within the uploaded file is error free. The data within the file is still validated during the validation step. But, if there are no formatting or system compatibility errors, you will not have the option to perform a final review before the data is loaded.
Blank values should overwrite existing data
Select this option if you want a blank value in the load file to overwrite an existing value within the system. For example, a user record (John Smith) has an email address set in the system (jsmith@email.com), but the email value in the file is blank. If this option is selected, the blank value within the file overwrites the email value set in the system. If this option is not selected, the blank value within the file does not overwrite the email value in the system and John Smith's email address is not affected.
Note: If the field is a required field, the value cannot be blank within the file.
Do not allow relationships with inactive Users and OUs
Select this option to prevent OUs and users from being associated with inactive OUs or users. This can be used to ensure organizations have a functioning hierarchy between OUs and users. If users and OUs are connected with inactive users or OUs, this may cause breakdowns in system communication such as approvals and reviews.
Individual Targets Processing Options
The following processing options are available for individual targets data:
Dates are in International (dd/mm/yyyy or dd-mm-yyyy) format
Select this option if the dates within the file are in International format. This allows the system to properly read and interpret the date values when loading them into the system. Many date formats are supported in both American and International versions. Consult the Helpful Hints documents for a full list.
If file is error free, automatically load into system
Select this option to automatically load the data into the system if the data within the uploaded file is error free. The data within the file is still validated during the validation step. But, if there are no formatting or system compatibility errors, you will not have the option to perform a final review before the data is loaded.
Do not allow relationships with inactive Users and OUs
Select this option to prevent OUs and users from being associated with inactive OUs or users. This can be used to ensure organizations have a functioning hierarchy between OUs and users. If users and OUs are connected with inactive users or OUs, this may cause breakdowns in system communication such as approvals and reviews.
Salary Structure Processing Options
The following processing options are available for salary structure data:
If file is error free, automatically load into system
Select this option to automatically load the data into the system if the data within the uploaded file is error free. The data within the file is still validated during the validation step. But, if there are no formatting or system compatibility errors, you will not have the option to perform a final review before the data is loaded.
Blank values should overwrite existing data
Select this option if you want a blank value in the load file to overwrite an existing value within the system. For example, a user record (John Smith) has an email address set in the system (jsmith@email.com), but the email value in the file is blank. If this option is selected, the blank value within the file overwrites the email value set in the system. If this option is not selected, the blank value within the file does not overwrite the email value in the system and John Smith's email address is not affected.
This setting does not apply to Secondary OU values. Also, this setting does not apply to unmapped fields.
Note: If the field is a required field, the value cannot be blank within the file.
Do not allow relationships with inactive Users and OUs
Select this option to prevent OUs and users from being associated with inactive OUs or users. This can be used to ensure organizations have a functioning hierarchy between OUs and users. If users and OUs are connected with inactive users or OUs, this may cause breakdowns in system communication such as approvals and reviews.
After selecting the appropriate options, click to proceed to the Validate step. See Load Compensation Data - Step 6 - Validate.