Schedule Assignment File
Previous Top Next


The Schedule Assignment File (files with extension sa.csv) contains information relating to Schedule settings that can be applied across different Schedule Codes.
The data identifies each Grant ID, Tranche ID, and Schedule Code. 


An Schedule Assignment record can be sent to change only one tranche assignment value.


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

If there is more than one record in the Schedule Assignment file with the same Grant ID, Tranche ID and Effective Date 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 single Schedule Assignment Line, you can add a record in an acceptable .CSV file format that contains only the Grant ID and Tranche 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
GrantID
P
Alpha-Numeric (40)
1554
Links to Grant information
2
TrancheID
P
Alpha-Numeric(20)
0001
The identifier of the Tranche within the Grant
3
 Schedule Code
P
Alpha-Numeric (20)
3343
This will serve as a code where groups of Grants can be assigned by TrancheID through a batch update process.



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


An example of valid lines in an Schedule File are as follows:
Grant004, 0001,3343
Grant005, 0002,4434