Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Financial Aid Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: GOVERNMENT_FINANCIAL_AID

Description Contains common data identified for known governmental reporting regarding financial aid students. Detail data may include academic period, student level, financial aid fund title or name, fund source type, financial aid type, offerred amount, accepted amount, declined amount, paid amount, disbursed amount, etc.
Key & Frequency One row per aid year per academic period per fund per person.
Recommended Search Columns AID_YEAR, PERSON_UID, FUND, ACADEMIC_PERIOD
PERSON_UID, FUND, ACADEMIC_PERIOD
ACADEMIC_PERIOD
AID_YEAR, FUND
FUND
PERSON_UID, ACADEMIC_PERIOD
PERSON_UID, COHORT_RULE
PERSON_UID, AID_YEAR, FUND, ACADEMIC_PERIOD
PERSON_UID, STUDENT_LEVEL, ACADEMIC_PERIOD
STUDENT_LEVEL, ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_LEVEL

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period for the student. VARCHAR2(63)

RPRATRM

RPRATRM_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACCEPT_AMOUNT Amount accepted by the student for the indicated financial aid fund for this aid year. NUMBER

RPRAWRD

RPRAWRD_ACCEPT_AMT

ACTIVITY1 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY2 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY3 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY4 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY5 Activity code that represents official participation in a sport that was defined per the display rules for sport activities. Institution defined. VARCHAR2(63)

SGRSPRT

SGRSPRT_ACTC_CODE

ACTIVITY_DESC1 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC2 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC3 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC4 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC5 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

AGE Calculated age (subtract the birth date from the current system date). NUMBER

FUNCTION

F_CALCULATE_AGE

AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc. VARCHAR2(63)

RPRATRM

RPRATRM_AIDY_CODE

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(255)

RTVAPRD

RTVAPRD_DESC

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)

RPRAWRD

RPRAWRD_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

ATHLETIC_AID_IND1 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

ATHLETIC_AID_IND2 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

ATHLETIC_AID_IND3 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

ATHLETIC_AID_IND4 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

ATHLETIC_AID_IND5 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

BIRTH_DATE Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

COHORT1 Cohort tracking group assigned to the person through the Administrative UI display rules. VARCHAR2(63)

SGRCHRT

SGRCHRT_CHRT_CODE

COHORT2 Cohort tracking group assigned to the person through the Administrative UI display rules. VARCHAR2(63)

SGRCHRT

SGRCHRT_CHRT_CODE

COHORT3 Cohort tracking group assigned to the person through the Administrative UI display rules. VARCHAR2(63)

SGRCHRT

SGRCHRT_CHRT_CODE

COHORT_DESC1 Cohort tracking group description assigned to the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COHORT_DESC2 Cohort tracking group description assigned to the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COHORT_DESC3 Cohort tracking group description assigned to the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COHORT_RULE Display rule set up in MGRSDAX that determines which cohort values are displayed for this person. Institution defined. VARCHAR2(63)

MGRSDAX

MGRSDAX_INTERNAL_CODE

DECLINE_AMOUNT Total amount of this fund declined by the student's for this aid year. NUMBER

RPRAWRD

RPRAWRD_DECLINE_AMT

DISBURSED_AMT Financial aid award sum disbursed for the time frame with a fund source type indicator equal to federal, and a fund type indicator equal to grant. NUMBER

FUNCTION

ROKODSF.F_CALCULATE_DISB_AMTS

ELIGIBILITY1 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ELIGIBILITY2 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ELIGIBILITY3 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ELIGIBILITY4 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

ELIGIBILITY5 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

FINANCIAL_AID_TYPE Identifies the type of financial assistance as either work, loan, scholarship or grant. VARCHAR2(63)

RFRBASE

RFRBASE_FTYP_CODE

FINANCIAL_AID_TYPE_DESC Financial aid type description. VARCHAR2(255)

RTVFTYP

RTVFTYP_DESC

FIRST_NAME Person's first or given name. VARCHAR2(63)

SPRIDEN

SPRIDEN_FIRST_NAME

FUND Financial Aid Fund code to be associated with information in this record. VARCHAR2(63)

RPRADSB

RPRADSB_FUND_CODE

FUND_SOURCE_TYPE Identifies the source of the financial assistance. VARCHAR2(63)

RFRBASE

RFRBASE_FSRC_CODE

FUND_SOURCE_TYPE_DESC Financial assistance sources descriptions. For example, External, Federal, Institutional, State or Other. VARCHAR2(255)

RTVFSRC

RTVFSRC_DESC

FUND_TITLE Descriptive title for the fund. VARCHAR2(255)

RFRBASE

RFRBASE_FUND_TITLE

GENDER Person's gender. Values are Male, Female or Not reported to the institution. VARCHAR2(63)

SPBPERS

SPBPERS_SEX

GENDER_DESC Identify as Male, Female or Not reported. VARCHAR2(63)

CALCULATION

DECODE(SPBPERS_SEX,'M','MALE','F','FEMALE','N','NOT REPORTED')

HISPANIC_LATINO_ETHNICITY_IND Indicates if person's ethnicity is Latino or Hispanic. Due to mandated changes to the collection of race and ethnicity, these classifications were changed to separate Race and Ethnicity. Ethnicity can now be defined as either Hispanic or Latino, or Not Hispanic or Latino. VARCHAR2(1)

SPBPERS

SPBPERS_ETHN_CODE

ID ID number given to the student to track their records at the institution. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

LAST_ACADEMIC_PERIOD Last academic period the student attended the institution. VARCHAR2(63)

FUNCTION

MSKFUNC.F_GET_LAST_ACADEMIC_PERIOD

LAST_NAME Last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

MIDDLE_NAME Middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

OFFER_AMOUNT Maintains the current amount of the award fund offered. NUMBER

RPRAWRD

RPRAWRD_OFFER_AMT

PAID_AMOUNT Total amount offered and then paid from this fund. NUMBER

RPRAWRD

RPRAWRD_PAID_AMT

PERSON_UID Internally generated by the system to uniquely identify the person or entity. NUMBER

SGBSTDN

SGBSTDN_PIDM

PRIMARY_ETHNICITY Person's reported ethnicity. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIMARY_ETHNICITY_DESC Ethnic code description. VARCHAR2(255)

STVETHN

STVETHN_DESC

PRIM_ETHNICITY_CATEGORY Person's reported ethnicity. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIM_ETHNICITY_CATEGORY_DESC Ethnic Code Description VARCHAR2(255)

STVETHN

STVETHN_DESC

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

RACE_CATEGORY_COUNT Number of unique regulatory races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE_CATEGORY

RACE_COUNT Number of races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE

RACE_ETHNICITY_CONFIRM_DATE Race and ethnicity self confirmed date. DATE

SPBPERS

SPBPERS_CONFIRMED_RE_DATE

RACE_ETHNICITY_CONFIRM_IND Indicates if the person's race and ethnicity have been self-identified. VARCHAR2(1)

SPBPERS

SPBPERS_CONFIRMED_RE_CDE

SPORT_STATUS1 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS2 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS3 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS4 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS5 Current status for the sport participation for the sport selected in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS_DESC1 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC2 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC3 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC4 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC5 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_LEVEL Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_LEVL_CODE

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Level name associated with the academic study for which the student applied. For example, undergraduate, graduate, etc. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

TAX_ID Person's tax identification number assigned by their home federal government. VARCHAR2(63)

SPBPERS

SPBPERS_SSN

TOTAL_CREDITS Total credits for the student for this academic period. NUMBER

FUNCTION

F_CALC_REGISTRATION_HOURS



Ver: 8.0