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.
|
Used as the core source for loading the FTE fact table and the Xchange monthly FTE cube in Planning. |
|
|
|
Year associated to the data values. Required. |
|
Two digit fiscal period number for the period associated to the data values. Required. |
|
Employee code associated to the employee; must match entry Employee. Required. |
|
Office code associated to the employee and FTE value; must match entry in Office. Required. |
|
Practice Group / Department code associated to the employee and the FTE Value; must match entry in PG_Dept. Required. |
|
Title code associated to the employee and FTE value; must match entry in Title. Required. |
|
The numeric FTE value for the employee. Used to calculate compensation and production FTE for the budget. Required. |
|
The numeric Headcount value for the employee; will typically be one if the employee is full-time (or near full-time). Optional. |
|
|
|
These rules govern creation of this table and cover what the column does and how it may be calculated. |
|
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
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 |
0 Comments