Timesheet Split Process – Postgres

This process workflow with gel script forces billable hours on timesheet down to 40 hours, and sets overtime hours to non-billable.  Timesheets with 40 or fewer hours are not touched.  Process kicks off upon submission of timesheet.  Steps are:

• Determine if timesheet has > 40 hours.  If so, proceed.
• Create a SPLIT row for each timesheet row, with Input Type Code = Non-Bill.
• Divide 40 by total timesheet ours.  Store this value.
• Multiply each timesheet cell by the stored value, and enter the result into that cell.
• Take the difference (original cell value – new cell value), and enter in same cell on Split row.
• The end result will be 40 hours total on Billable rows, and overtime hours on Non-Billable rows.