RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Operational Data Store
Reporting View Target: FIELD_OF_STUDY

Description Audit trail of all fields of study assigned to a curricula for a student or learner.
Key & Frequency One row per occurrence of field of study per curricula per student or learner.

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

SORLFOS

SORLFOS_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

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

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

STVACYR

STVACYR_DESC

ACTIVE_IND Indicates whether the student is active in this field of study. VARCHAR2(1)

SOBCACT

SOBCACT_ACTIVE_IND

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

NA

NA

AID_ELIGIBILITY_IND Indicates the field of study is eligible for financial assistance or aid from the institution. VARCHAR2(1)

STVMAJR

STVMAJR_AID_ELIGIBILITY_IND

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

SORLCUR

SORLCUR_CAMP_CODE

CAMPUS_DESC Institution campus name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_TERM_CODE_CTLG

CATALOG_ACADEMIC_PERIOD_DESC Catalog academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLCUR

SORLCUR_COLL_CODE

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

STVCOLL

STVCOLL_DESC

CONCENTRATION_MAJOR Identifies the major subject area when the field of study type is a concentration. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE_ATTACH

CONCENTRATION_MAJOR_DESC Major subject area name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_IND Indicates whether this is the most recent field of study record for this academic period. VARCHAR2(1)

FUNCTION

SB_FIELDOFSTUDY.F_FIND_CURRENT_ALL_IND

CURRENT_TIME_STATUS Time status for the academic period based on institution rules. For example, full time, part time, etc. VARCHAR2(63)

SORLFOS

SORLFOS_TMST_CODE

CURRENT_TIME_STATUS_DESC Current time status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SOBCACT

SOBCACT_ACTIVE_IND

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

SORLFOS

SORLFOS_CACT_CODE

CURRICULUM_ACTIVITY_STAT_DESC Curriculum activity status description. VARCHAR2(255)

STVCACT

STVCACT_DESC

CURRICULUM_CHANGE_REASON Reason a curriculum was changed or new record created. For example, a curriculum may be denied, sought, inprogress, awarded, applied, etc. VARCHAR2(63)

SORLFOS

SORLFOS_CSTS_CODE

CURRICULUM_CHANGE_REASON_DESC Curriculum change reason description. VARCHAR2(255)

STVCSTS

STVCSTS_DESC

CURRICULUM_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_PRIORITY Identifies the significanct ranking for a curricula. NUMBER

SORLCUR

SORLCUR_PRIORITY_NO

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

SORLCUR

SORLCUR_DEGC_CODE

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

STVDEGC

STVDEGC_DESC

DEPARTMENT Department associated with the field of study. VARCHAR2(63)

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

END_DATE Date the student became inactive in this field of study. DATE

SORLFOS

SORLFOS_END_DATE

EXPECTED_GRADUATION_DATE Expected graduation date. DATE

CALCULATION

NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)

FIELD_OF_STUDY Identifies the field of study, for example, major, concentration, minor within this record. VARCHAR2(63)

SORLFOS

SORLFOS_MAJR_CODE

FIELD_OF_STUDY_ACTIVITY_DESC Field of study activity status description. VARCHAR2(255)

STVCACT

STVCACT_DESC

FIELD_OF_STUDY_ACTIVITY_STATUS Identifies the student current status or activity within this field of study. VARCHAR2(63)

SORLFOS

SORLFOS_CACT_CODE

FIELD_OF_STUDY_DESC Field of study description. VARCHAR2(255)

STVMAJR

STVMAJR_DESC

FIELD_OF_STUDY_TYPE Type of field of study such as major, minor, concentration, vocational. VARCHAR2(63)

SORLFOS

SORLFOS_LFST_CODE

FIELD_OF_STUDY_TYPE_DESC Field of study type description VARCHAR2(255)

GTVLFST

GTVLFST_DESC

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

SPRIDEN

SPRIDEN_ID

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

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_TERM_CODE_END

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

NA

NA

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

NA

NA

NAME Combination of the person's last, first, and middle initial into one value. VARCHAR2(94)

FUNCTION

FORMAT_NAME

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

SORLFOS

SORLFOS_ROLLED_SEQNO

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

SORLFOS

SORLFOS_PIDM

PRIORITY Identifies the significance within ranking this field of study for a curricula. NUMBER

SORLFOS

SORLFOS_PRIORITY_NO

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

NA

NA

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

SORLCUR

SORLCUR_PROGRAM

PROGRAM_CLASSIFICATION Program classification associated with the major subject area of study for this outcome. Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government. VARCHAR2(63)

STVMAJR

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

FUNCTION

GOKODSF.F_GET_DESC

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

SORLCUR

SORLCUR_LMOD_CODE

SOURCE_DESC Student or learner source description. VARCHAR2(255)

STVLMOD

STVLMOD_DESC

SOURCE_SEQUENCE_NUMBER Sequence number of the source key record. NUMBER

SORLCUR

SORLCUR_KEY_SEQNO

START_DATE Date the student became active in this field of study. DATE

SORLFOS

SORLFOS_START_DATE

STUDENT_LEVEL Student level associated with the coursework in the academic outcome. Examples, include undergraduate and graduate, etc. VARCHAR2(63)

SORLCUR

SORLCUR_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC



Ver: 3.1