FTE_Monthly_Data

Used for the Forecast Module only, this is an extract of FTE’s by month for the current population of fee earners and administrative staff for loading of the actual to be used in the forecast to compare against the budget.

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 FTE Decimal 10, 4 Yes
8 Headcount Integer   No

 

Summary

FTE_Monthly_Data

Used as the core source for loading the FTE fact table and the Xchange monthly FTE cube in Planning.

Columns

 

Year

Year associated to 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 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 in PG_DeptRequired.

Title_Code

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

FTE

The numeric FTE value for the employee.  Used to calculate compensation and production FTE for the budget. Required.

Headcount

The numeric Headcount value for the employee; will typically be one if the employee is full-time (or near full-time). Optional.

Documentation

 

Business Rules

These rules govern creation of this table and cover what the column does and how it may be calculated.

Sample CSV Load File

This load file is a small sample of an FTE load.

Sample CSV Load File

This load file is a small sample of an FTE load.

Filename: FTE_Monthly_Data.csv

2008,11,00032,01,030,Partner,1.0,1
2008,11,00075,01,022,Partner,1.0,1
2008,11,00046,01,034,Paralegal,1.0,1
2008,11,00094,01,007,Of Counsel,1.0,1
2008,11,00076,01,050,Of Counsel,1.0,1
2008,11,00084,90,065,Partner,1.0,1
2008,11,00006,90,070,Paralegal,0.0,0

Columns

Year

Year varchar(

4

) NOT NULL

Year associated to 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 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

FTE

FTE decimal(

10,

4

) NOT NULL

The numeric FTE value for the employee.  Used to calculate compensation and production FTE for the budget. Required.

 

 

Field Load File Format
Type Decimal
Maximum Length 10, 4
Required Yes

Headcount

Headcount int NULL

The numeric Headcount value for the employee; will typically be one if the employee is full-time (or near full-time). Optional.

 

 

Field Load File Format
Type Integer
Required No

 

Business Rules

These rules govern creation of this table and cover what the column does and how it may be calculated.

Calculated Columns

Headcount

If FTE > .5 then Headcount is 1 otherwise Headcount is 0.

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk