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 Name Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD 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 Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic Year Description Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

RPRAWRD

RPRAWRD_ACCEPT_AMT

ACTIVITY1 Activity 1 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 2 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 3 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 4 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 5 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 Description 1 Activity code that represents the sport participation. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

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

FUNCTION

F_CALCULATE_AGE

AID_ENROLLMENT_PERIOD 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 Aid enrollment period description. VARCHAR2(255)

ROBPRDS

ROBPRDS_DESC

AID_PERIOD 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 Aid Period Description Financial Aid period description. VARCHAR2(255)

RTVAPRD

RTVAPRD_DESC

AID_YEAR 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 Aid Year Description Financial aid year name. VARCHAR2(255)

ROBINST

ROBINST_AIDY_DESC

ATHLETIC_AID_IND1 Athletic Aid Indicator 1 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 Athletic Aid Indicator 2 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 Athletic Aid Indicator 3 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 Athletic Aid Indicator 4 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 Athletic Aid Indicator 5 Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity. VARCHAR2(1)

SGRSPRT

SGRSPRT_ATHL_AID_IND

BIRTH_DATE Birth Date Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

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

SGRCHRT

SGRCHRT_CHRT_CODE

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

SGRCHRT

SGRCHRT_CHRT_CODE

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

SGRCHRT

SGRCHRT_CHRT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

COHORT_RULE 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 Decline Amount Total amount of this fund declined by the student's for this aid year. NUMBER

RPRAWRD

RPRAWRD_DECLINE_AMT

DISBURSED_AMT Disbursed Amount 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 Eligibility 1 Indicates eligibility to officially participate in this sport as identified in the display rules. VARCHAR2(63)

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGRSPRT

SGRSPRT_ELIG_CODE

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

SGRSPRT

SGRSPRT_ELIG_CODE

FINANCIAL_AID_TYPE 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 Financial aid type description. VARCHAR2(255)

RTVFTYP

RTVFTYP_DESC

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

SPRIDEN

SPRIDEN_FIRST_NAME

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

RPRADSB

RPRADSB_FUND_CODE

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

RFRBASE

RFRBASE_FSRC_CODE

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

RTVFSRC

RTVFSRC_DESC

FUND_TITLE Fund Title Descriptive title for the fund. VARCHAR2(255)

RFRBASE

RFRBASE_FUND_TITLE

GENDER Gender Identifies the gender of the person. VARCHAR2(63)

SPBPERS

SPBPERS_SEX

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

CALCULATION

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

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

SPBPERS

SPBPERS_GNDR_CODE

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

GTVGNDR

GTVGNDR_GNDR_DESC

HISPANIC_LATINO_ETHNICITY_IND Hispanic Latino Ethinicity Indicator 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 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 Last academic period the student attended the institution. VARCHAR2(63)

FUNCTION

MSKFUNC.F_GET_LAST_ACADEMIC_PERIOD

LAST_NAME Last Name Last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

MIDDLE_NAME Middle Name Middle name. VARCHAR2(63)

SPRIDEN

SPRIDEN_MI

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

NA

NA

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

NA

NA

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

RPRAWRD

RPRAWRD_OFFER_AMT

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

RPRAWRD

RPRAWRD_PAID_AMT

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

SPBPERS

SPBPERS_PPRN_CODE

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

GTVPPRN

GTVPPRN_PPRN_DESC

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

SGBSTDN

SGBSTDN_PIDM

PRIMARY_ETHNICITY Primary Ethnicity Person's reported ethnicity. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIMARY_ETHNICITY_DESC Primary Ethnicity Description Ethnic code description. VARCHAR2(255)

STVETHN

STVETHN_DESC

PRIM_ETHNICITY_CATEGORY Primary Ethnicity Person's reported ethnicity. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIM_ETHNICITY_CATEGORY_DESC Primary Ethnicity Description Ethnic Code Description. VARCHAR2(255)

STVETHN

STVETHN_DESC

PROCESS_GROUP 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 Race Category Count Number of unique regulatory races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE_CATEGORY

RACE_COUNT Race Count Number of races selected by this person. NUMBER

FUNCTION

MGKFUNC.F_COUNT_RACE

RACE_ETHNICITY_CONFIRM_DATE Race Ethnicity Confirm Date Race and ethnicity self confirmed date. DATE

SPBPERS

SPBPERS_CONFIRMED_RE_DATE

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

SPBPERS

SPBPERS_CONFIRMED_RE_CDE

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

SGRSPRT

SGRSPRT_SPST_CODE

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

SGRSPRT

SGRSPRT_SPST_CODE

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

SGRSPRT

SGRSPRT_SPST_CODE

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

SGRSPRT

SGRSPRT_SPST_CODE

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

SGRSPRT

SGRSPRT_SPST_CODE

SPORT_STATUS_DESC1 Sport Status Description 1 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC2 Sport Status Description 2 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC3 Sport Status Description 3 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC4 Sport Status Description 4 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SPORT_STATUS_DESC5 Sport Status Description 5 Student participation status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_ACADEMIC_PERIOD 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 Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

STUDENT_LEVEL 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 Student Level Description Level name associated with the academic study for which the student applied. For example, undergraduate, graduate, etc. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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

SPBPERS

SPBPERS_SSN

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

FUNCTION

F_GET_SUM_TOTAL_CREDITS_BY_AEP



Ver: 9.2