Administration Guide
Appendix IV - Expense Claim Database CSV Export Report

After a set of expense claim records have been exported as a database export (csv) file, the file can be imported into another application or database via the appropriate data loading utility (for example, via the Microsoft Access or Sage Accounting data import processes). The exported data is set in a fixed column format, outlined below.

Each line of the CSV export file data provides the information for a distinct expense claim entry. A distinct expense claim entry exists for each entered line of an expense claim.

The expense claim to which a given expense claim entry belongs can be identified by the expense claim Id column included in the flat file output, with the system user related to that expense claim identified by their employee number.

The format of the flat file data, with the first column on the left of a printed line listed as Column 1, is as follows:

Column Data Description
1 Employee Number The employee number of the employee corresponding to the expense claim entry.
2 Username The username registered for the employee.
3 First Name The first name of the employee.
4 Last Name The last name of the employee.
5 Expense Claim Id The uniquely identifying expense claim Id assigned by Senomix to the expense claim record.
6 Vendor Name The name of the vendor noted for the expense claim, or the text "<< NONE >>" if no vendor was indicated.
7 Claim Date The date provided for the full expense claim. This date is presented in the form "DD-MM-YYYY HH:MM:SS", with the hours, minutes and seconds all set to 0.
8 Approved Flag A boolean value indicating whether or not the expense claim has been approved or disapproved. If this flag is false and the approved user is blank, then the expense claim is still pending approval.
9 Approved User The employee no. of the user which approved or disapproved the expense claim. If this value is blank, the expense claim is still pending approval.
10 Approved Date The date and time on which the expense claim was either approved or disapproved. If the approved user is blank, the expense claim has not yet been approved and this field will be blank.
11 Project Code The project code corresponding to the expense claim entry.
12 Project Name The project billing code name of the entry.
13 Activity Code The activity code corresponding to the expense claim entry. If no activity was indicated for the entry, this value will be blank.
14 Activity Name The activity billing code name corresponding to the expense claim entry. If no activity was indicated for the entry, this value will be blank.
15 Task Code The task code corresponding to the expense claim entry. If no task was indicated for the entry, this value will be blank.
16 Task Name The task billing code name corresponding to the expense claim entry. If no task was indicated for the entry, this value will be blank.
17 Expense Type The expense type noted for the expense claim entry, or the text "<< NONE >>" if no expense type was indicated.
18 Entry Date The Date provided for the Expense Claim entry. This date is presented in the form "DD-MM-YYYY HH:MM:SS", with the hours, minutes and seconds all set to 0.
19 Amount The currency amount of the expense claim entry.
20 Details The text details provided for the expense claim entry.
21 Billable Status An integer value indicating whether the Expense Claim entry is for a billable or non-billable item. The int values for that billable status are as follows:

0 Non-billable item
1 Billable item