Wiki·ontology·ontology/subtask.md

SubTask

A step inside a task (typically mapping to a specific maintenance action or inspection). Keyed by TLGSBTSK_SUBTsk_Uniqueid.

Canonical table: FLOG_TLGWU_SUBTSK_DTL · Key column: TLGSBTSK_SUBTsk_Uniqueid

Example record

  • TLGSBTSK_Ouinstance: 2
  • TLGSBTSK_SUBTsk_Uniqueid: -2147482711
  • TLGSBTSK_TechlogNo: LP-000787-2020
  • TLGSBTSK_WU_Trackid: 87276
  • TLGSBTSK_WU_SeqNo: 1
  • TLGSBTSK_SUBTask_Desc: efv
  • TLGSBTSK_Createddate: 2020-10-12 16:57:05.673
  • TLGSBTSK_Createdby: DMUSER

Outgoing relationships (1)

  • SUBTASK_HAS_SIGNOFFSubTaskSignOff
    • via FLOG_TLGWU_SUBTSK_DTL.TLGSBTSK_SUBTsk_Uniqueid = FLOG_TLGSTSO_SUBTSK_SNOFF.TLGSTSO_SUBTSK_Uniqueid
    • Subtask has sign-off record

Incoming relationships (1)

  • TaskHAS_SUBTASK (no automatic join)

See also