swo_swoema_emp_actuals_dtl
Contains actual timesheet details for employees working on SWO tasks. This table records actual time spent by employees on specific maintenance tasks, providing data for labor cost calculation and productivity analysis.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Employee work details including indirect work and actual time records
This table is the canonical store for the SWOEmpActual entity.
Primary key
swoema_seqno
Columns (43)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swoema_analysiscode | Char | Account group analysis code. |
| 2 | swoema_att_type | varchar | Attendance type of the employee. |
| 3 | swoema_billable_flag | varchar | Flag indicating if the entry is billable. |
| 4 | swoema_booking_id | Bigint | Booking identifier. |
| 5 | swoema_break_hrs | numeric | Break duration in hours. |
| 6 | swoema_comments | varchar | Additional comments or notes. |
| 7 | swoema_cost_center | varchar | Cost center associated with the entry. |
| 8 | swoema_created_by | varchar | User who created the record. |
| 9 | swoema_created_date | datetime | Creation date of the record. |
| 10 | swoema_dur_hrs | numeric | Duration in hours. |
| 11 | swoema_emp_code | varchar | Employee code. |
| 12 | swoema_emp_cost | numeric | Cost associated with the employee. |
| 13 | swoema_emp_ou | int | Employee organizational unit instance. |
| 14 | swoema_emp_rate | numeric | Employee rate. |
| 15 | swoema_finbook | varchar | Book identifier. |
| 16 | swoema_fin_postingDone | varchar | Flag indicating if finance posting is done. |
| 17 | swoema_from_datetime | datetime | Start date and time of task execution. |
| 18 | swoema_from_utc_datetime | datetime | Clock start date and time in UTC. |
| 19 | swoema_indirect_hrs | numeric | Indirect hours. |
| 20 | swoema_modified_by | varchar | User who modified the record. |
| 21 | swoema_modified_date | datetime | Modification date. |
| 22 | swoema_ouinstance | int | SWO organizational unit instance. |
| 23 | swoema_pri_skill | varchar | Primary skill of the employee. |
| 24 | swoema_seqno 🔑 | bigint | Unique sequence number (Primary Key). |
| 25 | swoema_signoff_skill | varchar | Sign-off skill. |
| 26 | swoema_source | varchar | Source of the entry. |
| 27 | swoema_station_code | varchar | Station code mapped to work center. |
| 28 | swoema_status | varchar | Time sheet status-AU(Authorized),CF-Confirmed |
| 29 | swoema_subanalysiscode | Char | Account Group - Sub Analysis Code |
| 30 | swoema_sub_trackid | bigint | Track Id |
| 31 | swoema_swo_no | varchar | Shop Work Order (SWO )No |
| 32 | swoema_task_code | varchar | Task for which time sheet details are reported |
| 33 | swoema_task_ou | int | Task code for reported timesheet details. |
| 34 | swoema_task_track_id | bigint | Task organizational unit instance. |
| 35 | swoema_till_datetime | datetime | Task track ID for reported task. |
| 36 | swoema_timestamp | int | End date of the task. |
| 37 | swoema_to_datetime | datetime | Timestamp of the record. |
| 38 | swoema_to_utc_datetime | datetime | End date and time of task execution. |
| 39 | swoema_updated_by | varchar | Clock end date and time in UTC. |
| 40 | swoema_updated_date | datetime | Updated by. |
| 41 | swoema_updated_remarks | varchar | Updated date |
| 42 | swoema_upd_mode | varchar | Mode of update (Clock/Manual). |
| 43 | swoema_wc_code | varchar | Execution work center for the task. |
Sample rows (from live DB)
swoema_analysiscode | swoema_att_type | swoema_billable_flag | swoema_booking_id | swoema_break_hrs | swoema_comments |
|---|---|---|---|---|---|
| — | NRM | N | — | — | — |
| — | NRM | N | — | — | — |
| — | NRM | N | — | — | — |
Showing 3 of 25,085 rows.