ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_PERIOD	Academic period or time frame this person applied to study at this institution.			SORLFOS	SORLFOS_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.			STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic year associated with the academic period on this record.			STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.			STVACYR	STVACYR_DESC
ACTIVE_IND	Indicates whether the student is active in this field of study.			SOBCACT	SOBCACT_ACTIVE_IND
ACTIVITY_DATE	Date record was inserted or updated.			SORLFOS	SORLFOS_ACTIVITY_DATE
AID_ELIGIBILITY_IND	Indicates the field of study is eligible for financial assistance or aid from the institution.			STVMAJR	STVMAJR_AID_ELIGIBILITY_IND
CATALOG_ACADEMIC_PERIOD	Catalog academic period used to measure completion requirements for the outcome.			SORLFOS	SORLFOS_TERM_CODE_CTLG
CATALOG_ACADEMIC_PERIOD_DESC	Catalog academic period description.			FUNCTION	GOKODSF.F_GET_DESC
CONCENTRATION_MAJOR	Identifies the major subject area when the field of study type is a concentration.			SORLFOS	SORLFOS_MAJR_CODE_ATTACH
CONCENTRATION_MAJOR_DESC	Major subject area name.			FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE	System current date (sysdate) or date the data was extracted.			NA	SYSDATE
CURRENT_IND	Indicates whether this is the most recent field of study record for this academic period.			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.			SORLFOS	SORLFOS_TMST_CODE
CURRENT_TIME_STATUS_DESC	Current time status description.			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.			SORLFOS	SORLFOS_CSTS_CODE
CURRICULUM_CHANGE_REASON_DESC	Curriculum change reason description.			STVCSTS	STVCSTS_DESC
CURRICULUM_SEQUENCE	System generated one-up number assigned to a student or learner for a curriculum or curriculum changes.			SORLFOS	SORLFOS_LCUR_SEQNO
DEPARTMENT	Department associated with the field of study.			SORLFOS	SORLFOS_DEPT_CODE
DEPARTMENT_DESC	Department name.			FUNCTION	GOKODSF.F_GET_DESC
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.			NA	NA
END_DATE	Date the student became inactive in this field of study.			SORLFOS	SORLFOS_END_DATE
FIELD_OF_STUDY	Identifies the field of study, for example, major, concentration, minor within this record.			SORLFOS	SORLFOS_MAJR_CODE
FIELD_OF_STUDY_ACTIVITY_DESC	Field of study activity status description.			STVCACT	STVCACT_DESC
FIELD_OF_STUDY_ACTIVITY_STATUS	Identifies the student current status or activity within this field of study.			SORLFOS	SORLFOS_CACT_CODE
FIELD_OF_STUDY_DESC	Field of study description.			STVMAJR	STVMAJR_DESC
FIELD_OF_STUDY_TYPE	Type of field of study such as major, minor, concentration, vocational.			SORLFOS	SORLFOS_LFST_CODE
FIELD_OF_STUDY_TYPE_DESC	Field of study type description			GTVLFST	GTVLFST_DESC
LAST_ACADEMIC_PERIOD_DESC	Field of study last active academic period desc.			FUNCTION	GOKODSF.F_GET_DESC
LAST_ACTIVE_ACADEMIC_PERIOD	Field of study last active academic period.			SORLFOS	SORLFOS_TERM_CODE_END
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
OUTCOME_NUMBER	Degree or award sequence number for this academic outcome for the student.			SORLFOS	SORLFOS_ROLLED_SEQNO
PERSON_UID	System generated, unique, internal identification number assigned to this person.			SORLFOS	SORLFOS_PIDM
PRIORITY	Identifies the significance within ranking this field of study for a curricula.			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.			STVMAJR	STVMAJR_CIPC_CODE
PROGRAM_CLASSIFICATION_DESC	Program classification description.			FUNCTION	GOKODSF.F_GET_DESC
SEQUENCE_NUMBER	System generated one-up number assigned to a field of study for the student or learner.			SORLFOS	SORLFOS_SEQNO
START_DATE	Date the student became active in this field of study.			SORLFOS	SORLFOS_START_DATE
USER_ID	Unique identification code of the user who entered or last touched the transaction.			SORLFOS	SORLFOS_USER_ID
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA

Ver: 8.3