Page Comparison

ExportType

Displays a value of 1 to indicate that the file contains pay agreement rates or 7 to indicate that the file contains job order pay agreement rates.

This is used by the system to determine the type of rates that are being updated when the file is imported into FastTrack360.

Do not edit or delete this column.

OfficeCode

Identifies the office code and office name of the agency office to which pay agreement rates are assigned.

This column is only included in the file if the export type is 7.

ClientNo

Identifies the nine-digit ID that uniquely identifies the client who owns the job order to which pay agreement rates are assigned.

This column is only included in the file if the export type is 7.

ClientName

Identifies the name of the client who owns the job order to which pay agreement rates are assigned.

This column is only included in the file if the export type is 7.

ParentClientNo

Identifies the nine-digit ID that uniquely identifies the parent client who is linked to the job order to which the pay agreement rates are assigned.

This column is only included in the file if the export type is 7.

ParentClientName

Identifies the name of the parent client who is linked to the job order to which pay agreement rates are assigned.

This column is only included in the file if the export type is 7.

JobOrderNumber

Identifies the nine-digit ID that uniquely identifies the job order to which pay agreement rates are assigned.

This column is only included in the file if the export type is 7.

PayAgreementName

Identifies the name of the pay agreement.

PayAgreementCountry

Identifies the country of the pay agreement.

AgreementValidityStart

Identifies the date on which the pay agreement becomes valid.

AgreementValidityEnd

Identifies the date on which the pay agreement ceases to be valid.

RateRuleName

Identifies the name of the pay rate rule.

LastTimesheetEndDate

Identifies the end date of the last timesheet that has been processed against the corresponding pay agreement.

Note that this is accurate as of the time when the export file is created. If more timesheets are processed after the file is exported, the actual last timesheet end date for the corresponding pay agreement could be later than what is shown in this column.

ValidityStartDate

Identifies the date on which the pay rate rule became effective.

ValidityEndDate

Identifies the date on which the pay rate rule ceases to be effective. Alternatively, this column is blank if the corresponding pay rate rule is effective indefinitely.

Note that rates belonging to a rate rule that is already end-dated cannot be updated via Bulk Rate Update. Such rows will be written to the exception file when you import the updated file to bulk update rates (for more information, see Validation Errors & Exceptions).

RateHierarchyType

Identifies the rate hierarchy level of the exported pay rate rule.

For example, a value of State indicates the corresponding pay rate rule is defined at the state level of the agreement hierarchy.

RateHierarchyValue

Identifies the rate hierarchy value of the exported pay rate rule.

For example, a value of Victoria indicates the corresponding pay rate rule is defined at the state level of the agreement hierarchy and applies specifically to the state of Victoria.

HierarchyGroup

Identifies the rate hierarchy group of the exported pay rate rule.

PayCodeName

Identifies the name of the pay code that is defined on the exported pay rate rule.

PayBillRateRuleId

ID that is used by FastTrack360 to uniquely identify the pay rate rule to which each row in the export file corresponds.

This is used to match each row in the file to an existing pay agreement and pay rate rule when the file is imported into FastTrack360 to bulk update rates.

Do not edit or delete this column.

PayBillRateRuleSubRuleId

ID that is used by FastTrack360 to uniquely identify the sub-rate on a pay rate rule to which each row in the export file corresponds.

This is used to match each row in the file to an existing sub-rate on a pay rate rule when the file is imported into FastTrack360 to bulk update rates.

Do not edit or delete this column.

IsCalculationOnly

Identifies if the exported pay rate rule is flagged as Calculation Only.

This column displays Yes if the corresponding pay rate rule is flagged as Calculation Only, in which case a pay rate description cannot be keyed in the NewRateDescription column.

IsTopUpRate

Identifies if the Top Up Rates option is enabled on the exported pay rate rule, thereby indicating that the pay rate rule tops up the rate specified by another pay rate rule.

This column displays Yes if the exported pay rate rule defines a top up rate, in which case a rate minimum cannot be keyed in the NewRateMinimum field.

RateType

Identifies the pay rate type that applies to the exported rate. This is one of the following:

• Flat Rate

• Calculation

• Direct Valuation

• Payee Rate

ConditionalVariable

Identifies the name of the conditional variable that applies to the exported rate.

ConditionalVariableValue

Identifies the conditional variable value that applies to the exported rate.

CalculationPayCode

If the rate type of the exported rate is Calculation, this column identifies the name of the pay code based on which the final rate is calculated.

CalculationOperator

If the rate type of the exported rate is Calculation, this column identifies the mathematical operation that results in the final rate.

This is one of the following:

• Plus

• Minus

• Multiple

• Percent

• Divide

Rate

Identifies the rate value of the exported rate for the exported validity period. Alternatively, if the exported rate has a rate type of Calculation, this value represents the pay value and not the final rate.

This column is blank if the corresponding sub-rate has a rate type of Direct Valuation or Payee Rate.

RateMinimum

Identifies the absolute minimum value to which the rate value can be edited on a job order without breaching the minimum rate allowable by the award or industrial instrument to which the corresponding pay agreement corresponds. This column is blank if the Rate Minimum Value field on the corresponding agreement pay rate rule does not contain a value.

RateDescription

Identifies the rate description for the exported rate, if defined.

*NewValidityStartDate

Identifies the date on which the rate update is to become effective.

You must key a date in this column for each row in the file before the file can be imported into FastTrack360 to bulk update rates.

Note that the following conditions apply to the date that you key in this column:

• it must be defined in the format dd/mm/yyy (e.g. 01/01/2018)

• it must fall after the current validity start date of the corresponding pay rate rule, as shown in the

• ValidityStartDate column

• it must fall after the current validity end date of the corresponding pay rate rule, if defined, as shown in the ValidityEndDate column

• it must fall after the last timesheet end date for the corresponding pay agreement, as shown in the

• LastTimesheetEndDate column

• it must be the same date as the date specified in the NewValidityStartDate column for all other sub-rates in the file that belong to the same pay rate rule.

*NewRate

Identifies the pay rate that will apply for the new validity period. Alternatively, if the exported rate has a rate type of Calculation, this defines the pay value for the new validity period.

This defaults to the current pay rate, unless the corresponding rate type is Direct Valuation or Payee Rate, in which case this column is blank by default.

If this column is defaulted to the current pay rate, you can leave the default value as is, if the rate is to remain unchanged for the new rate validity period, or you can update the rate as necessary (rate value must be a decimal with a maximum of 6 decimal places). However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the rate type is not Direct Valuation or Payee Rate.

If this column is blank by default, which indicates that the pay rate type of the corresponding sub-rate is

Direct Valuation or Payee Rate, this column must remain blank.

*NewRateMinimum

Identifies the rate minimum that will apply for the new validity period.

If a sub-rate has a rate minimum value for the exported validity period, this field will default to the existing rate minimum value. However, this can be updated or deleted if necessary (must be a decimal with a maximum of 6 decimal places).

If a sub-rate does not have a rate minimum for the exported period, a rate minimum value can be keyed in this column to apply a rate minimum value for the new validity period except where the IsTopUpRate

column is set to Yes, in which case this column must remain blank because a rate minimum cannot be defined for top-up rates.

*NewRateDescription

Identifies the pay rate description that will apply for the new validity period.

If a sub-rate has a pay rate description for the exported validity period, this field will default to the existing pay rate description. However, this can be updated or deleted if necessary.

The new rate description can be a maximum of 60 characters.

This column must remain blank for all rows in the import file that correspond to a Calculation Only pay rate rule (i.e. where the IsCalculationOnly column displays a value of Yes).

• ValidityStartDate column

• it must fall after the current validity end date of the corresponding pay rate rule, if defined, as shown in the ValidityEndDate column

• it must be the same date as the date specified in the NewValidityStartDate column for all other sub-rates in the file that belong to the same pay rate rule.

*NewRate

Identifies the pay rate that will apply for the new validity period. Alternatively, if the exported rate has a rate type of Calculation, this defines the pay value for the new validity period.

This defaults to the current pay rate, unless the corresponding rate type is Direct Valuation or Payee Rate, in which case this column is blank by default.

If this column is defaulted to the current pay rate, you can leave the default value as is, if the rate is to remain unchanged for the new rate validity period, or you can update the rate as necessary (rate value must be a decimal with a maximum of 6 decimal places). However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the rate type is not Direct Valuation or Payee Rate.

If this column is blank by default, which indicates that the pay rate type of the corresponding sub-rate is

Direct Valuation or Payee Rate, this column must remain blank.

*NewRateMinimum

Identifies the rate minimum that will apply for the new validity period.
If a sub-rate has a rate minimum value for the exported validity period, this field will default to the existing rate minimum value. However, this can be updated or deleted if necessary (rate value must be a decimal with a maximum of 6 decimal places).
If a sub-rate does not have a rate minimum for the exported period, a rate minimum value can be keyed in this column to apply a rate minimum value for the new validity period except where the IsTopUpRate column is set to Yes, in which case this column must remain blank because a rate minimum cannot be defined for top-up rates.

*NewRateDescription

Identifies the pay rate description that will apply to the exported rate for the new validity period.

If a sub-rate has a pay rate description for the exported validity period, this field will default to the existing pay rate description. However, this can be updated or deleted if necessary.

The new rate description can be a maximum of 60 characters.

This column must remain blank for all rows in the import file that correspond to a Calculation Only pay rate rule (i.e. where the IsCalculationOnly column displays a value of Yes).

Column

Description

ExportType

Displays a value of 3 to indicate that the file contains bill agreement rates or 8 to indicate that the file contains job order bill agreement rates.

This is used by the system to determine the type of rates that are being updated when the file is imported into FastTrack360.

Do not edit or delete this column.

OfficeCode

Identifies the office code and office name of the agency office to which pay agreement rates are assigned.

This column is only included in the file if the export type is 8.

ClientNo

Identifies the nine-digit ID that uniquely identifies the client who owns the job order to which bill agreement rates are assigned.

This column is only included in the file if the export type is 8.

ClientName

Identifies the name of the client who owns the job order to which bill agreement rates are assigned.

This column is only included in the file if the export type is 8.

ParentClientNo

Identifies the nine-digit ID that uniquely identifies the parent client who is linked to the job order to which pay agreement rates are assigned.

This column is only included in the file if the export type is 8.

ParentClientName

Identifies the name of the parent client who is linked to the job order to which pay agreement rates are assigned.

This column is only included in the file if the export type is 8.

JobOrderNumber

Identifies the nine-digit ID that uniquely identifies the job order to which pay agreement rates are assigned.

This column is only included in the file if the export type is 8.

BillAgreementName

Identifies the name of the bill agreement.

BillAgreementCountry

Identifies the country to which the bill agreement belongs.

AgreementValidityStart

Identifies the date on which the bill agreement becomes effective.

AgreementValidityEnd

Identifies the date on which the bill agreement ceases to be effective.

RateRuleName

Identifies the name of the exported bill rate rule.

LastTimesheetEndDate

Identifies the end date of the last timesheet that has been processed against the bill agreement.

Note that this is accurate as of the time when the export file is created. If more timesheets are processed after the file is exported, the actual last timesheet end date for the corresponding bill agreement could be later than what is shown in this column.

ValidityStartDate

Identifies the date on which the exported bill rate rule became effective.

ValidityEndDate

Identifies the date on which the exported bill rate rule ceases to be effective. Alternatively, this column is blank if the corresponding bill rate rule is effective indefinitely.

Note that rates belonging to a rate rule that is already end-dated cannot be updated via Bulk Rate Update. Such rows will be written to the exception file when you import the updated file to bulk update rates (for more information, see Validation Errors & Exceptions).

RateHierarchyType

Identifies the rate hierarchy level of the exported bill rate rule.

For example, a value of State indicates the corresponding bill rate rule is defined at the state level of the agreement hierarchy.

RateHierarchyValue

Identifies the rate hierarchy value of the exported bill rate rule.

For example, a value of Victoria indicates the corresponding bill rate rule is defined at the state level of the agreement hierarchy and applies specifically to the state of Victoria.

HierarchyGroup

Identifies the rate hierarchy group of the exported bill rate rule.

BillCode

Identifies the name of the bill code that is defined on the exported bill rate rule.

BillRateRuleId

ID that is used by FastTrack360 to uniquely identify the bill rate rule to which each row in the export file corresponds.

This is used to match each row in the file to an existing bill agreement and bill rate rule when the file is imported into FastTrack360 to bulk update rates.

Do not edit or delete this column.

BillRateRuleSubRuleId

ID that is used by FastTrack360 to uniquely identify the sub-rate on a bill rate rule to which each row in the export file corresponds.

This is used to match each row in the file to an existing sub-rate on a bill rate rule when the file is imported into FastTrack360 to bulk update rates.

Do not edit or delete this column.

MarginMarkupType

Identifies the bill rate type that applies to the exported rate. This will be one of the following:

• Margin Percent

• Markup Dollar

• Markup Percent

• Flat
  Use Other Rate Dollar Margin

• Calculation

• Markup Factor

• Bill Rate Formula

BillRateFormulaId

If the margin/markup type of the exported bill rate rule is Bill Rate Formula, this column identifies the ID that is used by FastTrack360 to uniquely identify the bill rate formula that is used to calculate the bill rate.

Do not edit or delete this column.

BillRateFormulaName

If the margin/markup type of the exported bill rate rule is Bill Rate Formula, this column identifies the name of the bill rate formula that is used to calculate the bill rate.

ConditionalVariable

Identifies the name of the conditional variable that applies to the exported rate.

ConditionalVariableValue

Identifies the conditional variable value that applies to the exported rate.

CalculationPayCode

If the listed rate has a rate type of Calculation or Use Other Rate Dollar Margin, this column identifies the name of the pay code based on which the final rate is calculated.

CalculationOperator

If the listed rate has a rate type of Calculation or Use Other Rate Dollar Margin, this column identifies the mathematical operation that results in the final rate.

This is one of the following:

• Plus

• Minus

• Multiple

• Percent

• Divide

Rate

Identifies the rate value for the exported validity period.

This column is blank if the corresponding sub-rate has a rate type of Use Other Rate Dollar Margin or Bil l Rate Formula.

*NewValidityStartDate

Identifies the date on which the rate update is to become effective.

You must key a date in this column for each row in the file before the file can be imported into FastTrack360 to bulk update rates.

Note that the following conditions apply to the date that you key in this column:

• it must be defined in the format dd/mm/yyy (e.g. 01/01/2018)

• it must fall after the current validity start date of the corresponding bill rate rule, as shown in the

• ValidityStartDate column

• it must fall after the current validity end date of the corresponding bill rate rule, if defined, as shown in the ValidityEndDate column

• it must fall after the last timesheet end date for the corresponding bill agreement, as shown in the Las tTimesheetEndDate column

• it must be the same date as the date specified in the NewValidityStartDate column for all other sub-rates in the file that belong to the same bill rate rule.

*NewRate

Identifies the bill rate that will apply to the new validity period.

This defaults to the current bill rate, unless the corresponding rate type is Use Other Rate Dollar Margin

or Bill Rate Formula in which case this column is blank by default.

If this column is defaulted to the current bill rate, you can leave the default value as is, if the rate is to remain unchanged for the new rate validity period, or you can update the rate as necessary (rate value must be a decimal with a maximum of 6 decimal places). However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the margin/markup type is not Use Other Rate Dollar Margin or Bill Rate Formula.

If this column is blank by default, which indicates that the bill rate type of the corresponding sub-rate is Us e Other Rate Dollar Margin or Bill Rate Formula, this column must remain blank.

*NewBillRateFormula

Identifies the name of the bill rate formula that is to be used to calculate the bill rate for the new validity period.

If the corresponding margin/markup type is Bill Rate Formula, this column will default to the current bill rate formula name but you can update this to any valid bill rate formula name. However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the margin/markup type is Bill Rate Formula.

If the corresponding margin/markup type is not Bill Rate Formula, this column must remain blank.

Column

Description

ExportType

Displays a value of 4 to indicate that the file contains template bill agreement rates.

This is used by the system to determine the type of rates that are being updated when the file is imported into FastTrack360.

Do not edit or delete this column.

TemplateName

Identifies the name of the job template to which the bill agreement is assigned.

TemplateType

Identifies the type or job template to which the pay agreement is assigned. This displays one of the following:

• Country

• Office

• Parent Client

• Client

• Cost Centre

EntityId

If the template type is Office, this column identifies the office code of the agency office to which the template corresponds.

If the template type is Parent Client, Client or Cost Centre, this column identifies the 9-digit ID that uniquely identifies the parent client, client or cost centre entity to which the template corresponds.

If the template type is Country, this column is blank (refer to EntityName column to identify the country name).

EntityName

Identifies the name of the country, office, parent client, client or cost centre to which the template corresponds.

Position

Identifies the job position to which the template corresponds, as defined in the Position field on the template.

ClientPosition

Identifies the job position to which the template corresponds, as defined in the Client Position field on the template.

AgreementID

Displays the ID that uniquely identifies the corresponding bill agreement that is assigned to the job template.

Do not edit or delete this column.

AgreementName

Identifies the name of the bill agreement.

AgreementCountry

Identifies the country to which the bill agreement belongs.

AgreementValidityStartDate

Identifies the date on which the bill agreement becomes valid.

AgreementValidityEndDate

Identifies the date on which the pay agreement ceases to be valid.

TemplateStatus

Identifies the status of the template. This is one of the following:

• Active

• Inactive

TemplateId

Unique ID that identifies the template that is the source of the exported rates.

This is used by the system to identify the correct target template when the file is imported into FastTrack360.

Do not edit or delete this column.

RateRuleName

Identifies the name of the exported bill rate rule.

LastTimesheetEndDate

Identifies the end date of the last timesheet that has been processed against the corresponding bill agreement.

Note that this is accurate as of the time when the export file is created. If more timesheets are processed after the file is exported, the actual last timesheet end date for the corresponding pay agreement could be later than what is shown in this column.

RateRuleValidityStartDate

Identifies the date on which the exported bill rate rule became effective.

RateRuleValidityEndDate

Identifies the date on which the exported bill rate rule ceases to be effective. Alternatively, this column is blank if the corresponding bill rate rule is effective indefinitely.

Note that rates belonging to a rate rule that is already end-dated cannot be updated via Bulk Rate Update. Such rows will be written to the exception file when you import the updated file to bulk update rates (for more information, see Validation Errors & Exceptions).

RateHierarchyType

Identifies the rate hierarchy level of the exported bill rate rule.

For example, a value of State indicates the corresponding bill rate rule is defined at the state level of the agreement hierarchy.

RateHierarchyValue

Identifies the rate hierarchy value of the exported bill rate rule.

For example, a value of Victoria indicates the corresponding bill rate rule is defined at the state level of the agreement hierarchy and applies specifically to the state of Victoria.

HierarchyGroup

Identifies the rate hierarchy group of the exported bill rate rule.

BillCodeName

Identifies the name of the bill code that is defined on the exported bill rate rule.

BillRateRuleId

ID that is used by FastTrack360 to uniquely identify the bill rate rule to which each row in the export file corresponds.

This is used to match each row in the file to an existing bill agreement and bill rate rule when the file is imported into FastTrack360 to bulk update rates.
Do not edit or delete this column.

BillRateRuleSubRuleId

ID that is used by FastTrack360 to uniquely identify the sub-rate on a bill rate rule to which each row in the export file corresponds.

This is used to match each row in the file to an existing sub-rate on a bill rate rule when the file is imported into FastTrack360 to bulk update rates.

Do not edit or delete this column.

MarginMarkupType

Identifies the bill rate type that applies to the exported rate. This will be one of the following:

• Margin Percent

• Markup Dollar

• Markup Percent

• Flat

• Use Other Rate Dollar Margin

• Calculation

• Markup Factor

• BillRateFormula

ConditionalVariable

Identifies the name of the conditional variable that applies to the exported rate.

ConditionalVariableValue

Identifies the conditional variable value that applies to the exported rate.

CalculationPayCode

If the exported bill rate has a margin/markup type of Calculation, this column identifies the name of the pay code based on which the final rate is calculated.

CalculationOperator

If the exported bill rate has a margin/markup type of Calculation, this column identifies the mathematical operation that results in the final rate. This is one of the following:

• Plus

• Minus

• Multiple

• Percent

• Divide

Rate

Identifies the rate value of the exported rate.

This column is blank if the corresponding sub-rate has a margin/markup type of Use Other Rate Dollar Margin or Bill Rate Formula.

*NewValidityStartDate

Identifies the date on which the rate update is to become effective for the exported rate.

You must key a date in this column for each row in the file before the file can be imported into FastTrack360 to bulk update rates.

Note that the following conditions apply to the date that you key in this column:

• it must be defined in the format dd/mm/yyy (e.g. 01/01/2018)

• it must fall after the current validity start date of the corresponding bill rate rule, as shown in the

• ValidityStartDate column

• it must fall after the current validity end date of the corresponding bill rate rule, if defined, as shown in the ValidityEndDate column

• it must be the same date as the date specified in the NewValidityStartDate column for all other sub-rates in the file that belong to the same bill rate rule.

*NewRate

Identifies the bill rate that will apply to the exported rate for the new validity period.

This defaults to the current bill rate, unless the corresponding margin/markup type is Use Other Rate Dollar Margin or Bill Rate Formula in which case this column is blank by default.

If this column is defaulted to the current bill rate, you can leave the default value as is, if the rate is to remain unchanged for the new rate validity period, or you can update the rate as necessary (rate value must be a decimal with a maximum of 6 decimal places). However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the margin/markup type is not Use Other Rate Dollar Margin.

If this column is blank by default, which indicates that the bill rate type of the corresponding sub-rate is Use Other Rate Dollar Margin or Bill Rate Formula this column must remain blank. An error will occur if you attempt to import the file into FastTrack360 if a rate value has been specified for such bill items.

*NewBillRateFormula

Identifies the name of the bill rate formula that is to be used to calculate the bill rate for the new validity period.

If the corresponding margin/markup type is Bill Rate Formula, this column will default to the current bill rate formula name but you can update this to any valid bill rate formula name. However, a value must ex ist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the margin/markup type is Bill Rate Formula.

If the corresponding margin/markup type is not Bill Rate Formula, this column must remain blank.

Column

Description

ExportType

Displays a value of 5 to indicate that the file contains standard rates.

This is used by the system to determine the type of rates that are being updated when the file is imported into FastTrack360.

Do not edit or delete this column.

JobOrderNumber

Identifies the nine-digit ID that uniquely identifies the job order to which the standard rates are assigned.

Position

Identifies the name of the job position of the job order to which the standard rates are assigned.

ClientPosition

Identifies the name of the client job position of the job order to which the standard rates are assigned.

OfficeCode

Identifies the office code and office name of the agency office of the job order to which the standard rates are assigned.

ClientNo

Identifies the nine-digit ID that uniquely identifies the client who owns the job order to which the standard rates assigned.

ClientName

Identifies the name of the client who owns the job order to which the standard rates are assigned.

ParentClientNo

Identifies the nine-digit ID that uniquely identifies the parent client who is linked to the job order to which the standard rates are assigned.

ParentClientName

Identifies the name of the parent client of the client who is linked to the job order to which the standard rates are assigned.

HierarchyGroup

Identifies the rate hierarchy group of the job order to which the standard rates are assigned.

LastTimesheetEndDate

Identifies the end date of the last timesheet that has been processed against the standard rates.

Note that this is accurate as of the time when the export file is created. If more timesheets are processed after the file is exported, the actual last timesheet end date for the corresponding job order could be later than what is shown in this column.

ValidityStartDate

Identifies the date on which the corresponding standard rates set becomes valid.

PayCodeName

Identifies the name of a pay code that is defined within the standard rates matrix for the corresponding job order.

PayRate

Identifies the pay rate of the corresponding pay code for the exported validity period. Alternatively, if the corresponding pay code is flagged as Direct Valuation in the standard rates matrix on the corresponding job order, this column is blank.

RateDescription

Identifies the rate description for the corresponding pay code, if defined.

BillCodeName

Identifies the name of a bill code that is defined within the standard rates matrix for the corresponding job order.

BillType

Identifies the margin/markup type that applies to the corresponding bill code within the standard rates matrix for the corresponding job order. This is one of the following:

• Flat

• Margin %

• Markup %

• Markup Factor

• Markup $

• Bill Rate Formula

BillRateFormulaId

Identifies the FastTrack360 ID that uniquely identifies the bill rate formula that is used to calculate the bill rate, if the bill type is Bill Rate Formula.

Do not edit or delete this column.

BillRateFormulaName

Identifies the name of the bill rate formula that is used to calculate the bill rate, if the bill type is Bill Rate Formula.

BillValue

Identifies the bill value that applies to the corresponding bill code within the standard rates matrix for the corresponding job order.

This is blank if the corresponding bill type is Bill Rate Formula.

StandardRatesHeaderId

Identifies the FastTrack360 ID that uniquely identifies the standard rates header to which the exported rates belong.

This is used by the system to determine to which standard rates header the updated rates belong when the file is imported into FastTrack360.

Do not edit or delete this column.

StandardRateId

Identifies the FastTrack360 ID that uniquely matches the pay and bill rates in the standard rates matrix for the corresponding job order.
This is used by the system to determine to which combination of pay and bill rates are to be updated on a job order when the file is imported into FastTrack360.
Do not edit or delete this column.

PayBillRateRuleId

Identifies the FastTrack360 ID that uniquely identifies the pay rate component within the standard rates matrix for the corresponding job order.

This is used by the system to identify the specific pay rate that is to be updated within the standard rates matrix when the file is imported into FastTrack360.

Do not edit or delete this column.

BillRateRuleId

Identifies the FastTrack360 ID that uniquely identifies the bill rate component within the standard rates matrix for the corresponding job order.

This is used by the system to identify the specific pay rate that is to be updated within the standard rates matrix when the file is imported into FastTrack360.

Do not edit or delete this column.

*NewValidityStartDate

Identifies the date on which the rate update is to become effective.

You must key a date in this column for each row in the file before the file can be imported into FastTrack360 to bulk update rates.

Note that the following conditions apply to the date that you key in this column:

• it must be defined in the format dd/mm/yyy (e.g. 01/01/2018)

• it must fall after the current validity start date of the corresponding rate set, as shown in the

• ValidityStartDate column

• it must fall after the last timesheet end date for the corresponding job order, as shown in the LastTime sheetEndDate column

• it must be the same date as the date specified in the NewValidityStartDate column for all rows in the file that belong to the same rate header.

*NewPayRate

Identifies the pay rate that will apply for the new validity period.

This defaults to the pay rate for the exported period, unless the corresponding rate type is Direct Valuation

, in which case this column is blank by default.

If this column is defaulted with a pay rate, you can leave the default value as is if the rate is to remain unchanged for the new rate validity period, or you can update the rate as necessary (rate value must be a decimal with a maximum of 6 decimal places). However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the rate type is not Direct Valuation.

If this column is blank by default, which indicates that the pay rate type of the corresponding rate is Direct Valuation, this column must remain blank.

*NewRateDescription

Identifies the pay rate description that will apply to the corresponding pay code for the new validity period.

If a pay item has a pay rate description for the exported validity period, this field will default to the existing pay rate description. However, this can be updated or deleted if necessary.

The new rate description can be a maximum of 60 characters.

*NewBillValue

Identifies the bill rate that will apply for the new validity period.

If the corresponding bill type is anything except Bill Rate Formula, this defaults to the bill rate for the exported period. You can leave the default value as is if the rate is to remain unchanged for the new rate validity period, or you can update the rate as necessary (rate value must be a decimal with a maximum of 6 decimal places). However, a value must exist in this column before you can import the file into FastTrack360.

If the corresponding bill type is Bill Rate Formula, this column must remain blank. An error will occur if you attempt to import the file into FastTrack360 if a rate value has been specified for such bill items.

*NewBillRateFormula

Identifies the name of the bill rate formula that is to be used to calculate the bill rate for the new validity period.

If the corresponding bill type is Bill Rate Formula, this column will default to the current bill rate formula name but you can update this to any valid bill rate formula name. However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the margin/markup type is Bill Rate Formula.

If the corresponding bill type is not Bill Rate Formula, this column must remain blank.

Column

Description

ExportType

Displays a value of 6 to indicate that the file contains template standard rates.

This is used by the system to determine the type of rates that are being updated when the file is imported into FastTrack360.

Do not edit or delete this column.

TemplateName

Identifies the name of the job template to which the standard rates are assigned.

TemplateType

Identifies the type of job template to which the standard rates are assigned. This displays one of the following:

• Country

• Office

• Parent

• Client

• Cost Centre

EntityId

If the template type is Office, this column identifies the office code of the agency office to which the template corresponds.

If the template type is Parent Client, Client or Cost Centre, this column identifies the 9-digit ID that uniquely identifies the parent client, client or cost centre entity to which the template corresponds.

If the template type is Country, this column is blank (refer to EntityName column to identify the country name).

EntityName

Identifies the name of the country, office, parent client, client or cost centre to which the template corresponds.

Position

Identifies the job position to which the template corresponds, as defined in the Position field on the template.

ClientPosition

Identifies the job position to which the template corresponds, as defined in the Client Position field on the template.

TemplateStatus

Identifies the status of the template to which the standard rates belong. This is one of the following:

• Active

• Inactive

TemplateId

Unique ID that identifies the template that is the source of the exported rates.

This is used by the system to identify the correct target template when the file is imported into FastTrack360.

Do not edit or delete this column.

HierarchyGroup

Identifies the rate hierarchy group of the template to which the standard rates are assigned.

LastTimesheetEndDate

Identifies the end date of the last timesheet that has been processed against the standard rates.

Note that this is accurate as of the time when the export file is created. If more timesheets are processed after the file is exported, the actual last timesheet end date for the corresponding job order could be later than what is shown in this column.

ValidityStartDate

Identifies the date on which the corresponding standard rates set becomes valid.

PayCodeName

Identifies the name of a pay code that is defined within the standard rates matrix for the corresponding template.

PayRate

Identifies the pay rate of the corresponding pay code for the exported validity period. Alternatively, if the corresponding pay code is flagged as Direct Valuation in the standard rates matrix on the corresponding job order, this column is blank.

RateDescription

Identifies the rate description for the corresponding pay code, if defined.

BillCodeName

Identifies the name of a bill code that is defined within the standard rates matrix for the corresponding template.

BillType

Identifies the margin/markup type that applies to the corresponding bill code within the standard rates matrix for the corresponding template. This is one of the following:

• Flat

• Margin %

• Markup %

• Markup Factor

• Markup $

• Bill Rate Formula

BillRateFormulaName

Identifies the name of the bill rate formula that is used to calculate the bill rate, if the bill type is Bill Rate Formula.

BillValue

Identifies the bill value that applies to the corresponding bill code within the standard rates matrix for the corresponding template.

This is blank if the corresponding bill type is Bill Rate Formula.

StandardRatesHeaderId

Identifies the FastTrack360 ID that uniquely identifies the standard rates header to which the exported rates belong.

This is used by the system to determine to which standard rates header the updated rates belong when the file is imported into FastTrack360.

Do not edit or delete this column.

StandardRateId

Identifies the FastTrack360 ID that uniquely matches the pay and bill rates in the standard rates matrix for the corresponding template.

This is used by the system to determine to which combination of pay and bill rates are to be updated on a job order when the file is imported into FastTrack360.

Do not edit or delete this column.

PayBillRateRuleId

Identifies the FastTrack360 ID that uniquely identifies the pay rate component within the standard rates matrix for the corresponding template.

This is used by the system to identify the specific pay rate that is to be updated within the standard rates matrix when the file is imported into FastTrack360.

Do not edit or delete this column.

BillRateRuleId

Identifies the FastTrack360 ID that uniquely identifies the bill rate component within the standard rates matrix for the corresponding template.

This is used by the system to identify the specific pay rate that is to be updated within the standard rates matrix when the file is imported into FastTrack360.

Do not edit or delete this column.

AgreementId

Identifies the FastTrack360 ID that maps the corresponding pay and bill rates to a unique set of standard rates.

This is used by the system to identify the specific set of standard rates to be updated within the standard rates matrix when the file is imported into FastTrack360.

Do not edit or delete this column.

*NewValidityStartDate

Identifies the date on which the rate update is to become effective.

You must key a date in this column for each row in the file before the file can be imported into FastTrack360 to bulk update rates.

Note that the following conditions apply to the date that you key in this column:

• it must be defined in the format dd/mm/yyy (e.g. 01/01/2018)

• it must fall after the current validity start date of the corresponding rate set, as shown in the

• ValidityStartDate column

• it must fall after the last timesheet end date for the corresponding job order, as shown in the LastTime sheetEndDate column

• it must be the same date as the date specified in the NewValidityStartDate column for all rows in the file that belong to the same rate set.

*NewPayRate

Identifies the pay rate that will apply for the new validity period.

This defaults to the pay rate for the exported period, unless the corresponding rate type is Direct Valuation

, in which case this column is blank by default.

If this column is defaulted with a pay rate, you can leave the default value as is if the rate is to remain unchanged for the new rate validity period, or you can update the rate as necessary (rate value must be a decimal with a maximum of 6 decimal places). However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the rate type is not Direct Valuation.

If this column is blank by default, which indicates that the pay rate type of the corresponding rate is Direct Valuation, this column must remain blank.

*NewBillValue

If the corresponding bill type is anything except Bill Rate Formula, this defaults to the bill rate for the exported period. You can leave the default value as is if the rate is to remain unchanged for the new rate validity period, or you can update the rate as necessary (rate value must be a decimal with a maximum of 6 decimal places). However, a value must exist in this column before you can import the file into FastTrack360.
If the corresponding bill type is Bill Rate Formula, this column must remain blank. An error will occur if you attempt to import the file into FastTrack360 if a rate value has been specified for such bill items.

*NewBillRateFormula

Identifies the name of the bill rate formula that is to be used to calculate the bill rate for the new validity period.

If the corresponding bill type is Bill Rate Formula, this column will default to the current bill rate formula name but you can update this to any valid bill rate formula name. However, a value must exist in this column before you can import the file into FastTrack360. An error will occur if you attempt to import the file into FastTrack360 if this column is blank for any row in the file where the margin/markup type is Bill Rate Formula.

If the corresponding bill type is not Bill Rate Formula, this column must remain blank.