SWO_Visit_Lvl_Info
Visit level header detail
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Captures hierarchical information of a shop visit at different levels, supporting structured tracking of tasks, components, and configurations
This table is the canonical store for the VisitPackage entity.
Primary key
VLI_DocUnique_id
Columns (36)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | VLC_ConfigError | varchar | Flags any configuration errors for attention. |
| 2 | VLI_Component | varchar | Identifies the component being referenced. |
| 3 | VLI_ConfigStatus | varchar | Tracks the status of the component configuration. |
| 4 | VLI_created_By | datetime | Identifies the user who created the visit reference record. |
| 5 | VLI_created_date | varchar | Records the date when the visit reference was created. |
| 6 | VLI_Document_No | bigint | Unique identifier for the visit reference. |
| 7 | VLI_DocUnique_id 🔑 | varchar | Provides a distinct identifier for the record. |
| 8 | VLI_Modified_By | datetime | Identifies the user who last modified the visit reference. |
| 9 | VLI_Modified_date | int | Records when the visit reference was last updated. |
| 10 | VLI_Ou_instance | varchar | Captures the organizational unit instance associated with the record. |
| 11 | VLI_Part_No | varchar | Identifies the part number of the component. |
| 12 | VLI_Ref_Document | varchar | References a related document for the component. |
| 13 | VLI_Ref_Doc_Type | varchar | Indicates the type of reference document. |
| 14 | VLI_Serial_No | varchar | Identifies the serial number of the component. |
| 15 | VLI_status | varchar | Indicates the current status of the component. |
| 16 | VLI_Target_prt | varchar | Identifies the target part number for the component. |
| 17 | VLI_thrustrat_code | int | Indicates the thrustrating code for tracking. |
| 18 | VLI_Timestamp | varchar | Records the timestamp of the record. |
| 19 | VLC_ConfigError | varchar | Configuration error for the Visit reference |
| 20 | VLI_Component | varchar | Component for the Visit reference |
| 21 | VLI_ConfigStatus | varchar | Configuration status for the Visit reference |
| 22 | VLI_created_By | datetime | Created by for the Visit reference |
| 23 | VLI_created_date | varchar | Creation date for the Visit reference |
| 24 | VLI_Document_No | bigint | Visit reference number |
| 25 | VLI_DocUnique_id 🔑 | varchar | Unique ID for the Visit reference |
| 26 | VLI_Modified_By | datetime | Modified by for the Visit reference |
| 27 | VLI_Modified_date | int | Modified date for the Visit reference |
| 28 | VLI_Ou_instance | varchar | Organization unit instance for the Visit reference |
| 29 | VLI_Part_No | varchar | Part number for the Visit reference |
| 30 | VLI_Ref_Document | varchar | Reference document for the Visit reference |
| 31 | VLI_Ref_Doc_Type | varchar | Reference document type for the Visit reference |
| 32 | VLI_Serial_No | varchar | Serial number for the Visit reference |
| 33 | VLI_status | varchar | Status of the Visit reference |
| 34 | VLI_Target_prt | varchar | Target part number for the Visit reference |
| 35 | VLI_thrustrat_code | int | Thrustrating code for the Visit reference |
| 36 | VLI_Timestamp | #N/A | Timestamp of the Visit reference |
Relationships (6)
VISIT_FOR_SWO→ ShopWorkOrder (swo_swoh_shop_wo_hdr)- Join:
SWO_Visit_Lvl_Info.visit_id = swo_swoh_shop_wo_hdr.swoh_eventid - Visit package for shop work order
- Join:
VISIT_HAS_CONFIG→ VisitConfig (SWO_Visit_Lvl_Cmp_config)- Join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_Lvl_Cmp_config.VSC_unique_id - Visit has configuration
- Join:
VISIT_HAS_BASELINE→ VisitBaselineConfig (SWO_Visit_Lvlb_Cmpb_config)- Join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_Lvlb_Cmpb_config.VSBC_unique_id - Visit has baseline configuration
- Join:
VISIT_HAS_COMPLETION→ VisitCompletion (swo_visit_cmpl_dtl)- Join:
SWO_Visit_Lvl_Info.visit_id = swo_visit_cmpl_dtl.vcp_uniqueid - Visit has completion record
- Join:
VISIT_HAS_PLAN_EO→ VisitPlanEO (swo_visit_plan_eo_dtl) (no automatic join)- Visit has planned EO
VISIT_HAS_LLP_INFO→ VisitLLPInfo (SWO_Visit_LLP_Info)- Join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_LLP_Info.VLLP_Component_ID - Visit has LLP information
- Join:
Sample rows (from live DB)
VLC_ConfigError | VLI_Component | VLI_ConfigStatus | VLI_created_By | VLI_created_date | VLI_Document_No |
|---|---|---|---|---|---|
| — | C005048-2022 | Pending Confirmation | — | — | visitdoc-001 |
| — | 00DQFC | Pending Confirmation | — | — | vhub1test |
| — | A104254 | Pending Confirmation | DMUSER | 2022-03-26 18:14:58.263 | VH-000001-2022 |
Showing 3 of 3,567 rows.