SWO_Visit_Lvlb_Cmpb_config
Visit Ref Baselined Component Configuration Details
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Stores configuration-level information for level-based components, defining setup, compatibility, and maintenance parameters for shop visits
This table is the canonical store for the VisitBaselineConfig entity.
Primary key
VSBC_unique_id
Columns (25)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | VSBC_APPROVEDDATE | Datetime | Date when the record or component was approved |
| 2 | VSBC_APPROVED_BY | varchar | User who approved the record or component |
| 3 | VSBC_Baselined_by | varchar | User who baselined the record or component |
| 4 | VSBC_Baselined_datetime | Datetime | Date and time when the record was baselined |
| 5 | VSBC_BASELINED_FLAG | varchar | Flag indicating whether the baseline process has been completed |
| 6 | VSBC_Baselined_obj_type | varchar | Object type associated with the baseline record |
| 7 | VSBC_Baseline_Object | varchar | Baseline object details associated with the record |
| 8 | VSBC_COMMENTS | varchar | Comments or notes related to the record |
| 9 | VSBC_COMPONENTID | varchar | Unique identifier assigned to the component |
| 10 | VSBC_COMPONENT_OU | int | Organizational unit instance associated with the component |
| 11 | VSBC_CREATED_BY | varchar | User who created the record |
| 12 | VSBC_CREATIONDATE | Datetime | Date when the record was created |
| 13 | VSBC_Document_No | varchar | Visit reference number associated with the component |
| 14 | VSBC_FILE_NAME | varchar | Name of the related file in the system |
| 15 | VSBC_INIT_FILENAME | varchar | Initialized filename stored in the system |
| 16 | VSBC_MODIFIEDDATE | Datetime | Date when the record was modified |
| 17 | VSBC_MODIFIED_BY | varchar | User who last modified the record |
| 18 | VSBC_NO_OF_ATTACHMNT | int | Number of attachments linked to the record |
| 19 | VSBC_NO_OF_POSCODE | int | Number of position codes defined for the component or assembly |
| 20 | VSBC_Ou_instance | int | Organizational unit instance assigned to the component |
| 21 | VSBC_REVNO | varchar | Revision number assigned to the component or document |
| 22 | VSBC_STATUS | varchar | Current status of the component or record |
| 23 | VSBC_TIMESTAMP | int | Timestamp of the record creation or modification |
| 24 | VSBC_unique_id 🔑 | bigint | Unique identifier assigned to the record |
| 25 | VSBD_Doc_Revisiono | varchar | Revision number of the document |
Relationships (1)
- VisitPackage (SWO_Visit_Lvl_Info) →
VISIT_HAS_BASELINE(this table is target)- Join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_Lvlb_Cmpb_config.VSBC_unique_id - Visit has baseline configuration
- Join:
Sample rows (from live DB)
VSBC_APPROVEDDATE | VSBC_APPROVED_BY | VSBC_Baselined_by | VSBC_Baselined_datetime | VSBC_BASELINED_FLAG | VSBC_Baselined_obj_type |
|---|---|---|---|---|---|
| — | — | dmuser | 2022-04-13 16:04:08.920 | BIR | SWO |
| — | — | dmuser | 2022-04-13 16:04:08.920 | BIR | SWO |
| — | — | dmuser | 2022-04-13 16:06:28.313 | BIR | SWO |
Showing 3 of 920 rows.