Loading Employee FTE Information

Does not apply to the Position budget detail

To load employee FTE:

Identify the member and entry names associated with FTE-related Smart Lists. See Frequently Used Public Sector Planning and Budgeting Smart Lists.
Create a file in a tool such as Microsoft Excel. Note: Although you can use a text editor, it is best to use a spreadsheet program to customize the sample code, because some text editors may not maintain the necessary line breaks.

Copy and paste this code into the file:

Budget Item,Data Load Cube Name,Point-of-View,Proposed FTE,FTE Start Date,FTE End Date
<LINEITEM("FTE and Status Assignments")>,HCP,"BegBalance,Local,Unspecified Element,Budget,Stage 1,Entity1,No Year,Employee1,Position1",1,01-01-2010,12-31-2010

In the Point-of-View column, replace Entity1, Employee1, Positon1, Budget, and Stage 1 with the name of the employees for whom you are loading FTEs, their positions, their cost center or department, and the budget stage and version.
Note:
For the Employee budget detail, replace Position with Job Code.
In the second line of code, specify data such as the FTE, the position to apply it, and the dates during which to apply it.
Example: You want to load an FTE of 1, that is effective March 1, 2011 to March 2, 2012 for Derek MacKay holding the Survey Implementation position (survey_2) in the Office of Tourism (dept_tourism), specify:
```
Budget Item,Data Load Cube Name,Point-of-View,Proposed FTE,FTE Start Date,FTE End Date
<LINEITEM("FTE and Status Assignments")>,HCP,"BegBalance,Local,Unspecified Element,Budget,Stage 1,dept_tourism,No Year,""MacKay, Derek"",survey_2",1,03-01-2011,
03-01-2012,
```
Save the file in CSV format.
Perform a test run of the CSV file to ensure that it loads employee FTE is correctly. See Verifying Data Loads and Testing Load Files.
After confirming that the file loads data correctly, run it in the production environment. See Running Load Files .