ARRA TransactionType

The ARRA Information (ARRA) Transaction Type is provided so that the records can be routed through workflow for approvals before updates are made to the ARRA tables. The ARRAD transaction does not allow you to modify any existing ARRA table records. The transaction can only be used to enter new records, either on all associated ARRA tables at once, or on any “child” table after the “parent” records have been loaded to the transaction. Final ARRAD transactions cannot be modified and Final ARRAD transactions cannot be cancelled. All business rules associated with the ARRA tables apply to the ARRAD transaction.

The Load Existing Record action loads corresponding ARRA table records based on “key” fields.

Any values already in the transaction record are overwritten.
Upon selection of the Load Existing Record action, if the Record Type is blank, the transaction defaults the Record Type to Existing.
An error is received if the record cannot be located.

During Validate/Submit, for any record with a Record Type of Existing:

Advantage automatically attempts to load the most recent corresponding table record.
Any values already in the transaction record are overwritten (whether typed or previously loaded).
An error is received if the record cannot be located.
During Validate/Submit for any record with Record Type of New:
Advantage checks if a table record with the corresponding keys already exists and issues an error if it does.
Note: You cannot have a “child” record with a Record Type of Existing and a “parent” record with a Record Type of New. For example, you cannot have an “Existing” Recipient Quarterly record for a “New” Ongoing Award Information record.

ARRA Delivered Transaction Codes

The ARRA Transaction Type has the following Transaction Code (listed alphabetically by Transaction Name):

Transaction Name	Transaction Code	Intended Use
ARRA Information	ARRAD	This transaction allows you to enter new records on any of the ARRA tables.