Flog_TLgITM_Emp_Idir_Work_Hrs
Stores indirect booking hours logged by employees against Aircraft Maintenance Execution (AME) packages. Supports monitoring of non-direct labor allocation.
Process: LINEMAINTENANCE · Component: BasFltLog · Table type: Transaction Table Category: Groups the tables related to indirect and actual work hours logged against Aircraft Maintenance Execution ( AME ) packages task
This table is the canonical store for the IndirectTimeBooking entity.
Primary key
TLgITM_OuInstance, TLgITM_Employee_No, TLgITM_Line_No
Columns (17)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLgITM_OuInstance 🔑 | int | Source organization unit to which the current logged in organization unit is interacting. |
| 2 | TLgITM_Employee_No 🔑 | varchar | Employee who reported the indirect hours |
| 3 | TLgITM_Line_No 🔑 | int | Line number of the Aircraft Maintenance Execution ( AME ) package for indirect hours booking |
| 4 | TLgITM_Start_DateTime | datetime | Start DateTime for indirect hours booking |
| 5 | TLgITM_End_DateTime | datetime | End DateTime for indirect hours booking |
| 6 | TLgITM_Category | Varchar | Stores the category of indirect hours (e.g., Classroom, Doc Control, ERP) for AME packages to classify and analyze non-direct work activities |
| 7 | TLgITM_Dur_Hours | numeric | Duration of indirect hours booking |
| 8 | TLgITM_Comments | varchar | Comments recorded by employee |
| 9 | TLgITM_Upd_Mode | varchar | Stores the update mode used for logging indirect booking hours against Aircraft Maintenance Execution (AME) packages. It indicates whether the entry was recorded via clock in or out ( CLK ) or entered manually ( MNL )… |
| 10 | TLgiTM_Crt_Ou | int | The organization unit in which the in-direct hours are recorded |
| 11 | TLGITM_ATTEN_TYPE | varchar | Stores the attendance type associated with indirect booking hours logged against Aircraft Maintenance Execution (AME) packages. Used to classify bookings as Normal, Extra Time, Field Pay, Normal Time, or Overtime, ens… |
| 12 | TLGITM_TMSHT_STATUS | varchar | stores the timesheet status ( AU ) Authorized, ( CF ) Confirmed, ( FR ) Fresh, (NR) Not Required for indirect booking hours in Aircraft Maintenance and Exceution( AME ) packages, ensuring proper validation and appro… |
| 13 | TLGITM_PRM_SKILL | varchar | Stores the Primary skill of the employee |
| 14 | tlgitm_updated_by | varchar | The user who updated the in direct hours |
| 15 | tlgitm_updated_remarks | varchar | Remarks provided by the user who updated the in direct hours booking |
| 16 | tlgitm_updated_datetime | datetime | Date and Time at which the in direct hours booking is updated |
| 17 | TLgITM_Tabooking_id | Bigint | Stores the indirect booking reference ID for Time & Attendance (T and A) in Aircraft Maintenance and Execution packages, ensuring linkage and traceability of non direct labor hours |
Relationships (1)
- Employee (—) →
LOGGED_INDIRECT_TIME(this table is target) (no automatic join)- Employee logged indirect time
Sample rows (from live DB)
TLgITM_OuInstance | TLgITM_Employee_No | TLgITM_Line_No | TLgITM_Start_DateTime | TLgITM_End_DateTime | TLgITM_Category |
|---|---|---|---|---|---|
| 2 | 00000001 | 29 | 2020-02-28 12:24:00.000 | 2020-03-17 13:39:18.000 | Meeting |
| 2 | 00000001 | 30 | 2020-05-26 12:34:57.050 | 2020-05-26 13:35:46.037 | Meeting |
| 2 | 00000001 | 31 | 2020-05-26 07:00:00.000 | 2020-05-26 09:00:00.000 | Training |
Showing 3 of 145 rows.