Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(6)	SORLFOS	SORLFOS_TERM_CODE
ACADEMIC_PERIOD_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 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)	STVMAJR	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 and curriculum sequence.	VARCHAR2(1)	SORLFOS	SORLFOS_CURRENT_CDE
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)	STVCSTS	STVCSTS_DESC
CURRICULUM_SEQUENCE	System generated one-up number assigned to a student or learner for a curriculum or curriculum changes.	NUMBER	SORLFOS	SORLFOS_LCUR_SEQNO
DEPARTMENT	Department responsible for the major subject area of a student course or associated with the major within the student academic 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)	STVCACT	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)	STVMAJR	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)	GTVLFST	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	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
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(6)	STVMAJR	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	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: