FLOG_TLGEA_EMP_ACTUALS_DTL
Maintains actual timesheet entries of employees working on Aircraft Maintenance Execution (AME) packages. Captures hours, employee IDs, and task references for accurate work tracking.
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
Primary key
TLGEA_SLFSRC_OUINSTANCE, TLGEA_TECHLOG_NO, TLGEA_KEY_SEQ_NO
Columns (46)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | TLGEA_SLFSRC_OUINSTANCE 馃攽 | #N/A | Source organization unit to which the current logged-in organization unit is interacting. |
| 2 | TLGEA_TECHLOG_NO 馃攽 | varchar | Aircraft Maintenance and Execution ( AME ) Package for which the employee actuals are recorded |
| 3 | TLGEA_KEY_SEQ_NO 馃攽 | #N/A | Running sequence for employee actuals for the correspondingAircraft Maintenance and Execution ( AME ) package. |
| 4 | TLGEA_CRT_OU | #N/A | Organization unit in which the employee actual bookings are done. |
| 5 | TLGEA_EMP_OU | #N/A | Organization unit in which the employee is defined. |
| 6 | TLGEA_EMP_NO | varchar | Stores the unique employee code used in Aircraft Maintenance and Execution ( AME ) |
| 7 | TLGEA_ACT_FROM_DATETIME | datetime | Actual From DateTime for Time booking |
| 8 | TLGEA_ACT_TO_DATETIME | datetime | Actual To DateTime for Time booking |
| 9 | TLGEA_ACT_DURN_HRS | numeric | Stores the actual duration of hours booked by employees |
| 10 | TLGEA_EMP_COMMENTS | varchar | Stores employee remarks added during timesheet booking |
| 11 | TLGEA_CREATED_BY | varchar | Timesheet booking done by the employees |
| 12 | TLGEA_CREATED_DATETIME | datetime | Timesheet Booking Created Date and Time |
| 13 | TLGEA_MODIFIED_BY | varchar | Tracks the user who last modified a timesheet entry |
| 14 | TLGEA_MODIFIED_DATETIME | datetime | Stores the date and time of the last modification to a timesheet entry, |
| 15 | TLGEA_TIMESTAMP | #N/A | Captures the system timestamp for timesheet booking details |
| 16 | TLGEA_UPDATE_MODE | varchar | Indicates time booking update method like clock , and manual |
| 17 | TLGEA_BREAK_HRS | numeric | Records employee break hours during time booking.or time booking |
| 18 | TLGEA_ACT_INDIR_HRS | numeric | Captures actual indirect hours worked by an employee |
| 19 | TLGEA_ATTEN_TYPE | varchar | Stores the type of employee attendance for time booking, such as Normal, Extra Time, Field Pay, Normal Time, or Overtime, to classify work hours accurately |
| 20 | TLGEA_TMSHT_STATUS | varchar | Records the Time Sheet Status AU Authorized, ( CF ) Confirmed( FR ) Fresh,( NR ) Not Required |
| 21 | TLGEA_PRM_SKILL | varchar | Stores the Primary Skill for Employee |
| 22 | TLGEA_TASK_NO | varchar | Captures the Task Number Reference |
| 23 | TLGEA_TASK_SEQ | int | Task Sequence Reference |
| 24 | TLGEA_TASK_OU | int | Stores the details of the Task Organizational Unit Instance for Timebooking |
| 25 | TLGEA_ACT_RATE | numeric | Actual Rate for a hour |
| 26 | TLGEA_ACT_COST | numeric | Actual Cost for Employee booked details |
| 27 | TLGEA_WC_CODE | varchar | Work center details |
| 28 | TLGEA_STATION | varchar | Cointains the Station details |
| 29 | TLGEA_TILLDATE_TIME | datetime | Stored the end duration with Date and Time |
| 30 | TLGEA_BILLABLE | varchar | Billable Accoutable for Invoice |
| 31 | TLGEA_UTC_FROM_DATETIME | datetime | Indicates if booked hours are billable and accountable for invoicing. |
| 32 | TLGEA_UTC_TO_DATETIME | datetime | tores UTC server timestamp for actual work start. |
| 33 | tlgea_updated_remarks | varchar | Stores UTC server timestamp for actual work end |
| 34 | tlgea_updated_datetime | datetime | Captures employee remarks entered during updates |
| 35 | tlgea_updated_by | varchar | Date and time when booking details were last updated |
| 36 | TLGEA_TASK_Track_id | bigint | Identifier for tracking assigned tasks |
| 37 | tlgea_booking_id | Bigint | Unique tracking ID for each time booking entry |
| 38 | tlgea_cost_center | varchar | Finance cost center associated with the work |
| 39 | tlgea_fin_postingDone | varchar | Flag indicating whether finance posting is completed |
| 40 | tlgea_fromlocation | varchar | Source location linked to the booking |
| 41 | tlgea_ref_bookcode | Bigint | Reference book code for finance/accounting linkage |
| 42 | tlgea_subtask_id | Bigint | Identifier for tracking sub-tasks under a main task |
| 43 | tlgea_tolocation | varchar | Destination location linked to the booking |
| 44 | tlgea_analysiscode | Char | Finance/analysis code for reporting and cost allocation. |
| 45 | tlgea_subanalysiscode | Char | Sub-level analysis code for detailed finance tracking |
| 46 | tlgea_financebook | varchar | Finance account book details linked to the booking. |
Sample rows (from live DB)
TLGEA_SLFSRC_OUINSTANCE | TLGEA_TECHLOG_NO | TLGEA_KEY_SEQ_NO | TLGEA_CRT_OU | TLGEA_EMP_OU | TLGEA_EMP_NO |
|---|---|---|---|---|---|
| 2.0 | LC-000004-2019 | 2.0 | 2.0 | 2.0 | 00000007 |
| 2.0 | LC-000004-2019 | 3.0 | 2.0 | 2.0 | 00000007 |
| 2.0 | LC-000004-2019 | 4.0 | 2.0 | 2.0 | 00000007 |
Showing 3 of 4,487 rows.