Generate Aircraft Configuration File From ATCM
Aircraft type or assembly type configuration data must be loaded to IFS Cloud for aircraft type configuration information to be available for Mobile Maintenance for Aviation.
Customers with the Aviation Technical Content Manager (ATCM) solution can migrate the information from ATCM to Mobile Maintenance (MM) for Aviation.
In the IFS Cloud database, map the MM tables to ATCM as indicated below and write a script to generate a csv file.
Table in ADCOM (MM) |
Attribute |
Data Type |
Usage in MM |
Table in CFGMR (ATCM) |
Attribute |
Data Type |
av_part_number |
part_number_id |
|
|
opr_part_tab |
|
|
|
manufacturer |
TEXT(16) |
|
|
manufacturer_code |
TEXT(16) |
|
part_number |
TEXT(40) |
|
|
oem_part_no |
TEXT(100) |
|
part_name |
TEXT(80) |
|
|
part_name |
TEXT(80) |
|
inventory_class_code |
TEXT(8) |
|
|
inv_class_code |
TEXT(8) |
|
part_use |
|
Not used |
|
|
|
|
mx_unique_key |
|
|
|
SELECT mx_key FROM opr_key_map_tab WHERE ifs_key = opr_part_tab.part_id AND table_name = 'opr_part_tab'; |
TEXT(200) |
Table in ADCOM (MM) |
Attribute |
Data type |
Usage in MM |
Table in CFGMGR (ATCM) |
Attribute |
Data Type |
av_part_group |
part_group_id |
|
|
opr_part_group_tab |
|
|
|
aircraft_type_code |
TEXT(8) |
|
|
assm_code |
TEXT(8) |
|
assembly_type_code |
TEXT(8) |
|
|
assm_code |
TEXT(8) |
|
config_slot_code |
TEXT(50) |
|
|
SELECT config_slot_code FROM opr_config_slot_tab WHERE config_slot_id = opr_part_group_tab.config_slot_id; |
TEXT(50) |
|
part_group_code |
TEXT(50) |
|
|
part_group_code |
TEXT(50) |
|
part_group_name |
TEXT(100) |
|
|
part_group_name |
TEXT(100) |
|
inventory_class_code |
TEXT(8) |
|
|
inv_class_code |
TEXT(8) |
|
part_quantity |
NUMBER |
|
|
quantity |
NUMBER |
|
applicability_range |
TEXT(4000) |
|
|
effectivity |
TEXT(4000) |
|
is_common_hardware |
Boolean |
|
|
|
|
|
conditions_desc |
TEXT(4000) |
|
|
condition |
TEXT(4000) |
|
mx_unique_key |
|
|
|
SELECT mx_key FROM opr_key_map_tab WHERE ifs_key = opr_part_group_tab.part_group_id AND table_name = 'opr_part_group_tab/part_group_key'; |
|
Table in ADCOM (MM) |
Attribute |
Data Type |
Usage in MM |
Table in CFGMGR (ATCM) |
Attribute |
Data Type |
av_part_group_part |
part_group_part_id |
|
|
opr_pg_part_tab |
|
|
|
part_group_id |
|
|
|
part_group_id |
NUMBER |
|
part_no_id |
|
|
|
part_id |
NUMBER |
|
is_standard |
Boolean |
|
|
is_standard |
TEXT(5) |
|
is_approved |
Boolean |
|
|
is_approved |
TEXT(5) |
|
mx_unique_key |
|
|
|
SELECT (mx_key || ':' || (SELECT mx_key FROM opr_key_map_tab WHERE (ifs_key = opr_pg_part_tab.part_group_id AND table_name = 'opr_part_group_tab/part_group_key'); |
TEXT(100) |
Table in ADCOM (MM) |
Attribute |
Data Type |
Usage in MM |
Table in CFGMGR |
Attribute |
Data Type |
av_config_slot |
config_slot_code |
TEXT(50) |
|
opr_config_slot_tab |
config_slot_code |
TEXT(50) |
|
assembly_type_code |
TEXT(8) |
|
|
assm_code |
TEXT(8) |
|
aircraft_type_code |
TEXT(8) |
|
|
assm_code |
TEXT(8) |
|
class_code |
TEXT(16) |
|
|
config_slot_class |
TEXT(8) |
|
parent_aircraft_type_code |
TEXT(16) |
|
|
assm_code |
TEXT(8) |
|
parent_config_slot_code |
TEXT(40) |
|
|
SELECT config_slot_code FROM opr_config_slot_tab WHERE config_slot_id = opr_config_slot_tab.parent_config_slot_id; |
TEXT(50) |
|
config_slot_status |
TEXT(8) |
not used |
|
|
|
|
config_slot_name |
TEXT(100) |
|
|
config_slot_name |
TEXT(100) |
|
is_mandatory |
Boolean |
|
|
is_mandatory |
Boolean |
|
number_of_positions |
|
not used |
|
|
|
Table in ADCOM (MM) |
Attribute |
Data Type |
Usage in MM |
Table in CFGMGR (ATCM) |
Attribute |
Data Type |
av_config_slot_position |
config_slot_position_id |
|
|
opr_positions_tab |
|
|
|
config_slot_code |
|
|
|
SELECT config_slot_code FROM opr_config_slot_tab WHERE config_slot_id = opr_positions_tab.config_slot_id; |
TEXT(50) |
|
aircraft_type_code |
|
|
|
SELECT assm_code FROM opr_config_slot_tab WHERE config_slot_id = opr_positions_tab.config_slot_id; |
TEXT(8) |
|
assembly_type_code |
|
|
|
SELECT assm_code FROM opr_config_slot_tab WHERE config_slot_id = opr_positions_tab.config_slot_id; |
TEXT(8) |
|
config_slot_position_code |
TEXT(200) |
|
|
position_code |
TEXT(200) |
|
mx_unique_key |
|
|
|
mx_unique_key |
TEXT(100) |
Table in ADCOM (MM) |
Attribute |
Data Type |
Usage in MM |
Table in CFGMGR (ATCM) |
Attribute |
Data Type |
av_aircraft_system |
system_id |
|
|
opr_system_tab |
|
|
|
aircraft_type_code |
TEXT(8) |
|
|
assm_code |
TEXT(8) |
|
assembly_type_code |
TEXT(8) |
|
|
assm_code |
TEXT(8) |
|
system_name |
TEXT(100) |
|
|
system_name |
TEXT(100) |
|
system_code |
TEXT(50) |
|
|
system_code |
TEXT(50) |
|
mx_unique_key |
|
|
|
mx_unique_key |
TEXT(100) |
Table in ADCOM (MM) |
Attribute |
Data Type |
Usage in MM |
Table in CFGMGR (ATCM) |
Attribute |
Data Type |
av_aircraft_subsystem |
sub_system_id |
|
|
opr_sub_system_tab |
|
|
|
sub_system_name |
TEXT(100) |
|
|
sub_system_name |
TEXT(100) |
|
sub_system_code |
TEXT(50) |
|
|
sub_system_code |
TEXT(50) |
|
system_id |
|
|
|
system_id |
NUMBER |
|
aircraft_type_code |
TEXT(8) |
|
|
assm_code |
TEXT(8) |
|
assembly_type_code |
TEXT(8) |
|
|
assm_code |
TEXT(8) |
|
mx_unique_key |
|
|
|
mx_unique_key |
TEXT(100) |
For more information on loading the configuration and running the migration job, see Prepare and Load Aircraft Configuration