Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Student Composite View Reports

Banner Operational Data Store
Composite View Target: AS_LEARNER_CURRICULUM_FOS

Description Source composite view contains all active and current curricula for all students identified in the Student module as well as all active and current fields of study for Major, Minor, and Concentrations.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
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(6)

SORLCUR

SORLCUR_TERM_CODE

NO

NO
ACADEMIC_PERIOD_ADMITTED This field identifies the academic period or term associated with the information on the academic study information record. VARCHAR2(6)

SORLCUR

SORLCUR_TERM_CODE_ADMIT

NO

NO
ACADEMIC_PERIOD_ADMITTED_DESC This field specifies the academic period or term associated with the academic period code. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
ACADEMIC_PERIOD_END This field identifies the ending academic period or term associated with the information on the academic study information record. VARCHAR2(6)

FUNCTION

SOKODSF.F_GET_END_SGBSTDN_TERM

NO

NO
ACADEMIC_PERIOD_MATRICULATED The matriculation term of the student. VARCHAR2(6)

SORLCUR

SORLCUR_TERM_CODE_MATRIC

NO

NO
ACADEMIC_PERIOD_MATRIC_DESC The description of the matriculation term. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
ACADEMIC_PERIOD_START This field identifies the starting academic period or term associated with the information on the academic study information record. VARCHAR2(6)

SGBSTDN

SGBSTDN_TERM_CODE_EFF

NO

NO
ACTIVITY_DATE Date record was inserted or updated. DATE

SORLCUR

SORLCUR_ACTIVITY_DATE

NO

NO
ADMISSIONS_POPULATION This field identifies the admission type of the applicant. VARCHAR2(2)

SORLCUR

SORLCUR_ADMT_CODE

NO

NO
ADMISSIONS_POPULATION_DESC This field specifies the admission type (e.g. early admit, mature, adult and continuing education, etc.) associated with the admission type code. VARCHAR2(30)

STVADMT

STVADMT_DESC

NO

NO
AGE_ADMITTED Age upon entry to institution. NUMBER

FUNCTION

SOKODSF.F_CALCULATE_AGE_ADMIT

NO

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

SORLCUR

SORLCUR_CAMP_CODE

NO

NO
CAMPUS_DESC The description of the curriculum campus. VARCHAR2(30)

STVCAMP

STVCAMP_DESC

NO

NO
CATALOG Curriculum Catalog Term. VARCHAR2(6)

SORLCUR

SORLCUR_TERM_CODE_CTLG

NO

NO
CATALOG_ACADEMIC_PERIOD_DESC The description of the curriculum catalog term. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

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

SORLCUR

SORLCUR_COLL_CODE

NO

NO
COLLEGE_DESC The description of the curriculum college . VARCHAR2(30)

STVCOLL

STVCOLL_DESC

NO

NO
CURRENT_DATE The current date. DATE

NA

SYSDATE

NO

NO
CURRICULUM_PRIORITY Identifies the significanct ranking for a curricula. NUMBER

SORLCUR

SORLCUR_PRIORITY_NO

NO

NO
CURRICULUM_SEQUENCE System generated one-up number assigned to a student or learner for a curriculum or curriculum changes. NUMBER

SORLCUR

SORLCUR_SEQNO

NO

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(6)

SORLCUR

SORLCUR_DEGC_CODE

NO

NO
DEGREE_AWARD_CATEGORY The degree award category. VARCHAR2(2)

STVDEGC

STVDEGC_ACAT_CODE

NO

NO
DEGREE_AWARD_CATEGORY_DESC The degree award category description. VARCHAR2(30)

STVACAT

STVACAT_DESC

NO

NO
DEGREE_DESC The description of the curriculum degree . VARCHAR2(30)

STVDEGC

STVDEGC_DESC

NO

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

SORLFOS

SORLFOS_DEPT_CODE

NO

NO
DEPARTMENT_DESC The description of the students department for the current curriculum. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

NO

NO
DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

NO

NO
END_DATE The date the curriculum ends. DATE

SORLCUR

SORLCUR_END_DATE

NO

NO
EXPECTED_GRADUATION_DATE The expected graduation date of the student. DATE

CALCULATION

NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)

NO

NO
FIRST_CONCENTRATION This field identifies the first concentration within the curriculum for the term. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FIRST_CONCENTRATION_DESC This field identifies the description of the first concentration within the curriculum for the term. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
FIRST_MINOR First minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FIRST_MINOR_DESC Minor area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_DEPARTMENT This field identifies the fourth department within the curriculum for the term. VARCHAR2(4)

SORLFOS

SORLFOS_DEPT_CODE

NO

NO
FOURTH_DEPARTMENT_DESC This field identifies the description of the fourth department within the curriculum for the term. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

NO

NO
FOURTH_MAJOR This field identifies the fourth major within the curriculum for the term. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MAJOR_CONC_1 Concentration 1 on fourth Major of Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MAJOR_CONC_1_DESC The description of the first concentration on fourth Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_MAJOR_CONC_2 Concentration 2 on fourth Major on Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MAJOR_CONC_2_DESC The description of the second concentration on fourth Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_MAJOR_CONC_3 Concentration 3 on fourth Major on Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MAJOR_CONC_3_DESC The description of the third concentration on fourth Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_MAJOR_DESC This field identifies the description of the fourth major within the curriculum for the term. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_MINOR Fourth minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
FOURTH_MINOR_DESC Minor area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
FOURTH_PROGRAM_CLASSIFICATION This identifies the Classification of Institutional Programs (CIP) code of the fourth major within the curriculum for the term. VARCHAR2(6)

STVMAJR

STVMAJR_CIPC_CODE

NO

NO
FOURTH_PROGRAM_CLASSIF_DESC This identifies the description of the Classification of Institutional Programs (CIP) code of the fourth major within the curriculum for the term. VARCHAR2(30)

STVCIPC

STVCIPC_DESC

NO

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

CALCULATION

NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)

NO

NO
GRAD_ACAD_PERIOD_INTENDED_DESC The description of the intended graduation term. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
GRAD_YEAR_INTENDED Intended year of graduation. VARCHAR2(4)

CALCULATION

NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)

NO

NO
GRAD_YEAR_INTENDED_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

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

FUNCTION

NVL(SORLCUR_TERM_CODE_END,'999999')

NO

NO
LEAVE_DATE_FROM Start date of the student leave. DATE

CALCULATION

NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)

NO

NO
LEAVE_DATE_TO Date the student leave is scheduled to or ends. DATE

CALCULATION

NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)

NO

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

CALCULATION

NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE)

NO

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

STVLEAV

STVLEAV_DESC

NO

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

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
MAJOR_DESC The description of the students major for the current curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
MAJOR_ELIG_FOR_AID_IND Indicates whether the student is eligible for financial aid based on their assigned major. VARCHAR2(1)

STVMAJR

STVMAJR_AID_ELIGIBILITY_IND

NO

NO
MATRICULATED_IND This is a Y or N field to indicate if the student is matriculated. VARCHAR2(1)

FUNCTION

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

NO

NO
MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

NO

NO
NON_TRADITIONAL_IND This field indicates whether this academic study is non-traditional. VARCHAR2(1)

NA

NA

NO

NO
OUTCOME_NUMBER The sequence number of the outcome created during the grade roll. NUMBER

SORLCUR

SORLCUR_ROLLED_SEQNO

NO

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

SORLCUR

SORLCUR_PIDM

NO

NO
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(12)

SORLCUR

SORLCUR_PROGRAM

NO

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

STVMAJR

STVMAJR_CIPC_CODE

NO

NO
PROGRAM_CLASSIFICATION_DESC This identifies the description of the Classification of Institutional Programs (CIP) code for the current curriculum. VARCHAR2(30)

STVCIPC

STVCIPC_DESC

NO

NO
PROGRAM_DESC Curriculum Program Description. VARCHAR2(30)

SMRPRLE

SMRPRLE_PROGRAM_DESC

NO

NO
PROGRAM_LEVEL Curriculum Level . VARCHAR2(2)

SORLCUR

SORLCUR_LEVL_CODE

NO

NO
PROGRAM_LEVEL_DESC The description of the curriculum level. VARCHAR2(30)

STVLEVL

STVLEVL_DESC

NO

NO
SECOND_CONCENTRATION This field identifies the second concentration within the curriculum for the term. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_CONCENTRATION_DESC This field identifies the description of the second concentration within the curriculum for the term. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_DEPARTMENT This field identifies the second department within the curriculum for the term. VARCHAR2(4)

SORLFOS

SORLFOS_DEPT_CODE

NO

NO
SECOND_DEPARTMENT_DESC This field identifies the description of the second department within the curriculum for the term. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

NO

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

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MAJOR_CONC_1 Concentration 1 on Second Major of Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MAJOR_CONC_1_DESC The description of the first concentration on Second Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_CONC_2 Concentration 2 on Second Major on Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MAJOR_CONC_2_DESC The description of the second concentration on Second Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_CONC_3 Concentration 3 on Second Major on Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MAJOR_CONC_3_DESC The description of the third concentration on Second Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MAJOR_DESC This field identifies the description of the second major within the curriculum for the term. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_MINOR Second minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
SECOND_MINOR_DESC Minor area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
SECOND_PROGRAM_CLASSIFICATION This identifies the Classification of Institutional Programs (CIP) code of the second major within the curriculum for the term. VARCHAR2(6)

STVMAJR

STVMAJR_CIPC_CODE

NO

NO
SECOND_PROGRAM_CLASSIF_DESC This identifies the description of the Classification of Institutional Programs (CIP) code of the second major within the curriculum for the term. VARCHAR2(30)

STVCIPC

STVCIPC_DESC

NO

NO
SITE The site code of the student for this term. VARCHAR2(3)

FUNCTION

NVL(SORLCUR_SITE_CODE, SGBSTDN_SITE_CODE)

NO

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

NA

NA

NO

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

STVSITE

STVSITE_CITY

NO

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

NA

NA

NO

NO
SITE_COUNTY_CODE County associated with the site address. VARCHAR2(5)

NA

NA

NO

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

NA

NA

NO

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

NA

NA

NO

NO
SITE_DESC Student's site or location description. VARCHAR2(30)

STVSITE

STVSITE_DESC

NO

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

STVSITE

STVSITE_NATION_CODE

NO

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

STVNATN

STVNATN_NATION

NO

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

STVSITE

STVSITE_ZIPC

NO

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

STVSITE

STVSITE_STATE

NO

NO
SITE_STATE_PROVINCE_DESC Name of the state/province. VARCHAR2(30)

STVSTAT

STVSTAT_DESC

NO

NO
SITE_STREET_LINE1 First line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR1

NO

NO
SITE_STREET_LINE2 Second line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR2

NO

NO
SITE_STREET_LINE3 Third line of the site address. VARCHAR2(255)

STVSITE

STVSITE_STREET_ADDR3

NO

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

NA

NA

NO

NO
SOURCE_SEQUENCE_NUMBER Sequence number of the source key record. NUMBER

SORLCUR

SORLCUR_KEY_SEQNO

NO

NO
START_DATE The date the curriculum starts. DATE

SORLCUR

SORLCUR_START_DATE

NO

NO
START_DATE_ADMITTED Non term based admissions field. Date you started studying. DATE

STVTERM

STVTERM_START_DATE

NO

NO
START_DATE_MATRICULATED The matriculation start date of the student. DATE

STVTERM

STVTERM_START_DATE

NO

NO
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(1)

FUNCTION

NVL(SORLCUR_STYP_CODE, SGBSTDN_STYP_CODE)

NO

NO
STUDENT_POPULATION_DESC This field specifies the student type (e.g. new freshman, transfer, continuing) associated with the student type code. VARCHAR2(30)

STVSTYP

STVSTYP_DESC

NO

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

CALCULATION

NVL(SORLCUR_RATE_CODE, SGBSTDN_RATE_CODE)

NO

NO
STUDENT_RATE_DESC Description for the rate code. VARCHAR2(30)

STVRATE

STVRATE_DESC

NO

NO
SUB_ACADEMIC_PERIOD_ADMITTED This field identifies the session or part of the academic period associated with the information on the academic study information record. VARCHAR2(3)

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_ADMIT_DESC This field specifies the session or part of the academic period associated with the session code. VARCHAR2(30)

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_MATRIC The matriculation sub academic period of the student. VARCHAR2(3)

NA

NA

NO

NO
SUB_ACAD_PERIOD_MATRIC_DESC The description of the sub academic period. VARCHAR2(30)

NA

NA

NO

NO
THIRD_CONCENTRATION This field identifies the third concentration within the curriculum for the term. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_CONCENTRATION_DESC This field identifies the description of the third concentration within the curriculum for the term. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_DEPARTMENT This field identifies the third department within the curriculum for the term. VARCHAR2(4)

SORLFOS

SORLFOS_DEPT_CODE

NO

NO
THIRD_DEPARTMENT_DESC This field identifies the description of the third department within the curriculum for the term. VARCHAR2(30)

STVDEPT

STVDEPT_DESC

NO

NO
THIRD_MAJOR This field identifies the third major within the curriculum for the term. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MAJOR_CONC_1 Concentration 1 on third Major of Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MAJOR_CONC_1_DESC The description of the first concentration on third Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_MAJOR_CONC_2 Concentration 2 on third Major on Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MAJOR_CONC_2_DESC The description of the second concentration on third Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_MAJOR_CONC_3 Concentration 3 on third Major on Curriculum. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MAJOR_CONC_3_DESC The description of the third concentration on third Major on Curriculum. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_MAJOR_DESC This field identifies the description of the third major within the curriculum for the term. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_MINOR Third minor for the student within this academic study. This may be blank when no minor has been specified. VARCHAR2(4)

SORLFOS

SORLFOS_MAJR_CODE

NO

NO
THIRD_MINOR_DESC Minor area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

NO

NO
THIRD_PROGRAM_CLASSIFICATION This identifies the Classification of Institutional Programs (CIP) code of the third major within the curriculum for the term. VARCHAR2(6)

STVMAJR

STVMAJR_CIPC_CODE

NO

NO
THIRD_PROGRAM_CLASSIF_DESC This identifies the description of the Classification of Institutional Programs (CIP) code of the third major within the curriculum for the term. VARCHAR2(30)

STVCIPC

STVCIPC_DESC

NO

NO
USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(30)

SORLCUR

SORLCUR_USER_ID

NO

NO
YEAR_ADMITTED This field identifies the academic year associated with the information on the academic study information record. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

NO

NO
YEAR_ADMITTED_DESC This field specifies the academic year associated with the academic year code. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

NO
YEAR_MATRICULATED The matriculation year of the student. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

NO

NO
YEAR_MATRICULATED_DESC The matriculation year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

NO
ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA

NO

NO


Ver: