Difference between revisions of "Proliant Export"
From sbv.wiki
m |
m |
||
| (One intermediate revision by one user not shown) | |||
| 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. | |
| − | * | + | * ''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 |
| − | * | + | |
| − | * | + | |
Latest revision as of 20:44, 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
