Regent Award Data View Data Dictionary

Current -- Release 6.9.1.0

Summary

The Regent Award Data View Data Dictionary contains a list of all data views currently available in Regent Award. 

For each Data View, there is a corresponding tab showing the view information. View information includes column names, types, lengths, and brief descriptions. 

Data Dictionary

The data dictionary for the latest, current release 6.9.1.0 can be downloaded here: 

  • The file contains only the latest, current version of each data view.

  • This file does not contain any prior versions (named "_v###"). 

For 2024-2025, the Student Aid Index (SAI) value is stored in the preexisting “Primary EFC” or “EFC” fields for ease of integrating with legacy systems. Many new fields, including the Provisional SAI, are added to the ISIR record data.

FTI/CUI Data Views

 The use of FTI information is limited to the determination of an applicant’s eligibility for federal student aid and the amount for which they are eligible and disclosure to state higher education agencies or designated scholarship organizations.

Schools that would like to have access to the FTI/CUI Data Views must work with their Account Manager or Project Manager. The updated views are not automatically provided as part of a release.

The FTI/CUI Data Views do not follow the standard schema. FTI/CUI Data Views include the CUI//SP-TAX label at the beginning and end of all FTI/CUI data per federal regulations.

 

The data dictionary for older versions (6.9.0.0 and earlier) is available here: 

For each older (legacy) version, the tab is named with the view name followed by the version number, for example, "_v###" on the end of the name.

There are a few exceptions to how the base view name is determined, compared to the names in 5.0.0.4 and later:



Base view name from the view name

Actual Base view name used (5.0.0.4 and later)

Base view name from the view name

Actual Base view name used (5.0.0.4 and later)

dataExtract_DisbursementSchedule_View

dataExtract_DisbursementSchedule_Config_View

dataExtract_FundFeesSetup_Config_View

dataExtract_FundFeeSetup_Config_View

dataExtract_FundGroupSetup_Config_View

dataExtract_FundGroup_Config_View

dataExtract_PackagingPhilosophySetup_Config_View

dataExtract_PackagingPhilosophy_Config_View





Date

Description of Change

Editor

Date

Description of Change

Editor

4/2/2024

Added FTI/CUI Data View information

Jen Dewey

12/18/24

Updated for 6.9.1

Heather Smith