xpms.v_sheet_crew_timesheets
View
The Playbook Crew Timesheets sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | Yes | Row number in the source sheet. |
| timesheet_id | text | Yes | TIMESHEET ID (column A), field. |
| project_id | text | Yes | PROJECT ID (column B), field. |
| shift_id | text | Yes | SHIFT ID (column C), field. |
| actual_in_time | text | Yes | ACTUAL IN TIME (column J), field. |
| meal_out_time | text | Yes | MEAL OUT TIME (column K), field. |
| meal_in_time | text | Yes | MEAL IN TIME (column L), field. |
| actual_out_time | text | Yes | ACTUAL OUT TIME (column M), field. |
| status | text | Yes | STATUS (column AC), field. |
| flag | text | Yes | FLAG (column AD), field. |
| notes | text | Yes | NOTES (column AE), field. |
| created_by | text | Yes | CREATED BY (column AF), field. |
| created_at | text | Yes | CREATED AT (column AG), field. |
| updated_at | text | Yes | UPDATED AT (column AH), field. |
| work_date | date | Yes | WORK DATE (column D), computed. |
| personnel_id | text | Yes | PERSONNEL ID (column E), computed. |
| crew_name | text | Yes | CREW NAME (column F), computed. |
| role_code | text | Yes | ROLE CODE (column G), computed. |
| rate_card_id | text | Yes | RATE CARD ID (column H), computed. |
| job_title | xpms.canon_text | Yes | JOB TITLE (column I), computed. |
| meal_duration_hrs | numeric | Yes | MEAL DURATION (HRS) (column N), computed. |
| total_elapsed_hours | numeric | Yes | TOTAL ELAPSED HOURS (column O), computed. |
| net_worked_hours | numeric | Yes | NET WORKED HOURS (column P), computed. |
| regular_hours_1_0x | numeric | Yes | REGULAR HOURS (1.0x) (column Q), computed. |
| overtime_hours_1_5x | numeric | Yes | OVERTIME HOURS (1.5x) (column R), computed. |
| double_time_hours_2_0x | numeric | Yes | DOUBLE TIME HOURS (2.0x) (column S), computed. |
| hourly_base_rate | numeric | Yes | HOURLY BASE RATE (column T), computed. |
| regular_pay | numeric | Yes | REGULAR PAY (column U), computed. |
| overtime_pay | numeric | Yes | OVERTIME PAY (column V), computed. |
| double_time_pay | numeric | Yes | DOUBLE TIME PAY (column W), computed. |
| meal_penalty_pay | integer | Yes | MEAL PENALTY PAY (column X), computed. |
| per_diem_pay | numeric | Yes | PER DIEM PAY (column Y), computed. |
| gross_earnings | numeric | Yes | GROSS EARNINGS (column Z), computed. |
| expense_gl_account | numeric | Yes | EXPENSE GL ACCOUNT (column AA), computed. |
| expense_gl_name | xpms.canon_text | Yes | EXPENSE GL NAME (column AB), computed. |