Difference between revisions of "Proliant Export"
From sbv.wiki
(Created page with "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.") |
m |
||
Line 2: | Line 2: | ||
* <CheckDate> can be used to add the check date to the file name so that each payroll doesn't overwrite the previous payroll file. | * <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 |
Revision as of 19:47, 17 May 2023
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