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

SGHE Banner Operational Data Store
Composite View Target: AS_FIELD_OF_STUDY

Description Source composite view contains all active, inactive, current, and and non-current fields of study 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)

SORLFOS

SORLFOS_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(30)

FUNCTION

STVTERM

GOKODSF.F_GET_DESC

STVTERM_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 field of study. VARCHAR2(1)

SOBCACT

SOBCACT_ACTIVE_IND

ACTIVITY_DATE Date record was inserted or updated. DATE

SORLFOS

SORLFOS_ACTIVITY_DATE

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

FUNCTION

STVMAJR

GOKODSF.F_GET_DESC

STVMAJR_AID_ELIGIBILITY_IND

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

SORLFOS

SORLFOS_TERM_CODE_CTLG

CATALOG_ACADEMIC_PERIOD_DESC Catalog academic period description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_MAJR_CODE_ATTACH

CONCENTRATION_MAJOR_DESC Major subject area name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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 field of study record for this academic period. VARCHAR2(1)

FUNCTION

GOKODSF.F_FIND_CURRENT_ALL_IND

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

SORLFOS

SORLFOS_TMST_CODE

CURRENT_TIME_STATUS_DESC Current time status description. VARCHAR2(30)

FUNCTION

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

SORLFOS

SORLFOS_CSTS_CODE

CURRICULUM_CHANGE_REASON_DESC Curriculum change reason description. VARCHAR2(30)

FUNCTION

STVCSTS

GOKODSF.F_GET_DESC

STVCSTS_DESC

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

SORLFOS

SORLFOS_LCUR_SEQNO

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

SORLFOS

SORLFOS_DEPT_CODE

DEPARTMENT_DESC Department name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_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 field of study. DATE

SORLFOS

SORLFOS_END_DATE

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

SORLFOS

SORLFOS_MAJR_CODE

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

FUNCTION

STVCACT

GOKODSF.F_GET_DESC

STVCACT_DESC

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

SORLFOS

SORLFOS_CACT_CODE

FIELD_OF_STUDY_DESC Field of study description. VARCHAR2(30)

FUNCTION

STVMAJR

GOKODSF.F_GET_DESC

STVMAJR_DESC

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

SORLFOS

SORLFOS_LFST_CODE

FIELD_OF_STUDY_TYPE_DESC Field of study type description VARCHAR2(30)

FUNCTION

GTVLFST

GOKODSF.F_GET_DESC

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

SORLFOS

SORLFOS_TERM_CODE_END

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)

SORLFOS

SORLFOS_ROLLED_SEQNO

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

SORLFOS

SORLFOS_PIDM

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

SORLFOS

SORLFOS_PRIORITY_NO

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

FUNCTION

STVMAJR

GOKODSF.F_GET_DESC

STVMAJR_CIPC_CODE

PROGRAM_CLASSIFICATION_DESC Program classification description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

SEQUENCE_NUMBER System generated one-up number assigned to a field of study for the student or learner. NUMBER(4)

SORLFOS

SORLFOS_SEQNO

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

SORLFOS

SORLFOS_START_DATE

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

SORLFOS

SORLFOS_USER_ID

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

NA

NA



Ver: 8.0