Salary

Loads annual salary into the Employee Data fact table and Employee Data cube.  This table is separately maintained as salary information often exists in a source system other than the ERP system.  It also allows the sensitive information to be input in different fashions.  Local annual salary is the defined default and is the only value needed for single currency implementations.  For multi currency implementations, the Base annual salary is optional and used for reporting purposes only.

Idx Field Type Maximum Length Required
1 Year Alphanumeric 4 Yes
2 Employee_Code Alphanumeric 20 Yes
3 Currency_Code Alphanumeric 3 Yes
4 Local_Annual_Salary Money   Yes
5 Base_Annual_Salary Money   No

 

Summary

Salary

Loads annual salary into the Employee Data fact table and Employee Data cube.

Columns

 

Year

Year associated with the data values.   Required.

Employee_Code

Employee code associated to the employee; must match entry in EmployeeRequired.

Currency_Code

Currency code for value in the Local_Annual_Salary column; must match entry in Currency; this is meant to validate the local amount. Required.

Local_Annual_Salary

Current annual salary in the local currency of the office of the employee specified by Currency_CodeRequired.

Base_Annual_Salary

Current annual salary in the base (or reporting) currency. Optional.

Documentation

 

What to Load

Data should be loaded at least for the current planning year.

Currency Implementation

Records must be loaded using a consistent currency theme for either a Single-Currency Implementation or a Multi-Currency Implementation; regardless of the implementation, values are loaded into Local and if desired, converted to Base.

Sample CSV Load File

This load file is a small sample of a Salary load.

Sample CSV Load File

This load file is a small sample of a Salary load.

Filename: Salary.csv

2007,00032,USD,175438.00,
2007,00006,USD,104091.00,
2007,00046,USD,73936.00,
2007,00075,USD,86027.00,
2007,00084,USD,180567.00,
2007,00094,USD,140472.00,
2007,00076,USD,133154.00,

Columns

Year

Year varchar(

4

) NOT NULL

Year associated with the data values.   Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 4
Required Yes

Employee_Code

Employee_Code varchar(

20

) NOT NULL

Employee code associated to the employee; must match entry in EmployeeRequired.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 20
Required Yes

Currency_Code

Currency_Code varchar(

3

) NOT NULL

Currency code for value in the Local_Annual_Salary column; must match entry in Currency; this is meant to validate the local amount. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 3
Required Yes

Local_Annual_Salary

Local_Annual_Salary money NOT NULL

Current annual salary in the local currency of the office of the employee specified by Currency_CodeRequired.

 

 

Field Load File Format
Type Money
Required Yes

Base_Annual_Salary

Base_Annual_Salary money NULL

Current annual salary in the base (or reporting) currency. Optional.

 

 

Field Load File Format
Type Money
Required No

Documentation

What to Load

Data should be loaded at least for the current planning year.  Historical information may also be loaded for reporting purposes.

Salaries for employees that do not appear in this table will be defaulted to 0.

Currency Implementation

Records must be loaded using a consistent currency theme for either a Single-Currency Implementation or a Multi-Currency Implementation; regardless of the implementation, values are loaded into Local and if desired, converted to Base.

Single-Currency Implementation

Only a single currency may appear (and must be the same as the base currency) and all records must have that <Currency_Code>.  Typically for most implementations, base currency will be USD.

If the base amount is not specified, it will be defaulted to the local amount.

Multi-Currency Implementations

The amount is specified in the local currency of the office (the office of the employee).  This amount must also be converted to the base currency.  If the <Currency_Code> is the base currency, any amount not having a base value will be defaulted to the local amount.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk