Proliant Export - Revision history

Joel at 20:44, 17 May 2023

2023-05-17T20:44:22Z

Joel at 19:54, 17 May 2023

2023-05-17T19:54:39Z

Joel at 19:47, 17 May 2023

2023-05-17T19:47:05Z

Jeffrey: Created page with "Additional fields that can be used: * can be used to add the check date to the file name so that each payroll doesn't overwrite the previous payroll file."

2021-09-01T21:12:56Z

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."

New page

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.

@@ Line 8: / Line 8: @@
 The export file has place for the below columns:
-* ''id'': Employee's ID from the Report ID on the Options tab.
+* ''ID'': Employee's ID from the Report ID on the Options tab.
-* ''det'': "E" for all lines.
+* ''DET'': "E" for all lines.
-* ''detCode'': Pay Type payroll export code
+* ''DETCode'': Pay Type payroll export code
-* ''hours'': Total of hours for the whole period
+* ''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)
+* ''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
+* ''Rate'': Blank
-* ''rateCode'': Blank
+* ''RateCode'': Blank
-* ''cc1'': Worked labor level from the Grouping on the Options tab
+* ''CC1'': Worked labor level from the Grouping on the Options tab
-* ''cc2'': 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
+* ''CC3'': Worked labor level from the Grouping on the Options tab
-* ''cc4'': 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
+* ''CC5'': Worked labor level from the Grouping on the Options tab
-* ''jobCode'': Blank
+* ''JobCode'': Blank
-* ''shift'': Blank
+* ''Shift'': Blank
-* ''beginDate'': Blank
+* ''BeginDate'': Blank
-* ''endDate'': Blank
+* ''EndDate'': Blank
-* ''wcc'': Blank
+* ''WCC'': Blank
-* ''tcode1'': Blank
+* ''Tcode1'': Blank
-* ''tcode2'': Blank
+* ''Tcode2'': Blank
-* ''tcode3'': Blank
+* ''Tcode3'': Blank
-* ''tcode4'': Blank
+* ''Tcode4'': Blank

@@ 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.
 * $ 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.
-* 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: From the Grouping on the Options tab
+* ''cc3'': Worked labor level from the Grouping on the Options tab
-* cc2: From the Grouping on the Options tab
+* ''cc4'': Worked labor level from the Grouping on the Options tab
-* cc3: From the Grouping on the Options tab
+* ''cc5'': Worked labor level from the Grouping on the Options tab
-* cc4: From the Grouping on the Options tab
+* ''jobCode'': Blank
-* cc5: From the Grouping on the Options tab
+* ''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

← Older revision		Revision as of 19:47, 17 May 2023
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