Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE 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. Contain 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.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD
PERSON_UID, COHORT_RULE
ACADEMIC_PERIOD
PERSON_UID, STUDENT_LEVEL, ACADEMIC_PERIOD
STUDENT_LEVEL, ACADEMIC_PERIOD
ACADEMIC_PERIOD, STUDENT_LEVEL
PERSON_UID, OUTCOME_NUMBER
PROGRAM, MAJOR, PERSON_UID
COLLEGE, DEPARTMENT, PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame associated with this outcome or degree record. 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 Organization-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 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. 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 to which applicant is applying. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_CAMP_CODE

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 College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_COLL_CODE_1

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 Degree or award code associated with the academic study. 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 student's academic study. VARCHAR2(63)

SHRDGMR

SORLFOS

SHRDGMR_DEPT_CODE

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)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_1

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)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_MINR_1

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 Person's gender. Values are Male, Female or Not reported to the institution. 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')

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

SPBPERS

SPBPERS_ETHN_CODE

ID ID number given to the student to track their records at the institution. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

LAST_NAME Last name. VARCHAR2(63)

SPRIDEN

SPRIDEN_LAST_NAME

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_1

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

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

SHRDGMR

SORLCUR

SHRDGMR_PROGRAM

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

SHRDGMR

SORLFOS

SHRDGMR_MAJR_CODE_CONC_1_2

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)

SGBSTDN

SORLFOS

SGBSTDN_DEPT_CODE_2_2

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 Second major subject area or focus recorded for the student's academic study. This may be blank. VARCHAR2(63)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_1_2

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)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_2

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)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_2_2

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)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_2_3

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)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_MINR_1_2

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 Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63)

SHRDGMR

SORLCUR

SHRDGMR_LEVL_CODE

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)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_1_3

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



Ver: 8.0