SWO_Visit_Lvl_Cmp_config
Visit level component configuration
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Stores higher-level configuration data for components installed or modified during a shop visit
This table is the canonical store for the VisitConfig entity.
Primary key
VSC_unique_id
Columns (21)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | VSBD_Doc_Revisiono | datetime | Identifies the revision of the visit reference. |
| 2 | VSC_APPROVEDDATE | varchar | Records the date the component configuration was approved. |
| 3 | VSC_APPROVED_BY | varchar | Identifies the user who approved the component configuration. |
| 4 | VSC_BASELINED_FLAG | varchar | Indicates whether a baseline has been established. |
| 5 | VSC_COMMENTS | varchar | Stores remarks or notes for context. |
| 6 | VSC_COMPONENTID | int | Identifies the engine component involved. |
| 7 | VSC_COMPONENT_OU | varchar | Links the component to its organizational unit instance. |
| 8 | VSC_CREATED_BY | datetime | Identifies the user who created the component record. |
| 9 | VSC_CREATIONDATE | varchar | Records when the component record was created. |
| 10 | VSC_Document_No | varchar | Unique identifier for the maintenance visit. |
| 11 | VSC_FILE_NAME | varchar | Stores the name of a related file or document. |
| 12 | VSC_INIT_FILENAME | datetime | Stores the name of a related file or document. |
| 13 | VSC_MODIFIEDDATE | varchar | Records when the component record was last modified. |
| 14 | VSC_MODIFIED_BY | int | Identifies the user who last modified the record. |
| 15 | VSC_NO_OF_ATTACHMNT | int | Indicates the number of attachments linked to the record. |
| 16 | VSC_NO_OF_POSCODE | int | Indicates the number of position codes linked to the component. |
| 17 | VSC_Ou_instance | varchar | Captures the organizational unit instance linked to the component. |
| 18 | VSC_REVNO | varchar | Tracks the revision number of the component. |
| 19 | VSC_STATUS | int | Indicates the current status of the component. |
| 20 | VSC_TIMESTAMP | bigint | Records the date and time of the record update or creation. |
| 21 | VSC_unique_id 🔑 | varchar | Provides a unique identifier for the record. |
Relationships (2)
- VisitPackage (SWO_Visit_Lvl_Info) →
VISIT_HAS_CONFIG(this table is target)- Join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_Lvl_Cmp_config.VSC_unique_id - Visit has configuration
- Join:
CONFIG_HAS_DETAIL→ VisitConfigDetail (SWO_Visit_Lvl_Cmp_cfg_dtl)- Join:
SWO_Visit_Lvl_Cmp_config.VSC_unique_id = SWO_Visit_Lvl_Cmp_cfg_dtl.VSD_unique_id - Config has detail records
- Join:
Sample rows (from live DB)
VSBD_Doc_Revisiono | VSC_APPROVEDDATE | VSC_APPROVED_BY | VSC_BASELINED_FLAG | VSC_COMMENTS | VSC_COMPONENTID |
|---|---|---|---|---|---|
| — | — | — | Y | — | A109787 |
| — | — | — | Y | — | C005062-2022 |
| — | — | — | Y | — | A109723 |
Showing 3 of 4,988 rows.