flog_adlsoff_tsk_dtl
Maintains additional sign-off records for tasks executed under Aircraft Maintenance Execution (AME) packages. Provides redundancy and additional compliance documentation for quality assurance.
Process: LINEMAINTENANCE · Component: BasFltLog · Table type: Transaction Table Category: Core system for Aircraft Maintenance Execution ( AME ) package tracking, task eliminations, work assignments, and maintenance operations. Manages detailed records of maintenance tasks, employee assignments, work centers, and scheduling for aircraft maintenance activities.
This table is the canonical store for the AdditionalSignOff entity.
Primary key
adlso_UniqueId
Columns (12)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | adlso_ou | int | OU instance specifies the organizational unit instance |
| 2 | adlso_packageno | varchar | Package Number for AME identifies the AME package number |
| 3 | adlso_tsktrackid | bigint | Task Track Id uniquely identifies the task in the AME package |
| 4 | adlso_subtskId | bigint | Subtask level Master Unique Id identifies the unique ID at the subtask level |
| 5 | adlso_addlsoff | varchar | Additional Sign Off By records the user who provided additional sign off |
| 6 | adlso_resgroup | varchar | ASOFF Additional Sign Off indicates whether additional sign off is completed |
| 7 | adlso_signdt | datetime | Additional Sign Off Date time records when additional sign off was performed |
| 8 | adlso_context | varchar | Sign Off context specifies the context under which sign off was done |
| 9 | adlso_procdt | datetime | Processed date records the date when the task or sign off was processed |
| 10 | adlso_procby | varchar | Processed by identifies the user who processed the task or sign off |
| 11 | adlso_entity_type | varchar | AME / SWO specifies whether the record belongs to AME or SWO |
| 12 | adlso_UniqueId 🔑 | bigint | Table unique Id provides a unique identifier for the table entry |
Relationships (1)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
ADDITIONAL_SIGNOFF(this table is target) (no automatic join)- Task has additional sign-off
Sample rows (from live DB)
adlso_ou | adlso_packageno | adlso_tsktrackid | adlso_subtskId | adlso_addlsoff | adlso_resgroup |
|---|---|---|---|---|---|
| 2 | VP1-001716-2024 | 281989.0 | -2147440563.0 | 00001413 | ASOFF |
| 2 | VP1-001716-2024 | 281989.0 | -2147440562.0 | 00001413 | ASOFF |
| 2 | VP1-001719-2024 | 282030.0 | -2147440534.0 | 00001413 | ASOFF |
Showing 3 of 843 rows.