Wiki·ontology·ontology/swotask.md

SWOTask

A task inside a shop work order — what needs to be done to repair the component. Keyed by swostk_task_track_id.

Canonical table: swo_swostk_sub_task_details · Key column: swostk_task_track_id

Example record

  • swostk_task_track_id: 55783
  • swostk_swo_no: OWO-000371-2013
  • swostk_seq_no: 1
  • swostk_ouinstance: 2
  • swostk_sub_task_desc: Default Workcoping
  • swostk_resource_group: NREQ
  • swostk_recorded_by: —
  • swostk_reported_by: —

Outgoing relationships (15)

  • SWO_HAS_PARAM → TaskParam
    • via swo_swostk_sub_task_details.swostk_swo_no = swo_swoprm_task_param_det.swoprm_swo_no
    • SWO task has parameters
  • SWO_HAS_OBSERVATION → SWOObservation
    • via swo_swostk_sub_task_details.swostk_swo_no = swo_swoobs_observation_list.swoobs_swo_no
    • SWO task has observations
  • SWO_HAS_CHILD_DISC → ChildDiscrepancy (no automatic join)
    • SWO task has child discrepancies
  • SWO_HAS_EO_RELATED → EORelatedTask (no automatic join)
    • SWO task has EO related tasks
  • TASK_HAS_AMEND_DETAIL → TaskAmendDetail (no automatic join)
    • SWO task has amendment detail
  • TASK_HAS_AMEND_POSITION → AmendTaskPos
    • via swo_swostk_sub_task_details.swostk_swo_no = swo_wsati_amend_task_pos_dtl.wsatipos_swo_no
    • SWO task has amendment position
  • SWO_HAS_SUBTASK → SWOSubTask (no automatic join)
    • SWO task has subtasks
  • SWO_HAS_PART → SWOPartDetail
    • via swo_swostk_sub_task_details.swostk_task_track_id = swo_swoprt_part_details.swoprt_task_track_id
    • SWO task has part details
  • SWO_HAS_RESOURCE → SWOResourceDetail (no automatic join)
    • SWO task has resource details
  • SWO_HAS_CHARGE → ChargeDetail
    • via swo_swostk_sub_task_details.swostk_task_track_id = swo_swocrg_charge_details.swocrg_task_track_id
    • SWO task has charge details
  • SWO_HAS_EMP_ACTUAL → SWOEmpActuals (no automatic join)
    • SWO task has employee actuals
  • SWO_TASK_ADDITIONAL → TaskAdditionalDtl
    • via swo_swostk_sub_task_details.swostk_task_track_id = swo_swotad_shop_wo_tsk_addl_dtl.swotad_task_track_id
    • SWO task has additional details
  • SWO_HAS_DISCREPANCY → SWODiscrepancy
    • via swo_swostk_sub_task_details.swostk_swo_no = swo_swodes_discrepancy_list.swodes_swo_no
    • SWO task has discrepancies
  • SWO_HAS_PART_TAG → PartTag
    • via swo_swostk_sub_task_details.swostk_swo_no = swo_swoptg_part_tag_list.swoptg_swo_no
    • Task has part tags
  • SWO_HAS_PREF_SERIAL → PrefSerialNo
    • via swo_swostk_sub_task_details.swostk_task_track_id = swo_swopsl_prefserlno_dtl.swopsl_task_track_id
    • Task has preferred serial numbers

Incoming relationships (1)

  • ShopWorkOrder → SWO_CONTAINS_TASK
    • via swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swostk_sub_task_details.swostk_swo_no

See also