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.
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 
|
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
|