FLOG_TLGEC_EXCOMM_HIST
Contains historical records of comments entered during task execution in Aircraft Maintenance Execution (AME). Supports operational traceability and rationale documentation.
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 ExecutionComment entity.
Primary key
replication_key
Columns (13)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGECH_SLFSRC_OUINSTANCE | #N/A | Source organization unit to which the current logged-in organization unit is interacting specifies the interacting unit again |
| 2 | TLGECH_TECHLOG_NO | varchar | Aircraft Maintenance Execution Package Number for which execution comments are given identifies the package |
| 3 | TLGECH_WU_SEQ_NO | #N/A | Task Sequence Number for which the execution comments are given identifies the task |
| 4 | TLGECH_COMMENTS | varchar | Execution comments records the comments regarding task execution |
| 5 | TLGECH_RECORDED_BY | varchar | User who recorded the execution comments identifies the user entering the comments |
| 6 | TLGECH_COMMENTS_DATE | datetime | Comments Entered DateTime records when the execution comments were entered |
| 7 | TLGECH_COMMENTS_TYPE | varchar | Comments Type EXEC Execution Comments EC Employee Comments specifies the type of comment |
| 8 | TLGECH_KEY_NO | int | Running Sequence Number for execution comments recording provides the sequence of comment entries |
| 9 | tlgech_trackid | bigint | Unique ID for identification of employee execution comments provides a unique identifier |
| 10 | TLGECH_WU_Track_id | bigint | Task Track ID uniquely identifies the task for which comments are recorded |
| 11 | TLGECH_RESOURCE_GRP | varchar | Task Resource group identifies the resource group for the task |
| 12 | TLGECH_SKILL_CODE | varchar | Task Skill code specifies the skill code required for the task |
| 13 | TLGECH_SUBTSK_Uniqueid | Bigint | Sub Task sequence number identifies the sequence number of the subtask |
Relationships (1)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
HAS_EXECUTION_COMMENT(this table is target)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGEC_EXCOMM_HIST.TLGECH_WU_Track_id - Task has execution comments
- Join:
Sample rows (from live DB)
TLGECH_SLFSRC_OUINSTANCE | TLGECH_TECHLOG_NO | TLGECH_WU_SEQ_NO | TLGECH_COMMENTS | TLGECH_RECORDED_BY | TLGECH_COMMENTS_DATE |
|---|---|---|---|---|---|
| 2.0 | LP-000007-2019 | 2.0 | Aircraft maintenance checks… | 00000001 | 2019-05-22 06:40:22.000 |
| 2.0 | VP-000995-2018 | 2.0 | AIRCRAFT MAINTANENCE | 00000001 | 2019-05-22 06:50:03.000 |
| 2.0 | VP-000995-2018 | 2.0 | Comment # 1 | 00000001 | 2019-05-22 06:50:03.000 |
Showing 3 of 2,242 rows.