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