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

Banner Operational Data Store
Reporting View Target: ACADEMIC_STUDY_EXTENDED

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 per defined term code.
Recommended Search Columns PERSON_UID, PRIMARY_PROGRAM_IND, PROGRAM_NUMBER

Target Column Business Name Business Definition Database Data Type Source Name Source Column
ACADEMIC_HISTORY_EXISTS_IND Academic History Exists Indicator Indicates whether the student has academic history information for the academic period. VARCHAR2(1)

FUNCTION

SOKODSF.F_CHECK_FOR_ACAD_HISTORY_DATA

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)

SGBSTDN

SGBSTDN_TERM_CODE_EFF

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

SORLCUR

SORLCUR_TERM_CODE_ADMIT

ACADEMIC_PERIOD_ADMITTED_DESC Academic Period Admitted Description Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

SORLCUR

SORLCUR_TERM_CODE_MATRIC

ACADEMIC_PERIOD_MATRIC_DESC Academic Period Matriculated Description Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACADEMIC_STANDING Academic Standing Academic standing 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)

FUNCTION

NVL(ACADEMIC_PERIOD,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_ACAD_PERIOD'')

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

FUNCTION

NVL(ACADEMIC_STANDING_DESC,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_DESC'')

ACADEMIC_STANDING_DATE Academic Standing Date Date the academic standing was applied to the student record. This may be derived from the end date of the academic period override or be the date the academic standing was assigned. DATE

FUNCTION

NVL(ACADEMIC_STANDING_DATE,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_DATE'')

ACADEMIC_STANDING_DESC Academic Standing Description Description for the academic standing value. VARCHAR2(255)

FUNCTION

STVASTD

NVL(ACADEMIC_STANDING_DESC,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''ACADEMIC_STANDING_DESC'')

STVASTD_DESC

ACADEMIC_STANDING_END 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 Academic Standing End Date Date that the academic standing no longer applies to the student. This may have been derived from the start date of the academic period for which the academic standing was applied as an override. DATE

SHRTTRM

SHRTTRM_ASTD_DATE_END_OF_TERM

ACADEMIC_STAND_OVERRIDE Academic Stand Override Identifies the academic standing at the end of the previous academic period has been overridden for the student. This override will be the academic standing value as of the academic period specified. VARCHAR2(63)

SGBSTDN

SGBSTDN_ASTD_CODE

ACADEMIC_STAND_OVERRIDE_DESC Academic Stand Override Description Description for the academic standing override value. VARCHAR2(255)

STVASTD

STVASTD_DESC

ACADEMIC_YEAR 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 Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVTERM

STVTERM_DESC

ACAD_STANDING_END_DESC Academic Standing End Description Academic standing description. VARCHAR2(255)

STVASTD

STVASTD_DESC

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

NA

NA

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

SORLCUR

SORLCUR_ADMT_CODE

ADMISSIONS_POPULATION_DESC Admissions Population Description Admission population description. VARCHAR2(255)

STVADMT

STVADMT_DESC

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

FUNCTION

MSKFUNC.F_COUNT_ADVISORS

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

FUNCTION

SOKODSF.F_CALCULATE_AGE_ADMIT

AID_ENROLLMENT_PERIOD Financial Aid Enrollment Period Aid enrollment period associated with the award schedule. This period can span multiple student terms. VARCHAR2(63)

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_ENROLLMENT_PERIOD_DESC Financial Aid Enrollment Period Description Aid enrollment period description. VARCHAR2(255)

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_YEAR Financial Aid Year Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

AID_YEAR_DESC Financial Aid Year Description Financial aid year name. VARCHAR2(255)

FUNCTION

MRKFUNC.F_GET_AID_ENROLL_PERIOD

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)

STVACAT

STVACAT_DESC

BLOCK_SCHEDULE 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 Block Schedule Description Description for the block schedule code. VARCHAR2(255)

STVBLCK

STVBLCK_DESC

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)

STVCAMP

STVCAMP_DESC

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

SORLCUR

SORLCUR_TERM_CODE_CTLG

CATALOG_ACADEMIC_PERIOD_DESC Catalog Academic Period Description Catalog academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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)

STVCOLL

STVCOLL_DESC

COMBINED_ACAD_STANDING Combined Academic Standing Combined academic standing for the student 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)

FUNCTION

NVL(COMBINED_ACAD_STANDING,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''COMBINED_ACAD_STANDING'')

COMBINED_ACAD_STANDING_DATE Combined Academic Standing Date Date the combined academic standing was applied to the student record. This may be derived from the start date of the academic period override or be the date the combined academic standing was assigned. DATE

FUNCTION

NVL(COMBINED_ACAD_STANDING_DATE,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''COMBINED_ACAD_STANDING_DATE'')

COMBINED_ACAD_STANDING_DESC Combined Academic Standing Description Description for the combined academic standing value. VARCHAR2(255)

FUNCTION

NVL(COMBINED_ACAD_STANDING_DESC,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''COMBINED_ACAD_STANDING_DESC'')

COMBINED_ACAD_STAND_END Combined Academic Stand End Identifies a student's combined academic standing at the end of the academic period (probation, good standing, etc). This will be the value assigned when grades were processed. VARCHAR2(63)

SHRTTRM

SHRTTRM_CAST_CODE

COMBINED_ACAD_STAND_END_DATE Combined Academic Stand End Date Date combined academic standing was calculated or entered at the end of the academic period. DATE

SHRTTRM

SHRTTRM_CAST_DATE

COMBINED_ACAD_STAND_END_DESC Combined Academic Stand End Description Description for the combined academic standing value. VARCHAR2(255)

STVCAST

STVCAST_DESC

COMB_ACAD_STAND_OVERRIDE Combined Academic Stand Override Identifies the combined academic standing at the end of the previous academic period has been overridden for the student. This override will be the combined academic standing value as of the academic period specified. VARCHAR2(63)

SGBSTDN

SGBSTDN_CAST_CODE

COMB_ACAD_STAND_OVERRIDE_DESC Combined Academic Stand Override Description Description for the combined academic standing override value. VARCHAR2(255)

STVCAST

STVCAST_DESC

COOPERATIVE_EDUCATION_IND Cooperative Education Indicator Indicates this is a cooperative education course. VARCHAR2(1)

FUNCTION

MSKFUNC.F_CHECK_COOP_IND

CURRENT_TIME_STATUS 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

SFBETRM_TMST_CODE

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

CURRENT_TIME_STATUS_DESC Current Time Status Description Current time status description. VARCHAR2(255)

FUNCTION

STVTMST

GOKODSF.F_GET_DESC

STVTMST_DESC

CURRICULUM_PRIORITY_NUMBER Curriculum Priority Number Identifies the significanct ranking for a curricula. NUMBER

SORLCUR

SORLCUR_PRIORITY_NO

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

SHRTTRM

SHRTTRM_ASTD_DATE_DL

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

STVASTD

STVASTD_DESC

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

SORLCUR

SORLCUR_DEGC_CODE

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

STVDEGC

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

STVDEPT

STVDEPT_DESC

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

SGBSTDN

SGBSTDN_DEGC_CODE_DUAL

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

SGBSTDN

SGBSTDN_COLL_CODE_DUAL

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

STVCOLL

STVCOLL_DESC

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

SGBSTDN

SGBSTDN_DEPT_CODE_DUAL

DUAL_DEGREE_DEPARTMENT_DESC Dual Degree Department Description College, faculty or school description. VARCHAR2(255)

STVDEPT

STVDEPT_DESC

DUAL_DEGREE_DESC Dual Degree Description Dual degree description. VARCHAR2(255)

STVDEGC

STVDEGC_DESC

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

SGBSTDN

SGBSTDN_LEVL_CODE_DUAL

DUAL_DEGREE_LEVEL_DESC Dual Degree Level Description Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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

SGBSTDN

SGBSTDN_MAJR_CODE_DUAL

DUAL_DEGREE_MAJOR_DESC Dual Degree Major Description Major or subject area description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

DUAL_PROGRAM_CLASSIFICATION 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 Dual Program Classification Description Program classification description. VARCHAR2(255)

STVCIPC

STVCIPC_DESC

ENROLLED_IND Enrolled Indicator Indicates whether the student has enrolled for the academic period identified by the student having a registration enrollment status that effects headcount. VARCHAR2(1)

FUNCTION

F_ENROLLED_THIS_TERM

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

SFBETRM

SFBETRM_ADD_DATE

ENROLLMENT_EXISTS_IND Enrollment Exists Indicator Indicates whether the student has current enrollment information for the academic period. VARCHAR2(1)

CALCULATION

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

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

SFBETRM

SFBETRM_ESTS_CODE

ENROLLMENT_STATUS_DATE Enrollment Status Date Date for the last update to enrollment status. DATE

SFBETRM

SFBETRM_ESTS_DATE

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

FUNCTION

GOKODSF.F_GET_DESC

EXPECTED_GRADUATION_DATE Expected Graduation Date Expected graduation date. DATE

CALCULATION

NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)

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)

STVMAJR

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

STVMAJR

STVMAJR_DESC

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)

STVDEPT

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

STVMAJR

STVMAJR_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 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 Fourth Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_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 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 Fourth Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

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

STVMAJR

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

STVMAJR

STVMAJR_DESC

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

STVMAJR

STVMAJR_CIPC_CODE

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

STVCIPC

STVCIPC_DESC

FTE_DIVISOR FTE - Full Time Equated Divisor Full time equivalency divisor. NUMBER

NA

NA

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

NA

NA

GRADUATED_IND Graduated Indicator 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 Graduate Academic Period Intended Intended academic period of graduation for the student. VARCHAR2(63)

CALCULATION

NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)

GRAD_ACAD_PERIOD_INTENDED_DESC Graduate Academic Period Intended Description Intended graduation term description. VARCHAR2(255)

STVTERM

STVTERM_DESC

GRAD_YEAR_INTENDED Graduate Year Intended Intended year of graduation. VARCHAR2(63)

CALCULATION

NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)

GRAD_YEAR_INTENDED_DESC Graduate Year Intended Description Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SGBSTDN

SGBSTDN_FULL_PART_IND

LEAVE_DATE_FROM Leave Date From Date the student leave began. DATE

CALCULATION

NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)

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

CALCULATION

NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)

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

CALCULATION

NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE)

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

STVLEAV

STVLEAV_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

CALCULATION

DECODE(SORLCUR_TERM_CODE_MATRIC)

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

CALCULATION

DECODE(SORLCUR_TERM_CODE_ADMIT)

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

NA

NA

OUTCOME_AWARDED_IND Outcome Awarded Indicator 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 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 Person UID System generated, unique, internal identification number assigned to the person. NUMBER

SGBSTDN

SGBSTDN_PIDM

PRIMARY_ADVISOR_NAME_FMIL Primary Advisor Name First, Middle Initial, Last Advisor's current first name, middle name and last name. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRIMARY_ADVISOR_NAME_LFMI Primary Advisor Name Last, First, Middle Initial Advisor's current last name, first name middle initial. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PRIMARY_ADVISOR_PERSON_UID Primary Advisor Person UID System generated, unique, internal identification number assigned to the person. NUMBER

SGRADVR

SGRADVR_ADVR_PIDM

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

SGRADVR

SGRADVR_ADVR_CODE

PRIMARY_ADVISOR_TYPE_DESC Primary Advisor Type Description Advisor type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

CASE PROGRAM_NUMBER WHEN 1 THEN 'Y' ELSE 'N' END

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)

STVMAJR

STVMAJR_CIPC_CODE

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

STVCIPC

STVCIPC_DESC

PROGRAM_DESC Program Description Program or course of study description. VARCHAR2(255)

SMRPRLE

SMRPRLE_PROGRAM_DESC

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

FUNCTION

ROW_NUMBER() OVER (PARTITION BY SORLCUR_PIDM, SGBSTDN_TERM_CODE_EFF ORDER BY SORLCUR_PRIORITY_NO)

PROGRESS_EVALUATION Progress Evaluation Progress evaluation for the student 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)

FUNCTION

NVL(PROGRESS_EVALUATION,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''PROGRESS_EVALUATION'')

PROGRESS_EVALUATION_DATE Progress Evaluation Date Date progress evaluation was overridden or entered for the academic period. DATE

FUNCTION

NVL(PROGRESS_EVALUATION_DATE,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''PROGRESS_EVALUATION_DATE'')

PROGRESS_EVALUATION_DESC Progress Evaluation Description Description for the progress evaluation value. VARCHAR2(255)

FUNCTION

NVL(PROGRESS_EVALUATION_DESC,MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_UID,ACADEMIC_PERIOD,PROGRAM_LEVEL,''PROGRESS_EVALUATION_DESC'')

PROGRESS_EVALUATION_END Progress Evaluation End Identifies a student's progress evaluation value at the end of the academic period (probation, good standing, etc). This will be the value assigned when grades were processed. VARCHAR2(63)

SHRTTRM

SHRTTRM_PREV_CODE

PROGRESS_EVALUATION_END_DATE Progress Evaluation End Date Date progress evaluation was calculated or entered at the end of the academic period. DATE

SHRTTRM

SHRTTRM_PREV_DATE

PROGRESS_EVALUATION_END_DESC Progress Evaluation End Description Description for the progress evaluation value. VARCHAR2(255)

STVPREV

STVPREV_DESC

PROGRESS_EVAL_OVERRIDE Progress Eval Override Identifies the progress evaluation at the end of the previous academic period has been overridden for the student. This override will be the progress evaluation value as of the academic period specified. VARCHAR2(63)

SGBSTDN

SGBSTDN_PREV_CODE

PROGRESS_EVAL_OVERRIDE_DESC Progress Eval Override Description Description for the progress evaluation override value. VARCHAR2(255)

STVPREV

STVPREV_DESC

REGISTERED_IND Registered Indicator Indicates the student is registered when there is at least one graded student course in institutional academic history or one student course in registration with a course registration status to be included as enrolled for the academic period. VARCHAR2(1)

FUNCTION

F_REGISTERED_THIS_TERM

REGISTRATION_REASON 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 Registration reason description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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)

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

SECOND_DEPARTMENT_DESC Second Department Description Department name. VARCHAR2(255)

STVDEPT

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

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_2 Second Major Concentration 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)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_2_DESC Second Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

SECOND_MAJOR_CONC_3 Second Major Concentration 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)

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MAJOR_CONC_3_DESC Second Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

SECOND_MINOR_DESC Second Minor Description Minor area of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

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

STVMAJR

STVMAJR_CIPC_CODE

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

STVCIPC

STVCIPC_DESC

SITE 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 Site Carrier Route Carrier route associated with the site address for barcode mailings. VARCHAR2(63)

NA

NA

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

STVSITE

STVSITE_CITY

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

NA

NA

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

NA

NA

SITE_COUNTY_CODE_DESC Site County Code Description Descriptions of the county associated with the site address. VARCHAR2(255)

NA

NA

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

NA

NA

SITE_DESC Site Description Site or location name. VARCHAR2(255)

STVSITE

STVSITE_DESC

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

STVSITE

STVSITE_NATION_CODE

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

STVNATN

STVNATN_NATION

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

STVSITE

STVSITE_ZIPC

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

STVSITE

STVSITE_STATE

SITE_STATE_PROVINCE_DESC Site State Province Description Name of the state or province. VARCHAR2(255)

STVSTAT

STVSTAT_DESC

SITE_STREET_LINE1 Site Street Line 1 First line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR1

SITE_STREET_LINE2 Site Street Line 2 Second line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR2

SITE_STREET_LINE3 Site Street Line 3 Third line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR3

SITE_STREET_LINE4 Site Street Line 4 Fourth line of the site address. VARCHAR2(255)

NA

NA

SPECIAL_EXAM_CREDIT 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 Exam Description Special examination credit description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLCUR

SORLCUR_START_DATE

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

STVTERM

STVTERM_START_DATE

START_DATE_MATRICULATED 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

STVTERM

STVTERM_START_DATE

STUDENT_CLASSIFICATION Student Classification Identifies the student's current class at the institution. The typical VALUES are first year, second year, or freshman, sophomore, etc.. VARCHAR2(63)

FUNCTION

F_CLASS_CALC_FNC

STUDENT_CLASSIFICATION_BOAP 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 Classification Description Student's classification description. VARCHAR2(255)

STVCLAS

STVCLAS_DESC

STUDENT_CLASS_BOAP_DESC Student Class Boap Description Beginning of academic period student classification. VARCHAR2(255)

STVCLAS

STVCLAS_DESC

STUDENT_FTE Student FTE - Full Time Equated 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 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

STUDENT_MEETING_TIME 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 Meeting Time Description Student's meeting session description. VARCHAR2(255)

STVSESS

STVSESS_DESC

STUDENT_POPULATION Student Population Identifies the category this student that will be used for governmental reporting. The typical VALUES are new first time, transfer, continuing, etc. VARCHAR2(63)

CALCULATION

NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE)

STUDENT_POPULATION_DESC Student Population Description Student population or type description. VARCHAR2(255)

STVSTYP

STVSTYP_DESC

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

CALCULATION

NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE)

STUDENT_RATE_DESC Student Rate Description Description for the rate code. VARCHAR2(255)

STVRATE

STVRATE_DESC

STUDENT_STATUS 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 Status Description Student's status description. VARCHAR2(255)

STVSTST

STVSTST_DESC

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

NA

NA

SUB_ACADEMIC_PERIOD_ADMITTED 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 Sub Academic Period Admitted Description 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 Sub academic period description. VARCHAR2(255)

NA

NA

SUB_ACADEMIC_PERIOD_MATRIC Sub Academic Period Matriculated Matriculation sub-academic period of the student. VARCHAR2(63)

NA

NA

SUB_ACAD_PERIOD_MATRIC_DESC Sub Academic Period Matriculated 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)

STVMAJR

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

STVDEPT

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

STVMAJR

STVMAJR_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 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 Third Major Concentration 2 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_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 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 Third Major Concentration 3 Description Student's concentration description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

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

STVMAJR

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

STVMAJR

STVMAJR_DESC

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

STVMAJR

STVMAJR_CIPC_CODE

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

STVCIPC

STVCIPC_DESC

TRANSFER_CENTER 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 Transfer center description. VARCHAR2(255)

STVTRCN

STVTRCN_DESC

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

SHRTTRM

SHRTTRM_SBGI_CODE_TRANS

TRANSFER_TO_INSTITUTION_DESC Transfer To Institution Description Name of the institution the student plans to attend. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

WITHDRAWAL_REASON Withdrawal Reason If the student withdraws for the institution this identifies the major reason for the student withdrawal defined by institution values. VARCHAR2(63)

SHRTTRM

SHRTTRM_WRSN_CODE

WITHDRAWAL_REASON_DESC Withdrawal Reason Description Reason for withdrawal description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

STVTERM

STVTERM_ACYR_CODE

YEAR_ADMITTED_DESC Year Admitted Description Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

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

STVTERM

STVTERM_ACYR_CODE

YEAR_MATRICULATED_DESC Year Matriculated Description Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC



Ver: 9.2