Employee Balances CSV Format
Previous Topic  Next Topic 

Employee Balances Fields


Field

Description

Format

Employee

Employee login name. Either this field or Employee ID must be specified when importing.

Text (80 chars max)

Employee ID

Employee ID. Either this field or Employee must be specified when importing.

Text (80 chars max)

Balance

Balance name. Either this field or Balance ID must be specified when importing.

Text (80 chars max)

Balance ID

Balance ID. Either this field or Balance must be specified when importing.

Text (80 chars max)

Date

When importing this is the date the Value or Change should take effect. When exporting this is the current date.

Date

Value

The value of the balance, in hours. When importing the balance will be set to this value as of the specified Date. This field is ignored when importing if Change is specified. When exporting this is the current balance.

Number

Change

The number of hours to add or deduct from the balance for the specified Date. This field overrides any value in the Value field when importing. This field is only applicable when importing.

Number

Comment

A comment about this change. This field is only applicable when importing.

Text (255 chars max)