Document toolboxDocument toolbox

This article is for Budgets for Data Center.

Staff Members CSV Export

Following grid show all budget fields that are exported and description of their contents.
Note the grid order may differ from the actual export file column order

FOLIO Field

Import Notes

FOLIO Field

Import Notes

Category

The category (always "SALARY")

Type

The role of the staff member

Description

The description for the staff member

Reporter

The reporter of the data

Start date

The start date of the worked hours period or the date on which the wage is effective.

End date

 The end date of the worked hours period.

Wage

The wage of the staff member (hourly rate).

Availability

The availability ratio (%) of the staff member.

Worked Hours

The hours worked in the period defined by the start date and end date.

Custom fields

The value for a specific custom field.

 

Note

Export will generate for a member :

  • one row per wages and/or availability.

  • one row per worked hours

  • no row will be generated for "computed worked hours"

 

"Category","Type","Name","Member","Description","Reporter","Wage","Availability","Worked Hours","Start date","End date"
"SALARY","Administration","admin","admin","Project Manager","admin","45.00","100.0000","","2013/09/02",""
"SALARY","Administration","admin","admin","Project Manager","admin","33.00","50.0000","","2013/11/05",""
"SALARY","Administration","admin","admin","Project Manager","admin","","","35.00","2013/12/01","2013/12/07"
"SALARY","Designers Web","Unassigned","unassigned","Designer Web senior","admin","50.00","100.0000","","2013/09/02",""

 

 

 

Related pages:

Â