Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Student Reporting View Reports

Banner Operational Data Store
Reporting View Target: FIELD_OF_STUDY

Description Audit trail of all fields of study assigned to a curricula for a student or learner.
Key & Frequency One row per occurrence of field of study per curricula per student or learner.
Recommended Search Columns PERSON_UID
PERSON_UID, SOURCE, ACADEMIC_PERIOD, SOURCE_SEQUENCE_NUMBER, CURRICULUM_PRIORITY, ACTIVE_IND
FIELD_OF_STUDY, FIELD_OF_STUDY_TYPE
PERSON_UID, FIELD_OF_STUDY_TYPE, PRIORITY, ACTIVE_IND

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

SORLFOS

SORLFOS_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

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

STVACYR

STVACYR_DESC

ACTIVE_IND Indicates whether the student is active in this field of study. VARCHAR2(1)

SOBCACT

SOBCACT_ACTIVE_IND

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

NA

NA

AID_ELIGIBILITY_IND Indicates the field of study is eligible for financial assistance or aid from the institution. VARCHAR2(1)

STVMAJR

STVMAJR_AID_ELIGIBILITY_IND

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

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

STVCAMP

STVCAMP_DESC

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

SORLFOS

SORLFOS_TERM_CODE_CTLG

CATALOG_ACADEMIC_PERIOD_DESC Catalog academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

SORLCUR

SORLCUR_COLL_CODE

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

STVCOLL

STVCOLL_DESC

CONCENTRATION_MAJOR Identifies the major subject area when the field of study type is a concentration. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE_ATTACH

CONCENTRATION_MAJOR_DESC Major subject area name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_IND Indicates whether this is the most recent field of study record for this academic period and curriculum sequrence. VARCHAR2(1)

SORLFOS

SORLFOS_CURRENT_CDE

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

SORLFOS

SORLFOS_TMST_CODE

CURRENT_TIME_STATUS_DESC Current time status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CURRICULUM_ACTIVE_IND Indicates whether the student is active in this curriculum. VARCHAR2(1)

SOBCACT

SOBCACT_ACTIVE_IND

CURRICULUM_ACTIVITY_STATUS Identifies the student current status or activity within this curriculum. VARCHAR2(63)

SORLFOS

SORLFOS_CACT_CODE

CURRICULUM_ACTIVITY_STAT_DESC Curriculum activity status description. VARCHAR2(255)

STVCACT

STVCACT_DESC

CURRICULUM_CHANGE_REASON Reason a curriculum was changed or new record created. For example, a curriculum may be denied, sought, inprogress, awarded, applied, etc. VARCHAR2(63)

SORLFOS

SORLFOS_CSTS_CODE

CURRICULUM_CHANGE_REASON_DESC Curriculum change reason description. VARCHAR2(255)

STVCSTS

STVCSTS_DESC

CURRICULUM_CURRENT_IND Indicates whether this is the most recent curriculum record for this academic period. VARCHAR2(1)

FUNCTION

SB_CURRICULUM.F_FIND_CURRENT_ALL_IND

CURRICULUM_PRIORITY Identifies the significanct ranking for a curricula. NUMBER

SORLCUR

SORLCUR_PRIORITY_NO

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

STVDEGC

STVDEGC_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

END_DATE Date the student became inactive in this field of study. DATE

SORLFOS

SORLFOS_END_DATE

EXPECTED_GRADUATION_DATE Expected graduation date. DATE

CALCULATION

NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)

FIELD_OF_STUDY Identifies the field of study, for example, major, concentration, minor within this record. VARCHAR2(63)

SORLCUR

SORLCUR_EXP_GRAD_DATE

FIELD_OF_STUDY_ACTIVITY_DESC Field of study activity status description. VARCHAR2(255)

STVCACT

STVCACT_DESC

FIELD_OF_STUDY_ACTIVITY_STATUS Identifies the student current status or activity within this field of study. VARCHAR2(63)

SORLFOS

SORLFOS_CACT_CODE

FIELD_OF_STUDY_DESC Field of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

FIELD_OF_STUDY_TYPE Type of field of study such as major, minor, concentration, vocational. VARCHAR2(63)

SORLFOS

SORLFOS_LFST_CODE

FIELD_OF_STUDY_TYPE_DESC Field of study type description. VARCHAR2(255)

GTVLFST

GTVLFST_DESC

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

SPRIDEN

SPRIDEN_ID

LAST_ACADEMIC_PERIOD_DESC Field of study last active academic period desc. VARCHAR2(255)

STVTERM

STVTERM_DESC

LAST_ACTIVE_ACADEMIC_PERIOD Field of study last active academic period. VARCHAR2(63)

SORLFOS

SORLFOS_TERM_CODE_END

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

NAME Combination of the person's last, first, and middle initial into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

OUTCOME_NUMBER Degree or award sequence number for this academic outcome for the student. NUMBER

SORLFOS

SORLFOS_ROLLED_SEQNO

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

SORLFOS

SORLFOS_PIDM

PRIORITY Identifies the significance within ranking this field of study for a curricula. NUMBER

SORLFOS

SORLFOS_PRIORITY_NO

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

NA

NA

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

SORLCUR

SORLCUR_PROGRAM

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

STVMAJR

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SMRPRLE

SMRPRLE_PROGRAM_DESC

SOURCE Administrative system source for this record. For example, recruiting, admissions, learner, academic outcome. VARCHAR2(63)

SORLCUR

SORLCUR_LMOD_CODE

SOURCE_DESC Student or learner source description. VARCHAR2(255)

STVLMOD

STVLMOD_DESC

SOURCE_SEQUENCE_NUMBER Sequence number of the source key record. NUMBER

SORLCUR

SORLCUR_KEY_SEQNO

START_DATE Date the student became active in this field of study. DATE

SORLFOS

SORLFOS_START_DATE

STUDENT_LEVEL Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(63)

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC



Ver: 9.1