SWO_Visit_Lvl_Cmp_cfg_dtl

Visit level component configuration detail

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Provides detailed configuration data of components at specific levels during a shop visit, ensuring proper tracking of installed parts and assemblies

This table is the canonical store for the VisitCfgDetail entity.

Primary key

VSD_unique_id

Columns (155)

#	Column	Type	Description
1	`VSD_Accept_Reference`	varchar	Reference number provided for acceptance
2	`vsd_ActAttch_Comp`	varchar	Identifier of the actual attached component
3	`vsd_ActAttch_Disc_CAt`	varchar	Category of discrepancy for the attached component
4	`vsd_ActAttch_Disc_Sts`	varchar	Status of the attached discrepancy
5	`vsd_ActAttch_Prt`	varchar	Part number of the actual attached part
6	`vsd_ActAttch_Qty`	int	Quantity of the actual attached part
7	`vsd_ActAttch_Srl`	varchar	Serial number of the actual attached part
8	`vsd_ActAttch_Sts`	varchar	Status of the actual attached part
9	`VSD_ActFndDisasmbld`	varchar	Indicates whether the component was found disassembled
10	`VSD_addl_remarks`	varchar	Additional remarks recorded in the entry
11	`VSD_alt_type`	varchar	Type of alternate component or configuration
12	`VSD_aprj_rem`	varchar	Remarks provided during approval or rejection
13	`VSD_AssmGrp`	varchar	Group to which the assembly belongs
14	`VSD_ATA`	varchar	ATA chapter number associated with the component
15	`VSD_Attached_Part`	varchar	Part number of the attached component
16	`VSD_Attached_serial`	varchar	Serial number of the attached component
17	`VSD_Attached_Status`	varchar	Status of the attached component
18	`VSD_ATTACH_dATE`	datetime	Date when the attachment was performed
19	`VSD_Att_Discp_status`	varchar	Status of the attached discrepancy
20	`VSD_Base_Part`	varchar	Part number of the base component
21	`VSD_Certificate_Date`	datetime	Date when the certificate was issued
22	`VSD_Certificate_No`	varchar	Certificate number associated with the component
23	`VSD_Certificate_Type`	varchar	Type of certificate linked to the component
24	`vsd_Cfg_change_Status`	varchar	Status of the configuration change recorded
25	`vsd_Changeinfo`	varchar	Information describing the change applied to the configuration
26	`vsd_chldexst_flag`	varchar	Flag indicating whether child records exist for the component
27	`VSD_Cnfg_Flag`	varchar	Configuration flag associated with the component
28	`VSD_comments`	varchar	Additional comments linked to the record
29	`VSD_Component`	varchar	Number assigned to the component
30	`VSD_Comp_Mandatory`	varchar	Indicates whether the component is mandatory
31	`VSD_cond_crit`	varchar	Criteria that must be met for configuration validity
32	`VSD_CONFIGEXEP`	varchar	Exception recorded during configuration processing
33	`VSD_Configstatus`	varchar	Status of the configuration such as active inactive or obsolete
34	`VSD_Config_Change_Flag`	varchar	Flag indicating whether a configuration change is recorded
35	`VSD_Config_Created_By`	varchar	User who created the configuration record
36	`VSD_Config_Created_Date`	datetime	Date when the configuration record was created
37	`VSD_Config_Modified_By`	varchar	User who last modified the configuration
38	`VSD_Config_Modified_Date`	datetime	Date when the configuration was last modified
39	`VSD_Config_Revision`	varchar	Revision number assigned to the configuration
40	`VSD_Config_TimeStamp`	int	System timestamp for the configuration record
41	`VSD_CR`	varchar	Details of the component replacement
42	`VSD_critical`	varchar	Indicates whether the component is considered critical
43	`vsd_Crr`	varchar	Reference number of the configuration revision request
44	`VSD_CR_Flag`	varchar	Flag indicating component replacement
45	`VSD_CR_Type`	varchar	Type of component replacement performed
46	`VSD_CSN`	numeric	Total cycles since new value recorded for the component
47	`VSD_Discp_Category`	varchar	Category of discrepancy noted during inspection
48	`VSD_Discp_Notes`	varchar	Notes explaining the identified discrepancy
49	`VSD_Display_Seq`	numeric	Sequence in which the display is organized
50	`VSD_DISPLEVELCODE`	varchar	Level code of the display hierarchy
51	`VSD_Document_No`	varchar	The document number related to the visit
52	`VSD_Drawing`	varchar	The engineering drawing associated with the component or assembly
53	`VSD_EIPN_Comp`	varchar	The component identifier linked to the Engineering Item Part Number
54	`VSD_EIPN_Part`	varchar	The part number linked to the Engineering Item Part Number
55	`VSD_EIPN_Serial`	varchar	The serial number linked to the Engineering Item Part Number
56	`VSD_Eqp_Cat`	varchar	The classification category of the equipment
57	`VSD_Eqp_Group`	varchar	The group classification to which the equipment belongs
58	`VSD_Error_Msg`	varchar	Detailed information about the error message
59	`VSD_FC`	varchar	The total number of flight cycles accumulated by the component or aircraft
60	`VSD_FH`	varchar	The total number of flight hours accumulated by the component or aircraft
61	`VSD_FileName`	varchar	The name of the file associated with the component or record
62	`VSD_FndDisasmbld`	varchar	Indicator showing whether the component was found disassembled
63	`vsd_+C4670:D4762Idnt_Changes`	datetime	Details of identification changes made to the component
64	`VSD_Induction_DateTime`	varchar	The date and time of induction into the system or process
65	`VSD_Installed_Component`	varchar	The component that has been installed
66	`VSD_Installed_Condition`	varchar	The condition of the component at the time of installation
67	`VSD_Installed_MSN`	varchar	The manufacturer serial number of the installed component
68	`VSD_Installed_Part`	varchar	The part installed in the configuration or assembly
69	`VSD_Installed_Serial`	int	The serial number of the installed part
70	`vsd_InstQty`	varchar	The installed quantity of the component or part
71	`VSD_Interchang_Rule`	varchar	The rule defining interchangeability between components or parts
72	`VSD_ISSNOTES`	varchar	Notes recorded at the time of issue
73	`VSD_KeyNo`	varchar	The key number used for identification
74	`VSD_last_impacted_eo`	varchar	The last impacted engineering order reference
75	`VSD_last_impacted_eo_flag`	varchar	Flag indicating whether the last impacted engineering order is applicable
76	`VSD_last_impacted_eo_rev`	varchar	The revision number of the last impacted engineering order
77	`VSD_Level_Code`	varchar	The level code indicating the hierarchical level of the component or part
78	`VSD_Level_No`	varchar	The sequential level number of the component or part
79	`VSD_LLP`	int	Details of life limited parts associated with the component
80	`VSD_MAXQTY`	datetime	The maximum allowable quantity for the component or part
81	`VSD_Mfr_DateTime`	int	The date and time of manufacture of the component
82	`VSD_MINQTY`	varchar	The minimum allowable quantity for the component or part
83	`VSD_NHALEVEL_CODE`	varchar	The level code of the next higher assembly
84	`VSD_NHAPOSCODE`	varchar	The position code of the next higher assembly
85	`VSD_NHA_Component`	varchar	The component number of the next higher assembly
86	`VSD_NHA_EMPTY_POS`	varchar	Indicator showing an empty position in the next higher assembly
87	`VSD_NHA_Part`	varchar	The part number of the next higher assembly
88	`VSD_NHA_Serial`	varchar	The serial number of the next higher assembly
89	`vsd_orig_position_part`	varchar	The original position part reference
90	`vsd_ori_installed_part`	varchar	The originally installed part before replacement
91	`VSD_Ori_Position_Code`	varchar	The original position code assigned
92	`VSD_Ori_Position_Part`	int	The original part assigned to the position
93	`VSD_Ou_instance`	varchar	The organizational unit instance linked to the record
94	`VSD_OVVRDN`	varchar	Indicator showing whether the data or setting has been overridden
95	`VSD_Ownership`	varchar	The ownership status of the component or record
96	`VSD_Owningagency`	varchar	The agency responsible for owning the component or record
97	`VSD_Parameter_Init`	varchar	The initialization details of the parameter
98	`VSD_Parent_Id`	varchar	The unique identifier of the parent record or component
99	`VSD_Part_Category`	varchar	The category to which the part belongs
100	`VSD_PIECEPART`	varchar	The piece part associated with the component or assembly
101	`vsd_PiecePrt_Flag`	varchar	Indicator flag showing whether the part is a piece part
102	`VSD_Piece_part`	varchar	Indicator showing whether the part is treated as a piece part
103	`vsd_PMA_PrtUsg`	varchar	The details of Parts Manufacturer Approval usage for the part
104	`VSD_Position_Code`	varchar	The code representing the position within the assembly
105	`VSD_Position_Formula`	varchar	The formula used to calculate or define the position
106	`VSD_Position_Part`	varchar	The part assigned to the position in the assembly
107	`VSD_Position_Part_Desc`	varchar	The description of the part assigned to the position
108	`VSD_Position_Status`	varchar	The current status of the position within the assembly
109	`VSD_Position_Type`	varchar	The type of position within the assembly
110	`VSD_POSMOD`	varchar	The modification applied to the position
111	`VSD_Pos_Modifcation_Cat`	varchar	The category of modification applied to the position
112	`VSD_Pos_Modificiation_Remarks`	int	Remarks related to the modification of the position
113	`VSD_PPCMKYSQ`	varchar	The key sequence assigned to the piece part
114	`VSD_PPQTYREM_FLAG`	varchar	Indicator showing whether the piece part quantity has been removed
115	`VSD_Reason`	varchar	The reason recorded for the change or action
116	`VSD_Recorded_By`	varchar	The user who recorded the details
117	`VSD_RECUSEENGDISP`	varchar	The disposition for recurring usage of the part
118	`vsd_refdoc_no`	varchar	The number of the reference document linked to the component
119	`vsd_refdoc_typ`	int	The type of the reference document
120	`vsd_RefQty`	Bigint	The reference quantity specified in the document
121	`vsd_ref_crtrkid`	varchar	The tracking identifier for the referenced change request
122	`VSD_Ref_Document`	varchar	The external document used as a reference
123	`VSD_Remarks`	datetime	Additional remarks or notes
124	`VSD_Removal_Time`	varchar	The recorded time of removal of the part
125	`VSD_removedby`	varchar	The user who performed the removal
126	`VSD_Removed_Cond`	varchar	The condition of the part at the time of removal
127	`VSD_Removed_Condition`	varchar	The status of the removed component
128	`VSD_Removed_Type`	varchar	The type of part removal carried out
129	`VSD_Rem_dispotion`	varchar	The disposition recorded for the removed part
130	`VSD_Rem_Type`	varchar	The type of removal performed
131	`VSD_ReNumber_Flag`	datetime	Indicator showing whether renumbering has been applied
132	`VSD_Replacement_DateTime`	varchar	The date and time of part replacement
133	`VSD_replacement_type`	varchar	The type of replacement carried out for the component
134	`VSD_REPLPRTCOND`	varchar	The condition of the part at the time of replacement
135	`VSD_REQTST`	varchar	The status of the request associated with the part or record
136	`VSD_Req_for`	varchar	The user or role for whom the request was made
137	`VSD_RsedMech_flag`	varchar	The flag indicating whether a restricted mechanic is required
138	`VSD_Selected`	varchar	Indicator showing whether the part or record is selected
139	`vsd_srcdoc_no`	varchar	The source document number used as reference
140	`vsd_srcdoc_typ`	Varchar	The type of source document used
141	`VSD_Station`	varchar	The station linked to the component or process
142	`VSD_StockStatus`	varchar	The current stock status of the part or component
143	`VSD_SWOSPL_FLAG`	varchar	Indicator showing whether the record has been split
144	`VSD_SWO_No`	varchar	The shop work order number linked to the component or record
145	`VSD_Template_Part`	numeric	The reference template part associated with the configuration
146	`VSD_TRGTBLDUPVAL`	numeric	The target buildup value for the part or component
147	`VSD_TSN`	bigint	The total time since new value recorded for the part
148	`VSD_unique_id` 🔑	varchar	The unique identifier assigned to the record
149	`VSD_User_defined1`	varchar	A user defined custom field one
150	`VSD_User_defined2`	varchar	A user defined custom field two
151	`VSD_User_defined3`	varchar	A user defined custom field three
152	`VSD_User_defined4`	varchar	A user defined custom field four
153	`VSD_User_defined5`	varchar	A user defined custom field five
154	`VSD_User_defined6`	varchar	A user defined custom field six
155	`VSD_Zone`	varchar	The zone associated with the component or process

Relationships (1)

VisitConfig (SWO_Visit_Lvl_Cmp_config) → CONFIG_HAS_DETAIL (this table is target)
- Join: SWO_Visit_Lvl_Cmp_config.VSC_unique_id = SWO_Visit_Lvl_Cmp_cfg_dtl.VSD_unique_id
- Config has detail records

Sample rows (from live DB)

`VSD_Accept_Reference`	`vsd_ActAttch_Comp`	`vsd_ActAttch_Disc_CAt`	`vsd_ActAttch_Disc_Sts`	`vsd_ActAttch_Prt`	`vsd_ActAttch_Qty`
—	—	—	—	—	—
—	—	—	—	—	—
—	—	—	—	—	—

Showing 3 of 50,000 rows.

SWO_Visit_Lvl_Cmp_cfg_dtl

Primary key

Columns (155)

Relationships (1)

Sample rows (from live DB)

See also