Employees
This table shows the columns in the import file for the Employees table:
| Column | Description | Type | Size |
|---|---|---|---|
| Member | The dimension member name or ID in the database, such as a unit or a product, used for the Detail Budgeting data (e.g., San Diego or Baseball). | Text | 255 |
| EmpID | The ID of the employee. | Text | 255 |
| Name | The name of the employee. | Text | 255 |
| HeadCount | The employee's or employees' head count. | Integer | 5 |
| Version | (Optional) The Version dimension member for the data. If the version is mentioned in the section head, then the version column is optional. If the Version parameter in the section head is Multiple, then the version column is required. | Integer | 8 |
| SecondAllocation | (Optional) The allocation ID used for the secondary dimension. This ID determines how data is allocated across one or more of the secondary dimension members. | Integer | 8 |
The Employee import file should have only one record for each unique combination of Member and EmpID.
This sample text file could be imported into Detail Budgeting for employees:
[Detail Budgeting]
Version=Budget
Columns=Member,EmpID,Name,Headcount
Administration,0355,John Doe,1
Administration,0355,Frank Smith,2