RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Student Reporting View Reports

SGHE Operational Data Store
Reporting View Target: ACADEMIC_STUDY

Description Contains data for each curriculum/program, the student is considered active and permitted to enroll for the academic period. A student will have one record for each different academic study recorded for the person. All current and active curriculum records for an academic period will have a separate reporting row for ease of reporting. The field of study associated with the active curriculum will be included for up to four majors, each potentially having up to three associated concentrations. The curriculum may also display up to four associated minors. The student's primary curriculum for the academic period will be flagged with the PRIMARY_PROGRAM_IND set to Y.
Key & Frequency One row per person per academic period per curriculum.
Recommended Search Columns PERSON_UID
PERSON_UID,┐ACADEMIC_PERIOD
ACADEMIC_PERIOD
ACADEMIC_STANDING_END,┐ACADEMIC_PERIOD
ACADEMIC_PERIOD,┐STUDENT_CLASSIFICATION_BOAP
PERSON_UID,┐STUDENT_LEVEL,┐ACADEMIC_PERIOD
STUDENT_CLASSIFICATION,┐STUDENT_LEVEL,┐ACADEMIC_PERIOD
ACADEMIC_PERIOD,┐STUDENT_LEVEL
STUDENT_LEVEL
PERSON_UID,┐ACADEMIC_PERIOD,┐PRIMARY_PROGRAM_IND,┐PROGRAM_NUMBER
ACADEMIC_PERIOD,┐PRIMARY_PROGRAM_IND

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame associated with the information on the student record. VARCHAR2(63)

SGBSTDN

SGBSTDN_TERM_CODE_EFF

ACADEMIC_PERIOD_ADMITTED Academic period or time frame the student was admitted to this academic study VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_TERM_CODE_ADMIT

SORLCUR_TERM_CODE_ADMIT

ACADEMIC_PERIOD_ADMITTED_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_PERIOD_MATRICULATED Academic period or time frame in which the student was matriculated in this curriculum. The time period when they began formal study in this academic study. VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_TERM_CODE_MATRIC

SORLCUR_TERM_CODE_MATRIC

ACADEMIC_PERIOD_MATRIC_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_STANDING Academic standing or progress indicator for the student as determined at the beginning of the academic period before grades are assigned. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution. VARCHAR2(63)

SGBSTDN

SHRTTRM

STVASTD

SGBSTDN_ASTD_CODE

SHRTTRM_ASTD_CODE_END_OF_TERM

STVASTD_CODE

ACADEMIC_STANDING_ACAD_PERIOD Academic period or time frame when this academic standing code is valid for the student. VARCHAR2(63)

SGBSTDN

SGBSTDN_TERM_CODE_ASTD

ACADEMIC_STANDING_DESC Academic standing description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_STANDING_END Academic standing or progress indicator for the student as determined after the grades are processed for the academic period. Indicates the student may continue to enroll or must seek assistance prior to continuing to study at the institution. VARCHAR2(63)

SHRTTRM

SHRTTRM_ASTD_CODE_END_OF_TERM

ACADEMIC_STANDING_END_DATE Date that the academic standing no longer applies to the student. This may have been derived from the end date of the academic period for which the academic standing was applied as an override. DATE

SHRTTRM

SHRTTRM_ASTD_DATE_END_OF_TERM

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACAD_STANDING_ACAD_PERIOD_DESC Academic period description associated with the student academic standing. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACAD_STANDING_END_DESC Academic standing description. VARCHAR2(255)

STVASTD

STVASTD_DESC

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

NA

NA

ADMISSIONS_POPULATION Identifies an admission population such as early admit, mature, adult and continuing education, etc., associated with the person and application. VARCHAR2(63)

CALCULATION

SGBSTDN

DECODE(SORLCUR_ADMT_CODE)

SGBSTDN_ADMT_CODE

SGBSTDN_ADMT_CODE_2

ADMISSIONS_POPULATION_DESC Admission population description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ADVISOR_COUNT Count of current active advisors assigned to the student. NUMBER

FUNCTION

MSKFUNC.F_COUNT_ADVISORS

AGE_ADMITTED Calculated age of the person at the time of admission to the institution. NUMBER

FUNCTION

SOKODSF.F_CALCULATE_AGE_ADMIT

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

BLOCK_SCHEDULE Block schedule code assigned to the student. May be used by the institution to expedite the enrollment process to a block of sections or for reporting and identifying groups of students. VARCHAR2(63)

SGBSTDN

SGBSTDN_BLCK_CODE

BLOCK_SCHEDULE_DESC Description for the block schedule code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CAMPUS Campus associated with the student. VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_CAMP_CODE

SGBSTDN_CAMP_CODE_2

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CATALOG_ACADEMIC_PERIOD Catalog academic period used to measure completion requirements for the outcome. VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_TERM_CODE_CTLG_1

SGBSTDN_TERM_CODE_CTLG_2

SORLCUR_TERM_CODE_CTLG

CATALOG_ACADEMIC_PERIOD_DESC Catalog academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

COLLEGE College, faculty or school to which the academic study for the student is associated. VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_COLL_CODE_1

SGBSTDN_COLL_CODE_2

SORLCUR_COLL_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

COOPERATIVE_EDUCATION_IND Indicates that the student has work experience data in the database. VARCHAR2(1)

FUNCTION

MSKFUNC.F_CHECK_COOP_IND

CURRENT_TIME_STATUS System-calculated time status for the academic period based on institution defined rules. For example, full time, part time, etc. VARCHAR2(63)

SFBETRM

SFRTHST

SFBETRM_TMST_CODE

SFRTHST_TMST_CODE

CURRENT_TIME_STATUS_DATE Date the system-calculated time status for the academic period based on institution defined rules. For example, full time, part time, etc. DATE

SFBETRM

SFBETRM_TMST_CODE

SFBETRM_TMST_DATE

CURRENT_TIME_STATUS_DESC Current time status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CURRICULUM_PRIORITY_NUMBER Identifies the significanct ranking for a curricula. NUMBER

SORLCUR

SORLCUR_PRIORITY_NO

DEANS_LIST_DATE Date on which the Dean's List code was recorded. DATE

SHRTTRM

SHRTTRM_ASTD_DATE_DL

DEANS_LIST_DESC Student's dean's list code description. VARCHAR2(255)

STVASTD

STVASTD_DESC

DEANS_LIST_VALUE Identifies whether the student qualified for the dean's list this academic period. VARCHAR2(63)

SHRTTRM

SHRTTRM_ASTD_CODE_DL

DEGREE Degree or award code associated with the academic study. VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_DEGC_CODE_1

SGBSTDN_DEGC_CODE_2

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)

SGBSTDN

SORLFOS

SGBSTDN_DEPT_CODE

SGBSTDN_DEPT_CODE_2

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DUAL_DEGREE Identifies this as a dual degree. VARCHAR2(63)

SGBSTDN

SGBSTDN_DEGC_CODE_DUAL

DUAL_DEGREE_COLLEGE College associated with the dual degree. VARCHAR2(63)

SGBSTDN

SGBSTDN_COLL_CODE_DUAL

DUAL_DEGREE_COLLEGE_DESC College, faculty or school description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DUAL_DEGREE_DEPARTMENT Department associated with the dual degree. VARCHAR2(63)

SGBSTDN

SGBSTDN_DEPT_CODE_DUAL

DUAL_DEGREE_DEPARTMENT_DESC College, faculty or school description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DUAL_DEGREE_DESC Dual degree description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DUAL_DEGREE_LEVEL Level associated with the dual degree. VARCHAR2(63)

SGBSTDN

SGBSTDN_LEVL_CODE_DUAL

DUAL_DEGREE_LEVEL_DESC Student level description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DUAL_DEGREE_MAJOR Major associated with the dual degree. VARCHAR2(63)

SGBSTDN

SGBSTDN_MAJR_CODE_DUAL

DUAL_DEGREE_MAJOR_DESC Major or subject area description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DUAL_PROGRAM_CLASSIFICATION Program classification sometimes referred to as the Classification of Institutional Programs (CIP) code for reporting this academic study. VARCHAR2(63)

STVMAJR

STVMAJR_CIPC_CODE

DUAL_PROGRAM_CLASSIF_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ENROLLED_IND Indicates whether the student's enrollment status includes them in headcounts. VARCHAR2(1)

FUNCTION

F_ENROLLED_THIS_TERM

ENROLLMENT_ADD_DATE Date of the initial enrollment and course offering registration for this academic period. DATE

SFBETRM

SFBETRM_ADD_DATE

ENROLLMENT_STATUS Student's current enrollment status for this academic period. VARCHAR2(63)

SFBETRM

SFBETRM_ESTS_CODE

ENROLLMENT_STATUS_DATE Date for the last update to enrollment status. DATE

SFBETRM

SFBETRM_ESTS_DATE

ENROLLMENT_STATUS_DESC Student's enrollment status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EXPECTED_GRADUATION_DATE Expected graduation date. DATE

CALCULATION

SGBSTDN

NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)

SGBSTDN_EXP_GRAD_DATE

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

SGBSTDN_MAJR_CODE_CONC_2

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

SGBSTDN_MAJR_CODE_MINR_2

SORLFOS_MAJR_CODE

FIRST_MINOR_DESC Minor subject area description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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 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_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 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_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 outcome. This may be the Classification of Institutional Programs (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

FTE_DIVISOR Full time equivalency divisor. NUMBER

NA

NA

FTE_IND Indicates whether the student represents at least one FTE (full-time equivalent). VARCHAR2(1)

NA

NA

GRADUATED_IND Indicates whether the person has graduated or earned any academic outcomes to date. VARCHAR2(1)

FUNCTION

SOKODSF.F_CHECK_FOR_GRADUATE_IND

GRAD_ACADEMIC_PERIOD_INTENDED Intended academic period of graduation for the student. VARCHAR2(63)

CALCULATION

SGBSTDN

NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)

SGBSTDN_TERM_CODE_GRAD

GRAD_ACAD_PERIOD_INTENDED_DESC Intended graduation term description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

GRAD_YEAR_INTENDED Intended year of graduation. VARCHAR2(63)

CALCULATION

SGBSTDN

NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)

SGBSTDN_ACYR_CODE

GRAD_YEAR_INTENDED_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INTENDED_TIME_STATUS Student's intended time status. VARCHAR2(1)

SGBSTDN

SGBSTDN_FULL_PART_IND

LEAVE_DATE_FROM Date the student leave began. DATE

CALCULATION

SGBSTDN

NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)

SGBSTDN_LEAV_FROM_DATE

LEAVE_DATE_TO Date the student leave is schedule to or ends. DATE

CALCULATION

SGBSTDN

NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)

SGBSTDN_LEAV_TO_DATE

LEAVE_REASON Leave code of the student for this academic period. VARCHAR2(63)

CALCULATION

SGBSTDN

NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE)

SGBSTDN_LEAV_CODE

LEAVE_REASON_DESC Student's leave code description for this term. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_1

SGBSTDN_MAJR_CODE_2

SORLFOS_MAJR_CODE

MAJOR_DESC Name of the student's major subject area. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

MATRICULATED_IND Indicates whether the student has matriculated, and was formally admitted to a degree granting academic study or program. VARCHAR2(1)

CALCULATION

DECODE(SGBSTDN_TERM_CODE_MATRIC,NULL,'N','Y')

DECODE(SORLCUR_TERM_CODE_MATRIC)

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 for the record when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Name of the person (last name, first name middle initial). VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NEW_STUDENT_IND Indicates that this is the first academic period for the student and they are a new admit to the institution. VARCHAR2(1)

CALCULATION

DECODE(SGBSTDN_TERM_CODE_ADMIT)

DECODE(SORLCUR_TERM_CODE_ADMIT)

NON_TRADITIONAL_IND Indicates whether this academic study is non-traditional. VARCHAR2(63)

NA

NA

OUTCOME_AWARDED_IND Indicates that there is an academic outcome row for this academic study and academic period. VARCHAR2(63)

FUNCTION

MSKFUNC.F_GET_OUTCOME_AWARDED_IND

PERMIT_REGISTRATION Indicates whether the student is permitted to register for sections, or schedule offerings in this academic period. VARCHAR2(1)

STVSTST

STVSTST_REG_IND

PERSON_UID System generated, unique, internal identification number assigned to the person. NUMBER

SGBSTDN

SGBSTDN_PIDM

PRIMARY_ADVISOR_NAME_FMIL Advisor's current first name, middle name and last name. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRIMARY_ADVISOR_NAME_LFMI Advisor's current last name, first name middle initial. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRIMARY_ADVISOR_PERSON_UID System generated, unique, internal identification number assigned to the person. NUMBER

SGRADVR

SGRADVR_ADVR_PIDM

PRIMARY_ADVISOR_TYPE Primary advisor current advising assignment type. VARCHAR2(63)

SGRADVR

SGRADVR_ADVR_CODE

PRIMARY_ADVISOR_TYPE_DESC Advisor type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PRIMARY_PROGRAM_IND Indicates whether this is the student's primary academic study or program. VARCHAR2(1)

CALCULATION

CONSTANT

DECODE(SGBSTDN_LEVL_CODE,NULL,'N','Y')

DECODE(SORLCUR_LEVL_CODE,NULL,'N','Y')

'N'

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)

SGBSTDN

SORLCUR

SGBSTDN_PROGRAM_1

SGBSTDN_PROGRAM_2

SORLCUR_PROGRAM

PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting 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 Program or course of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PROGRAM_NUMBER Unique sequence number that identifies this academic study or program for the student. VARCHAR2(3)

CALCULATION

DECODE(SGBSTDN_LEVL_CODE,NULL,NULL,'01')

DECODE(SGBSTDN_LEVL_CODE_2,NULL,NULL,'02')

REGISTERED_IND Indicates whether the student is registered for the current academic period. VARCHAR2(1)

FUNCTION

F_REGISTERED_THIS_TERM

REGISTRATION_REASON Reason recorded for the student registration. May be the reason registered, or the reason the registration is withdrawn depending on the institution's definition. VARCHAR2(63)

SFBETRM

SFBETRM_RGRE_CODE

REGISTRATION_REASON_DESC Registration reason description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_1_2

SGBSTDN_MAJR_CODE_CONC_2_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 major or subject area of academic instruction. VARCHAR2(63)

SGBSTDN

SORLFOS

SGBSTDN_DEPT_CODE_1_2

SGBSTDN_DEPT_CODE_2_2

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MAJOR Second major or subject area for this academic study. VARCHAR2(63)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_1_2

SGBSTDN_MAJR_CODE_2_2

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1 First concentration or focus of study within this student's major. This may be blank if concentrations are not being used, or when this major does not have a concentration or emphasis. VARCHAR2(63)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_121

SGBSTDN_MAJR_CODE_CONC_221

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_1_DESC Student's concentration description. 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 if concentrations are not being used, or when this major does not have a concentration or emphasis. VARCHAR2(63)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_122

SGBSTDN_MAJR_CODE_CONC_222

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Student's concentration description. 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 if concentrations are not being used, or when this major does not have a concentration or emphasis. VARCHAR2(63)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_CONC_123

SGBSTDN_MAJR_CODE_CONC_223

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Student's concentration description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

SECOND_MINOR Second minor subject area of the person's academic study. VARCHAR2(63)

SGBSTDN

SORLFOS

SGBSTDN_MAJR_CODE_MINR_1_2

SGBSTDN_MAJR_CODE_MINR_2_2

SORLFOS_MAJR_CODE

SECOND_MINOR_DESC Minor area of study description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SECOND_PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (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

SITE Site or location where the student is attending or obtaining instruction. VARCHAR2(63)

CALCULATION

NVL(SORLCUR_SITE_CODE,SGBSTDN_SITE_CODE)

SITE_CARRIER_ROUTE Carrier route associated with the site address for barcode mailings. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SITE_CITY City, town or municipality associated with the site address. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SITE_CORRECTION_DIGIT Correction digit associated with the site address for barcode mailings. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SITE_COUNTY_CODE County associated with the site address. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SITE_COUNTY_CODE_DESC Descriptions of the county associated with the site address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SITE_DELIVERY_POINT Delivery point associated with the site address for barcode mailings. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SITE_DESC Site or location name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SITE_NATION Nation/country code associated with the site address. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SITE_NATION_DESC Description for the nation/country associated with the site address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SITE_POSTAL_CODE Postal code associated with the site address. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STATE_PROVINCE Identifies the state or province associated with this address. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STATE_PROVINCE_DESC Name of the state or province. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STREET_LINE1 First line of the site address. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STREET_LINE2 Second line of the site address. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STREET_LINE3 Third line of the site address. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

SITE_STREET_LINE4 Fourth line of the site address. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SPECIAL_EXAM_CREDIT Identifies that special examination credit was granted to the student in this academic period. VARCHAR2(63)

SHRTTRM

SHRTTRM_EXAM_CODE

SPECIAL_EXAM_DESC Special examination credit description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

START_DATE Date the student started studying. This is a non-term based field. DATE

SORLCUR

SORLCUR_START_DATE

START_DATE_ADMITTED Date the student began to study courses within this academic study. DATE

FUNCTION

GOKODSF.F_GET_DESC

START_DATE_MATRICULATED Date the student was official accepted or matriculated into this academic study. It may be individual for the person or taken from the start date for the academic period in which the person was matriculated. DATE

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_CLASSIFICATION Identifies the student classification (i.e. year in school) after grades have been processed for this academic period. For example, first year, second year or freshman, sophomore, etc. This may be the same value as the Student Classification BOAP or when appropriate be the value to begin the next academic period. VARCHAR2(63)

FUNCTION

F_CLASS_CALC_FNC

STUDENT_CLASSIFICATION_BOAP Identifies the student┐s classification (i.e. class or year in school) when the academic period begins, for example, first year, second year or freshman, sophomore, etc. This will be the same value as the Student Classification when the previous academic period ended. VARCHAR2(63)

FUNCTION

SGKCLAS.F_CLASS_CODE

STUDENT_CLASSIFICATION_DESC Student's classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_CLASS_BOAP_DESC Beginning of academic period student classification. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_FTE Identifies the portion of full time equated load the student is currently registered for in this academic study for this academic period. NUMBER

NA

NA

STUDENT_LEVEL Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63)

SGBSTDN

SORLCUR

SGBSTDN_LEVL_CODE

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_MEETING_TIME Student's normal attendance time. May be either day, evening, weekend, etc. VARCHAR2(63)

SGBSTDN

SGBSTDN_SESS_CODE

STUDENT_MEETING_TIME_DESC Student's meeting session description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_POPULATION Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc. VARCHAR2(63)

CALCULATION

SGBSTDN

NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE)

SGBSTDN_STYP_CODE

STUDENT_POPULATION_DESC Student population or type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_RATE Identifies any specific assessment rate to be used to determine the charges for this student. VARCHAR2(63)

CALCULATION

SGBSTDN

NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE)

SGBSTDN_RATE_CODE

STUDENT_RATE_DESC Description for the rate code. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_STATUS Student's current status for the academic period. May include active and permitted to register, inactive and stop registration, graduated, etc. VARCHAR2(63)

SGBSTDN

SGBSTDN_STST_CODE

STUDENT_STATUS_DESC Student's status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

NA

GOKODSF.F_GET_NULL_VARCHAR2

NA

SUB_ACADEMIC_PERIOD_ADMITTED Session or part of the academic period associated with the information on the academic study information record. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_ADMIT_DESC Description of the session or part of the academic period associated with the session code. VARCHAR2(255)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

FUNCTION

NA

GOKODSF.F_GET_NULL_VARCHAR2

NA

SUB_ACADEMIC_PERIOD_MATRIC Matriculation sub-academic period of the student. VARCHAR2(63)

NA

NA

SUB_ACAD_PERIOD_MATRIC_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

SGBSTDN_MAJR_CODE_CONC_2_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 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_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 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_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 outcome. This may be the Classification of Institutional Programs (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_CENTER Informational data defined by the institution to identify a transfer center. VARCHAR2(63)

SGBSTDN

SGBSTDN_TRCN_CODE

TRANSFER_CENTER_DESC Transfer center description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TRANSFER_TO_INSTITUTION Institution to which the student will transfer from this institution. VARCHAR2(63)

SHRTTRM

SHRTTRM_SBGI_CODE_TRANS

TRANSFER_TO_INSTITUTION_DESC Name of the institution the student plans to attend. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

WITHDRAWAL_REASON Reason for the student's withdrawal from this institution. Accepted elsewhere, financial difficulty, etc. VARCHAR2(63)

SHRTTRM

SHRTTRM_WRSN_CODE

WITHDRAWAL_REASON_DESC Reason for withdrawal description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

YEAR_ADMITTED Academic year the student was admitted to this academic study. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

YEAR_ADMITTED_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

YEAR_MATRICULATED Academic year the student matriculated to this academic study. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

YEAR_MATRICULATED_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC



Ver: 3.1