Interpreter Manual Item Import Mapping Fields

Candidate ID

Number that uniquely identifies a candidate, as configured on a candidate record in Recruitment Manager.

Integer (9 characters exactly)

Candidate Alt No

Alternative candidate number or code that is used by the client to reference a candidate, as configured in the candidate record properties in Recruitment Manager.

Alphanumeric (maximum 50 characters)

Candidate Firstname

Given name of a candidate, as configured on a candidate record in Recruitment Manager.

Alphanumeric (maximum 50 characters)

Candidate Surname

Family name of a candidate, as configured on a candidate record in Recruitment Manager.

Alphanumeric (maximum 50 characters)

Candidate Full Name (formatted CandidateSurname CandidateFirstname)*

Full name of a candidate in the format <surname> <first name>.

For example: Smith John

Alphanumeric (maximum 101 characters)

Candidate Full Name (formatted CandidateFirstname CandidateSurname)*

Full name of a candidate in the format <first name> <surname>.

For example: John Smith

Alphanumeric (maximum 101 characters)

Client No

Number that uniquely identifies a client, as defined in a client record in Recruitment Manager.

Integer (9 characters exactly)

Client Alternate No

Alternative client number or code that the client uses to identify themselves, as configured in the client record properties in Recruitment Manager.

Alphanumeric (maximum 50 characters)

Cost Centre Code

Code that identifies a client cost centre (site), as defined in a Cost Centre record in Recruitment Manager.

Alphanumeric (maximum 50 characters)

Cost Centre Name

Name of a client cost centre (site), as defined on a Cost Centre record in Recruitment Manager.

Alphanumeric (maximum 50 characters)

Cost Centre No

 System-generated, nine-digit number that uniquely identifies a client cost centre (site), as defined in a Cost Centre record in Recruitment Manager.

Integer (9 characters exactly)

Job Alt No

Alternative job order number that is used by the client to reference a job order, as configured in the job order record properties in Recruitment Manager.

Alphanumeric (maximum 50 characters)

Job ID

Unique job number that identifies a specific job order record in Recruitment Manager.

Integer (9 characters exactly)

Purchase Order No

Unique number or code that identifies a purchase order number, as assigned to a job order record in Recruitment Manager.

Alphanumeric (maximum 50 characters)

Timesheet ID

The ID of the timesheet that the manual item is to be applied to. This is a system generated value that is assigned to a timesheet.

Numeric

Timesheet Week Ending Date

Date on which the week ending date of a timesheet falls.

Date (format: dd/mm/yyyy)

Timesheet Week Starting Date

Date on which the week starting date of a timesheet falls.

Date (format: dd/mm/yyyy)

Manual Item Date

Date of the manual item, must intersect with the related interpreted timesheet’s Start Date and End Date period.

Mandatory

Date (format: dd/mm/yyyy)

Pay Code Import Code

Import code that is assigned to a pay code, as configured in the pay code record header in Rates and Rules. This can be used to identify manual/additional timesheet items.

Mandatory where Pay Code Name is not supplied.

Note that this field needs to be used to identify additional items rather than the Pay Code Name - must relate to an active Pay Code for the Timesheet’s Country.

Alphanumeric (maximum 50 characters)

Pay Code Name

Unique name that identifies a pay code, as configured in the pay code header in Rates and Rules. This can be used to identify manual/additional timesheet items.

• Mandatory

• Must be an active Pay Code for the Timesheet’s Country.

Note that this field needs to be used to identify additional items rather than the Pay Code Import Code field

Alphanumeric (maximum 50 characters)

Pay Quantity

Quantity that applies to an additional pay (manual) timesheet item.

• Mandatory

• Cannot be null (but can be zero).  Both + & - values are accepted.

Numeric (maximum 38,6)

Reimbursement Net Value

The net value that applies where the related manual item Pay Code is of type ‘Reimbursement’.

• Mandatory where Pay Code is of type ‘Reimbursement’.

• Cannot be null (but can be zero).

Numeric (maximum 38,6)

Reimbursement GST/VAT Value

The GST/VAT/Tax component value that applies where the related manual item Pay Code is of type ‘Reimbursement’.

• Mandatory where Pay Code is of type ‘Reimbursement’.

• Cannot be null (but can be zero).

Numeric (maximum 38,6)

Pay Rate

Where the manual item is not of type ‘Reimbursement’ a pay rate value is required.

• Mandatory

• Can have a value of zero.  Both + & - values are accepted.

Numeric (maximum 38,6)

Bill Code Import Code

Import code that is assigned to a bill code, as configured in the bill code record header in Rates and Rules. This can be used to identify manual/additional timesheet items.

Mandatory where Bill Code Name is not supplied.

Note that this field needs to be used to identify additional items rather than the Bill Code Name - must relate to an active Bill Code for the Timesheet’s Country.

Alphanumeric (maximum 50 characters)

Bill Code Name

Unique name that identifies a bill code, as configured in the pay code header in Rates and Rules. This can be used to identify manual/additional timesheet items.

• Mandatory

• Must be an active Bill Code for the Timesheet’s Country.

Note that this field needs to be used to identify additional items rather than the Bill Code Import Code field

Alphanumeric (maximum 50 characters)

Bill Quantity

Quantity that applies to an additional bill (manual) timesheet item.

• Mandatory

• Cannot be null OR zero.  Both + & - values are accepted.

Numeric (maximum 38,6)

Bill Rate

The rate that is changed to the client for the manual item.

• Mandatory. 

• Can have a value of zero. Both + & - values are accepted.

Numeric (maximum 38,6)

Project Code

If the timesheet’s related job order is set to enforce project code, then a valid project code is required.

Alphanumeric (maximum 50)