FLOG_TLGSC_SOCOMM_HIST
Maintains historical comments entered during sign-off of tasks in Aircraft Maintenance Execution (AME). Supports quality assurance and compliance validation.
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 SignOffComment entity.
Primary key
replication_key
Columns (17)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGSCH_SLFSRC_OUINSTANCE | #N/A | Specifies the organization unit against which the sign off comments recorded unit is interacting |
| 2 | TLGSCH_TECHLOG_NO | varchar | Specifies the Aircraft Maintenance Execution package number for which the sign off comments are recorded |
| 3 | TLGSCH_WU_SEQ_NO | #N/A | Specifies the task sequence reference number |
| 4 | TLGSCH_SUBTSK_SEQ_NO | varchar | Specifies the sub task sequence reference number |
| 5 | TLGSCH_DRILLDOWN_SEQ_NO | #N/A | Specifies the drill down sequence number |
| 6 | TLGSCH_SKILL_CODE | Varchar | Specifies the skill code |
| 7 | TLGSCH_RESOURCE_GRP | Varchar | Specifies the resource group |
| 8 | TLGSCH_RECORDED_BY | varchar | Specifies the user who recorded the sign off comments |
| 9 | TLGSCH_COMMENTS_DATE | datetime | Specifies the date and time at which the sign off comments are recorded |
| 10 | TLGSCH_COMMENTS_TYPE | varchar | Specifies the type of sign off comments |
| 11 | TLGSCH_SNOFF_FLAG | varchar | Specifies the sign off status |
| 12 | TLGSCH_COMMENTS | varchar | Specifies the sign off comments |
| 13 | TLGSCH_KEY_NO | int | Specifies the running sequence number |
| 14 | TLGSCH_WU_Track_id | bigint | Specifies the task track ID |
| 15 | TLGSCH_CERTIFICATE_NO | varchar | Specifies the certificate number for skill code |
| 16 | TLGSCH_LICENSE_NO | varchar | Specifies the license number for skill code |
| 17 | tlgsch_altskill_code | varchar | Specifies alternate skill details for entered skill |
Relationships (1)
- Task (FLOG_TLGWU_WORK_UNIT_DTL) →
HAS_SIGNOFF_COMMENT(this table is target)- Join:
FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGSC_SOCOMM_HIST.TLGSCH_WU_Track_id - Task has sign-off comments
- Join:
Sample rows (from live DB)
TLGSCH_SLFSRC_OUINSTANCE | TLGSCH_TECHLOG_NO | TLGSCH_WU_SEQ_NO | TLGSCH_SUBTSK_SEQ_NO | TLGSCH_DRILLDOWN_SEQ_NO | TLGSCH_SKILL_CODE |
|---|---|---|---|---|---|
| 2.0 | LP-000020-2019 | 1.0 | 1.1 | 1.0 | — |
| 2.0 | LP-000020-2019 | 2.0 | 2.2 | 1.0 | — |
| 2.0 | LP-000020-2019 | 3.0 | 3.3 | 1.0 | — |
Showing 3 of 44,530 rows.