Grant Attribute File
 Previous Top Next
The Grant Attribute File (files with extension ga.csv) contains information related to a individual grant attributes. The data identifies each Grant ID, the Attribute Name, and the Attribute Values for that Grant ID. 

For each Attribute Name being populated for an Grant, a separate row is required. 

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, Attribute Name, and Attribute Value.

If there is more than one record in the Grant Attribute file with the same Grant ID, Attribute Name, and Attribute Value 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.

To delete an attribute from an Grant Attribute File, the user will upload an Grant row with the Grant ID and the Attribute Name but no value for the Attribute Value.


File Format
#
Field Name
P=Required
Field Type
Sample Field
Description
1
GrantID
P
Alpha-Numeric (40)
1554
The unique identifier for each Grant.
2
AttributeName
P
Alpha-Numeric (20)
GrantClass
Identifies the AttributeName from the User Defined Lists Data File.
No quotation marks allowed
3
Attribute Value
P
Alpha-Numeric (40)
Class1
Identifies the value of the Attribute Name for a particular Optionee ID.
No quotation marks allowed

Examples
The fields in each row must be in the following sequence to load correctly:

GrantID, AttributeName, AttributeValue


The following is an example of a valid Grant Attribute File with information for three grants.

10001,GrantClass,Class1

10002,GrantClass,Class2

10008,GrantClass,Class1