| ODS Column |
ODS Business Definition |
ODS Calculation Formula |
ODS Data Type |
Banner Source Name |
Banner Source Column |
Banner Form Name |
|
ACADEMIC_PERIOD
|
Academic period representing the accounts receivable term for disbursement from the applicant award schedule table.
|
|
|
RPRATRM
|
RPRATRM_TERM_CODE
|
|
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
|
|
STVTERM
|
STVTERM_DESC
|
|
|
ACADEMIC_YEAR
|
Academic year associated with the academic period on this record.
|
|
|
STVTERM
|
STVTERM_ACYR_CODE
|
|
|
ACADEMIC_YEAR_DESC
|
Academic year description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ACCEPT_AMOUNT
|
Amount accepted by the student for the indicated financial aid fund for this aid year.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
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.
|
|
|
SGRSPRT
|
SGRSPRT_ACTC_CODE
|
|
|
ACTIVITY_DESC1
|
Activity code that represents the sport participation.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ACTIVITY_DESC2
|
Activity code that represents the sport participation.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ACTIVITY_DESC3
|
Activity code that represents the sport participation.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ACTIVITY_DESC4
|
Activity code that represents the sport participation.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ACTIVITY_DESC5
|
Activity code that represents the sport participation.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
ADMINISTRATIVE_GROUP
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
|
|
NA
|
NA
|
|
|
AGE
|
Calculated age (subtract the birth date from the current system date).
|
|
|
FUNCTION
|
F_CALCULATE_AGE
|
|
|
AID_ENROLLMENT_PERIOD
|
Aid enrollment period associated with the award schedule. This period can span multiple student terms.
|
|
|
RPRATRM
|
RPRATRM_PERIOD
|
|
|
AID_ENROLLMENT_PERIOD_DESC
|
Aid enrollment period description.
|
|
|
ROBPRDS
|
ROBPRDS_DESC
|
|
|
AID_PERIOD
|
Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.
|
|
|
RPRATRM
|
RPRATRM_AIDY_CODE
|
|
|
AID_PERIOD_DESC
|
Financial Aid period description.
|
|
|
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).
|
|
|
RPRAWRD
|
RPRAWRD_AIDY_CODE
|
|
|
AID_YEAR_DESC
|
Financial aid year name.
|
|
|
ROBINST
|
ROBINST_AIDY_DESC
|
|
|
ATHLETIC_AID_IND1
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
|
ATHLETIC_AID_IND2
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
|
ATHLETIC_AID_IND3
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
|
ATHLETIC_AID_IND4
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
|
ATHLETIC_AID_IND5
|
Indicates whether the person is receiving sport athletic scholarship or aid for this sport activity.
|
|
|
SGRSPRT
|
SGRSPRT_ATHL_AID_IND
|
|
|
BIRTH_DATE
|
Date of birth for the person.
|
|
|
SPBPERS
|
SPBPERS_BIRTH_DATE
|
|
|
COHORT1
|
Cohort tracking group assigned to the person through the Administrative UI display rules.
|
|
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
|
|
COHORT2
|
Cohort tracking group assigned to the person through the Administrative UI display rules.
|
|
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
|
|
COHORT3
|
Cohort tracking group assigned to the person through the Administrative UI display rules.
|
|
|
SGRCHRT
|
SGRCHRT_CHRT_CODE
|
|
|
COHORT_DESC1
|
Cohort tracking group description assigned to the person.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
COHORT_DESC2
|
Cohort tracking group description assigned to the person.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
COHORT_DESC3
|
Cohort tracking group description assigned to the person.
|
|
|
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.
|
|
|
MGRSDAX
|
MGRSDAX_INTERNAL_CODE
|
|
|
DECLINE_AMOUNT
|
Total amount of this fund declined by the student's for this aid year.
|
|
|
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.
|
|
|
FUNCTION FUNCTION
|
ROKODSF.F_CALCULATE_DISB_AMTS ROKODSF.F_GET_TOTAL_DISBURSED
|
|
|
ELIGIBILITY1
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
|
ELIGIBILITY2
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
|
ELIGIBILITY3
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
|
ELIGIBILITY4
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
|
ELIGIBILITY5
|
Indicates eligibility to officially participate in this sport as identified in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_ELIG_CODE
|
|
|
FINANCIAL_AID_TYPE
|
Identifies the type of financial assistance as either work, loan, scholarship or grant.
|
|
|
RFRBASE
|
RFRBASE_FTYP_CODE
|
|
|
FINANCIAL_AID_TYPE_DESC
|
Financial aid type description.
|
|
|
RTVFTYP
|
RTVFTYP_DESC
|
|
|
FIRST_NAME
|
Person's first or given name.
|
|
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
|
|
FUND
|
Financial Aid Fund code to be associated with information in this record.
|
|
|
RPRADSB
|
RPRADSB_FUND_CODE
|
|
|
FUND_SOURCE_TYPE
|
Identifies the source of the financial assistance.
|
|
|
RFRBASE
|
RFRBASE_FSRC_CODE
|
|
|
FUND_SOURCE_TYPE_DESC
|
Financial assistance sources descriptions. For example, External, Federal, Institutional, State or Other.
|
|
|
RTVFSRC
|
RTVFSRC_DESC
|
|
|
FUND_TITLE
|
Descriptive title for the fund.
|
|
|
RFRBASE
|
RFRBASE_FUND_TITLE
|
|
|
GENDER
|
Person's gender. Values are Male, Female or Not reported to the institution.
|
|
|
SPBPERS
|
SPBPERS_SEX
|
|
|
GENDER_DESC
|
Identify as Male, Female or Not reported.
|
|
|
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.
|
|
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
|
|
ID
|
ID number given to the student to track their records at the institution.
|
|
|
SPRIDEN
|
SPRIDEN_ID
|
|
|
LAST_ACADEMIC_PERIOD
|
Last academic period the student attended the institution.
|
|
|
FUNCTION
|
MSKFUNC.F_GET_LAST_ACADEMIC_PERIOD
|
|
|
LAST_NAME
|
Last name.
|
|
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
|
MIDDLE_NAME
|
Middle name.
|
|
|
SPRIDEN
|
SPRIDEN_MI
|
|
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
|
|
NA
|
NA
|
|
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
|
|
NA
|
NA
|
|
|
OFFER_AMOUNT
|
Maintains the current amount of the award fund offered.
|
|
|
RPRAWRD
|
RPRAWRD_OFFER_AMT
|
|
|
PAID_AMOUNT
|
Total amount offered and then paid from this fund.
|
|
|
RPRAWRD
|
RPRAWRD_PAID_AMT
|
|
|
PERSON_UID
|
Internally generated by the system to uniquely identify the person or entity.
|
|
|
SGBSTDN
|
SGBSTDN_PIDM
|
|
|
PRIMARY_ETHNICITY
|
Person's reported ethnicity.
|
|
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
|
|
PRIMARY_ETHNICITY_DESC
|
Ethnic code description.
|
|
|
STVETHN
|
STVETHN_DESC
|
|
|
PRIM_ETHNICITY_CATEGORY
|
Person's reported ethnicity.
|
|
|
SPBPERS
|
SPBPERS_ETHN_CODE
|
|
|
PRIM_ETHNICITY_CATEGORY_DESC
|
Ethnic Code Description
|
|
|
STVETHN
|
STVETHN_DESC
|
|
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
|
|
NA
|
NA
|
|
|
RACE_CATEGORY_COUNT
|
Number of unique regulatory races selected by this person.
|
|
|
FUNCTION
|
MGKFUNC.F_COUNT_RACE_CATEGORY
|
|
|
RACE_COUNT
|
Number of races selected by this person.
|
|
|
FUNCTION
|
MGKFUNC.F_COUNT_RACE
|
|
|
RACE_ETHNICITY_CONFIRM_DATE
|
Race and ethnicity self confirmed date.
|
|
|
SPBPERS
|
SPBPERS_CONFIRMED_RE_DATE
|
|
|
RACE_ETHNICITY_CONFIRM_IND
|
Indicates if the person's race and ethnicity have been self-identified.
|
|
|
SPBPERS
|
SPBPERS_CONFIRMED_RE_CDE
|
|
|
SPORT_STATUS1
|
Current status for the sport participation for the sport selected in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
|
SPORT_STATUS2
|
Current status for the sport participation for the sport selected in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
|
SPORT_STATUS3
|
Current status for the sport participation for the sport selected in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
|
SPORT_STATUS4
|
Current status for the sport participation for the sport selected in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
|
SPORT_STATUS5
|
Current status for the sport participation for the sport selected in the display rules.
|
|
|
SGRSPRT
|
SGRSPRT_SPST_CODE
|
|
|
SPORT_STATUS_DESC1
|
Student participation status description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
SPORT_STATUS_DESC2
|
Student participation status description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
SPORT_STATUS_DESC3
|
Student participation status description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
SPORT_STATUS_DESC4
|
Student participation status description.
|
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
|
SPORT_STATUS_DESC5
|
Student participation status description.
|
|
|
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.
|
|
|
RORPRDS
|
RORPRDS_TERM_CODE
|
|
|
STUDENT_ACADEMIC_PERIOD_DESC
|
Academic period description.
|
|
|
STVTERM
|
STVTERM_DESC
|
|
|
STUDENT_LEVEL
|
Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.
|
|
|
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.
|
|
|
STVLEVL
|
STVLEVL_DESC
|
|
|
TAX_ID
|
Person's tax identification number assigned by their home federal government.
|
|
|
SPBPERS
|
SPBPERS_SSN
|
|
|
TOTAL_CREDITS
|
Total credits for the student for this academic period.
|
|
|
FUNCTION
|
F_CALC_REGISTRATION_HOURS
|
|