Argntina

Liberty Mutual |
Argentina Extract Requirements |
|

Liberty Mutual02/21/2011 |

Table of Contents
Executive Summary 1
This Project 1
Extract Details 1
Extract Frequently Asked Questions 1
Q1. Which employees should show up in this extract? 1
Q2. How often should this extract be generated? 1
Q3. Should I include historical records about my employees? 1
Q4. How longafter an employee leaves the company should I continue to include them in the extract? 1
Q5. What should my columns be named? 1
Q6. I don’t have an N-Number, how do I upload my file? 1
Formatting Specifications 1
Filename 1
File Type 1
Column Delimiter 1
Data Column Order 1
Data Column Naming 1
Reporting Logic 1
Appendix A: Column Definitions 1
Employee ID 1
Last Name 1First Name 1
E-Mail 1
Birthdate 1
Start Date 1
End Date 1
Termination Code 1
Termination Reason 1
Org. Detail 1 Code 1
Org. Detail 1 Description 1
Org. Detail 2 Code 1
Org. Detail 2 Description 1
Org. Detail 3 Code 1
Org. Detail 3 Description 1
Org. Detail 4 Code 1
Org. Detail 4 Description 1
Employee Type Code 1
Employee Type Description 1
Employee Status Code 1Employee Status Description 1
Status Effective Start Date 1
Status Effective End Date 1
Job Code 1
Job Description 1
Salary 1
Bonus 1
Performance Rating 1
Performance Rating Date 1
Manager ID 1
Manager Name 1
Direct Reports 1
Salary Actual 1
Bonus actual 1
Appendix B: Additional Notes and Action Items 1

Executive Summary
This Project
The purpose of this project isto consolidate human resources data from all Liberty Mutual owned, international operations. To accomplish this task a weekly data extract will be collected from each country operation. To make automation of the import possible, the extract must be in a standardized format.
Extract Details
Extract Frequently Asked Questions
Q1. Which employees should show up in this extract?
A. Allemployees who do not have a termination date earlier than February 1st 2011. Include the same employees who are included in current headcount reporting process.
Q2. How often should this extract be generated?
A. An extract should be generated every Friday between the hours of 2:00pm and 4:00pm local time.
Q3. Should I include historical records about my employees?
A. No. One record containingcurrent status per employee is sufficient.
Q4. How long after an employee leaves the company should I continue to include them in the extract?
A. You should continue to send information on an employee for 12 months after the termination date.
Q5. What should my columns be named?
A. Each column in the extract should include a header that contains the name of that item in your sourcesystem. Please see the Data Column Naming section for more information.
Q6. I don’t have an N-Number, how do I upload my file?
If you do not have an N-Number, please follow the procedure to request and N-Number then follow the method given in
Salary Actual
This field should contain employee’s actual paid salary for the period in local currency
Bonus actual
A. This field should contain acumulative YTD total from January 1st for key bonus payments for the pay period in local currency.
Formatting Specifications
Filename
The filename should consist of the following format: “OCSSDDMMYYYY.FFF”. To break this down into sections we have:
OC = Operation Code
SS = Country Stamp
DD = Day
MM = Month
YYYY = Year
FFF = File Type. For more information on this topic, please see the nextsection: File Type.
The operation code and country stamp can be picked from the following table:
Table [ 1 ]: Operation Code and Country Stamp
Country Name | Operation Code | Country Stamp |
Venezuela | 01 | VE |
Brazil | 02 | BR |
Colombia | 03 | CO |
Argentina | 04 | AR |
Chile | 05 | CL |
Spain | 06 | ES |
Portugal | 07 | PT |
Poland | 08 | PL |
Turkey | 09 | TR |...