Data Dictionary - Configuration

 

 
Table Name CFG_CAD_COMP_ATTACH_DTL

 

 
Table Comment Stores Component Attach Details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CAD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CAD_COMPONENT_ID varchar(90) NOT NULL The number identifying the child component that is attached to the position code Yes No

 

CAD_AIRCRAFT_REG_NO varchar(30) NULL Register No of the Aircraft to which the component is attached No No

 

CAD_PARENT_COMP_ID varchar(90) NULL The Number Identifying the Parent component No No

 

CAD_ROOT_NODE varchar(90) NULL Root Node in hierarchy No No

 

 
Table Name cfg_cbmeld_mdlcfg_mel_det

 

 
Table Comment Minimum equipment list for the Baselined Model Configuration is maintained

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbmdl_ouinstance decimal(10) NOT NULL OUInstance Yes Yes

 

CBMELD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CBMELD_MODEL_NO varchar(20) NOT NULL Aircraft Model No. Yes No

 

CBMELD_REVNO varchar(40) NOT NULL The revision number of the model configuration Yes No

 

cbmeld_level_code varchar(150) NOT NULL Level Code Yes No

 

CBMELD_MEL_ITEM_CODE varchar(30) NOT NULL Minimum Equipment List Item code Yes No

 

CBMELD_CONFIG_CLASS varchar(30) NOT NULL The configuration class of the aircraft model, from which the configuration details must be copied No No

 

cbmeld_pos_code varchar(25) NOT NULL Position Code which is a cdl No No

 

CBMELD_PART_NO varchar(40) NOT NULL Part no No No

 

cbmeld_condition sql_variant NULL Condition of the part No No

 

cbmeld_maint_implication varchar(255) NULL Maintenance Implications if any No No

 

cbmeld_oper_implication varchar(255) NULL Operational Implications if any No No

 

cbmeld_conditional_flag varchar(25) NULL Conditional Flag No No

 

cbmeld_mel_flag varchar(25) NULL MEL Flag No No

 

cbmeld_level_no varchar(150) NULL Level Number No No

 

cbmeld_nha_no varchar(40) NULL Next Higher Assembly No No

 

cbmeld_placard varchar(5) NULL Placard N- Not Required R- Required No No

 

cbmeld_placard_inst varchar(2000) NULL Placard Instructions No No

 

cbmeld_deferral_task varchar(30) NULL The task type which to be deferred No No

 

cbmelD_deferral_rev_task varchar(40) NULL Deferral Task Revision No No No

 

 
Table Name CFG_CFBAC_AIRCRAFT_CONFIG

 

 
Table Comment Stores Aircraft-Model-Configuration class Details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBAC_AIRCRAFT_REG_NO varchar(30) NOT NULL The aircraft model for which the configuration details must be entered Yes No

 

CFBAC_REVNO varchar(40) NOT NULL The revision number of the model configuration. Yes No

 

CFBAC_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBAC_CONFIG_CLASS varchar(30) NOT NULL The configuration class of the aircraft model No No

 

CFBAC_MODEL_OU decimal(10) NULL ouinstance No No

 

CFBAC_MODEL_NO varchar(20) NULL The aircraft model, the configuration details of which are to be copied into the model configuration No No

 

CFBAC_STATUS varchar(15) NOT NULL Status , Fresh,Active,Cancel No No

 

CFBAC_CREATED_BY varchar(30) NULL Created by user No No

 

CFBAC_MODIFIED_BY varchar(30) NULL Modified by the user No No

 

CFBAC_APPROVED_BY varchar(30) NULL Approved by the user No No

 

CFBAC_APPROVEDDATE datetime NULL Approved Date No No

 

CFBAC_CREATIONDATE datetime NULL Creation date No No

 

CFBAC_MODIFIEDDATE datetime NULL Modified Date No No

 

 
Table Name cfg_cfbacd_ac_config_dtl

 

 
Table Comment Position Codes and their associated parts for a baselined aircraft configuration is maintained here
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBACD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBACD_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No. Yes No

 

CFBACD_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfbacd_pos_code varchar(25) NOT NULL The position code where the rotable can be fitted Yes No

 

cfbacd_pos_part_no varchar(40) NULL Part number associated with the position code No No

 

cfbacd_pos_status varchar(15) NULL Position Status. Can be either A - Active or I - Inactive. No No

 

cfbacd_pos_type varchar(25) NULL Position Type. Can be either ’Engine’, ’APU’,’Landing Gear’ or  ’Others’ E - Engine A - APU O - Others L - Landing Gear No No

 

cfbacd_rot_man_flag varchar(25) NULL Rotable Mandatory Flag indicates if a rotatable is mandatory or not. Can take values ’Yes’ or ’No’ Y - Yes N - No No No

 

cfbacd_zonecode varchar(15) NULL Zone code. Place where the position is located in the Aircraft No No

 

cfbacd_ata_no varchar(16) NULL Air Traffic Association Chapter number No No

 

cfbacd_drawing_id varchar(40) NULL Drawing Id No No

 

cfbacd_doc_path varchar(50) NULL Document Path where the drawing is available No No

 

cfbacd_level_no varchar(150) NULL This indicates the level in which the position codes exists No No

 

cfbacd_level_code varchar(150) NULL System generated code for the various positions in the hierarchy No No

 

cfbacd_component_id varchar(90) NULL Component ID No No

 

cfbacd_serial_no varchar(40) NULL Serial Number No No

 

cfbacd_date_of_attach datetime NULL Date of Attachment No No

 

cfbacd_time_of_attach datetime NULL Time of Attachment No No

 

cfbacd_pos_part_ou numeric(10) NULL OUInstance of the Position Part Number No No

 

cfbacd_component_revno varchar(40) NULL Component Revision Number No No

 

cfbacd_comp_condition varchar(5) NULL Component Condition NW - New OVH - Over Hauled PO - Phased Out SER - Serviceable USR - Un-Serviceable No No

 

cfbacd_from_date datetime NULL From Date No No

 

CFBACD_BODY_STATION_NO varchar(15) NULL body station No No

 

cfbacd_seq_no numeric(10) NULL Sequence Number No No

 

cfbacd_cargo_flag varchar(5) NULL Cargo Flag No No

 

cfbacd_rvsm_flag varchar(5) NULL RVSM Flag No No

 

cfbacd_link_flag varchar(75) NULL Link Flag Info No No

 

cfbacd_disp_seq_no decimal(10) NULL Disp Sequence Number No No

 

cfbacd_attach_status varchar(5) NULL Attachment Status No No

 

CFBACD_REMARKS sql_variant NULL CFBACD_REMARKS No No

 

CFBACD_REMARKS_ID sql_variant NULL CFBACD_REMARKS_ID No No

 

 
Table Name cfg_cfbacn_ac_config_notes

 

 
Table Comment Notes related to the Baselined Aircraft Configuration is maintained

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBACN_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBACN_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No. Yes No

 

CFBACN_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfbacn_notes varchar(2000) NULL Notes No No

 

 
Table Name cfg_cfbaic_cfgac_intchg_rule

 

 
Table Comment This table maintains the interchangeability rules related to the various position odes in the tree for an baselined aircraft configuration

 

Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbaic_order_of_pref numeric(10) NULL Order of preference of the interchangeable part No No

 

cfbaic_config_class varchar(30) NULL Configuration Class No No

 

cfbaic_interchange_part varchar(40) NOT NULL Part number that can be an alternative to the part number defined for the position Yes No

 

cfbaic_mod_status varchar(15) NULL Mod Status gives the document number which has authorized the interchange No No

 

CFBAIC_REMARKS sql_variant NULL CFBAIC_REMARKS No No

 

CFBAIC_REMARKS_ID sql_variant NULL CFBAIC_REMARKS_ID No No

 

CFBAIC_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No. Yes No

 

CFBAIC_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfbaic_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

CFBAIC_POS_CODE varchar(25) NOT NULL The code identifying the position in the component displayed in the “Component Details” Yes No

 

CFBAIC_REVNO varchar(40) NOT NULL The revision number of the model configuration Yes No

 

cfbaic_level_code varchar(150) NOT NULL Level Code Yes No

 

 
Table Name cfg_cfbaix_cfgac_intmx_rule

 

 
Table Comment This table maintains the intermixing rules for an baselined Aircraft Configuration.

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbaix_level_no varchar(150) NULL Level Number No No

 

cfbaix_dep_pos_code varchar(25) NOT NULL Dependent Position Code No No

 

cfbaix_dep_level_code varchar(150) NOT NULL Dependent Level Code Yes No

 

CFBAIX_REMARKS sql_variant NULL CFBAIX_REMARKS No No

 

cfbaix_dep_part_no varchar(40) NULL Part number associated with the dependent position code No No

 

cfbaix_rev_flag varchar(25) NULL Reversible Flag. Can be either ’Yes’ or ’No’ No No

 

CFBAIX_REMARKS_ID sql_variant NULL CFBAIX_REMARKS_ID No No

 

CFBAIX_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No. Yes No

 

CFBAIX_REVNO varchar(40) NOT NULL The revision number of the component configuration Yes No

 

CFBAIX_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfbaix_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

CFBAIX_POS_CODE varchar(25) NOT NULL The code identifying the position in the component Yes No

 

cfbaix_config_class varchar(30) NOT NULL Configuration Class Yes No

 

cfbaix_level_code varchar(150) NOT NULL Level Code Yes No

 

 
Table Name cfg_cfbatw_cfgac_etop_twnps

 

 
Table Comment This table maintains the various etop twin positions for the baselined Aircraft Configuration

 

Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbatw_twin_level_code varchar(150) NOT NULL Etop Twin Level Code Yes No

 

cfbatw_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

cfbatw_twin_pos_code varchar(25) NOT NULL Twin position code No No

 

cfbatw_config_class varchar(30) NULL Configuration Class No No

 

cfbatw_twin_part_no varchar(40) NULL Part number associated with the twin position code No No

 

CFBATW_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No Yes No

 

CFBATW_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBATW_POS_CODE varchar(25) NOT NULL The code identifying the position in the component Yes No

 

CFBATW_REVNO varchar(40) NOT NULL Revision no of the component Configuration Yes No

 

cfbatw_level_code varchar(150) NOT NULL Level Code Yes No

 

 
Table Name cfg_cfbcmd_cmp_config_dtl

 

 
Table Comment This definition of the various position codes and their level for a baselined component configuration are 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

 

CFBCMD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBCMD_COMPONENTID varchar(90) NOT NULL Component Id Yes No

 

CFBCMD_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfbcmd_pos_code varchar(25) NOT NULL Position code associated with the component Yes No

 

cfbcmd_root_node varchar(90) NOT NULL Root Node Yes No

 

cfbcmd_root_revno varchar(40) NOT NULL Root Revision Number Yes No

 

cfbcmd_pos_part_no varchar(40) NULL part associated to the position code No No

 

cfbcmd_pos_part_ou numeric(10) NULL OUInstance of the Position Part Number No No

 

cfbcmd_nha varchar(40) NULL Next Higher Assembly No No

 

cfbcmd_nha_revno varchar(40) NULL NHA Revision Number No No

 

cfbcmd_rot_man_flag varchar(25) NULL This flag indicates if a rotable should always exists in the position code No No

 

cfbcmd_pos_type varchar(25) NULL Type of the position code. Can be Engine’, ’APU’,’Landing Gear’ or ’Others’ E - Engine A - APU L - Landing Gear O - Others No No

 

cfbcmd_drawing_id varchar(40) NULL Drawing Id No No

 

cfbcmd_doc_path varchar(50) NULL Path in which the Drawing exists No No

 

cfbcmd_level_code varchar(150) NULL Unique identifier for each node in the configuration No No

 

cfbcmd_level_no varchar(150) NULL level number of the node No No

 

cfbcmd_zonecode varchar(15) NULL zone code No No

 

cfbcmd_ata_no varchar(30) NULL ATA Chapter number No No

 

cfbcmd_rot_comp varchar(90) NULL Rotable Component No No

 

cfbcmd_rot_revno varchar(40) NULL Rotable Revision Number No No

 

cfbcmd_rot_serial_no varchar(40) NULL Rotable Serial Number No No

 

cfbcmd_date_of_attach datetime NULL Date of Attachment No No

 

cfbcmd_time_of_attach datetime NULL Time of Attachment No No

 

cfbcmd_child_exists_flag varchar(25) NULL Flag for the existence of child level Y - Child exists N - Child doesn't exists No No

 

cfbcmd_pos_status varchar(15) NULL Position Status A - Active I - Inactive No No

 

cfbcmd_comp_condition varchar(5) NULL Component Condition NW - New OVH - Over Hauled PO - Phased Out SER - Serviceable USR - Un-Serviceable No No

 

cfbcmd_from_date datetime NULL Component Effective From Date No No

 

cfbcmd_disp_seq_no decimal(10) NULL Display Sequence Number No No

 

cfbcmd_attach_status varchar(5) NULL Attachment Status No No

 

CFBCMD_REMARKS sql_variant NULL CFBCMD_REMARKS No No

 

CFBCMD_REMARKS_ID sql_variant NULL CFBCMD_REMARKS_ID No No

 

 
Table Name cfg_cfbcmp_comp_config

 

 
Table Comment Baselined Component Configuration is maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbcmp_ouinstance decimal(10) NOT NULL OUIstance Yes No

 

cfbcmp_componentid varchar(90) NOT NULL Component Id Yes No

 

cfbcmp_revno varchar(40) NOT NULL Revision number of the component configuration Yes No

 

cfbcmp_status varchar(15) NOT NULL Status of the Configuration. Can be either ’Fresh’, ’Active’, ’Revised’ or ’Cancelled’ A - Active C - Cancelled F - Fresh No No

 

cfbcmp_approved_by varchar(30) NULL Approver No No

 

cfbcmp_approveddate datetime NULL Approval Date No No

 

cfbcmp_created_by varchar(30) NULL Created By No No

 

cfbcmp_creationdate datetime NULL Configuration Creation Date No No

 

cfbcmp_modified_by varchar(30) NULL Last Modified By No No

 

cfbcmp_modifieddate datetime NULL Last Modified Date No No

 

cfbcmp_comments varchar(255) NULL Comments No No

 

cfbcmp_componentid_status varchar(15) NULL Status of the Component ID A - Active I - Inactive No No

 

 
Table Name cfg_cfbcnt_cmp_config_notes

 

 
Table Comment Notes for Baselined component Configuration is maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBCNT_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBCNT_COMPONENTID varchar(90) NOT NULL Component Id Yes No

 

CFBCNT_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfbcnt_notes varchar(2000) NULL Notes No No

 

 
Table Name cfg_cfbmcd_mdl_config_cdl

 

 
Table Comment Component Deviation List for Baselined Model Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbmcd_cdl_qty numeric(28,8) NULL CDL Quantity No No

 

cfbmcd_cdl_min_qty numeric(28,8) NULL CDL Minimum Quantity No No

 

cfbmcd_cdl_item_desc varchar(150) NULL CDL Item Description No No

 

cfbmcd_cdl_remarks varchar(255) NULL Remarks No No

 

cfbmcd_deferral_task varchar(30) NULL Deferral Task code No No

 

cfbmcd_cdl_item_status varchar(15) NULL CDL Item Status A - Active I - Inactive No No

 

cfbmcd_placard_inst varchar(2000) NULL Placard Instructions No No

 

cfbmcd_placard varchar(5) NULL Placard R-Required N-NotRequired No No

 

cfbmcd_deferral_rev_task varchar(40) NULL Deferral Task Revision No No No

 

CFBMCD_CONFIG_CLASS varchar(30) NOT NULL Configuration class Yes No

 

CFBMCD_REVNO varchar(40) NOT NULL Revision NO Yes No

 

CFBMCD_MODEL_NO varchar(20) NOT NULL Model No Yes No

 

CFBMCD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfbmcd_oper_implication varchar(255) NULL Operational Implications if any No No

 

cfbmcd_maint_implication varchar(255) NULL Maintenance Implications if any No No

 

cfbmcd_cdl_item_code varchar(30) NOT NULL CDL Item Code Yes No

 

cfbmcd_part_ou numeric(10) NULL OUInstance of the Part Number No No

 

cfbmcd_part_no varchar(40) NULL Part Number which is a CDL No No

 

 
Table Name cfg_cfbmdl_Model_config

 

 
Table Comment Baselined Model Configuration details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbmdl_ouinstance decimal(10) NOT NULL OUInstance Yes No

 

cfbmdl_model_no varchar(20) NOT NULL Model Yes No

 

cfbmdl_config_class varchar(30) NOT NULL Configuration Class Name Yes No

 

cfbmdl_revno varchar(40) NOT NULL revision number Yes No

 

cfbmdl_model_ou decimal(10) NULL OU of the Model No No

 

cfbmdl_status varchar(15) NULL Status of the configuration. Can be active or fresh or revised or cancelled A - Active C - Cancelled F - Fresh No No

 

cfbmdl_created_by varchar(30) NULL created by No No

 

cfbmdl_creationdate datetime NULL creation date No No

 

cfbmdl_approved_by varchar(30) NULL Approver No No

 

cfbmdl_approveddate datetime NULL Approved Date No No

 

cfbmdl_modifieddate datetime NULL Last Modified Date No No

 

cfbmdl_modified_by varchar(30) NULL Last Modified By No No

 

cfbmdl_comments varchar(255) NULL Comments No No

 

 
Table Name cfg_cfbmdt_mdl_config_dtl

 

 
Table Comment Position code details for the Baselined Model Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBMDT_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBMDT_MODEL_NO varchar(20) NOT NULL Model No Yes No

 

CFBMDT_CONFIG_CLASS varchar(30) NOT NULL Configuration Class Yes No

 

CFBMDT_REVNO varchar(40) NOT NULL Revision No Yes No

 

cfbmdt_pos_code varchar(25) NOT NULL Position Code Yes No

 

cfbmdt_pos_part_no varchar(40) NULL Part number associated with the position code No No

 

cfbmdt_pos_part_ou numeric(10) NULL OUInstance of the Position Part Number No No

 

cfbmdt_pos_status varchar(15) NULL Status of the position code. Can be A - Active or I - Inactive No No

 

cfbmdt_pos_type varchar(5) NULL Position Code type . Can be ’Engine’, ’APU’,’Landing Gear’ or ’Others’ A - Apu E - Engine L - Landing Gear O - Others No No

 

cfbmdt_rot_man_flag varchar(25) NULL Indicates if a rotable is mandatory in the position code defined. No No

 

cfbmdt_cargo_flag varchar(25) NULL Indicates if the configuration is applicable for cargo planes No No

 

cfbmdt_rvsm_flag varchar(25) NULL RVSM Flag No No

 

cfbmdt_zonecode varchar(15) NULL Zone no No No

 

cfbmdt_body_station_no varchar(15) NULL Body Station no No No

 

cfbmdt_ata_no varchar(16) NULL ATA chapter no No No

 

cfbmdt_drawing_no varchar(40) NULL Drawing no No No

 

cfbmdt_doc_path varchar(50) NULL path where the document is available. No No

 

cfbmdt_level_no varchar(150) NULL level number of the position code No No

 

cfbmdt_level_code varchar(150) NULL unique identifier for the position code in the structure of configuration No No

 

cfbmdt_no_of_eng numeric(10) NULL no of engines No No

 

cfbmdt_no_of_apus numeric(10) NULL no of auxiliary power units No No

 

cfbmdt_pos_part_revno varchar(40) NULL Position Part Revision Number No No

 

cfbmdt_mel_flag varchar(25) NULL MEL Flag No No

 

CFBMDT_SEQ_NO decimal(10) NULL sequence no No No

 

CFBMDT_LINK_INFO varchar(25) NULL Link_info No No

 

CFBMDT_DISP_SEQ_NO decimal(10) NULL Display sequence No. No No

 

CFBMDT_REMARKS sql_variant NULL CFBMDT_REMARKS No No

 

CFBMDT_REMARKS_ID sql_variant NULL CFBMDT_REMARKS_ID No No

 

 
Table Name cfg_cfbmel_mdl_config_mel

 

 
Table Comment Baselined Minimum equipment list for the model configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBMEL_OUINSTANCE decimal(10) NOT NULL OuInstance Yes No

 

CFBMEL_MODEL_NO varchar(20) NOT NULL Aircraft Model No Yes No

 

CFBMEL_CONFIG_CLASS varchar(30) NOT NULL configuration Class to which the Aircraft belongs Yes No

 

CFBMEL_REVNO varchar(40) NOT NULL The revision number of the model configuration Yes No

 

cfbmel_mel_item_code varchar(30) NOT NULL The number identifying the MEL item for which the position details must be defined. Yes No

 

cfbmel_part_no varchar(40) NULL part number No No

 

cfbmel_condition_flag varchar(25) NULL condition flag. No No

 

cfbmel_conditions sql_variant NULL conditions if any No No

 

cfbmel_mel_qty numeric(28,8) NULL MEL quantity No No

 

cfbmel_maint_implication varchar(255) NULL Maintenance Implications if any No No

 

cfbmel_oper_implication varchar(255) NULL Operational Implications if any No No

 

cfbmel_pos_based_flag varchar(25) NULL Position Based Flag No No

 

cfbmel_part_ou numeric(10) NULL OUInstance of the Part Number No No

 

cfbmel_mel_item_desc varchar(150) NULL MEL Item Description No No

 

cfbmel_category varchar(30) NULL MEL Category No No

 

cfbmel_min_mel_qty numeric(28,8) NULL Minimum MEL Quantity No No

 

cfbmel_mel_item_status varchar(5) NULL MEL Item Status A - Active I - Inactive No No

 

cfbmel_placard varchar(5) NULL Placard N- Not Required R- Required No No

 

cfbmel_placard_inst varchar(2000) NULL Placard Instructions No No

 

cfbmel_deferral_task varchar(30) NULL Deferral Task No No

 

cfbmel_deferral_rev_task varchar(40) NULL Deferral Revision No. No No

 

 
Table Name cfg_cfbmic_mdlcfg_intchge_rule

 

 
Table Comment Interchangeable rules for the Model - Baselined versions alone

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBMIC_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBMIC_MODEL_NO varchar(20) NOT NULL Model No Yes No

 

CFBMIC_CONFIG_CLASS varchar(30) NOT NULL Configuration Class Yes No

 

CFBMIC_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfbmic_level_code varchar(150) NOT NULL Level Code Yes No

 

CFBMIC_POS_CODE varchar(25) NOT NULL Position Code Yes No

 

cfbmic_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

cfbmic_interchange_part varchar(40) NOT NULL Interchangeable part for the position Yes No

 

cfbmic_order_of_pref numeric(10) NULL Order of preference No No

 

cfbmic_mod_status varchar(15) NULL document number which authorizes the interchangeability No No

 

CFBMIC_REMARKS sql_variant NULL CFBMIC_REMARKS No No

 

CFBMIC_REMARKS_ID sql_variant NULL CFBMIC_REMARKS_ID No No

 

 
Table Name cfg_cfbmix_mdlcfg_intmx_rule

 

 
Table Comment Intermixing Rules for Model position codes - Baselined versions alone

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbmdl_revno varchar(40) NOT NULL revision number Yes Yes

 

CFBMIX_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBMIX_MODEL_NO varchar(20) NOT NULL Model_no Yes No

 

CFBMIX_CONFIG_CLASS varchar(30) NOT NULL Configuration Class Yes No

 

CFBMIX_REVNO varchar(40) NOT NULL Revision no Yes No

 

cfbmix_level_code varchar(150) NOT NULL Level Code Yes No

 

CFBMIX_POS_CODE varchar(25) NOT NULL Position code Yes No

 

cfbmix_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

cfbmix_dep_level_code varchar(150) NOT NULL Dependent Level Code Yes No

 

cfbmix_dep_pos_code varchar(25) NOT NULL Dependent position code No No

 

cfbmix_dep_part_no varchar(40) NULL Part number attached to the dependent position code No No

 

cfbmix_rev_flag varchar(25) NULL Reversible Flag No No

 

CFBMIX_REMARKS sql_variant NULL CFBMIX_REMARKS No No

 

CFBMIX_REMARKS_ID sql_variant NULL CFBMIX_REMARKS_ID No No

 

 
Table Name CFG_CFBMLK_MODEL_LINK_INFO

 

 
Table Comment Indicates whether the interchangeability rules, intermixing rules and ETOP twin position rules have been entered for the position. The system displays one of the following options:

 

Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBMLK_MODEL_NO varchar(20) NOT NULL Aircraft Model No. Yes No

 

CFBMLK_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBMLK_REV_NO varchar(40) NOT NULL configuration Revision No. Yes No

 

CFBMLK_LEVEL_CODE varchar(150) NOT NULL Level code Yes No

 

CFBMLK_CONFIG_CLASS varchar(30) NOT NULL Configuration class Yes No

 

CFBMLK_POS_CODE varchar(25) NOT NULL Position code No No

 

CFBMLK_PART_NO varchar(40) NOT NULL Part No. No No

 

CFBMLK_CHILD_LEVEL_NO decimal(10) NOT NULL Child Level No. No No

 

CFBMLK_ZONE_CODE varchar(15) NULL The zone associated to the position code No No

 

CFBMLK_ATA_NO varchar(16) NULL The ATA chapter for which the position code details are to be retrieved No No

 

CFBMLK_BODY_STATION varchar(15) NULL Body Station No No

 

CFBMLK_CARGO_FLAG varchar(25) NULL the position code is in the cargo aircraft No No

 

CFBMLK_RVSM_FLAG varchar(15) NULL reduced vertical separation minimum l list flag No No

 

CFBMLK_LINK_FLAG varchar(15) NULL Link flag No No

 

CFBMLK_NHA varchar(40) NULL Next higher Assembly No No

 

 
Table Name cfg_cfbmnt_mdlcfg_notes

 

 
Table Comment This table maintains the notes for Baselined Model configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBMNT_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBMNT_MODEL_NO varchar(20) NOT NULL Model No. Yes No

 

CFBMNT_CONFIG_CLASS varchar(30) NOT NULL Configuration Class Yes No

 

CFBMNT_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfbmnt_notes varchar(2000) NULL Notes No No

 

 
Table Name cfg_cfbmtw_mdlcfg_etop_twnps

 

 
Table Comment ETop Twin positions for Baselined Model Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbmtw_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

CFBMTW_POS_CODE varchar(25) NOT NULL Position code Yes No

 

cfbmtw_twin_level_code varchar(150) NOT NULL Etop Twin Level Code Yes No

 

cfbmtw_twin_pos_code varchar(25) NOT NULL Twin Position Code No No

 

cfbmtw_twin_part_no varchar(40) NULL Part Number associated with the twin position code No No

 

CFBMTW_MODEL_NO varchar(20) NOT NULL Model No Yes No

 

CFBMTW_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfbmtw_level_code varchar(150) NOT NULL Level Code Yes No

 

CFBMTW_CONFIG_CLASS varchar(30) NOT NULL Configuration class Yes No

 

CFBMTW_REVNO varchar(40) NOT NULL Revision Number Yes No

 

 
Table Name cfg_cfbpnt_part_notes

 

 
Table Comment Baselined Part Configuration - Notes Details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBPNT_REV_NO varchar(40) NOT NULL Revision No Yes No

 

cfbpnt_notes varchar(2000) NULL Notes No No

 

CFBPNT_PART_NO varchar(40) NOT NULL Baselined Part No Yes No

 

CFBPNT_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

 
Table Name cfg_cfbpt_part_config

 

 
Table Comment Baselined Part Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfbpt_ouinstance numeric(10) NOT NULL OUInstance Yes No

 

cfbpt_part_no varchar(40) NOT NULL Part Number Yes No

 

cfbpt_rev_no varchar(40) NOT NULL Revision Number Yes No

 

cfbpt_status varchar(15) NULL Status of Part Configuration A - Active I - Inactive No No

 

cfbpt_no_of_engines numeric(10) NULL Number of Engines No No

 

cfbpt_no_of_apus numeric(10) NULL Number of APUs No No

 

cfbpt_created_by varchar(30) NULL Created By No No

 

cfbpt_createddate datetime NULL Created Date No No

 

cfbpt_approved_by varchar(30) NULL Approved By No No

 

cfbpt_approveddate datetime NULL Approved Date No No

 

cfbpt_modified_by varchar(30) NULL Last Modified By No No

 

cfbpt_modifieddate datetime NULL Last Modified Date No No

 

cfbpt_ac_part_ou numeric(10) NULL OUInstance of Aircraft Part Number No No

 

cfbpt_comments varchar(255) NULL Comments No No

 

cfbpt_baselined_flag varchar(25) NULL BaseLined Flag Y - Yes N - No No No

 

cfbpt_inherit_chgs_flag varchar(25) NULL Inherit Change Flag Y - Yes N - No No No

 

 
Table Name cfg_cfbptt_part_config_dtl

 

 
Table Comment Baselined Part Configuration Position code details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFBPTT_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFBPTT_PART_NO varchar(40) NOT NULL Part No Yes No

 

CFBPTT_REV_NO varchar(40) NOT NULL Revision No Yes No

 

cfbptt_pos_code varchar(25) NOT NULL Position Code Yes No

 

cfbptt_pos_part_no varchar(40) NOT NULL associated part number No No

 

cfbptt_pos_status varchar(15) NULL position status A - Active I - Inactive No No

 

cfbptt_pos_type varchar(25) NULL position type.Can be  ’Engine’, ’APU’,’Landing Gear’ or  ’Others’ A - Apu E - Engine L - Landing Gear O - Others No No

 

cfbptt_rvsm_flag varchar(25) NULL RVSM Flag - Yes or No No No

 

cfbptt_cargo_flag varchar(25) NULL Cargo Flag Yes or No No No

 

cfbptt_ata_no varchar(16) NULL ATA Chapter Number No No

 

cfbptt_drawing_no varchar(40) NULL Drawing Number No No

 

cfbptt_doc_path varchar(50) NULL Document Path No No

 

cfbptt_child_exists_flag varchar(25) NULL Indicates if the node has children Y - Yes N - No No No

 

cfbptt_rot_man_flag varchar(25) NULL Rotable Mandatory flag No No

 

cfbptt_pos_rev_no varchar(40) NULL Revision Number of the Position part number No No

 

cfbptt_pos_part_ou numeric(10) NULL OUInstance of the position part number No No

 

cfbptt_zonecode varchar(10) NULL Zone code No No

 

cfbptt_part_seqno numeric(10) NULL Sequence Number No No

 

CFBPTT_DISP_SEQ_NO decimal(10) NULL Display sequence No. No No

 

CFBPTT_REMARKS sql_variant NULL CFBPTT_REMARKS No No

 

CFBPTT_REMARKS_ID sql_variant NULL CFBPTT_REMARKS_ID No No

 

 
Table Name cfg_cfgac_Aircraft_config

 

 
Table Comment Aircraft Configuration Details are maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgac_creationdate datetime NULL Creation Date No No

 

cfgac_timestamp decimal(10) NULL Timestamp No No

 

cfgac_approveddate datetime NULL Approved Date No No

 

cfgac_approved_by varchar(30) NULL Approved By No No

 

cfgac_modified_by varchar(30) NULL Last Modified By No No

 

cfgac_mismatch_flag varchar(25) NULL Mismatch Flag No No

 

CFGAC_FILE_NAME varchar(50) NULL File Name No No

 

cfgac_modifieddate datetime NULL Last Modified Date No No

 

cfgac_baselined_flag varchar(25) NULL Base Lined Flag No No

 

cfgac_comments varchar(255) NULL Comments No No

 

CFGAC_INIT_FILENAME varchar(50) NULL Initial file name No No

 

cfgac_revno varchar(40) NOT NULL Revision Number of the configuration Yes No

 

cfgac_status varchar(15) NOT NULL Status of the Configuration. Can be either ’Fresh’, ’Active’,’Revised’ or ’Cancelled’ A - Active C - Cancelled F - Fresh Yes No

 

cfgac_aircraft_reg_no varchar(30) NOT NULL Aircraft Registration Number Yes No

 

CFGAC_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfgac_created_by varchar(30) NULL Created By No No

 

cfgac_model_no varchar(20) NULL Model Number No No

 

CFGAC_CONFIG_CLASS varchar(30) NULL Configuration Class No No

 

cfgcl_ouinstance decimal(10) NULL OUInstance No Yes

 

cfgac_aircraft_ou decimal(10) NULL OUInstance of Aircraft registration Number No No

 

cfgcl_config_class varchar(30) NULL Configuration Class Name No Yes

 

 
Table Name cfg_cfgacd_ac_config_dtl

 

 
Table Comment Position Codes and their associated parts for a aircraft configuration is maintained here. Readiness log details like component Id and serial number details for all the parts in the aircraft are also maintained here

 

Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGACD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGACD_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No Yes No

 

CFGACD_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfgacd_pos_code varchar(25) NOT NULL Position Code Yes No

 

cfgacd_pos_part_no varchar(40) NULL Part number associated with the position code No No

 

cfgacd_pos_status varchar(15) NULL Position Status. Can be either Active or Inactive. A - Active I - Inactive No No

 

cfgacd_pos_type varchar(25) NULL Position Type. Can be either ’Engine’, ’APU’,’Landing Gear’ or  ’Others’ A - Apu E - Engine L - Landing Gear O - Others No No

 

cfgacd_rot_man_flag varchar(25) NULL Rotable Mandatory Flag indicates if a rotatable is mandatory or not. Can take values ’Yes’ or ’No’ Y - Yes N - No No No

 

cfgacd_zonecode varchar(15) NULL Zone code. Place where the position is located in the Aircraft No No

 

cfgacd_ata_no varchar(30) NULL Air Traffic Association Chapter number No No

 

cfgacd_drawing_id varchar(40) NULL Drawing Id No No

 

cfgacd_doc_path varchar(50) NULL Document Path where the drawing is available No No

 

cfgacd_level_no varchar(150) NULL This indicates the level in which the position codes exists No No

 

cfgacd_level_code varchar(150) NULL System generated code for the various positions in the hierarchy No No

 

cfgacd_date_of_attach datetime NULL Date of Attachment No No

 

cfgacd_time_of_attach datetime NULL Time of Attachment No No

 

cfgacd_component_id varchar(90) NULL Component ID No No

 

cfgacd_serial_no varchar(40) NULL Serial Number No No

 

cfgacd_pos_part_ou numeric(10) NULL OUInstance of the Position Part Number No No

 

cfgacd_comp_condition varchar(5) NULL Component Condition NW - New OVH - Over Hauled PO - Phased Out SER - Serviceable USR - Un-Serviceable No No

 

cfgacd_from_date datetime NULL Component Effective From Date No No

 

cfgacd_body_station_no varchar(15) NULL Body Station No No

 

cfgacd_seq_no numeric(10) NULL Sequence No No No

 

cfgacd_cargo_flag varchar(5) NULL Cargo Flag No No

 

cfgacd_rvsm_flag varchar(5) NULL RVSM Flag No No

 

cfgacd_link_flag varchar(75) NULL Link Information No No

 

CFGACD_INDUCTION_DATE datetime NULL induction date No No

 

CFGACD_OPERATION_DATE datetime NULL operation date No No

 

CFGACD_ATTACH_ROT_FLAG varchar(25) NULL rotable attachment flag No No

 

cfgacd_comp_part_no varchar(40) NULL Part No of the attached component. No No

 

cfgacd_comp_part_ou numeric(10,2) NULL Ou insance of the part no of the attached component. No No

 

CFGACD_DISP_SEQ_NO decimal(10) NULL Display Sequence Number No No

 

cfgacd_attach_status varchar(5) NULL Attachment Status No No

 

CFGACD_REMARKS sql_variant NULL CFGACD_REMARKS No No

 

CFGACD_REMARKS_ID sql_variant NULL CFGACD_REMARKS_ID No No

 

 
Table Name cfg_cfgach_achistory_log

 

 
Table Comment Aircraft History Log Table

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgach_ouinstance numeric(28) NOT NULL OUInstance Yes No

 

cfgach_component_id varchar(90) NOT NULL Component ID Yes No

 

cfgach_eff_from_date datetime NOT NULL Effective Attachment date Yes No

 

cfgach_component_ou numeric(10) NULL OUInstance of the Component No No

 

cfgach_aircraft_ou numeric(10) NULL OUInstance of the Aircraft reg No. No No

 

cfgach_aircraft_reg_no varchar(30) NULL Aircraft Reg No No No

 

cfgach_pos_code varchar(25) NULL Position Code No No

 

cfgach_pos_type varchar(5) NULL Position Type A - Apu E - Engine L - Landing Gear O - Others No No

 

cfgach_parent_component_ou numeric(10) NULL OUInstance of the parent component ID No No

 

cfgach_parent_component_id varchar(90) NULL Parent Component ID No No

 

cfgach_eff_to_date datetime NULL Effective Removal Date No No

 

cfgach_level_code varchar(150) NULL Level Code No No

 

cfgach_level_no numeric(28) NULL Level No No No

 

cfgach_createdby varchar(30) NULL Created User No No

 

cfgach_createddate datetime NULL Created Date No No

 

 
Table Name cfg_cfgacn_ac_config_notes

 

 
Table Comment Notes related to the Aircraft Configuration is maintained

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGACN_OUINSTANCE decimal(10) NOT NULL OU instance Yes No

 

CFGACN_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration number Yes No

 

CFGACN_REVNO varchar(40) NOT NULL Revision Number Yes No

 

cfgacn_notes varchar(2000) NULL Notes No No

 

 
Table Name CFG_CFGAEO_AC_EO_LIST

 

 
Table Comment Aircraft Registration change option association with Engineering Order Component

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGAEO_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration Number Yes No

 

CFGAEO_REV_NO varchar(40) NOT NULL Revision Number Yes No

 

CFGAEO_EO_NO varchar(40) NOT NULL Engineering Order Number Yes No

 

CFGAEO_OUINSTANCE decimal(10) NOT NULL OU Instance Yes No

 

CFGAEO_RELEASED_DATE datetime NULL Released Date No No

 

CFGAEO_COMPLIED_DATE datetime NULL Compiled Date No No

 

 
Table Name cfg_cfgaic_cfgac_intchg_rule

 

 
Table Comment This table maintains the interchangeability rules related to the various position codes in the tree for an aircraft configuration

 

Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgaic_order_of_pref numeric(10) NULL Order of preference of the interchangeable part No No

 

cfgaic_interchange_part varchar(40) NOT NULL Part number that can be an alternative to the part number defined for the position Yes No

 

cfgaic_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

cfgaic_mod_status varchar(15) NULL Mod Status gives the document number which has authorized the interchange No No

 

CFGAIC_REMARKS sql_variant NULL CFGAIC_REMARKS No No

 

CFGAIC_REMARKS_ID sql_variant NULL CFGAIC_REMARKS_ID No No

 

CFGAIC_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No. Yes No

 

CFGAIC_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGAIC_POS_CODE varchar(25) NOT NULL The position code retrieved by the system Yes No

 

CFGAIC_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfgaic_level_code varchar(150) NOT NULL Level Code Yes No

 

 
Table Name cfg_cfgaix_cfgac_intmx_rule

 

 
Table Comment This table maintains the intermixing rules for an Aircraft Configuration.

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgaix_dep_part_no varchar(40) NULL Part number associated with the dependent position code No No

 

cfgaix_dep_pos_code varchar(25) NOT NULL Dependent Position Code No No

 

cfgaix_dep_level_code varchar(150) NOT NULL Dependent Level Code Yes No

 

cfgaix_rev_flag varchar(25) NULL Reversible Flag. Can be either ’Yes’ or ’No’ No No

 

CFGAIX_REMARKS sql_variant NULL CFGAIX_REMARKS No No

 

CFGAIX_REMARKS_ID sql_variant NULL CFGAIX_REMARKS_ID No No

 

CFGAIX_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No. Yes No

 

CFGAIX_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfgaix_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

CFGAIX_POS_CODE varchar(25) NOT NULL The position code for which the configuration rules must be defined Yes No

 

CFGAIX_REVNO varchar(40) NOT NULL The revision number of the aircraft configuration Yes No

 

cfgaix_level_code varchar(150) NOT NULL Level Code Yes No

 

 
Table Name cfg_cfgaps_accfg_sppart_pos

 

 
Table Comment This table maintains the various spare parts for the aircraft configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGAPS_OUINSTANCE decimal(10) NOT NULL OU Instance Yes No

 

CFGAPS_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Register Number Yes No

 

CFGAPS_REVNO varchar(40) NOT NULL Revision Number Yes No

 

CFGAPS_PART_NO varchar(40) NOT NULL Part number Yes No

 

cfgaps_pos_code varchar(25) NOT NULL Position Code which needs to be tracked in the spare part Yes No

 

cfgaps_pos_status varchar(15) NULL Status of the position code. Can be either ’Active’ or ’Inactive’ A - Active I - Inactive No No

 

cfgaps_serial_no varchar(40) NULL Serial Number No No

 

cfgaps_lot_no varchar(18) NULL Lot Number No No

 

cfgaps_date_of_att datetime NULL Date of Attachment No No

 

cfgaps_wo_no varchar(18) NULL Work Order Number No No

 

cfgaps_wo_ou numeric(10) NULL OUInstance of the Work Order Number No No

 

 
Table Name CFG_CFGAPS_CFGAC_PERM_SRLNO

 

 
Table Comment Stores aps details for Aircraft model and part

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGAPS_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration no Yes No

 

CFGAPS_REVNO varchar(40) NOT NULL Revision no Yes No

 

CFGAPS_LEVEL_CODE varchar(150) NOT NULL Level code Yes No

 

CFGAPS_POS_CODE varchar(25) NOT NULL Position code Yes No

 

CFGAPS_POS_PART_NO varchar(40) NOT NULL Position Part No Yes No

 

CFGAPS_FROM_MSN_NO varchar(40) NOT NULL Manufacturer Serial No. Yes No

 

CFGAPS_INTERCHANGE_PART varchar(40) NOT NULL Interchangeable Part No. Yes No

 

CFGAPS_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGAPS_RESTRICT_TYPE varchar(5) NULL Restrict type No No

 

CFGAPS_INTERCHANGE_PART_OU decimal(10) NULL ouinstance No No

 

CFGAPS_TO_MSN_NO varchar(40) NULL To manufacturer serial no No No

 

CFGAPS_FROM_MSN_PRFX varchar(40) NULL MSN Prefix No No

 

CFGAPS_FROM_MSN_SFX decimal(10) NULL MSN SUFFIX No No

 

CFGAPS_TO_MSN_PRFX varchar(40) NULL TO MSN Prefix No No

 

CFGAPS_TO_MSN_SFX decimal(10) NULL To MSN Suffix No No

 

CFGAPS_TIMESTAMP decimal(28) NULL Time Stamp No No

 

 
Table Name cfg_cfgasp_accfg_spare_part

 

 
Table Comment List of Spare Parts for the Aircraft Configuration is maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGASP_OUINSTANCE decimal(10) NOT NULL OUinstance Yes No

 

CFGASP_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No Yes No

 

CFGASP_REVNO varchar(40) NOT NULL Revision No. Yes No

 

cfgasp_spare_part varchar(40) NOT NULL Spare Part Number Yes No

 

cfgasp_spare_part_ou numeric(10) NULL OUInstance of the spare part number No No

 

cfgasp_quantity numeric(28,8) NULL Quantity of the Spare part in the Aircraft Configuration No No

 

cfgasp_trackable_flag varchar(25) NULL This flag (Yes or No) indicates if the spare part need to be tracked or not. No No

 

cfgasp_pos_prefix varchar(6) NULL Prefix for generating the position codes No No

 

cfgasp_zone varchar(15) NULL Zone Code No No

 

 
Table Name cfg_cfgatw_cfgac_etop_twnps

 

 
Table Comment This table maintains the various etop twin positions for the Aircraft Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgatw_pos_part_no varchar(40) NOT NULL Position Part Number Yes No

 

CFGATW_POS_CODE varchar(25) NOT NULL Position Code Yes No

 

cfgatw_twin_level_code varchar(150) NOT NULL Twin Position Level Code Yes No

 

cfgatw_twin_pos_code varchar(25) NOT NULL Twin position code No No

 

cfgatw_twin_part_no varchar(40) NULL Part number associated with the twin position code No No

 

CFGATW_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfgatw_level_code varchar(150) NOT NULL Level Code Yes No

 

CFGATW_AIRCRAFT_REG_NO varchar(30) NOT NULL Aircraft Registration No. Yes No

 

CFGATW_REVNO varchar(40) NOT NULL Revision Number Yes No

 

 
Table Name cfg_cfgceo_cmp_eo_list

 

 
Table Comment List of EOs which has triggered the COmponent Configuration Changes

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGCEO_REVNO varchar(40) NOT NULL Configuration Revision No Yes No

 

CFGCEO_COMPONENTID varchar(90) NOT NULL Component Id Yes No

 

cfgceo_eo_no varchar(40) NOT NULL Engineering Order Number Yes No

 

cfgceo_released_date datetime NOT NULL Released Date No No

 

cfgceo_complied_date datetime NOT NULL Compliance date No No

 

cfgcmp_componentid varchar(90) NOT NULL Component Id Yes Yes

 

cfgcmp_ouinstance decimal(10) NOT NULL OUIstance Yes Yes

 

cfgcmp_status varchar(15) NOT NULL Status of the Configuration. Can be either ’Fresh’, ’Active’, ’Revised’ or ’Cancelled’ A - Active C - Cancelled F - Fresh R - Revised Yes Yes

 

cfgcmp_revno varchar(40) NOT NULL Revision number of the component configuration Yes Yes

 

CFGCEO_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

 
Table Name cfg_cfgcl_config_class_info

 

 
Table Comment This table maintains the various Configuration Class information

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgcl_ouinstance decimal(10) NOT NULL OUInstance Yes No

 

cfgcl_config_class varchar(30) NOT NULL Configuration Class Name Yes No

 

cfgcl_Description varchar(150) NOT NULL Description Of the Configuration Class No No

 

cfgcl_status varchar(15) NULL Status of the Configuration Class. Can be Active or Inactive A - Active I - Inactive No No

 

cfgcl_etop_flag varchar(25) NOT NULL This flag indicates if the class is for ETOP or not. This can take value ’Yes’ or ’No’ No No

 

cfgcl_no_of_engines decimal(10) NULL No of engines that will be available for this configuration class No No

 

cfgcl_no_of_apus decimal(10) NULL No of Auxiliary Power Units No No

 

cfgcl_user_Def_1 varchar(30) NULL User Defined Value No No

 

cfgcl_user_def_2 varchar(30) NULL cfgcl_user_def_2 No No

 

cfgcl_ac_group varchar(25) NULL Aircraft Group for which the configuration class is applicable - Quick Codes No No

 

cfgcl_ac_type varchar(25) NULL Aircraft Type for which the configuration class is applicable - Quick Codes No No

 

cfgcl_usage_type varchar(25) NULL Usage Type for which the configuration class is applicable - Quick Codes No No

 

cfgcl_landing_gear_type varchar(25) NULL Landing gear type can be ’Bogie Beam’, ’Tri-Cycle’ BB - Bogie Beam TC - Tri-Cycle No No

 

cfgcl_model_eff_flag varchar(25) NULL A indicates this configuration Class is associated with all the models and R indicates it is mapped to restricted models only No No

 

cfgcl_created_by varchar(30) NULL Created User No No

 

cfgcl_creationdate datetime NULL Creation Date No No

 

cfgcl_modified_by varchar(30) NULL Last Modified User Id No No

 

cfgcl_modifieddate datetime NULL Last Modified Date No No

 

cfgcl_timestamp decimal(10) NULL Timestamp No No

 

 
Table Name cfg_cfgcm_cfgmdl_association

 

 
Table Comment The mapping of Configuration Class to Models is maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgcm_model_no varchar(20) NOT NULL Model associated to the Configuration class Yes No

 

cfgcm_model_ou numeric(10) NOT NULL OUInstance of the Model No No

 

CFGCM_CONFIG_CLASS varchar(30) NOT NULL Configuration Class Yes No

 

CFGCM_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

 
Table Name cfg_cfgcmd_cmp_config_dtl

 

 
Table Comment This definition of the various position codes and their level are 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

 

CFGCMD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGCMD_COMPONENTID varchar(90) NOT NULL The component for which the configuration details must be define Yes No

 

CFGCMD_REVNO varchar(40) NOT NULL The number identifying the revision of the component configuration Yes No

 

cfgcmd_pos_code varchar(25) NOT NULL Position code associated with the component Yes No

 

cfgcmd_pos_part_no varchar(40) NULL part associated to the position code No No

 

cfgcmd_pos_part_ou numeric(10) NULL OUInstance of the Part Number No No

 

cfgcmd_nha varchar(90) NULL Next Higher Assembly No No

 

cfgcmd_root_node varchar(90) NULL Root Node No No

 

cfgcmd_root_revno varchar(40) NULL Root revision No No No

 

cfgcmd_rot_man_flag varchar(25) NULL This flag indicates if a rotable should always exists in the position code No No

 

cfgcmd_pos_type varchar(25) NULL Type of the position code. Can be Engine’, ’APU’,’Landing Gear’ or ’Others’ A - Apu E - Engine L - Landing Gear O - Others No No

 

cfgcmd_drawing_id varchar(40) NULL Drawing Id No No

 

cfgcmd_doc_path varchar(50) NULL Path in which the Drawing exists No No

 

cfgcmd_level_code varchar(150) NULL Unique identifier for each node in the configuration No No

 

cfgcmd_level_no varchar(150) NULL level number of the node No No

 

cfgcmd_zonecode varchar(15) NULL zone code No No

 

cfgcmd_ata_no varchar(30) NULL ATA Chapter number No No

 

cfgcmd_rot_comp varchar(90) NULL Rotable Component ID No No

 

cfgcmd_rot_serial_no varchar(40) NULL Rotable Serial Number No No

 

cfgcmd_date_of_attach datetime NULL Date of Attachment No No

 

cfgcmd_time_of_attach datetime NULL Time of Attachment No No

 

cfgcmd_pos_status varchar(15) NULL Position Status A - Active I - Inactive No No

 

cfgcmd_child_exists_flag varchar(25) NULL Flag for the existence of Child level -Y- YES -N- NO No No

 

cfgcmd_seq_no numeric(10) NULL Sequence Number - Building the level Code No No

 

cfgcmd_comp_condition varchar(5) NULL Component Condition NW - New OVH - Over Hauled PO - Phased Out SER - Serviceable USR - Un-Serviceable No No

 

cfgcmd_from_date datetime NULL Component Effective from date No No

 

cfgcmd_cargo_flag varchar(5) NULL Cargo Flag No No

 

cfgcmd_rvsm_flag varchar(5) NULL RVSM Flag No No

 

cfgcmd_body_station_no varchar(15) NULL Body Station No No

 

cfgcmd_link_flag varchar(75) NULL Link Flag Information No No

 

CFGCMD_INDUCTION_DATE datetime NULL induction date No No

 

CFGCMD_OPERATION_DATE datetime NULL operation date No No

 

CFGCMD_ATTACH_ROT_FLAG varchar(25) NULL rotable attachment flag No No

 

cfgcmd_rot_comp_part_no varchar(40) NULL Part No of the attached component. No No

 

cfgcmd_rot_comp_part_ou numeric(10) NULL Ou instance of the part no of the attached component. No No

 

CFGCMD_DISP_SEQ_NO decimal(10) NULL Display Sequence Number No No

 

cfgcmd_attach_status varchar(5) NULL Attachment Status No No

 

CFGCMD_REMARKS sql_variant NULL CFGCMD_REMARKS No No

 

CFGCMD_REMARKS_ID sql_variant NULL CFGCMD_REMARKS_ID No No

 

 
Table Name cfg_cfgcmp_comp_config

 

 
Table Comment Component Configuration is maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgcmp_ouinstance decimal(10) NOT NULL OUIstance Yes No

 

cfgcmp_componentid varchar(90) NOT NULL Component Id Yes No

 

cfgcmp_revno varchar(40) NOT NULL Revision number of the component configuration Yes No

 

cfgcmp_status varchar(15) NOT NULL Status of the Configuration. Can be either ’Fresh’, ’Active’, ’Revised’ or ’Cancelled’ A - Active C - Cancelled F - Fresh R - Revised Yes No

 

cfgcmp_component_ou decimal(10) NULL OUInstance of Component ID No No

 

cfgcmp_approveddate datetime NULL Approval Date No No

 

cfgcmp_created_by varchar(30) NULL Created By No No

 

cfgcmp_modified_by varchar(30) NULL Last Modified By No No

 

cfgcmp_timestamp decimal(10) NULL Timestamp No No

 

cfgcmp_approved_by varchar(30) NULL Approver No No

 

cfgcmp_baselined_flag varchar(25) NULL Base Lined Flag No No

 

cfgcmp_comments varchar(255) NULL Comments No No

 

cfgcmp_creationdate datetime NULL Configuration Creation Date No No

 

cfgcmp_modifieddate datetime NULL Last Modified Date No No

 

CFGCMP_FILE_NAME varchar(50) NULL CFGCMP_FILE_NAME No No

 

CFGCMP_NO_OF_ATTACHMNT decimal(10) NULL Number of Attachments No No

 

CFGCMP_NO_OF_POSCODE decimal(10) NULL Number of position codes No No

 

CFGCMP_INIT_FILENAME varchar(50) NULL Init Filename No No

 

 
Table Name cfg_cfgcnt_cmp_config_notes

 

 
Table Comment Notes for component Configuration is maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgcmp_ouinstance decimal(10) NOT NULL OUIstance Yes Yes

 

CFGCNT_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGCNT_COMPONENTID varchar(90) NOT NULL The number identifying the component Yes No

 

CFGCNT_CONFIG_REVNO varchar(40) NOT NULL The number identifying the revision of the component configuration with respect to the component configuration status. Yes No

 

cfgcnt_notes varchar(2000) NULL Notes No No

 

CFGCNT_NOTES_ID sql_variant NULL CFGCNT_NOTES_ID No No

 

 
Table Name cfg_cfgcps_cmp_sppart_pos

 

 
Table Comment Various position codes of the spare part which is tracked is maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgcps_lot_no varchar(18) NULL Lot Number No No

 

cfgcps_serial_no varchar(40) NULL Serial Number No No

 

cfgcps_pos_status varchar(15) NULL Status of the position code A - Active I - Inactive No No

 

cfgcps_date_of_attach datetime NULL Date of Attachment No No

 

cfgcps_wo_ou numeric(10) NULL OUInstance of the Work Order Number No No

 

cfgcps_wo_no varchar(18) NULL Work Order Number No No

 

CFGCPS_COMPONENTID varchar(90) NOT NULL The number identifying the component. Yes No

 

CFGCPS_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfgcps_pos_code varchar(25) NOT NULL Position code Yes No

 

CFGCPS_REVNO varchar(40) NOT NULL The number identifying the revision of the component configuration with respect to the component configuration status. Yes No

 

CFGCPS_SPARE_PART_NO varchar(40) NOT NULL Spare part Number Yes No

 

 
Table Name cfg_cfgcrh_crhistory_log

 

 
Table Comment Component History Log Table

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgcrh_ouinstance numeric(10) NOT NULL OUInstance Yes No

 

cfgcrh_component_id varchar(90) NOT NULL Component ID Yes No

 

cfgcrh_eff_from_date datetime NOT NULL Effective Attachment Date Yes No

 

cfgcrh_component_ou numeric(10) NULL OUInstance of the Component ID No No

 

cfgcrh_aircraft_ou numeric(10) NULL OUInstance of the Aircraft reg No No No

 

cfgcrh_aircraft_reg_no varchar(30) NULL Aircraft Registration No No No

 

cfgcrh_rev_no varchar(40) NULL Revision Number No No

 

cfgcrh_pos_code varchar(25) NULL Position Code No No

 

cfgcrh_pos_type varchar(5) NULL Position Type A - Apu E - Engine L - Landing Gear O - Others No No

 

cfgcrh_pos_part_ou numeric(10) NULL OUInstance of the part in the Position. No No

 

cfgcrh_pos_part_no varchar(40) NULL Part in the Position. No No

 

cfgcrh_parent_component_ou numeric(10) NULL OUInstance of the parent component id No No

 

cfgcrh_parent_component_id varchar(90) NULL Parent Component ID No No

 

cfgcrh_part_serial_no varchar(40) NULL Part Serial Number No No

 

cfgcrh_eff_to_date datetime NULL Effective removal date No No

 

cfgcrh_in_status varchar(25) NULL In Coming Status No No

 

cfgcrh_out_status varchar(25) NULL Out Going Status No No

 

cfgcrh_EO_no varchar(40) NULL Engineering Document No No No

 

cfgcrh_ata_no varchar(16) NULL ATA Number No No

 

cfgcrh_attach_tran_ou numeric(10) NULL OUInstance of the Attachment transaction No No No

 

cfgcrh_attach_tran_no varchar(40) NULL Attachment transaction Number No No

 

cfgcrh_removal_tran_ou numeric(10) NULL OUInstance of the Removal transaction No No No

 

cfgcrh_removal_tran_no varchar(40) NULL Removal transaction Number No No

 

cfgcrh_level_code varchar(150) NULL Level Code No No

 

cfgcrh_level_no numeric(10) NULL Level Number No No

 

cfgcrh_prm1_in_SN numeric(28,8) NULL Since New Value of the Parameter 1 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm1_out_SN numeric(28,8) NULL Since New Value of the Parameter 1 identified in Aircraft at the time of Removing the Component. No No

 

cfgcrh_prm1_in_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 1 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm1_out_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 1 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm2_in_SN numeric(28,8) NULL Since New Value of the Parameter 2 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm2_out_SN numeric(28,8) NULL Since New Value of the Parameter 2 identified in Aircraft at the time of Removing the Component. No No

 

cfgcrh_prm2_in_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 2 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm2_out_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 2 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm3_in_SN numeric(28,8) NULL Since New Value of the Parameter 3 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm3_out_SN numeric(28,8) NULL Since New Value of the Parameter 3 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm3_in_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 3 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm3_out_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 3 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm4_in_SN numeric(28,8) NULL Since New Value of the Parameter 4 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm4_out_SN numeric(28,8) NULL Since New Value of the Parameter 4 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm4_in_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 4 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm4_out_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 4 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm5_in_SN numeric(28,8) NULL Since New Value of the Parameter 5 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm5_out_SN numeric(28,8) NULL Since New Value of the Parameter 5 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm5_in_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 5 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm5_out_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 5 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm6_in_SN numeric(28,8) NULL Since New Value of the Parameter 6 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm6_out_SN numeric(28,8) NULL Since New Value of the Parameter 6 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm6_in_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 6 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm6_out_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 6 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm7_in_SN numeric(28,8) NULL Since New Value of the Parameter 7 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm7_out_SN numeric(28,8) NULL Since New Value of the Parameter 7 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm7_in_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 7 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm7_out_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 7 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm8_in_SN numeric(28,8) NULL Since New Value of the Parameter 8 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm8_out_SN numeric(28,8) NULL Since New Value of the Parameter 8 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm8_in_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 8 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm8_out_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 8 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm9_in_SN numeric(28,8) NULL Since New Value of the Parameter 9 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm9_out_SN numeric(28,8) NULL Since New Value of the Parameter 9 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm9_in_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 9 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm9_out_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 9 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm10_in_SN numeric(28,8) NULL Since New Value of the Parameter 10 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm10_out_SN numeric(28,8) NULL Since New Value of the Parameter 10 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_prm10_in_SO numeric(28,8) NULL Since OverHaul Value of the Parameter 10 identified in Aircraft at the time of Attaching the Component. No No

 

cfgcrh_prm10_out_SO numeric(28,8) NULL Since Overhaul Value of the Parameter 10 identified in Aircraft at the time of removing the Component. No No

 

cfgcrh_createdby varchar(30) NULL Created User No No

 

cfgcrh_createddate datetime NULL Created Date No No

 

CFGCRH_REMARKS varchar(255) NULL Remarks No No

 

cfgcrh_ini_attach_sts varchar(5) NULL Attachment Status No No

 

cfgcrh_ini_attach_date datetime NULL Attachment Date No No

 

cfgcrh_ini_attach_by varchar(30) NULL Attached By No No

 

 
Table Name CFG_CFGCRHTMP_CR_LOG

 

 
Table Comment Component Replacement Temp History Log

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGCRHTMP_GUID varchar(40) NOT NULL Guid No No

 

CFGCRHTMP_OUINSTANCE decimal(10) NULL OU Instance No No

 

CFGCRHTMP_COMPONENT_ID varchar(90) NULL Component ID No No

 

CFGCRHTMP_POS_CODE varchar(25) NULL Position Code No No

 

CFGCRHTMP_LEVEL_CODE varchar(150) NULL Level Code No No

 

CFGCRHTMP_POS_PART_NO varchar(40) NULL Position Part Number No No

 

CFGCRHTMP_POS_PART_OU decimal(10) NULL Position Part OU No No

 

CFGCRHTMP_PART_SERIAL_NO varchar(18) NULL Part Serial Number No No

 

CFGCRHTMP_EFF_FROM_DATE datetime NULL Effective From Date No No

 

CFGCRHTMP_EFF_TO_DATE datetime NULL Effective To Date No No

 

CFGCRHTMP_ATTACH_TRAN_OU decimal(10) NULL Attached Transaction OU No No

 

CFGCRHTMP_ATTACH_TRAN_NO varchar(18) NULL Attached Transaction Number No No

 

CFGCRHTMP_REMOVAL_TRAN_OU decimal(10) NULL Removal Transaction OU No No

 

CFGCRHTMP_REMOVAL_TRAN_NO varchar(18) NULL Removal Transaction Number No No

 

CFGCRHTMP_CREATEDBY varchar(30) NULL Created By No No

 

CFGCRHTMP_REMARKS varchar(255) NULL Remarks No No

 

 
Table Name cfg_cfgcsp_cmpcfg_spare_part

 

 
Table Comment Spare part list for the component configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGCSP_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGCSP_COMPONENTID varchar(90) NOT NULL The number identifying the component Yes No

 

CFGCSP_REVNO varchar(40) NOT NULL The number identifying the revision of the component configuration with respect to the component configuration status. Yes No

 

cfgcsp_spare_part_no varchar(40) NOT NULL spare part number Yes No

 

cfgcsp_spare_part_ou numeric(10) NULL OUInstance of the Spare Part Number No No

 

cfgcsp_quantity numeric(28,8) NULL quantity of the spare part which needs to be tracked No No

 

cfgcsp_trackable_flag varchar(25) NULL trackable flag . Holds value ’Yes’ or ’No’ No No

 

cfgcsp_pos_prefix varchar(25) NULL Prefix to generate the position codes No No

 

 
Table Name cfg_cfgmcd_mdl_config_cdl

 

 
Table Comment Component Deviation List for Model Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGMCD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGMCD_MODEL_NO varchar(20) NOT NULL The model associated to the aircraft for which the configuration details are to be entered Yes No

 

CFGMCD_CONFIG_CLASS varchar(30) NOT NULL The system retrieves the aircraft that are associated to the configuration class entered here. Yes No

 

CFGMCD_REVNO varchar(40) NOT NULL The revision number of the configuration class. Yes No

 

cfgmcd_cdl_item_code varchar(150) NOT NULL CDL Item Code Yes No

 

cfgmcd_part_no varchar(40) NULL Part Number which is a CDL No No

 

cfgmcd_maint_implication varchar(255) NULL Maintenance Implications if any No No

 

cfgmcd_oper_implication varchar(255) NULL Operational Implications if any No No

 

cfgmcd_cdl_remarks varchar(255) NULL Remarks No No

 

cfgmcd_part_ou numeric(10) NULL OUInstance of the Part Number No No

 

cfgmcd_cdl_item_desc varchar(255) NULL CDL Item Description No No

 

cfgmcd_cdl_qty numeric(28,8) NULL CDL Quantity No No

 

cfgmcd_cdl_min_qty numeric(28,8) NULL CDL Minimum Quantity No No

 

cfgmcd_cdl_item_status varchar(15) NULL Status of the CDL Item Number A - Active I - Inactive No No

 

cfgmcd_placard varchar(5) NULL Placard R - Required N - Not Required No No

 

cfgmcd_placard_inst varchar(2000) NULL Placard Instructions No No

 

CFGMCD_FILE_NAME varchar(50) NULL file name No No

 

cfgmcd_deferral_task varchar(30) NULL deferral Task No No

 

cfgmcd_deferral_rev_task varchar(40) NULL deferral Task rev no No No

 

 
Table Name cfg_cfgmdl_Model_config

 

 
Table Comment Model Configuration details

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgmdl_approveddate datetime NULL Approved Date No No

 

cfgmdl_approved_by varchar(30) NULL Approver No No

 

cfgmdl_inherit_changes varchar(25) NULL Inherit Changes Flag No No

 

cfgmdl_comments varchar(255) NULL Comments No No

 

cfgmdl_timestamp decimal(10) NULL Time Stamp No No

 

CFGMDL_MEL_FILE_NAME varchar(50) NULL Minimum Equipment List file name. No No

 

cfgmdl_baselined_flag varchar(25) NULL Indicates if the current Model configuration revision has been baselined or not.Holds yes or no value No No

 

CFGMDL_FILE_NAME varchar(50) NULL Model File Name No No

 

cfgmdl_mismatch_flag varchar(25) NULL Mismatch flag No No

 

CFGMDL_CDL_FILE_NAME varchar(50) NULL Configuration Deviation List Filename No No

 

CFGMDL_CONFIG_CLASS varchar(30) NOT NULL The configuration class to which the aircraft model is associated. Yes No

 

cfgmdl_revno varchar(40) NOT NULL revision number Yes No

 

CFGMDL_MODEL_NO varchar(20) NOT NULL The aircraft model number to which the aircraft is associated. Yes No

 

CFGMDL_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfgmdl_modified_by varchar(30) NULL Last Modified By No No

 

cfgmdl_creationdate datetime NULL creation date No No

 

cfgmdl_modifieddate datetime NULL Last Modified Date No No

 

cfgmdl_model_ou decimal(10) NULL OU of the Model No No

 

cfgmdl_created_by varchar(30) NULL created by No No

 

cfgmdl_status varchar(15) NOT NULL Status of the configuration. Can be active or fresh or revised or cancelled A - Active C - Cancelled F - Fresh R - Revised No No

 

 
Table Name CFG_CFGMDL_POSTATTRIB_DTL

 

 
Table Comment Stores Details Of Position Attributes

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGMDL_AIRCRAFT_REG_NO varchar(30) NOT NULL The aircraft registration number Yes No

 

CFGMDL_POS_CODE varchar(25) NOT NULL The position code for which the configuration rules must be defined Yes No

 

CFGMDL_LEVEL_CODE varchar(150) NOT NULL The level code corresponding to the position code Yes No

 

CFGMDL_POS_PART_NO varchar(40) NOT NULL The part number for which the position code details are to be retrieved Yes No

 

CFGMDL_OUINSTANCE decimal(10) NOT NULL Ouinstance No No

 

CFGMDL_AIRCRAFT_REV_NO varchar(40) NULL The revision number of the model configuration. No No

 

CFGMDL_MODEL_NO varchar(20) NOT NULL The Model No. of the Aircraft No No

 

CFGMDL_CONFIG_CLASS varchar(30) NULL The configuration class to which the aircraft model is associated. No No

 

CFGMDL_REVNO varchar(40) NULL The revision number of the model configuration. No No

 

CFGMDL_POS_PART_OU decimal(10) NULL Ouinstance No No

 

CFGMDL_ZONECODE varchar(40) NULL The zone associated to the position code No No

 

CFGMDL_BODY_STATION_NO varchar(15) NULL Station Associated With the Body No No

 

CFGMDL_ATA_NO varchar(16) NULL The ATA chapter number associated to the position code No No

 

CFGMDL_LINK_INFO varchar(25) NULL Indicates whether the interchangeability rules, intermixing rules and ETOP twin position rules have been entered for the position. No No

 

CFGMDL_PARENT_PART_NO varchar(40) NULL Parent part info No No

 

CFGMDL_LEVEL_NO varchar(150) NOT NULL The level number of the position code and its associated part number. No No

 

CFGMDL_CARGO_FLAG varchar(25) NULL indicate that the position code is in the cargo aircraft. No No

 

CFGMDL_RVSM_FLAG varchar(25) NULL to indicate that the position code is in the aircraft, which fly in the reduced vertical separation minimum limit. No No

 

 
Table Name cfg_cfgmdt_mdl_config_dtl

 

 
Table Comment Position code details for the Model Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGMDT_OUINSTANCE decimal(10) NOT NULL OU Instance Yes No

 

CFGMDT_MODEL_NO varchar(20) NOT NULL Model Number Yes No

 

CFGMDT_CONFIG_CLASS varchar(30) NOT NULL Configuration Class Yes No

 

CFGMDT_REVNO varchar(40) NOT NULL Revision Number Yes No

 

cfgmdt_pos_code varchar(25) NOT NULL Position Code Yes No

 

cfgmdt_pos_part_no varchar(40) NOT NULL Part number associated with the position code No No

 

cfgmdt_pos_status varchar(15) NULL Status of the position code. Can be Active or Inactive No No

 

cfgmdt_pos_type varchar(25) NULL Position Code type . Can be ’Engine’, ’APU’,’Landing Gear’ or ’Others’ E- Engine A- APU L - Landing Gear O- Others No No

 

cfgmdt_rot_man_flag varchar(25) NULL Indicates if a rotable is mandatory in the position code defined. No No

 

cfgmdt_cargo_flag varchar(25) NULL Indicates if the configuration is applicable for cargo planes No No

 

cfgmdt_rvsm_flag varchar(25) NULL RVSM Flag No No

 

cfgmdt_mel_flag varchar(25) NULL MEL Flag No No

 

cfgmdt_zonecode varchar(15) NULL Zone Code No No

 

cfgmdt_body_station_no varchar(15) NULL Body Station no No No

 

cfgmdt_ata_no varchar(16) NULL ATA chapter no No No

 

cfgmdt_drawing_no varchar(40) NULL Drawing no No No

 

cfgmdt_doc_path varchar(50) NULL path where the document is available. No No

 

cfgmdt_level_no numeric(10) NULL level number of the position code No No

 

cfgmdt_level_code varchar(150) NULL unique identifier for the position code in the structure of configuration No No

 

cfgmdt_no_of_eng numeric(10) NULL no of engines No No

 

cfgmdt_no_of_apus numeric(10) NULL no of auxiliary power units No No

 

cfgmdt_pos_part_ou numeric(10) NULL OUInstance of the part number No No

 

cfgmdt_change_type_flag varchar(25) NULL This flag indicates whether the change is insertion or modification No No

 

cfgmdt_seq_no numeric(10) NULL Sequence Number No No

 

cfgmdt_link_info varchar(75) NULL Link Flag Information No No

 

CFGMDT_DISP_SEQ_NO decimal(10) NULL Display Sequence Number No No

 

CFGMDT_REMARKS varchar(2000) NULL CFGMDT_REMARKS No No

 

CFGMDT_REMARKS_ID varchar(40) NULL CFGMDT_REMARKS_ID No No

 

 
Table Name cfg_cfgmel_mdl_config_mel

 

 
Table Comment Minimum equipment list for the model configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGMEL_OUINSTANCE decimal(10) NOT NULL OU Instance Yes No

 

CFGMEL_MODEL_NO varchar(20) NOT NULL The aircraft model for which the minimum equipment list is displayed Yes No

 

CFGMEL_CONFIG_CLASS varchar(30) NOT NULL Configuration class associated with the aircraft Yes No

 

CFGMEL_REVNO varchar(40) NOT NULL The revision number of the model configuration. Yes No

 

cfgmel_mel_item_code varchar(150) NOT NULL The number identifying the MEL item Yes No

 

cfgmel_part_no varchar(40) NULL The part number to which the component belongs No No

 

cfgmel_condition_flag varchar(25) NULL Indicates that the usage of the part in an unserviceable state is based on certain cond No No

 

cfgmel_conditions sql_variant NULL The conditions or the factors governing the usage of the part in an unserviceable state No No

 

cfgmel_mel_qty numeric(28,8) NULL quantity of the part to be included in the MEL No No

 

cfgmel_maint_implication varchar(255) NULL The maintenance implications of flying the aircraft with the part in an unserviceable state No No

 

cfgmel_oper_implication varchar(255) NULL The operational implications of flying the aircraft with the part in an unserviceable state. No No

 

cfgmel_pos_based_flag varchar(25) NULL This flag is true if the no of qty per aircraft and the MEL quantity given matches No No

 

cfgmel_part_ou numeric(10) NULL OUInstance of the Part Number No No

 

cfgmel_mel_item_desc varchar(255) NULL The textual description of the MEL item No No

 

cfgmel_category varchar(25) NULL The MEL category to which the MEL item belongs No No

 

cfgmel_min_mel_qty numeric(28,8) NULL The minimum quantity of the part to be included in the MEL No No

 

cfgmel_mel_item_status varchar(15) NULL The status of the MEL item. No No

 

cfgmel_placard varchar(5) NULL Placard N- Not Required R- Required No No

 

cfgmel_placard_inst varchar(2000) NULL Placard Instructions No No

 

CFGMEL_FILE_NAME varchar(50) NULL File name No No

 

cfgmel_deferral_task varchar(30) NULL The task performed during the first scheduled maintenance to rectify a deferred discrepancy, which would have occurred during a maintenance activity. No No

 

cfgmel_deferral_rev_task varchar(30) NULL The task performed during the second scheduled maintenance in case of further deferment in the discrepancy rectification. No No

 

 
Table Name cfg_cfgmelc_mel_category

 

 
Table Comment MEL Category Detailas

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgmelc_ouinstance numeric(10) NOT NULL OUInstance Yes No

 

cfgmelc_mel_category varchar(30) NOT NULL The code identifying MEL category that you wish to modify Yes No

 

cfgmelc_description varchar(150) NULL The textual description of the MEL category. No No

 

cfgmelc_deferral_type varchar(5) NULL Deferral Type TL - Time Limited TU - Time and Usage Limited UL - Usage Limited No No

 

cfgmelc_limit_basis varchar(5) NULL Limit Basis Time and Usage Limited" in the "Limit Type" field. No No

 

cfgmelc_deferral_dur numeric(20) NULL The duration or period for which the MEL item number can be deferred No No

 

CFGMELC_DUR_UOM varchar(5) NULL Deferral duration UOM No No

 

cfgmelc_status varchar(5) NULL MEL Category Status A - Active I - Inactive No No

 

cfgmelc_remarks varchar(255) NULL Any remark or comment pertaining the MEL category No No

 

cfgmelc_created_by varchar(30) NULL Created User No No

 

cfgmelc_createddate datetime NULL Created Date No No

 

cfgmelc_modified_by varchar(30) NULL Modified User No No

 

cfgmelc_modifieddate datetime NULL Modified Date No No

 

cfgmelc_timestamp numeric(10) NULL TimeStamp No No

 

 
Table Name cfg_cfgmelp_mel_catg_param

 

 
Table Comment Parameter Deferral limit details for the MEL Category

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGMELP_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGMELP_MEL_CATEGORY varchar(30) NOT NULL The MEL category code Yes No

 

cfgmelp_param_code varchar(40) NOT NULL The unique code identifying the parameter, as defined in the Aircraft business comp Yes No

 

cfgmelp_deferral_limit numeric(20) NULL The value of the parameter based on which the MEL item number is deferred No No

 

 
Table Name cfg_cfgmeo_model_eo_list

 

 
Table Comment List of Engineering Orders that changed model configuration.

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgmeo_eo_no varchar(40) NOT NULL The number identifying the engineering order due to which the model configuration was revised Yes No

 

CFGMEO_REV_NO varchar(40) NOT NULL The revision number of the aircraft configuration. Yes No

 

cfgmeo_released_date datetime NULL The date on which the engineering order was issued. No No

 

cfgmeo_complied_date datetime NULL The date on which the changes were made in the aircraft configuration. No No

 

CFGMEO_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGMEO_CONFIG_CLASS varchar(30) NOT NULL The configuration class associated to the aircraft. Yes No

 

CFGMEO_MODEL_NO varchar(20) NOT NULL Model No associated with the aircraft Yes No

 

 
Table Name cfg_cfgmic_mdlcfg_intchge_rule

 

 
Table Comment Interchangeable rules for the Model

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGMIC_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGMIC_MODEL_NO varchar(20) NOT NULL The aircraft model for which the part interchangeability rule details must be defined. Yes No

 

CFGMIC_CONFIG_CLASS varchar(30) NOT NULL The configuration class to which the aircraft model is associated Yes No

 

CFGMIC_REVNO varchar(40) NOT NULL The revision number of the model configuration Yes No

 

CFGMIC_POS_CODE varchar(25) NOT NULL The position code for which the list of interchangeable parts must be defined Yes No

 

cfgmic_pos_part_no varchar(40) NOT NULL The part associated to the position code, for which the list of interchangeable parts must be defined Yes No

 

cfgmic_interchange_part varchar(40) NOT NULL The part that can be fitted in place of the reference part number, in the reference position code Yes No

 

cfgmic_level_code varchar(150) NOT NULL The level at which the reference position code occurs in model configuration hierarchy Yes No

 

cfgmic_order_of_pref numeric(10) NULL The preferred order in which the interchangeable part must be considered for fitting in the reference position code No No

 

cfgmic_mod_status varchar(15) NULL document number which authorizes the interchangeability No No

 

CFGMIC_REMARKS sql_variant NULL CFGMIC_REMARKS No No

 

CFGMIC_REMARKS_ID sql_variant NULL CFGMIC_REMARKS_ID No No

 

 
Table Name cfg_cfgmix_mdlcfg_intmx_rule

 

 
Table Comment Intermixing Rules for Model position codes

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGMIX_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGMIX_MODEL_NO varchar(20) NOT NULL The aircraft model for which the intermixing rule details must be defined Yes No

 

CFGMIX_CONFIG_CLASS varchar(30) NOT NULL The configuration class to which the aircraft model is associated. Yes No

 

CFGMIX_REVNO varchar(40) NOT NULL The revision number of the model configuration. Yes No

 

cfgmix_level_code varchar(150) NOT NULL The level code of the reference part number. Yes No

 

CFGMIX_POS_CODE varchar(25) NOT NULL The position code selected for which the dependent position codes must be entered. Yes No

 

cfgmix_pos_part_no varchar(40) NOT NULL select the part associated to the position code, for which the dependent position codes must be entered. Yes No

 

cfgmix_dep_level_code varchar(150) NOT NULL The level at which the dependent position code and part number occurs in the model configuration hierarchy. Yes No

 

cfgmix_dep_pos_code varchar(25) NOT NULL The position code that is dependent on the reference position code and the reference part number No No

 

cfgmix_dep_part_no varchar(40) NOT NULL The part number that must be fitted in the dependent position code, when the reference part number is fitted in the reference position code No No

 

cfgmix_rev_flag varchar(25) NULL Reversible Flag, Yes , No No No

 

CFGMIX_REMARKS sql_variant NULL CFGMIX_REMARKS No No

 

CFGMIX_REMARKS_ID sql_variant NULL CFGMIX_REMARKS_ID No No

 

 
Table Name cfg_cfgmlk_model_link_info

 

 
Table Comment Model Configuration Link Information

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgmlk_ata_no varchar(16) NULL The ATA chapter to be associated to the position code No No

 

cfgmlk_body_station varchar(15) NULL Station which is associated with the body of the aircraft No No

 

cfgmlk_zone_code varchar(15) NULL The zone to be associated to the position code No No

 

cfgmlk_child_level_no numeric(10) NOT NULL child Level Number No No

 

cfgmlk_link_flag varchar(15) NULL Indicates whether the interchangeability rules, intermixing rules and ETOP twin position rules have been entered for the position IC,IM,ETOP No No

 

cfgmlk_cargo_flag varchar(25) NULL that the position code is in the cargo aircraft. The system provides the options “Yes” and “No”. No No

 

cfgmlk_rvsm_flag varchar(15) NULL indicate that the position code is in the aircraft, which fly in the reduced vertical separation minimum limit. The system provides the options “Yes” and “No”. No No

 

cfgmlk_nha varchar(40) NULL Next Higher Assembly No No

 

CFGMLK_MODEL_NO varchar(20) NOT NULL The model to which the aircraft is associated Yes No

 

CFGMLK_CONFIG_CLASS varchar(30) NOT NULL that are associated to the selected aircraft model Yes No

 

CFGMLK_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfgmlk_part_no varchar(40) NOT NULL The part number for which the position code details are to be retrieved No No

 

CFGMLK_POS_CODE varchar(25) NOT NULL The position code for which the configuration rules must be defined No No

 

CFGMLK_REV_NO varchar(40) NOT NULL The revision number of the aircraft configuration Yes No

 

cfgmlk_level_code varchar(150) NOT NULL The level code corresponding to the position code Yes No

 

 
Table Name CFG_CFGMNT_MDLCFG_NOTES

 

 
Table Comment This table stores Model Configuration Notes , Config Class, Revision Number against each model.
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGMNT_MODEL_NO varchar(20) NOT NULL Configuration Model Number Yes No

 

CFGMNT_CONFIG_CLASS varchar(30) NOT NULL Configuration Class Yes No

 

CFGMNT_REVNO varchar(40) NOT NULL Revision Number Yes No

 

CFGMNT_OUINSTANCE decimal(10) NOT NULL OU Instance Yes No

 

CFGMNT_NOTES varchar(2000) NULL Notes No No

 

 
Table Name cfg_cfgmps_mdcfg_sppart_pos

 

 
Table Comment Position Code definition for the trackable spare parts in the model

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgmps_pos_code varchar(25) NOT NULL The position code to which the spare part must be fitted Yes No

 

CFGMPS_SPARE_PART varchar(40) NOT NULL The spare part to be associated to the aircraft configuration Yes No

 

cfgmps_pos_status varchar(15) NULL Status of the position code .Can be either active or Inactive. A - Active I - Inactive No No

 

cfgmps_pos_count numeric(10) NULL Position Count (seq no) No No

 

CFGMPS_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGMPS_REVNO varchar(40) NOT NULL The revision number of the model configuration Yes No

 

CFGMPS_MODEL_NO varchar(20) NOT NULL The aircraft model associated with aircraft Yes No

 

CFGMPS_CONFIG_CLASS varchar(30) NOT NULL The configuration class to which the aircraft model is associated Yes No

 

 
Table Name cfg_cfgmsp_mdcfg_spare_part

 

 
Table Comment Spare Part list for Model Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgmsp_trackable_flag varchar(25) NULL Trackable Flag No No

 

cfgmsp_quantity numeric(28,8) NULL Quantity of the Spare Part that needs to be tracked No No

 

cfgmsp_pos_prefix varchar(6) NULL Prefix for the position code generation No No

 

cfgmsp_spare_part_ou numeric(10) NULL OUInstance of the Spare Part Number No No

 

cfgmsp_zone varchar(15) NULL Zone Code No No

 

CFGMSP_MODEL_NO varchar(20) NOT NULL The model to which the aircraft is associated. Yes No

 

CFGMSP_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfgmsp_spare_part varchar(40) NOT NULL The spare part to be associated to the aircraft configuration Yes No

 

CFGMSP_CONFIG_CLASS varchar(30) NOT NULL The configuration class to which the aircraft is associated. Yes No

 

CFGMSP_REVNO varchar(40) NOT NULL The revision number of the aircraft configuration. Yes No

 

 
Table Name cfg_cfgmtw_mdlcfg_etop_twnps

 

 
Table Comment ETop Twin positions for Model Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgmtw_pos_part_no varchar(40) NOT NULL The part associated to the reference position code. Yes No

 

CFGMTW_POS_CODE varchar(25) NOT NULL position code, for which the twin position code must be defined. Yes No

 

cfgmtw_level_code varchar(150) NOT NULL the level at which the reference position code occurs in the model configuration hierarchy. Yes No

 

cfgmtw_twin_level_code varchar(150) NOT NULL The level at which the twin position code and part number occurs in the model configuration hierarchy. Yes No

 

cfgmtw_twin_pos_code varchar(25) NOT NULL The position code that is parallel to the reference position code displayed in the “Ref. Position Code” field No No

 

cfgmtw_twin_part_no varchar(40) NOT NULL Part Number associated with the twin position code No No

 

CFGMTW_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

cfgmdl_revno varchar(40) NOT NULL revision number Yes Yes

 

CFGMTW_REVNO varchar(40) NOT NULL The revision number of the model configuration. Yes No

 

CFGMTW_MODEL_NO varchar(20) NOT NULL The aircraft model associated with aircraft Yes No

 

CFGMTW_CONFIG_CLASS varchar(30) NOT NULL The configuration class to which the aircraft model is associated. Yes No

 

 
Table Name cfg_cfgpeo_part_eo_list

 

 
Table Comment This Table maintains the list of EOs that trigger the Part revisions

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgpeo_eo_no varchar(40) NOT NULL Engineering Order Number Yes No

 

cfgpeo_released_date datetime NULL Released Date No No

 

cfgpeo_complied_date datetime NULL Compliance Date No No

 

CFGPEO_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGPEO_REV_NO varchar(40) NOT NULL Revision no of the configuration Yes No

 

CFGPEO_PART_NO varchar(40) NOT NULL Part no which triggers the Eo Yes No

 

 
Table Name cfg_cfgpnt_part_notes

 

 
Table Comment This table maintains the notes for Part Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGPNT_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGPNT_PART_NO varchar(40) NOT NULL Part No. Yes No

 

CFGPNT_REV_NO varchar(40) NOT NULL Revision No Yes No

 

cfgpnt_notes varchar(2000) NULL Notes No No

 

CFGPNT_NOTES_ID sql_variant NULL CFGPNT_NOTES_ID No No

 

 
Table Name cfg_cfgppp_cfgprt_sppt_pos

 

 
Table Comment Position codes that are tracked in the Spare part

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGPPP_SPARE_PART varchar(40) NOT NULL The spare part to be associated to the aircraft Yes No

 

cfgppp_pos_code varchar(25) NOT NULL The position code to which the spare part must be fitted Yes No

 

cfgppp_pos_status varchar(15) NULL Status of the Position Code. Can be Active or Inactive No No

 

CFGPPP_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGPPP_REV_NO varchar(40) NOT NULL The revision number of the configuration Yes No

 

CFGPPP_PART_NO varchar(40) NOT NULL part to be associated to the aircraft configuration Yes No

 

 
Table Name cfg_cfgpsp_prtcfg_spare_part

 

 
Table Comment Spare Part List for part configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgpsp_quantity numeric(28,8) NULL Quantity of the Spare part which has to be tracked No No

 

cfgpsp_spare_part_no varchar(40) NOT NULL Spare Part Number Yes No

 

CFGPSP_REV_NO varchar(40) NOT NULL Revision no of the configuration Yes No

 

cfgpsp_trackable_flag varchar(25) NULL Trackable Flag - Can be Yes or No No No

 

cfgpsp_pos_prefix varchar(6) NULL Prefix for generating the position codes No No

 

cfgpsp_spare_part_ou numeric(10) NULL OUInstance of the Spare Part No No

 

cfgpt_part_no varchar(40) NOT NULL Part Number Yes Yes

 

cfgpt_ouinstance numeric(10) NOT NULL OUInstance Yes Yes

 

CFGPSP_PART_NO varchar(40) NOT NULL Part No Yes No

 

cfgpt_rev_no varchar(40) NOT NULL Revision Number Yes Yes

 

CFGPSP_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

 
Table Name cfg_cfgpt_part_config

 

 
Table Comment Part Configuration

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfgpt_ouinstance numeric(10) NOT NULL OUInstance Yes No

 

cfgpt_part_no varchar(40) NOT NULL Part Number Yes No

 

cfgpt_rev_no varchar(40) NOT NULL Revision Number Yes No

 

cfgpt_ac_part_ou numeric(10) NULL This is the Aircraft Ou which has inherited the Inventory defined part No No

 

cfgpt_status varchar(15) NULL Status of Part Configuration A - Active I - Inactive No No

 

cfgpt_no_of_engines numeric(10) NULL Number of Engines No No

 

cfgpt_no_of_apus numeric(10) NULL Number of Auxiliary Power units No No

 

cfgpt_comments varchar(255) NULL Comments No No

 

cfgpt_created_by varchar(30) NULL Created By No No

 

cfgpt_createddate datetime NULL Created Date No No

 

cfgpt_approved_by varchar(30) NULL Approved By No No

 

cfgpt_approveddate datetime NULL Approved Date No No

 

cfgpt_modified_by varchar(30) NULL Last Modified By No No

 

cfgpt_modifieddate datetime NULL Last Modified Date No No

 

cfgpt_timestamp numeric(10) NULL Timestamp No No

 

cfgpt_baselined_flag varchar(25) NULL Base Lined Flag No No

 

cfgpt_mismatch_flag varchar(25) NULL Mismatch flag No No

 

cfgpt_inherit_chgs_flag varchar(25) NULL Inherit Changes Flag No No

 

CFGPT_FILE_NAME varchar(50) NULL filename No No

 

 
Table Name cfg_cfgptt_part_config_dtl

 

 
Table Comment Part Configuration Table

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFGPTT_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFGPTT_PART_NO varchar(40) NOT NULL Part no Yes No

 

CFGPTT_REV_NO varchar(40) NOT NULL Revision No. Yes No

 

cfgptt_pos_code varchar(25) NOT NULL Position Code Yes No

 

cfgptt_pos_part_no varchar(40) NOT NULL associated part number No No

 

cfgptt_pos_status varchar(15) NULL position status A - Active I - Inactive No No

 

cfgptt_pos_type varchar(25) NULL position type.Can be  ’Engine’, ’APU’,’Landing Gear’ or  ’Others’ A - Apu E - Engine L - Landing Gear O - Others No No

 

cfgptt_rvsm_flag varchar(25) NULL RVSM Flag - Yes or No No No

 

cfgptt_cargo_flag varchar(25) NULL Cargo Flag Yes or No No No

 

cfgptt_ata_no varchar(16) NULL ATA Chapter Number No No

 

cfgptt_drawing_no varchar(40) NULL Drawing Number No No

 

cfgptt_doc_path varchar(50) NULL Document Path No No

 

cfgptt_child_exists_flag varchar(25) NULL Indicates if the node has children No No

 

cfgptt_change_type_flag varchar(25) NULL Change Type Flag No No

 

cfgptt_rot_man_flag varchar(25) NULL Rotatable Mandatory flag - Holds flag ’Yes’ or ’No’ No No

 

cfgptt_zonecode varchar(15) NULL Zone Code No No

 

cfgptt_pos_part_ou numeric(10) NULL OUInstance of the Position Part Number No No

 

cfgptt_part_seqno numeric(10) NULL Sequence Number No No

 

CFGPTT_DISP_SEQ_NO decimal(10) NULL Display sequence No. No No

 

CFGPTT_REMARKS sql_variant NULL CFGPTT_REMARKS No No

 

CFGPTT_REMARKS_ID sql_variant NULL CFGPTT_REMARKS_ID No No

 

 
Table Name cfg_cfmeld_mdlcfg_mel_det

 

 
Table Comment Minimum equipment list for the Model Configuration is maintained

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

CFMELD_OUINSTANCE decimal(10) NOT NULL Ouinstance Yes No

 

CFMELD_MODEL_NO varchar(20) NOT NULL The model to which the aircraft is associated Yes No

 

CFMELD_REVNO varchar(40) NOT NULL The revision number of the configuration Yes No

 

cfmeld_level_code varchar(150) NOT NULL The level at which the part is associated to this position code in the model configuration hierarchy Yes No

 

CFMELD_MEL_ITEM_CODE varchar(30) NOT NULL he number identifying the MEL item that must be included in the minimum equipment list Yes No

 

CFMELD_CONFIG_CLASS varchar(30) NOT NULL The configuration class to which the aircraft model is associated. No No

 

cfmeld_pos_code varchar(25) NOT NULL Position Code which is a cdl No No

 

CFMELD_PART_NO varchar(40) NOT NULL part no No No

 

cfmeld_condition sql_variant NULL Condition of the part No No

 

cfmeld_maint_implication varchar(255) NULL Maintenance Implications if any No No

 

cfmeld_oper_implication varchar(255) NULL Operational Implications if any No No

 

cfmeld_conditional_flag varchar(25) NULL Conditional Flag - Y -’YES’ , N - ’NO’ No No

 

cfmeld_mel_flag varchar(25) NULL Takes value ’Yes’ or ’No’ No No

 

cfmeld_NHA_no varchar(40) NULL Next Higher Assembly No No

 

cfmeld_placard varchar(5) NULL Placard R- Required N- Not Required No No

 

cfmeld_placard_inst varchar(2000) NULL Placard Instructions No No

 

cfmeld_deferral_task varchar(30) NULL Deferral Task No No

 

cfmelD_deferral_rev_task varchar(30) NULL Deferral Tasks - Revised No No

 

 
Table Name cfg_cfpexp_part_hierarchy

 

 
Table Comment The entire structure for a part that is mapped to a Model configuration is maintained here

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

cfpexp_ouinstance numeric(10) NOT NULL OUinstance Yes No

 

cfpexp_cnfg_part_no varchar(40) NOT NULL Part number for which explosion is performed Yes No

 

cfpexp_level_code varchar(150) NOT NULL level code.System generated identifier Yes No

 

cfpexp_part_no varchar(40) NOT NULL Part number attached to the position code in the exploded hierarchy of the cnfg_part_no No No

 

cfpexp_pos_code varchar(25) NULL Position code where the part gets attached No No

 

cfpexp_rev_no varchar(40) NULL Revision Number No No

 

cfpexp_parent_part_no varchar(40) NULL Immediate Parent of the Part number No No

 

cfpexp_pos_type varchar(25) NULL Position Type A - Apu E - Engine L - Landing Gear O - Others No No

 

cfpexp_level_no varchar(150) NULL Level number No No

 

cfpexp_ata_no varchar(16) NULL Ata Number No No

 

cfpexp_zone_no varchar(15) NULL Zone Code No No

 

cfpexp_part_ou varchar(40) NULL OUInstance of the Part Number No No

 

cfpexp_assembly_flag varchar(25) NULL Assembly Flag No No

 

cfpexp_parent_rev_no varchar(40) NULL Parent revision Number No No

 

 
Table Name Cfg_mdlog_mdl_chg_log

 

 
Table Comment Model Configuration Change Log

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

Mdlog_OuInstance numeric(10) NOT NULL OUInstance Yes No

 

Mdlog_Model_no varchar(20) NOT NULL Model Number Yes No

 

Mdlog_rev_no varchar(40) NOT NULL Revision Number Yes No

 

Mdlog_level_code varchar(150) NOT NULL Level Code Yes No

 

Mdlog_Eo_no varchar(18) NOT NULL Engineering Document No Yes No

 

Mdlog_chg_date datetime NOT NULL Model Configuration Changed Date Yes No

 

Mdlog_config_class varchar(30) NOT NULL Configuration Class Yes No

 

Mdlog_pos_code varchar(25) NULL Position Code No No

 

Mdlog_status varchar(15) NULL Status of the Model Configuration No No

 

Mdlog_partno_old varchar(40) NULL Old Part Number No No

 

Mdlog_pos_status varchar(15) NULL Position Status A - Active I - Inactive No No

 

Mdlog_partno_new varchar(40) NULL New Part Number No No

 

Mdlog_updmode varchar(25) NULL Update Mode New Part ’I’ Part Change ’U’ No No

 

 
Table Name Cfg_Prtlog_chg_log

 

 
Table Comment Part Configuration Change Log table

 
Table Column Name Table Column Datatype Table Column Null Option Table Column Comment Table Column Is PK Table Column Is FK

 

Prtlog_Ouinstance numeric(10) NOT NULL OUInstance Yes No

 

Prtlog_Partno varchar(40) NOT NULL Part Number Yes No

 

Prtlog_rev_no varchar(40) NOT NULL Revision Number Yes No

 

Prtlog_pos_code varchar(25) NOT NULL Position Code Yes No

 

Prtlog_Eo_no varchar(18) NOT NULL Engineering Order Number Yes No

 

Prtlog_chg_date datetime NOT NULL Changed Date Yes No

 

Prtlog_partno_old varchar(40) NULL Old Part Number No No

 

Prtlog_status varchar(15) NULL Status A - Active I - Inactive No No

 

Prtlog_pos_status varchar(15) NULL Position Status A - Active I - Inactive No No

 

Prtlog_partno_new varchar(40) NULL New Part Number No No

 

Prtlog_updmode varchar(25) NULL Update Mode New (I) or Update (U) No No