swo_visit_cmpl_dtl

Visit Reference table for Compliance details. This table stores detailed compliance information including regulatory requirements, inspection results, and certification status during aircraft visits.

Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Captures the actual completion details of a shop visit, including status, closure information, and outcomes

This table is the canonical store for the VisitCompletion entity.

Primary key

vcp_uniqueid

Columns (92)

#	Column	Type	Description
1	`vcp_acmodel`	varchar	Aircraft model number
2	`vcp_addl_comments`	varchar	Additional comments
3	`vcp_addtlremarks`	varchar	Additional remarks
4	`vcp_allocexedoc`	varchar	Allocate excution document
5	`vcp_applevel`	varchar	Applicability level
6	`vcp_applicability`	varchar	Applicability
7	`VCP_CMPLSEQ`	int	Compliance seq
8	`vcp_comments`	varchar	Comments
9	`vcp_compliance_date`	datetime	Compliance date
10	`vcp_compliance_time`	Datetime	Compliance time
11	`VCP_COMPLMCR`	varchar	Compliance mcr
12	`vcp_component`	varchar	Component
13	`vcp_component_id`	varchar	Component id
14	`VCP_CONCFG_REV_NO`	varchar	Configuration revision number
15	`vcp_configclss`	varchar	Configuration class
16	`vcp_confirmed_by`	varchar	Confirmed by
17	`vcp_confirmed_date`	datetime	Confirmed date
18	`vcp_created_by`	varchar	Created by
19	`vcp_created_date`	datetime	Created date
20	`vcp_currval`	varchar	Current value
21	`vcp_dftunique_id`	bigint	Draft unique id
22	`vcp_document_no`	varchar	Visit reference number
23	`vcp_EOCMPL_STS`	varchar	Eo compliance status
24	`vcp_eo_flag`	varchar	Engineering order flag
25	`vcp_eo_no`	varchar	Engineering order number
26	`vcp_eo_rev`	varchar	Engineering order revision number
27	`VCP_ExecInfo`	varchar	Execution information
28	`vcp_execution_comments`	varchar	Execution comments
29	`vcp_exe_document`	varchar	Execution document
30	`vcp_filappgrp`	varchar	Applicability group
31	`vcp_filapplvl`	varchar	Applicability level1
32	`vcp_fllwupinst`	varchar	Follow up installed part
33	`VCP_INSQTY`	int	Installed quantity
34	`vcp_jobtype`	varchar	Type of maintenance or task, e.g., scheduled maintenance, unscheduled repair, inspection, or modification.
35	`vcp_kitid`	bigint	Identifier for the kit used in maintenance or assembly
36	`VCP_LEVEL_CODE`	varchar	Code representing the maintenance level or assembly hierarchy
37	`vcp_lvlnumber`	int	Numerical representation of the assembly or subassembly level in the aircraft structure
38	`vcp_maint_type`	varchar	Maint type
39	`VCP_MAXQTY`	int	Maximum quantity
40	`VCP_MINQTY`	int	Minimum quantity
41	`vcp_modified_by`	varchar	Modified by
42	`vcp_modified_date`	datetime	Modified date
43	`vcp_mpditem`	varchar	Mpd item
44	`vcp_mssgecnter`	varchar	Message center
45	`VCP_NHALVL_CODE`	varchar	Next higher assembly level code
46	`VCP_NHA_COMP`	varchar	Nha component
47	`VCP_NHA_PART`	varchar	Nha part
48	`VCP_NHA_POSCODE`	varchar	Nha position code
49	`vcp_ou_instance`	int	Ouinstance
50	`VCP_Ovride_EO`	varchar	Override engineering order
51	`VCP_Ovride_Ref`	varchar	Override reference
52	`VCP_Ovride_Remarks`	varchar	Override remarks
53	`vcp_partdesc`	varchar	Part description
54	`vcp_part_no`	varchar	Part number
55	`vcp_pieceprt`	varchar	Piece part
56	`vcp_Planeo`	varchar	Plan engineering order number
57	`VCP_PLANEO_SEQ`	int	Plan engineering order sequence
58	`vcp_Plantsk`	varchar	Planned task
59	`VCP_plntask_updated`	varchar	Planned task updated
60	`vcp_posbsdsched`	varchar	Position based scheduled
61	`VCP_POSCODE`	varchar	Position code
62	`VCP_POSPART`	varchar	Position part
63	`vcp_program_rev`	varchar	Program revision number
64	`VCP_PRTCMPLREM`	varchar	Part compliance remaining value
65	`vcp_prteffid`	bigint	Part effectivity id
66	`VCP_REFQTY`	int	Reference quantity
67	`vcp_remarks`	varchar	Remarks
68	`vcp_remval`	varchar	Remainning value
69	`vcp_REQ_FOR`	int	Required for
70	`vcp_schedval`	varchar	Scheduled value
71	`vcp_serial_no`	varchar	Serial number
72	`vcp_sheduled`	varchar	Scheduled
73	`vcp_shrttrmesclref`	varchar	Shor term esclation reference
74	`vcp_srcdocno`	varchar	Source document number
75	`vcp_taskdesc`	varchar	Task description
76	`vcp_taskrev`	varchar	Task revision number
77	`vcp_task_no`	varchar	Task number
78	`vcp_timestamp`	int	Timestamp
79	`vcp_TSKCMPL_STS`	varchar	Task compliance status
80	`vcp_ud6`	datetime	User defined 6
81	`vcp_uniqueid` 🔑	bigint	Unique id
82	`VCP_updtBy`	varchar	Updated by
83	`vcp_user_defined1`	varchar	User defined 1
84	`vcp_user_defined2`	varchar	User defined 2
85	`vcp_user_defined3`	varchar	User defined 3
86	`vcp_user_defined4`	varchar	User defined 4
87	`vcp_user_defined5`	datetime	User defined 5
88	`VCP_user_flag`	varchar	User flag
89	`vcp_workunit_line_no`	int	Work unit line number
90	`vcp_wsamdchngtyp`	varchar	Amendment change type
91	`vcp_WSAMDNO`	varchar	Amendment number
92	`vcp_WSAMDSTS`	varchar	Amendment status

Relationships (1)

VisitPackage (SWO_Visit_Lvl_Info) → VISIT_HAS_COMPLETION (this table is target)
- Join: SWO_Visit_Lvl_Info.visit_id = swo_visit_cmpl_dtl.vcp_uniqueid
- Visit has completion record

Sample rows (from live DB)

`vcp_acmodel`	`vcp_addl_comments`	`vcp_addtlremarks`	`vcp_allocexedoc`	`vcp_applevel`	`vcp_applicability`
—	—	AdlRem	—	—	C
—	—	—	—	—	C
—	—	—	—	—	—

Showing 3 of 1,163 rows.

swo_visit_cmpl_dtl

Primary key

Columns (92)

Relationships (1)

Sample rows (from live DB)

See also