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 Employee. Required.
Office_Code	Office code associated to the employee and FTE value; must match entry in Office. Required.
PG_Dept_Code	Practice Group / Department code associated to the employee and the FTE Value; must match entry in PG_Dept. Required.
Title_Code	Title code associated to the employee and FTE value; must match entry in Title. Required.
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 Employee. Required.

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 Office. Required.

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_Dept. Required.

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 Title. Required.

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.