SWO_visit_Target_Cmp_cfg_dtl

Visit Ref Target Configuration details

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Maintains configuration details for target components scheduled during a shop visit, used to align with planned maintenance and compliance requirements

Primary key

VSTC_unique_id

Columns (142)

#	Column	Type	Description
1	`cfgcsp_last_impacted_eo`	varchar	Tracks the last impacted engineering order number
2	`cfgcsp_last_impacted_eo_flag`	varchar	Indicates the flag for the last impacted engineering order
3	`cfgcsp_last_impacted_eo_rev`	varchar	Records the revision number of the last impacted engineering order
4	`VSTC_Accept_Reference`	varchar	Captures the acceptance reference
5	`VSTC_ActFndDisasmbld`	varchar	Records if the component was actually found disassembled
6	`VSTC_addl_remarks`	varchar	Stores additional remarks
7	`VSTC_alt_type`	varchar	Captures the alternate type
8	`VSTC_aprj_rem`	varchar	Records approval or rejection remarks
9	`VSTC_AssmGrp`	varchar	Tracks the assembly group
10	`VSTC_ATA`	varchar	Records the ATA number
11	`VSTC_Attached_Part`	varchar	Tracks the attached part number
12	`VSTC_Attached_serial`	varchar	Records the attached serial number
13	`VSTC_Attached_Status`	datetime	Indicates the status of attached items
14	`VSTC_ATTACH_dATE`	varchar	Records the date of attachment
15	`VSTC_Att_Discp_status`	varchar	Tracks the attached discrepancy status
16	`VSTC_Base_Part`	datetime	Records the base part number
17	`VSTC_Certificate_Date`	varchar	Stores the certificate date
18	`VSTC_Certificate_No`	varchar	Tracks the certificate number
19	`VSTC_Certificate_Type`	varchar	Records the certificate type
20	`VSTC_CHANGEINFO`	varchar	Captures change information
21	`VSTC_CMPLUPD`	varchar	Stores compliance update details
22	`VSTC_Cnfg_Flag`	varchar	Indicates the configuration flag
23	`VSTC_comments`	varchar	Stores comments
24	`VSTC_Component`	varchar	Tracks the component ID
25	`VSTC_Comp_Mandatory`	varchar	Indicates if the component is mandatory
26	`VSTC_cond_crit`	varchar	Indicates if the component is in a critical condition
27	`VSTC_Configstatus`	varchar	Records the configuration status
28	`VSTC_Config_Change_Flag`	varchar	Indicates the configuration change flag
29	`VSTC_Config_Created_By`	datetime	Identifies the user who created the configuration
30	`VSTC_Config_Created_Date`	varchar	Records the configuration creation date
31	`VSTC_Config_Modified_By`	datetime	Identifies the user who modified the configuration
32	`VSTC_Config_Modified_Date`	varchar	Records the configuration modified date
33	`VSTC_Config_Revision`	int	Tracks the configuration revision number
34	`VSTC_Config_TimeStamp`	varchar	Stores the configuration timestamp
35	`VSTC_CR`	varchar	Indicates component replacement
36	`VSTC_critical`	varchar	Indicates whether the component is critical for aircraft operation or safety
37	`VSTC_CRR`	varchar	Tracks configuration revision requests
38	`VSTC_CR_Flag`	varchar	Indicates if the component replacement flag is set
39	`VSTC_CR_Type`	numeric	Records the component replacement type
40	`VSTC_CSN`	varchar	Represents the component serial number
41	`VSTC_Discp_Category`	varchar	Tracks the discrepancy category
42	`VSTC_Discp_Notes`	numeric	Stores discrepancy notes
43	`VSTC_Display_Seq`	varchar	Records display sequence
44	`VSTC_DISPLEVELCODE`	varchar	Tracks display level code
45	`VSTC_Document_No`	varchar	Captures the visit reference number
46	`VSTC_Drawing`	varchar	Records the drawing reference
47	`VSTC_EIPN_Comp`	varchar	Identifies the Epin component
48	`VSTC_EIPN_Part`	varchar	Tracks the part number
49	`VSTC_EIPN_Serial`	varchar	Records the Epin serial
50	`vstc_eng_refno`	varchar	Tracks the engineering reference number
51	`VSTC_Eqp_Cat`	varchar	Captures the equipment category
52	`VSTC_Eqp_Group`	varchar	Records the equipment group
53	`VSTC_Error_Msg`	varchar	Stores error messages
54	`VSTC_FC`	varchar	Tracks the flight cycle
55	`VSTC_FH`	varchar	Records flight hours
56	`VSTC_FileName`	varchar	Captures the file name
57	`VSTC_FndDisasmbld`	datetime	Indicates if found disassembled
58	`VSTC_Induction_DateTime`	varchar	Records induction date and time
59	`VSTC_Installed_Component`	varchar	Tracks the installed component
60	`VSTC_Installed_Condition`	varchar	Records the installed condition
61	`VSTC_Installed_MSN`	varchar	Stores the installed Manufacturer Serial Number (MSN)
62	`VSTC_Installed_Part`	varchar	Tracks the installed part number
63	`VSTC_Installed_Serial`	int	Records the installed serial number
64	`vstc_instqty`	varchar	Captures the installed quantity
65	`VSTC_Interchang_Rule`	varchar	Tracks interchangeability rules
66	`VSTC_ISSNOTES`	varchar	Stores issuance notes
67	`VSTC_KeyNo`	bigint	Records key number
68	`vstc_kitid`	varchar	Tracks the Kit ID
69	`VSTC_last_impacted_eo`	varchar	Last impacted engineering order number
70	`VSTC_last_impacted_eo_flag`	varchar	Last impacted engineering order flag
71	`VSTC_last_impacted_eo_rev`	varchar	Last impacted engineering order revision number
72	`VSTC_Level_Code`	varchar	Stores the level code
73	`VSTC_Level_No`	varchar	Tracks the level number
74	`VSTC_LLP`	int	Indicates life-limited parts
75	`vstc_maxqty`	datetime	Records the maximum quantity
76	`VSTC_Mfr_DateTime`	int	Tracks manufacture date and time
77	`vstc_minqty`	varchar	Indicates minimum quantity
78	`vstc_newposflag`	varchar	Records new position flag
79	`VSTC_NHALEVEL_CODE`	varchar	Tracks NHA level code
80	`VSTC_NHAPOSCODE`	varchar	Records NHA position code
81	`VSTC_NHA_Component`	varchar	Identifies NHA component
82	`VSTC_NHA_EMPTY_POS`	varchar	Indicates NHA empty position
83	`VSTC_NHA_Part`	varchar	Tracks NHA part number
84	`VSTC_NHA_Serial`	varchar	Records NHA serial number
85	`VSTC_Orig_Position_Part`	varchar	Captures original position part
86	`VSTC_Ori_Installed_Part`	varchar	Tracks original installed part
87	`VSTC_Ori_Position_Code`	varchar	Records original position code
88	`VSTC_Ori_Position_Part`	int	Stores original position part
89	`VSTC_Ou_instance`	varchar	Captures the organizational unit instance
90	`VSTC_Ownership`	varchar	Tracks ownership
91	`VSTC_Owningagency`	varchar	Records owning agency
92	`VSTC_Parameter_Init`	varchar	Stores parameter initialization
93	`VSTC_Parent_Id`	varchar	Tracks parent ID
94	`VSTC_Part_Category`	varchar	Records part category
95	`VSTC_PIECEPART`	varchar	Indicates piece part
96	`VSTC_PIECEPRT_FLAG`	varchar	Tracks piece part flag
97	`VSTC_Piece_part`	varchar	Stores piece part usage approval
98	`VSTC_PMA_PrtUsg`	varchar	Parts Manufacturer Approval part usage
99	`VSTC_Position_Code`	varchar	Records position code
100	`VSTC_Position_Formula`	varchar	Captures position formula
101	`VSTC_Position_Part`	varchar	Tracks position part
102	`VSTC_Position_Part_Desc`	varchar	Stores position part description
103	`VSTC_Position_Status`	varchar	Records position status
104	`VSTC_Position_Type`	varchar	Tracks position type
105	`vstc_posmod`	varchar	Captures position modification
106	`VSTC_Pos_Modifcation_Cat`	varchar	Records position modification category
107	`VSTC_Pos_Modificiation_Remarks`	varchar	Stores position modification remarks
108	`VSTC_Reason`	varchar	Tracks reason for changes
109	`VSTC_Recorded_By`	varchar	Records user who recorded the action
110	`VSTC_RECUSEENGDISP`	int	Indicates recurring usage disposition
111	`VSTC_REFQTY`	varchar	Tracks reference quantity
112	`VSTC_Ref_Document`	varchar	Stores reference document
113	`VSTC_Remarks`	datetime	Captures remarks
114	`VSTC_Removal_Time`	varchar	Records removal time
115	`VSTC_removedby`	varchar	Tracks user who removed
116	`VSTC_Removed_Cond`	varchar	Stores removed condition
117	`VSTC_Removed_Condition`	varchar	Indicates removed condition type
118	`VSTC_Removed_Type`	varchar	Tracks remaining disposition
119	`VSTC_Rem_dispotion`	varchar	Records remaining type
120	`VSTC_Rem_Type`	varchar	Indicates renumber flag
121	`VSTC_ReNumber_Flag`	datetime	Renumber flag
122	`VSTC_Replacement_DateTime`	varchar	Records replacement date and time
123	`VSTC_replacement_type`	varchar	Tracks replacement type
124	`VSTC_REPLPRTCOND`	varchar	Stores replication part condition
125	`VSTC_REQTST`	varchar	Tracks request status
126	`VSTC_Req_for`	varchar	Records requested for
127	`VSTC_RsedMech_flag`	varchar	Indicates RSED mech flag
128	`VSTC_Selected`	varchar	Tracks selected components
129	`VSTC_Station`	varchar	Records station
130	`VSTC_StockStatus`	varchar	Tracks stock status
131	`VSTC_SWO_No`	varchar	Records Shop Work Order number
132	`VSTC_Template_Part`	numeric	Tracks template part
133	`VSTC_TRGTBLDUPVAL`	numeric	Stores target buildup value
134	`VSTC_TSN`	bigint	Records Time Since New (TSN)
135	`VSTC_unique_id` 🔑	varchar	Stores unique identifier
136	`VSTC_User_defined1`	varchar	Tracks user-defined field 1
137	`VSTC_User_defined2`	varchar	Tracks user-defined field 2
138	`VSTC_User_defined3`	varchar	Tracks user-defined field 3
139	`VSTC_User_defined4`	datetime	Tracks user-defined field 4
140	`VSTC_User_defined5`	datetime	Tracks user-defined field 5
141	`VSTC_User_defined6`	varchar	Tracks user-defined field 6
142	`VSTC_Zone`	bigint	Records zone

Sample rows (from live DB)

`cfgcsp_last_impacted_eo`	`cfgcsp_last_impacted_eo_flag`	`cfgcsp_last_impacted_eo_rev`	`VSTC_Accept_Reference`	`VSTC_ActFndDisasmbld`	`VSTC_addl_remarks`
—	—	—	—	—	—
—	—	—	—	—	—
—	—	—	—	—	—

Showing 3 of 10,897 rows.

SWO_visit_Target_Cmp_cfg_dtl

Primary key

Columns (142)

Sample rows (from live DB)

See also