Difference between revisions of "Proliant Export"
From sbv.wiki
m |
m |
||
| Line 3: | Line 3: | ||
* <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. | * $ 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: | 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. | |
| − | * id: Employee's ID from the Report ID on the Options tab. | + | * ''detCode'': Pay Type payroll export code |
| − | * det: "E" for all lines. | + | * ''hours'': Total of hours for the whole period |
| − | * detCode: Pay Type payroll export code | + | * ''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) |
| − | * hours: Total of hours for the whole period | + | * ''rate'': Blank |
| − | * 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) | + | * ''rateCode'': Blank |
| − | * rate: Blank | + | * ''cc1'': Worked labor level from the Grouping on the Options tab |
| − | * rateCode: Blank | + | * ''cc2'': Worked labor level from the Grouping on the Options tab |
| − | * cc1: | + | * ''cc3'': Worked labor level from the Grouping on the Options tab |
| − | * cc2: | + | * ''cc4'': Worked labor level from the Grouping on the Options tab |
| − | * cc3: | + | * ''cc5'': Worked labor level from the Grouping on the Options tab |
| − | * cc4: | + | * ''jobCode'': Blank |
| − | * cc5: | + | * ''shift'': Blank |
| − | * jobCode: Blank | + | * ''beginDate'': Blank |
| − | * shift: Blank | + | * ''endDate'': Blank |
| − | * beginDate: Blank | + | * ''wcc'': Blank |
| − | * endDate: Blank | + | * ''tcode1'': Blank |
| − | * wcc: Blank | + | * ''tcode2'': Blank |
| − | * tcode1: Blank | + | * ''tcode3'': Blank |
| − | * tcode2: Blank | + | * ''tcode4'': Blank |
| − | * tcode3: Blank | + | |
| − | * tcode4: Blank | + | |
Revision as of 19:54, 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.
- 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
