INSERT_PUNCH
Inserts or updates a system generated timesheet entry (e.g. for Holiday); handles updating, deleting
Example Usage
INSERT_PUNCH("2022-05-30", "HOL", 8.0) -> add 8hrs HOL for Memorial Day
INSERT_PUNCH("2022-03-22", "MBP", 1, "NL") -> add 1hrs meal break penalty, with "No lunch taken" exception
Overview
Function signature
INSERT_PUNCH(date, hourtype, hours, exception)
Category
Database
Return data type
bool
Arguments
| Name | DataType | List Options | Description |
|---|---|---|---|
date | date | The date on which to add the time punch entry | |
hourtype | string | The hour type (earnings code) to add | |
hours | float | The number of hours to add | |
exception | string | Optional: set an exception abbreviation on the punch |