Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

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 aid enrollment period, accounts receivable academic period, student academic period, student level, financial aid fund title or name, fund source type, financial aid type, offered amount, accepted amount, declined amount, paid amount, disbursed amount, etc.
Key & Frequency One row per aid year per aid enrollment period per fund per person.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
ACADEMIC_PERIOD
PERSON_UID, FUND, AID_ENROLLMENT_PERIOD
AID_ENROLLMENT_PERIOD
PERSON_UID, FUND, ACADEMIC_PERIOD
AID_YEAR
FUND, AID_YEAR
PERSON_UID, ACADEMIC_PERIOD, COHORT_RULE

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period representing the accounts receivable term for disbursement from the applicant award schedule table. 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 Administrative-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_ENROLLMENT_PERIOD Aid enrollment period associated with the award schedule. This period can span multiple student terms. VARCHAR2(63)

RPRATRM

RPRATRM_PERIOD

AID_ENROLLMENT_PERIOD_DESC Aid enrollment period description. VARCHAR2(255)

ROBPRDS

ROBPRDS_DESC

AID_PERIOD Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc. VARCHAR2(63)

RPRATRM

RPRATRM_AIDY_CODE

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(255)

RTVAPRD

RTVAPRD_DESC

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. 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_GET_TOTAL_DISBURSED

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 Aid fund type code defined as one of the following grant, loan, scholarship or grant for the aid fund. VARCHAR2(63)

RTVFTYP

RTVFTYP_ATYP_IND

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 Identifies the gender of the person. 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')

GENDER_DESIGNATION This gender identity of the person. VARCHAR2(63)

SPBPERS

SPBPERS_GNDR_CODE

GENDER_DESIGNATION_DESC The description of the gender identity. VARCHAR2(255)

GTVGNDR

GTVGNDR_GNDR_DESC

HISPANIC_LATINO_ETHNICITY_IND Indicates if person's ethnicity is Latino or Hispanic.This one ethnicity group was identified as a federal reporting group for ethnicity and race categories. VARCHAR2(1)

SPBPERS

SPBPERS_ETHN_CODE

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. 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

PERSONAL_PRONOUN The personal pronoun of the person. VARCHAR2(63)

SPBPERS

SPBPERS_PPRN_CODE

PERSONAL_PRONOUN_DESC The description of the personal pronoun. VARCHAR2(255)

GTVPPRN

GTVPPRN_PPRN_DESC

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_ACADEMIC_PERIOD Academic period representing the term to pull the student data used for the aid enrollment period. As an example, student classification, or student. VARCHAR2(63)

RORPRDS

RORPRDS_TERM_CODE

STUDENT_ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

STUDENT_LEVEL Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, 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_GET_SUM_TOTAL_CREDITS_BY_AEP



Ver: 9.1