Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

SGHE 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
ACADEMIC_PERIOD Academic period or time frame this person applied to study at this institution. VARCHAR2(6)

SGBSTDN

SGBSTDN_TERM_CODE_EFF

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

SORLCUR

SORLCUR_TERM_CODE_ADMIT

ACADEMIC_PERIOD_ADMITTED_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

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

ACADEMIC_PERIOD_MATRIC_DESC Academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

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

SOBCACT

SOBCACT_ACTIVE_IND

ACTIVITY_DATE Date record was inserted or updated. DATE

SORLCUR

SORLCUR_ACTIVITY_DATE

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

ADMISSIONS_POPULATION_DESC Admission population description. VARCHAR2(30)

STVADMT

STVADMT_DESC

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

FUNCTION

SOKODSF.F_CALCULATE_AGE_ADMIT

APPLICATION_CURRIC_SEQUENCE Sequence number of the application curriculum the learner curriculum was created from. NUMBER(4)

SORLCUR

SORLCUR_APPL_SEQNO

APPLICATION_NUMBER Application number the learner curriculum was created from. NUMBER(2)

SORLCUR

SORLCUR_APPL_KEY_SEQNO

CAMPUS Campus to which applicant is applying. VARCHAR2(3)

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(30)

STVCAMP

STVCAMP_DESC

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

SORLCUR

SORLCUR_TERM_CODE_CTLG

CATALOG_ACADEMIC_PERIOD_DESC Catalog academic period description. VARCHAR2(30)

STVTERM

STVTERM_DESC

COLLEGE College, faculty or school to which the academic study for the student is associated. VARCHAR2(2)

SORLCUR

SORLCUR_COLL_CODE

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

STVCOLL

STVCOLL_DESC

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

NA

SYSDATE

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_ACTIVITY_STATUS Identifies the student current status or activity within this curriculum. VARCHAR2(15)

SORLCUR

SORLCUR_CACT_CODE

CURRICULUM_ACTIVITY_STAT_DESC Curriculum activity status description. VARCHAR2(30)

STVCACT

STVCACT_DESC

CURRICULUM_PRIORITY Identifies the significanct ranking for a curricula. NUMBER(4)

SORLCUR

SORLCUR_PRIORITY_NO

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

SORLCUR

SORLCUR_SEQNO

DEGREE Degree or award code associated with the academic study. VARCHAR2(6)

SORLCUR

SORLCUR_DEGC_CODE

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

DEGREE_AWARD_CATEGORY_DESC Degree award category description. VARCHAR2(30)

STVACAT

STVACAT_DESC

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

STVDEGC

STVDEGC_DESC

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

NA

NA

END_DATE Date the student became inactive in this curriculum. DATE

SORLCUR

SORLCUR_END_DATE

EXPECTED_GRADUATION_DATE Expected graduation date. DATE

SORLCUR

SORLCUR_EXP_GRAD_DATE

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

SORLCUR

SORLCUR_TERM_CODE_GRAD

GRAD_ACAD_PERIOD_INTENDED_DESC Intended graduation term description. VARCHAR2(30)

STVTERM

STVTERM_DESC

GRAD_YEAR_INTENDED Intended year of graduation. VARCHAR2(4)

SORLCUR

SORLCUR_ACYR_CODE

GRAD_YEAR_INTENDED_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

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

STVTERM

STVTERM_DESC

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

SORLCUR

SORLCUR_TERM_CODE_END

LEAVE_DATE_FROM Start date of the student leave. DATE

SORLCUR

SORLCUR_LEAV_FROM_DATE

LEAVE_DATE_TO End date of the student leave. DATE

SORLCUR

SORLCUR_LEAV_TO_DATE

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

SORLCUR

SORLCUR_LEAV_CODE

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

STVLEAV

STVLEAV_DESC

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)

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

NA

NA

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

NA

NA

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

SORLCUR

SORLCUR_ROLLED_SEQNO

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

SORLCUR

SORLCUR_ROLL_IND

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

SORLCUR

SORLCUR_PIDM

PROGRAM Program or course of study for the student. This may be blank when programs are not being used to manage a set of completion requirements. VARCHAR2(12)

SORLCUR

SORLCUR_PROGRAM

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

SMRPRLE

SMRPRLE_PROGRAM_DESC

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

SORLCUR

SORLCUR_SITE_CODE

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

NA

NA

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

FUNCTION

SOKODSF.F_SITE

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

NA

NA

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

NA

NA

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

NA

NA

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

NA

NA

SITE_DESC Site or location name. VARCHAR2(30)

FUNCTION

SOKODSF.F_SITE

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

FUNCTION

SOKODSF.F_SITE

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

FUNCTION

SOKODSF.F_SITE

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

FUNCTION

SOKODSF.F_SITE

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

FUNCTION

SOKODSF.F_SITE

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

FUNCTION

SOKODSF.F_SITE

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

FUNCTION

SOKODSF.F_SITE

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

FUNCTION

SOKODSF.F_SITE

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

FUNCTION

SOKODSF.F_SITE

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

NA

NA

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

SORLCUR

SORLCUR_LMOD_CODE

SOURCE_DESC Student or learner source description. VARCHAR2(30)

STVLMOD

STVLMOD_DESC

SOURCE_SEQUENCE_NUMBER Sequence number of the source key record. NUMBER(2)

SORLCUR

SORLCUR_KEY_SEQNO

START_DATE Date the student became active in this curriculum. DATE

SORLCUR

SORLCUR_START_DATE

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

STVTERM

STVTERM_START_DATE

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_LEVEL Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(2)

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(30)

STVLEVL

STVLEVL_DESC

STUDENT_POPULATION Student population or type for reporting. May include populations like new freshman, transfer, continuing, etc. VARCHAR2(1)

SORLCUR

SORLCUR_STYP_CODE

STUDENT_POPULATION_DESC Student population or type description. VARCHAR2(30)

STVSTYP

STVSTYP_DESC

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

SORLCUR

SORLCUR_RATE_CODE

STUDENT_RATE_DESC Description for the rate code. VARCHAR2(30)

STVRATE

STVRATE_DESC

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

NA

NA

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

SUB_ACADEMIC_PERIOD_ADMIT_DESC Description of the session or part of the academic period associated with the session code. VARCHAR2(30)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(30)

NA

NA

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

NA

NA

SUB_ACAD_PERIOD_MATRIC_DESC Sub-academic period description. VARCHAR2(30)

NA

NA

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

SORLCUR

SORLCUR_USER_ID

YEAR_ADMITTED Academic year the student was admitted to this academic study. VARCHAR2(4)

STVTERM

STVTERM_ACYR_CODE

YEAR_ADMITTED_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

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

STVTERM

STVTERM_ACYR_CODE

YEAR_MATRICULATED_DESC Academic year description. VARCHAR2(30)

STVACYR

STVACYR_DESC

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

NA

NA



Ver: 8.1