Override and Allocate

The allocation or override import use the same template, allocation.xls. However, the codes for Columns B (Force or Reject) and AD (Add Time) must indicate the override. This import allows a user to override existing calculated labor hours or add hours that do not exist in Track. The allocations should be forced to match the total number of hours being submitted with the import. The option to use this import will only be available in the drop-down list for users who must override labor hours according to the Profile Rules.

 

Import Template Name

Import Type

Import Data Fields

allocation

Allocation

  • Record ID

  • Force or Reject

  • Source

  • Date

  • Order Type

  • Location ID

  • Company Code

  • Resource ID

  • Resource Name

  • Area

  • Group Name

  • Agreement

  • Skill Type

  • Shift

  • Level 1 ID

  • Level 2 ID

  • Level 3 ID

  • Level 4 ID

  • Hours Total

  • Hours Total Activity Code

  • S/T (Hrs)

  • S/T Hrs Activity Code

  • O/T (Hrs)

  • O/T Hrs Activity Code

  • D/T (Hrs)

  • D/T Hrs Activity Code

  • Extra Charges $

  • Extra Charges $ Activity Code

  • Extra

  • Add Time

  • Pay Type

  • R4 (Hrs)

  • R5 (Hrs)

  • R6 (Hrs)

  • GL Account

  • ST Adders

  • OT Adders

  • DT Adders

  • R4 Adders

  • R5 Adders

  • R6 Adders

  • Override Reason

  • Override Reason Comment