FLOG_TLGMN_TECH_LOG_HDR
Stores header level information of Aircraft Maintenance Execution (AME) packages. Includes package identifiers, aircraft references, and high-level execution metadata.
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 AMEPackage entity.
Primary key
TLGMN_TECHLOG_NO, TLGMN_SLFSRC_OUINSTANCE
Columns (154)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGMN_SLFSRC_OUINSTANCE 🔑 | #N/A | Organization Unit in which the Aircraft Maintenance Execution Package is created identifies the responsible unit |
| 2 | TLGMN_TECHLOG_CATEGORY | Varchar | Category of Aircraft Maintenance Execution Package that is created for an Aircraft specifies the package category |
| 3 | TLGMN_ACT_ARRIVAL_DATETIME | datetime | Actual arrival date of the Aircraft to the Line Maintenance Area records when the aircraft arrived |
| 4 | TLGMN_UTC_ACT_ARR_DATETIME | datetime | UTC value of actual arrival date of the Aircraft to the Line Maintenance Area provides the UTC timestamp of arrival |
| 5 | TLGMN_CONFIRMED_BY | varchar | The User who confirmed the Aircraft Maintenance Execution Document Package identifies the confirming user |
| 6 | TLGMN_CONFIRMED_DATE | datetime | The date in which the Aircraft Maintenance Execution Document Package is confirmed records the confirmation date |
| 7 | TLGMN_FIRST_FLIGHT_FLAG | varchar | The flag which indicates whether this Aircraft Maintenance Execution Package is the first after first journey for the day specifies if it is the first package |
| 8 | TLGMN_FROM_STATION | varchar | The station from which the Aircraft is started identifies the departure station |
| 9 | TLGMN_JRNLOG_TO_STATION | varchar | The station to which the Aircraft is flying from here identifies the arrival station |
| 10 | TLGMN_GATE_IN_DATETIME | datetime | Gate In time of the Aircraft records when the aircraft entered the gate |
| 11 | TLGMN_UTC_GATE_IN_DATETIME | datetime | UTC value of Gate In time of the Aircraft provides the gate entry time in UTC |
| 12 | TLGMN_GATE_NO | varchar | Gate Number identifies the gate assigned |
| 13 | TLGMN_ADL_WORK_PERF | #N/A | Additional work performed records any additional work done |
| 14 | TLGMN_MECH_COMMENTS | varchar | Mechanic comments captures comments from the mechanic |
| 15 | TLGMN_INSP_EMP_NO | varchar | The Inspector who inspected mechanics work identifies the inspector |
| 16 | TLGMN_INSP_LICENCE_NO | varchar | Licence Number of the Inspector records the inspector’s license number |
| 17 | TLGMN_INSP_COMMENTS | varchar | Inspector comments captures comments from the inspector |
| 18 | TLGMN_TECHLOG_DTL_1 | Varchar | Additional details 1 provides extra details for the record |
| 19 | TLGMN_TECHLOG_DTL_2 | Varchar | Additional details 2 provides extra details for the record |
| 20 | TLGMN_TECHLOG_DTL_3 | Varchar | Additional details 3 provides extra details for the record |
| 21 | TLGMN_USER_DEFINED_1 | Varchar | User Defined Details 1 captures user-defined information |
| 22 | TLGMN_USER_DEFINED_2 | Varchar | User Defined Details 2 captures user-defined information |
| 23 | TLGMN_USER_DEFINED_3 | Varchar | User Defined Details 3 captures user-defined information |
| 24 | TLGMN_JRNLOG_FLIGHT_NO | varchar | Flight Number of the Journey Log which is associated with this Package |
| 25 | TLGMN_JRNLOG_LEG_NO | #N/A | Leg Number of the Journey Log which is associated with this Package |
| 26 | TLGMN_MECH_LICENSE_NO | varchar | Licence Number of the Mechanic |
| 27 | TLGMN_LOG_LEAF_NO | varchar | Log Leaf Number |
| 28 | TLGMN_MECH_NO | varchar | Mechanic who performed the tasks |
| 29 | TLGMN_MODIFIED_BY | varchar | The user who modified this Aircraft Maintenance Execution Package |
| 30 | TLGMN_CRT_OU | #N/A | Organization Unit in which the Aircraft Maintenance Execution Package is created |
| 31 | TLGMN_MODIFIED_DATE | datetime | The date in which the Aircraft Maintenance Execution Package is modified |
| 32 | TLGMN_OUT_FLIGHT_NO | varchar | Flight Number of the next journey from the current work station |
| 33 | TLGMN_OUT_LEG_NO | #N/A | Leg Number of the next journey from the current work station |
| 34 | TLGMN_OUT_SCH_DEP_DATETIME | datetime | Scheduled departure date and time of the next journey from the current work station |
| 35 | TLGMN_OUT_UTC_SCH_DEP_DATETIME | datetime | UTC value of scheduled departure date and time of the next journey from the current work station |
| 36 | TLGMN_PAPER_DOC_UPD | varchar | Flag which indicates whether the paper documents related to this package has been updated or not |
| 37 | TLGMN_RECORDING_STATION | varchar | Recording Station of this package |
| 38 | TLGMN_REF_JRNLOG_NO | varchar | Reference Journey log Number |
| 39 | TLGMN_REF_JRNLOG_OU | #N/A | Organization unit in which the reference journey log is created |
| 40 | TLGMN_RELEASE_COMMENTS | varchar | Comments provided during package release |
| 41 | TLGMN_RELEASE_STATUS | varchar | Release status of the package |
| 42 | TLGMN_RELEASED_BY | varchar | The user who released the package |
| 43 | TLGMN_RELEASED_DATE | datetime | The date in which the package got released |
| 44 | TLGMN_TECHLOG_STATUS | varchar | Status of the package Possible values are Draft Fresh Released etc |
| 45 | TLGMN_TIMESTAMP | #N/A | Indicates the number of times the package got modified |
| 46 | TLGMN_TO_STATION | varchar | The station to which the Aircraft is flying from the current location |
| 47 | TLGMN_USER_STATUS | Varchar | Status maintained by the user for this Aircraft Maintenance Execution document |
| 48 | TLGMN_FILE_NAME | varchar | Name of the file associated to the Aircraft Maintenance Execution document |
| 49 | TLGMN_WORK_CENTER | varchar | Name of the work location in which the tasks identified as part of this Aircraft Maintenance Execution document is performed |
| 50 | TLGMN_MAINTENANCE_EVENT | varchar | Identifies the maintenance event |
| 51 | TLGMN_WORK_CENTER_OU | #N/A | Specifies the organization unit in which the work location is created |
| 52 | TLGMN_WORK_TIMESTAMP | #N/A | Records the work timestamp |
| 53 | TLGMN_MATERIAL_TIMESTAMP | #N/A | Records the material timestamp |
| 54 | TLGMN_CR_TIMESTAMP | #N/A | Records the CR timestamp |
| 55 | TLGMN_TIMESHEET_TIMESTAMP | #N/A | Records the timesheet timestamp |
| 56 | TLGMN_RES_TIMESTAMP | #N/A | Records the resource timestamp |
| 57 | TLGMN_LOCAL_TIMEZONE | varchar | Specifies the timezone in which the work is performed |
| 58 | TLGMN_ACTSTART_DTTIME | datetime | Records the date and time in which the mechanic started executing the task identified as part of the Aircraft Maintenance Execution package |
| 59 | TLGMN_ACTEND_DTTIME | datetime | Records the date and time in which the mechanic completed all the tasks planned as part of the Aircraft Maintenance Execution document |
| 60 | TLGMN_UTC_ACTSTART_DTTIME | datetime | Provides the UTC value of the date and time in which the mechanic started executing the task |
| 61 | TLGMN_UTC_ACTEND_DTTIME | datetime | Provides the UTC value of the date and time in which the mechanic completed all the tasks planned |
| 62 | TLGMN_COM_REQD | varchar | Indicates whether Certificate of Maintenance is required for the package |
| 63 | TLgMn_Start_Station | varchar | Identifies the starting station |
| 64 | Tlgmn_Line_Pack_no | varchar | Specifies the line package number |
| 65 | Tlgmn_Line_Pack_OU | int | Specifies the organization unit in which the line package is created |
| 66 | TLGMN_TECHLOG_TYPE | varchar | Specifies the type of the Aircraft Maintenance Execution Package document |
| 67 | TLGMN_TECHLOG_BASIS | varchar | Identifies the basis on which the Aircraft Maintenance Execution document is created |
| 68 | TLGMN_EXPENSE_TYPE | varchar | Specifies the expense type of the Aircraft Maintenance Execution document |
| 69 | TLGMN_REFDOC_TYPE | varchar | Specifies the type of the reference document |
| 70 | TLGMN_CUSTORDER_NO | varchar | Specifies the customer order number related to this Aircraft Maintenance Execution document |
| 71 | TLGMN_MISC_COST | numeric | Records miscellaneous cost incurred to execute the tasks identified as part of this package |
| 72 | TLGMN_CAPEXPROPOSAL_NO | varchar | Specifies the CAPEX proposal number of this Aircraft Maintenance Execution document |
| 73 | TLGMN_CUSTORDER_OU | int | Specifies the organization unit in which the customer order is created |
| 74 | TLGMN_JRNLOG_LINE_NO | int | Records the line number of the journey log if the Aircraft Maintenance Execution document is created against a journey log line |
| 75 | TLGMN_MAT_COST | numeric | Records the materials cost incurred to execute the tasks identified as part of this package |
| 76 | TLGMN_FAC_COST | numeric | Records the facilities cost incurred to execute the tasks identified as part of this package |
| 77 | TLGMN_LAB_COST | numeric | Records the labour cost incurred to execute the tasks identified as part of this package |
| 78 | TLGMN_ROSTER_CODE_FLAG | varchar | Specifies the roster code flag |
| 79 | TLGMN_OILCONS_STATUS | varchar | Specifies the oil consumption status |
| 80 | TLGMN_DAILY_CHECK | varchar | Indicates the type of the package |
| 81 | TLGMN_WEEKLY_CHECK | varchar | Indicates the type of the package |
| 82 | tlgmn_execdoc_type | varchar | Specifies the execution document type |
| 83 | TLGMN_EXECU_TYPE | varchar | Specifies the execution document type |
| 84 | TLGMN_DEF_PRIORITY | varchar | Specifies the priority number |
| 85 | TLGMN_AUTO_RET | varchar | Indicates auto return flag |
| 86 | TLGMN_FB_NO | varchar | Specifies the finance book number |
| 87 | TLGMN_FB_OU | int | Specifies the organization unit in which the finance book is created |
| 88 | TLGMN_SLOTNO | varchar | Specifies the slot number |
| 89 | TLGMN_SLOT_StDate | datetime | Specifies the starting date of the slot |
| 90 | TLGMN_SLOT_EnDate | datetime | Specifies the end date of the slot |
| 91 | TLGMN_Plan_StDate | datetime | Records the planned start date and time for the mechanic to execute the task |
| 92 | TLGMN_Plan_EnDate | datetime | Records the planned end date and time for the mechanic to complete the tasks |
| 93 | TLGMN_USER_DEF_STATUS | varchar | Specifies the user defined status |
| 94 | tlgmn_pckg_desc | varchar | Provides detailed description of the package |
| 95 | tlgmn_repair_proc_code | varchar | Specifies the repair procedure code |
| 96 | tlgmn_order_class | varchar | Specifies the order classification |
| 97 | tlgmn_repair_class | varchar | Specifies the repair classification |
| 98 | tlgmn_contract_no | varchar | Specifies the contract number based on which this document is created |
| 99 | tlgmn_contract_rev_no | int | Specifies the revision number of the contract |
| 100 | tlgmn_contract_eff_code | varchar | Specifies the contract effectivity code |
| 101 | tlgmn_contract_eff_line_no | int | Specifies the contract effectivity line number |
| 102 | tlgmn_est_flag | varchar | Indicates whether estimation is done for this document |
| 103 | tlgmn_cus_order_revno | varchar | Specifies the revision number of the customer order |
| 104 | tlgmn_cust_no | varchar | Specifies the customer order number related to this document |
| 105 | tlgmn_operator_code | varchar | Specifies the operator code |
| 106 | tlgmn_src_cust_ord | varchar | Specifies the source customer order number |
| 107 | tlgmn_cust_reg_date | datetime | Specifies the customer registration date |
| 108 | tlgmn_prom_del_date | datetime | Specifies the promised delivery date |
| 109 | tlgmn_target_date | datetime | Specifies the target date of work completion |
| 110 | tlgmn_promised_cmp_date | datetime | Specifies the promised completion date |
| 111 | tlgmn_eventid | varchar | Specifies the event ID |
| 112 | TLGMN_SCH_ARR_DATETIME | datetime | Specifies the scheduled arrival time of the flight |
| 113 | TLGMN_SCH_DEP_DATETIME | datetime | Specifies the scheduled departure time of the flight |
| 114 | tlgmn_work_req | varchar | Specifies the work requested |
| 115 | tlgmn_source_flag | varchar | Specifies the source flag |
| 116 | TLGMN_cust_warr_req_flag | varchar | Indicates the warranty requested flag |
| 117 | TLGMN_cust_warr_res_flag | varchar | Indicates the warranty resolution flag |
| 118 | TLGMN_cust_warr_notes | varchar | Specifies the warranty notes |
| 119 | TLGMN_OPR_TYPE | varchar | Specifies the operations type |
| 120 | TLGMN_OUT_JRNLOG_NO | varchar | Specifies the reference number of the next journey from this location |
| 121 | TLGMN_FLIGHT_CODE | varchar | Specifies the flight code of the next journey |
| 122 | TLGMN_LEG_NO | int | Specifies the leg number of the next journey from the current work station |
| 123 | TLGMN_SCH_DEP_STATION | varchar | Specifies the scheduled departure time of the flight from the current location |
| 124 | TLGMN_SCH_ARR_STATION | varchar | Specifies the scheduled arrival time of the flight from the current location |
| 125 | tlgmn_base_source_flag | varchar | Specifies the base source flag |
| 126 | tlgmn_data_trans_flag | varchar | Indicates whether the details of the document have been transferred to main field base |
| 127 | TLGMN_TRANSFER_DATE | datetime | Specifies the transferred date |
| 128 | tlgmn_act_arr_datetime | datetime | Specifies the actual arrival date and time |
| 129 | tlgmn_act_dep_datetime | datetime | Specifies the actual departure date and time |
| 130 | tlgmn_arr_delaycode | varchar | Specifies the arrival delay code |
| 131 | tlgmn_arr_delayreason | varchar | Specifies the arrival delay reason |
| 132 | tlgmn_dep_delaycode | varchar | Specifies the departure delay code |
| 133 | tlgmn_dep_delayreason | varchar | Specifies the departure delay reason |
| 134 | TLGMN_REP_NAME | varchar | Specifies the CRA sign off representative name |
| 135 | TLGMN_REP_SIGN | Char | Specifies the CRA sign off representative sign |
| 136 | TLGMN_REP_DATETIME | varchar | Specifies the CRA sign off date and time |
| 137 | TLGMN_SUPPLIER_NO | varchar | Specifies the supplier number |
| 138 | TLGMN_AMEND_FLAG | varchar | Specifies the amend flag |
| 139 | TLGMN_AMEND_date | datetime | Specifies the AMEND date |
| 140 | TLGMN_AMENDedby | varchar | Specifies the user who amended |
| 141 | tlgmn_accesstime_hrs | int | Specifies the access time in hours |
| 142 | tlgmn_accesstime_min | int | Specifies the access time in minutes |
| 143 | tlgmn_at_modreason | varchar | Specifies the reason for modification |
| 144 | tlgmn_addldtls1 | varchar | Specifies additional details 1 |
| 145 | tlgmn_addldtls2 | varchar | Specifies additional details 2 |
| 146 | tlgmn_addldtls3 | varchar | Specifies additional details 3 |
| 147 | TLGMN_cust_RefDocNo | varchar | Specifies customer reference document number |
| 148 | tlgmn_planid | Bigint | Specifies the planner ID |
| 149 | tlgmn_roster_grp | varchar | Specifies the roster group code |
| 150 | TLGMN_USER_DEFINED1 | varchar | Specifies user defined data 1 |
| 151 | TLGMN_USER_DEFINED2 | varchar | Specifies user defined data 2 |
| 152 | TLGMN_USER_DEFINED3 | datetime | Specifies user defined data 3 |
| 153 | tlgmn_sch_opt | varchar | Specifies required data for scheduling optimization |
| 154 | tlgmn_skill_effciency | numeric | Specifies the skill efficiency |
Relationships (10)
CONTAINS_TASK→ Task (FLOG_TLGWU_WORK_UNIT_DTL) (no automatic join)- Package contains task work units
HAS_CERTIFICATE→ CertificateOfMaintenance (FLOG_TLGCOM_TECH_COM_DTL)- Join:
FLOG_TLGMN_TECH_LOG_HDR.TLGMN_TECHLOG_NO = FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_TechLog_No - Package has certificate of maintenance
- Join:
BELONGS_TO_OU→ OrganizationUnit (—) (no automatic join)- Package belongs to organization unit
FOR_AIRCRAFT→ Aircraft (AC_ACI_AIRCRAFT_INFO)- Join:
FLOG_TLGMN_TECH_LOG_HDR.TLGMN_AIRCRAFT_REG_NO = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO - AME Package is for a specific aircraft
- Join:
AT_STATION→ Station (CM_STNDTL_STATION_DTL)- Join:
FLOG_TLGMN_TECH_LOG_HDR.TLGMN_FROM_STATION = CM_STNDTL_STATION_DTL.STNDTL_STATION - AME Package executed at station
- Join:
AT_WORK_CENTER→ Workcenter (BAS_WCLOG_WC_LOGICAL_WC_DTL)- Join:
FLOG_TLGMN_TECH_LOG_HDR.TLGMN_WORK_CENTER = BAS_WCLOG_WC_LOGICAL_WC_DTL.WCLOG_WORK_CENTER - AME Package executed at workcenter
- Join:
- DefDiscResolution (FLOG_DFDPRSL_DEF_DISC_RESOL) →
RESOLVED_BY_AME(this table is target)- Join:
FLOG_DFDPRSL_DEF_DISC_RESOL.DFDPRSL_TECHLOG_NO = FLOG_TLGMN_TECH_LOG_HDR.TLGMN_TECHLOG_NO - Deferred discrepancy resolved by AME Package
- Join:
HAS_COMPONENT_REPLACEMENT→ COMPONENT_REPLACEMENT (BAS_CR_CRD_COMP_REPL_DTL) (no automatic join)- Package has component replacement records
HAS_CUSTOMER_ORDER→ CustomerOrder (—) (no automatic join)- AME Package having customer order reference
FOR_CUSTOMER→ Customer (Cu_CMH_Cust_Master_Hdr)- Join:
FLOG_TLGMN_TECH_LOG_HDR.tlgmn_cust_no = Cu_CMH_Cust_Master_Hdr.CMH_Cust_No - AME Package having customer reference
- Join:
Sample rows (from live DB)
TLGMN_SLFSRC_OUINSTANCE | TLGMN_TECHLOG_CATEGORY | TLGMN_ACT_ARRIVAL_DATETIME | TLGMN_UTC_ACT_ARR_DATETIME | TLGMN_CONFIRMED_BY | TLGMN_CONFIRMED_DATE |
|---|---|---|---|---|---|
| 2.0 | 1-Repair | — | — | — | — |
| 2.0 | 1-Repair | — | — | — | — |
| 2.0 | — | — | — | — | — |
Showing 3 of 5,736 rows.