Proliant Export

From sbv.wiki
Revision as of 19:47, 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.

The export file has place for the below columns:

id,det,detCode,hours,amount,rate,rateCode,cc1,cc2,cc3,cc4,cc5,jobCode,shift,beginDate,endDate,wcc,tcode1,tcode2,tcode3,tcode4

  • 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: From the Grouping on the Options tab
  • cc2: From the Grouping on the Options tab
  • cc3: From the Grouping on the Options tab
  • cc4: From the Grouping on the Options tab
  • cc5: 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