api_external.timesheets
View
Timesheets of the caller's engagements with minutes derived from their time entries, while the operational area is open. Submitted through app.submit_timesheet.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Timesheet. |
| engagement_id | uuid | Yes | Engagement. |
| project_id | uuid | Yes | Project. |
| project_name | text | Yes | Project name. |
| period_start | date | Yes | First day. |
| period_end | date | Yes | Last day. |
| timesheet_state | app.timesheet_state | Yes | Proposed, Submitted, Approved or Rejected. |
| worked_minutes | integer | Yes | Closed entry minutes less breaks. |
| submitted_at | timestamp with time zone | Yes | When last submitted. |
| decided_at | timestamp with time zone | Yes | When last approved or rejected. |