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

Banner Operational Data Store
Reporting View Target: GOVERNMENT_ACADEMIC_OUTCOME

Description Contains the common data required for government reporting on the number of academic outcomes completed for the time frame. Contains only the academic period and person who have completed an academic study (award, degree, certificate, etc.). This reporting view may be joined with other reporting views for external and or internal report requirements.
Key & Frequency One row per person per academic period per outcome number per address rule.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
PERSON_UID, ACADEMIC_PERIOD, COHORT_RULE
ACADEMIC_PERIOD
PERSON_UID, OUTCOME_NUMBER
STUDENT_LEVEL
PROGRAM, MAJOR, PERSON_UID
COLLEGE, DEPARTMENT, PERSON_UID

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic Period Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year. VARCHAR2(63)

SHRDGMR

SHRDGMR_TERM_CODE_STUREC

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_PERIOD_GRAD Academic Period Graduate Academic period when graduation requirements were or will be completed. VARCHAR2(63)

SHRDGMR

SHRDGMR_TERM_CODE_GRAD

ACADEMIC_PERIOD_GRAD_DESC Academic Period Graduate Description Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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

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

ADDRESS_RULE 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. VARCHAR2(30)

MGRSDAX

MGRSDAX_INTERNAL_CODE

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

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

AWARD_CATEGORY Award Category Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc. VARCHAR2(63)

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC Award Category Description Award category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

BIRTH_DATE Birth Date Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

CAMPUS Campus Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc. VARCHAR2(63)

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC Campus Description Institution campus name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CITY City Address city, town or municipality. VARCHAR2(63)

SPRADDR

SPRADDR_CITY

COHORT1 Cohort 1 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. VARCHAR2(63)

SGRCHRT

SGRCHRT_CHRT_CODE

COHORT2 Cohort 2 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. VARCHAR2(63)

SGRCHRT

SGRCHRT_CHRT_CODE

COHORT3 Cohort 3 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. 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 that determines which cohort values are displayed for this person. Institution defined. VARCHAR2(63)

MGRSDAX

MGRSDAX_INTERNAL_CODE

COLLEGE College First level of the institution organization structure that owns the student or the academic instruction for a student course. VARCHAR2(63)

SORLCUR

SORLCUR_COLL_CODE

COLLEGE_DESC College Description College, faculty or school name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COUNTY County County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County Description County name for the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CREDITS_ATTEMPTED Credits Attempted Sum of credits attempted by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

CREDITS_EARNED 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. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

CREDITS_PASSED Credits Passed Sum of credits passed by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

DEGREE Degree Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_DEGC_CODE

SORLCUR_DEGC_CODE

DEGREE_DESC Degree Description Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DEPARTMENT Department Department responsible for the major subject area of a student course or associated with the major within the student academic study. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department Description Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EDUCATIONAL_GOAL Educational Goal Educational goal recorded for the student. VARCHAR2(63)

SGBSTDN

SGBSTDN_EGOL_CODE

EDUCATIONAL_GOAL_DESC Educational Goal Description Educational goal description. VARCHAR2(255)

STVEGOL

STVEGOL_DESC

EDUCATION_LEVEL Education Level Highest level of education completed by the person. VARCHAR2(63)

SGBSTDN

SGBSTDN_EDLV_CODE

EDUCATION_LEVEL_DESC Education Level Description Description of the highest level of education recorded for the person. VARCHAR2(255)

STVEDLV

STVEDLV_DESC

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

FIRST_CONCENTRATION First Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FIRST_CONCENTRATION_DESC First Concentration Description Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FIRST_MINOR First Minor Minor subject area of the person's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC First Minor Description Minor subject area description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SPRIDEN

SPRIDEN_FIRST_NAME

FOURTH_DEPARTMENT Fourth Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

FOURTH_DEPARTMENT_DESC Fourth Department Description Department Name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_MAJOR Fourth Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_1 Fourth Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_1_DESC Fourth Major Concentration 1 Description Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_MAJOR_CONC_2 Fourth Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_2_DESC Fourth Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_MAJOR_CONC_3 Fourth Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_3_DESC Fourth Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_MAJOR_DESC Fourth Major Description Major or subject area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_MINOR Fourth Minor Fourth minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MINOR_DESC Fourth Minor Description Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_PROGRAM_CLASSIFICATION 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. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_PROGRAM_CLASSIF_DESC Fourth Major Classification Description Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

GPA Grade Point Average or Average Calculated grade point average or average for a set of courses completed. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

GPA_CREDITS Credits used in Grade Point Average or Average Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

HISPANIC_LATINO_ETHNICITY_IND Hispanic Latino Ethnicity 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_CDE

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

INSTITUTION_CREDITS_ATTEMPTED Institution Credits Attempted Sum of institution course credits attempted by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_CREDITS_EARNED Institution Credits Earned Sum of institution course credits earned by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_CREDITS_PASSED Institution Credits Passed Sum of institution course credits passed by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_GPA Institution GPA - Grade Point Average or Average Calculated of institution course grade point average or average for the set of courses completed. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_GPA_CREDITS Institution GPA - Grade Point Average or Average Credits Sum of institution course credits used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

INSTITUTION_QUALITY_POINTS Institution Quality Points Sum of institution course quality points used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

LAST_NAME Last Name Last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

MAJOR Major Major subject area of the person's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

MAJOR_DESC Major Description Major subject area name for the person's academic study. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NATION Nation Nation associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_NATN_CODE

NATION_DESC Nation Description Nation name associated with the address record. VARCHAR2(255)

STVNATN

STVNATN_NATION

NATION_OF_BIRTH Nation Of Birth Person's nation of birth. VARCHAR2(63)

GOBINTL

GOBINTL_NATN_CODE_BIRTH

NATION_OF_BIRTH_DESC Nation Of Birth Description Name of the person's nation of birth. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

OUTCOME_GRADUATION_DATE Official Graduation Date Official date of graduation. DATE

SHRDGMR

SHRDGMR_GRAD_DATE

OUTCOME_NUMBER Outcome Number Academic outcome (degree or award) internal sequence number. NUMBER

SHRDGMR

SHRDGMR_SEQ_NO

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

SHRDGMR

SHRDGMR_PIDM

POSTAL_CODE Postal Code Address postal or zip code. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

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

SPBPERS

SPBPERS_ETHN_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

PRIM_ETHNICITY_CATEGORY Primary Ethnicity Category Ethnic group used for governmental reporting. VARCHAR2(63)

STVETHN

STVETHN_ETCT_CODE

PRIM_ETHNICITY_CATEGORY_DESC Primary Ethnicity Category Description Ethnic category description as defined by the government reporting. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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

PROGRAM Program Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes. VARCHAR2(63)

SORLCUR

SORLCUR_PROGRAM

PROGRAM_CLASSIFICATION Program Classification Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_CLASSIFICATION_DESC Program Classification Description Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_DESC Program Description Person's program or course of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

QUALITY_POINTS Quality Points Sum of the student's quality points for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

SECOND_CONCENTRATION Second Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_CONCENTRATION_DESC Second Concentration Description Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_DEPARTMENT Second Department Department responsible for the second major or subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Second Department Description Description for the second layer of the institution organization associated with a second major or subject area for this academic study. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR Second Major Major subject area of the person's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1 Second Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1_DESC Second Major Concentration 1 Description Name for the first concentration of study or emphasis attached to the second major for the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR_CONC_2 Second Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Second Major Concentration 2 Description Name for the second concentration of study or emphasis attached to the second major for the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR_CONC_3 Second Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Second Major Concentration 3 Description Name for the third concentration of study or emphasis attached to the second major for the person. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR_DESC Second Major Description Major area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MINOR Second Minor Second minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MINOR_DESC Second Minor Description Description for the second minor subject area of the person's academic study. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_PROGRAM_CLASSIFICATION 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. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_PROGRAM_CLASSIF_DESC Second Program Classification Description Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STATE_PROVINCE State Province State or province associated with this address. VARCHAR2(63)

SPRADDR

SPRADDR_STAT_CODE

STATE_PROVINCE_DESC State Province Description State or province name associated with the address record. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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)

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student Level Description Student level description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SUB_ACADEMIC_PERIOD Sub Academic Period A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub Academic Period Description Sub academic period description. VARCHAR2(255)

NA

NA

THIRD_CONCENTRATION Third Concentration Concentration or study emphasis attached to the major for the student's academic study. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_CONCENTRATION_DESC Third Concentration Description Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_DEPARTMENT Third Department Department responsible for the major or subject area of academic instruction. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

THIRD_DEPARTMENT_DESC Third Department Description Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_MAJOR Third Major Subject area or major focus recorded for the student's academic study. This may be blank. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_1 Third Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_1_DESC Third Major Concentration 1 Description Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_MAJOR_CONC_2 Third Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_2_DESC Third Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_MAJOR_CONC_3 Third Major Concentration 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. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_3_DESC Third Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_MAJOR_DESC Third Major Description Major or subject area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_MINOR Third Minor Third minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MINOR_DESC Third Minor Description Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_PROGRAM_CLASSIFICATION 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. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

THIRD_PROGRAM_CLASSIF_DESC Third Program Classification Description Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TRANSFER_CREDITS_ATTEMPTED Transfer Credits Attempted Sum of transfer course credits attempted by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_CREDITS_EARNED Transfer Credits Earned Sum of transfer course credits earned by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_CREDITS_PASSED Transfer Credits Passed Sum of transfer course credits passed by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_GPA Transfer GPA - Grade Point Average or Average Calculated of transfer course grade point average or average for the set of courses completed. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_GPA_CREDITS Transfer GPA - Grade Point Average or Average Credits Sum of transfer course credits used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

TRANSFER_QUALITY_POINTS Transfer Quality Points Sum of transfer course quality points used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA



Ver: 9.2