SWO_Visit_Lvlb_Cmpb_cfg_dtl

Visit Ref Baselined Component Configuration Details

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Contains detailed configuration information about level-based component builds (CMPB) for a shop visit, ensuring accurate assembly and maintenance records

Primary key

VSBD_unique_id

Columns (149)

#	Column	Type	Description
1	`VDT_Document_No`	varchar	Reference number of the related maintenance visit
2	`VSBD_Accept_Reference`	varchar	Reference details linked to acceptance records
3	`vsbd_ActAttch_Comp`	varchar	Identifier of the actual attached component
4	`vsbd_ActAttch_Disc_CAt`	varchar	Category of the actual discrepancy attached to the record
5	`vsbd_ActAttch_Disc_Sts`	varchar	Status of the actual discrepancy attached to the record
6	`vsbd_ActAttch_Prt`	varchar	Part number of the actual attached component
7	`vsbd_ActAttch_Qty`	int	Quantity of the actual attached component
8	`vsbd_ActAttch_Srl`	varchar	Serial number of the actual attached component
9	`vsbd_ActAttch_Sts`	varchar	Status of the actual attached component
10	`VSBD_ActFndDisasmbld`	varchar	Indicates whether the component was actually found disassembled
11	`VSBD_addl_remarks`	varchar	Additional remarks recorded for the configuration
12	`VSBD_alt_type`	varchar	Specifies the alternate type associated with the component
13	`VSBD_aprj_rem`	varchar	Remarks recorded during approval or rejection of the record
14	`VSBD_AssmGrp`	varchar	Group identifier associated with the assembly
15	`VSBD_ATA`	varchar	ATA chapter number linked to the component or record
16	`VSBD_Attached_Part`	varchar	Part number of the attached component
17	`VSBD_Attached_serial`	varchar	Serial number of the attached component
18	`VSBD_Attached_Status`	varchar	Status of the attached component
19	`VSBD_ATTACH_dATE`	datetime	Date when the component was attached
20	`VSBD_Att_Discp_status`	varchar	Status of the discrepancy of the attached component
21	`VSBD_Base_Part`	varchar	Unique base part number associated with the configuration
22	`VSBD_Baslined_flag`	varchar	Flag indicating whether the configuration has been baselined
23	`VSBD_Certificate_Date`	datetime	Date of issue of the certificate
24	`VSBD_Certificate_No`	varchar	Unique certificate number issued
25	`VSBD_Certificate_Type`	varchar	Type of certificate linked to the component or configuration
26	`VSBD_Cfg_change_Status`	varchar	Current status of the configuration change applied
27	`VSBD_Changeinfo`	varchar	Information about the change made to the configuration
28	`vsbd_chldexst_flag`	varchar	Flag indicating if a child component exists for the record
29	`VSBD_cmplupd`	varchar	Date of the latest compliance update for the record
30	`VSBD_Cnfg_Flag`	varchar	Indicates whether the configuration flag has been applied
31	`VSBD_comments`	varchar	Comments recorded for the record
32	`VSBD_Component`	varchar	Identifier of the component in the record
33	`VSBD_Comp_Mandatory`	varchar	Indicates whether the component is mandatory
34	`VSBD_cond_crit`	varchar	Specifies the critical condition of the component
35	`VSBD_CONFIGEXEP`	varchar	Status of the configuration record
36	`VSBD_Configstatus`	varchar	Status of the configuration record
37	`VSBD_Config_Change_Flag`	varchar	Flag indicating whether a configuration change has been applied
38	`VSBD_Config_Created_By`	varchar	User who created the configuration
39	`VSBD_Config_Created_Date`	datetime	Date when the configuration was created
40	`VSBD_Config_Modified_By`	varchar	User who modified the configuration
41	`VSBD_Config_Modified_Date`	datetime	Date when the configuration was last modified
42	`VSBD_Config_Revision`	varchar	Revision number of the configuration
43	`VSBD_Config_TimeStamp`	int	System timestamp when the configuration was recorded
44	`VSBD_CR`	varchar	Identifier of the component replacement
45	`VSBD_critical`	varchar	Indicates whether the component is marked as critical
46	`vsBd_Crr`	varchar	Revision request number linked to the configuration
47	`VSBD_CR_Flag`	varchar	Indicates whether a replacement has been applied for the component
48	`VSBD_CR_Type`	varchar	Specifies the type of replacement performed
49	`VSBD_CSN`	numeric	Represents the cycles since new value of the component
50	`VSBD_Discp_Category`	varchar	Category of discrepancy linked to the record
51	`VSBD_Discp_Notes`	varchar	Notes describing the discrepancy linked to the record
52	`VSBD_Display_Seq`	int	Sequence number used to display the record
53	`VSBD_DISPLEVELCOCE`	varchar	Level code used for display hierarchy
54	`VSBD_Document_No`	varchar	Document number assigned to uniquely identify the document
55	`VSBD_Doc_Revision`	varchar	Revision number of the document indicating version control
56	`VSBD_Drawing`	varchar	Drawing reference linked to the component or assembly
57	`VSBD_EIPN_Comp`	varchar	Unique identifier assigned to the component
58	`VSBD_EIPN_Part`	varchar	Number assigned to identify a part
59	`VSBD_EIPN_Serial`	varchar	Unique serial number assigned to the part or equipment
60	`VSBD_Eqp_Cat`	varchar	Category of the equipment such as engine airframe or avionics
61	`VSBD_Eqp_Group`	varchar	Group classification of the equipment for organizational purposes
62	`VSBD_Error_Msg`	varchar	Details of the error message encountered
63	`VSBD_FC`	varchar	Number of flight cycles completed by the equipment or component
64	`VSBD_FH`	varchar	Total number of flight hours recorded for the equipment
65	`VSBD_FileName`	varchar	Name of the associated file stored in the system
66	`VSBD_FndDisasmbld`	varchar	Indicates whether the part or component was found in a disassembled condition
67	`vsbd_Idnt_Changes`	varchar	Information regarding changes made to the identification of the component
68	`VSBD_Induction_DateTime`	datetime	Date and time when the component was inducted into the process
69	`VSBD_Installed_Component`	varchar	Identifier of the installed component
70	`VSBD_Installed_Condition`	varchar	Condition of the component when it was installed
71	`VSBD_Installed_MSN`	varchar	Manufacturer serial number of the installed equipment
72	`VSBD_Installed_Part`	varchar	Part number of the installed component
73	`VSBD_Installed_Serial`	varchar	Serial number of the installed component
74	`VSBD_InstQty`	int	Quantity of components installed
75	`VSBD_Interchang_Rule`	varchar	Defined rule for determining interchangeability of components
76	`VSBD_ISSNOTES`	varchar	Notes or remarks provided at the time of issuance
77	`VSBD_KeyNo`	int	Unique key number assigned for identification or tracking
78	`VSBD_last_impacted_eo`	varchar	Number of the last impacted engineering order associated with the component
79	`VSBD_last_impacted_eo_rev`	varchar	Revision number of the last impacted engineering order
80	`VSBD_Level_Code`	varchar	Code representing the hierarchical level of the component
81	`VSBD_Level_No`	varchar	Numeric level representing the position in the assembly hierarchy
82	`VSBD_LLP`	varchar	Indicates if the component is classified as a life limited part
83	`VSBD_MAXQTY`	numeric	Maximum allowed quantity of the component in the configuration
84	`VSBD_Mfr_DateTime`	datetime	Date and time of manufacturing for the component
85	`VSBD_MINQTY`	numeric	Minimum allowed quantity of the component in the configuration
86	`VSBD_NHALEVEL_CODE`	varchar	Level code of the next higher assembly
87	`VSBD_NHAPOSCODE`	varchar	Position code within the next higher assembly
88	`VSBD_NHA_Component`	varchar	Identifier of the next higher assembly component
89	`VSBD_NHA_EMPTY_POS`	varchar	Indicates if the next higher assembly has an empty position
90	`VSBD_NHA_Part`	varchar	Part number of the next higher assembly component
91	`VSBD_NHA_Serial`	varchar	Serial number of the next higher assembly component
92	`vsBd_orig_position_part`	varchar	Original position part number in the assembly
93	`vsBd_ori_installed_part`	varchar	The part that was originally installed in the assembly
94	`VSBD_Ori_Position_Code`	varchar	Code of the original position in the configuration
95	`VSBD_Ori_Position_Part`	varchar	Part number of the original position part
96	`VSBD_Ou_instance`	int	Organizational unit instance linked to the component or document
97	`VSBD_Ownership`	varchar	Indicates the ownership status of the component or part
98	`VSBD_Owningagency`	varchar	Agency or organization owning the component
99	`VSBD_Parameter_Init`	varchar	Initialization details of defined parameters
100	`VSBD_Parent_Id`	varchar	Identifier of the parent record or component
101	`VSBD_Part_Category`	varchar	Category classification of the part
102	`VSBD_PIECEPART`	varchar	Indicates a piece part within the assembly
103	`VSBD_PiecePrt_Flag`	varchar	Flag to indicate whether the part is a piece part
104	`VSBD_Piece_part`	varchar	Indicates details of piece parts within the configuration
105	`VSBD_PMA_PrtUsg`	varchar	Details of approved usage of parts under PMA (Parts Manufacturer Approval) regulations
106	`VSBD_Position_Code`	varchar	Code assigned to a position in the assembly
107	`VSBD_Position_Formula`	varchar	Formula used to define or calculate position logic
108	`VSBD_Position_Part`	varchar	Part number associated with the position
109	`VSBD_Position_Part_Desc`	varchar	Description of the position part in the assembly
110	`VSBD_Position_Status`	varchar	Status of the assigned position in the assembly
111	`VSBD_Position_Type`	varchar	Type of position within the assembly hierarchy
112	`VSBD_POSMOD`	varchar	Modification details of the position
113	`VSBD_Pos_Modifcation_Cat`	varchar	Category of the position modification performed
114	`VSBD_Pos_Modificiation_Remarks`	varchar	Remarks provided for the position modification
115	`VSBD_PPCMKYSQ`	int	Sequence number assigned to the piece part
116	`VSBD_Reason`	varchar	Reason recorded for an action or change
117	`VSBD_Recorded_By`	varchar	User who recorded the entry
118	`VSBD_RECUSEENGDISP`	varchar	Disposition for recurring usage of the component
119	`VSBD_RefQty`	int	Reference quantity associated with the part or assembly
120	`VSBD_Ref_Document`	varchar	Document referenced for additional details
121	`VSBD_Remarks`	varchar	Remarks or notes associated with the entry
122	`VSBD_Removal_Time`	datetime	Time of component removal
123	`VSBD_removedby`	varchar	User who performed the removal
124	`VSBD_Removed_Cond`	varchar	Condition of the part at the time of removal
125	`VSBD_Removed_Condition`	varchar	Additional condition details for the removed part
126	`VSBD_Removed_Type`	varchar	Type of component removed
127	`VSBD_Rem_dispotion`	varchar	Disposition of the remaining component or assembly
128	`VSBD_Rem_Type`	varchar	Type of remaining component or assembly
129	`VSBD_ReNumber_Flag`	varchar	Indicates whether a renumbering operation has been performed
130	`VSBD_Replacement_DateTime`	datetime	Date and time when the replacement was performed
131	`VSBD_replacement_type`	varchar	Type of replacement carried out
132	`VSBD_REPLPRTCOND`	varchar	Condition of the replacement part
133	`VSBD_REQTST`	varchar	Status of the request associated with the component or document
134	`VSBD_REQ_FOR`	varchar	Specifies what the component is required for
135	`VSBD_Selected`	varchar	Indicates whether the component or record was selected
136	`VSBD_Station`	varchar	Station location associated with the component or work order
137	`VSBD_StockStatus`	varchar	Current stock status of the component
138	`VSBD_SWO_No`	varchar	Number of the shop work order linked to the record
139	`VSBD_Template_Part`	varchar	Template part used for standardization in configuration
140	`VSBD_TRGTBLDUPVAL`	numeric	Target buildup value defined for the component
141	`VSBD_TSN`	numeric	Time since new value representing usage history of the component
142	`VSBD_unique_id` 🔑	bigint	Unique identifier of the record
143	`VSBD_User_defined1`	varchar	Custom user defined field one for additional data
144	`VSBD_User_defined2`	varchar	Custom user defined field two for additional data
145	`VSBD_User_defined3`	varchar	Custom user defined field three for additional data
146	`VSBD_User_defined4`	varchar	Custom user defined field four for additional data
147	`VSBD_User_defined5`	datetime	Custom user defined field five for additional data
148	`VSBD_User_defined6`	datetime	Custom user defined field six for additional data
149	`VSBD_Zone`	varchar	Zone or area associated with the component or work order

Sample rows (from live DB)

`VDT_Document_No`	`VSBD_Accept_Reference`	`vsbd_ActAttch_Comp`	`vsbd_ActAttch_Disc_CAt`	`vsbd_ActAttch_Disc_Sts`	`vsbd_ActAttch_Prt`
—	—	—	—	—	—
—	—	—	—	—	—
—	—	—	—	—	—

Showing 3 of 42,116 rows.

SWO_Visit_Lvlb_Cmpb_cfg_dtl

Primary key

Columns (149)

Sample rows (from live DB)

See also