Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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	Academic period description.	VARCHAR2(30)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR	Academic Year	Academic year associated with the academic period on this record.	VARCHAR2(4)		STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic Year Description	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	Aid Eligibility Indicator	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	Current Indicator	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	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(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 Description	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	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	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(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	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)		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(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: