Data Flow of External Awards to Student Award Tables

The following diagram shows a high-level flow of data.

Data flow of external awards to student award tables

Various data sources update the core set of External Award staging tables. After external award data or transactions update the staging tables, a separate External Award Load process is run to determine whether and how the external award data is to update the student award tables. The result of the External Award Load process updates the processing status field maintained for each external award transaction.