RETURN TO COMPOSITE VIEW REPORTS LIST
Student Composite View Reports

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

SORLCUR

SORLCUR_TERM_CODE

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)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

FUNCTION

STVTERM

GOKODSF.F_GET_DESC

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)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

STVTERM

GOKODSF.F_GET_DESC

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(30)

FUNCTION

STVACYR

GOKODSF.F_GET_DESC

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)

CALCULATION

NVL(SORLCUR_ADMT_CODE,SGBSTDN_ADMT_CODE)

ADMISSIONS_POPULATION_DESC Admission population description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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

SORLCUR

SORLCUR_APPL_SEQNO

APPLICATION_NUMBER Application number the learner curriculum was created from. NUMBER

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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

STVCOLL

GOKODSF.F_GET_DESC

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

GOKODSF.F_FIND_CURRENT_ALL_IND

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)

FUNCTION

STVCACT

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

DEGREE_AWARD_CATEGORY_DESC Degree award category description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

STVDEGC

GOKODSF.F_GET_DESC

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

CALCULATION

NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)

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

CALCULATION

NVL(SORLCUR_TERM_CODE_GRAD, SGBSTDN_TERM_CODE_GRAD)

GRAD_ACAD_PERIOD_INTENDED_DESC Intended graduation term description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

GRAD_YEAR_INTENDED Intended year of graduation. VARCHAR2(4)

CALCULATION

NVL(SORLCUR_ACYR_CODE, SGBSTDN_ACYR_CODE)

GRAD_YEAR_INTENDED_DESC Academic year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_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

CALCULATION

NVL(SORLCUR_LEAV_FROM_DATE, SGBSTDN_LEAV_FROM_DATE)

LEAVE_DATE_TO End date of the student leave. DATE

CALCULATION

NVL(SORLCUR_LEAV_TO_DATE, SGBSTDN_LEAV_TO_DATE)

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

CALCULATION

NVL(SORLCUR_LEAV_CODE, SGBSTDN_LEAV_CODE)

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

FUNCTION

GOKODSF.F_GET_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)

FUNCTION

GOKODSF.F_GET_DESC

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

CALCULATION

NVL(SORLCUR_SITE_CODE,SGBSTDN_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(20)

FUNCTION

STVSITE

GOKODSF.F_GET_DESC

STVSITE_CITY

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

GOKODSF.F_GET_DESC

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

FUNCTION

STVSITE

GOKODSF.F_GET_DESC

STVSITE_NATION_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

STVSITE

GOKODSF.F_GET_DESC

STVSITE_ZIPC

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

FUNCTION

STVSITE

GOKODSF.F_GET_DESC

STVSITE_STATE

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

STVSITE

GOKODSF.F_GET_DESC

STVSITE_STREET_ADDR1

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

FUNCTION

STVSITE

GOKODSF.F_GET_DESC

STVSITE_STREET_ADDR2

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

FUNCTION

STVSITE

GOKODSF.F_GET_DESC

STVSITE_STREET_ADDR3

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

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)

FUNCTION

STVLMOD

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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)

FUNCTION

STVLEVL

GOKODSF.F_GET_DESC

STVLEVL_DESC

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

CALCULATION

NVL(SORLCUR_STYP_CODE,SGBSTDN_STYP_CODE)

STUDENT_POPULATION_DESC Student population or type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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)

STUDENT_RATE_DESC Description for the rate code. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SUB_ACADEMIC_PERIOD_ADMITTED Session or part of the academic period associated with the information on the academic study information record. VARCHAR2(3)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

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

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

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

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

SUB_ACAD_PERIOD_MATRIC_DESC Sub-academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_NULL_VARCHAR2

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

FUNCTION

STVTERM

GOKODSF.F_GET_DESC

STVTERM_ACYR_CODE

YEAR_ADMITTED_DESC Academic year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

STVTERM

GOKODSF.F_GET_DESC

STVTERM_ACYR_CODE

YEAR_MATRICULATED_DESC Academic year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA



Ver: 3.1