Compensation_Monthly_Data

Used for the Forecast Module only, this is an extract from the payroll system to provide compensation data by employee by month.  Compensation Measures include Salary, Overtime, Bonus 1, Bonus 2, Bonus 3 . These are expenses paid by the firm, not withholding amounts, and will need to be specified in building the extract file from the payroll system, configured to meet requirements.  These measures are the items that are typically budgeted in the proCube database that relate to compensation.  The other members in the Budget Compensation cube, such as FICA, FUTA, Medical, etc., are not included here because they are not compensation items.

Idx Field Type Maximum Length Required
1 Year Alphanumeric 4 Yes
2 Period Numeric 2 Yes
3 Employee_Code Alphanumeric 20 Yes
4 Currency_Code Alphanumeric 3 Yes
5 Local_Salary Money   Yes
6 Local_Overtime Money   No
7 Local_Bonus_1 Money   No
8 Local_Bonus_2 Money   No
9 Local_Bonus_3 Money   No
10 Local_Bonus_4 Money   No
11 Base_Salary Money   Yes
12 Base_Overtime Money   No
13 Base_Bonus_1 Money   No
14 Base_Bonus_2 Money   No
15 Base_Bonus_3 Money   No
16 Base_Bonus_4 Money   No

 

Summary

Compensation_Monthly_Data

Extract from the payroll system to provide compensation data by employee by month.

Columns

 

Year

Year associated with the data values.   Required.

Period

Two digit fiscal period number for the period associated to 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_/nnn/_Amount column; must match entry in Currency; this is meant to validate the local amount. Required.

Local Values

 

Local_Salary

Local Salary amount for the period and employee.  Must match currency as specified in Currency_Code. If only single currency use Local. Required.

Local_Overtime

Local Overtime amount for the period and employee.  Must match currency as specified in Currency_Code. If only single currency use Local. Optional.

Local_Bonus_1

Local Bonus 1 amount for the period and employee.  Must match currency as specified in Currency_Code. If only single currency use Local. Optional.

Local_Bonus_2

Local Bonus 2 amount for the period and employee.  Must match currency as specified in Currency_Code. If only single currency use Local. Optional.

Local_Bonus_3

Local Bonus 3 amount for the period and employee.  Must match currency as specified in Currency_Code. If only single currency use Local. Optional.

Local_Bonus_4

Local Bonus 4 amount for the period and employee.  Must match currency as specified in Currency_Code. If only single currency use Local. Optional.

Base Values

 

Base_Salary

Salary in the base (or reporting) currency for the period and employee. Optional.

Base_Overtime

Overtime in the base (or reporting) currency for the period and employee. Optional.

Base_Bonus_1

Bonus 1 in the base (or reporting) currency for the period and employee. Optional.

Base_Bonus_2

Bonus 2 in the base (or reporting) currency for the period and employee. Optional.

Base_Bonus_3

Bonus 3 in the base (or reporting) currency for the period and employee. Optional.

Base_Bonus_4

Bonus 4 in the base (or reporting) currency for the period and employee. Optional.

Sample CSV Load File

This load file is a small sample of a Compensation Monthly Data  load.

Filename: Compensation_Monthly_Data.csv

2007,1,00032,USD,15000.00,0,5000.00,0,0,0,0,0,0,0,0,0

2007,2,00032,USD,17500.00,0,0,0,0,0,0,0,0,0,0,0

2007,3,00032,USD,15000.00,0,0,0,0,0,0,0,0,0,0,0

2007,1,00006,USD,12500.00,500,0,0,0,0,0,0,0,0,0,0

2007,2,00006,USD,14000.00,200,2500.00,0,0,0,0,0,0,0,0,0

2007,3,00006,USD,12500.00,300,0,0,0,0,0,0,0,0,0,0

 

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

Period

Period numeric(

2

) NOT NULL

Two digit fiscal period number for the period associated to the data values.   Required.

 

 

Field Load File Format
Type Numeric
Maximum Length 2
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_/nnn/_Amount 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 Values

Local_Salary

Local_Salary money NOT NULL

Local Salary amount for the period and employee.  Must match currency as specified in Currency_CodeRequired.

 

 

Field Load File Format
Type Money
Required Yes

Local_Overtime

Local_Overtime money NULL

Local Overtime amount for the period and employee.  Must match currency as specified in Currency_CodeOptional.

 

 

Field Load File Format
Type Money
Required No

Local_Bonus_1

Local_Bonus_1 money NULL

Local Bonus 1 amount for the period and employee.  Must match currency as specified in Currency_CodeOptional.

 

 

Field Load File Format
Type Money
Required No

Local_Bonus_2

Local_Bonus_2 money NULL

Local Bonus 2 amount for the period and employee.  Must match currency as specified in Currency_CodeOptional.

 

 

Field Load File Format
Type Money
Required No

Local_Bonus_3

Local_Bonus_3 money NULL

Local Bonus 3 amount for the period and employee.  Must match currency as specified in Currency_CodeOptional.

 

 

Field Load File Format
Type Money
Required No

Local_Bonus_4

Local_Bonus_4 money NULL

Local Bonus 4 amount for the period and employee.  Must match currency as specified in Currency_CodeOptional.

 

 

Field Load File Format
Type Money
Required No

 

Base Values

Base_Salary

Base_Salary money NOT NULL

Salary in the base (or reporting) currency for the period and employee. Required.

 

 

Field Load File Format
Type Money
Required Yes

Base_Overtime

Base_Overtime money NULL

Overtime in the base (or reporting) currency for the period and employee. Optional.

 

 

Field Load File Format
Type Money
Required No

Base_Bonus_1

Base_Bonus_1 money NULL

Bonus 1 in the base (or reporting) currency for the period and employee. Optional.

 

 

Field Load File Format
Type Money
Required No

Base_Bonus_2

Base_Bonus_2 money NULL

Bonus 2 in the base (or reporting) currency for the period and employee. Optional.

 

 

Field Load File Format
Type Money
Required No

Base_Bonus_3

Base_Bonus_3 money NULL

Bonus 3 in the base (or reporting) currency for the period and employee. Optional.

 

 

Field Load File Format
Type Money
Required No

Base_Bonus_4

Base_Bonus_4 money NULL

Bonus 4 in the base (or reporting) currency for the period and employee. Optional.

 

 

Field Load File Format
Type Money
Required No

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk