Extract Aircraft Configuration From Maintenix¶
One way of loading configuration data to Mobile Maintenance for Aviation, is by extracting aircraft configuration information from Maintenix.
You can extract configuration data from Maintenix, by writing a script to prepare a csv file, which then be loaded to the Aircraft Configuration Loader in IFS Cloud. The csv file is loaded to the aircraft configuration data loading migration job and the migration job is executed afterwards.
Tables and columns in the Maintenix database to extract information from and load information to are as follows.
Create or update assemblies¶
Use the mapping information below to extract assemblies where the assembly class is not COMHW (Common Hardware) and TSE (Tools and Service Equipment)
Table in Maintenix | Column to extract | Aircraft Configuration Loader csv file column to write to | Aircraft Configuration Loader csv column name | Aircraft Configuration Loader csv column value to write | Data Type (Max Length) | Mapped Table in MM for Aviation |
---|---|---|---|---|---|---|
Not Applicable | None | Column 1 | Record Type | ASSY | Varchar(10) | Not Applicable |
eqp_assmbl | assmbl_cd | Column 2 | Assembly Type Code | Varchar (8) | av_assembly | |
eqp_assmbl | assmbl_name | Column 7 | Assembly Name | Varchar(80) | av_assembly | |
eqp_assmbl | assmbl_class_cd | Column 10 | Assembly Class Code | Varchar(8) | av_assembly | |
Not Applicable | None | Column 32 | Is Obsolete | FALSE | Varchar(20) | Not Applicable |
Not Applicable | None | Column 33 | External ID | A user defined unique value for the record type which identifies the row and if the new record type needs to be created or updated. | Varchar(80) | Not Applicable |
Create or update systems and sub-systems¶
Systems and Sub-systems in Maintenix are extracted from the same table. Systems are at a higher level and sub-systems are ranked beneath. For example the system code of a system is 25 and the sub-systems are 25-10, 25-20, and so on.
Use the mapping information below to extract systems where the config slot class is SYS connected to the ROOT (Root) config slot, and the assembly type code is not COMHW (Common Hardware) or TSE (Tools and Service Equipment).
Table in Maintenix | Column to extract | Aircraft Configuration Loader csv file column to write to | Aircraft Configuration Loader csv column name | Aircraft Configuration Loader csv column value to write | Data Type (Max Length) | Mapped Table in MM for Aviation |
---|---|---|---|---|---|---|
Not Applicable | None | Column 1 | Record Type | SYS | Varchar(10) | Not Applicable |
eqp_assmbl_bom | assmbl_cd | Column 2 | Assembly Type Code | Varchar(8) | av_aircraft_system | |
eqp_assmbl_bom | assmbl_bom_cd | Column 3 | System Code | Varchar(50) | av_aircraft_system | |
eqp_assmbl_bom | assmbl_bom_name | Column 9 | System Name | Varchar(100) | av_aircraft_system | |
Not Applicable | None | Column 32 | Is Obsolete | FALSE | Varchar(20) | Not Applicable |
eqp_assmbl_bom | None | Column 33 | External ID | A user defined unique value for the record type which identifies the row and if the new record type needs to be created or updated. | Varchar(80) | Not Applicable |
Use the mapping information below to extract sub systems where the config class is SYS (System) and the assembly class code is not COMHW (Common Hardware) or TSE (Tools and Service Equipment).
Table in Maintenix | Column to extract | Aircraft Configuration Loader csv file column to write to | Aircraft Configuration Loader csv column name | Aircraft Configuration Loader csv column value to write | Data Type (Max Length) | Mapped Table in MM for Aviation |
---|---|---|---|---|---|---|
Not Applicable | None | Column 1 | Record Type | SUB | Varchar(10) | Not Applicable |
eqp_assmbl_bom | assmbl_cd | Column 2 | Assembly Type Code | Varchar(8) | av_aircraft_subsystem | |
eqp_assmbl_bom | assmbl_bom_cd | Column 4 | Sub System Code | Varchar(50) | av_aircraft_subsystem | |
eqp_assmbl_bom | assmbl_bom_name | Column 9 | Sub System Name | Varchar(100) | av_aircraft_subsystem | |
Not Applicable | None | Column 32 | Is Obsolete | FALSE | Varchar(20) | Not Applicable |
Not Applicable | None | Column 33 | External ID | A user defined unique value for the record type which identifies the row and if the new record type needs to be created or updated. | Varchar(80) | Not Applicable |
eqp_assmbl_bom | None | Column 34 | System External ID | The value for this field must be the same as the External ID for a system created previously. | Varchar(20) | av_aircraft_subsystem |
Create or update configuration slots¶
Use the mapping information below to extract config slots where the config class code is TRK, SUBASSY or ROOT (Tracked, Sub Assembly or Root) and the assembly class code is not COMHW (Common Hardware) or TSE (Tools and Service Equipment).
Table in Maintenix | Column to extract | Aircraft Configuration Loader csv file column to write to | Aircraft Configuration Loader csv column name | Aircraft Configuration Loader csv column value to write | Data Type (Max Length) | Mapped Table in MM for Aviation |
---|---|---|---|---|---|---|
Not Applicable | None | Column 1 | Record Type | CFG | Varchar(10) | Not Applicable |
eqp_assmbl_bom | assmbl_cd | Column 2 | Assembly Type Code | Varchar(8) | av_config_slot | |
eqp_assmbl_bom | assmbl_bom_cd | Column 5 | Config Slot Code | Varchar(50) | av_config_slot | |
eqp_assmbl_bom | assmbl_bom_name | Column 9 | Config Slot Name | Varchar(100) | av_config_slot | |
eqp_assmbl | assmbl_class_cd | Column 10 | Assembly Class Code | Varchar(8) | av_config_slot | |
eqp_assmbl_bom_root | assmbl_cd of the next highest config slot where the next highest config class code is not SYS | Column 12 | Parent Aircraft Type Code | Varchar(16) | av_config_slot | |
eqp_assmbl_bom_root | assmbl_bom_cd | Column 13 | Parent Config Slot Code | Varchar (40) | av_config_slot | |
eqp_assmbl_bom | cfg_slot_status_cd | Column 14 | Config Slot Status | Varchar(8) | av_config_slot | |
eqp_assmbl_bom | mandatory_bool | Column 15 | Is Mandatory | True/False | Varchar(20) | av_config_slot |
eqp_assmbl_bom | software_bool | Column 16 | Is Software | True/False | Varchar(20) | av_config_slot |
eqp_assmbl_bom | pos_ct | Column 17 | Number of Config Slot Positions | Number(20) | av_config_slot | |
Not Applicable | None | Column 32 | Is Obsolete | FALSE | Varchar(20) | Not Applicable |
Not Applicable | None | Column 33 | External ID | A user defined unique value for the record type which identifies the row and if the new record type needs to be created or updated. | Varchar(80) | Not Applicable |
Create or update configuration slot positions¶
Use the mapping information below to extract config slot positions where the config class code is TRK, SUBASSY or ROOT (Tracked, Sub Assembly or Root) and the assembly class code is not COMHW (Common Hardware) or TSE (Tools and Service Equipment).
Table in Maintenix | Column to extract | Aircraft Configuration Loader csv file column to write to | Aircraft Configuration Loader csv column name | Aircraft Configuration Loader csv column value to write | Data Type (Max Length) | Mapped Table in MM for Aviation |
---|---|---|---|---|---|---|
Not Applicable | None | Column 1 | Record Type | CFGPOS | Varchar(10) | Not Applicable |
eqp_assmbl_bom | assmbl_cd | Column 2 | Assembly Type Code | assembly_type_code | Varchar(8) | av_config_slot_position |
eqp_assmbl_pos | assmbl_bom_cd | Column 5 | Config Slot Code | Varchar(50) | av_config_slot_position | |
eqp_assmbl_pos | eqp_pos_cd | Column 6 | Config Slot Position Code | Varchar(200) | av_config_slot_position | |
Not Applicable | None | Column 32 | Is Obsolete | FALSE | Varchar(20) | Not Applicable |
Not Applicable | None | Column 33 | External ID | A user defined unique value for the record type which identifies the row and if the new record type needs to be created or updated. | Varchar(80) | Not Applicable |
Create or update part groups¶
Use the mapping information below to extract part groups where the assembly class code is not TSE (Tools and Service Equipment) and the inventory class code is BATCH, SER, KIT, TRK, ASSY, ACFT (Batch, Serial, Kit, Tracked, Assembly, Aircraft).
Table in Maintenix | Column to extract | Aircraft Configuration Loader csv file column to write to | Aircraft Configuration Loader csv column name | Aircraft Configuration Loader csv column value to write | Data Type (Max Length) | Mapped Table in MM for Aviation |
---|---|---|---|---|---|---|
Not Applicable | None | Column 1 | Record Type | PG | Varchar(10) | Not Applicable |
eqp_bom_part | If eqp_assmbl.assmbl_class_cd is 'COMHW' THEN NULL. ELSE eqp_bom_part.assmbl_cd. | Column 2 | Assembly Type Code | Varchar(8) | av_part_group | |
eqp_bom_part | If eqp_assmbl.assmbl_class_cd is 'COMHW' OR eqp_bom_part.inv_class_cd = 'BATCH','SER','KIT' THEN NULL. ELSE eqp_assmbl_bom.assmbl_bom_cd. | Column 5 | Config Slot Code | Varchar(50) | av_part_group | |
eqp_bom_part | bom_part_cd | Column 7 | Part Group Code | Varchar(50) | av_part_group | |
eqp_bom_part | bom_part_name | Column 9 | Part Group Name | Varchar(100) | av_part_group | |
eqp_bom_part | inv_class_cd | Column 11 | Inventory Class Code | Varchar (8) | av_part_group | |
eqp_bom_part | part_qt | Column 18 | Part Quantity | Number(20) | av_part_group | |
eqp_bom_part | lru_bool | Column 19 | Is Line Replaceable | Number(20) | av_part_group | |
eqp_bom_part | appl_eff_ldesc | Column 20 | Applicability Range | Varchar(4000) | av_part_group | |
eqp_bom_part | If eqp_assmbl.assmbl_class_cd is 'COMHW' THEN TRUE ELSE FALSE | Column 21 | Is Common Hardware | True/False | Varchar(20) | av_part_group |
eqp_bom_part | req_spec_part_bool | Column 22 | Is Req Spec Part | Varchar(5) | av_part_group | |
eqp_bom_part | conditions_ldesc | Column 23 | Conditions Desc | Varchar(4000) | av_part_group | |
Not Applicable | None | Column 32 | Is Obsolete | FALSE | Varchar(20) | Not Applicable |
Not Applicable | None | Column 33 | External ID | A user defined unique value for the record type which identifies the row and if the new record type needs to be created or updated. | Varchar(80) | Not Applicable |
Create or update part numbers¶
Use the mapping information below to extract part numbers where the inventory class code is BATCH, SER, KIT, TRK, ASSY, SYS, ACFT (Batch, Serial, Kit, Tracked, Assembly, System, Aircraft) and not BLKOUT (Not Applicable).
Table in Maintenix | Column to extract | Aircraft Configuration Loader csv file column to write to | Aircraft Configuration Loader csv column name | Aircraft Configuration Loader csv column value to write | Data Type (Max Length) | Mapped Table in MM for Aviation |
---|---|---|---|---|---|---|
Not Applicable | None | Column 1 | Record Type | PN | Varchar(10) | Not Applicable |
eqp_part_no | part_no_oem | Column 8 | Part Number | Varchar(40) | av_part_number | |
eqp_part_no | part_no_sdesc | Column 9 | Part Name | Varchar(80) | av_part_number | |
eqp_part_no | inv_class_cd | Column 11 | Inventory Class Code | Varchar(8) | av_part_number | |
eqp_part_no | manufact_cd | Column 24 | Manufacturer | Varchar(16) | av_part_number | |
eqp_part_no | part_use_cd | Column 25 | Part Use | Varchar(20) | av_part_number | |
eqp_part_no | repair_bool | Column 26 | Is Repairable | True/False | Varchar(20) | av_part_number |
eqp_part_no | part_status_cd | Column 26 | Part Status | Varchar(20) | av_part_number | |
Not Applicable | None | Column 32 | Is Obsolete | FALSE | Varchar(20) | Not Applicable |
Not Applicable | None | Column 33 | External ID | A user defined unique value for the record type which identifies the row and if the new record type needs to be created or updated. | Varchar(80) | Not Applicable |
Create or update part group parts¶
Use the mapping information below to extract part groups parts where the assembly class code is not TSE (Tools and Service Equipment) and the inventory class code is BATCH, SER, KIT, TRK, ASSY, ACFT (Batch, Serial, Kit, Tracked, Assembly, Aircraft).
Table in Maintenix | Column to extract | Aircraft Configuration Loader csv file column to write to | Aircraft Configuration Loader csv column name | Aircraft Configuration Loader csv column value to write | Data Type (Max Length) | Mapped Table in MM for Aviation |
---|---|---|---|---|---|---|
Not Applicable | None | Column 1 | Record Type | PGP | Varchar(20) | Not Applicable |
eqp_part_baseline | standard_bool | Column 28 | Is Standard | True/False | Varchar(20) | av_part_group_part |
eqp_part_baseline | interchg_ord | Column 29 | Interchangeability Order | Number(20) | av_part_group_part | |
eqp_part_baseline | approved_bool | Column 30 | Is Approved | True/False | Varchar(20) | av_part_group_part |
eqp_part_baseline | conditional_bool | Column 31 | Is Conditions | True/False | Varchar(20) | av_part_group_part |
Not Applicable | None | Column 32 | Is Obsolete | FALSE | Varchar(20) | Not Applicable |
Not Applicable | None | Column 33 | External ID | A user defined unique value for the record type which identifies the row and if the new record type needs to be created or updated. | Varchar(80) | Not Applicable |
Not Applicable | None | Column 35 | Part Group External ID | An external identifier for the part group to which the part group part needs to be assigned. The value for this field must be the same as the External ID for a part group created previously. | Varchar(80) | Not Applicable |
Not Applicable | None | Column 36 | Part Number External ID | An external identifier for the part number with which the part group part can be assigned to the part group. The value for this field must be the same as the External ID for a part number created previously. | Varchar(80) | Not Applicable |
For more information on preparing a csv file with aircraft configuration information and loading the file to IFS Cloud, see Prepare and Load Aircraft Configuration