Proliant Export

From sbv.wiki
Revision as of 19:54, 17 May 2023 by Joel (Talk | contribs)

Jump to: navigation, search

Additional fields that can be used:

  • <CheckDate> can be used to add the check date to the file name so that each payroll doesn't overwrite the previous payroll file.
  • $ sign in the Pay Type payroll export code will cause the hours to export to the amount column.
  • Employees that are marked as Exclude from Payroll Export on their Misc tab will not be included on the export.
  • If using Timecard Approval, it will pop up a list of unapproved time cards.

The export file has place for the below columns:

  • id: Employee's ID from the Report ID on the Options tab.
  • det: "E" for all lines.
  • detCode: Pay Type payroll export code
  • hours: Total of hours for the whole period
  • amount: Total of amounts for the whole period (if an amount was entered instead of hours, or if there is a $ in the export code then it will put the hours in the amount column)
  • rate: Blank
  • rateCode: Blank
  • cc1: Worked labor level from the Grouping on the Options tab
  • cc2: Worked labor level from the Grouping on the Options tab
  • cc3: Worked labor level from the Grouping on the Options tab
  • cc4: Worked labor level from the Grouping on the Options tab
  • cc5: Worked labor level from the Grouping on the Options tab
  • jobCode: Blank
  • shift: Blank
  • beginDate: Blank
  • endDate: Blank
  • wcc: Blank
  • tcode1: Blank
  • tcode2: Blank
  • tcode3: Blank
  • tcode4: Blank