Wiki·ontology·ontology/task.md

Task

A unit of maintenance work inside an AME package. Tracked by a TLGWU_TRACK_ID. Tasks have sub-tasks, sign-offs, part consumption, and resource consumption. Historically the central hub of AME execution; in this data drop the headers table is empty, so sign-offs and sub-tasks are read directly by TECHLOG_NO.

Canonical table: FLOG_TLGWU_WORK_UNIT_DTL · Key column: TLGWU_TRACK_ID

Outgoing relationships (13)

  • HAS_SUBTASK → SubTask (no automatic join)
    • Task contains subtasks
  • HAS_SIGNOFF → TaskSignOff
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGTSO_TSK_SNOFF.TLGTSO_WU_Track_id
    • Task has sign-off record
  • HAS_PART_CONSUMPTION → PartConsumption
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGPC_PART_CONSUMP_DTL.TLGPC_TASK_Track_id
    • Task has part consumption records
  • HAS_RESOURCE_CONSUMPTION → ResourceConsumption
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGRC_RES_CONSUMP_DTL.TLGRC_TASK_Track_id
    • Task has resource consumption records
  • ADDITIONAL_SIGNOFF → AdditionalSignOff (no automatic join)
    • Task has additional sign-off
  • HAS_WORK_ASSIGNMENT → WorkAssignment
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_WORK_ASSIGN_DTL.FLOG_TASK_tRACK_ID
    • Task has work assignment
  • HAS_PARAM_UPDATE → ParamUpdateDetail
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = flog_tlgpm_param_upd_dtl.TLGPM_Wu_Track_id
    • Task has parameter update details
  • HAS_EXECUTION_COMMENT → ExecutionComment
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGEC_EXCOMM_HIST.TLGECH_WU_Track_id
    • Task has execution comments
  • HAS_SIGNOFF_COMMENT → SignOffComment
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = FLOG_TLGSC_SOCOMM_HIST.TLGSCH_WU_Track_id
    • Task has sign-off comments
  • HAS_ISSUE_RETURN → IssueReturn
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = fl_tlissret_issue_dtl.TLISSRET_Task_Track_ID
    • Task has issue/return records
  • HAS_BENCH_STOCK → BenchStockConsump
    • via FLOG_TLGWU_WORK_UNIT_DTL.TLGWU_TRACK_ID = flog_rbsc_bench_stk_cons_dtl.rbsc_track_id
    • Task has bench stock consumption
  • HAS_TIME_BOOKING → TimeBooking (no automatic join)
    • Task has time booking records
  • HAS_MATERIAL_REQUEST → MaterialRequest (no automatic join)
    • Task has material request

Incoming relationships (1)

  • AMEPackage → CONTAINS_TASK (no automatic join)

See also