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

Banner Operational Data Store
Composite View Target: AS_CURRICULUM

Description Source composite view contains all active, inactive, current, and and non-current curricula for all students identified in recruiting, admissions, student and academic outcome.

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)

SGBSTDN

SGBSTDN_TERM_CODE_EFF

NO

NO
ACADEMIC_PERIOD_ADMITTED Academic period or time frame associated with the information on the student record. VARCHAR2(6)

SORLCUR

SORLCUR_TERM_CODE_ADMIT

NO

NO
ACADEMIC_PERIOD_ADMITTED_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

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

SORLCUR

SORLCUR_TERM_CODE_MATRIC

NO

NO
ACADEMIC_PERIOD_MATRIC_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

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

STVTERM

STVTERM_ACYR_CODE

NO

NO
ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

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

SOBCACT

SOBCACT_ACTIVE_IND

NO

NO
ACTIVITY_DATE Date record was inserted or updated. DATE

SORLCUR

SORLCUR_ACTIVITY_DATE

NO

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

SORLCUR

SORLCUR_ADMT_CODE

NO

NO
ADMISSIONS_POPULATION_DESC Admission population description. VARCHAR2(30)

STVADMT

STVADMT_DESC

NO

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

FUNCTION

SOKODSF.F_CALCULATE_AGE_ADMIT

NO

NO
APPLICATION_CURRIC_SEQUENCE Sequence number of the application curriculum the learner curriculum was created from. NUMBER

SORLCUR

SORLCUR_APPL_SEQNO

NO

NO
APPLICATION_NUMBER Application number the learner curriculum was created from. NUMBER

SORLCUR

SORLCUR_APPL_KEY_SEQNO

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 Institution campus name. VARCHAR2(30)

STVCAMP

STVCAMP_DESC

NO

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

SORLCUR

SORLCUR_TERM_CODE_CTLG

NO

NO
CATALOG_ACADEMIC_PERIOD_DESC Catalog academic period description. 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 College, faculty or school name. VARCHAR2(30)

STVCOLL

STVCOLL_DESC

NO

NO
CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

NO

NO
CURRENT_IND Indicates whether this is the most recent curriculum record for this academic period and curriculum sequence. VARCHAR2(1)

SORLCUR

SORLCUR_CURRENT_CDE

NO

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

SORLCUR

SORLCUR_CACT_CODE

NO

NO
CURRICULUM_ACTIVITY_STAT_DESC Curriculum activity status description. VARCHAR2(30)

STVCACT

STVCACT_DESC

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 Award category associated with the degree used for reporting by type of awards. Includes 2 year awards, 4 year, professional, etc. VARCHAR2(2)

STVDEGC

STVDEGC_ACAT_CODE

NO

NO
DEGREE_AWARD_CATEGORY_DESC Degree award category description. VARCHAR2(30)

STVACAT

STVACAT_DESC

NO

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

STVDEGC

STVDEGC_DESC

NO

NO
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

NO

NO
END_DATE Date the student became inactive in this curriculum. DATE

SORLCUR

SORLCUR_END_DATE

NO

NO
EXPECTED_GRADUATION_DATE Expected graduation date. DATE

SORLCUR

SORLCUR_EXP_GRAD_DATE

NO

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

SORLCUR

SORLCUR_TERM_CODE_GRAD

NO

NO
GRAD_ACAD_PERIOD_INTENDED_DESC Intended graduation term description. VARCHAR2(30)

STVTERM

STVTERM_DESC

NO

NO
GRAD_YEAR_INTENDED Intended year of graduation. VARCHAR2(4)

SORLCUR

SORLCUR_ACYR_CODE

NO

NO
GRAD_YEAR_INTENDED_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

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

STVTERM

STVTERM_DESC

NO

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

SORLCUR

SORLCUR_TERM_CODE_END

NO

NO
LEAVE_DATE_FROM Start date of the student leave. DATE

SORLCUR

SORLCUR_LEAV_FROM_DATE

NO

NO
LEAVE_DATE_TO End date of the student leave. DATE

SORLCUR

SORLCUR_LEAV_TO_DATE

NO

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

SORLCUR

SORLCUR_LEAV_CODE

NO

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

STVLEAV

STVLEAV_DESC

NO

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

NO

NO
MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

NO

NO
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

NO

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

SORLCUR

SORLCUR_ROLLED_SEQNO

NO

NO
OUTCOME_ROLL_IND Indicates if the learner curriculum should roll to academic history when courses are rolled. VARCHAR2(1)

SORLCUR

SORLCUR_ROLL_IND

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_DESC Program or course of study description. VARCHAR2(30)

SMRPRLE

SMRPRLE_PROGRAM_DESC

NO

NO
SITE Site or location to which applicant is applying. VARCHAR2(3)

SORLCUR

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

FUNCTION

SOKODSF.F_SITE

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 Site or location name. VARCHAR2(30)

FUNCTION

SOKODSF.F_SITE

NO

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

FUNCTION

SOKODSF.F_SITE

NO

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

FUNCTION

SOKODSF.F_SITE

NO

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

FUNCTION

SOKODSF.F_SITE

NO

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

FUNCTION

SOKODSF.F_SITE

NO

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

FUNCTION

SOKODSF.F_SITE

NO

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

FUNCTION

SOKODSF.F_SITE

NO

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

FUNCTION

SOKODSF.F_SITE

NO

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

FUNCTION

SOKODSF.F_SITE

NO

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

NA

NA

NO

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

SORLCUR

SORLCUR_LMOD_CODE

NO

NO
SOURCE_DESC Student or learner source description. VARCHAR2(30)

STVLMOD

STVLMOD_DESC

NO

NO
SOURCE_SEQUENCE_NUMBER Sequence number of the source key record. NUMBER

SORLCUR

SORLCUR_KEY_SEQNO

NO

NO
START_DATE Date the student became active in this curriculum. DATE

SORLCUR

SORLCUR_START_DATE

NO

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

STVTERM

STVTERM_START_DATE

NO

NO
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

NO

NO
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

NO

NO
STUDENT_LEVEL_DESC Student level description. VARCHAR2(30)

STVLEVL

STVLEVL_DESC

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)

SORLCUR

SORLCUR_STYP_CODE

NO

NO
STUDENT_POPULATION_DESC Student population or type description. 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)

SORLCUR

SORLCUR_RATE_CODE

NO

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

STVRATE

STVRATE_DESC

NO

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

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_ADMITTED 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 Description of the session or part of the academic period associated with the session code. VARCHAR2(30)

NA

NA

NO

NO
SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(30)

NA

NA

NO

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

NA

NA

NO

NO
SUB_ACAD_PERIOD_MATRIC_DESC Sub-academic period description. VARCHAR2(30)

NA

NA

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 Academic year the student was admitted to this academic study. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

NO

NO
YEAR_ADMITTED_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

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

STVTERM

STVTERM_ACYR_CODE

NO

NO
YEAR_MATRICULATED_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

NO

NO
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA

NO

NO


Ver: