Import Information
- The file to be imported must be in a comma delimited .csv format (Field Delimiter).
- If a data field within this file contains commas, it should be surrounded with "double quotes" (Text Delimiter).
- Line returns should be replaced with the pipe character '|'. (Usually found on the backslash key).
- Microsoft Excel is able to save using a.csv format that should match these requirements.
- RMS is able to determine whether the first record is a header record.
Field Order
Order | Field Name | Field Type | Required | Max Charaters | RMS Equivalent |
---|---|---|---|---|---|
1 | Legacy Res ID | Alpha Numeric | Y | 50 | Legacy Res ID |
2 | Date | Date | Y | 50 | Date Rate Applies |
3 | Total_Rate | Numeric | Y | Base Rate Amount | |
4 | Charge Type | Alpha Numeric | N | Rate Type |