SWO_Visit_DFT_COMP_Draft_DTL

Visit hub component draft detail table. This table contains draft information about aircraft components during the planning phase of maintenance visits, before final approval.

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Holds draft component-level details related to a shop visit before they are approved and finalized

Primary key

VDL_unique_id

Columns (158)

#	Column	Type	Description
1	`VDL_Accept_Reference`	varchar	Acceptance reference
2	`VDL_ActAttQty`	int	Actual attached qty
3	`VDL_ActFndDisasmbld`	varchar	Actual found disassembled
4	`VDL_addl_remarks`	varchar	Additional remarks
5	`VDL_alt_type`	varchar	Alternate type
6	`VDL_aprj_rem`	varchar	Approval/rejection remarks
7	`VDL_AssmGrp`	varchar	Assembly group
8	`VDL_AssmGrp_1`	varchar	Assembly group 1
9	`VDL_ATA`	varchar	Refers to the ATA chapter number that classifies the system or component of the aircraft according to the ATA
10	`VDL_Attached_Part`	varchar	Attached part number
11	`VDL_Attached_serial`	varchar	Attached serial number
12	`VDL_Attached_Status`	varchar	Attached status
13	`VDL_ATTACH_dATE`	datetime	Attached date
14	`VDL_Att_Discp_status`	varchar	Attachment discrepency status
15	`VDL_Base_Part`	varchar	The unique number assigned to identify the basic part without considering its modifications or revisions
16	`VDL_Certificate_Date`	datetime	The date on which the certificate was issued for the part or component
17	`VDL_Certificate_No`	varchar	The unique identification number of the issued certificate
18	`VDL_Certificate_Type`	varchar	The category or type of certificate associated with the part or component
19	`VDL_Changeinfo`	varchar	Details describing the change or modification made to the component or configuration
20	`vdl_cmplupd`	varchar	Information regarding the most recent compliance status or update of the component
21	`VDL_Cnfg_Flag`	varchar	Indicator that specifies whether the component is part of a configuration
22	`VDL_comments`	varchar	Additional notes or remarks related to the part or configuration
23	`VDL_Component`	varchar	The unique identifier assigned to the component
24	`VDL_Comp_Mandatory`	varchar	Indicates whether the component is mandatory for the configuration
25	`VDL_Comp_Mandatory_1`	varchar	Secondary field to specify if a component is mandatory in another scenario
26	`VDL_cond_crit`	varchar	The specific conditions that must be satisfied for the part or configuration to be valid
27	`VDL_CONFIGEXEP`	varchar	Records any exception related to the configuration process
28	`VDL_Configstatus`	varchar	The current status of the configuration such as active inactive or obsolete
29	`VDL_Config_Change_Flag`	varchar	Indicator showing if a configuration change has been applied
30	`VDL_Config_Created_By`	varchar	The user who created the configuration record
31	`VDL_Config_Created_Date`	datetime	The date on which the configuration was first created
32	`VDL_Config_Modified_By`	varchar	The user who last modified the configuration
33	`VDL_Config_Modified_Date`	datetime	The date on which the configuration was last modified
34	`VDL_Config_Revision`	varchar	The revision number assigned to the configuration for version control
35	`VDL_Config_TimeStamp`	Integer	The recorded system date and time of the configuration entry
36	`VDL_CR`	varchar	Information about a component that has been replaced within the configuration
37	`VDL_critical`	varchar	Indicates if the component is critical to the system or assembly
38	`VDL_CRR`	varchar	The request number associated with a configuration revision
39	`VDL_CR_Flag`	varchar	Indicator specifying whether a component replacement has been carried out
40	`VDL_CR_Type`	varchar	The type or category of component replacement performed
41	`VDL_CSN`	numeric	Cycles since new represents the total number of operational cycles completed by a component since it was new
42	`VDL_Discp_Category`	varchar	The classification of discrepancies identified during inspection or operation
43	`VDL_Discp_Notes`	varchar	Detailed notes explaining the discrepancy
44	`VDL_Display_Seq`	int	The sequence number used to define the display order of the component or record
45	`VDL_DISPLEVELCODE`	varchar	The level code used to represent the display hierarchy of the component
46	`VDL_Drawing`	varchar	The drawing reference associated with the part or component
47	`VDL_EIPN_Comp`	varchar	Engineering item part number component identifier used to identify a specific component
48	`VDL_EIPN_Part`	varchar	Engineering item part number identifying the part
49	`VDL_EIPN_Serial`	varchar	Engineering item part number serial number of the part
50	`vdl_eng_refno`	varchar	The engineering reference number related to the component or configuration
51	`VDL_Eqp_Cat`	varchar	The category of equipment to which the part or component belongs
52	`VDL_Eqp_Group`	varchar	The group classification under which the equipment is categorized
53	`VDL_Error_Msg`	varchar	The error message or details recorded during processing
54	`VDL_FC`	varchar	The total number of flight cycles completed by the aircraft or component
55	`VDL_FH`	Varchar	The total number of flight hours completed by the aircraft or component
56	`VDL_FileName`	varchar	The name of the file associated with the record or document
57	`VDL_FndDisasmbld`	varchar	Indicates whether the component was found disassembled during inspection
58	`VDL_Induction_DateTime`	datetime	The date and time when the component was inducted or received
59	`VDL_Installed_Component`	varchar	The identifier of the component that has been installed
60	`VDL_Installed_Condition`	varchar	The condition of the component at the time of installation
61	`VDL_Installed_MSN`	varchar	The manufacturer serial number of the installed component
62	`VDL_Installed_Part`	varchar	The part number of the installed component
63	`VDL_Installed_Serial`	varchar	The serial number of the installed component
64	`VDL_InstQty`	varchar	The quantity of components installed
65	`VDL_Interchang_Rule`	varchar	The interchangeability rule applied to the component
66	`VDL_Interchang_Rule_1`	varchar	Secondary interchangeability rule applied to the component
67	`VDL_ISSNOTES`	varchar	Notes related to the issue or observation
68	`VDL_KeyNo`	int	The unique key number related to draft component details for a maintenance visit
69	`vdl_kitid`	bigint	Represents the kitting identifier used to track component kits
70	`VDL_last_impacted_eo`	varchar	The last impacted engineering order reference number
71	`VDL_last_impacted_eo_flag`	varchar	Flag indicating whether the last impacted engineering order is applicable
72	`VDL_last_impacted_eo_rev`	varchar	The revision number of the last impacted engineering order
73	`VDL_Level_Code`	varchar	The level code representing the position of the component in the hierarchy
74	`VDL_Level_No`	varchar	The level number assigned within the hierarchy for the component
75	`VDL_LLP`	varchar	Details of life limited parts associated with the component
76	`VDL_llp_1`	varchar	Additional details of life limited parts associated with the component
77	`VDL_MAXQTY`	varchar	The maximum quantity allowed for the component
78	`VDL_MAXQTY_1`	int	Additional field for maximum quantity allowed for the component
79	`VDL_Mfr_DateTime`	datetime	The date and time of manufacture of the component
80	`VDL_MINQTY`	varchar	The minimum quantity required for the component
81	`VDL_MINQTY_1`	int	Additional field for minimum quantity required for the component
82	`VDL_NEWPOSFLAG`	varchar	Flag indicating if the new position has been created for the component
83	`VDL_NHALEVEL_CODE`	varchar	The level code for the next higher assembly of the component
84	`VDL_NHAPOSCODE`	varchar	The position code of the next higher assembly
85	`VDL_NHA_Component`	varchar	The identifier of the next higher assembly component
86	`VDL_NHA_EMPTY_POS`	varchar	Indicates whether the position in the next higher assembly is empty
87	`VDL_NHA_Part`	varchar	The part number of the next higher assembly component
88	`VDL_NHA_Serial`	varchar	The serial number of the next higher assembly component
89	`VDL_Orig_Position_Part`	varchar	The original position part reference for the component
90	`VDL_Ori_Installed_Part`	varchar	The original installed part number before changes were applied
91	`VDL_Ori_Position_Code`	varchar	The original position code assigned to the component
92	`VDL_Ori_Position_Part`	varchar	The original position part description
93	`VDL_Ou_instance`	int	The organizational unit linked to the draft component details for a maintenance visit
94	`VDL_OVVRDN`	varchar	Indicates whether the configuration or record has been overridden
95	`VDL_Ownership`	varchar	Defines the ownership details of the part or component
96	`VDL_Owningagency`	varchar	Specifies the owning agency of the part or component
97	`VDL_Parameter_Init`	varchar	A parameter value associated with the component configuration
98	`VDL_Parent_Id`	varchar	The parent identifier for linking the component in the hierarchy
99	`VDL_Part_Category`	varchar	The category under which the part is classified
100	`VDL_PIECEPART`	varchar	Indicates whether the part is classified as a piece part
101	`VDL_PIECEPART_1`	varchar	Additional piece part value field used for calculations or configuration
102	`VDL_PiecePrt_Flag`	varchar	Flag indicating whether the part is treated as a piece part
103	`VDL_Piece_part`	varchar	Specifies the part considered as a piece part in the configuration
104	`VDL_PMA_PrtUsg`	varchar	Indicates if the part has parts manufacturer approval usage
105	`VDL_Position_Code`	varchar	The position code assigned to the component within the assembly
106	`VDL_Position_Code_1`	varchar	Additional position code field for the component within the assembly
107	`VDL_Position_Formula`	varchar	The formula used to determine the position configuration
108	`VDL_Position_Part`	varchar	The part number of the component assigned to the position
109	`VDL_Position_Part_1`	varchar	Additional field for the part number of the component assigned to the position
110	`VDL_Position_Part_Desc`	varchar	The description of the part assigned to the position
111	`VDL_Position_Status`	varchar	The status of the position such as active or inactive
112	`VDL_Position_Type`	varchar	The type of position defined in the configuration
113	`VDL_Position_Type_1`	varchar	Additional field for the type of position defined in the configuration
114	`VDL_POSMOD`	varchar	The modification applied to the position in the configuration
115	`VDL_POSMOD_1`	varchar	Additional value field for position modification
116	`VDL_Pos_Modifcation_Cat`	varchar	The category of modification applied to the position
117	`VDL_Pos_Modificiation_Remarks`	varchar	Remarks recorded for the modification of the position
118	`VDL_PPCMKYSQ`	int	The sequence key for the piece part in the component configuration
119	`VDL_Reason`	varchar	The reason provided for the configuration change or update
120	`VDL_Recorded_By`	varchar	The user who recorded the details in the system
121	`VDL_RECUSEENGDISP`	varchar	The disposition for recurring usage of the component
122	`VDL_RefQty`	varchar	The reference quantity associated with the configuration
123	`VDL_REFQTY_1`	int	Additional reference quantity field for configuration tracking
124	`VDL_Ref_Document`	varchar	The reference document associated with the configuration or part
125	`VDL_Ref_Guid`	varchar	The globally unique identifier reference associated with the record
126	`VDL_Remarks`	varchar	Remarks related to the component or configuration
127	`VDL_Removal_Time`	datetime	The recorded time of removal of the component
128	`VDL_removedby`	varchar	The user who removed the component
129	`VDL_Removed_Cond`	varchar	The condition of the component at the time of removal
130	`VDL_Removed_Condition`	varchar	Additional details of the component condition at the time of removal
131	`VDL_Removed_Type`	varchar	The type of removal performed on the component
132	`VDL_Rem_dispotion`	varchar	The disposition of the component after removal
133	`VDL_Rem_Type`	varchar	The type of removal applied to the component in the system
134	`VDL_ReNumber_Flag`	varchar	Flag indicating if the renumbering has been applied to the position or component
135	`VDL_Replacement_DateTime`	datetime	The date and time when the replacement was carried out
136	`VDL_replacement_type`	varchar	The type of replacement performed for the component
137	`VDL_REPLPRTCOND`	varchar	The condition of the replacement part at the time of installation
138	`VDL_REQTST`	varchar	The current request status for the component or configuration
139	`VDL_REQTST1_1`	varchar	Indicates whether the component is required to be tested
140	`VDL_req_for`	varchar	Specifies what the component or configuration is required for
141	`VDL_RsedMech_flag`	varchar	Flag indicating screen mechanism details for the component
142	`VDL_Selected`	varchar	Indicates whether the component or configuration has been selected
143	`VDL_Station`	Varchar	Specifies the station associated with the component or operation
144	`VDL_StockStatus`	varchar	The stock status of the part or component
145	`VDL_SWO_No`	varchar	The shop work order number related to the component
146	`VDL_Template_Part`	varchar	The identifier for the template part used in configuration
147	`VDL_TRGTBLDUPVAL`	numeric	The target buildup value used in configuration or assembly planning
148	`VDL_TSN`	numeric	Represents the total operational time in hours cycles or other units accumulated by a component or aircraft part since it was newly manufactured
149	`VDL_unique_id` 🔑	bigint	The unique identifier assigned to the record or component
150	`VDL_User_defined1`	Varchar	User defined field one for custom information entry
151	`VDL_User_defined2`	Varchar	User defined field two for custom information entry
152	`VDL_User_defined3`	Varchar	User defined field three for custom information entry
153	`VDL_User_defined4`	Varchar	User defined field four for custom information entry
154	`VDL_User_defined5`	Varchar	User defined field five for custom information entry
155	`VDL_User_defined6`	Varchar	User defined field six for custom information entry
156	`VDL_Zone`	varchar	The zone in which the component or configuration is applicable
157	`VDT_Cfg_change_Status`	varchar	Indicates the current status of a configuration change such as active inactive or completed
158	`VDT_Document_No`	varchar	Unique number assigned to identify a document associated with the configuration or component

Sample rows (from live DB)

`VDL_Accept_Reference`	`VDL_ActAttQty`	`VDL_ActFndDisasmbld`	`VDL_addl_remarks`	`VDL_alt_type`	`VDL_aprj_rem`
—	—	—	—	—	—
—	—	—	—	—	—
—	—	—	—	—	—

Showing 3 of 44,855 rows.

SWO_Visit_DFT_COMP_Draft_DTL

Primary key

Columns (158)

Sample rows (from live DB)

See also