Amortization Method File
 Previous Top Next
 
The Amortization Method File (files with extension am.csv) allows you to set an amortization method at the grant level.

Insertions and Modifications
Upload file can contain both new records, and updates to existing records.
A row is uniquely identified by the Grant ID.

If users want to specify a default amortization method for all grant IDs, then they will have to utilize the user interface on the Amortization Method page.

If there is more than one record in the Amortization Method file with the same Grant ID, the system will assume that the last record is supposed to update the previous record(s).  The previous record(s) will be lost and no validation error will be reported.


Deletions

To delete a record, you can add a record in an acceptable .CSV file format that contains only the Grant ID. Deletion records can be in the same file as insertion and modification records.

File Format

#
Field Name
P =Required
Field Type
Sample Field
Description
1
Grant ID
P
Alpha-Numeric (40)
2001EAH
A unique classification for each grant.
2
Amortization Method
P
List Selection
(Enumeration)
X
The amortization method for the Grant ID.
Must be G, R or S
Not case sensitive

Examples

To properly load, fields in each row of the file must be in the following sequence:

Grant ID, AmortizationMethod


An example of valid lines is as follows:

55647,G
2001EAH,R
3333BBB,S