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)	STVCAMP	STVCAMP_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)	STVTERM	STVTERM_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)	SORLCUR	SORLCUR_EXP_GRAD_DATE
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)	STVTERM	STVTERM_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(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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)	SMRPRLE	SMRPRLE_PROGRAM_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: 8.1