Revenue_Monthly_Data

 

Used for Forecast Module only, this is an extract of the time and billing system and contains actual data for the worked hours and worked values by working timekeeper, office, and department.

 
Idx Field Type Maximum Length Required
1 Year Alphanumeric 4 Yes
2 Period Numeric 2 Yes
3 Employee_Code Alphanumeric 20 Yes
4 Office_Code Alphanumeric 20 Yes
5 PG_Dept_Code Alphanumeric 20 Yes
6 Title_Code Alphanumeric 50 Yes
7 Currency_Code Alphanumeric 3 Yes
8 Local_Hours_Worked Numeric 19,4 Yes
9 Local_Amount_Worked Money   Yes
10 Base_Hours_Worked Numeric 19,4 No
11 Base_Amount_Worked Money   No

 

Summary

Revenue_Monthly_Data

The data source for the worked hours and value by timekeeper derived from the time and billing system.

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.

Office_Code

Office code associated to the employee and FTE value; must match entry in OfficeRequired.

PG_Dept_Code

Practice Group / Department code associated to the employee and the FTE Value; must match entry inPG_DeptRequired.

Title_Code

Title code associated to the employee and FTE value; must match entry in TitleRequired.

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_Hours_Worked

Worked (Billable) Hours for a Timekeeper associated with the Local_Amount_Worked.  Used to determine Rate:Local_Amount_Worked / Local_Hours_WorkedRequired.

Local_Amount_Worked

Local Amount worked for a timekeeper based on Local_Hours_Worked.  Must match currency as specified inCurrency_CodeRequired.

Base Values

 

Base_Hours_Worked

Worked (Billable) Hours for a Timekeeper associated with the Base_Amount_Worked.  Used to determine Rate:Base_Amount_Worked / Base_Hours_WorkedOptional.

Base_Amount_Worked

Base Amount worked for a timekeeper based on Base_Hours_Worked.  Must match currency as specified inCurrency_CodeOptional.

Sample CSV Load File

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

Filename: Compensation_Monthly_Data.csv

2009,1,00032,10,120,ASOCCIATE,USD,168,53760.00,0,0

2009,2,00032,10,120,ASOCCIATE,USD,154,49280.00,0,0

2009,3,00032,10,120,ASOCCIATE,USD,173,55360.00,0,0

2009,1,00006,12,150,PARTNER,USD,138,62100.00,0,0

2009,2,00006,12,150,PARTNER,USD,144,66200.00,0,0

2009,3,00006,12,150,PARTNER,USD,123,55250.00,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

Office_Code

Office_Code varchar(

20

) NOT NULL

Office code associated to the employee and FTE value; must match entry in OfficeRequired.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 20
Required Yes

PG_Dept_Code

PG_Dept_Code varchar(

20

) NOT NULL

Practice Group / Department code associated to the employee and the FTE Value; must match entry in PG_DeptRequired.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 20
Required Yes

Title_Code

Title_Code varchar(

50

) NOT NULL

Title code associated to the employee and FTE value; must match entry in TitleRequired.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 50
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_Hours_Worked

Local_Hours_Worked numeric(

19,

4

) NOT NULL

Worked (Billable) Hours for a Timekeeper associated with the Local_Amount_Worked.  Used to determine Rate: Local_Amount_Worked / Local_Hours_WorkedRequired.

 

 

Field Load File Format
Type Numeric
Maximum Length 19, 4
Required Yes

Local_Amount_Worked

Local_Amount_Worked money NOT NULL

Local Amount worked for a timekeeper based on Local_Hours_Worked.  Must match currency as specified in Currency_CodeRequired.

 

 

Field Load File Format
Type Money
Required Yes

Base Values

Base_Hours_Worked

Base_Hours_Worked numeric(

19,

4

) NULL

Worked (Billable) Hours for a Timekeeper associated with the Base_Amount_Worked.  Used to determine Rate: Base_Amount_Worked / Base_Hours_WorkedOptional.

 

 

Field Load File Format
Type Numeric
Maximum Length 19, 4
Required No

Base_Amount_Worked

Base_Amount_Worked money NULL

Base Amount worked for a timekeeper based on Base_Hours_Worked.  Must match currency as specified in Currency_CodeOptional.

 

 

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