Data Dictionary -- Aircraft

Srl. No.	Table Name	Comment
1	AC_ACASER_AC_SEARCH_MASTER	Search master capturing of Aircraft information related filters.
2	AC_ACBPRM_AC_BASE_PRM_MAP	The mapping between the parameters defined and the used parameters like FH, FC are done here
3	AC_ACCHIS_AC_CONDITION_HIS	This tables maintains the condition change history for the Components.
4	ac_accond_history	This tables maintains the condition change history for the Aircrafts.
5	AC_ACCSER_CMP_SEARCH_MASTER	Search Id capturing of component info related filters.
6	AC_ACG_AIRCRAFT_GROUP	Aircraft Groups List
7	AC_ACINTP_INHERITABLE_PARAM	Inheritable parameters list
8	AC_ACIPH_INHRIT_POS_HIS	Inheritable position history master
9	AC_ACIPH_INHRIT_PRM_HIS	Inheritable parameter history master
10	AC_ACIPH_INHRIT_PRM_HIS_OLD	Aircraft Inheritable parameter history stored here.
11	AC_ACIPH_INHRIT_PRM_HIS_PRT	Aircraft Inheritable Parameter History stored here..
12	Ac_acipt_inhrit_prm_tran	History of actions performed by user in Re-Initialize / Update Parameter Values interface
13	AC_ACIREF_AC_REFERENCE_DET	This table has the reference document details maintained for an Aircraft
14	AC_ACI_Account_Det_Hist	History of Aircraft - Operator mapping for finance/accounting reference.
15	AC_ACI_AIRCRAFT_INFO	Aircraft Information Master
16	AC_ACJLP_JLOG_PRM_INFO	Stores journey log parameter information.
17	AC_ACMAN_MANUFTR_MASTER	Manufacturer Master
18	AC_ACMD_ModNoEff_Detail	Aircraft Model Number Effectivity Detail
19	AC_ACMH_AIRCRAFT_MAINT_HIS	Aircraft Maintenance History.
20	AC_ACMPH_AC_MAINT_HIS_PRM	Maintenance Parameter History.This info will be maintained if the aircraft is not new.
21	AC_ACNPH_NON_INHRIT_POS_HIS	Non-Inheritable Parameter Postion history
22	AC_ACNPH_NON_INHRIT_PRM_HIS	Non-Inheritable Parameter History
23	AC_ACOIL_UPLIFT_DET	Oil uplift details of the Aircrafts
24	AC_ACOI_AC_ACQUISITION_HIS	Acquisition History of the Aircraft
25	AC_ACPMU_PRM_MTH_USG_HIS	Mothly parameter data for Aircraft and Component
26	AC_ACPP_PART_PREFIX	Last generated number details for each Component ID prefix defined in the system
27	AC_ACPRC_AC_RNGCON_PRM_LIST	Range and Consumption Parameters of Aircraft
28	AC_ACPRT_AIRCRAFT_PART_INFO	Maintenance Information of Parts
29	AC_ACPTA_AC_TECH_ATT_PRMLST	Technical and Attribute parameters of Aircraft
30	AC_ACPTMD_PART_MODEL_EFFECT	Model where this part is applicable is maintained here
31	ac_acptpo_phase_out_policy	Phase out policy for parts
32	ac_acqcsts_status_history	Aircraft Status History maintained here..
33	AC_ACSTS_STATUS_HISTORY	Aircraft Status History maintained here.
34	AC_AGR_AIRCRAFT_GROUP_REG	Aircraft mapping to a Group
35	AC_AOG_STATUS_HISTORY	Stores Aircraft On Ground Status details
36	AC_ATA_ATACHAPTER	List Of ATA Chapters
37	AC_ATTP_ATT_PARAM_DETAILS	List of possible values for Attribute Type Of Parameters
38	AC_CFAM_COMPONENT_FAMILY	Component Family Details
39	AC_CFPAT_CMP_FAM_AT_PRM	Attribute and Technical parameters for Component Family
40	AC_CFPRC_CMP_FAM_RNGCON_PRM	Range & Consumption Parameters for Component Family is maintained here.
41	AC_CMPID_COMPONENT_ID_INFO	Component Id information
42	AC_CMPOWN_OWNSHIPCHG_HIS	This tables maintains the ownership change history for the components.
43	AC_CMPRC_CMP_RNGCON_PRMLIST	Range and Consumption parameters for Components
44	AC_CMPRC_CMP_RNGCON_PRMLIST_PVLOG	AC_CMPRC_CMP_RNGCON_PRMLIST_PVLOG
45	AC_CMPREF_COMP_REFERENCE_DET	This table has the reference document details maintained for a Component
46	AC_CMPRM_COMP_PRM_HIS	Aircraft Component Parameter History maintained here.
47	AC_CMPTA_CMP_TECHATT_PRMLST	Attribute and Technical parameter list for the Components
48	AC_CMPTS_COMP_TS_VAL_DET	Component parameter value details
49	AC_CMP_DEPRECIATION_TSN_PERIOD_VAL	AC_CMP_DEPRECIATION_TSN_PERIOD_VAL
50	AC_CNGAC_ACREGCHANGE_LOG	Aircraft Registration number change details(Log) maintained here.
51	AC_COMPHS_COM_PRTCHANGE_HIS	This table maintains the details of the part modifications taken place for a component
52	AC_COMP_PRM_HIS_PURGE_APR	Purged information of component parameter value update details for the month of April
53	AC_COMP_PRM_HIS_PURGE_AUG	Purged information of component parameter value update details for the month of August
54	AC_COMP_PRM_HIS_PURGE_DEC	Purged information of component parameter value update details for the month of December
55	AC_COMP_PRM_HIS_PURGE_FEB	Purged information of component parameter value update details for the month of February
56	AC_COMP_PRM_HIS_PURGE_JAN	Purged information of component parameter value update details for the month of January
57	AC_COMP_PRM_HIS_PURGE_JUL	Purged information of component parameter value update details for the month of July
58	AC_COMP_PRM_HIS_PURGE_JUN	Purged information of component parameter value update details for the month of June
59	AC_COMP_PRM_HIS_PURGE_MAR	Purged information of component parameter value update details for the month of March
60	AC_COMP_PRM_HIS_PURGE_MAY	Purged information of component parameter value update details for the month of May
61	AC_COMP_PRM_HIS_PURGE_NOV	Purged information of component parameter value update details for the month of November
62	AC_COMP_PRM_HIS_PURGE_OCT	Purged information of component parameter value update details for the month of October
63	AC_COMP_PRM_HIS_PURGE_SEP	Purged information of component parameter value update details for the month of September
64	AC_ERROR_LOG	Error log
65	AC_GSC_GEN_SERCERT_INFO	AC_GSC_GEN_SERCERT_INFO
66	AC_MDL_AC_MODEL_DEFINITION	Model Definition Table
67	AC_MDRCP_MODEL_RNG_CONS_PRM	Range and Consumption parameters for Models
68	AC_MDTAP_MODEL_TECH_ATT_PRM	Technical and Attribute parameters for Model
69	AC_MFGATA_MFG_ATA_CHAPTER	Maintains Manufacturer ata details against each ATA chapter.
70	AC_NCMB_NON_COMP_MAINT_OBJ	Identifies non-component Maintenance Objects
71	AC_PARAMETER_DETAILS	Meta Data for Aircraft
72	AC_PRM_PARAM_DETAILS	Parameter Master
73	AC_PRTRC_PART_RNGCON_PRMLST	Range and Consumption Parameters for Parts
74	AC_PRTTA_PRT_TECHATT_PRMLST	Technical and Attribute parameter list for parts
75	AC_PVCPRM_COMPONENT_PRM_HIS	Components parameter history maintained here.
76	AC_PVIPRM_INHRIT_PRM	Inhertiable parameters maintained here.
77	AC_PVNPRM_NON_INHRIT_PRM	Non-Inhertiable parameters maintained here.
78	AC_QUICK_CODE	User defined Quick Codes Master
79	AC_SUB_CAL_USGDEPTSN_PV_TSN	AC_SUB_CAL_USGDEPTSN_PV_TSN
80	AC_SUB_CAL_USGDEP_USAGE_DEPRE_NHA_PERIOD	AC_SUB_CAL_USGDEP_USAGE_DEPRE_NHA_PERIOD
81	AC_SUB_CAL_USGDEP_USAGE_DEPRE_PERIOD	AC_SUB_CAL_USGDEP_USAGE_DEPRE_PERIOD
82	ac_tcq_techrecord_queue_dtl	ac_tcq_techrecord_queue_dtl
83	ac_tcq_techrecord_queue_his	Review record update history table
84	AC_USGDEPD_USAGE_DEPRECIATION_DTL	AC_USGDEPD_USAGE_DEPRECIATION_DTL
85	AC_ZND_ZONE_DETAILS	Zone details table
86	basac_prtdev_upd_dtl	To store the part updation details in aircraft

Table Name :	AC_ACASER_AC_SEARCH_MASTER
Comment :	Search master capturing of Aircraft information related filters.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACASER_OUINSTANCE	_decimal_17_0	decimal(17)	No	Ouinstance in search master	No
ACASER_SEARCH_ID	_varchar_30	varchar(30)	No	Search id for Filters	No
ACASER_AC_GROUP	_varchar_20	varchar(20)	Yes	Aircraft group no	No
ACASER_USAGE_TYPE	_varchar_25	Varchar(25)	Yes	Usage Type	No
ACASER_AC_TYPE	_varchar_25	Varchar(25)	Yes	Aircraft Type	No
ACASER_AC_CONDITION	_varchar_5	varchar(5)	Yes	Aircraft condition	No
ACASER_CONFIG_CLASS	_varchar_30	varchar(30)	Yes	Configuration class	No
ACASER_AC_MAKE	_varchar_45	varchar(45)	Yes	Aircraft make(Supplier/Manufacturer)	No
ACASER_OWNERSHIP	_varchar_5	varchar(5)	Yes	Aircraft ownership -Owned,Leased or Leased out	No
ACASER_LEASE_TYPE	_varchar_5	varchar(5)	Yes	Lease Type can be 'Wet' or 'Dry'. Wet means the lesse will take care of the Maintenance. Dry means the Lessor will do the Maintenance	No
ACASER_USER_DEFINED1	_varchar_25	Varchar(25)	Yes	Aircraft user defined details 1	No
ACASER_USER_DEFINED2	_varchar_25	Varchar(25)	Yes	Aircraft user defined details 2	No
ACASER_USER_DEFINED3	_varchar_25	Varchar(25)	Yes	Aircraft user defined details 3	No
ACASER_AC_DETAIL1	_varchar_25	Varchar(25)	Yes	Aircraft details 1	No
ACASER_AC_DETAIL2	_varchar_25	Varchar(25)	Yes	Aircraft details 2	No
ACASER_AC_DETAIL3	_varchar_25	Varchar(25)	Yes	Aircraft details 3	No
ACASER_CREATED_BY	_varchar_30	varchar(30)	Yes	User who created the search master	No
ACASER_CREATEDDATE	_datetime_8	datetime(8)	Yes	Date on which the search master created	No
ACASER_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified User	No
ACASER_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modification date	No
ACASER_TIMESTAMP	_decimal_17_0	decimal(17)	Yes	Timestamp value	No

Table Name :	AC_ACBPRM_AC_BASE_PRM_MAP
Comment :	The mapping between the parameters defined and the used parameters like FH, FC are done here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACBPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
ACBPRM_BASE_PARAM	_varchar_40	varchar(40)	No	Base Parameter	Yes
ACBPRM_USED_PRM	_varchar_40	varchar(40)	Yes	Used Parameter Code	No
ACBPRM_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by	No
ACBPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
ACBPRM_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
ACBPRM_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
ACBPRM_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp	No
ACBPRM_HIDDEN_PARAM	_varchar_40	varchar(40)	Yes	Hidden param code. This will have values from P1 to P10	No

Table Name :	AC_ACCHIS_AC_CONDITION_HIS
Comment :	This tables maintains the condition change history for the Components.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACCHIS_OUINSTANCE	_decimal_38_0	decimal(38)	No	aircraft ouinstance	Yes
ACCHIS_COMPONENT_ID	_varchar_90	varchar(90)	No	Component id	Yes
ACCHIS_FROM_CONDITION	_varchar_5	varchar(5)	No	From Which condition got changed	Yes
ACCHIS_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Component Condtion change date	Yes
ACCHIS_TO_CONDITION	_varchar_5	varchar(5)	Yes	To condition change	No
ACCHIS_TRANSACTION_NO	_varchar_40	varchar(40)	Yes	Transaction no for changing the condition	No
ACCHIS_TRANSACTION_TYPE	_varchar_25	Varchar(25)	Yes	Transaction Component	No
ACCHIS_TRANSACTION_OU	_decimal_38_0	decimal(38)	Yes	Transaction ou	No
ACCHIS_COMMENTS	_varchar_255	varchar(255)	Yes	comments	No
ACCHIS_REMARKS	_varchar_255	varchar(255)	Yes	remarks	No
ACCHIS_MODIFIEDBY	udd_username	varchar(25)	Yes	Modified by	No
ACCHIS_MODIFIEDDATE	udd_datetime1	datetime(8)	Yes	Modified date	No
created_area_code	varchar	Char(10)	Yes	Created Area Code	No

Table Name :	ac_accond_history
Comment :	This tables maintains the condition change history for the Aircrafts.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACCOND_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	No
ACCOND_AIR_REGNO	_varchar_30	varchar(30)	Yes	Aircraft Registration number	No
ACCOND_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference document number	No
ACCOND_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	Reference document type	No
ACCOND_REASON	_varchar_2000	varchar(2000)	Yes	Reason	No
ACCOND_APPROVEDBY	_varchar_30	varchar(30)	Yes	Approved by	No
ACCOND_FROMDATE	_datetime_8	datetime(8)	Yes	Approved From Date	No
ACCOND_COMMENTS	_varchar_2000	varchar(2000)	Yes	Comments	No
ACCOND_AC_CONDITION	_varchar_10	varchar(10)	Yes	Aircraft Condition	No
ACCOND_CREATEDBY	_varchar_30	varchar(30)	Yes	Created by	No
ACCOND_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created date	No
created_area_code	varchar	Char(10)	Yes	Created Area Code	No

Table Name :	AC_ACCSER_CMP_SEARCH_MASTER
Comment :	Search Id capturing of component info related filters.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACCSER_OUINSTANCE	_decimal_38_0	decimal(38)	No	Ouinstance	Yes
ACCSER_SEARCH_ID	_varchar_30	varchar(30)	No	Serarch id for filters	Yes
ACCSER_COMP_FAMILY	_varchar_25	Varchar(25)	Yes	Component Family code	No
ACCSER_COMP_TYPE	_varchar_5	varchar(5)	Yes	Component type-Apu,Engine,landing gear and others	No
ACCSER_MOD_STATUS	_varchar_15	varchar(15)	Yes	Mod status	No
ACCSER_ZONE_NO	_varchar_15	varchar(15)	Yes	Zone no	No
ACCSER_ASSEMBLY_STATUS	_varchar_15	varchar(15)	Yes	Assedmbly Status-Dormant or Complete	No
ACCSER_COMP_OWNERSHIP	_varchar_5	varchar(5)	Yes	Component ownership-	No
ACCSER_COMP_CONDITION	_varchar_5	varchar(5)	Yes	Component condition-New,Serviceable,Unserviceable,Overhaul and phased out	No
ACCSER_NHA	_varchar_40	varchar(40)	Yes	Nha part no	No
ACCSER_POSITION_CODE	_varchar_25	Varchar(25)	Yes	Position code	No
ACCSER_LEVEL_CODE	_varchar_150	varchar(150)	Yes	Level code	No
ACCSER_USER_DETAIL1	_varchar_25	Varchar(25)	Yes	User defined values-Quick codes1	No
ACCSER_USER_DETAIL2	_varchar_25	Varchar(25)	Yes	User defined values-Quick codes2	No
ACCSER_USER_DETAIL3	_varchar_25	Varchar(25)	Yes	User defined values-Quick codes3	No
ACCSER_COMP_DETAIL1	_varchar_25	Varchar(25)	Yes	component detailed values 1	No
ACCSER_COMP_DETAIL2	_varchar_25	Varchar(25)	Yes	component detailed values 2	No
ACCSER_COMP_DETAIL3	_varchar_25	Varchar(25)	Yes	component detailed values 3	No
ACCSER_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	Cargo flag("Yes" or "No")	No
ACCSER_RVSM_FLAG	_varchar_25	Varchar(25)	Yes	Rvsm flag("Yes" or "No")	No
ACCSER_MEL_FLAG	_varchar_25	Varchar(25)	Yes	mel flag("Yes" or "No")	No
ACCSER_CREATED_BY	_varchar_30	varchar(30)	Yes	user name	No
ACCSER_CREATEDDATE	_datetime_8	datetime(8)	Yes	Creation date	No
ACCSER_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modify user	No
ACCSER_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date	No
ACCSER_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	TimeStamp	No
ACCSER_NHACOMPONENT	_varchar_16	varchar(16)	Yes	NHA component	No
ACCSER_PARTNO	_varchar_40	varchar(40)	Yes	part no	No
ACCSER_EIPIN	_varchar_40	varchar(40)	Yes	eipin	No

Table Name :	AC_ACG_AIRCRAFT_GROUP
Comment :	Aircraft Groups List

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACG_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ACG_GROUP_NO	_varchar_20	varchar(20)	No	Group Number	Yes
ACG_DESCRIPTION	_varchar_150	varchar(150)	No	Description Number	No
ACG_CATEGORY	_varchar_25	Varchar(25)	Yes	Category	No
ACG_STATUS	_varchar_15	varchar(15)	Yes	Status	No
ACG_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
ACG_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
ACG_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
ACG_CREATED_BY	_varchar_30	varchar(30)	No	Created By	No
ACG_MODIFIED_BY	_varchar_30	varchar(30)	No	Last Modified By	No

Table Name :	AC_ACINTP_INHERITABLE_PARAM
Comment :	Inheritable parameters list

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACINTP_OUINSTANCE	_decimal_38_0	decimal(38)	No	Ouinstance	Yes
ACINTP_PARAM_CODE	_varchar_40	varchar(40)	No	Valid Parameter code which should be defined in Parameter master	Yes
ACINTP_HIDDEN_PARAM_CODE	_varchar_40	varchar(40)	No	Hidden param code value for pv calculation	No
ACINTP_HIDDEN_PARAM_VAL	_decimal_38_0	decimal(38)	No	Value of the Hidden param code like(1,2..10)	No
ACINTP_CREATED_BY	_varchar_30	varchar(30)	Yes	User name	No
ACINTP_CREATEDDATE	_datetime_8	datetime(8)	Yes	Creation date	No
ACINTP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modify user name	No
ACINTP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modification date	No
ACINTP_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	Timestamp value	No
ACINTP_SRC_OUINSTANCE	_decimal_38_0	decimal(38)	Yes	source OU in interaction model	No

Table Name :	AC_ACIPH_INHRIT_POS_HIS
Comment :	Inheritable position history master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACIPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
ACIPH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Reg no	Yes
ACIPH_POS_CODE	_varchar_25	Varchar(25)	No	Position code	Yes
ACIPH_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	Yes
ACIPH_PRM_ATTR_TYPE	udd_designparamcode	varchar(5)	No	Attribute type-SN(Since new), SO(since overhaul)	Yes
ACIPH_PRM1_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter1 Delta (or) New Flag	No
ACIPH_PRM2_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter2 Delta (or) New Flag	No
ACIPH_PRM3_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter3 Delta (or) New Flag	No
ACIPH_PRM4_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter4 Delta (or) New Flag	No
ACIPH_PRM5_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter5 Delta (or) New Flag	No
ACIPH_PRM6_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter6 Delta (or) New Flag	No
ACIPH_PRM7_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter7 Delta (or) New Flag	No
ACIPH_PRM8_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter8 Delta (or) New Flag	No
ACIPH_PRM9_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter9 Delta (or) New Flag	No
ACIPH_PRM10_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter 10 Delta (or) New Flag	No
ACIPH_PRM1_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter1 Incoming Value	No
ACIPH_PRM2_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter2 Incoming Value	No
ACIPH_PRM3_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter3 Incoming Value	No
ACIPH_PRM4_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter4 Incoming Value	No
ACIPH_PRM5_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter5 Incoming Value	No
ACIPH_PRM6_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter6 Incoming Value	No
ACIPH_PRM7_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter7 Incoming Value	No
ACIPH_PRM8_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter8 Incoming Value	No
ACIPH_PRM9_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter9 Incoming Value	No
ACIPH_PRM10_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter10 Incoming Value	No
ACIPH_INHERITED_FLAG	_varchar_5	varchar(5)	Yes	inherited flag	No
ACIPH_INSP_EMP_CODE	_varchar_30	varchar(30)	Yes	Employee code	No
ACIPH_SRC_TRAN_OU	ctxt_ouinstance	numeric(9)	No	Source transaction ou	Yes
ACIPH_SRC_TRAN_NO	udd_documentno	varchar(40)	No	Source transaction no	Yes
ACIPH_CREATEDBY	_varchar_30	varchar(30)	Yes	Created by	No
ACIPH_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_ACIPH_INHRIT_PRM_HIS
Comment :	Inheritable parameter history master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACIPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
ACIPH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Reg no	Yes
ACIPH_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	Yes
ACIPH_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	Yes
ACIPH_PRM_ATTR_TYPE	_varchar_5	varchar(5)	No	Attribute type-SN(Since new), SO(since overhaul)	Yes
ACIPH_PRM1_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter1 Delta (or) New Flag	No
ACIPH_PRM2_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter2 Delta (or) New Flag	No
ACIPH_PRM3_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter3 Delta (or) New Flag	No
ACIPH_PRM4_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter4 Delta (or) New Flag	No
ACIPH_PRM5_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter5 Delta (or) New Flag	No
ACIPH_PRM6_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter6 Delta (or) New Flag	No
ACIPH_PRM7_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter7 Delta (or) New Flag	No
ACIPH_PRM8_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter8 Delta (or) New Flag	No
ACIPH_PRM9_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter9 Delta (or) New Flag	No
ACIPH_PRM10_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter 10 Delta (or) New Flag	No
ACIPH_RESET_FLAG	_varchar_5	varchar(5)	Yes	Reset Flag	No
ACIPH_PRM1_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter1 Incoming Value	No
ACIPH_PRM1_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter1 Cumulative Value	No
ACIPH_PRM1_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter1 Delta Value	No
ACIPH_PRM2_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter2 Incoming Value	No
ACIPH_PRM2_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter2 Cumulative Value	No
ACIPH_PRM2_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter2 Delta Value	No
ACIPH_PRM3_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter3 Incoming Value	No
ACIPH_PRM3_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter3 Cumulative Value	No
ACIPH_PRM3_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter3 Delta Value	No
ACIPH_PRM4_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter4 Incoming Value	No
ACIPH_PRM4_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter4 Cumulative Value	No
ACIPH_PRM4_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter4 Delta Value	No
ACIPH_PRM5_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter5 Incoming Value	No
ACIPH_PRM5_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter5 Cumulative Value	No
ACIPH_PRM5_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter5 Delta Value	No
ACIPH_PRM6_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter6 Incoming Value	No
ACIPH_PRM6_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter6 Cumulative Value	No
ACIPH_PRM6_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter6 Delta Value	No
ACIPH_PRM7_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter7 Incoming Value	No
ACIPH_PRM7_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter7 Cumulative Value	No
ACIPH_PRM7_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter7 Delta Value	No
ACIPH_PRM8_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter8 Incoming Value	No
ACIPH_PRM8_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter8 Cumulative Value	No
ACIPH_PRM8_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter8 Delta Value	No
ACIPH_PRM9_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter9 Incoming Value	No
ACIPH_PRM9_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter9 Cumulative Value	No
ACIPH_PRM9_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter9 Delta Value	No
ACIPH_PRM10_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Parameter10 Incoming Value	No
ACIPH_PRM10_CUM_VALUE_SN	udd_numericparamval	numeric(13)	No	Parameter10 Cumulative Value	No
ACIPH_PRM10_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Parameter10 Delta Value	No
ACIPH_INSP_EMP_CODE	_varchar_30	varchar(30)	Yes	Employee code	No
ACIPH_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Source Transaction	No
ACIPH_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source transaction ou	Yes
ACIPH_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source transaction no	Yes
ACIPH_CREATEDBY	_varchar_30	varchar(30)	Yes	Created by	No
ACIPH_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No
ACIPH_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
ACNPH_REMARKS	_varchar_255	varchar(255)	Yes	Remarks.	No
ACIPH_INHCHLD	_varchar_5	varchar(5)	Yes	Inherit to child flag	No
ACIPH_PRM_CODE	_varchar_40	varchar(40)	Yes	parameter code	No

Table Name :	AC_ACIPH_INHRIT_PRM_HIS_OLD
Comment :	Aircraft Inheritable parameter history stored here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACIPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
ACIPH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Reg no	No
ACIPH_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
ACIPH_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
ACIPH_PRM_ATTR_TYPE	_varchar_5	varchar(5)	No	Attribute type-SN(Since new), SO(since overhaul)	No
ACIPH_PRM1_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter1 Delta (or) New Flag	No
ACIPH_PRM2_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter2 Delta (or) New Flag	No
ACIPH_PRM3_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter3 Delta (or) New Flag	No
ACIPH_PRM4_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter4 Delta (or) New Flag	No
ACIPH_PRM5_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter5 Delta (or) New Flag	No
ACIPH_PRM6_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter6 Delta (or) New Flag	No
ACIPH_PRM7_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter7 Delta (or) New Flag	No
ACIPH_PRM8_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter8 Delta (or) New Flag	No
ACIPH_PRM9_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter9 Delta (or) New Flag	No
ACIPH_PRM10_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter 10 Delta (or) New Flag	No
ACIPH_RESET_FLAG	_varchar_5	varchar(5)	Yes	Reset Flag	No
ACIPH_PRM1_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter1 Incoming Value	No
ACIPH_PRM1_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter1 Cumulative Value	No
ACIPH_PRM1_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter1 Delta Value	No
ACIPH_PRM2_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter2 Incoming Value	No
ACIPH_PRM2_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter2 Cumulative Value	No
ACIPH_PRM2_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter2 Delta Value	No
ACIPH_PRM3_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter3 Incoming Value	No
ACIPH_PRM3_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter3 Cumulative Value	No
ACIPH_PRM3_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter3 Delta Value	No
ACIPH_PRM4_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter4 Incoming Value	No
ACIPH_PRM4_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter4 Cumulative Value	No
ACIPH_PRM4_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter4 Delta Value	No
ACIPH_PRM5_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter5 Incoming Value	No
ACIPH_PRM5_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter5 Cumulative Value	No
ACIPH_PRM5_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter5 Delta Value	No
ACIPH_PRM6_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter6 Incoming Value	No
ACIPH_PRM6_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter6 Cumulative Value	No
ACIPH_PRM6_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter6 Delta Value	No
ACIPH_PRM7_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter7 Incoming Value	No
ACIPH_PRM7_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter7 Cumulative Value	No
ACIPH_PRM7_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter7 Delta Value	No
ACIPH_PRM8_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter8 Incoming Value	No
ACIPH_PRM8_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter8 Cumulative Value	No
ACIPH_PRM8_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter8 Delta Value	No
ACIPH_PRM9_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter9 Incoming Value	No
ACIPH_PRM9_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter9 Cumulative Value	No
ACIPH_PRM9_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter9 Delta Value	No
ACIPH_PRM10_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter10 Incoming Value	No
ACIPH_PRM10_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter10 Cumulative Value	No
ACIPH_PRM10_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter10 Delta Value	No
ACIPH_INSP_EMP_CODE	_varchar_30	varchar(30)	Yes	Employee code	No
ACIPH_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Source Transaction	No
ACIPH_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source transaction ou	No
ACIPH_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source transaction no	No
ACIPH_CREATEDBY	_varchar_30	varchar(30)	Yes	Created by	No
ACIPH_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_ACIPH_INHRIT_PRM_HIS_PRT
Comment :	Aircraft Inheritable Parameter History stored here..

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACIPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
ACIPH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Reg no	No
ACIPH_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
ACIPH_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
ACIPH_PRM_ATTR_TYPE	_varchar_5	varchar(5)	No	Attribute type-SN(Since new), SO(since overhaul)	No
ACIPH_PRM1_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter1 Delta (or) New Flag	No
ACIPH_PRM2_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter2 Delta (or) New Flag	No
ACIPH_PRM3_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter3 Delta (or) New Flag	No
ACIPH_PRM4_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter4 Delta (or) New Flag	No
ACIPH_PRM5_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter5 Delta (or) New Flag	No
ACIPH_PRM6_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter6 Delta (or) New Flag	No
ACIPH_PRM7_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter7 Delta (or) New Flag	No
ACIPH_PRM8_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter8 Delta (or) New Flag	No
ACIPH_PRM9_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter9 Delta (or) New Flag	No
ACIPH_PRM10_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter 10 Delta (or) New Flag	No
ACIPH_RESET_FLAG	_varchar_5	varchar(5)	Yes	Reset Flag	No
ACIPH_PRM1_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter1 Incoming Value	No
ACIPH_PRM1_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter1 Cumulative Value	No
ACIPH_PRM1_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter1 Delta Value	No
ACIPH_PRM2_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter2 Incoming Value	No
ACIPH_PRM2_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter2 Cumulative Value	No
ACIPH_PRM2_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter2 Delta Value	No
ACIPH_PRM3_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter3 Incoming Value	No
ACIPH_PRM3_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter3 Cumulative Value	No
ACIPH_PRM3_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter3 Delta Value	No
ACIPH_PRM4_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter4 Incoming Value	No
ACIPH_PRM4_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter4 Cumulative Value	No
ACIPH_PRM4_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter4 Delta Value	No
ACIPH_PRM5_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter5 Incoming Value	No
ACIPH_PRM5_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter5 Cumulative Value	No
ACIPH_PRM5_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter5 Delta Value	No
ACIPH_PRM6_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter6 Incoming Value	No
ACIPH_PRM6_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter6 Cumulative Value	No
ACIPH_PRM6_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter6 Delta Value	No
ACIPH_PRM7_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter7 Incoming Value	No
ACIPH_PRM7_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter7 Cumulative Value	No
ACIPH_PRM7_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter7 Delta Value	No
ACIPH_PRM8_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter8 Incoming Value	No
ACIPH_PRM8_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter8 Cumulative Value	No
ACIPH_PRM8_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter8 Delta Value	No
ACIPH_PRM9_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter9 Incoming Value	No
ACIPH_PRM9_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter9 Cumulative Value	No
ACIPH_PRM9_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter9 Delta Value	No
ACIPH_PRM10_INCOMING_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter10 Incoming Value	No
ACIPH_PRM10_CUM_VALUE_SN	_decimal_28_8	decimal(28)	Yes	Parameter10 Cumulative Value	No
ACIPH_PRM10_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Parameter10 Delta Value	No
ACIPH_INSP_EMP_CODE	_varchar_30	varchar(30)	Yes	Employee code	No
ACIPH_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Source Transaction	No
ACIPH_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source transaction ou	No
ACIPH_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source transaction no	No
ACIPH_CREATEDBY	_varchar_30	varchar(30)	Yes	Created by	No
ACIPH_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No
ACIPH_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
ACNPH_REMARKS	_varchar_255	varchar(255)	Yes	Remarks..	No
ACIPH_INHCHLD	_varchar_5	varchar(5)	Yes	Inherit child - Inheriting all the attributes from the source	No

Table Name :	Ac_acipt_inhrit_prm_tran
Comment :	History of actions performed by user in Re-Initialize / Update Parameter Values interface

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Acipt_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	ouinstance	No
Acipt_aircraft_reg_no	udd_aircraftnumber	varchar(30)	Yes	aircraft registeration no	No
Acipt_component_id	udd_componentid	varchar(90)	Yes	component id	No
Acipt_transaction_date	_datetime_8	datetime(8)	Yes	transaction date	No
Acipt_parameter	udd_parameter	varchar(40)	Yes	parameter	No
Acipt_sn	udd_numericparamval	numeric(13)	Yes	since new	No
Acipt_so	udd_numericparamval	numeric(13)	Yes	since overhaul	No
Acipt_sr	udd_numericparamval	numeric(13)	Yes	Since Repair	No
Acipt_si	udd_numericparamval	numeric(13)	Yes	Since Inspection	No
Acipt_lsv	udd_numericparamval	numeric(13)	Yes	Since Last visit	No
Acipt_src_tran_no	udd_documentno	varchar(40)	Yes	source transaction no	No
Acipt_update_option	udd_designparamcode	varchar(5)	Yes	update option	No
Acipt_createdby	udd_ctxt_user	varchar(30)	Yes	createdby	No
Acipt_createddate	_datetime_8	datetime(8)	Yes	createddate	No
Acipt_remarks	udd_remarks	varchar(255)	Yes	remarks	No
Acipt_inhchld	udd_designparamcode	varchar(5)	Yes	inherit child	No
Acipt_Paramtype	udd_designparamcode	varchar(5)	Yes	Param type	No
Acipt_RefDocType	udd_flag	varchar(25)	Yes	Reference Document Type	No
Acipt_RefDocNo	udd_documentno	varchar(40)	Yes	Acipt_RefDocNo	No
Acipt_Inival_Unknown	udd_designparamcode	varchar(5)	Yes	Initial value Unknown	No
Acipt_Mpv_Tran_No	udd_documentno	varchar(40)	Yes	Acipt_Mpv_Tran_No	No
Acipt_RInit_Mpv_No	udd_documentno	varchar(40)	Yes	Acipt_RInit_Mpv_No	No

Table Name :	AC_ACIREF_AC_REFERENCE_DET
Comment :	This table has the reference document details maintained for an Aircraft

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACIREF_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ACIREF_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	aircraft registeration no	Yes
ACIREF_DOCUMENT_NO	_varchar_40	varchar(40)	No	Document Number	Yes
ACIREF_REFDOC_TYPE	_varchar_25	Varchar(25)	No	Reference Document Type	Yes
ACIREF_REFDOC_DESC	_varchar_150	varchar(150)	Yes	Reference Document Description	No
ACIREF_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
ACIREF_FILENAME	_varchar_50	varchar(50)	Yes	File name	No

Table Name :	AC_ACI_Account_Det_Hist
Comment :	History of Aircraft - Operator mapping for finance/accounting reference.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AC_ACI_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
AC_ACI_AIRCRAFT_REG_NO	udd_aircraftnumber	varchar(30)	Yes	Aircraft Registration no	No
AC_ACI_AttributeType	UDD_text	varchar(256)	Yes	AttributeType	No
AC_ACI_Attributecode	udd_financebookid	varchar(20)	Yes	Attributecode	No
AC_ACI_EffectiveFromDate	_datetime_8	datetime(8)	Yes	Effective From Date	No
AC_ACI_EffectiveToDate	_datetime_8	datetime(8)	Yes	Effective To Date	No
AC_ACI_createdby	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	createdby	No
AC_ACI_createddate	_datetime_8	datetime(8)	Yes	createddate	No
AC_ACI_lastmodifiedby	_fin_ctxt_user_30	fin_ctxt_user(30)	Yes	lastmodifiedby	No
AC_ACI_Lastmodifieddate	_datetime_8	datetime(8)	Yes	Lastmodifieddate	No
created_area_code	varchar	Char(10)	Yes	Created Area Code	No

Table Name :	AC_ACI_AIRCRAFT_INFO
Comment :	Aircraft Information Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACI_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ACI_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number	Yes
ACI_MDL_MODEL	_varchar_20	varchar(20)	No	ACI Model	No
ACI_MDL_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	OU Instance	No
ACI_SERIAL_NO	_varchar_40	varchar(40)	No	Serial number of the Aircraft	No
ACI_TAB_NO	_varchar_30	varchar(30)	No	Tab number	No
ACI_TAIL_NO	_varchar_30	varchar(30)	No	Tail Number	No
ACI_CONFIGURATION_ID	_varchar_30	varchar(30)	Yes	Configuration Id - User defined.	No
ACI_REVISION_NO	_varchar_40	varchar(40)	Yes	Revision Number	No
ACI_REG_CERTIFICATE_NO	_varchar_40	varchar(40)	Yes	Certificate number Issued from Regulatory Authority	No
ACI_ISSUE_DATE	_datetime_8	datetime(8)	Yes	Certificate Issue Date	No
ACI_REGULATORY_AUTH	_varchar_25	Varchar(25)	Yes	Name of the Regulatory Authority	No
ACI_COUNTRY	udd_country	varchar(40)	Yes	Country Which has Issued the Certificate	No
ACI_OWNERSHIP	_varchar_5	varchar(5)	No	Ownership can be Owned , Leased or Leased Out	No
ACI_LEASE_TYPE	_varchar_5	varchar(5)	Yes	Lease Type can be Wet or Dry. Wet means the lesse will take care of the Maintenance. Dry means the Lessor will do the Maintenance	No
ACI_PLANNING_BASE	_decimal_10_0	decimal(10)	No	Planning location for the Aircraft	No
ACI_MAINTENANCE_BASE	_decimal_10_0	decimal(10)	Yes	Maintenance Location for the Aircraft	No
ACI_PLANNER_CODE	_varchar_20	varchar(20)	Yes	Planner for the Aircraft	No
ACI_INDUCTION_DATE	_datetime_8	datetime(8)	No	Induction Date of the Aircraft	No
ACI_OPERATIONAL_DATE	_datetime_8	datetime(8)	No	Operational Date of the Aircraft	No
ACI_USAGE_TYPE	_varchar_25	Varchar(25)	Yes	Usage Types are user defined	No
ACI_AIRCRAFT_TYPE	_varchar_25	Varchar(25)	Yes	aircraft Type	No
ACI_AIRCRAFT_CONDITION	_varchar_5	varchar(5)	Yes	Aircraft Condition can be Operational, Under Maintenance or Phased out	No
ACI_FROM_DATE	_datetime_8	datetime(8)	Yes	From Date	No
ACI_LEAD_PARAMETER	_varchar_40	varchar(40)	Yes	Reference Parameter	No
ACI_PO_NUMBER	_varchar_40	varchar(40)	Yes	Purchase Order Number	No
ACI_PO_DATE	_datetime_8	datetime(8)	Yes	Purchase Order Date	No
ACI_ACQUISITION_VALUE	_decimal_28_8	decimal(28)	Yes	Acquisition Value of the Aircraft	No
ACI_BOOK_VALUE	_decimal_28_8	decimal(28)	Yes	Book Value	No
ACI_USER_DEF1	_varchar_25	Varchar(25)	Yes	User Defined Value 1	No
ACI_USER_DEF2	_varchar_25	Varchar(25)	Yes	User Defined Value 2	No
ACI_USER_DEF3	_varchar_25	Varchar(25)	Yes	User Defined Value 3	No
ACI_AIRCRAFT_DET1	_varchar_25	Varchar(25)	Yes	User Defined Value 4	No
ACI_AIRCRAFT_DET2	_varchar_25	Varchar(25)	Yes	User Defined Value 5	No
ACI_AIRCRAFT_DET3	_varchar_25	Varchar(25)	Yes	User Defined Value 6	No
ACI_STATUS	_varchar_5	varchar(5)	Yes	Status of the Aircraft. Can be Active,Inactive or Under Creation	No
ACI_NOTES	_varchar_2000	varchar(2000)	Yes	Notes	No
ACI_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
ACI_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
ACI_CREATIONDATE	_datetime_8	datetime(8)	Yes	Created Date	No
ACI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
ACI_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
ACI_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
ACI_AC_REG_PREFIX	_varchar_30	varchar(30)	Yes	This will be the alphanumeric part of the Aircraft Registration Number	No
ACI_AC_REG_SUFFIX	_varchar_30	varchar(30)	Yes	This will be the running number part of the Aircraft Registration Number	No
ACI_MSN_PREFIX	_varchar_40	varchar(40)	Yes	This will be the alphanumeric part of the Manufacturer Serial Number	No
ACI_MSN_SUFFIX	_varchar_40	varchar(40)	Yes	This will be the running number part of the Manufacturer Serial Number	No
ACI_TAB_PREFIX	_varchar_30	varchar(30)	Yes	This will be the alphanumeric part of the tab no.	No
ACI_TAB_SUFFIX	_varchar_30	varchar(30)	Yes	This will be the running number part of the tab no.	No
ACI_TAIL_PREFIX	_varchar_30	varchar(30)	Yes	This will be the alphanumeric part of the tail number	No
ACI_TAIL_SUFFIX	_varchar_30	varchar(30)	Yes	This will be the running number part of the tail number	No
ACI_MANUFACTURE_DATE	_datetime_8	datetime(8)	Yes	Manufacturer Date	No
ACI_INV_PART_NO	_varchar_40	varchar(40)	Yes	Inventory Part Number	No
ACI_CUST_EFF_CODE	_varchar_30	varchar(30)	Yes	Customer Code	No
ACI_ENGINE_SET_NO	_varchar_30	varchar(30)	Yes	Engine Set Number	No
ACI_POLOCATION_OU	_decimal_38_0	decimal(38)	Yes	PO Location Ouinstance	No
ACI_OWNAGENCY_NO	_varchar_45	varchar(45)	Yes	owning agency code(customer or supplier code)	No
ACI_OWNAGENCY_OU	_decimal_38_0	decimal(38)	Yes	owning agency ou	No
ACI_ENGAGEMENT_TYPE	_varchar_5	varchar(5)	Yes	engagement type	No
ACI_PREV_AC_REG_NO	_varchar_30	varchar(30)	Yes	Previous AC Registration Number	No
aci_base_ac_reg_no	_varchar_30	varchar(30)	Yes	aci_base_ac_reg_no	No
ACOI_BASE_AC_REG_NO	_varchar_30	varchar(30)	Yes	Base Aircraft Registeration no	No
ACI_ASSET_NO	udd_assetnumber	varchar(18)	Yes	Asset Number	No
ACI_ASSET_TAG	udd_assettagno	int(4)	Yes	Asset Tag	No
ACI_ASSET_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Asset Modified By	No
ACI_ASSET_MODIFIED_DATE	udd_datetime	varchar(30)	Yes	Asset Modified Date	No
ACI_PREF_STATUS	udd_partstatus	varchar(40)	Yes	Preferred Status	No
ACI_RETMNT_DATETIME	udd_datetime	varchar(30)	Yes	Retirement Datetime	No
ACI_AOG_FROMDATE	_datetime_8	datetime(8)	Yes	AOG From Date	No
ACI_ACREG_STATUS	_varchar_40	varchar(40)	Yes	AC Registration Status	No
ACI_STATUS_FROMDATE	_datetime_8	datetime(8)	Yes	Status From Date	No
aci_operational_time	udd_time	datetime(8)	Yes	Operational Timings	No
ACI_FHLOGMODE	udd_designparamcode	varchar(5)	Yes	Flight Hours logging mode. Eg. Hobbs Meter Reading(HMR)	No
ACI_QRNTN	udd_designparamcode	varchar(5)	Yes	Quarantined	No
ACI_holdingfb	udd_financebookid	varchar(20)	Yes	Finance Book	No
ACI_holdingfb_date	_datetime_8	datetime(8)	Yes	Finance Book - Date	No
ACI_operatedfor_date	_datetime_8	datetime(8)	Yes	Operated from	No
ACI_operatedfor	udd_charparamval	varchar(32)	Yes	reason of operation	No
ACI_analysiscode_date	_datetime_8	datetime(8)	Yes	Finance - Analysis code from date	No
ACI_analysiscode	udd_designparamcode	varchar(5)	Yes	Finance - Analysis code	No
ACI_subanalysis_date	_datetime_8	datetime(8)	Yes	Finance - Sub analysis code from date	No
ACI_subanalysis	udd_designparamcode	varchar(5)	Yes	Finance - Sub analysis code	No
ACI_REM_FH	udd_numericparamval	numeric(13)	Yes	Remaining Flight hours	No
ACI_REM_FC	udd_numericparamval	numeric(13)	Yes	Remaining Flight Cyles	No
ACI_REM_DAYS	udd_numericparamval	numeric(13)	Yes	Remaining Days	No
ACI_NotesID	udd_guid	varchar(40)	Yes	Notes Id	No
aci_maint_operator_code	udd_charparamval	varchar(32)	Yes	aci_maint_operator_code	No
ACI_TRG_PARAM	udd_parameter	varchar(40)	Yes	Triggering Parameter	No
ACI_TRG_VALUE	udd_numericparamval	numeric(13)	Yes	Triggering Value	No
ACI_MODE_OF_USAGE	udd_designparamcode	varchar(5)	Yes	Mode of Usage	No

Table Name :	AC_ACJLP_JLOG_PRM_INFO
Comment :	Stores journey log parameter information.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACJLP_OUINSTANCE	_decimal_10_0	decimal(10)	No	ou instance	Yes
ACJLP_MODEL	_varchar_20	varchar(20)	No	aircraft model	Yes
ACJLP_CONFIG_CLASS	_varchar_30	varchar(30)	No	configuration class	Yes
ACJLP_LEG_WISE_PARAM	_varchar_5	varchar(5)	No	leg wise parameters. Will have values from P1 to P6	Yes
ACJLP_POSITION_CODE	_varchar_25	Varchar(25)	Yes	position code	No
ACJLP_PARAM_CODE	_varchar_40	varchar(40)	Yes	parameter code	No
ACJLP_MODEL_OU	_decimal_10_0	decimal(10)	Yes	model ou instance	No
ACJLP_CONFIG_OU	_decimal_10_0	decimal(10)	Yes	configuration class ou	No
ACJLP_PARAM_OU	_decimal_10_0	decimal(10)	Yes	parameter ou	No
ACJLP_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
ACJLP_CREATEDDATE	_datetime_8	datetime(8)	Yes	created date	No
ACJLP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
ACJLP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date	No
ACJLP_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	time stamp	No

Table Name :	AC_ACMAN_MANUFTR_MASTER
Comment :	Manufacturer Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACMAN_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
ACMAN_MAN_CODE	_varchar_45	varchar(45)	No	Manufacturer Code	Yes
ACMAN_MAN_DESC	_varchar_150	varchar(150)	Yes	Manufacturer Description	No
ACMAN_MAN_DESC_UP	_varchar_150	varchar(150)	Yes	Manufacturer Description in upper case	No
ACMAN_STATUS	_varchar_5	varchar(5)	Yes	status of the manufacturer code	No
ACMAN_CAGE_CODE	_varchar_5	varchar(5)	Yes	cage code	No
ACMAN_SITA_ARINC_CODE	_varchar_45	varchar(45)	Yes	SITA ARINC Code	No
ACMAN_SPEC_2K_CODE	_varchar_5	varchar(5)	Yes	SPEC 2K CODE	No
ACMAN_NSCM_CODE	_varchar_5	varchar(5)	Yes	NSCM code	No
ACMAN_MAN_CAT	_varchar_25	Varchar(25)	Yes	Manufacturer Category	No
ACMAN_ADDRESS	_varchar_2000	varchar(2000)	Yes	Address Details	No
ACMAN_ADDRESS_UP	_varchar_2000	varchar(2000)	Yes	ADDRESS_UP	No
ACMAN_CON_PHONE	_varchar_70	varchar(70)	Yes	contact phone number	No
ACMAN_URL	_varchar_255	varchar(255)	Yes	URL details	No
ACMAN_CONTACT_PERSON	_varchar_80	varchar(80)	Yes	contact person name	No
ACMAN_WRK_PHONE	_varchar_70	varchar(70)	Yes	Work Phone	No
ACMAN_EMAIL_ID	_varchar_70	varchar(70)	Yes	Email Id	No
ACMAN_CREATEDBY	_varchar_30	varchar(30)	Yes	created by	No
ACMAN_CREATED_DATE	_datetime_8	datetime(8)	Yes	created date	No
ACMAN_MODIFIEDBY	_varchar_30	varchar(30)	Yes	Last modified by	No
ACMAN_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	last modified date	No
ACMAN_TIMESTAMP	_decimal_10_2	decimal(10)	Yes	timestamp	No

Table Name :	AC_ACMD_ModNoEff_Detail
Comment :	Aircraft Model Number Effectivity Detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AcMD_OUInstance	_decimal_18_0	decimal(18)	No	OU Instance	No
AcMD_Aircraft_Reg_No	_varchar_30	varchar(30)	No	Aircraft Registration Number	No
AcMD_Aircraft_Model_NO	_varchar_30	varchar(30)	No	Aircraft Model Number	No
AcMD_Mod_No	_varchar_40	varchar(40)	No	Modification Number (like version number)	No
AcMD_Aircraft_Applicability	_varchar_25	Varchar(25)	Yes	Aircraft Applicability	No
AcMD_Remarks	_varchar_150	varchar(150)	Yes	Remarks	No
AcMD_TimeStamp	_decimal_18_0	decimal(18)	Yes	Timestamp	No
AcMD_Created_By	_varchar_30	varchar(30)	Yes	Created By	No
AcMD_CreationDate	_datetime_8	datetime(8)	Yes	Created on	No
AcMD_Modified_By	_varchar_30	varchar(30)	Yes	Modified By	No
AcMD_ModifiedDate	_datetime_8	datetime(8)	Yes	Modified On	No

Table Name :	AC_ACMH_AIRCRAFT_MAINT_HIS
Comment :	Aircraft Maintenance History.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACMH_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ACMH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registeration number	Yes
ACMH_MAINT_PROG_NO	_varchar_30	varchar(30)	Yes	This is the Last Major Maintenance Program Number that has been performed on the aircraft.	No
ACMH_PM_CYCLE_NO	_varchar_6	varchar(6)	Yes	PM Cycel number of the Maintenance Program	No
ACMH_SCHEDULE_NO	_decimal_10_0	decimal(10)	Yes	Schedule Number of the PM Cycle	No
ACMH_WORK_UNIT_CODE	_varchar_30	varchar(30)	Yes	Work Unit code of the Maintenance Program	No
ACMH_WORK_UNIT_TYPE	_varchar_25	Varchar(25)	Yes	Type of the Work Unit Identified	No
ACMH_LAST_PERFORMED_DATE	_datetime_8	datetime(8)	Yes	The Date on which the Maintenance was performed	No
ACMH_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
ACMH_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No

Table Name :	AC_ACMPH_AC_MAINT_HIS_PRM
Comment :	Maintenance Parameter History.This info will be maintained if the aircraft is not new.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACMPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ACMPH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registeration number	Yes
ACMPH_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
ACMPH_LAST_PERFORMED_VALUE	_decimal_28_8	decimal(28)	Yes	Value when maintenance was last performed	No

Table Name :	AC_ACNPH_NON_INHRIT_POS_HIS
Comment :	Non-Inheritable Parameter Postion history

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACNPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ACNPH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft reg no	Yes
ACNPH_POS_CODE	_varchar_25	Varchar(25)	No	Position code	Yes
ACNPH_PRM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
ACNPH_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction date	Yes
ACNPH_PRM_TYPE	_varchar_5	varchar(5)	Yes	Parameter type-(Consumption,Range,Technical ,Attribute)	No
ACNPH_PRM_ATTR_TYPE	_varchar_5	varchar(5)	Yes	Attribute type-SN(Since new),SO(Since new)	No
ACNPH_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Delta or new flag	No
ACNPH_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Incoming value	No
ACNPH_TA_PRM_VALUE	_varchar_32	varchar(32)	Yes	Tech /Attibute param value	No
ACNPH_INHERITED_FLAG	_varchar_5	varchar(5)	Yes	Inherited flag	No
ACNPH_INSP_EMP_CODE	_varchar_30	varchar(30)	Yes	Employee code	No
ACNPH_SRC_TRAN_OU	_decimal_10_0	decimal(10)	Yes	Source transation ou	No
ACNPH_SRC_TRAN_NO	_varchar_40	varchar(40)	Yes	Source transaction no	No
ACNPH_CREATEDBY	_varchar_30	varchar(30)	Yes	User name	No
ACNPH_CREATEDDATE	_datetime_8	datetime(8)	Yes	Creation date	No

Table Name :	AC_ACNPH_NON_INHRIT_PRM_HIS
Comment :	Non-Inheritable Parameter History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACNPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ACNPH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft reg no	Yes
ACNPH_COMPONENT_ID	_varchar_90	varchar(90)	No	Component id	Yes
ACNPH_PRM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
ACNPH_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction date	Yes
ACNPH_PRM_TYPE	_varchar_5	varchar(5)	Yes	Parameter type-(Consumption,Range,Technical ,Attribute)	No
ACNPH_PRM_ATTR_TYPE	_varchar_5	varchar(5)	No	Attribute type-SN(Since new),SO(Since new)	Yes
ACNPH_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Delta or new flag	No
ACNPH_RESET_FLAG	_varchar_5	varchar(5)	Yes	Reset flag	No
ACNPH_INCOMING_VALUE	udd_numericparamval	numeric(13)	No	Incoming value	No
ACNPH_CUM_PRM_VALUE	udd_numericparamval	numeric(13)	No	Cumulative value	No
ACNPH_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Delta value	No
ACNPH_TA_PRM_VALUE	_varchar_32	varchar(32)	Yes	Tech /Attibute param value	No
ACNPH_INSP_EMP_CODE	_varchar_30	varchar(30)	Yes	Employee code	No
ACNPH_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Transaction name	No
ACNPH_SRC_TRAN_OU	_decimal_10_0	decimal(10)	Yes	Source transation ou	No
ACNPH_SRC_TRAN_NO	_varchar_40	varchar(40)	Yes	Source transaction no	No
ACNPH_CREATEDBY	_varchar_30	varchar(30)	Yes	User name	No
ACNPH_CREATEDDATE	_datetime_8	datetime(8)	Yes	Creation date	No
ACNPH_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No

Table Name :	AC_ACOIL_UPLIFT_DET
Comment :	Oil uplift details of the Aircrafts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACOIL_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ounistance	Yes
ACOIL_MODEL	udd_model	varchar(20)	No	Model number	Yes
ACOIL_CONFIG_CLASS	udd_configid	varchar(30)	No	Configuration Class	Yes
ACOIL_ITEM_CODE	udd_itemcode	varchar(32)	No	Item code	Yes
ACOIL_ITEM_DESC	udd_text255	varchar(255)	Yes	Item description	No
ACOIL_PART_NO	udd_partno	varchar(40)	Yes	Part number	No
ACOIL_UOM	udd_unitofmeasurement	varchar(10)	Yes	Unit of measurement	No
ACOIL_MAX_CAPACITY	udd_quantity	numeric(13)	Yes	Maximum capacity	No
ACOIL_STATUS	udd_designparamcode	varchar(5)	Yes	Status	No
ACOIL_MANDATORY_FLAG	udd_designparamcode	varchar(5)	Yes	Mandatory Flag	No
ACOIL_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created Date	No
ACOIL_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Created By	No
ACOIL_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified Date	No
ACOIL_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified By	No
ACOIL_TIMESTAMP	udd_timestamp	int(4)	Yes	Timestamp	No

Table Name :	AC_ACOI_AC_ACQUISITION_HIS
Comment :	Acquisition History of the Aircraft

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACOI_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouninstance	Yes
ACOI_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registeration number	Yes
ACOI_PREV_REG_NO	_varchar_30	varchar(30)	No	Previous Registration Number	Yes
ACOI_PREV_REG_CERT_NO	_varchar_40	varchar(40)	Yes	Previous Regulatory Authority	No
ACOI_PREV_COUNTRY	_varchar_40	varchar(40)	Yes	Country of the Regulatory Authority	No
ACOI_PREV_OWNER	_varchar_40	varchar(40)	Yes	Previous Owner	No
ACOI_PREV_LESSOR	_varchar_40	varchar(40)	Yes	lessor	No
ACOI_PREV_LESSE	_varchar_40	varchar(40)	Yes	Lesse	No
ACOI_FROM_DATE	_datetime_8	datetime(8)	Yes	From Date	No
ACOI_TO_DATE	_datetime_8	datetime(8)	Yes	To Date	No
ACOI_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
ACOI_CHANGED_BY	_varchar_30	varchar(30)	Yes	Changed by the user	No
ACOI_CHANGED_DATE	_datetime_8	datetime(8)	Yes	Changed date	No
ACOI_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	Confirmed by	No
ACOI_CONFIRMED_DATE	_datetime_8	datetime(8)	Yes	Confirmed on the date	No
aci_base_ac_reg_no	_varchar_30	varchar(30)	Yes	Base Aircraft register no	No
acoi_base_ac_reg_no	_varchar_30	varchar(30)	Yes	base aircraft register number	No

Table Name :	AC_ACPMU_PRM_MTH_USG_HIS
Comment :	Mothly parameter data for Aircraft and Component

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACPMU_AIRCRAFT_OU	_decimal_38_0	decimal(38)	No	Aircraft ouinstance	Yes
ACPMU_AIRCRAFT_NO	_varchar_30	varchar(30)	No	Aircraft number	Yes
ACPMU_COMPONENT_OU	_decimal_38_0	decimal(38)	No	Component ouinsatnce	No
ACPMU_COMPONENT_ID	_varchar_90	varchar(90)	No	Component id	No
ACPMU_YEAR	_decimal_10_0	decimal(10)	No	Year	Yes
ACPMU_MONTH	_decimal_10_0	decimal(10)	No	Month	Yes
ACPMU_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
ACPMU_MONTHLY_USAGE_VAL	_decimal_28_8	decimal(28)	Yes	Monthly usage value	No
ACPMU_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by	No
ACPMU_CREATED_DATE	_varchar_30	varchar(30)	Yes	Created date	No
ACPMU_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No
ACPMU_MODIFIED_DATE	_varchar_30	varchar(30)	Yes	Modified date	No

Table Name :	AC_ACPP_PART_PREFIX
Comment :	Last generated number details for each Component ID prefix defined in the system

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACPP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinsatnce	Yes
ACPP_COMP_ID_PRFX	_varchar_18	varchar(18)	No	component id prefix	Yes
ACPP_LAST_NUM_GEN	_decimal_10_0	decimal(10)	No	Last generated number	No

Table Name :	AC_ACPRC_AC_RNGCON_PRM_LIST
Comment :	Range and Consumption Parameters of Aircraft

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACPRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	Yes
ACPRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft register number	Yes
ACPRC_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
ACPRC_PARAM_TYPE	_varchar_5	varchar(5)	No	Parameter Type - Can be R - Range or C - Consumt	No
ACPRC_LIFE_PRM_FLAG	_varchar_25	Varchar(25)	Yes	This flag indicates if the parameter is the life parameter for the Aircraft	No
ACPRC_PARAM_SOURCE	_varchar_5	varchar(5)	Yes	Parameter Source indicates how the value gets updated.Can be one of the following values Parent, Flight Log, Manual, Calculated or Composite.	No
ACPRC_FROM_VALUE	_decimal_28_8	decimal(28)	Yes	From Value	No
ACPRC_TO_VALUE	_decimal_28_8	decimal(28)	Yes	To Value	No
ACPRC_AVERAGE_VALUE	_decimal_28_8	decimal(28)	Yes	Average Value	No
ACPRC_FORECAST_FACTOR	_decimal_28_8	decimal(28)	Yes	This is the Multiplication Factor which is used in Forecasting	No
ACPRC_ULTIMATE_LIFE	_decimal_28_8	decimal(28)	Yes	Ultimate life gives the maximum life of the lead (reference) parameter after which the component should be discarded.	No
ACPRC_FORMULA_ID	_varchar_20	varchar(20)	Yes	Formula id based on which the value gets updated.	No
ACPRC_PRESENT_VALUE	_decimal_28_8	decimal(28)	Yes	Present Value	No
ACPRC_AS_OF_DATE	_datetime_8	datetime(8)	Yes	Present Value as of Date	No
ACPRC_AS_OF_TIME	_datetime_8	datetime(8)	Yes	Present Value as of Time	No
ACPRC_WARRANT_TRACKING	_varchar_5	varchar(5)	Yes	Warranty Tracking Flag	No
ACPRC_PARAM_UPDATE	_varchar_5	varchar(5)	Yes	Parameter Update - MND - mandatory or NMD - Non Mandatory	No
ACPRC_UPDATE_MODE	_varchar_5	varchar(5)	Yes	Update Mode - N - New or D - Delta	No
ACPRC_COMPUTESEQ	_decimal_10_0	decimal(10)	Yes	Computational Sequence for Formula Based parameters for Formula Id calculation	No
ACPRC_FHLOGMODE	udd_designparamcode	varchar(5)	Yes	Flight Hours logging mode. Eg. Hobbs Meter Reading(HMR)	No
created_area_code	varchar	Char(10)	Yes	Created Area Code	No

Table Name :	AC_ACPRT_AIRCRAFT_PART_INFO
Comment :	Maintenance Information of Parts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACPRT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
ACPRT_PART_NO	_varchar_40	varchar(40)	No	Part Number	Yes
ACPRT_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance where the part has been created	No
ACPRT_COMP_GEN_FLAG	_varchar_5	varchar(5)	Yes	Component generation Flag. Can either be Manual or Auto.	No
ACPRT_COMP_ID_PRFX	udd_prefix	varchar(6)	Yes	The prefix to be used while generating the Component Id number if the Auto generate option is set.	No
ACPRT_COMP_FAMILY_CODE	_varchar_25	Varchar(25)	Yes	Component Family code	No
ACPRT_COMP_TYPE	_varchar_5	varchar(5)	Yes	Can be Apu,Engine,Landing Gear and Others	No
ACPRT_PART_CLASSIFY	_varchar_5	varchar(5)	Yes	Can be Repairable, Rotable or Consumable	No
ACPRT_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Chaptor number	No
ACPRT_ATA_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	ATA OU insatnce	No
ACPRT_ZONE_NO	_varchar_15	varchar(15)	Yes	zone no	No
ACPRT_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	Y indicates that the Part is for a Cargo Plane	No
ACPRT_MEL_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if this is the Minimum Equipment List	No
ACPRT_RVSM_FLAG	_varchar_25	Varchar(25)	Yes	Y Indicates if it is the Reduced Vertical Seperation Minimum.	No
ACPRT_PLANNING_BASE	_decimal_10_0	decimal(10)	Yes	Planning Location for the Part	No
ACPRT_MAINT_BASE	_decimal_10_0	decimal(10)	Yes	Maintenance Location for the part	No
ACPRT_PLANNER_CODE	_varchar_20	varchar(20)	Yes	Employee Code	No
ACPRT_USAGE_TYPE	_varchar_25	Varchar(25)	Yes	User Defined Type	No
ACPRT_LEAD_PARAM_CODE	_varchar_40	varchar(40)	Yes	Lead parameter for the part. This is the reference parameter that decides the life of the part	No
ACPRT_USER_DEF1	_varchar_25	Varchar(25)	Yes	Additional Info for the part. User defined 1	No
ACPRT_USER_DEF2	_varchar_25	Varchar(25)	Yes	Additional Info for the part. User defined 2	No
ACPRT_USER_DEF3	_varchar_25	Varchar(25)	Yes	Additional Info for the part. User defined 3	No
ACPRT_COMP_DET1	_varchar_25	Varchar(25)	Yes	Additional Info for the part. User defined 4	No
ACPRT_COMP_DET2	_varchar_25	Varchar(25)	Yes	Additional Info for the part. User defined 5	No
ACPRT_COMP_DET3	_varchar_25	Varchar(25)	Yes	Additional Info for the part. User defined 6	No
ACPRT_CREATED_BY	_varchar_30	varchar(30)	Yes	Created User Name	No
ACPRT_CREATIONDATE	_datetime_8	datetime(8)	Yes	Created Date	No
ACPRT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User Name	No
ACPRT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
ACPRT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
ACPRT_LAST_NUM_GEN	_decimal_10_0	decimal(10)	Yes	Last Number Type Number	No
ACPRT_PART_CATEGORY_TXT	_varchar_25	Varchar(25)	Yes	part category	No
ACPRT_REPLACEMENT_TYPE	_varchar_5	varchar(5)	Yes	Replacement Type	No
ACPRT_DEF_WCCODE	_varchar_30	varchar(30)	Yes	Default WC Code	No
acprt_lifted	_varchar_5	varchar(5)	Yes	Lifed flag	No
acprt_maint_proc	_varchar_5	varchar(5)	Yes	Maintenance Process(HotTime, OnCondition, Continously Monitoring)	No
acprt_exec_fac	_varchar_5	varchar(5)	Yes	Execution Facility (Internal / External)	No
acprt_pref_rep_agency	_varchar_25	Varchar(25)	Yes	Preferred Repair Agency	No
acprt_phase_out_policy	_varchar_5	varchar(5)	Yes	Phase out policy	No
ACPRT_COMP_TRACKED	_varchar_5	varchar(5)	Yes	Component Tracked flag	No
ACPRT_AUTOLAND_FLAG	_varchar_25	Varchar(25)	Yes	Auto Landing flag	No
ACPRT_SOS_APP	udd_designparamcode	varchar(5)	Yes	SOS Applicability	No
ACPRT_EXEDOC_INT_REP	udd_quickcodes	varchar(25)	Yes	Default Exec.Doc for Int.Repair Routing	No
ACPRT_ETOPS_FLAG	udd_designparamcode	varchar(5)	Yes	ETOP flag	No
ACPRT_LLM_CODE	udd_quickcodes	varchar(25)	Yes	Lower Landing Minimum code	No
ACPRT_CFGCTRL_BASIS	udd_designparamcode	varchar(5)	Yes	Configuration Control Basis	No
ACPRT_PMA	udd_designparamcode	varchar(5)	Yes	PMA	No
ACPRT_TAT	udd_duration	numeric(13)	Yes	TAT	No
ACPRT_ULTI_LIFE_DAY	udd_usage	numeric(13)	Yes	Ultimate Life - Day	No
ACPRT_MaintOEMPartNo	udd_partno	varchar(40)	Yes	OEM Part #	No
ACPRT_CONSOLIDATD_WO_FLAG	udd_designparamcode	varchar(5)	Yes	Consolidate Exec. Order flag	No

Table Name :	AC_ACPTA_AC_TECH_ATT_PRMLST
Comment :	Technical and Attribute parameters of Aircraft

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACPTA_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ACPTA_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Register no	Yes
ACPTA_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
ACPTA_PARAM_TYPE	_varchar_5	varchar(5)	No	Parameter Type	No
ACPTA_PARAM_SOURCE	_varchar_5	varchar(5)	Yes	Parameter Source indicates how the value gets updated.Can be one of the following values Parent, Flight Log, Manual, Calculated or Composite.	No
ACPTA_PRESENT_VALUE	_varchar_15	varchar(15)	Yes	Present Value	No
ACPTA_AS_OF_DATE	_datetime_8	datetime(8)	Yes	Present Value As of Date	No
ACPTA_AS_OF_TIME	_datetime_8	datetime(8)	Yes	Present Value as of Time	No

Table Name :	AC_ACPTMD_PART_MODEL_EFFECT
Comment :	Model where this part is applicable is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACPTMD_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	No
ACPTMD_PART_NO	_varchar_40	varchar(40)	No	Part number	No
ACPTMD_MODEL_NO	udd_model	varchar(20)	Yes	Model Number	No
ACPTMD_MODEL_OU	udd_ctxt_ouinstance	int(4)	Yes	Model ou	No
ACPTMD_AIRCRAFT	udd_aircraftnumber	varchar(30)	Yes	Aircraft number	No
ACPTMD_NHA_PART	udd_partno	varchar(40)	Yes	Next higher level Part	No
ACPTMD_NHA_SERIAL	udd_partserialnumber	varchar(40)	Yes	Next higher level Serial	No
ACPTMD_EFF_NOTES	udd_txt2000	varchar(2000)	Yes	Effective notes	No
ACPTMD_REF_DOC_TYPE	udd_desc40	varchar(40)	Yes	Reference doument type	No
ACPTMD_REF_DOC_NO	udd_desc40	varchar(40)	Yes	Reference document number	No
ACPTMD_REF_DOC_REVNO	udd_designparamcode	varchar(5)	Yes	Reference document revision number	No
ACPTMD_CURR_EFF	udd_designparamcode	varchar(5)	Yes	Current Effectivity	No
ACPTMD_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Created by	No
ACPTMD_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created date	No
ACPTMD_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
ACPTMD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	modified date	No
ACPTMD_SEQNO	udd_seqno	int(4)	No	Sequence number	Yes
ACPTMD_SEQNO1	udd_seqno	int(4)	No	ACPTMD_SEQNO1	Yes

Table Name :	ac_acptpo_phase_out_policy
Comment :	Phase out policy for parts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
acptpo_ouinstance	_decimal_18_0	decimal(18)	Yes	Organization Unit	No
acptpo_part_no	_varchar_40	varchar(40)	Yes	Part #	No
acptpo_work_center	_varchar_30	varchar(30)	Yes	Work Center	No
acptpo_include_chd	_varchar_5	varchar(5)	Yes	Include child flag	No
acptpo_exec_unit	_decimal_18_0	decimal(18)	Yes	Execution Unit	No

Table Name :	ac_acqcsts_status_history
Comment :	Aircraft Status History maintained here..

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACQCSTS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	No
ACQCSTS_AIR_REGNO	_varchar_30	varchar(30)	Yes	Aircraft register number	No
ACQCSTS_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference document number	No
ACQCSTS_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	Reference doument type	No
ACQCSTS_REASON	_varchar_2000	varchar(2000)	Yes	Reason	No
ACQCSTS_APPROVEDBY	_varchar_30	varchar(30)	Yes	Approved by the user	No
ACQCSTS_FROMDATE	_datetime_8	datetime(8)	Yes	Approved from date	No
ACQCSTS_COMMENTS	_varchar_2000	varchar(2000)	Yes	Comments	No
ACQCSTS_ACREG_STATUS	_varchar_15	varchar(15)	Yes	Aircraft Registeration Satus	No
ACQCSTS_CREATEDBY	_varchar_30	varchar(30)	Yes	Created by	No
ACQCSTS_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created date	No

Table Name :	AC_ACSTS_STATUS_HISTORY
Comment :	Aircraft Status History maintained here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ACSTS_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
ACSTS_AIR_REGNO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
ACSTS_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Document Number	No
ACSTS_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	Reference Document Type	No
ACSTS_REASON	_varchar_2000	varchar(2000)	Yes	Reason	No
ACSTS_APPROVEDBY	_varchar_30	varchar(30)	Yes	Approved by	No
ACSTS_FROMDATE	_datetime_8	datetime(8)	Yes	Status From Date	No
ACSTS_COMMENTS	_varchar_2000	varchar(2000)	Yes	Comments	No
ACSTS_STATUS	_varchar_10	varchar(10)	Yes	Status of the Aircraft	No
ACSTS_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
ACSTS_CREATEDDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
created_area_code	varchar	Char(10)	Yes	Created Area Code	No

Table Name :	AC_AGR_AIRCRAFT_GROUP_REG
Comment :	Aircraft mapping to a Group

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AGR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
AGR_GROUP_NO	_varchar_20	varchar(20)	No	Group number	Yes
AGR_AIRCRAFT_REG_NO	_varchar_150	varchar(150)	No	Aircraft Registration Number	Yes
AGR_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
AGR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
AGR_USERID	_varchar_30	varchar(30)	No	User id	No

Table Name :	AC_AOG_STATUS_HISTORY
Comment :	Stores Aircraft On Ground Status details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AOG_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
AOG_AIR_REGNO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
AOG_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Document Number	No
AOG_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	Reference Document Type	No
AOG_REASON	_varchar_2000	varchar(2000)	Yes	Reason	No
AOG_APPROVEDBY	_varchar_30	varchar(30)	Yes	Approved By	No
AOG_FROMDATE	_datetime_8	datetime(8)	Yes	From Date	No
AOG_COMMENTS	_varchar_2000	varchar(2000)	Yes	Comments	No
AOG_STATUS	_varchar_10	varchar(10)	Yes	Status	No
AOG_CREATEDBY	_varchar_30	varchar(30)	Yes	Created by	No
AOG_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_ATA_ATACHAPTER
Comment :	List Of ATA Chapters

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ATA_OUINSTANCE	_decimal_10_0	decimal(10)	No	ATA OUInstance	Yes
ATA_CHAPTERNO	_varchar_16	varchar(16)	No	Air Traffic Association Chapter Number	Yes
ATA_DESCRIPTION	_varchar_150	varchar(150)	No	Description of the ATA Chaptor	No
ATA_DESCRIPTION_UP	_varchar_150	varchar(150)	No	Upper Description of the ATA Chaptor	No
ATA_STATUS	_varchar_15	varchar(15)	Yes	Status of the ATA Chapter. Can be Active or Inactive	No
ATA_CREATED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
ATA_CREATIONDATE	_datetime_8	datetime(8)	Yes	Created Date	No
ATA_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
ATA_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
ATA_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No

Table Name :	AC_ATTP_ATT_PARAM_DETAILS
Comment :	List of possible values for Attribute Type Of Parameters

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ATTP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
ATTP_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
ATTP_PARAM_VALUE	udd_charparamval	varchar(32)	No	The Various values the paramter can take	Yes
ATTP_PARAM_REMARKS	_varchar_255	varchar(255)	Yes	remarks for the attribute parameter	No
ATTP_USERID	_varchar_30	varchar(30)	Yes	Last Modified User Name	No
ATTP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
ATTP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
ATTP_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
ATTP_PARAM_TYPE	_varchar_5	varchar(5)	Yes	Paremeter Type - Can be A - attribute and T - Technical	No

Table Name :	AC_CFAM_COMPONENT_FAMILY
Comment :	Component Family Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFAM_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFAM_FAMILYCODE	_varchar_25	Varchar(25)	No	Name of the component Family	Yes
CFAM_DESCRIPTION	_varchar_80	varchar(80)	Yes	Description of the Family code	No
CFAM_ATA_CHAPTERNO	_varchar_16	varchar(16)	Yes	Chapter No	No
CFAM_COMPONENT_TYPE	_varchar_5	varchar(5)	No	Type of the Component -Apu,Engine,Landing Gear and Others.	No
CFAM_PART_CLASSIFY	_varchar_5	varchar(5)	Yes	Type of the Component.Can take values, "Rotable","Repairable" or "Consumable"	No
CFAM_ZONE_NO	_varchar_15	varchar(15)	Yes	zone no	No
CFAM_STATUS	_varchar_25	Varchar(25)	No	Status of the Component family	No
CFAM_CARGO_FLAG	_varchar_25	Varchar(25)	No	Y (Yes) indicates that the component list is for a cargo plane.	No
CFAM_MEL_FLAG	_varchar_25	Varchar(25)	No	Y (Yes) indicates that the component list is the Minimum Equipment List.	No
CFAM_RVSM_FLAG	_varchar_25	Varchar(25)	No	Y indicates that the component list is Reduced Vertical Seperation Minimum	No
CFAM_CREATED_BY	_varchar_30	varchar(30)	No	Created User Name	No
CFAM_CREATIONDATE	_datetime_8	datetime(8)	No	Created Date	No
CFAM_MODIFIED_BY	_varchar_30	varchar(30)	No	Last Modified User Name	No
CFAM_MODIFIEDDATE	_datetime_8	datetime(8)	No	Last Modified Date	No
CFAM_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp	No

Table Name :	AC_CFPAT_CMP_FAM_AT_PRM
Comment :	Attribute and Technical parameters for Component Family

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFPAT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFPAT_FAMILYCODE	_varchar_25	Varchar(25)	No	Family Code	Yes
CFPAT_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
CFPAT_PARAM_VALUE	udd_charparamval	varchar(32)	Yes	Valid value the Attribute or technical paramter can take.	No
CFPAT_PARAM_TYPE	_varchar_25	Varchar(25)	Yes	Parameter Type - Can be Attribute or Technical	No
CFPAT_PARAM_SOURCE	_varchar_10	varchar(10)	Yes	This value indicates the source thru which the parameter gets updated. This can take values Parent, Flight Log, Manual, Calculated or Composite.	No

Table Name :	AC_CFPRC_CMP_FAM_RNGCON_PRM
Comment :	Range & Consumption Parameters for Component Family is maintained here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFPRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFPRC_FAMILYCODE	_varchar_25	Varchar(25)	No	Family Code	Yes
CFPRC_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
CFPRC_PARAM_TYPE	_varchar_25	Varchar(25)	Yes	Parameter Type - Can be R - Range or C - Consumption	No
CFPRC_PARAM_SOURCE	_varchar_10	varchar(10)	Yes	This value indicates the source thru which the parameter gets updated. This can take values Parent, Flight Log, Manual, Calculated or Composite.	No
CFPRC_LIFE_PARAM_FLAG	_varchar_25	Varchar(25)	Yes	This flag indicates whether the parameter is a life parameter or not	No
CFPRC_ULTIMATE_LIFE	_decimal_28_8	decimal(28)	Yes	Ultimate Life Value for the parameter	No
CFPRC_FROM_VALUE	_decimal_28_8	decimal(28)	Yes	The start value of the range/Consumption parameter	No
CFPRC_TO_VALUE	_decimal_28_8	decimal(28)	Yes	To Value of the range/Consumption parameter	No
CFPRC_FORMULA_ID	_varchar_20	varchar(20)	Yes	Formula id based on which the parameter will get updated	No
CFPRC_AVERAGE_VALUE	_decimal_28_8	decimal(28)	Yes	Average Value	No
CFPRC_FORECAST_FACTOR	_decimal_28_8	decimal(28)	Yes	Forecast Factor	No
CFPRC_WARRANT_TRACKING	_varchar_25	Varchar(25)	Yes	Warranty Tracking - Can be Y - Yes or N - No	No
CFPRC_PARAM_UPDATE	_varchar_25	Varchar(25)	Yes	Parameter Update - MND - Mandatory, NMD - Non Mandatory	No
CFPRC_UPDATE_MODE	_varchar_25	Varchar(25)	Yes	Update Mode - N- New, D - Delta	No

Table Name :	AC_CMPID_COMPONENT_ID_INFO
Comment :	Component Id information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPID_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CMPID_COMPONENT_ID	_varchar_90	varchar(90)	No	Component Id	Yes
CMPID_PART_NO	_varchar_40	varchar(40)	Yes	Part number	No
CMPID_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	Part ouinstance	No
CMPID_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number of the Part	No
CMPID_STATUS	_varchar_5	varchar(5)	Yes	Status of the Component. This is user defined	No
CMPID_COMP_FAMILY_NO	_varchar_25	Varchar(25)	Yes	Family Id of the Component	No
CMPID_COMP_TYPE	_varchar_5	varchar(5)	Yes	Component Type-Apu-A,Engine-E, Landing Gear-L,Others-O	No
CMPID_PART_CLASSIFY	_varchar_5	varchar(5)	Yes	Type can be "Rotable', 'Repairable', or 'Consumable'	No
CMPID_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Number	No
CMPID_ZONE_NO	_varchar_15	varchar(15)	Yes	zone code	No
CMPID_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	Cargo	No
CMPID_RVSM_FLAG	_varchar_25	Varchar(25)	Yes	RVSM	No
CMPID_MEL_FLAG	_varchar_25	Varchar(25)	Yes	Minimum Equipment List Flag - Can be Yes or No	No
CMPID_OWNERSHIP	_varchar_5	varchar(5)	Yes	Onwership of the Component. Can be Owned or External	No
CMPID_POSESSION_STATUS	_varchar_5	varchar(5)	Yes	Posession Status of the Component can be Loaned or Exchanged	No
CMPID_INDUCTION_DATE	_datetime_8	datetime(8)	Yes	Induction Date of the Component	No
CMPID_OPERATION_DATE	_datetime_8	datetime(8)	Yes	Operation Date of the Component	No
CMPID_PLANNING_BASE	_decimal_10_0	decimal(10)	Yes	Planning Base	No
CMPID_MAINT_BASE	_decimal_10_0	decimal(10)	Yes	Maintenance Base indentified for the Component	No
CMPID_PLANNER_CODE	_varchar_20	varchar(20)	Yes	Employee who plans for the component	No
CMPID_COMPONENT_CONDITION	_varchar_5	varchar(5)	Yes	Component condition	No
CMPID_FROMDATE	_datetime_8	datetime(8)	Yes	From Date	No
CMPID_LEAD_PARAM_CODE	_varchar_40	varchar(40)	Yes	Lead Parameter Code	No
CMPID_PO_NUMBER	_varchar_40	varchar(40)	Yes	PO Number	No
CMPID_PO_DATE	_datetime_8	datetime(8)	Yes	PO Date	No
CMPID_ACQUISITION_VALUE	_decimal_28_8	decimal(28)	Yes	Aquicisition Value	No
CMPID_BOOK_VALUE	_decimal_28_8	decimal(28)	Yes	Book Value	No
CMPID_USER_DEF1	_varchar_25	Varchar(25)	Yes	User defined details 1	No
CMPID_USER_DEF2	_varchar_25	Varchar(25)	Yes	User defined details 2	No
CMPID_USER_DEF3	_varchar_25	Varchar(25)	Yes	User defined details 3	No
CMPID_COMPONENT_DET1	_varchar_25	Varchar(25)	Yes	Additional details 1 if any	No
CMPID_COMPONENT_DET2	_varchar_25	Varchar(25)	Yes	Additional details 2 if any	No
CMPID_COMPONENT_DET3	_varchar_25	Varchar(25)	Yes	Additional details 3 if any	No
CMPID_NOTES	_varchar_2000	varchar(2000)	Yes	Notes	No
CMPID_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CMPID_SERIAL_PRE	_varchar_40	varchar(40)	Yes	Serial Number prefix	No
CMPID_SERIAL_SUFF	_varchar_40	varchar(40)	Yes	Serial Number Suffix	No
CMPID_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
CMPID_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
CMPID_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified by	No
CMPID_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
CMPID_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
CMPID_MSN_NO	_varchar_40	varchar(40)	Yes	Manufacturer serial number	No
CMPID_MANUFACTURED_DATE	_datetime_8	datetime(8)	Yes	Manufactured Date	No
CMPID_DEF_WCCODE	_varchar_30	varchar(30)	Yes	Default work center code	No
CMPID_POLOCATION_OU	udd_ctxt_ouinstance	int(4)	Yes	Components PO location	No
CMPID_ENGAGEMENT_TYPE	_varchar_5	varchar(5)	Yes	engagement type	No
CMPID_OWNING_AGENCY_NO	_varchar_45	varchar(45)	Yes	owning agency code. can have customer code or supplier code	No
CMPID_OWNING_AGENCY_OU	udd_ctxt_ouinstance	int(4)	Yes	owning agency ou	No
CMPID_FIRST_ISSUE	_varchar_25	Varchar(25)	Yes	first issue.	No
cmpid_pref_status	_varchar_40	varchar(40)	No	Preferred Status	No
CMPID_STKSTATUS	udd_partstatus	varchar(40)	Yes	Stock Status	No
CMPID_RETMNT_DATETIME	udd_datetime1	datetime(8)	Yes	Retirement Datetime	No
CMPID_NotesID	udd_guid	varchar(40)	Yes	Notes identity number	No
cmpid_opr_code	udd_charparamval	varchar(32)	Yes	Operator code	No
cmpid_DER	udd_designparamcode	varchar(5)	Yes	DER flag	No
CMPID_RETIREMENT_FLAG	udd_designparamcode	varchar(5)	Yes	Retirement Flag	No
CMPID_lastveriBy	txt150	varchar(150)	Yes	CMPID_lastveriBy	No
CMPID_lastveriDate	datetime	Datetime(8)	No	CMPID_lastveriDate	No
CMPID_UserStatus	txt150	varchar(150)	No	CMPID_UserStatus	No
CMPID_VeriComments	txt2000	varchar(2000)	No	CMPID_VeriComments	No
CMPID_VerifiStatus	txt150	varchar(150)	No	CMPID_VerifiStatus	No
CMPID_MFRNO	udd_vendorcode	varchar(45)	Yes	CMPID_Manufacturer number	No
CMPID_MFRPARTNO	udd_partno	varchar(40)	Yes	CMPID_Manufacturer part number	No
created_area_code	udd_partno	varchar(40)	Yes	created area code	No

Table Name :	AC_CMPOWN_OWNSHIPCHG_HIS
Comment :	This tables maintains the ownership change history for the components.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPOWN_OUINSTANCE	_decimal_10_0	decimal(10)	No	component ouinstance	Yes
CMPOWN_COMPONENT_ID	_varchar_90	varchar(90)	No	Component id	Yes
CMPOWN_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Component Ownership change date	Yes
CMPOWN_TRANSACTION_NO	_varchar_40	varchar(40)	No	Transaction no for changing the component ownership	Yes
CMPOWN_TRANSACTION_TYPE	_varchar_25	Varchar(25)	No	Transaction Component	Yes
CMPOWN_TRANSACTION_OU	_decimal_10_0	decimal(10)	Yes	Transaction ou	No
CMPOWN_COMPOWNERSHIP	_varchar_25	Varchar(25)	Yes	Component ownership ,Supplier ,Customer ,Owned	No
CMPOWN_COMPPOSESSIONSTATUS	_varchar_25	Varchar(25)	Yes	CMPOWN_COMPPOSESSIONSTATUS	No
CMPOWN_OWNINGAGENCY	_varchar_25	Varchar(25)	Yes	Owing agency number	No
CMPOWN_OWNAGENCYNAME	udd_txt150	varchar(150)	Yes	Owning Agency name	No
CMPOWN_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
CMPOWN_TRANSFERTYPE	_varchar_25	Varchar(25)	Yes	Component Transfer Type String as (a) "Exchange-In" ( b) "Exchange-Out" ( c) "Salvaged	No
CMPOWN_CHANGEDESC	_varchar_255	varchar(255)	Yes	String as Changed attribute names + "Edited". Attribute names Compnent ownership Possession status Owning Agency	No
cmpown_oprcode	udd_charparamval	varchar(32)	Yes	Operator code	No
cmpown_DER	udd_designparamcode	varchar(5)	Yes	DER flag	No

Table Name :	AC_CMPRC_CMP_RNGCON_PRMLIST
Comment :	Range and Consumption parameters for Components

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CMPRC_COMPONENT_ID	_varchar_90	varchar(90)	No	Component id	Yes
CMPRC_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
CMPRC_PARAM_TYPE	_varchar_5	varchar(5)	Yes	Parameter Type. Can by R - Range or C - Consumption	No
CMPRC_LIFE_PRM_FLAG	_varchar_5	varchar(5)	Yes	Flag indicating if the parameter identified is life parameter or not for the component	No
CMPRC_PARAM_SOURCE	_varchar_5	varchar(5)	Yes	Parameter Source indicates how the value gets updated.Can be one of the following values Parent, Flight Log, Manual, Calculated or Composite.	No
CMPRC_FROM_VALUE	_decimal_28_8	decimal(28)	Yes	From Value of the Parameter	No
CMPRC_TO_VALUE	_decimal_28_8	decimal(28)	Yes	To Value of the Parameter	No
CMPRC_AVERAGE_VALUE	_decimal_28_8	decimal(28)	Yes	Average Value	No
CMPRC_FORECAST_FACTOR	_decimal_28_8	decimal(28)	Yes	Forecast Factor.	No
CMPRC_ULTIMATE_LIFE	_decimal_28_8	decimal(28)	Yes	Ultimate life gives the maximum life of the reference parameter after which the component is discarded. No of Kilometers in case of a car.	No
CMPRC_FORMULA_ID	_varchar_20	varchar(20)	Yes	Formula Id for the parameter	No
CMPRC_AS_OF_DATE	_datetime_8	datetime(8)	Yes	Parameter Value af of Date	No
CMPRC_AS_OF_TIME	_datetime_8	datetime(8)	Yes	Parameter Value af of Time	No
CMPRC_WARRANT_TRACKING	_varchar_5	varchar(5)	Yes	Warranty Tracking Flag	No
CMPRC_PARAM_UPDATE	_varchar_5	varchar(5)	Yes	Parameter Update - MND - Mandatory or NMD - Non Mandatory	No
CMPRC_UPDATE_MODE	_varchar_5	varchar(5)	Yes	Update Mode. Can be either n - New or D - Delta	No
CMPRC_TSN	_decimal_28_8	decimal(28)	Yes	Value Since New	No
CMPRC_TSO	_decimal_28_8	decimal(28)	Yes	Value Since Overhaul	No
CMPRC_TSR	_decimal_28_8	decimal(28)	Yes	Value since Repair	No
CMPRC_TSI	_decimal_28_8	decimal(28)	Yes	Value Since Inspection	No
CMPRC_TSV	_decimal_28_8	decimal(28)	Yes	Value since last shop visit	No
CMPRC_TSN_HIS	_decimal_28_8	decimal(28)	Yes	Since New - Induction Value	No
CMPRC_AS_OF_DATE_HIS	_datetime_8	datetime(8)	Yes	Parameter Value As of Induction Date	No
CMPRC_AS_OF_TIME_HIS	_datetime_8	datetime(8)	Yes	Parameter Value As of Induction Date Time	No
CMPRC_COMPUTESEQ	_decimal_10_0	decimal(10)	Yes	Computational Sequence for Formula based parmeters for Formula id calculation	No
CMPRC_INI_VALUE	_decimal_28_8	decimal(28)	Yes	Initial Value	No
CMPRC_INI_UNKNOWN	_varchar_5	varchar(5)	Yes	Initial Value - Unknown flag	No
Cmprc_first_inhdt	_datetime_8	datetime(8)	Yes	First inheritance date	No
created_area_code	varchar	Char(10)	Yes	Created Area Code	No

Table Name :	AC_CMPRC_CMP_RNGCON_PRMLIST_PVLOG
Comment :	AC_CMPRC_CMP_RNGCON_PRMLIST_PVLOG

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	AC_CMPREF_COMP_REFERENCE_DET
Comment :	This table has the reference document details maintained for a Component

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPREF_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinsatnce	Yes
CMPREF_COMPONENT_ID	_varchar_90	varchar(90)	No	component id	Yes
CMPREF_DOCUMENTNO	_varchar_40	varchar(40)	No	Document Number	Yes
CMPREF_REFDOCTYPE	_varchar_25	Varchar(25)	No	Ref. Document Type	Yes
CMPREF_REFDOCDESC	_varchar_150	varchar(150)	Yes	Reference Document Description	No
CMPREF_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
CMPREF_FILENAME	_varchar_50	varchar(50)	Yes	Filename	No

Table Name :	AC_CMPRM_COMP_PRM_HIS
Comment :	Aircraft Component Parameter History maintained here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	Yes
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	Yes
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	Yes
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	Yes
CMPRM_DELTA_VALUE	udd_numericparamval	numeric(13)	No	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_CMPTA_CMP_TECHATT_PRMLST
Comment :	Attribute and Technical parameter list for the Components

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPTA_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance1	Yes
CMPTA_COMPONENT_ID	_varchar_90	varchar(90)	No	compoonent id	Yes
CMPTA_PARAM_CODE	_varchar_40	varchar(40)	No	param code	Yes
CMPTA_PARAM_TYPE	_varchar_5	varchar(5)	Yes	Parameter type - Can be A - Attribute or T - Techincal	No
CMPTA_PARAM_SOURCE	_varchar_5	varchar(5)	Yes	Parameter Source indicates how the value gets updated.Can be one of the following values Parent, Flight Log, Manual, Calculated or Composite.	No
CMPTA_PRESENT_VALUE	udd_charparamval	varchar(32)	Yes	Present Value of the Parameter	No
CMPTA_AS_OF_DATE	_datetime_8	datetime(8)	Yes	Present Value updated as of Date	No
CMPTA_AS_OF_TIME	_datetime_8	datetime(8)	Yes	Present Value updated as of Time	No
CMPTA_PRESENT_VALUE_HIS	udd_charparamval	varchar(32)	Yes	Present value at the time acquisition if any	No
CMPTA_AS_OF_DATE_HIS	_datetime_8	datetime(8)	Yes	History value as of Date	No
CMPTA_AS_OF_TIME_HIS	_datetime_8	datetime(8)	Yes	History value as of Time	No

Table Name :	AC_CMPTS_COMP_TS_VAL_DET
Comment :	Component parameter value details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPTS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CMPTS_COMPONENT_ID	_varchar_90	varchar(90)	No	Component id	Yes
CMPTS_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
CMPTS_TSN	_decimal_28_8	decimal(28)	Yes	Since new To value	No
CMPTS_TSO	_decimal_28_8	decimal(28)	Yes	Since overhaul To value	No
CMPTS_TSR	_decimal_28_8	decimal(28)	Yes	Since Repair To value	No
CMPTS_TSI	_decimal_28_8	decimal(28)	Yes	Since Inspection To value	No
CMPTS_TSV	_decimal_28_8	decimal(28)	Yes	Since Visit To value	No
CMPTS_TSLI	_decimal_28_8	decimal(28)	Yes	Since Last Inspection To value	No

Table Name :	AC_CMP_DEPRECIATION_TSN_PERIOD_VAL
Comment :	AC_CMP_DEPRECIATION_TSN_PERIOD_VAL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	AC_CNGAC_ACREGCHANGE_LOG
Comment :	Aircraft Registration number change details(Log) maintained here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CNGAC_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	OU Instance2	No
CNGAC_AC_REG_NO	_varchar_30	varchar(30)	Yes	Current Aircraft Registration number	No
CNGAC_NEWAC_REG_NO	_varchar_20	varchar(20)	Yes	New Aircraft Registration number	No
CNGAC_STATUS	_varchar_5	varchar(5)	Yes	Authorization Status	No
CNGAC_TAB_NO	_varchar_30	varchar(30)	Yes	Tab number	No
CNGAC_TAIL_NO	_varchar_30	varchar(30)	Yes	Tail number	No
CNGAC_REG_AUTH	_varchar_25	Varchar(25)	Yes	Registration Authority	No
CNGAC_REG_CERT_NO	_varchar_40	varchar(40)	Yes	Registration Certificate Number	No
CNGAC_ISSUE_DATE	_datetime_8	datetime(8)	Yes	Issued Date	No
CNGAC_OWNERSHIP	_varchar_5	varchar(5)	Yes	Owenrship	No
CNGAC_OWNAGENCY_NO	_varchar_45	varchar(45)	Yes	Owning Agency number	No
CNGAC_OWNAGENCY_OU	_decimal_10_0	decimal(10)	Yes	Owning Agency OU Instance	No
CNGAC_LEASE_TYPE	_varchar_5	varchar(5)	Yes	Lease Type	No
CNGAC_EFF_FROM_DATE	_datetime_8	datetime(8)	Yes	Effective From Date	No
CNGAC_REPREASON	_varchar_20	varchar(20)	Yes	Repreason	No
CNGAC_CHGREASON	_varchar_255	varchar(255)	Yes	charge	No
CNGAC_INTIATED_BY	_varchar_30	varchar(30)	Yes	Initiater ID	No
CNGAC_INITIATEDDATE	_datetime_8	datetime(8)	Yes	Initiated Date	No
CNGAC_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	Confirmed User ID	No
CNGAC_CONFIRMEDDATE	_datetime_8	datetime(8)	Yes	Confirmed on	No
CNGAC_COMPLETEDDATE	_datetime_8	datetime(8)	Yes	Completed on	No

Table Name :	AC_COMPHS_COM_PRTCHANGE_HIS
Comment :	This table maintains the details of the part modifications taken place for a component

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPHS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
COMPHS_COMPONENT_ID	_varchar_90	varchar(90)	No	Component Id For which the part got modified	Yes
COMPHS_TRANSACTION_NO	_varchar_40	varchar(40)	No	Transaction number that changed the part	Yes
COMPHS_TRANSACTION_OU	_decimal_10_0	decimal(10)	No	Transaction Ou	Yes
COMPHS_TRANSACTION_TYPE	_varchar_90	varchar(90)	No	Transaction Type	Yes
COMPHS_UPDATEDDATE	_datetime_8	datetime(8)	No	Updated Date	Yes
COMPHS_OLD_PART_NO	_varchar_40	varchar(40)	Yes	Old Part Number	No
COMPHS_OLD_SERIAL_NO	_varchar_40	varchar(40)	Yes	old part serial no.	No
COMPHS_OLD_PART_OU	_decimal_10_0	decimal(10)	Yes	old part ou	No
COMPHS_UPDATED_BY	_varchar_30	varchar(30)	Yes	Updated By	No
COMPHS_NEW_PART_NO	_varchar_40	varchar(40)	Yes	New Part Number	No
COMPHS_NEW_SERIAL_NO	_varchar_40	varchar(40)	Yes	new part serial no.	No
COMPHS_NEW_PART_OU	_decimal_10_0	decimal(10)	Yes	new part ou	No

Table Name :	AC_COMP_PRM_HIS_PURGE_APR
Comment :	Purged information of component parameter value update details for the month of April

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance3	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_AUG
Comment :	Purged information of component parameter value update details for the month of August

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_DEC
Comment :	Purged information of component parameter value update details for the month of December

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_FEB
Comment :	Purged information of component parameter value update details for the month of February

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_JAN
Comment :	Purged information of component parameter value update details for the month of January

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance4	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_8	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_JUL
Comment :	Purged information of component parameter value update details for the month of July

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_0	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_JUN
Comment :	Purged information of component parameter value update details for the month of June

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_0	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_MAR
Comment :	Purged information of component parameter value update details for the month of March

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_0	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_MAY
Comment :	Purged information of component parameter value update details for the month of May

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_0	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_NOV
Comment :	Purged information of component parameter value update details for the month of November

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_0	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_OCT
Comment :	Purged information of component parameter value update details for the month of October

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_0	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_COMP_PRM_HIS_PURGE_SEP
Comment :	Purged information of component parameter value update details for the month of September

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	No
CMPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	No
CMPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	No
CMPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CMPRM_SRC_TRAN_OU	_decimal_10_0	decimal(10)	No	Source Transaction OU	No
CMPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction Number	No
CMPRM_DELTA_VALUE	_decimal_28_0	decimal(28)	Yes	Delta Value	No
CMPRM_ENTITY_TYPE	_varchar_5	varchar(5)	Yes	Entitry Type	No
CMPRM_ENTITY_OU	_decimal_10_0	decimal(10)	Yes	Entity OU	No
CMPRM_SRC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CMPRM_SRC_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Source Component ID	No
CMPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Srouce Transaction	No
CMPRM_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
CMPRM_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created on	No

Table Name :	AC_ERROR_LOG
Comment :	Error log

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AC_ERRID	_int_0	int(0)	Yes	Erro number	No
AC_ERR_DESC	udd_txt255	varchar(255)	Yes	Error Description	No

Table Name :	AC_GSC_GEN_SERCERT_INFO
Comment :	AC_GSC_GEN_SERCERT_INFO

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	AC_MDL_AC_MODEL_DEFINITION
Comment :	Model Definition Table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MDL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
MDL_MODEL_NO	_varchar_20	varchar(20)	No	Model of the Aircraft	Yes
MDL_AC_MAKE	_varchar_45	varchar(45)	Yes	Make of the aircraft	No
MDL_AC_MAKE_UP	_varchar_45	varchar(45)	Yes	Aircraft Make in Upper Case - This is used in Search criteria	No
MDL_AC_TYPE	_varchar_25	Varchar(25)	Yes	These types are user defined types defaulted from the Quick code master	No
MDL_DESCRIPTION	_varchar_150	varchar(150)	No	Brief description of the model	No
MDL_DESCRIPTION_UP	_varchar_150	varchar(150)	No	Description in Upper Case	No
MDL_STATUS	_varchar_15	varchar(15)	Yes	Status of the Model. Can be Active or Inactive	No
MDL_CREATIONDATE	_datetime_8	datetime(8)	Yes	creation Date	No
MDL_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
MDL_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
MDL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
MDL_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
MDL_TYPECERTNO	_varchar_40	varchar(40)	Yes	Certificate number	No
MDL_FILENAME	_varchar_50	varchar(50)	Yes	file name	No
MDL_FHLOGMODE	udd_designparamcode	varchar(5)	Yes	Flight Hours logging mode. Eg. Hobbs Meter Reading(HMR)	No

Table Name :	AC_MDRCP_MODEL_RNG_CONS_PRM
Comment :	Range and Consumption parameters for Models

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MDRCP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
MDRCP_MODEL_NO	_varchar_20	varchar(20)	No	Model number	Yes
MDRCP_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
MDRCP_LIFE_PARAM_FLAG	_varchar_25	Varchar(25)	Yes	Life Parameter Flag	No
MDRCP_PARAM_SOURCE	_varchar_5	varchar(5)	Yes	Parameter Source indicates how the value gets updated.Can be one of the following values Parent, Flight Log, Manual, Calculated or Composite.	No
MDRCP_FROM_VALUE	_decimal_28_0	decimal(28)	Yes	From Value in case of Range Parameters	No
MDRCP_TO_VALUE	_decimal_28_0	decimal(28)	Yes	To Value in case of Range Parameters	No
MDRCP_AVERAGE_VALUE	_decimal_28_0	decimal(28)	Yes	Average Value	No
MDRCP_FORECAST_FACTOR	_decimal_28_0	decimal(28)	Yes	Forecast Factor	No
MDRCP_ULTIMATE_LIFE	_decimal_28_0	decimal(28)	Yes	Ultimate Life	No
MDRCP_FORMULA_ID	_varchar_20	varchar(20)	Yes	Formula Id if the parameter is calculated based on a formula	No
MDRCP_WARRANT_TRACKING	_varchar_5	varchar(5)	Yes	Warranty Tracking Flag	No
MDRCP_PARAM_UPDATE	_varchar_5	varchar(5)	Yes	Parameter Update - MND - Mandatory, NMD - Non Mandatory	No
MDRCP_UPDATE_MODE	_varchar_5	varchar(5)	Yes	Update Mode - Can be D - Delta and N- New	No

Table Name :	AC_MDTAP_MODEL_TECH_ATT_PRM
Comment :	Technical and Attribute parameters for Model

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MDTAP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
MDTAP_MODEL_NO	_varchar_20	varchar(20)	No	Model number	Yes
MDTAP_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
MDTAP_PARAM_SOURCE	_varchar_5	varchar(5)	Yes	Parameter Source indicates how the value gets updated.Can be one of the following values Parent, Flight Log, Manual, Calculated or Composite.	No
MDTAP_PARAM_VALUE	udd_charparamval	varchar(32)	Yes	Parameter Value	No

Table Name :	AC_MFGATA_MFG_ATA_CHAPTER
Comment :	Maintains Manufacturer ata details against each ATA chapter.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MFGATA_OUINSTANCE	_decimal_10_0	decimal(10)	No	Manufacturer ata chapter ouinstance	Yes
MFGATA_ATA_CHAPTER_NO	_varchar_16	varchar(16)	No	ATA chapter no	Yes
MFGATA_MFG_ATA_CHAPTER_NO	_varchar_16	varchar(16)	No	Manufacturer ATA chapter no	Yes
MFGATA_MANUFACTURER	_varchar_45	varchar(45)	No	Manufacturer	Yes
MFGATA_MFG_ATA_CHAP_DESC	_varchar_150	varchar(150)	Yes	Manufacturer ATA chapter description	No
MFGATA_MFG_ATA_CHAP_DESC_UP	_varchar_150	varchar(150)	Yes	Manufacturer ATA chapter description in upper case	No
MFGATA_STATUS	_varchar_15	varchar(15)	Yes	status	No
MFGATA_REMARKS	_varchar_255	varchar(255)	Yes	remarks	No
MFGATA_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
MFGATA_CREATIONDATE	_datetime_8	datetime(8)	Yes	created date	No
MFGATA_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
MFGATA_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date	No

Table Name :	AC_NCMB_NON_COMP_MAINT_OBJ
Comment :	Identifies non-component Maintenance Objects

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
NCMB_OUINSTANCE	_decimal_10_0	decimal(10)	No	ou instance	Yes
NCMB_OBJECT_TYPE	_varchar_5	varchar(5)	No	object type. Can have FAC, MAK, PIP, PRO, RIN or MSC.	Yes
NCMB_COMPONENT_ID	_varchar_16	varchar(16)	No	component id	Yes
NCMB_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	component ou	No
NCMB_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	timestamp	No
NCMB_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
NCMB_CREATIONDATE	_datetime_8	datetime(8)	Yes	created date	No
NCMB_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modified by	No
NCMB_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date	No
ncmb_signoff_reqd	_varchar_5	varchar(5)	Yes	Signoff required flag	No
ncmb_auth_reqd	_varchar_5	varchar(5)	Yes	Authorization Required Flag	No

Table Name :	AC_PARAMETER_DETAILS
Comment :	Meta Data for Aircraft

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	_varchar_80	varchar(80)	No	Component Name	Yes
PARAMCATEGORY	_varchar_10	varchar(10)	No	Parameter Category	Yes
PARAMTYPE	_varchar_15	varchar(15)	No	Parameter Type	Yes
PARAMCODE	_varchar_10	varchar(10)	No	Parameter Code	Yes
PARAMDESC	_varchar_80	varchar(80)	No	Parameter Description	No
LANGID	_decimal_10_0	decimal(10)	No	Language Id	No
CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
SORTBY	_decimal_10_0	decimal(10)	Yes	Sort Order	No

Table Name :	AC_PRM_PARAM_DETAILS
Comment :	Parameter Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
PRM_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
PRM_DESCRIPTION	_varchar_150	varchar(150)	No	Parameter description	No
PRM_UOM	_varchar_10	varchar(10)	Yes	Parameter unit of measure	No
PRM_TYPE	_varchar_25	Varchar(25)	No	Parameter Type - can be Technical, range , consumption or attribute type	No
PRM_FORMULA_ID	_varchar_20	varchar(20)	Yes	The formula id to which the parameter is associated	No
PRM_STATUS	_varchar_5	varchar(5)	Yes	This is the status of the parameter. Value can be either active or Inactive	No
PRM_CREATED_BY	_varchar_30	varchar(30)	No	Last Modified User Name	No
PRM_CREATIONDATE	_datetime_8	datetime(8)	No	created date	No
PRM_MODIFIEDDATE	_datetime_8	datetime(8)	No	Last Modified Date	No
PRM_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp	No
PRM_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
PRM_DISP_FORMAT	udd_designparamcode	varchar(5)	Yes	Parameter Display format E.g HHMM for Hours format display DEC for decimal format display	No

Table Name :	AC_PRTRC_PART_RNGCON_PRMLST
Comment :	Range and Consumption Parameters for Parts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRTRC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
PRTRC_PART_NO	_varchar_40	varchar(40)	No	Part number	Yes
PRTRC_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
PRTRC_PARAM_TYPE	_varchar_25	Varchar(25)	Yes	Parameter Type - Can be Range or COnsumption	No
PRTRC_LIFE_PARAM_FLAG	_varchar_5	varchar(5)	Yes	Y indicates that the parameter is a life parameter.	No
PRTRC_PARAM_SOURCE	_varchar_5	varchar(5)	Yes	Parameter Source indicates how the value gets updated.Can be one of the following values Parent, Flight Log, Manual, Calculated or Composite.	No
PRTRC_FROM_VALUE	_decimal_28_0	decimal(28)	Yes	Valid From value for the parameter	No
PRTRC_TO_VALUE	_decimal_28_0	decimal(28)	Yes	Valid To Value for the parameter	No
PRTRC_AVG_VALUE	_decimal_28_0	decimal(28)	Yes	Average Value	No
PRTRC_FORECAST_FACTOR	_decimal_28_0	decimal(28)	Yes	Forecast Factor for the parameter	No
PRTRC_ULTIMATE_LIFE	_decimal_28_0	decimal(28)	Yes	Ultimate life gives the maximum life of the lead (reference) parameter after which the component should be discarded.	No
PRTRC_FORMULA_ID	_varchar_20	varchar(20)	Yes	Formula id based on the value of the parameter is updated	No
PRTRC_WARRANT_TRACKING	_varchar_5	varchar(5)	Yes	Warranty Tracking	No
PRTRC_PARAM_UPDATE	_varchar_5	varchar(5)	Yes	Parameter Update - Can be MND - Mandatory or NMD - Non Mandatory	No
PRTRC_UPDATE_MODE	_varchar_5	varchar(5)	Yes	Update Mode - can be N - New or D - Delta	No

Table Name :	AC_PRTTA_PRT_TECHATT_PRMLST
Comment :	Technical and Attribute parameter list for parts

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRTTA_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
PRTTA_PART_NO	_varchar_40	varchar(40)	No	Part number	Yes
PRTTA_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter code	Yes
PRTTA_PARAM_TYPE	_varchar_25	Varchar(25)	Yes	Parameter Type - Can be T - Technical or A - Atrribute	No
PRTTA_PARAM_SOURCE	_varchar_5	varchar(5)	Yes	Parameter Source indicates how the value gets updated.Can be one of the following values Parent, Flight Log, Manual, Calculated or Composite.	No
PRTTA_PRESENT_VALUE	_varchar_15	varchar(15)	Yes	Present Value of the parameter	No

Table Name :	AC_PVCPRM_COMPONENT_PRM_HIS
Comment :	Components parameter history maintained here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PVCPRM_COMPONENT_OU	_decimal_10_0	decimal(10)	No	OU Instance	Yes
PVCPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	Yes
PVCPRM_TRANSACTION_DTTIME	_datetime_8	datetime(8)	No	Transaction DateTime	Yes
PVCPRM_AIRCRAFT_OU	_decimal_10_0	decimal(10)	Yes	Aircraft OU	No
PVCPRM_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Register Number	No
PVCPRM_PART_NO	_varchar_40	varchar(40)	Yes	Part number	No
PVCPRM_PART_SERIAL	_varchar_40	varchar(40)	Yes	Part Serial number	No
PVCPRM_ATA_NO	_varchar_16	varchar(16)	Yes	Air Traffic Association number	No
PVCPRM_DELTAFH	_decimal_28_0	decimal(28)	Yes	Delta FH value	No
PVCPRM_DELTAFC	_decimal_28_0	decimal(28)	Yes	Delta FC value	No
PVCPRM_CREATED_DATE	_datetime_8	datetime(8)	Yes	Creation Date	No

Table Name :	AC_PVIPRM_INHRIT_PRM
Comment :	Inhertiable parameters maintained here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PVIPRM_GUID	_varchar_40	varchar(40)	No	Global Unique Identifier	Yes
PVIPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
PVIPRM_USER	_varchar_30	varchar(30)	No	User ID	Yes
PVIPRM_LANGUAGE	_decimal_10_0	decimal(10)	No	Language	Yes
PVIPRM_SRCCOMPCODE	_varchar_20	varchar(20)	No	Source Component Code	Yes
PVIPRM_SRCOUINSTANCE	_decimal_10_0	decimal(10)	No	Source OU Instance	Yes
PVIPRM_MAINTOBJECTTYPE	_varchar_10	varchar(10)	No	Maintenece object type	Yes
PVIPRM_ENTITY_OU	_decimal_10_0	decimal(10)	No	Entity OU	Yes
PVIPRM_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Register No	Yes
PVIPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component ID	Yes
PVIPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	No	Transaction Date	Yes
PVIPRM_POS_CODE	_varchar_25	Varchar(25)	No	Position Code	Yes
PVIPRM_PRM_ATTR_TYPE	_varchar_5	varchar(5)	No	Parameter Attribute type	Yes
PVIPRM_RESET_FLAG	_varchar_5	varchar(5)	Yes	Reset Flat	No
PVIPRM_PRM1_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter1 Delta or New Flag	No
PVIPRM_PRM2_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter2 Delta or New Flag	No
PVIPRM_PRM3_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter3 Delta or New Flag	No
PVIPRM_PRM4_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter4 Delta or New Flag	No
PVIPRM_PRM5_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter5 Delta or New Flag	No
PVIPRM_PRM6_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter6 Delta or New Flag	No
PVIPRM_PRM7_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter7 Delta or New Flag	No
PVIPRM_PRM8_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter8 Delta or New Flag	No
PVIPRM_PRM9_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter9 Delta or New Flag	No
PVIPRM_PRM10_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Parameter10 Delta or New Flag	No
PVIPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Source Transaction	No
PVIPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source Transaction number	Yes
PVIPRM_PRM1_CODE	_varchar_40	varchar(40)	Yes	Parameter1 code	No
PVIPRM_PRM1_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter1 value	No
PVIPRM_PRM2_CODE	_varchar_40	varchar(40)	Yes	Parameter2 code	No
PVIPRM_PRM2_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter2 value	No
PVIPRM_PRM3_CODE	_varchar_40	varchar(40)	Yes	Parameter3 code	No
PVIPRM_PRM3_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter3 value	No
PVIPRM_PRM4_CODE	_varchar_40	varchar(40)	Yes	Parameter4 code	No
PVIPRM_PRM4_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter4 value	No
PVIPRM_PRM5_CODE	_varchar_40	varchar(40)	Yes	Parameter5 code	No
PVIPRM_PRM5_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter5 value	No
PVIPRM_PRM6_CODE	_varchar_40	varchar(40)	Yes	Parameter6 code	No
PVIPRM_PRM6_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter6 value	No
PVIPRM_PRM7_CODE	_varchar_40	varchar(40)	Yes	Parameter7 code	No
PVIPRM_PRM7_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter7 value	No
PVIPRM_PRM8_CODE	_varchar_40	varchar(40)	Yes	Parameter8 code	No
PVIPRM_PRM8_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter8 value	No
PVIPRM_PRM9_CODE	_varchar_40	varchar(40)	Yes	Parameter9 code	No
PVIPRM_PRM9_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter9 value	No
PVIPRM_PRM10_CODE	_varchar_40	varchar(40)	Yes	Parameter10 code	No
PVIPRM_PRM10_VALUE	_decimal_28_0	decimal(28)	Yes	Parameter10 value	No
PVIPRM_AMEND_FLAG	_varchar_5	varchar(5)	Yes	Amendment Flag	No
PVIPRM_OLD_TRANSACTION_DATE	_datetime_8	datetime(8)	Yes	Old transcation date	No
PVIPRM_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
PVIPRM_SEQ	_Int_4	Int(4)	Yes	Sequence #	No

Table Name :	AC_PVNPRM_NON_INHRIT_PRM
Comment :	Non-Inhertiable parameters maintained here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PVNPRM_GUID	_varchar_40	varchar(40)	No	Guid	No
PVNPRM_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	No
PVNPRM_USER	_varchar_30	varchar(30)	No	User Name	No
PVNPRM_LANGUAGE	_decimal_10_0	decimal(10)	No	Language ID	No
PVNPRM_SRCCOMPCODE	_varchar_20	varchar(20)	No	Component code	No
PVNPRM_SRCOUINSTANCE	_decimal_10_0	decimal(10)	No	Source OUInstance	No
PVNPRM_MAINTOBJECTTYPE	_varchar_10	varchar(10)	No	Maintenance object type	No
PVNPRM_ENTITY_OU	_decimal_10_0	decimal(10)	No	Entity OU	No
PVNPRM_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft registration number	No
PVNPRM_COMPONENT_ID	_varchar_90	varchar(90)	No	Component id	No
PVNPRM_PRM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
PVNPRM_TRANSACTION_DATE	_datetime_8	datetime(8)	Yes	Transaction Date	No
PVNPRM_POS_CODE	_varchar_25	Varchar(25)	No	Position Code	No
PVNPRM_PRM_ATTR_TYPE	_varchar_5	varchar(5)	Yes	Parameter Attribute type	No
PVNPRM_RC_PRM_VALUE	_decimal_28_0	decimal(28)	Yes	Range Consumption parameter value	No
PVNPRM_TA_PRM_VALUE	_varchar_32	varchar(32)	Yes	Technical Attirbute parameter value	No
PVNPRM_RESET_FLAG	_varchar_5	varchar(5)	Yes	Reset flag	No
PVNPRM_DELTA_NEW_FLAG	_varchar_5	varchar(5)	Yes	Delta new flag	No
PVNPRM_SRC_TRANSACTION	_varchar_25	Varchar(25)	Yes	Source Transaction	No
PVNPRM_SRC_TRAN_NO	_varchar_40	varchar(40)	No	Source transaction number	No
PVNPRM_AMEND_FLAG	_varchar_5	varchar(5)	Yes	Amendment Flag	No
PVNPRM_OLD_TRANSACTION_DATE	_datetime_8	datetime(8)	Yes	old tran	No
PVNPRM_SEQ	_Int_4	Int(4)	Yes	sequence#	No

Table Name :	AC_QUICK_CODE
Comment :	User defined Quick Codes Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AC_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
AC_QUICK_CODE	_varchar_25	Varchar(25)	No	Quick Code	Yes
AC_TYPE	_varchar_80	varchar(80)	No	Quick Code Type - 'Aircraft Group Category', "Aircraft Type", "Model Type", "Usage Type", "Aircraft Details - 1", "Aircraft Details - 2", "Aircraft Details - 3", "Component Details - 1", "Component Details - 2", "Component Details - 3"	Yes
AC_DESCRIPTION	_varchar_80	varchar(80)	No	Description	No
AC_STATUS	_varchar_15	varchar(15)	No	Status - Can be A - Active or I - Inactive	No
AC_CREATED_BY	_varchar_30	varchar(30)	No	Created By	No
AC_MODIFIED_BY	_varchar_30	varchar(30)	No	Modified By	No
AC_CREATIONDATE	_datetime_8	datetime(8)	No	Creation Date	No
AC_MODIFIEDDATE	_datetime_8	datetime(8)	No	Last Modified date	No
AC_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp	No

Table Name :	AC_SUB_CAL_USGDEPTSN_PV_TSN
Comment :	AC_SUB_CAL_USGDEPTSN_PV_TSN

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	AC_SUB_CAL_USGDEP_USAGE_DEPRE_NHA_PERIOD
Comment :	AC_SUB_CAL_USGDEP_USAGE_DEPRE_NHA_PERIOD

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	AC_SUB_CAL_USGDEP_USAGE_DEPRE_PERIOD
Comment :	AC_SUB_CAL_USGDEP_USAGE_DEPRE_PERIOD

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	ac_tcq_techrecord_queue_dtl
Comment :	ac_tcq_techrecord_queue_dtl

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tcq_ouinstance	udd_ctxt_ouinstance	int(4)	No	User ouinstance	Yes
tcq_uniqueid	bigint	Bigint(8)	No	Unique identification number	Yes
tcq_partno	udd_partno	varchar(40)	Yes	Part number	No
tcq_mfr_partno	udd_partno	varchar(40)	Yes	Manufacturer part number	No
tcq_mfr_no	varchar	Char(10)	Yes	Manufacturer number	No
tcq_part_serialno	udd_partserialnumber	varchar(40)	Yes	Part serial number	No
tcq_part_mfrserialno	udd_partserialnumber	varchar(40)	Yes	Part manufacturer serial number	No
tcq_part_desc	udd_txt150	varchar(150)	Yes	Part description	No
tcq_component_id	udd_componentid	varchar(90)	Yes	Component id	No
tcq_Ref_doc_no	udd_documentno	varchar(40)	Yes	Reference document number	No
tcq_Refdoc_lineno	udd_lineno	int(4)	Yes	Reference document line number	No
tcq_Ref_doc_type	udd_designparamcode	varchar(5)	Yes	Reference document type	No
tcq_Ref_doc_date	datetime	Datetime(8)	Yes	Reference document date	No
tcq_packslip_no	udd_documentno	varchar(40)	Yes	pack slip number	No
tcq_waybill_no	udd_documentno	varchar(40)	Yes	way bill number	No
tcq_rec_WH	varchar	Char(10)	Yes	Record warehouse	No
tcq_rec_condition	udd_designparamcode	varchar(5)	Yes	Record condition	No
tcq_rec_comments	udd_txt2000	varchar(2000)	Yes	Record comments	No
tcq_cert_type	udd_flag	varchar(25)	Yes	Certificate type	No
tcq_cert_date	datetime	Datetime(8)	Yes	Certificate date	No
tcq_cert_no	udd_documentno	varchar(40)	Yes	Certificate number	No
tcq_trade_partner_type	udd_designparamcode	varchar(5)	Yes	Trade partner type	No
tcq_trade_partner_no	varchar	Char(10)	Yes	Trade partner number	No
tcq_trade_partner_name	udd_txt150	varchar(150)	Yes	Trade partner name	No
tcq_shelflife_expdate	datetime	Datetime(8)	Yes	shelflife expiry date	No
tcq_verification_status	udd_designparamcode	varchar(5)	Yes	Verification status	No
tcq_ver_comments	udd_txt2000	varchar(2000)	Yes	Verification comments	No
tcq_ver_userstatus	udd_status	varchar(25)	Yes	Verfication status	No
tcq_createddate	datetime	Datetime(8)	Yes	created date	No
tcq_createdby	udd_ctxt_user	varchar(30)	Yes	created by	No
tcq_modifieddate	datetime	Datetime(8)	Yes	Modified date	No
tcq_modifiedby	udd_ctxt_user	varchar(30)	Yes	Modified by	No
tcq_service_name	udd_ctxt_service	varchar(32)	Yes	Service name	No
tcq_source_Compcode	udd_ctxt_component	varchar(20)	Yes	Source component code	No

Table Name :	ac_tcq_techrecord_queue_his
Comment :	Review record update history table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tcqh_ouinstance	udd_ctxt_ouinstance	int(4)	No	User ouinstance	No
tcqh_uniqueid	bigint	Bigint(8)	No	Unique identification number	No
tcqh_partno	udd_partno	varchar(40)	Yes	Part number	No
tcqh_mfr_partno	udd_partno	varchar(40)	Yes	Manufacturer part number	No
tcqh_mfr_no	varchar	Char(10)	Yes	Manufacturer number	No
tcqh_part_serialno	udd_partserialnumber	varchar(40)	Yes	Part serial number	No
tcqh_part_mfrserialno	udd_partserialnumber	varchar(40)	Yes	Part manufacturer serial number	No
tcqh_part_desc	udd_txt150	varchar(150)	Yes	Part description	No
tcqh_component_id	udd_componentid	varchar(90)	Yes	Component id	No
tcqh_Ref_doc_no	udd_documentno	varchar(40)	Yes	Reference document number	No
tcqh_Refdoc_lineno	udd_lineno	int(4)	Yes	Reference document line number	No
tcqh_Ref_doc_type	udd_designparamcode	varchar(5)	Yes	Reference document type	No
tcqh_Ref_doc_date	datetime	Datetime(8)	Yes	Reference document date	No
tcqh_packslip_no	udd_documentno	varchar(40)	Yes	pack slip number	No
tcqh_waybill_no	udd_documentno	varchar(40)	Yes	way bill number	No
tcqh_rec_WH	varchar	Char(10)	Yes	Record warehouse	No
tcqh_rec_condition	udd_designparamcode	varchar(5)	Yes	Record condition	No
tcqh_rec_comments	udd_txt2000	varchar(2000)	Yes	Record comments	No
tcqh_cert_type	udd_flag	varchar(25)	Yes	Certificate type	No
tcqh_cert_date	datetime	Datetime(8)	Yes	Certificate date	No
tcqh_cert_no	udd_documentno	varchar(40)	Yes	Certificate number	No
tcqh_trade_partner_type	udd_designparamcode	varchar(5)	Yes	Trade partner type	No
tcqh_trade_partner_no	varchar	Char(10)	Yes	Trade partner number	No
tcqh_trade_partner_name	udd_txt150	varchar(150)	Yes	Trade partner name	No
tcqh_shelflife_expdate	datetime	Datetime(8)	Yes	shelflife expiry date	No
tcqh_verification_status	udd_designparamcode	varchar(5)	Yes	Verification status	No
tcqh_ver_comments	udd_txt2000	varchar(2000)	Yes	Verification comments	No
tcqh_ver_userstatus	udd_status	varchar(25)	Yes	Verfication status	No
tcqh_createddate	datetime	Datetime(8)	Yes	created date	No
tcqh_createdby	udd_ctxt_user	varchar(30)	Yes	created by	No
tcqh_modifieddate	datetime	Datetime(8)	Yes	Modified date	No
tcqh_modifiedby	udd_ctxt_user	varchar(30)	Yes	Modified by	No
tcqh_service_name	udd_ctxt_service	varchar(32)	Yes	Service name	No
tcqtmp_source_Compcode	udd_ctxt_component	varchar(20)	Yes	Source component code	No

Table Name :	AC_USGDEPD_USAGE_DEPRECIATION_DTL
Comment :	AC_USGDEPD_USAGE_DEPRECIATION_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	AC_ZND_ZONE_DETAILS
Comment :	Zone details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ZND_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
ZND_ZONECODE	_varchar_80	varchar(80)	No	Aircraft zone code	Yes
ZND_DESCRIPTION	_varchar_255	varchar(255)	Yes	description of the zone	No
ZND_DESCRIPTION_UP	_varchar_255	varchar(255)	Yes	upper description of the zone	No
ZND_CATEGORY	_varchar_255	varchar(255)	Yes	user defined zone category	No
ZND_CATEGORY_UP	_varchar_255	varchar(255)	Yes	Category in Upper case	No
ZND_STATUS	_varchar_15	varchar(15)	Yes	status of the zone	No
ZND_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
ZND_CREATEDBY	_varchar_30	varchar(30)	Yes	Created By	No
ZND_MODIFIEDBY	_varchar_30	varchar(30)	Yes	Last Modified by	No
ZND_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
ZND_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
ZND_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
ZND_MODEL_NO	_varchar_20	varchar(20)	No	model number	Yes
ZND_MODEL_OU	_decimal_38_0	decimal(38)	No	model ou	Yes

Table Name :	basac_prtdev_upd_dtl
Comment :	To store the part updation details in aircraft

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
basac_prtdev_ouinstance	_udd_ctxt_ouinstance_4	udd_ctxt_ouinstance(4)	No	Ou instance	Yes
basac_prtdev_partno	_udd_partno_40	udd_partno(40)	No	Part number	Yes
basac_prtdev_serialno	_UDD_SERIALNO_40	UDD_SERIALNO(40)	No	serial number	Yes
basac_prtdev_swo_no	_udd_documentno_40	udd_documentno(40)	No	shop work order number	No
basac_prtdev_partou	_udd_ctxt_ouinstance_4	udd_ctxt_ouinstance(4)	No	part Ou	No
basac_prtdev_ATAno	_udd_atanumber_16	udd_atanumber(16)	No	ATA Number	No
basac_prtdev_Deviation_no	_udd_partno_40	udd_partno(40)	No	Deviation number	No
basac_prtdev_Description	_udd_error_desc_2000	udd_error_desc(2000)	No	Description	No
basac_prtdev_approval_no	_udd_documentno_40	udd_documentno(40)	No	Approval number	No
basac_prtdev_remarks	_udd_notes_2000	udd_notes(2000)	No	remarks	No
basac_prtdev_timestamp	_udd_timestamp_4	udd_timestamp(4)	No	time of attempts submit button is cllicked	No
basac_prtdev_created_by	_udd_ctxt_user_30	udd_ctxt_user(30)	No	created user	No
basac_prtdev_created_date	_udd_datetime1_8	udd_datetime1(8)	No	created date	No
basac_prtdev_modified_by	_udd_ctxt_user_30	udd_ctxt_user(30)	No	modified user	No
basac_prtdev_modified_date	_udd_datetime1_8	udd_datetime1(8)	No	modified date	No
basac_prtdev_SeqNo	_udd_seqno_4	udd_seqno(4)	No	sequence number	Yes