ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_PERIOD	Academic period or time frame associated with this outcome or degree record.			SHRDGMR	SHRDGMR_TERM_CODE_STUREC
ACADEMIC_PERIOD_DESC	Academic period description.			FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_PERIOD_GRAD	Academic period when graduation requirements were or will be completed.			SHRDGMR	SHRDGMR_TERM_CODE_GRAD
ACADEMIC_PERIOD_GRAD_DESC	Academic period description.			FUNCTION	GOKODSF.F_GET_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
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
ADDRESS_RULE	Institution profile defined display rule determines which address displays for this person or entity. The display rule will exist on MGRSDAX with an internal group equal to ADDRESS and the institution defined internal code for government reporting of addresses.			MGRSDAX	MGRSDAX_INTERNAL_CODE
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
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
AWARD_CATEGORY	Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.			STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC	Award category description.			FUNCTION	GOKODSF.F_GET_DESC
BIRTH_DATE	Date of birth for the person.			SPBPERS	SPBPERS_BIRTH_DATE
CAMPUS	Campus to which applicant is applying.			SORLCUR	SORLCUR_CAMP_CODE
CAMPUS_DESC	Institution campus name.			FUNCTION	GOKODSF.F_GET_DESC
CITY	Address city, town or municipality.			SPRADDR	SPRADDR_CITY
COHORT1	Cohort tracking group assigned to the person through the Administrative UI display rules. When one of the internal codes defined under the internal group of CENSUS_FTE1 matchs one of the student cohort codes for the academic period, that student cohort will be used in this column.			SGRCHRT	SGRCHRT_CHRT_CODE
COHORT2	Cohort tracking group assigned to the person through the Administrative UI display rules. When one of the internal codes defined under the internal group of CENSUS_FTE2 matchs one of the student cohort codes for the academic period, that student cohort will be used in this column.			SGRCHRT	SGRCHRT_CHRT_CODE
COHORT3	Cohort tracking group assigned to the person through the Administrative UI display rules. When one of the internal codes defined under the internal group of CENSUS_FTE3 matchs one of the student cohort codes for the academic period, that student cohort will be used in this column.			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 that determines which cohort values are displayed for this person. Institution defined.			MGRSDAX	MGRSDAX_INTERNAL_CODE
COLLEGE	College, faculty or school to which the academic study for the student is associated.			SORLCUR	SORLCUR_COLL_CODE
COLLEGE_DESC	College, faculty or school name.			FUNCTION	GOKODSF.F_GET_DESC
COUNTY	County for this address.			SPRADDR	SPRADDR_CNTY_CODE
COUNTY_DESC	County name for the address.			FUNCTION	GOKODSF.F_GET_DESC
CREDITS_ATTEMPTED	Sum of credits attempted by a student for this academic outcome.			FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
CREDITS_EARNED	Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.			FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
CREDITS_PASSED	Sum of credits passed by a student for this academic outcome.			FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
DEGREE	Degree or award code associated with the academic study.			SHRDGMR SORLCUR	SHRDGMR_DEGC_CODE SORLCUR_DEGC_CODE
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.			FUNCTION	GOKODSF.F_GET_DESC
DEPARTMENT	Department responsible for the student's academic study.			SORLFOS	SORLFOS_DEPT_CODE
DEPARTMENT_DESC	Department name.			FUNCTION	GOKODSF.F_GET_DESC
EDUCATIONAL_GOAL	Educational goal recorded for the student.			SGBSTDN	SGBSTDN_EGOL_CODE
EDUCATIONAL_GOAL_DESC	Educational goal description.			STVEGOL	STVEGOL_DESC
EDUCATION_LEVEL	Highest level of education completed by the person.			SGBSTDN	SGBSTDN_EDLV_CODE
EDUCATION_LEVEL_DESC	Description of the highest level of education recorded for the person.			STVEDLV	STVEDLV_DESC
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
FIRST_CONCENTRATION	Concentration or study emphasis attached to the major for the student's academic study.			SORLFOS	SORLFOS_MAJR_CODE
FIRST_CONCENTRATION_DESC	Concentration or study emphasis description.			FUNCTION	GOKODSF.F_GET_DESC
FIRST_MINOR	Minor subject area of the person's academic study.			SORLFOS	SORLFOS_MAJR_CODE
FIRST_MINOR_DESC	Minor subject area description.			FUNCTION	GOKODSF.F_GET_DESC
FIRST_NAME	Person's first or given name.			SPRIDEN	SPRIDEN_FIRST_NAME
FOURTH_DEPARTMENT	Department responsible for the major or subject area of academic instruction.			SORLFOS	SORLFOS_DEPT_CODE
FOURTH_DEPARTMENT_DESC	Department Name.			FUNCTION	GOKODSF.F_GET_DESC
FOURTH_MAJOR	Subject area or major focus recorded for the student's academic study. This may be blank.			SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_1_DESC	Student's concentration description.			FUNCTION	GOKODSF.F_GET_DESC
FOURTH_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_2_DESC	Student's concentration description.			FUNCTION	GOKODSF.F_GET_DESC
FOURTH_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_3_DESC	Student's concentration description.			FUNCTION	GOKODSF.F_GET_DESC
FOURTH_MAJOR_DESC	Major or subject area of study description.			FUNCTION	GOKODSF.F_GET_DESC
FOURTH_MINOR	Fourth minor for the student within this academic study. This may be blank when no minor has been specified.			SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MINOR_DESC	Minor area of study description.			FUNCTION	GOKODSF.F_GET_DESC
FOURTH_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.			FUNCTION	GOKODSF.F_GET_DESC
FOURTH_PROGRAM_CLASSIF_DESC	Program classification code description.			FUNCTION	GOKODSF.F_GET_DESC
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')
GPA	Calculated grade point average or average for a set of courses completed.			FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
GPA_CREDITS	Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements.			FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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_NAME	Last name.			SPRIDEN	SPRIDEN_LAST_NAME
MAJOR	Major subject area of the person's academic study.			SORLFOS	SORLFOS_MAJR_CODE
MAJOR_DESC	Major subject area name for the person's academic study.			FUNCTION	GOKODSF.F_GET_DESC
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
NATION	Nation associated with the address.			SPRADDR	SPRADDR_NATN_CODE
NATION_DESC	Nation name associated with the address record.			STVNATN	STVNATN_NATION
NATION_OF_BIRTH	Person's nation of birth.			GOBINTL	GOBINTL_NATN_CODE_BIRTH
NATION_OF_BIRTH_DESC	Name of the person's nation of birth.			FUNCTION	GOKODSF.F_GET_DESC
OUTCOME_GRADUATION_DATE	Official date of graduation.			SHRDGMR	SHRDGMR_GRAD_DATE
OUTCOME_NUMBER	Academic outcome (degree or award) internal sequence number.			SHRDGMR	SHRDGMR_SEQ_NO
PERSON_UID	Internally generated by the system to uniquely identify the person or entity.			SHRDGMR	SHRDGMR_PIDM
POSTAL_CODE	Address postal or zip code.			SPRADDR	SPRADDR_ZIP
PRIMARY_ETHNICITY	Person's ethnicity.			SPBPERS	SPBPERS_ETHN_CODE
PRIMARY_ETHNICITY_DESC	Ethnic code description.			FUNCTION	GOKODSF.F_GET_DESC
PRIM_ETHNICITY_CATEGORY	Ethnic group used for governmental reporting.			STVETHN	STVETHN_ETCT_CODE
PRIM_ETHNICITY_CATEGORY_DESC	Ethnic category description as defined by the government reporting.			FUNCTION	GOKODSF.F_GET_DESC
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
PROGRAM	Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements.			SORLCUR	SORLCUR_PROGRAM
PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government.			FUNCTION	GOKODSF.F_GET_DESC
PROGRAM_CLASSIFICATION_DESC	Program classification description.			FUNCTION	GOKODSF.F_GET_DESC
PROGRAM_DESC	Person's program or course of study description.			FUNCTION	GOKODSF.F_GET_DESC
QUALITY_POINTS	Sum of the student's quality points for this academic outcome.			FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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
SECOND_CONCENTRATION	Concentration or study emphasis attached to the major for the student's academic study.			SORLFOS	SORLFOS_MAJR_CODE
SECOND_CONCENTRATION_DESC	Concentration or study emphasis description.			FUNCTION	GOKODSF.F_GET_DESC
SECOND_DEPARTMENT	Department responsible for the second major or subject area of academic instruction.			SORLFOS	SORLFOS_DEPT_CODE
SECOND_DEPARTMENT_DESC	Description for the second layer of the institution organization associated with a second major or subject area for this academic study.			FUNCTION	GOKODSF.F_GET_DESC
SECOND_MAJOR	Second major subject area or focus recorded for the student's academic study. This may be blank.			SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_1_DESC	Name for the first concentration of study or emphasis attached to the second major for the person.			FUNCTION	GOKODSF.F_GET_DESC
SECOND_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_2_DESC	Name for the second concentration of study or emphasis attached to the second major for the person.			FUNCTION	GOKODSF.F_GET_DESC
SECOND_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_3_DESC	Name for the third concentration of study or emphasis attached to the second major for the person.			FUNCTION	GOKODSF.F_GET_DESC
SECOND_MAJOR_DESC	Major area of study description.			FUNCTION	GOKODSF.F_GET_DESC
SECOND_MINOR	Second minor for the student within this academic study. This may be blank when no minor has been specified.			SORLFOS	SORLFOS_MAJR_CODE
SECOND_MINOR_DESC	Description for the second minor subject area of the person's academic study.			FUNCTION	GOKODSF.F_GET_DESC
SECOND_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.			FUNCTION	GOKODSF.F_GET_DESC
SECOND_PROGRAM_CLASSIF_DESC	Program classification code description.			FUNCTION	GOKODSF.F_GET_DESC
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
STATE_PROVINCE	State or province associated with this address.			SPRADDR	SPRADDR_STAT_CODE
STATE_PROVINCE_DESC	State or province name associated with the address record.			FUNCTION	GOKODSF.F_GET_DESC
STUDENT_LEVEL	Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc.			SORLCUR	SORLCUR_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.			FUNCTION	GOKODSF.F_GET_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.			NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.			NA	NA
THIRD_CONCENTRATION	Concentration or study emphasis attached to the major for the student's academic study.			SORLFOS	SORLFOS_MAJR_CODE
THIRD_CONCENTRATION_DESC	Concentration or study emphasis description.			FUNCTION	GOKODSF.F_GET_DESC
THIRD_DEPARTMENT	Department responsible for the major or subject area of academic instruction.			SORLFOS	SORLFOS_DEPT_CODE
THIRD_DEPARTMENT_DESC	Department name.			FUNCTION	GOKODSF.F_GET_DESC
THIRD_MAJOR	Subject area or major focus recorded for the student's academic study. This may be blank.			SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_1_DESC	Student's concentration description.			FUNCTION	GOKODSF.F_GET_DESC
THIRD_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_2_DESC	Student's concentration description.			FUNCTION	GOKODSF.F_GET_DESC
THIRD_MAJOR_CONC_3	Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.			SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_3_DESC	Student's concentration description.			FUNCTION	GOKODSF.F_GET_DESC
THIRD_MAJOR_DESC	Major or subject area of study description.			FUNCTION	GOKODSF.F_GET_DESC
THIRD_MINOR	Third minor for the student within this academic study. This may be blank when no minor has been specified.			SORLFOS	SORLFOS_MAJR_CODE
THIRD_MINOR_DESC	Minor area of study description.			FUNCTION	GOKODSF.F_GET_DESC
THIRD_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this academic outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting to the federal government.			FUNCTION	GOKODSF.F_GET_DESC
THIRD_PROGRAM_CLASSIF_DESC	Program classification code description.			FUNCTION	GOKODSF.F_GET_DESC

Ver: 8.3