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

Banner Operational Data Store
Composite View Target: AS_CURRICULUM_FOS

Description Source composite view contains all active and current curricula for all students identified in recruiting, admissions, and academic outcome 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
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

ACTIVITY_DATE Date record was inserted or updated. DATE

SORLCUR

SORLCUR_ACTIVITY_DATE

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

SORLCUR

SORLCUR_ADMT_CODE

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

ADMIT_IND This is a Y or N field to indicate if the student has been admitted to the institution for the associated term and level. VARCHAR2(1)

FUNCTION

F_LEVEL_ADMITTED_FNC

APPLICANT_IND This is a Y or N field to indicate if the student has applied for admissions for the associated term and level. VARCHAR2(1)

FUNCTION

F_LEVEL_APPL_FNC

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

STVDEGC

STVDEGC_ACAT_CODE

AWARD_CATEGORY_DESC The degree award category description. VARCHAR2(30)

STVACAT

STVACAT_DESC

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

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

STVCAMP

STVCAMP_DESC

CATALOG_ACADEMIC_PERIOD Curriculum Catalog Term . VARCHAR2(6)

SORLCUR

SORLCUR_TERM_CODE_CTLG

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

STVTERM

STVTERM_DESC

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

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

STVCOLL

STVCOLL_DESC

CONTINUING_EDUCATION_IND Indicates whether the course earns continuing education units instead of credits. VARCHAR2(1)

NA

NA

CURRENT_DATE The current date. DATE

NA

SYSDATE

CURRICULUM_PRIORITY Identifies the significanct ranking for a curricula. NUMBER

SORLCUR

SORLCUR_PRIORITY_NO

CURRICULUM_SEQUENCE Sequence number of key record. NUMBER

SORLCUR

SORLCUR_SEQNO

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

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

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

SORLFOS

SORLFOS_DEPT_CODE

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

STVDEPT

STVDEPT_DESC

DEPOSIT_IND This is a Y or N field to indicate if the student has paid an admissions deposit. VARCHAR2(1)

FUNCTION

F_PAID_ADMISSIONS_DEPOSIT

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

NA

NA

END_DATE The date the curriculum ends. DATE

SORLCUR

SORLCUR_END_DATE

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

FIRST_MINOR_DESC Minor area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

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

STVDEPT

STVDEPT_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

STVMAJR

STVMAJR_DESC

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

FOURTH_MINOR_DESC Minor area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

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

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

INQUIRER_IND This is a Y or N field to indicate if the student has any recruiting information. VARCHAR2(1)

FUNCTION

F_INQUIRER_FNC

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

SORLCUR

SORLCUR_TERM_CODE_END

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

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

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

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

NA

NA

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

SORLCUR

SORLCUR_PIDM

PRIMARY_PROGRAM_IND This field indicates whether this is your primary program of study. VARCHAR2(1)

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

SORLCUR

SORLCUR_PROGRAM

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

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

STVCIPC

STVCIPC_DESC

PROGRAM_DESC Curriculum Program Description. VARCHAR2(30)

SMRPRLE

SMRPRLE_PROGRAM_DESC

PROSPECT_IND This field is not currently used. VARCHAR2(1)

FUNCTION

F_PROSPECT_FNC

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

SORLFOS

SORLFOS_DEPT_CODE

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

STVDEPT

STVDEPT_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

STVMAJR

STVMAJR_DESC

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

SECOND_MINOR_DESC Minor area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

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

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

SOURCE The learner module code. VARCHAR2(15)

SORLCUR

SORLCUR_LMOD_CODE

SOURCE_SEQUENCE_NUMBER Sequence number of the source key record. NUMBER

SORLCUR

SORLCUR_KEY_SEQNO

START_DATE The date the curriculum starts. DATE

SORLCUR

SORLCUR_START_DATE

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

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC The description of the curriculum level. VARCHAR2(30)

STVLEVL

STVLEVL_DESC

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

SORLFOS

SORLFOS_DEPT_CODE

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

STVDEPT

STVDEPT_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

SORLFOS

SORLFOS_MAJR_CODE

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

STVMAJR

STVMAJR_DESC

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

STVMAJR

STVMAJR_DESC

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

THIRD_MINOR_DESC Minor area of study description. VARCHAR2(30)

STVMAJR

STVMAJR_DESC

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

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

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

SORLCUR

SORLCUR_USER_ID

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

NA

NA



Ver: