Wiki·ontology·ontology/visitpackage.md

VisitPackage

A visit package — a planned base visit (e.g., C-check) with multiple tasks bundled together across a multi-day event.

Canonical table: SWO_Visit_Lvl_Info · Key column: visit_id

Example record

  • VLI_DocUnique_id: -2147483648
  • VLI_Ou_instance: 2
  • VLI_Component: C005048-2022
  • VLI_Document_No: visitdoc-001
  • VLI_Ref_Document: AWO-000004-2011
  • VLI_Ref_Doc_Type: UT-Test
  • VLI_created_date: —
  • VLI_created_By: —

Outgoing relationships (6)

  • VISIT_FOR_SWO → ShopWorkOrder
    • via SWO_Visit_Lvl_Info.visit_id = swo_swoh_shop_wo_hdr.swoh_eventid
    • Visit package for shop work order
  • VISIT_HAS_CONFIG → VisitConfig
    • via SWO_Visit_Lvl_Info.visit_id = SWO_Visit_Lvl_Cmp_config.VSC_unique_id
    • Visit has configuration
  • VISIT_HAS_BASELINE → VisitBaselineConfig
    • via SWO_Visit_Lvl_Info.visit_id = SWO_Visit_Lvlb_Cmpb_config.VSBC_unique_id
    • Visit has baseline configuration
  • VISIT_HAS_COMPLETION → VisitCompletion
    • via SWO_Visit_Lvl_Info.visit_id = swo_visit_cmpl_dtl.vcp_uniqueid
    • Visit has completion record
  • VISIT_HAS_PLAN_EO → VisitPlanEO (no automatic join)
    • Visit has planned EO
  • VISIT_HAS_LLP_INFO → VisitLLPInfo
    • via SWO_Visit_Lvl_Info.visit_id = SWO_Visit_LLP_Info.VLLP_Component_ID
    • Visit has LLP information

See also