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

FUNCTION

GOKODSF.F_GET_DESC

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

SHRDGMR

SHRDGMR_TERM_CODE_GRAD

ACADEMIC_PERIOD_GRAD_DESC Academic period description. VARCHAR2(255)

FUNCTION

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

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

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-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

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

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

FUNCTION

GOKODSF.F_GET_DESC

BIRTH_DATE Date of birth for the person. DATE

SPBPERS

SPBPERS_BIRTH_DATE

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 Institution campus name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

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

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

MGRSDAX

MGRSDAX_INTERNAL_CODE

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, faculty or school name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COUNTY County for this address. VARCHAR2(63)

SPRADDR

SPRADDR_CNTY_CODE

COUNTY_DESC County name for the address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 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 Sum of credits passed by a student for this academic outcome. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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 code description. For example, bachelor of business administration, master of arts, juris doctor, etc. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SGBSTDN_EGOL_CODE

EDUCATIONAL_GOAL_DESC Educational goal description. VARCHAR2(255)

STVEGOL

STVEGOL_DESC

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

SGBSTDN

SGBSTDN_EDLV_CODE

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

STVEDLV

STVEDLV_DESC

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

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 Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC Minor subject area description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SPRIDEN

SPRIDEN_FIRST_NAME

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

SORLFOS

SORLFOS_DEPT_CODE

FOURTH_DEPARTMENT_DESC Department Name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 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 Student's concentration description. VARCHAR2(255)

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

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

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

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

SORLFOS

SORLFOS_MAJR_CODE

FOURTH_MINOR_DESC Minor area of study description. VARCHAR2(255)

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

FUNCTION

GOKODSF.F_GET_DESC

FOURTH_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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_CDE

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 Sum of institution course credits attempted by a student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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 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 Sum of institution course credits used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

SPRIDEN

SPRIDEN_LAST_NAME

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

SORLFOS

SORLFOS_MAJR_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

NATION Nation associated with the address. VARCHAR2(63)

SPRADDR

SPRADDR_NATN_CODE

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

STVNATN

STVNATN_NATION

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

GOBINTL

GOBINTL_NATN_CODE_BIRTH

NATION_OF_BIRTH_DESC Name of the person's nation of birth. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

OUTCOME_GRADUATION_DATE Official date of graduation. DATE

SHRDGMR

SHRDGMR_GRAD_DATE

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

SHRDGMR

SHRDGMR_SEQ_NO

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

SHRDGMR

SHRDGMR_PIDM

POSTAL_CODE Address postal or zip code. VARCHAR2(63)

SPRADDR

SPRADDR_ZIP

PRIMARY_ETHNICITY Person's ethnicity. VARCHAR2(63)

SPBPERS

SPBPERS_ETHN_CODE

PRIMARY_ETHNICITY_DESC Ethnic code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVETHN

STVETHN_ETCT_CODE

PRIM_ETHNICITY_CATEGORY_DESC Ethnic category description as defined by the government reporting. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

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 Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

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

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

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

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

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

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR_DESC Major area of study description. VARCHAR2(255)

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

SORLFOS

SORLFOS_MAJR_CODE

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

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

FUNCTION

GOKODSF.F_GET_DESC

SECOND_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

SPRADDR

SPRADDR_STAT_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA

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 Concentration or study emphasis description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

THIRD_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 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 Student's concentration description. VARCHAR2(255)

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

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_2_DESC Student's concentration description. VARCHAR2(255)

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

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

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

SORLFOS

SORLFOS_MAJR_CODE

THIRD_MINOR_DESC Minor area of study description. VARCHAR2(255)

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

FUNCTION

GOKODSF.F_GET_DESC

THIRD_PROGRAM_CLASSIF_DESC Program classification code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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 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 Sum of transfer course credits used in the GPA calculations for this student. NUMBER

FUNCTION

SOKODSF.F_GET_DEGREE_GPA_DATA

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.1