Use this format to import burden rates from outside MPM. You can create new or update existing burden rates. Importing burden rates will not replace existing burden rates in their entirety. Any burden rates not affected by the import file remain unchanged by the import.
Burden Code (type C) records must be imported before Burden Rate (type R) records in your import file. The burden code being assigned a rate must already exist in the database. If it does not already exist, add a Type C record prior to the Type R record to create the burden code.
To successfully import your data, the import file has be in comma delimited ASCII file format.
In the table that follows, an * indicates a required field.
In the Type column:
A = alphanumeric
N = numeric
Y/N = Yes or No
For more information on the table, see Import File Formats Legend.
Field Position |
No. of Chars |
Type |
Field Content |
1* |
1 |
A |
Global Import type: enter R for Burden Rates |
2* |
10 |
A |
Burden Code |
3* |
20 |
A |
Burden Rate Table ID |
4* |
6 |
N |
Rate Period: enter the period for which this rate applies, in YYYYMM format. |
5 |
10 |
N |
Rate Amount |
Each record must contain four commas, one after each field except the last field (even those being left blank), and end with a carriage return.
This record imports a rate of 25.7% for January 2007 into Rate Table 1 for the EOH burden.
R,EOH,1,200701,25.7