f_all_schedule_payroll_summary
Table Name: f_all_schedule_payroll_summary
Last Updated: June 01, 2026 at 01:20 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| client_code | character | Yes | - |
| user_id | integer | Yes | - |
| public_name | character | Yes | - |
| start_at_local | timestamp | Yes | - |
| end_at_local | timestamp | Yes | - |
| activity_date | date | Yes | - |
| duration_hours | numeric | Yes | - |
| points | numeric | Yes | - |
| stipend | numeric | Yes | - |
| pay_rate | numeric | Yes | - |
| work_type_multiplier_factor | numeric | Yes | - |
| work_type_id | integer | Yes | - |
| scheduling_work_type | character | Yes | - |
| assignment_id | integer | Yes | - |
| assignment_name | character | Yes | - |
| scheduling_activity_type | character | Yes | - |
| activity_type_shortcode | character | Yes | - |
| rotation_id | integer | Yes | - |
| rotation_name | character | Yes | - |
| is_trade | boolean | Yes | - |
| is_off_roster | boolean | Yes | - |
| is_holdover | boolean | Yes | - |
| is_approved | boolean | Yes | - |
| orig_report_group_code | character | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.