swo_adlsoff_tsk_dtl
This table is used to capture additional sign-off details related to a maintenance task or work order. It records extra validations or approvals required beyond the standard sign-off, ensuring compliance with operational and regulatory requirements.
Process: COMPMAINTENANCE 路 Component: BasSWO 路 Table type: Transaction Table Category: Groups the tables related to indirect and actual work hours logged against Shop work order ( SWO ) related task.
Primary key
adlso_UniqueId
Columns (12)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | adlso_addlsoff | varchar | Name or identifier of the authorized personnel who performed the additional sign-off |
| 2 | adlso_context | varchar | Specific service, task, or operational context related to the sign-off |
| 3 | adlso_entity_type | varchar | Indicates whether the record pertains to an Aircraft Maintenance Event (AME) or a Shop Work Order (SWO) |
| 4 | adlso_ou | int | Organizational unit (OU) where the sign-off is recorded |
| 5 | adlso_packageno | varchar | Unique identifier of the maintenance package associated with the sign-off |
| 6 | adlso_procby | varchar | User or system who processed the sign-off entry |
| 7 | adlso_procdt | datetime | Date and time when the sign-off entry was processed |
| 8 | adlso_resgroup | varchar | Resource group classification used for additional sign-off |
| 9 | adlso_signdt | datetime | Date and time when the additional sign-off was completed |
| 10 | adlso_subtskId | bigint | Links the sign-off to a subtask in the maintenance master hierarchy |
| 11 | adlso_tsktrackid | bigint | Identifier for tracking the task related to the sign-off |
| 12 | adlso_UniqueId 馃攽 | bigint | Auto-generated unique identifier for the record |
Sample rows (from live DB)
adlso_addlsoff | adlso_context | adlso_entity_type | adlso_ou | adlso_packageno | adlso_procby |
|---|---|---|---|---|---|
| 00001413 | SIGNOFF | SUBTSK | 2 | OWO-001293-2024 | DMUSER |
| 00000001 | SIGNOFF | SUBTSK | 2 | OWO-001293-2024 | DMUSER |
| 00000001 | SIGNOFF | SUBTSK | 2 | OWO-001293-2024 | DMUSER |
Showing 3 of 262 rows.