Aircraft

Data Dictionary- Aircraft

Table Name ac_acaser_ac_search_master

Table Comment Search Id capturing of Aircraft info related filters.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acaser_ouinstance	decimal(38)	NOT NULL	Ouinstance	Yes	No
acaser_search_id	varchar(30)	NOT NULL	Search id for Filters	Yes	No
acaser_ac_group	varchar(20)	NULL	Aircraft group no	No	No
acaser_usage_type	varchar(25)	NULL	User defined values-Quick codes	No	No
acaser_ac_type	varchar(25)	NULL		No	No
acaser_ac_condition	varchar(5)	NULL	Aircraft Condition can be ’Operational’, ’Under Maintenance’ or ’Phased out’ M - Under Maintenance P - Phased Out O - Operational	No	No
acaser_config_class	varchar(30)	NULL	Configuration class	No	No
acaser_ac_make	varchar(45)	NULL	Aircraft make(Supplier/Manufacturer)	No	No
acaser_ownership	varchar(5)	NULL	Aircraft ownership -Owned,Leased or Leased out O - Owned CUS - Customer LO - Leased Out L - Leased	No	No
acaser_lease_type	varchar(5)	NULL	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 W - Wet D - Dry	No	No
acaser_user_defined1	varchar(25)	NULL	User defined values-Quick codes	No	No
acaser_user_defined2	varchar(25)	NULL	User defined values-Quick codes	No	No
acaser_user_defined3	varchar(25)	NULL	User defined values-Quick codes	No	No
acaser_ac_detail1	varchar(25)	NULL	User defined values-Quick codes	No	No
acaser_ac_detail2	varchar(25)	NULL	User defined values-Quick codes	No	No
acaser_ac_detail3	varchar(25)	NULL	User defined values-Quick codes	No	No
acaser_created_by	varchar(30)	NULL	User name	No	No
acaser_createddate	datetime	NULL	Date value	No	No
acaser_modified_by	varchar(30)	NULL	Modified User	No	No
acaser_modifieddate	datetime	NULL	Modification date	No	No
acaser_timestamp	decimal(38)	NULL	Timestamp value	No	No

Table Name ac_acbprm_ac_base_prm_map

Table Comment The mapping between the parameters defined and the used parameters like FH, FC are done here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acbprm_modifieddate	datetime	NULL	Last Modified Date	No	No
acbprm_createddate		NULL	Creation Date	No	No
acbprm_created_by	varchar(30)	NULL	Created by	No	No
acbprm_modified_by		NULL	Last Modified By	No	No
acbprm_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
acbprm_hidden_param	varchar(40)	NULL	hidden Parameter (Inherit Parameter)	No	No
ACBPRM_BASE_PARAM	varchar(40)	NOT NULL		Yes	No
ACBPRM_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
acbprm_used_prm	varchar(40)	NULL	Used Parameter Code	No	No
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes

Table Name ac_acchis_ac_condition_his

Table Comment This tables maintains the condition change history for the components.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acchis_ouinstance	decimal(38)	NOT NULL	aircraft ouinstance	Yes	No
acchis_component_id	varchar(90)	NOT NULL	Component id	Yes	No
acchis_from_condition	varchar(5)	NOT NULL	From Which condition got changed M - Under Maintenance P - Phased Out O - Operational	Yes	No
acchis_transaction_date	datetime	NOT NULL	Component Condition change date	Yes	No
acchis_to_condition	varchar(5)	NULL	To condition change Aircraft Condition can be ’Operational’, ’Under Maintenance’ or ’Phased out’ M - Under Maintenance P - Phased Out O - Operational	No	No
acchis_transaction_no	varchar(40)	NULL	Transaction no for changing the condition	No	No
acchis_transaction_type	varchar(25)	NULL	Transaction Component	No	No
acchis_transaction_ou	decimal(38)	NULL	Transaction ou	No	No
acchis_comments	varchar(255)	NULL	comments	No	No
acchis_remarks	varchar(255)	NULL	remarks	No	No

Table Name ac_accser_cmp_search_master

Table Comment Search Id capturing of component info related filters.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
accser_ouinstance	decimal(38)	NOT NULL	Ouinstance	Yes	No
accser_search_id	varchar(30)	NOT NULL	Search id for filters	Yes	No
accser_comp_family	varchar(25)	NULL	Component Family code	No	No
accser_comp_type	varchar(5)	NULL	Component type-Apu,Engine,landing gear and others A - Apu E-Engine O-Others	No	No
accser_mod_status	varchar(15)	NULL	Mod status	No	No
accser_zone_no	varchar(15)	NULL	Zone no	No	No
accser_assembly_status	varchar(15)	NULL	Assembly Status-Dormant or Complete	No	No
accser_comp_ownership	varchar(5)	NULL	Component ownership- OWN - Owned CUS - Customer SUP - Supplier EXT - External	No	No
accser_comp_condition	varchar(5)	NULL	Component condition-New,Serviceable,Unserviceable,Overhaul and phased out OVH - Over Hauled PO - Phased Out SER - Serviceable NW - New USR - Un-Serviceable	No	No
accser_nha	varchar(40)	NULL	Nha part no	No	No
accser_position_code	varchar(25)	NULL	Position code	No	No
accser_level_code	varchar(150)	NULL	Level code	No	No
accser_user_detail1	varchar(25)	NULL	User defined values-Quick codes	No	No
accser_user_detail2	varchar(25)	NULL		No	No
accser_user_detail3	varchar(25)	NULL		No	No
accser_comp_detail1	varchar(25)	NULL		No	No
accser_comp_detail2	varchar(25)	NULL		No	No
accser_comp_detail3	varchar(25)	NULL		No	No
accser_cargo_flag	varchar(25)	NULL	Cargo flag("Yes" or "No") Y-Yes N-No	No	No
accser_rvsm_flag	varchar(25)	NULL	Rvsm flag("Yes" or "No") Y-Yes N-No	No	No
accser_mel_flag	varchar(25)	NULL	mel flag("Yes" or "No") Y-Yes N-No	No	No
accser_created_by	varchar(30)	NULL	user name	No	No
accser_createddate	datetime	NULL	Creation date	No	No
accser_modified_by	varchar(30)	NULL	Modify user	No	No
accser_modifieddate	datetime	NULL	modified date	No	No
accser_timestamp	decimal(38)	NULL	TimeStamp	No	No
accser_nhacomponent	varchar(16)	NULL	NHA component	No	No
accser_partno	varchar(40)	NULL	part no	No	No
accser_eipin	varchar(40)	NULL	eipin	No	No

Table Name ac_acg_aircraft_group

Table Comment Aircraft Groups List
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acg_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
acg_group_no	varchar(20)	NOT NULL	Group Number	Yes	No
acg_description	varchar(150)	NOT NULL	Description Number	No	No
acg_category	varchar(25)	NULL	Category	No	No
acg_status	varchar(15)	NULL	Status A - Active I - Inactive	No	No
acg_created_by	varchar(30)	NOT NULL	Created By	No	No
acg_creationdate	datetime	NULL	Creation Date	No	No
acg_modified_by	varchar(30)	NOT NULL	Last Modified By	No	No
acg_modifieddate	datetime	NULL	Modified Date	No	No
acg_timestamp	numeric(10)	NULL	Timestamp	No	No

Table Name AC_ACI_Account_Det_Hist
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AC_ACI_OUINSTANCE	int	NULL	Aircraft record created OU	No	No
AC_ACI_AIRCRAFT_REG_NO	sql_variant	NULL	Aircraft Reg#	No	No
AC_ACI_AttributeType	sql_variant	NULL	Attribute type	No	No
AC_ACI_Attributecode	sql_variant	NULL	Attribute code	No	No
AC_ACI_EffectiveFromDate	datetime	NULL	Effective From date	No	No
AC_ACI_EffectiveToDate	datetime	NULL	EffectiveTo date	No	No
AC_ACI_createdby	sql_variant	NULL	Created by	No	No
AC_ACI_createddate	datetime	NULL	Created date	No	No
AC_ACI_lastmodifiedby	sql_variant	NULL	Last modified by	No	No
AC_ACI_Lastmodifieddate	datetime	NULL	Last modified date	No	No

Table Name ac_aci_aircraft_info

Table Comment Aircraft Information Table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
aci_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
aci_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
mdl_ouinstance	numeric(10)	NULL	Ouinstance	No	Yes
mdl_model_no	varchar(20)	NULL	Model of the Aircraft	No	Yes
ACI_MDL_MODEL	varchar(20)	NOT NULL	ACI Model	No	No
ACI_MDL_OUINSTANCE	decimal(10)	NULL	OU Instance	No	No
aci_serial_no	varchar(40)	NOT NULL	Serial number of the Aircraft	No	No
aci_tab_no	varchar(30)	NOT NULL	Tab number	No	No
aci_tail_no	varchar(30)	NOT NULL	Tail Number	No	No
aci_configuration_id	varchar(30)	NULL	Configuration Id - User defined.	No	No
aci_revision_no	varchar(40)	NULL	Revision Number	No	No
aci_reg_certificate_no	varchar(40)	NULL	Certificate number Issued from Regulatory Authority	No	No
aci_issue_date	datetime	NULL	Certificate Issue Date	No	No
aci_regulatory_auth	varchar(25)	NULL	Name of the Regulatory Authority	No	No
aci_country	varchar(20)	NULL	Country Which has Issued the Certificate	No	No
aci_ownership	varchar(5)	NOT NULL	Ownership can be ’Owned’ , ’Leased’ or ’Leased Out’ O - Owned CUS - Customer LO - Leased Out L - Leased	No	No
aci_lease_type	varchar(5)	NULL	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 W - Wet D - Dry	No	No
aci_planning_base	numeric(10)	NOT NULL	Planning location for the Aircraft	No	No
aci_maintenance_base	numeric(10)	NULL	Maintenance Location for the Aircraft	No	No
aci_planner_code	varchar(20)	NULL	Planner for the Aircraft	No	No
aci_induction_date	datetime	NOT NULL	Induction Date of the Aircraft	No	No
aci_operational_date	datetime	NOT NULL	Operational Date of the Aircraft	No	No
aci_usage_type	varchar(25)	NULL	Usage Types are user defined	No	No
aci_aircraft_type	varchar(25)	NULL	User defined Types	No	No
aci_aircraft_condition	varchar(5)	NULL	Aircraft Condition can be ’Operational’, ’Under Maintenance’ or ’Phased out’ M - Under Maintenance P - Phased Out O - Operational	No	No
aci_from_date	datetime	NULL	From Date	No	No
aci_lead_parameter	varchar(40)	NULL	Reference Parameter	No	No
aci_po_number		NULL	Purchase Order Number	No	No
aci_po_date	datetime	NULL	Purchase Order Date	No	No
aci_acquisition_value	decimal(28,8)	NULL	Acquisition Value of the Aircraft	No	No
aci_book_value	decimal(28,8)	NULL	Book Value	No	No
aci_user_def1	varchar(25)	NULL	User Defined Value 1	No	No
aci_user_def2	varchar(25)	NULL	User Defined Value 2	No	No
aci_user_def3	varchar(25)	NULL	User Defined Value 3	No	No
aci_aircraft_det1	varchar(25)	NULL	User Defined Value	No	No
aci_aircraft_det2	varchar(25)	NULL		No	No
aci_aircraft_det3	varchar(25)	NULL		No	No
aci_status	varchar(5)	NULL	Status of the Aircraft. Can be ’Active’,’Inactive’ or ’Under Creation’ A - Active I - Inactive U - Under Creation	No	No
aci_notes	varchar(2000)	NULL	Notes	No	No
aci_comments	varchar(255)	NULL	Comments	No	No
aci_created_by	varchar(30)	NULL	Created By	No	No
aci_creationdate	datetime	NULL	Created Date	No	No
aci_modified_by	varchar(30)	NULL	Last Modified User	No	No
aci_modifieddate	datetime	NULL	Modified Date	No	No
aci_timestamp	numeric(10)	NULL	Timestamp	No	No
aci_ac_reg_prefix	varchar(30)	NULL	This will be the alphanumeric part of the Aircraft Registration Number	No	No
aci_ac_reg_suffix	varchar(30)	NULL	This will be the running number part of the Aircraft Registration Number	No	No
aci_msn_prefix	varchar(40)	NULL	This will be the alphanumeric part of the Manufacturer Serial Number	No	No
aci_msn_suffix	varchar(40)	NULL	This will be the running number part of the Manufacturer Serial Number	No	No
aci_tab_prefix	varchar(30)	NULL	This will be the alphanumeric part of the tabno	No	No
aci_tab_suffix	varchar(30)	NULL	This will be the running number part of the tabno	No	No
aci_tail_prefix	varchar(30)	NULL	This will be the alphanumeric part of the tail number	No	No
aci_tail_suffix	varchar(30)	NULL	This will be the running number part of the tail number	No	No
aci_manufacture_date	datetime	NULL	Manufacturer Date	No	No
aci_inv_part_no	varchar(40)	NULL	Inventory Part Number	No	No
aci_cust_eff_code	varchar(30)	NULL	Customer Code	No	No
aci_engine_set_no		NULL	Engine Set Number	No	No
aci_polocation_ou	decimal(38)	NULL	PO Location Ouinstance	No	No
aci_ownagency_no	varchar(45)	NULL	owning agency code(customer or supplier code)	No	No
aci_ownagency_ou	decimal(38)	NULL	owning agency ou	No	No
aci_engagement_type	varchar(5)	NULL	engagement type F - Full Maintenance O - On Request	No	No
ACI_PREV_AC_REG_NO	varchar(30)	NULL	Previous AC Registration Number	No	No
aci_base_ac_reg_no	varchar(30)	NULL	Base AC Registration Number	No	No
ACOI_BASE_AC_REG_NO	varchar(30)	NULL	Base Aircraft Register number	No	No
aci_asset_no	sql_variant	NULL	Asset Number	No	No
aci_asset_tag	int	NULL	Asset Tag	No	No
aci_asset_modified_by	sql_variant	NULL	Asset Modified By	No	No
aci_asset_modified_date	sql_variant	NULL	Asset Modified Date	No	No
aci_pref_status	sql_variant	NULL	Preferred Status	No	No
aci_retmnt_datetime	sql_variant	NULL	Retirement Datetime	No	No
ACI_FHLOGMODE	sql_variant	NULL	Flight Hours logging mode. Eg. Hobbs Meter Reading(HMR)	No	No
ACI_AOG_FROMDATE	datetime	NULL	AOG From Date	No	No
ACI_ACREG_STATUS	varchar(40)	NULL	AC Registration Status	No	No
ACI_STATUS_FROMDATE	datetime	NULL	Status From Date	No	No
aci_operational_time	datetime	NULL	Operational Timings	No	No
ACI_QRNTN	sql_variant	NULL		No	No
ACI_holdingfb	sql_variant	NULL	Holdng FB #	No	No
ACI_holdingfb_date	datetime	NULL	Effective from date -Holding FB	No	No
ACI_operatedfor_date	datetime	NULL	Effective from date - Operated For?	No	No
ACI_operatedfor	sql_variant	NULL	Operated For?	No	No
ACI_analysiscode_date	datetime	NULL	Effective from date - Analysiscode	No	No
ACI_analysiscode	sql_variant	NULL	Analysis code	No	No
ACI_subanalysis_date	datetime	NULL	Effective from date - Sub-analysis Code	No	No
ACI_subanalysis	sql_variant	NULL	Sub-analysis code	No	No

Table Name ac_acintp_inheritable_param

Table Comment Inheritable parameters list
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acintp_ouinstance	decimal(38)	NOT NULL	Ouinstance	Yes	No
acintp_param_code	varchar(40)	NOT NULL	Valid Parameter code which should be defined in Parameter master	Yes	No
acintp_hidden_param_code	varchar(40)	NOT NULL	Hidden param code value(like ’P1’,’P2’....’P10’)-for pv calculation	No	No
acintp_created_by	varchar(30)	NULL	User name	No	No
acintp_createddate	datetime	NULL	Creation date	No	No
acintp_modified_by	varchar(30)	NULL	Modify user name	No	No
acintp_modifieddate	datetime	NULL	Modification date	No	No
acintp_timestamp	decimal(38)	NULL	Timestamp value	No	No
acintp_src_ouinstance	decimal(38)	NULL	source OU in interaction model	No	No
acintp_hidden_param_val	decimal(38)	NOT NULL	Value of the Hidden param code like(1,2..10)	No	No

Table Name ac_aciph_inhrit_pos_his

Table Comment Inheritable position history master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
aciph_ouinstance	numeric(10)	NOT NULL	ouinstance	Yes	No
aciph_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft reg no	Yes	No
aciph_pos_code	varchar(25)	NOT NULL	Position code	Yes	No
aciph_transaction_date	datetime	NOT NULL	Transaction date	Yes	No
aciph_prm_attr_type	varchar(5)	NULL	Attribute type-SN(Since new), SO(since overhaul)	No	No
aciph_prm1_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter1.	No	No
aciph_prm2_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter2.	No	No
aciph_prm3_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter3.	No	No
aciph_prm4_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter4.	No	No
aciph_prm5_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter5.	No	No
aciph_prm6_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter6.	No	No
aciph_prm7_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter7.	No	No
aciph_prm8_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter8.	No	No
aciph_prm9_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter9.	No	No
aciph_prm10_delta_new_flag	varchar(5)	NULL	Updation Mode. delta(D) or new (N) flag for parameter10.	No	No
aciph_prm1_incoming_value	decimal(28,8)	NULL	Parameter1-Incoming value	No	No
aciph_prm2_incoming_value	decimal(28,8)	NULL	Parameter2-Incoming value	No	No
aciph_prm3_incoming_value	decimal(28,8)	NULL	Parameter3-Incoming value	No	No
aciph_prm4_incoming_value	decimal(28,8)	NULL	Parameter4-Incoming value	No	No
aciph_prm5_incoming_value	decimal(28,8)	NULL	Parameter5-Incoming value	No	No
aciph_prm6_incoming_value	decimal(28,8)	NULL	Parameter6-Incoming value	No	No
aciph_prm7_incoming_value	decimal(28,8)	NULL	Parameter7-Incoming value	No	No
aciph_prm8_incoming_value	decimal(28,8)	NULL	Parameter8-Incoming value	No	No
aciph_prm9_incoming_value	decimal(28,8)	NULL	Parameter9-Incoming value	No	No
aciph_prm10_incoming_value	decimal(28,8)	NULL	Parameter10-Incoming value	No	No
aciph_inherited_flag	varchar(5)	NULL	inherited flag	No	No
aciph_insp_emp_code	varchar(30)	NULL	Employee code	No	No
aciph_src_tran_ou	numeric(10)	NULL	Source transaction ou	No	No
aciph_src_tran_no	varchar(40)	NULL	Source transaction no	No	No
aciph_createdby	varchar(30)	NULL	User name	No	No
aciph_createddate	datetime	NULL	Creation date	No	No

Table Name ac_aciph_inhrit_prm_his

Table Comment Inheritable parameter history master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
aciph_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
aciph_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Reg no	Yes	No
aciph_component_id	varchar(90)	NOT NULL	Component id	Yes	No
aciph_transaction_date	datetime	NOT NULL	Transaction date	Yes	No
aciph_prm_attr_type	varchar(5)	NOT NULL	Parameter Attribute type	Yes	No
aciph_src_tran_ou	numeric(10)	NOT NULL	Transaction ou	Yes	No
aciph_src_tran_no	varchar(40)	NOT NULL	Transaction no	Yes	No
ACIPH_PRM_CODE	varchar(40)	NULL		No	No
aciph_prm1_delta_new_flag	varchar(5)	NULL	Update mode. delta(D) or new(N).	No	No
aciph_prm2_delta_new_flag	varchar(5)	NULL		No	No
aciph_prm3_delta_new_flag	varchar(5)	NULL		No	No
aciph_prm4_delta_new_flag	varchar(5)	NULL		No	No
aciph_prm5_delta_new_flag	varchar(5)	NULL		No	No
aciph_prm6_delta_new_flag	varchar(5)	NULL		No	No
aciph_prm7_delta_new_flag	varchar(5)	NULL		No	No
aciph_prm8_delta_new_flag	varchar(5)	NULL		No	No
aciph_prm9_delta_new_flag	varchar(5)	NULL		No	No
aciph_prm10_delta_new_flag	varchar(5)	NULL		No	No
aciph_reset_flag	varchar(5)	NULL	Reset Flag Y- Yes N - No	No	No
aciph_prm1_incoming_value	decimal(28,8)	NULL	Parmeter1 -incoming value	No	No
aciph_prm1_cum_value_SN	decimal(28,8)	NULL	Parmeter1 -cumulative value	No	No
aciph_prm1_delta_value	decimal(28,8)	NULL	Parameter1-delta value	No	No
aciph_prm2_incoming_value	decimal(28,8)	NULL	Parmeter2 -incoming value	No	No
aciph_prm2_cum_value_SN	decimal(28,8)	NULL	Parmeter2 -cumulative value	No	No
aciph_prm2_delta_value	decimal(28,8)	NULL	Parameter2-delta value	No	No
aciph_prm3_incoming_value	decimal(28,8)	NULL	Parmeter3 -incoming value	No	No
aciph_prm3_cum_value_SN	decimal(28,8)	NULL	Parmeter3 -cumulative value	No	No
aciph_prm3_delta_value	decimal(28,8)	NULL	Parameter3-delta value	No	No
aciph_prm4_incoming_value	decimal(28,8)	NULL	Parmeter4 -incoming value	No	No
aciph_prm4_cum_value_SN	decimal(28,8)	NULL	Parmeter4 -cumulative value	No	No
aciph_prm4_delta_value	decimal(28,8)	NULL	Parameter4-delta value	No	No
aciph_prm5_incoming_value	decimal(28,8)	NULL	Parmeter5 -incoming value	No	No
aciph_prm5_cum_value_SN	decimal(28,8)	NULL	Parmeter5 -cumulative value	No	No
aciph_prm5_delta_value	decimal(28,8)	NULL	Parameter5-delta value	No	No
aciph_prm6_incoming_value	decimal(28,8)	NULL	Parmeter6 -incoming value	No	No
aciph_prm6_cum_value_SN	decimal(28,8)	NULL	Parmeter6 -cumulative value	No	No
aciph_prm6_delta_value	decimal(28,8)	NULL	Parameter6-delta value	No	No
aciph_prm7_incoming_value	decimal(28,8)	NULL	Parmeter7 -incoming value	No	No
aciph_prm7_cum_value_SN	decimal(28,8)	NULL	Parmeter7 -cumulative value	No	No
aciph_prm7_delta_value	decimal(28,8)	NULL	Parameter7-delta value	No	No
aciph_prm8_incoming_value	decimal(28,8)	NULL	Parmeter8 -incoming value	No	No
aciph_prm8_cum_value_SN	decimal(28,8)	NULL	Parmeter8 -cumulative value	No	No
aciph_prm8_delta_value	decimal(28,8)	NULL	Parameter8-delta value	No	No
aciph_prm9_incoming_value	decimal(28,8)	NULL	Parmeter9 -incoming value	No	No
aciph_prm9_cum_value_SN	decimal(28,8)	NULL	Parmeter9 -cumulative value	No	No
aciph_prm9_delta_value	decimal(28,8)	NULL	Parameter9-delta value	No	No
aciph_prm10_incoming_value	decimal(28,8)	NULL	Parmeter10 -incoming value	No	No
aciph_prm10_cum_value_SN	decimal(28,8)	NULL	Parmeter10 -cumulative value	No	No
aciph_prm10_delta_value	decimal(28,8)	NULL	Parameter10-delta value	No	No
aciph_insp_emp_code	varchar(30)	NULL	Employee code	No	No
aciph_src_transaction	varchar(25)	NULL	Transaction name-Component name	No	No
aciph_createdby	varchar(30)	NULL	User name	No	No
aciph_createddate	datetime	NULL	Creation date	No	No
ACIPH_REMARKS	varchar(255)	NULL		No	No
ACNPH_REMARKS	varchar(255)	NULL		No	No
ACIPH_INHCHLD	varchar(5)	NULL		No	No

Table Name AC_ACIPH_INHRIT_PRM_HIS_OLD

Table Comment Aircraft Inheritable parameter history stored here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACIPH_OUINSTANCE	decimal(10)	NOT NULL	OU Instance	No	No
ACIPH_AIRCRAFT_REG_NO	varchar(30)	NOT NULL	Aircraft Register Number	No	No
ACIPH_COMPONENT_ID	varchar(90)	NOT NULL	Component ID	No	No
ACIPH_TRANSACTION_DATE	datetime	NOT NULL	Transaction Date	No	No
ACIPH_PRM_ATTR_TYPE	varchar(5)	NOT NULL	Parameter Attribute Type	No	No
ACIPH_PRM1_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter1 Delta (or) New Flag	No	No
ACIPH_PRM2_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter2 Delta (or) New Flag	No	No
ACIPH_PRM3_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter3 Delta (or) New Flag	No	No
ACIPH_PRM4_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter4 Delta (or) New Flag	No	No
ACIPH_PRM5_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter5 Delta (or) New Flag	No	No
ACIPH_PRM6_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter6 Delta (or) New Flag	No	No
ACIPH_PRM7_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter7 Delta (or) New Flag	No	No
ACIPH_PRM8_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter8 Delta (or) New Flag	No	No
ACIPH_PRM9_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter9 Delta (or) New Flag	No	No
ACIPH_PRM10_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter10 Delta (or) New Flag	No	No
ACIPH_RESET_FLAG	varchar(5)	NULL	Reset Flag	No	No
ACIPH_PRM1_INCOMING_VALUE	decimal(28,8)	NULL	Parameter1 Incoming Value	No	No
ACIPH_PRM1_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter1 Cumulative Value	No	No
ACIPH_PRM1_DELTA_VALUE	decimal(28,8)	NULL	Parameter1 Delta Value	No	No
ACIPH_PRM2_INCOMING_VALUE	decimal(28,8)	NULL	Parameter2 Incoming Value	No	No
ACIPH_PRM2_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter2 Cumulative Value	No	No
ACIPH_PRM2_DELTA_VALUE	decimal(28,8)	NULL	Parameter2 Delta Value	No	No
ACIPH_PRM3_INCOMING_VALUE	decimal(28,8)	NULL	Parameter3 Incoming Value	No	No
ACIPH_PRM3_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter3 Cumulative Value	No	No
ACIPH_PRM3_DELTA_VALUE	decimal(28,8)	NULL	Parameter3 Delta Value	No	No
ACIPH_PRM4_INCOMING_VALUE	decimal(28,8)	NULL	Parameter4 Incoming Value	No	No
ACIPH_PRM4_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter4 Cumulative Value	No	No
ACIPH_PRM4_DELTA_VALUE	decimal(28,8)	NULL	Parameter4 Delta Value	No	No
ACIPH_PRM5_INCOMING_VALUE	decimal(28,8)	NULL	Parameter5 Incoming Value	No	No
ACIPH_PRM5_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter5 Cumulative Value	No	No
ACIPH_PRM5_DELTA_VALUE	decimal(28,8)	NULL	Parameter5 Delta Value	No	No
ACIPH_PRM6_INCOMING_VALUE	decimal(28,8)	NULL	Parameter6 Incoming Value	No	No
ACIPH_PRM6_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter6 Cumulative Value	No	No
ACIPH_PRM6_DELTA_VALUE	decimal(28,8)	NULL	Parameter6 Delta Value	No	No
ACIPH_PRM7_INCOMING_VALUE	decimal(28,8)	NULL	Parameter7 Incoming Value	No	No
ACIPH_PRM7_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter7 Cumulative Value	No	No
ACIPH_PRM7_DELTA_VALUE	decimal(28,8)	NULL	Parameter7 Delta Value	No	No
ACIPH_PRM8_INCOMING_VALUE	decimal(28,8)	NULL	Parameter8 Incoming Value	No	No
ACIPH_PRM8_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter8 Cumulative Value	No	No
ACIPH_PRM8_DELTA_VALUE	decimal(28,8)	NULL	Parameter8 Delta Value	No	No
ACIPH_PRM9_INCOMING_VALUE	decimal(28,8)	NULL	Parameter9 Incoming Value	No	No
ACIPH_PRM9_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter9 Cumulative Value	No	No
ACIPH_PRM9_DELTA_VALUE	decimal(28,8)	NULL	Parameter9 Delta Value	No	No
ACIPH_PRM10_INCOMING_VALUE	decimal(28,8)	NULL	Parameter10 Incoming Value	No	No
ACIPH_PRM10_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter10 Cumulative Value	No	No
ACIPH_PRM10_DELTA_VALUE	decimal(28,8)	NULL	Parameter10 Delta Value	No	No
ACIPH_INSP_EMP_CODE	varchar(30)	NULL	Inspector Employee Code	No	No
ACIPH_SRC_TRANSACTION	varchar(25)	NULL	Source Transaction	No	No
ACIPH_SRC_TRAN_OU	decimal(10)	NOT NULL	Source Transaction OU Instance	No	No
ACIPH_SRC_TRAN_NO	varchar(40)	NOT NULL	Source Transaction number	No	No
ACIPH_CREATEDBY	varchar(30)	NULL	Created by (application user)	No	No
ACIPH_CREATEDDATE	datetime	NULL	Created on	No	No

Table Name AC_ACIPH_INHRIT_PRM_HIS_PRT

Table Comment Aircraft Inheritable Parameter History stored here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACIPH_OUINSTANCE	decimal(10)	NOT NULL	OU Instance	No	No
ACIPH_AIRCRAFT_REG_NO	varchar(30)	NOT NULL	Aircraft Register Number	No	No
ACIPH_COMPONENT_ID	varchar(90)	NOT NULL	Component ID	No	No
ACIPH_TRANSACTION_DATE	datetime	NOT NULL	Transaction Date	No	No
ACIPH_PRM_ATTR_TYPE	varchar(5)	NOT NULL	Parameter Attribute Type	No	No
ACIPH_PRM1_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter1 Delta (or) New Flag	No	No
ACIPH_PRM2_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter2 Delta (or) New Flag	No	No
ACIPH_PRM3_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter3 Delta (or) New Flag	No	No
ACIPH_PRM4_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter4 Delta (or) New Flag	No	No
ACIPH_PRM5_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter5 Delta (or) New Flag	No	No
ACIPH_PRM6_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter6 Delta (or) New Flag	No	No
ACIPH_PRM7_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter7 Delta (or) New Flag	No	No
ACIPH_PRM8_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter8 Delta (or) New Flag	No	No
ACIPH_PRM9_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter9 Delta (or) New Flag	No	No
ACIPH_PRM10_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter 10 Delta (or) New Flag	No	No
ACIPH_RESET_FLAG	varchar(5)	NULL	Reset Flag	No	No
ACIPH_PRM1_INCOMING_VALUE	decimal(28,8)	NULL	Parameter1 Incoming Value	No	No
ACIPH_PRM1_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter1 Cumulative Value	No	No
ACIPH_PRM1_DELTA_VALUE	decimal(28,8)	NULL	Parameter1 Delta Value	No	No
ACIPH_PRM2_INCOMING_VALUE	decimal(28,8)	NULL	Parameter2 Incoming Value	No	No
ACIPH_PRM2_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter2 Cumulative Value	No	No
ACIPH_PRM2_DELTA_VALUE	decimal(28,8)	NULL	Parameter2 Delta Value	No	No
ACIPH_PRM3_INCOMING_VALUE	decimal(28,8)	NULL	Parameter3 Incoming Value	No	No
ACIPH_PRM3_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter3 Cumulative Value	No	No
ACIPH_PRM3_DELTA_VALUE	decimal(28,8)	NULL	Parameter3 Delta Value	No	No
ACIPH_PRM4_INCOMING_VALUE	decimal(28,8)	NULL	Parameter4 Incoming Value	No	No
ACIPH_PRM4_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter4 Cumulative Value	No	No
ACIPH_PRM4_DELTA_VALUE	decimal(28,8)	NULL	Parameter4 Delta Value	No	No
ACIPH_PRM5_INCOMING_VALUE	decimal(28,8)	NULL	Parameter5 Incoming Value	No	No
ACIPH_PRM5_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter5 Cumulative Value	No	No
ACIPH_PRM5_DELTA_VALUE	decimal(28,8)	NULL	Parameter5 Delta Value	No	No
ACIPH_PRM6_INCOMING_VALUE	decimal(28,8)	NULL	Parameter6 Incoming Value	No	No
ACIPH_PRM6_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter6 Cumulative Value	No	No
ACIPH_PRM6_DELTA_VALUE	decimal(28,8)	NULL	Parameter6 Delta Value	No	No
ACIPH_PRM7_INCOMING_VALUE	decimal(28,8)	NULL	Parameter7 Incoming Value	No	No
ACIPH_PRM7_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter7 Cumulative Value	No	No
ACIPH_PRM7_DELTA_VALUE	decimal(28,8)	NULL	Parameter7 Delta Value	No	No
ACIPH_PRM8_INCOMING_VALUE	decimal(28,8)	NULL	Parameter8 Incoming Value	No	No
ACIPH_PRM8_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter8 Cumulative Value	No	No
ACIPH_PRM8_DELTA_VALUE	decimal(28,8)	NULL	Parameter8 Delta Value	No	No
ACIPH_PRM9_INCOMING_VALUE	decimal(28,8)	NULL	Parameter9 Incoming Value	No	No
ACIPH_PRM9_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter9 Cumulative Value	No	No
ACIPH_PRM9_DELTA_VALUE	decimal(28,8)	NULL	Parameter9 Delta Value	No	No
ACIPH_PRM10_INCOMING_VALUE	decimal(28,8)	NULL	Parameter10 Incoming Value	No	No
ACIPH_PRM10_CUM_VALUE_SN	decimal(28,8)	NULL	Parameter10 Cumulative Value	No	No
ACIPH_PRM10_DELTA_VALUE	decimal(28,8)	NULL	Parameter10 Delta Value	No	No
ACIPH_INSP_EMP_CODE	varchar(30)	NULL	Inspector Employee code	No	No
ACIPH_SRC_TRANSACTION	varchar(25)	NULL	Source Transaction	No	No
ACIPH_SRC_TRAN_OU	decimal(10)	NOT NULL	Transaction OU	No	No
ACIPH_SRC_TRAN_NO	varchar(40)	NOT NULL	Transaction Number	No	No
ACIPH_CREATEDBY	varchar(30)	NULL	Created by	No	No
ACIPH_CREATEDDATE	datetime	NULL	created on	No	No
ACIPH_REMARKS	varchar(255)	NULL	remarks	No	No
ACNPH_REMARKS		NULL		No	No
ACIPH_INHCHLD	varchar(5)	NULL	Inheritable Child	No	No

Table Name ac_aciref_ac_reference_det

Table Comment This table has the reference document details maintained for an Aircraft
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
aciref_refdoc_type	varchar(25)	NOT NULL	Reference Document Type	Yes	No
aciref_document_no	varchar(40)	NOT NULL	Document Number	Yes	No
aciref_refdoc_desc	varchar(150)	NULL	Reference Document Description	No	No
aciref_remarks	varchar(255)	NULL	Remarks	No	No
aciref_filename	varchar(50)	NULL	Filename	No	No
aci_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
ACIREF_AIRCRAFT_REG_NO	varchar(30)	NOT NULL		Yes	No
aci_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	Yes
ACIREF_OUINSTANCE	decimal(10)	NOT NULL		Yes	No

Table Name ac_acjlp_jlog_prm_info

Table Comment Stores journey log parameter information.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acjlp_ouinstance	numeric(10)	NOT NULL	ou instance	Yes	No
acjlp_model	varchar(20)	NOT NULL	aircraft model	Yes	No
acjlp_config_class	varchar(30)	NOT NULL	configuration class	Yes	No
acjlp_leg_wise_param	varchar(5)	NOT NULL	leg wise parameters. Will have values from P1 to P6. P1 - Parameter 1 P2 - Parameter 2 P3 - Parameter 3 P4 - Parameter 4 P5 - Parameter 5 P6 - Parameter 6	Yes	No
acjlp_position_code	varchar(25)	NULL	position code	No	No
acjlp_param_code	varchar(40)	NULL	parameter code	No	No
acjlp_model_ou	numeric(10)	NULL	model ou instance	No	No
acjlp_config_ou	numeric(10)	NULL	configuration class ou	No	No
acjlp_param_ou	numeric(10)	NULL	parameter ou	No	No
acjlp_created_by	varchar(30)	NULL	created by	No	No
acjlp_createddate	datetime	NULL	created date	No	No
acjlp_modified_by	varchar(30)	NULL	modified by	No	No
acjlp_modifieddate	datetime	NULL	modified date	No	No
acjlp_timestamp	numeric(10)	NULL	time stamp	No	No

Table Name ac_acman_manuftr_master

Table Comment Manufacturer Master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acman_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
acman_man_code	varchar(45)	NOT NULL	Manufacturer Code		No
acman_man_desc	varchar(150)	NULL	Manufacturer Description	No	No
acman_man_desc_up	varchar(150)	NULL	Manufacturer Description in upper case	No	No
acman_status	varchar(5)	NULL	status of the manufacturer code A - Active I - Inactive	No	No
acman_cage_code	varchar(5)	NULL	cage code	No	No
acman_sita_arinc_code	varchar(45)	NULL	SITA ARINC Code	No	No
acman_spec_2k_code	varchar(5)	NULL	SPEC 2K CODE	No	No
acman_nscm_code	varchar(5)	NULL	NSCM code	No	No
acman_man_cat	varchar(25)	NULL	Manufacturer Category	No	No
acman_address	varchar(2000)	NULL	Address Details	No	No
acman_address_up	varchar(2000)	NULL	Address details in upper case	No	No
acman_contact_person	varchar(80)	NULL	contact person name	No	No
acman_con_phone	varchar(70)	NULL	contact phone number	No	No
acman_wrk_phone	varchar(70)	NULL	Work Phone	No	No
acman_email_id	varchar(70)	NULL	Email Id	No	No
acman_url	varchar(255)	NULL	URL details	No	No
acman_createdby	varchar(30)	NULL	created by	No	No
acman_created_date	datetime	NULL	created date	No	No
acman_modifiedby	varchar(30)	NULL	Last modified by	No	No
acman_modified_date	datetime	NULL	last modified date	No	No
acman_timestamp	numeric(10,2)	NULL	timestamp	No	No

Table Name AC_ACMD_ModNoEff_Detail

Table Comment Aircraft Model Number Effectivity Detail
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACMD_OUINSTANCE	decimal(18,9)	NOT NULL	OU Instance	No	No
ACMD_AIRCRAFT_REG_NO	varchar(30)	NOT NULL	Aircraft Registration Number	No	No
ACMD_AIRCRAFT_MODEL_NO		NOT NULL	Aircraft Model Number	No	No
ACMD_MOD_NO	varchar(40)	NOT NULL	Modification Number (like version number)	No	No
ACMD_AIRCRAFT_APPLICABILITY	varchar(25)	NULL	Aircraft Applicability	No	No
ACMD_REMARKS	varchar(150)	NULL	Remarks	No	No
ACMD_TIMESTAMP	decimal(18,9)	NULL	Timestamp	No	No
ACMD_CREATED_BY	varchar(30)	NULL	Created By	No	No
ACMD_CREATIONDATE	datetime	NULL	Created on	No	No
ACMD_MODIFIED_BY	varchar(30)	NULL	Modified By	No	No
ACMD_MODIFIEDDATE	datetime	NULL	Modified On	No	No

Table Name ac_acmh_aircraft_maint_his

Table Comment Aircraft Maintenance History.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acmh_work_unit_type	varchar(25)	NULL	Type of the Work Unit Identified WP - Work Package T - Task P - Procedure	No	No
acmh_work_unit_code	varchar(30)	NULL	Work Unit code of the Maintenance Program	No	No
acmh_schedule_no	numeric(10)	NULL	Schedule Number of the PM Cycle	No	No
acmh_last_performed_date	datetime	NULL	The Date on which the Maintenance was performed	No	No
acmh_comments	varchar(255)	NULL	Comments	No	No
acmh_timestamp	numeric(10)	NULL	Timestamp	No	No
aci_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	Yes
aci_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
acmh_pm_cycle_no	varchar(6)	NULL	PM Cycle number of the Maintenance Program	No	No
acmh_maint_prog_no	varchar(30)	NULL	This is the Last Major Maintenance Program Number that has been performed on the aircraft.	No	No
ACMH_OUINSTANCE	decimal(10)	NOT NULL		No	No
ACMH_AIRCRAFT_REG_NO	varchar(30)	NOT NULL		No	No

Table Name ac_acmph_ac_maint_his_prm

Table Comment Maintenance Parameter History.This info will be maintained if the aircraft is not new.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACMPH_AIRCRAFT_REG_NO	varchar(30)	NOT NULL		Yes	No
acmph_param_code	varchar(40)	NOT NULL	Parameter Code	Yes	No
acmph_last_performed_value	decimal(28,8)	NULL	Value when maintenance was last performed	No
aci_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
ACMPH_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
aci_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	Yes

Table Name ac_acnph_non_inhrit_pos_his

Table Comment Non-Inheritable Parameter Position history master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acnph_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
acnph_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft reg no	Yes	No
acnph_pos_code	varchar(25)	NOT NULL	Position code	Yes	No
acnph_prm_code	varchar(40)	NOT NULL	Valid paramerter code	Yes	No
acnph_transaction_date	datetime	NOT NULL	Transaction date	Yes	No
acnph_prm_type	varchar(5)	NULL	Parameter type-(Consumption,Range,Technical ,Attribute) T - Technical C - Consumption A - Attribute	No	No
acnph_prm_attr_type	varchar(5)	NULL	Attribute type-SN(Since new),SO(Since new)	No	No
acnph_delta_new_flag	varchar(5)	NULL	Delta or new flag	No	No
acnph_incoming_value	decimal(28,8)	NULL	Incoming value	No	No
acnph_ta_prm_value	varchar(32)	NULL	Technical/Attribute param value	No	No
acnph_inherited_flag	varchar(5)	NULL	Inherited flag	No	No
acnph_insp_emp_code	varchar(30)	NULL	Employee code	No	No
acnph_src_tran_ou	numeric(10)	NULL	Source transaction ou	No	No
acnph_src_tran_no	varchar(40)	NULL	Source transaction no	No	No
acnph_createdby	varchar(30)	NULL	User name	No	No
acnph_createddate	datetime	NULL	Creation date	No	No

Table Name ac_acnph_non_inhrit_prm_his

Table Comment Non-Inheritable Parameter History
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acnph_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
acnph_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration no	Yes	No
acnph_component_id	varchar(90)	NOT NULL	Component id	Yes	No
acnph_prm_code	varchar(40)	NOT NULL	Parameter code	Yes	No
acnph_transaction_date	datetime	NOT NULL	Transaction date	Yes	No
acnph_prm_attr_type	varchar(5)	NOT NULL	SN or SO(Since new or Since overhaul)	Yes	No
acnph_prm_type	varchar(5)	NULL	Parameter type-Consumption,Range,Tech or Attribute type T - Technical C - Consumption A - Attribute	No	No
acnph_delta_new_flag	varchar(5)	NULL	Delta or new flag	No	No
acnph_reset_flag	varchar(5)	NULL	Reset flag	No	No
acnph_incoming_value	decimal(28,8)	NULL	Incoming value	No	No
acnph_cum_prm_value	decimal(28,8)	NULL	Cumulative value	No	No
acnph_delta_value	decimal(28,8)	NULL	Delta value	No	No
acnph_ta_prm_value	varchar(32)	NULL	Tech /Attribute param value	No	No
acnph_insp_emp_code	varchar(30)	NULL	Employee code	No	No
acnph_src_transaction	varchar(25)	NULL	Transaction name	No	No
acnph_src_tran_ou	numeric(10)	NULL	Transaction ou	No	No
acnph_src_tran_no	varchar(40)	NULL	Source transaction no	No	No
acnph_createdby	varchar(30)	NULL	user name	No	No
acnph_createddate	datetime	NULL	Creation date	No	No
ACNPH_REMARKS	varchar(255)	NULL	Remarks	No	No

Table Name ac_acoi_ac_acquisition_his

Table Comment Acquisition History Of the Aircraft
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACOI_REMARKS	varchar(255)	NULL		No	No
ACOI_CHANGED_BY	varchar(30)	NULL		No	No
acoi_to_date	datetime	NULL	To Date	No	No
acoi_from_date	datetime	NULL	From Date	No	No
acoi_prev_lesse	varchar(40)	NULL	Lesse	No	No
aci_base_ac_reg_no	varchar(30)	NULL		No	No
ACOI_CHANGED_DATE	datetime	NULL		No	No
ACOI_CONFIRMED_DATE	datetime	NULL		No	No
ACOI_CONFIRMED_BY	varchar(30)	NULL		No	No
acoi_base_ac_reg_no	varchar(30)	NULL		No	No
ACOI_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
ACOI_AIRCRAFT_REG_NO	varchar(30)	NOT NULL		Yes	No
aci_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	Yes
aci_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes
acoi_prev_lessor	varchar(40)	NULL	lessor	No	No
acoi_prev_owner	varchar(40)	NULL	Previous Owner	No	No
acoi_prev_reg_no	varchar(30)	NOT NULL	Previous Registration Number	Yes	No
acoi_prev_country	varchar(40)	NULL	Country of the Regulatory Authority	No	No
acoi_prev_reg_cert_no	varchar(40)	NULL	Previous Regulatory Authority	No	No

Table Name ac_acprc_ac_rngcon_prm_list

Table Comment Range and Consumption Parameters for Aircraft is maintained in this table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acprc_formula_id	varchar(20)	NULL	Formula id based on which the value gets updated.	No	No
acprc_present_value	decimal(28,8)	NULL	Present Value	No	No
acprc_as_of_date	datetime	NULL	Present Value as of Date	No	No
acprc_ultimate_life	decimal(28,8)	NULL	Ultimate life gives the maximum life of the lead (reference) parameter after which the component should be discarded.	No	No
acprc_forecast_factor	decimal(28,8)	NULL	This is the Multiplication Factor which is used in Forecasting	No	No
acprc_average_value	decimal(28,8)	NULL	Average Value	No	No
acprc_update_mode	varchar(5)	NULL	Update Mode - N - New or D - Delta	No	No
acprc_computeSeq	numeric(10)	NULL	Computational Sequence for Formula Based parameters for Formula Id calculation	No	No
acprc_as_of_time	datetime	NULL	Present Value as of Time	No	No
acprc_param_update	varchar(5)	NULL	Parameter Update - MND - mandatory or NMD - Non Mandatory	No	No
acprc_warrant_tracking	varchar(5)	NULL	Warranty Tracking Flag	No	No
ACPRC_FHLOGMODE	sql_variant	NULL	Flight Hours logging mode. Eg. Hobbs Meter Reading(HMR)	No	No
aci_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	Yes
ACPRC_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
aci_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
ACPRC_AIRCRAFT_REG_NO	varchar(30)	NOT NULL		Yes	No
ACPRC_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
acprc_to_value	decimal(28,8)	NULL	To Value	No	No
acprc_param_source	varchar(5)	NULL	Parameter Source indicates how the value gets updated.Can be one of the following values ’Parent’, ’Flight Log’, ’Manual’, ’Calculated’ or ’Composite’. PA- Parent FL - Flight Log MA - Manual CA - Calculated	No	No
acprc_from_value	decimal(28,8)	NULL	From Value	No
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
prm_param_code	varchar(40)	NULL	Parameter code	No
acprc_life_prm_flag	varchar(25)	NULL	This flag indicates if the parameter is the life parameter for the Aircraft	No	No
acprc_param_type	varchar(5)	NOT NULL	Parameter Type - Can be R - Range or C - Consumption	No	No

Table Name ac_acprt_aircraft_part_info

Table Comment Part Information. Invetory parts inherited in Aircraft
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acprt_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
acprt_part_no	varchar(40)	NOT NULL	Part Number	Yes	No
acprt_part_ou	numeric(10)	NULL	OUInstance where the part has been created	No	No
acprt_comp_gen_flag	varchar(5)	NULL	Component generation Flag. Can either be Manual or Auto.	No	No
acprt_comp_id_prfx	varchar(5)	NULL	The prefix to be used while generating the Component Id number if the ’Auto’ generate option is set.	No	No
acprt_comp_family_code	varchar(25)	NULL	Component Family code	No	No
acprt_comp_type	varchar(5)	NULL	Can be Apu,Engine,Landing Gear and Others	No	No
acprt_part_classify	varchar(5)	NULL	Can be ’Repairable’, ’Rotable’ or ’Controllable’ REP - Repairable ROT - Rotable CON - Controllable	No	No
acprt_ata_no	varchar(16)	NULL	ATA Chaptor number	No	No
acprt_ata_ouinstance	numeric(10)	NULL	ATA OU	No	No
acprt_zone_no	varchar(15)	NULL	zone no	No	No
acprt_cargo_flag	varchar(25)	NULL	’Y’ indicates that the Part is for a Cargo Plane	No	No
acprt_mel_flag	varchar(25)	NULL	Indicates if this is the Minimum Equipment List	No	No
acprt_rvsm_flag	varchar(25)	NULL	Y Indicates if it is the Reduced Vertical Separation Minimum.	No	No
acprt_planning_base	numeric(10)	NULL	Planning Location for the Part	No	No
acprt_maint_base		NULL	Maintenance Location for the part	No	No
acprt_planner_code	varchar(20)	NULL	Employee Code	No	No
acprt_usage_type	varchar(25)	NULL	User Defined Type	No	No
acprt_lead_param_code	varchar(40)	NULL	Lead parameter for the part. This is the reference parameter that decides the life of the part	No	No
acprt_user_def1	varchar(25)	NULL	Additional Info for the part. User defined	No	No
acprt_user_def2	varchar(25)	NULL		No	No
acprt_user_def3	varchar(25)	NULL		No	No
acprt_comp_det1	varchar(25)	NULL		No	No
acprt_comp_det2	varchar(25)	NULL		No	No
acprt_comp_det3	varchar(25)	NULL		No	No
acprt_created_by	varchar(30)	NULL	Created User Name	No	No
acprt_creationdate	datetime	NULL	Created Date	No	No
acprt_modified_by	varchar(30)	NULL	Last Modified User Name	No	No
acprt_modifieddate	datetime	NULL	Last Modified Date	No	No
acprt_timestamp	numeric(10)	NULL	Timestamp	No	No
acprt_last_num_gen	numeric(10)	NULL	Last Number Type Number	No	No
acprt_part_category_txt	varchar(25)	NULL	part category	No	No
acprt_replacement_type	varchar(5)	NULL	Replacement Type S - SRU L - LRU	No	No
acprt_def_wccode	varchar(30)	NULL	Default WC Code	No	No
acprt_lifted	varchar(5)	NULL	Lifed flag	No	No
acprt_maint_proc	varchar(5)	NULL	Maintenance Process(HotTime, OnCondition, Continously Monitoring)	No	No
acprt_exec_fac	varchar(5)	NULL	Execution Facility (Internal / External)	No	No
acprt_pref_rep_agency	varchar(25)	NULL	Preferred Repair Agency	No	No
acprt_phase_out_policy	varchar(5)	NULL	Phase out policy	No	No

Table Name ac_acpta_ac_tech_att_prmlst

Table Comment Attribute and Technical parameters for Aircraft
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acpta_param_source	varchar(5)	NULL	Parameter Source indicates how the value gets updated.Can be one of the following values ’Parent’, ’Flight Log’, ’Manual’, ’Calculated’ or ’Composite’. CA - Calculated FL - Flight Log MA - Manual PA - Parent	No	No
acpta_param_type		NOT NULL	Parameter Type T - Technical C - Consumption A - Attribute	No
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
acpta_present_value	varchar(15)	NULL	Present Value	No	No
acpta_as_of_date	datetime	NULL	Present Value As of Date	No	No
acpta_as_of_time	datetime	NULL	Present Value as of Time	No	No
aci_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
aci_aircraft_reg_no	varchar(30)	NOT NULL	Aircraft Registration Number		Yes
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
ACPTA_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
ACPTA_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
ACPTA_AIRCRAFT_REG_NO	varchar(30)	NOT NULL		Yes	No

Table Name ac_acptmd_part_model_effect

Table Comment Model where this part is applicable is maintained here
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACPTMD_PART_NO	varchar(40)	NOT NULL		Yes	No
acptmd_model_no	varchar(20)	NOT NULL	Model Number		No
acptmd_model_ou	decimal(38)	NULL	Model ou	No
acprt_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
ACPTMD_OUINSTANCE	decimal(38)	NOT NULL		Yes	No
acprt_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes

Table Name ac_acptpo_phase_out_policy
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acptpo_work_center	varchar(30)	NULL		No	No
acptpo_part_no	varchar(40)	NOT NULL		Yes	No
acptpo_include_chd	varchar(5)	NULL		No	No
acptpo_exec_unit	decimal	NULL			No
acprt_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
acptpo_ouinstance	decimal	NOT NULL		Yes	No
acprt_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes

Table Name ac_acqcsts_status_history
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACQCSTS_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
ACQCSTS_AIR_REGNO	varchar(30)	NOT NULL		Yes	No
ACQCSTS_FROMDATE	datetime	NOT NULL		Yes	No
ACQCSTS_ACREG_STATUS	varchar(15)	NOT NULL		Yes	No
ACQCSTS_REF_DOC_NO	varchar(40)	NULL		No	No
ACQCSTS_REF_DOC_TYPE	varchar(25)	NULL		No	No
ACQCSTS_REASON	varchar(2000)	NULL		No	No
ACQCSTS_APPROVEDBY	varchar(30)	NULL		No	No
ACQCSTS_COMMENTS	varchar(2000)	NULL		No	No
ACQCSTS_CREATEDBY	varchar(30)	NULL		No	No
ACQCSTS_CREATEDDATE	datetime	NULL		No	No

Table Name AC_ACSTS_STATUS_HISTORY

Table Comment Aircraft Status History maintained here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACSTS_OUINSTANCE	numeric(10)	NOT NULL	OU Instance	Yes	No
ACSTS_AIR_REGNO	varchar(30)	NOT NULL	Aircraft Registration Number	Yes	No
ACSTS_FROMDATE	datetime	NOT NULL	Status From Date	Yes	No
ACSTS_STATUS	varchar(10)	NOT NULL	Status of the Aircraft	Yes	No
ACSTS_REF_DOC_NO	varchar(40)	NULL	Reference Document Number	No	No
ACSTS_REF_DOC_TYPE	varchar(25)	NULL	Reference Document Type	No	No
ACSTS_REASON	varchar(2000)	NULL	Reason	No	No
ACSTS_APPROVEDBY	varchar(30)	NULL	Approved by	No	No
ACSTS_COMMENTS	varchar(2000)	NULL	Comments	No	No
ACSTS_CREATEDBY	varchar(30)	NULL	Created By	No	No
ACSTS_CREATEDDATE	datetime	NULL	Creation Date	No	No

Table Name ac_agr_aircraft_group_reg

Table Comment Aircraft mapping to a Group
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
acg_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
acg_group_no	varchar(20)	NOT NULL	Group Number	Yes	Yes
AGR_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
AGR_GROUP_NO	varchar(20)	NOT NULL		Yes	No
agr_aircraft_reg_no	varchar(150)	NOT NULL	Aircraft Registration Number	Yes	No
agr_creationdate	datetime	NULL	Creation Date	No	No
agr_modifieddate	datetime	NULL	Modified Date	No	No
agr_userid	varchar(30)	NOT NULL	User id	No	No

Table Name AC_AOG_STATUS_HISTORY

Table Comment Stores Aircraft On Ground Status details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AOG_OUINSTANCE	numeric(10)	NOT NULL	OU Instance	No	No
AOG_AIR_REGNO	varchar(30)	NULL	Aircraft Registration Number	No	No
AOG_REF_DOC_NO	varchar(40)	NULL	Reference Document Number	No	No
AOG_REF_DOC_TYPE	varchar(25)	NULL	Reference Document Type	No	No
AOG_REASON	varchar(2000)	NULL	Reason	No	No
AOG_APPROVEDBY	varchar(30)	NULL	Approved By	No	No
AOG_FROMDATE	datetime	NULL	From Date	No	No
AOG_COMMENTS	varchar(2000)	NULL	Comments	No	No
AOG_STATUS	varchar(10)	NULL	Status	No	No
AOG_CREATEDBY	varchar(30)	NULL	Created by	No	No
AOG_CREATEDDATE	datetime	NULL	Created on	No	No

Table Name ac_ata_atachapter

Table Comment List Of ATA Chapters
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ata_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
ata_chapterno	varchar(16)	NOT NULL	Air Traffic Association Chapter Number	Yes	No
ata_description	varchar(150)	NOT NULL	Description of the ATA Chaptor	No	No
ata_description_up	varchar(150)	NOT NULL	Upper Description of the ATA Chaptor	No	No
ata_status	varchar(15)	NULL	Status of the ATA Chapter. Can be Active or Inactive A - Active D - Inactive	No	No
ata_created_by	varchar(30)	NULL	Last Modified User	No	No
ata_creationdate	datetime	NULL	Created Date	No	No
ata_modifieddate	datetime	NULL	Last Modified Date	No	No
ata_timestamp	numeric(10)	NULL	Timestamp	No	No
ata_modified_by	varchar(30)	NULL	Last Modified By	No	No

Table Name ac_attp_att_param_details

Table Comment List of possible values for Attribute Type Of Parameters
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
attp_creationdate	datetime	NULL	Creation Date	No	No
attp_userid	varchar(30)	NULL	Last Modified User Name	No	No
attp_param_remarks	varchar(255)	NULL	remarks for the attribute parameter	No	No
attp_modifieddate	datetime	NULL	Last Modified Date	No	No
attp_timestamp	numeric(10)	NULL	Timestamp	No	No
attp_param_type	varchar(5)	NULL	ParameterType - Can be A - attribute and T - Technical	No	No
prm_param_code	varchar(40)	NOT NULL	Parameter code	Yes	Yes
prm_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
attp_param_value	varchar(15)	NOT NULL	The Various values the parameter can take	Yes	No
ATTP_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
ATTP_PARAM_CODE	varchar(40)	NOT NULL		Yes	No

Table Name ac_cfam_component_family

Table Comment Component Family Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CFAM_OUINSTANCE	decimal(10)	NOT NULL	Component Family’s OU Instance	Yes	No
cfam_familycode	varchar(25)	NOT NULL	Name of the component Family	Yes	No
ata_ouinstance	numeric(10)	NULL	ATA OUInstance	No	Yes
ata_chapterno	varchar(16)	NULL	Air Traffic Association Chapter Number	No	Yes
cfam_description	varchar(80)	NULL	Description of the Family code	No	No
CFAM_ATA_CHAPTERNO	varchar(16)	NULL	Chapter No	No	No
cfam_component_type	varchar(5)	NOT NULL	Type of the Component -Apu,Engine,Landing Gear and Others.	No	No
cfam_part_classify		NULL	Type of the Component.Can take values, ’’Rotable’’,’’Repairable’’ or ’’Consumable’’	No	No
cfam_zone_no	varchar(15)	NULL	zone no	No	No
cfam_status	varchar(25)	NOT NULL	Status of the Component Family A - Active I - Inactive	No	No
cfam_cargo_flag	varchar(25)	NOT NULL	Y (Yes) indicates that the component list is for a cargo plane.	No	No
cfam_mel_flag	varchar(25)	NOT NULL	Y (Yes) indicates that the component list is the Minimum Equipment List.	No	No
cfam_rvsm_flag	varchar(25)	NOT NULL	Y indicates that the component list is Reduced Vertical Separation Minimum	No	No
cfam_created_by	varchar(30)	NOT NULL	Created User Name	No	No
cfam_creationdate	datetime	NOT NULL	Created Date	No	No
cfam_modified_by	varchar(30)	NOT NULL	Last Modified User Name	No	No
cfam_modifieddate	datetime	NOT NULL	Last Modified Date	No	No
cfam_timestamp	numeric(10)	NOT NULL	Timestamp	No	No

Table Name ac_cfpat_cmp_fam_at_prm

Table Comment Attribute and Technical parameters for Component Family
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
cfpat_param_value	varchar(15)	NULL	Valid value the Attribute or technical parameter can take.	No	No
cfpat_param_type	varchar(25)	NULL	Parameter Type - Can be ’Attribute’ or ’Technical’ T - Technical C - Consumption A - Attribute	No	No
cfpat_param_source	varchar(10)	NULL	This value indicates the source thru which the parameter gets updated. This can take values ’Flight Log’’, ’’Manual’’, ’’Parent’’, ’’Calculated’’ or ’’Composite’’ CA - Calculated FL - Flight Log MA - Manual PA - Parent	No	No
CFAM_OUINSTANCE	decimal(10)	NOT NULL		Yes	Yes
cfam_familycode	varchar(25)	NOT NULL	Name of the component Family	Yes	Yes
CFPAT_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
CFPAT_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
CFPAT_FAMILYCODE	varchar(25)	NOT NULL		Yes	No

Table Name ac_cfprc_cmp_fam_rngcon_prm

Table Comment Range & Consumption Parameters for Component Family is maintained here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cfprc_to_value	decimal(28,8)	NULL	To Value of the range/Consumption parameter	No	No
cfprc_formula_id	varchar(20)	NULL	Formula id based on which the parameter will get updated	No	No
cfprc_from_value	decimal(28,8)	NULL	The start value of the range/Consumption parameter	No	No
cfprc_ultimate_life	decimal(28,8)	NULL	Ultimate Life Value for the parameter	No	No
cfprc_life_param_flag	varchar(25)	NULL	This flag indicates whether the parameter is a life parameter or not	No	No
cfprc_param_update	varchar(25)	NULL	Parameter Update - MND - Mandatory, NMD - Non Mandatory	No	No
cfprc_average_value	decimal(28,8)	NULL	Average Value	No	No
cfprc_warrant_tracking	varchar(25)	NULL	Warranty Tracking - Can be Y - Yes or N - No	No	No
cfprc_forecast_factor	decimal(28,8)	NULL	Forecast Factor	No	No
cfprc_update_mode	varchar(25)	NULL	Update Mode - N- New, D - Delta	No	No
CFPRC_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
CFPRC_FAMILYCODE	varchar(25)	NOT NULL		Yes	No
CFAM_OUINSTANCE	decimal(10)	NOT NULL		Yes	Yes
cfam_familycode	varchar(25)	NOT NULL	Name of the component Family	Yes	Yes
cfprc_param_source	varchar(10)	NULL	This value indicates the source thru which the parameter gets updated. This can take values ’Flight Log’’, ’’Manual’’, ’’Parent’’, ’’Calculated’’ or ’’Composite’’ FL- Flight Log MA - Manual PA - Parent CA - Calculated	No	No
cfprc_param_type	varchar(25)		Parameter Type - Can be R - Range or C - Consumption	No	No
CFPRC_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes

Table Name ac_cmpid_component_id_info

Table Comment Component Id information
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CMPID_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
cmpid_component_id	varchar(90)	NOT NULL	Component Id	Yes	No
acprt_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
acprt_part_no	varchar(40)	NULL	Part Number	No	Yes
CMPID_PART_NO	varchar(40)	NULL		No	No
cmpid_part_ou	numeric(10)	NULL	Part OU	No	No
cmpid_serial_no	varchar(40)	NULL	Serial Number of the Part	No	No
cmpid_status	varchar(5)	NULL	Status of the Component. This is user defined A - Active I - Inactive	No	No
cmpid_comp_family_no	varchar(25)	NULL	Family Id of the Component	No	No
cmpid_comp_type	varchar(5)	NULL	Component Type-Apu-A,Engine-E, Landing Gear-L,Others-O	No	No
cmpid_part_classify	varchar(5)	NULL	Type can be "Rotable’’, ’’Repairable’’, or ’’Consumable’’	No	No
cmpid_ata_no	varchar(16)	NULL	ATA Number	No	No
cmpid_zone_no	varchar(15)	NULL	zone code	No	No
cmpid_cargo_flag	varchar(25)	NULL	Cargo	No	No
cmpid_rvsm_flag	varchar(25)	NULL	RVSM	No	No
cmpid_mel_flag	varchar(25)	NULL	Minimum Equipment List Flag - Can be ’Yes’ or ’No’	No	No
cmpid_ownership	varchar(5)	NULL	Ownership of the Component. Can be ’Owned’ or ’External’ OWN - Owned CUS - Customer SUP - Supplier EXT - External	No	No
cmpid_posession_status	varchar(5)	NULL	Possession Status of the Component can be ’Loaned’ or ’Exchanged’ EX -Exchanged LI - Loaned-In LN - Loaned PBH - PBH RO - Rented-Out	No	No
cmpid_induction_date	datetime	NULL	Induction Date of the Component	No	No
cmpid_operation_date	datetime	NULL	Operation Date of the Component	No	No
cmpid_planning_base	numeric(10)	NULL	Planning Base	No	No
cmpid_maint_base	numeric(10)	NULL	Maintenance Base identified for the Component	No	No
cmpid_planner_code	varchar(20)	NULL	Employee who plans for the component	No	No
cmpid_Component_condition	varchar(5)	NULL	Condition of the Component. Can be either ’Operational’ or ’Under Maintenance’ or ’Phased Out’ OVH - Over Hauled PO - Phased Out SER - Serviceable NW - New USR - Un-Serviceable	No	No
cmpid_fromdate	datetime	NULL	From Date	No	No
cmpid_lead_param_code	varchar(40)	NULL	Lead Parameter Code	No	No
cmpid_po_number	varchar(40)	NULL	PO Number	No	No
cmpid_po_date	datetime	NULL	PO Date	No	No
cmpid_acquisition_Value	decimal(28,8)	NULL	Acquisition Value	No	No
cmpid_book_value	decimal(28,8)	NULL	Book Value	No	No
cmpid_user_Def1	varchar(25)	NULL	User Defined	No	No
cmpid_user_Def2	varchar(25)	NULL		No	No
cmpid_user_Def3	varchar(25)	NULL		No	No
cmpid_component_Det1	varchar(25)	NULL	Additional details if any	No	No
cmpid_component_Det2	varchar(25)	NULL		No	No
cmpid_component_Det3	varchar(25)	NULL		No	No
cmpid_notes	varchar(2000)	NULL	Notes	No	No
cmpid_comments	varchar(255)	NULL	Comments	No	No
cmpid_serial_pre	varchar(40)	NULL	Serial Number prefix	No	No
cmpid_serial_suff	varchar(40)	NULL	Serial Number Suffix	No	No
cmpid_created_by	varchar(30)	NULL	Created By	No	No
cmpid_creationdate	datetime	NULL	Creation Date	No	No
cmpid_modified_by	varchar(30)	NULL	Last Modified by	No	No
cmpid_modifieddate	datetime	NULL	Last Modified Date	No	No
cmpid_timestamp	numeric(10)	NULL	Timestamp	No	No
cmpid_msn_no	varchar(40)	NULL	Manufacturer serial number	No	No
cmpid_manufactured_date	datetime	NULL	Manufactured Date	No	No
cmpid_def_wccode	varchar(30)	NULL	Default work center code	No	No
cmpid_polocation_ou	decimal(38)	NULL	PO location ouinstance	No	No
cmpid_engagement_type	varchar(5)	NULL	engagement type F - Full Maintenance O - On Request	No	No
cmpid_owning_agency_no	varchar(45)	NULL	owning agency code. can have customer code or supplier code	No	No
cmpid_owning_agency_ou	numeric(10)	NULL	owning agency ou	No	No
cmpid_first_issue	varchar(25)	NULL	first issue.	No	No
cmpid_pref_status	sql_variant	NULL	Preferred Status	No	No
cmpid_stkstatus	sql_variant	NULL	Stock Status	No	No
cmpid_retmnt_datetime	sql_variant	NULL	Retirement Datetime	No	No

Table Name Ac_CmpOwn_OwnShipChg_his

Table Comment This tables maintains the ownership change history for the components.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cmpown_ouinstance	numeric(10)	NOT NULL	component ouinstance	Yes	No
cmpown_component_id	varchar(90)	NOT NULL	Component id	Yes	No
cmpown_transaction_date	datetime	NOT NULL	Component Ownership change date	Yes	No
cmpown_transaction_no	varchar(40)	NOT NULL	Transaction no for changing the component ownership	Yes	No
cmpown_transaction_type	varchar(25)	NOT NULL	Transaction Component	Yes	No
cmpown_transaction_ou	numeric(10)	NULL	Transaction ou	No	No
cmpown_compOwnership	varchar(25)	NULL	Component ownership OWN - Owned CUS - Customer SUP - Supplier EXT - External	No	No
cmpown_compPosessionStatus	varchar(25)	NULL	Component Possession status EX -Exchanged LI - Loaned-In LN - Loaned PBH - PBH RO - Rented-Out	No	No
cmpown_owningAgency	varchar(25)	NULL	Owning Agency code	No	No
cmpown_ownAgencyName	varchar(25)	NULL	Owning Agency name	No	No
cmpown_remarks	varchar(255)	NULL	Remarks	No	No
cmpown_TransferType	varchar(25)	NULL	Component Transfer Type EXI - Exchange-In EXO - Exchange-Out LAN - Loan PUR - Purchase REN - Rental SAL - Sale SVG - Salvaged	No	No
cmpown_changedesc	varchar(255)	NULL	String as Changed attribute names + "Edited". Attribute names Component ownership Possession status Owning Agency	No	No

Table Name ac_cmprc_cmp_rngcon_prmlist

Table Comment Range and Consumption parameters for Components
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cmprc_TSN	decimal(28,8)	NULL	Value Since New	No	No
cmprc_update_mode	varchar(5)	NULL	Update Mode. Can be either n - New or D - Delta	No	No
cmprc_TSO	decimal(28,8)	NULL	Value Since Overhaul	No	No
cmprc_TSR	decimal(28,8)	NULL	Value since Repair	No	No
cmprc_as_of_time	datetime	NULL	Parameter Value as of Time	No	No
cmprc_param_update	varchar(5)	NULL	Parameter Update - MND - Mandatory or NMD - Non Mandatory	No	No
cmprc_warrant_tracking	varchar(5)	NULL	Warranty Tracking Flag	No	No
cmprc_as_of_date	datetime	NULL	Parameter Value as of Date	No	No
cmprc_computeSeq	numeric(10)	NULL	Computational Sequence for Formula based parameters for Formula id calculation	No	No
cmprc_as_of_time_his	datetime	NULL	Parameter Value As of Induction Date Time	No	No
CMPRC_INI_VALUE	decimal(28,8)	NULL	Initial Value	No	No
cmprc_TSI	decimal(28,8)	NULL	Value Since Inspection	No	No
cmprc_TSV	decimal(28,8)	NULL	Value since last shop visit	No	No
cmprc_as_of_date_his	datetime	NULL	Parameter Value As of Induction Date	No	No
cmprc_TSN_his	decimal(28,8)	NULL	Since New - Induction Value	No	No
CMPRC_INI_UNKNOWN	varchar(5)	NULL		No	No
CMPRC_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
CMPRC_COMPONENT_ID	varchar(90)	NOT NULL		Yes	No
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
cmpid_component_id	varchar(90)	NOT NULL	Component Id	Yes	Yes
CMPRC_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
CMPID_OUINSTANCE	decimal(10)	NOT NULL		Yes	Yes
cmprc_formula_id	varchar(20)	NULL	Formula Id for the parameter	No	No
cmprc_forecast_factor	decimal(28,8)	NULL	Forecast Factor.	No	No
cmprc_average_value	decimal(28,8)	NULL	Average Value	No	No
cmprc_ultimate_life	decimal(28,8)	NULL	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	No
cmprc_param_type	varchar(5)	NULL	Parameter Type. Can by ’R’ - Range or C - Consumption	No	No
cmprc_life_prm_flag	varchar(5)	NULL	Flag indicating if the parameter identified is life parameter or not for the component	No	No
cmprc_to_value	decimal(28,8)	NULL	To Value of the Parameter	No	No
cmprc_param_source	varchar(5)	NULL	Parameter Source indicates how the value gets updated. Can be one of the following values ’Parent’, ’Flight Log’, ’Manual’, ’Calculated’ or ’Composite’. CA - Calculated FL - Flight Log MA - Manual PA - Parent	No	No
cmprc_from_value	decimal(28,8)	NULL	From Value of the Parameter	No	No

Table Name ac_cmpref_comp_reference_det

Table Comment This table has the reference document details maintained for a Component
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cmpref_refdoctype	varchar(25)	NOT NULL	Reference Document Type	Yes	No
cmpref_documentno	varchar(40)	NOT NULL	Document Number	Yes	No
cmpref_refdocdesc	varchar(150)	NULL	Reference Document Description	No	No
cmpref_remarks	varchar(255)	NULL	Remarks	No	No
cmpref_filename	varchar(50)	NULL	Filename	No	No
CMPREF_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
CMPID_OUINSTANCE	decimal(10)	NOT NULL		Yes	Yes
cmpid_component_id	varchar(90)	NOT NULL	Component Id	Yes	Yes
CMPREF_COMPONENT_ID	varchar(90)	NOT NULL		Yes	No

Table Name AC_CMPRM_COMP_PRM_HIS

Table Comment Aircraft Component Parameter History maintained here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CMPRM_OUINSTANCE	decimal(10)	NOT NULL	OU Instance	Yes	No
CMPRM_COMPONENT_ID	varchar(90)	NOT NULL	Component ID	Yes	No
CMPRM_TRANSACTION_DATE	datetime	NOT NULL	Transaction Date	Yes	No
CMPRM_PRM_CODE	varchar(40)	NOT NULL	Parameter Code	Yes	No
CMPRM_SRC_TRAN_OU	decimal(10)	NOT NULL	Source Transaction OU	Yes	No
CMPRM_SRC_TRAN_NO	varchar(40)	NOT NULL	Source Transaction Number	Yes	No
CMPRM_DELTA_VALUE	decimal(28,8)	NULL	Delta Value	No	No
CMPRM_ENTITY_TYPE	varchar(5)	NULL	Entity Type	No	No
CMPRM_ENTITY_OU	decimal(10)	NULL	Entity OU	No	No
CMPRM_SRC_AIRCRAFT_REG_NO	varchar(30)	NULL	Aircraft Registration Number	No	No
CMPRM_SRC_COMPONENT_ID	varchar(90)	NULL	Source Component ID	No	No
CMPRM_SRC_TRANSACTION	varchar(25)	NULL	Source Transaction	No	No
CMPRM_CREATEDBY	varchar(30)	NULL	Created By	No	No
CMPRM_CREATEDDATE	datetime	NULL	Created on	No	No

Table Name ac_cmpta_cmp_techatt_prmlst

Table Comment Attribute and Technical parameter list for the Components
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cmpta_present_value	varchar(15)	NULL	Present Value of the Parameter	No	No
cmpta_as_of_date	datetime	NULL	Present Value updated as of Date	No	No
cmpta_param_source	varchar(5)	NULL	Parameter Source indicates how the value gets updated. Can be one of the following values ’Parent’, ’Flight Log’, ’Manual’, ’Calculated’ or ’Composite’. FL - Flight Log PA - Parent MA - Manual CA - Calculated	No	No
cmpta_param_type	varchar(5)	NULL	Parameter type - Can be A - Attribute or T - Technical	No	No
cmpta_as_of_date_his	datetime	NULL	History value as of Date	No	No
cmpta_as_of_time	datetime	NULL	Present Value updated as of Time	No	No
cmpta_present_value_his	varchar(15)	NULL	Present value at the time acquisition if any	No	No
cmpta_as_of_time_his	datetime	NULL	History value as of Time	No	No
CMPID_OUINSTANCE	decimal(10)	NOT NULL		Yes	Yes
CMPTA_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
cmpid_component_id	varchar(90)	NOT NULL	Component Id	Yes	Yes
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
CMPTA_COMPONENT_ID	varchar(90)	NOT NULL		Yes	No
CMPTA_PARAM_CODE	varchar(40)	NOT NULL		Yes	No

Table Name AC_CMPTS_COMP_TS_VAL_DET
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CMPTS_COMPONENT_ID	varchar(90)	NOT NULL		Yes	No
CMPTS_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
CMPTS_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
CMPTS_TSN	decimal(28,8)	NULL		No	No
CMPTS_TSO	decimal(28,8)	NULL		No	No
CMPTS_TSR	decimal(28,8)	NULL		No	No
CMPTS_TSI	decimal(28,8)	NULL		No	No
CMPTS_TSV	decimal(28,8)	NULL		No	No
CMPTS_TSLI	decimal(28,8)	NULL		No	No

Table Name AC_CNGAC_ACREGCHANGE_LOG

Table Comment Aircraft Registration number change details(Log) maintained here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
CNGAC_OUINSTANCE	decimal(10)	NULL	OU Instance	No	No
CNGAC_AC_REG_NO	varchar(30)	NULL	Current Aircraft Registration number	No	No
CNGAC_NEWAC_REG_NO	varchar(20)	NULL	New Aircraft Registration number	No	No
CNGAC_STATUS	varchar(5)	NULL	Authorization Status	No	No
CNGAC_TAB_NO	varchar(30)	NULL	Tab number	No	No
CNGAC_TAIL_NO	varchar(30)	NULL	Tail number	No	No
CNGAC_REG_AUTH	varchar(25)	NULL	Registration Authority	No	No
CNGAC_REG_CERT_NO	varchar(40)	NULL	Registration Certificate Number	No	No
CNGAC_ISSUE_DATE	datetime	NULL	Issued Date	No	No
CNGAC_OWNERSHIP	varchar(5)	NULL	Ownership	No	No
CNGAC_OWNAGENCY_NO	varchar(45)	NULL	Owning Agency number	No	No
CNGAC_OWNAGENCY_OU	decimal(10)	NULL	Owning Agency OU Instance	No	No
CNGAC_LEASE_TYPE	varchar(5)	NULL	Lease Type	No	No
CNGAC_EFF_FROM_DATE	datetime	NULL	Effective From Date	No	No
CNGAC_REPREASON	varchar(20)	NULL	Repreason	No	No
CNGAC_CHGREASON	varchar(255)	NULL		No	No
CNGAC_INTIATED_BY	varchar(30)	NULL	Initiater ID	No	No
CNGAC_INITIATEDDATE	datetime	NULL	Initiated Date	No	No
CNGAC_CONFIRMED_BY	varchar(30)	NULL	Confirmed User ID	No	No
CNGAC_CONFIRMEDDATE	datetime	NULL	Confirmed on	No	No
CNGAC_COMPLETEDDATE	datetime	NULL	Completed on	No	No

Table Name ac_comphs_com_prtchange_his

Table Comment This table maintains the details of the part modifications taken place for a component
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
comphs_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
comphs_component_id	varchar(90)	NOT NULL	Component Id For which the part got modified	Yes	No
comphs_transaction_no	varchar(40)	NOT NULL	Transaction number that changed the part	Yes	No
comphs_transaction_ou	numeric(10)	NOT NULL	Transaction Ou	Yes	No
comphs_transaction_type	varchar(90)	NOT NULL	Transaction Type	Yes	No
comphs_updateddate	datetime	NOT NULL	Updated Date	Yes	No
comphs_old_part_no	varchar(40)	NULL	Old Part Number	No	No
comphs_old_serial_no	varchar(40)	NULL	old part serial no.	No	No
comphs_old_part_ou	numeric(10)	NULL	old part ou	No	No
comphs_updated_by	varchar(30)	NULL	Updated By	No	No
comphs_new_part_no	varchar(40)	NULL	New Part Number	No	No
comphs_new_serial_no	varchar(40)	NULL	new part serial no.	No	No
comphs_new_part_ou	numeric(10)	NULL	new part ou	No	No

Table Name ac_mdl_ac_model_definition

Table Comment Model Definition Table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mdl_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	No
mdl_model_no	varchar(20)	NOT NULL	Model of the Aircraft	Yes	No
mdl_ac_make	varchar(45)	NULL	Make of the aircraft	No	No
mdl_ac_make_up	varchar(45)	NULL	Aircraft Make in Upper Case - This is used in Search criteria	No	No
mdl_ac_type	varchar(25)	NULL	These types are user defined types defaulted from the Quick code master	No	No
mdl_description	varchar(150)	NOT NULL	Brief description of the model	No	No
mdl_description_up	varchar(150)	NOT NULL	Description in Upper Case	No	No
mdl_status	varchar(15)	NULL	Status of the Model. Can be Active or Inactive	No	No
mdl_creationdate	datetime	NULL	creation Date	No	No
mdl_created_by	varchar(30)	NULL	Created By	No	No
mdl_modifieddate	datetime	NULL	Last Modified Date	No	No
mdl_modified_by	varchar(30)	NULL	Last Modified By	No	No
mdl_timestamp	numeric(10)	NULL	Timestamp	No	No
mdl_typecertno	varchar(40)	NULL	Type Certificate Number	No	No
mdl_filename	varchar(50)	NULL	file name	No	No
MDL_FHLOGMODE	sql_variant	NULL	Flight Hours logging mode. Eg. Hobbs Meter Reading(HMR)	No	No

Table Name ac_mdrcp_model_rng_cons_prm

Table Comment Range and Consumption parameters for Models
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mdrcp_average_value	decimal(28,8)	NULL	Average Value	No	No
mdrcp_forecast_factor	decimal(28,8)	NULL	Forecast Factor	No	No
mdrcp_to_value	decimal(28,8)	NULL	To Value in case of Range Parameters	No	No
mdrcp_from_value	decimal(28,8)	NULL	From Value in case of Range Parameters	No	No
mdrcp_param_update	varchar(5)	NULL	Parameter Update - MND - Mandatory, NMD - Non Mandatory	No	No
mdrcp_ultimate_life	decimal(28,8)	NULL	Ultimate Life	No	No
mdrcp_warrant_tracking	varchar(5)	NULL	Warranty Tracking Flag	No	No
mdrcp_formula_id	varchar(20)	NULL	Formula Id if the parameter is calculated based on a formula	No	No
mdrcp_update_mode	varchar(5)	NULL	Update Mode - Can be D - Delta and N- New	No	No
MDRCP_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
MDRCP_MODEL_NO	varchar(20)	NOT NULL		Yes	No
mdl_model_no	varchar(20)	NOT NULL	Model of the Aircraft	Yes	Yes
mdl_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
mdrcp_param_source	varchar(5)	NULL	Parameter Source indicates how the value gets updated. Can be one of the following values ’Parent’, ’Flight Log’, ’Manual’, ’Calculated’ or ’Composite’. FL - Flight Log CA - Calculated MA - Manual PA - Parent	No	No
mdrcp_life_param_flag	varchar(25)	NULL	Life Parameter Flag	No	No
MDRCP_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes

Table Name ac_mdtap_model_tech_att_prm

Table Comment Technical and Attribute parameters for Model
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
MDTAP_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
mdtap_param_source	varchar(5)	NULL	Parameter Source indicates how the value gets updated. Can be one of the following values ’Parent’, ’Flight Log’, ’Manual’, ’Calculated’ or ’Composite’. FL - Flight Log PA - Parent MA - Manual CA - Calculated	No	No
mdtap_param_value	varchar(15)	NULL	Parameter Value	No	No
mdl_ouinstance	numeric(10)	NOT NULL	Ouinstance	Yes	Yes
MDTAP_MODEL_NO	varchar(20)	NOT NULL		Yes	No
mdl_model_no	varchar(20)	NOT NULL	Model of the Aircraft	Yes	Yes
MDTAP_OUINSTANCE	decimal(10)	NOT NULL		Yes	No

Table Name ac_mfgata_mfg_ata_chapter

Table Comment Maintains Manufacturer ata details against each ATA chapter.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
mfgata_ouinstance	numeric(10)	NOT NULL	Manufacturer Ata chapter ouinstance	Yes	No
mfgata_ata_chapter_no	varchar(16)	NOT NULL	ATA chapter no	Yes	No
mfgata_mfg_ata_chapter_no	varchar(16)	NOT NULL	Manufacturer ATA chapter no	Yes	No
mfgata_manufacturer	varchar(45)	NOT NULL	Manufacturer	Yes	No
mfgata_mfg_ata_chap_desc	varchar(150)	NULL	Manufacturer ATA chapter description	No	No
mfgata_mfg_ata_chap_desc_up	varchar(150)	NULL	Manufacturer ATA chapter description in upper case	No	No
mfgata_status	varchar(15)	NULL	status A - Active I - Inactive	No	No
mfgata_remarks	varchar(255)	NULL	remarks	No	No
mfgata_created_by	varchar(30)	NULL	created by	No	No
mfgata_creationdate	datetime	NULL	created date	No	No
mfgata_modified_by	varchar(30)	NULL	modified by	No	No
mfgata_modifieddate	datetime	NULL	modified date	No	No

Table Name ac_ncmb_non_comp_maint_obj

Table Comment Identifies non-component Maintenance Objects
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ncmb_ouinstance	numeric(10)	NOT NULL	ou instance	Yes	No
ncmb_object_type	varchar(5)	NOT NULL	object type. Can have ’FAC’, ’MAK’, ’PIP’, ’PRO’, ’RIN’ or ’MSC’. FAC - Facility MAK - Make PIP - Piece Part PRO - Project RIN - Receipt-Inspection MSC - Miscellaneous	Yes	No
ncmb_component_id	varchar(16)	NOT NULL	component id	Yes	No
ncmb_component_ou	numeric(10)	NULL	component ou	No	No
ncmb_timestamp	numeric(10)	NULL	timestamp	No	No
ncmb_created_by	varchar(30)	NULL	created by	No	No
ncmb_creationdate	datetime	NULL	created date	No	No
ncmb_modified_by	varchar(30)	NULL	modified by	No	No
ncmb_modifieddate	datetime	NULL	modified date	No	No
ncmb_signoff_reqd	varchar(5)	NULL	Signoff required flag	No	No
ncmb_auth_reqd	varchar(5)	NULL	Authorization Required Flag	No	No

Table Name ac_parameter_details

Table Comment Meta Data for Aircraft
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
componentname	varchar(80)	NOT NULL	Component Name	Yes	No
ParamCategory	varchar(10)	NOT NULL	Parameter Category	Yes	No
ParamType	varchar(15)	NOT NULL	Parameter Type	Yes	No
ParamCode	varchar(10)	NOT NULL	Parameter Code	Yes	No
ParamDesc	varchar(80)	NOT NULL	Parameter Description	No	No
Langid	numeric(10)	NOT NULL	Language Id	No	No
Creationdate	datetime	NULL	Creation Date	No	No
sortby	numeric(10)	NULL	Sort Order	No	No

Table Name ac_prm_param_details

Table Comment Parameter Master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
prm_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
prm_param_code	varchar(40)	NOT NULL	Parameter code	Yes	No
prm_type	varchar(25)	NOT NULL	Parameter Type - can be Technical, range , consumption or attribute type	No	No
prm_description	varchar(150)	NOT NULL	Parameter description	No	No
prm_uom	varchar(10)	NULL	Parameter unit of measure	No	No
prm_formula_id	varchar(20)	NULL	The formula id to which the parameter is associated	No	No
prm_status	varchar(5)	NULL	This is the status of the parameter. Value can be either active or Inactive	No	No
prm_created_by	varchar(30)	NOT NULL	Last Modified User Name	No	No
prm_creationdate	datetime	NOT NULL	created date	No	No
prm_modifieddate	datetime	NOT NULL	Last Modified Date	No	No
prm_timestamp	numeric(10)	NOT NULL	Timestamp	No	No
prm_modified_by	varchar(30)	NULL	Last Modified By	No	No
prm_disp_format	sql_variant	NULL	Parameter Display format E.g HHMM for Hours format display DEC for decimal format display	No	No

Table Name ac_prtrc_part_rngcon_prmlst

Table Comment Range and Consumption Parameters for Parts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
prtrc_avg_value	decimal(28,8)	NULL	Average Value	No	No
prtrc_forecast_factor	decimal(28,8)	NULL	Forecast Factor for the parameter	No	No
prtrc_to_value	decimal(28,8)	NULL	Valid To Value for the parameter	No	No
prtrc_from_value	decimal(28,8)	NULL	Valid From value for the parameter	No	No
prtrc_param_source	varchar(5)	NULL	Parameter Source indicates how the value gets updated. Can be one of the following values ’Parent’, ’Flight Log’, ’Manual’, ’Calculated’ or ’Composite’. CA - Calculated FL - Flight Log MA - Manual PA - Parent	No	No
prtrc_param_update	varchar(5)	NULL	Parameter Update - Can be MND - Mandatory or NMD - Non Mandatory	No	No
prtrc_ultimate_life	decimal(28,8)	NULL	Ultimate life gives the maximum life of the lead (reference) parameter after which the component should be discarded.	No	No
prtrc_warrant_tracking	varchar(5)	NULL	Warranty Tracking	No	No
prtrc_formula_id	varchar(20)	NULL	Formula id based on the value of the parameter is updated	No	No
prtrc_update_mode	varchar(5)	NULL	Update Mode - can be N - New or D - Delta	No	No
PRTRC_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
PRTRC_PART_NO	varchar(40)	NOT NULL		Yes	No
acprt_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes
acprt_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
prtrc_life_param_flag	varchar(5)	NULL	’Y’ indicates that the parameter is a life parameter.	No	No
prtrc_param_type	varchar(25)	NULL	Parameter Type - Can be R - Range C - Consumption		No
PRTRC_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes

Table Name ac_prtta_prt_techatt_prmlst

Table Comment Technical and Attribute parameter list for parts
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
prm_param_code	varchar(40)	NULL	Parameter code	No	Yes
prm_ouinstance	numeric(10)	NULL	OUInstance	No	Yes
prtta_param_type	varchar(25)	NULL	Parameter Type - Can be T - Technical or A - Attribute	No	No
prtta_param_source	varchar(5)	NULL	Parameter Source indicates how the value gets updated. Can be one of the following values ’Parent’, ’Flight Log’, ’Manual’, ’Calculated’ or ’Composite’. CA - Calculated FL - Flight Log MA - Manual PA - Parent	No	No
prtta_present_value	varchar(15)	NULL	Present Value of the parameter	No	No
acprt_part_no	varchar(40)	NOT NULL	Part Number	Yes	Yes
acprt_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	Yes
PRTTA_PARAM_CODE	varchar(40)	NOT NULL		Yes	No
PRTTA_OUINSTANCE	decimal(10)	NOT NULL		Yes	No
PRTTA_PART_NO	varchar(40)	NOT NULL		Yes	No

Table Name AC_PVCPRM_COMPONENT_PRM_HIS

Table Comment Component’s parameter history maintained here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PVCPRM_COMPONENT_OU	decimal(10)	NOT NULL	OU Instance	Yes	No
PVCPRM_COMPONENT_ID	varchar(90)	NOT NULL	Component ID	Yes	No
PVCPRM_TRANSACTION_DTTIME	datetime	NOT NULL	Transaction DateTime	Yes	No
PVCPRM_AIRCRAFT_OU	decimal(10)	NULL	Aircraft OU	No	No
PVCPRM_AIRCRAFT_REG_NO	varchar(30)	NULL	Aircraft Register Number	No	No
PVCPRM_PART_NO	varchar(40)	NULL	Part number	No	No
PVCPRM_PART_SERIAL	varchar(40)	NULL	Part Serial number	No	No
PVCPRM_ATA_NO	varchar(16)	NULL	Air Traffic Association number	No	No
PVCPRM_DELTAFH	decimal(28,8)	NULL	Delta FH value	No	No
PVCPRM_DELTAFC	decimal(28,8)	NULL	Delta FC value	No	No
PVCPRM_CREATED_DATE	datetime	NULL	Creation Date	No	No

Table Name AC_PVIPRM_INHRIT_PRM

Table Comment Inhertiable parameters maintained here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PVIPRM_GUID	varchar(40)	NOT NULL	Global Unique Identifier	Yes	No
PVIPRM_OUINSTANCE	decimal(10)	NOT NULL	OU Instance	Yes	No
PVIPRM_USER	varchar(30)	NOT NULL	User ID	Yes	No
PVIPRM_LANGUAGE	decimal(10)	NOT NULL	Language	Yes	No
PVIPRM_SRCCOMPCODE	varchar(20)	NOT NULL	Source Component Code	Yes	No
PVIPRM_SRCOUINSTANCE	decimal(10)	NOT NULL	Source OU Instance	Yes	No
PVIPRM_MAINTOBJECTTYPE	varchar(10)	NOT NULL	Maintenance object type	Yes	No
PVIPRM_ENTITY_OU	decimal(10)	NOT NULL	Entity OU	Yes	No
PVIPRM_AIRCRAFT_REG_NO	varchar(30)	NOT NULL	Aircraft Register No	Yes	No
PVIPRM_COMPONENT_ID	varchar(90)	NOT NULL	Component ID	Yes	No
PVIPRM_TRANSACTION_DATE	datetime	NOT NULL	Transaction Date	Yes	No
PVIPRM_POS_CODE	varchar(25)	NOT NULL	Position Code	Yes	No
PVIPRM_SRC_TRAN_NO	varchar(40)	NOT NULL	Source Transaction number	Yes	No
PVIPRM_PRM_ATTR_TYPE	varchar(5)	NOT NULL	Parameter Attribute type	Yes	No
PVIPRM_RESET_FLAG	varchar(5)	NULL	Reset Flat	No	No
PVIPRM_PRM1_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter1 Delta or New Flag	No	No
PVIPRM_PRM2_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter2 Delta or New Flag	No	No
PVIPRM_PRM3_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter3 Delta or New Flag	No	No
PVIPRM_PRM4_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter4 Delta or New Flag	No	No
PVIPRM_PRM5_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter5 Delta or New Flag	No	No
PVIPRM_PRM6_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter6 Delta or New Flag	No	No
PVIPRM_PRM7_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter7 Delta or New Flag	No	No
PVIPRM_PRM8_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter8 Delta or New Flag	No	No
PVIPRM_PRM9_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter9 Delta or New Flag	No	No
PVIPRM_PRM10_DELTA_NEW_FLAG	varchar(5)	NULL	Parameter10 Delta or New Flag	No	No
PVIPRM_SRC_TRANSACTION	varchar(25)	NULL	Source Transaction	No	No
PVIPRM_PRM1_CODE	varchar(40)	NULL	Parameter1 code	No	No
PVIPRM_PRM1_VALUE	decimal(28,8)	NULL	Parameter1 value	No	No
PVIPRM_PRM2_CODE	varchar(40)	NULL	Parameter2 code	No	No
PVIPRM_PRM2_VALUE	decimal(28,8)	NULL	Parameter2 value	No	No
PVIPRM_PRM3_CODE	varchar(40)	NULL	Parameter3 code	No	No
PVIPRM_PRM3_VALUE	decimal(28,8)	NULL	Parameter3 value	No	No
PVIPRM_PRM4_CODE	varchar(40)	NULL	Parameter4 code	No	No
PVIPRM_PRM4_VALUE	decimal(28,8)	NULL	Parameter4 value	No	No
PVIPRM_PRM5_CODE	varchar(40)	NULL	Parameter5 code	No	No
PVIPRM_PRM5_VALUE	decimal(28,8)	NULL	Parameter5 value	No	No
PVIPRM_PRM6_CODE	varchar(40)	NULL	Parameter6 code	No	No
PVIPRM_PRM6_VALUE	decimal(28,8)	NULL	Parameter6 value	No	No
PVIPRM_PRM7_CODE	varchar(40)	NULL	Parameter7 code	No	No
PVIPRM_PRM7_VALUE	decimal(28,8)	NULL	Parameter7 value	No	No
PVIPRM_PRM8_CODE	varchar(40)	NULL	Parameter8 code	No	No
PVIPRM_PRM8_VALUE	decimal(28,8)	NULL	Parameter8 value	No	No
PVIPRM_PRM9_CODE	varchar(40)	NULL	Parameter9 code	No	No
PVIPRM_PRM9_VALUE	decimal(28,8)	NULL	Parameter9 value	No	No
PVIPRM_PRM10_CODE	varchar(40)	NULL	Parameter10 code	No	No
PVIPRM_PRM10_VALUE	decimal(28,8)	NULL	Parameter10 value	No	No
PVIPRM_AMEND_FLAG	varchar(5)	NULL	Amendment Flag	No	No
PVIPRM_OLD_TRANSACTION_DATE	sql_variant	NULL		No	No
PVIPRM_REMARKS	varchar(255)	NULL	Remarks	No	No

Table Name AC_PVNPRM_NON_INHRIT_PRM

Table Comment Non-Inhertiable parameters maintained here.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
PVNPRM_GUID	varchar(40)	NOT NULL	Guid	Yes	No
PVNPRM_OUINSTANCE	decimal(10)	NOT NULL	OU Instance	Yes	No
PVNPRM_USER	varchar(30)	NOT NULL	User Name	Yes	No
PVNPRM_LANGUAGE	decimal(10)	NOT NULL	Language ID	Yes	No
PVNPRM_SRCCOMPCODE	varchar(20)	NOT NULL	Component code	Yes	No
PVNPRM_SRCOUINSTANCE	decimal(10)	NOT NULL	OU Instance	Yes	No
PVNPRM_MAINTOBJECTTYPE	varchar(10)	NOT NULL	Maintenance object type	Yes	No
PVNPRM_ENTITY_OU	decimal(10)	NOT NULL	Entity OU	Yes	No
PVNPRM_AIRCRAFT_REG_NO	varchar(30)	NOT NULL	Aircraft registration number	Yes	No
PVNPRM_COMPONENT_ID	varchar(90)	NOT NULL	COMPONENT ID	Yes	No
PVNPRM_PRM_CODE	varchar(40)	NOT NULL	Parameter Code	Yes	No
PVNPRM_TRANSACTION_DATE	datetime	NOT NULL	Transaction Date	Yes	No
PVNPRM_POS_CODE	varchar(25)	NOT NULL	Position Code	Yes	No
PVNPRM_SRC_TRAN_NO	varchar(40)	NOT NULL	Source transaction number	Yes	No
PVNPRM_PRM_ATTR_TYPE	varchar(5)	NULL	Parameter Attribute type	No	No
PVNPRM_RC_PRM_VALUE	decimal(28,8)	NULL	Range Consumption parameter value	No	No
PVNPRM_TA_PRM_VALUE	varchar(32)	NULL	Technical Attribute parameter value	No	No
PVNPRM_RESET_FLAG	varchar(5)	NULL	Reset flag	No	No
PVNPRM_DELTA_NEW_FLAG	varchar(5)	NULL	Delta new flag	No	No
PVNPRM_SRC_TRANSACTION	varchar(25)	NULL	Source Transaction	No	No
PVNPRM_AMEND_FLAG	varchar(5)	NULL	Amendment Flag	No	No
PVNPRM_OLD_TRANSACTION_DATE	datetime	NULL		No	No

Table Name ac_quick_code

Table Comment User defined Quick Codes Master
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ac_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
ac_quick_code	varchar(25)	NOT NULL	Quick Code	Yes	No
ac_type	varchar(80)	NOT NULL	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	No
ac_description	varchar(80)	NOT NULL	Description	No	No
ac_status	varchar(15)	NOT NULL	Status - Can be A - Active or I - Inactive	No	No
ac_created_by	varchar(30)	NOT NULL	Created By	No	No
ac_modified_by	varchar(30)	NOT NULL	Modified By	No	No
ac_creationdate	datetime	NOT NULL	Creation Date	No	No
ac_modifieddate	datetime	NOT NULL	Last Modified date	No	No
ac_timestamp	numeric(10)	NOT NULL	Timestamp	No	No

Table Name ac_znd_zone_details

Table Comment Zone details table
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
znd_status	varchar(15)	NULL	status of the zone A - Active I - Inactive	No	No
znd_comments	varchar(255)	NULL	Comments	No	No
znd_category_up	varchar(255)	NULL	Category in Upper case	No	No
znd_category	varchar(255)	NULL	user defined zone category	No	No
znd_modifieddate	datetime	NULL	Last Modified Date	No	No
znd_createdby	varchar(30)	NULL	Created By	No	No
znd_creationdate	datetime	NULL	Creation Date	No	No
znd_modifiedby	varchar(30)	NULL	Last Modified by	No	No
znd_timestamp	numeric(10)	NULL	Timestamp	No	No
znd_zonecode	varchar(80)	NOT NULL	Aircraft zone code	Yes	No
ZND_MODEL_NO	varchar(20)	NOT NULL		Yes	No
znd_ouinstance	numeric(10)	NOT NULL	OUInstance	Yes	No
znd_description_up	varchar(255)	NULL	upper description of the zone	No	No
znd_description	varchar(255)	NULL	description of the zone		No
ZND_MODEL_OU	decimal(38)	NOT NULL		Yes	No
mdl_model_no	varchar(20)	NULL	Model of the Aircraft	No	Yes
mdl_ouinstance	numeric(10)	NULL	Ouinstance	No	Yes

Table Name cfg_cfgac_status_updtl

Table Comment This table is used to update the status
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
cfgac_ouinstance	int	NULL	ouinstance	No	No
cfgac_aircraft_code	sql_variant	NULL	Aircraft Code	No	No
cfgac_cmpid_code	sql_variant	NULL	Component Id Code	No	No
cfgfac_guid	varchar	NULL		No	No
cfgac_partno	varchar(40)	NULL	Part Number	No	No
cfgac_serialno	varchar(40)	NULL	Serial Number	No	No

Data Dictionary- Aircraft