Use this format to import resource rates from outside MPM. You can create new or update existing resource rates. Importing resource rates will not replace existing resource rates in their entirety. Any resource rates not affected by the import file remain unchanged by the import.
Resource Code (type C) records must be imported before Resource Rate (type R) records in your import file.
The resource 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 resource 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 Resource Rates |
|
2* |
10 |
A |
Resource Code |
|
3* |
20 |
A |
Resource 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 $37.50 for January 2007 into Rate Table 1 for the ENGE resource.
R,ENGE,1,200701,37.5