swo_swoclk_emp_clock_dtl
Holds work scope timesheet details for SWO operations. This table captures employee clock-in and clock-out times, work duration, and labor allocation across different maintenance tasks, enabling accurate cost tracking and resource management.
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Core disassembly and assembly operations and details
This table is the canonical store for the SWOEmpClock entity.
Primary key
replication_key
Columns (14)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | REPLICATION_KEY | Bigint | Replication key for unique identification. |
| 2 | swoclk_createdby | varchar | User who created the log. |
| 3 | swoclk_createddate | datetime | Timestamp when the log was created. |
| 4 | swoclk_emp_code | varchar | Employee code performing the task. |
| 5 | swoclk_emp_ouinstance | int | Employee organizational unit instance. |
| 6 | swoclk_fromdate | datetime | Start date of logged period. |
| 7 | swoclk_modifiedby | varchar | User who last modified the log. |
| 8 | swoclk_modifieddate | datetime | Timestamp of last modification. |
| 9 | swoclk_ouinstance | int | Organizational unit instance. |
| 10 | swoclk_skill | varchar | Skill code associated with the task. |
| 11 | swoclk_swo_no | varchar | Shop work order number. |
| 12 | swoclk_taskcode | varchar | Task code. |
| 13 | swoclk_todate | datetime | End date of logged period. |
| 14 | swoclk_upd_flag | varchar | Update flag (Yes or No). |
Sample rows (from live DB)
REPLICATION_KEY | swoclk_createdby | swoclk_createddate | swoclk_emp_code | swoclk_emp_ouinstance | swoclk_fromdate |
|---|---|---|---|---|---|
| — | DMUSER | 2019-06-26 13:29:57.293 | 00000001 | 2 | 2019-06-26 13:29:57.293 |
| — | DMUSER | 2019-06-27 11:04:04.967 | 00000001 | 2 | 2019-06-27 11:04:04.967 |
| — | DMUSER | 2019-06-27 11:37:05.530 | 00000001 | 2 | 2019-06-27 11:37:05.530 |
Showing 3 of 20,810 rows.