Publication Date: 3/13/2024 Share Print

Previous Topic

Next Topic

Book Contents

Book Index

Preparing the MPD File, via eMRO MPD Loader to Import

The Maintenance Planning Data (MPD) fields and its contents must meet specific standards in order for the data to load correctly into the system. Review and prepare the MPD excel file (.xlsx) provided by the aircraft manufacturer and arrange and modify the columns (fields) to meet the standards defined in the table below.

eMRO_V5_gold There are two different MPD import excel file templates that can be used. The selection of the 'Use EC Revision From File' checkbox (via the MPDLoader Import window) determines which template to use:

  1. If the checkbox is not selected (indicating the imported E/Cs are to adopt the Traxdoc revision number), use the template eMRO MPD Loader Template. This template does not include an 'EC_Revision' column.
  2. If the checkbox is selected (indicating that each imported E/C is to adopt a specific revision number), use the template eMRO MPD Loader Template (With EC REV). This template includes an 'EC_Revision' column where each individual E/C can be assigned a specific revision number.

 

Column

Column Name

Data Limitation

Fields Populated

Path

A

Rev

N/A

N/A

N/A

B

Sec

N/A

N/A

N/A

C

Task Number

- 25 character limit

- Line delimited allowed for multiple entries

Sub E/C (E/C Reference)

Engineering / Update / Engineering Control Selection / Engineering Control, General Tab

D eMRO_V5_gold

EC Revision

20 character limit

Revision

Engineering / Update / Engineering Control Selection / Engineering Control, General tab

E

Source Task Reference

N/A

N/A

N/A

F

Access

- 25 character limit

- Line delimited allowed for multiple entries

Task Card Panel

Engineering / Update/ Task Card Selection/ Task Card

G

Preparation

N/A

N/A

N/A

H

Zone

- 25 character limit

- Line delimited allowed for multiple entries

Task Card Zone

Engineering/ Update/ Task Card Selection/ Task Card

I

Description

250 character limit

E/C Description

Engineering/ Update/ Engineering Control Selection/ Engineering Control, General Tab

AND

Engineering/ Update/ Task Card Selection/ Task Card, General Tab

J

Skill Code

- 10 character limit

- one entry

Skill

Engineering/ Update/ Task Card Selection/ Task Card/ Task Card Item, Skills Tab

K

Task Code

- 8 character limit

- one entry

Category

Engineering/ Update/ Engineering Control Selection/ Engineering Control, General Tab

AND

Engineering/ Update/ Task Card Selection/ Task Card, General Tab

L

Sample Threshold

All data same as 100% Threshold (Column M)

If 100% Threshold is blank, data will be taken from this field

N/A

N/A

M

Sample Interval

All data same as 100% Interval (Column N)

If 100% Interval is blank, data will be taken from this field

N/A

N/A

N

100% Threshold

Line delimited allowed for multiple entries

Information entered as the following:

<time> <time type>

<time> = Numeric Digits

<time type> = 2 Character Code

YE = Year

DY = Day

MO = Month

FH = Flight Hour

CY = Cycle

First Schedule

Hours/Cycles/Days etc.

Engineering/ Update/ Engineering Control Selection/ Engineering Control, Schedule Tab

O

100% Interval

Line delimited allowed for multiple entries

Information entered as the following:

<time> <time type>

<time> = Numeric Digits

<time type> = 2 Character Code

YE = Year

DY = Day

MO = Month

FH = Flight Hour

CY = Cycle

Repeat Schedule

Hours/Cycles/Days etc.

Engineering/ Update/ Engineering Control Selection/ Engineering Control, Schedule Tab

P

Source Task Reference

N/A

N/A

N/A

Q

TCI

N/A

N/A

N/A

R

TPS

N/A

N/A

N/A

S

Reference

Note: This must be the original AMM reference, not the Task Card reference.

- 25 character limit

- Line delimited allowed for multiple entries

N/A

N/A

T

Men

2 digit limit

N/A

Engineering/ Update/ Task Card Selection/ Task Card/ Task Card Item, Skills Tab

U

Task M.H

- 6 digit limit

- 2 decimal place limit

- Line delimited allowed for multiple entries

Man Hours

(Access M.H. [Column U] and

Prep M.H. [Column V] will be added to this)

Engineering/ Update/ Task Card Selection/ Task Card/ Task Card Item, Skills Tab

V

Access M.H

- 7 digit limit

- 2 decimal place limit

- Line delimited allowed for multiple entries

Man Hours

(Will be added to Task M.H [Column T])

Engineering/ Update/ Task Card Selection/ Task Card/ Task Card Item, Skills Tab

W

Prep M.H.

- 8 digit limit

- 2 decimal place limit

- Line delimited allowed for multiple entries

Man Hours

(Will be added to Task M.H [Column T])

Engineering/ Update/ Task Card Selection/ Task Card/ Task Card Item, Skills Tab

X

Applic

 

- Line delimited allowed for multiple entries

- Aircraft Serial Number to be entered and must exist in the system

- 1,000 character limit

- must be set to = ALL. E/C and/or T/C will be effective to all A/C in the system

- When loading an MPD Revision, if an E/C is set up originally as a P/N E/C, but the MPD file has applicability against A/C, the system will override and remove the original P/N E/C Effectivity and assign it to the A/C specified. It is important that when this scenario is in effect, in order for the MPD Loader not to override the P/N E/Cs Effectivity, the file must be amended by removing the A/C Effectivity against the Engineering Controls set up as P/N E/Cs. When the A/C applicability is removed and left blank, the system will retain the original P/N E/C Effectivity.

Aircraft Effectivity

Engineering/ Update/ Engineering Control Selection/ Engineering Control/ A/C E/C Effectivity

AND

Engineering/ Update/ Task Card Selection/ Task Card/ T/C Effectivity

Y

rev count

N/A

N/A

N/A

Z

MPD rev

N/A

N/A

N/A

AA

Summary of Changes

N/A

N/A

N/A

See Also

MPD Loader to Import, via MPD Loader (MPDLDR)

Top of Page Publication Date: 3/13/2024 Share Print