Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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(63)	SORLFOS	SORLFOS_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
ACTIVE_IND	Indicates whether the student is active in this field of study.	VARCHAR2(1)	SOBCACT	SOBCACT_ACTIVE_IND	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
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	NO	NO
CAMPUS	Campus associated with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(63)	SORLCUR	SORLCUR_CAMP_CODE	NO	NO
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC	NO	NO
CATALOG_ACADEMIC_PERIOD	Catalog academic period used to measure completion requirements for the outcome.	VARCHAR2(63)	SORLFOS	SORLFOS_TERM_CODE_CTLG	NO	NO
CATALOG_ACADEMIC_PERIOD_DESC	Catalog academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(63)	SORLCUR	SORLCUR_COLL_CODE	NO	NO
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
CONCENTRATION_MAJOR	Identifies the major subject area when the field of study type is a concentration.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE_ATTACH	NO	NO
CONCENTRATION_MAJOR_DESC	Major subject area name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CURRENT_IND	Indicates whether this is the most recent field of study record for this academic period and curriculum sequrence.	VARCHAR2(1)	SORLFOS	SORLFOS_CURRENT_CDE	NO	NO
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	NO	NO
CURRENT_TIME_STATUS_DESC	Current time status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
CURRICULUM_ACTIVE_IND	Indicates whether the student is active in this curriculum.	VARCHAR2(1)	SOBCACT	SOBCACT_ACTIVE_IND	NO	NO
CURRICULUM_ACTIVITY_STATUS	Identifies the student current status or activity within this curriculum.	VARCHAR2(63)	SORLFOS	SORLFOS_CACT_CODE	NO	NO
CURRICULUM_ACTIVITY_STAT_DESC	Curriculum activity status description.	VARCHAR2(255)	STVCACT	STVCACT_DESC	NO	NO
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	NO	NO
CURRICULUM_CHANGE_REASON_DESC	Curriculum change reason description.	VARCHAR2(255)	STVCSTS	STVCSTS_DESC	NO	NO
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	NO	NO
CURRICULUM_PRIORITY	Identifies the significanct ranking for a curricula.	NUMBER	SORLCUR	SORLCUR_PRIORITY_NO	NO	NO
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate. This information will be taken from the ODS Academic Study or Academic Outcome or Admissions Application reporting view as appropriate for the star scheme.	VARCHAR2(63)	SORLCUR	SORLCUR_DEGC_CODE	NO	NO
DEGREE_DESC	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC	NO	NO
DEPARTMENT	Department responsible for the major subject area of a student course or associated with the major within the student academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
DEPARTMENT_DESC	Department name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
END_DATE	Date the student became inactive in this field of study.	DATE	SORLFOS	SORLFOS_END_DATE	NO	NO
EXPECTED_GRADUATION_DATE	Expected graduation date.	DATE	CALCULATION	NVL(SORLCUR_EXP_GRAD_DATE, SGBSTDN_EXP_GRAD_DATE)	NO	NO
FIELD_OF_STUDY	Identifies the field of study, for example, major, concentration, minor within this record.	VARCHAR2(63)	SORLCUR	SORLCUR_EXP_GRAD_DATE	NO	NO
FIELD_OF_STUDY_ACTIVITY_DESC	Field of study activity status description.	VARCHAR2(255)	STVCACT	STVCACT_DESC	NO	NO
FIELD_OF_STUDY_ACTIVITY_STATUS	Identifies the student current status or activity within this field of study.	VARCHAR2(63)	SORLFOS	SORLFOS_CACT_CODE	NO	NO
FIELD_OF_STUDY_DESC	Field of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
FIELD_OF_STUDY_TYPE	Type of field of study such as major, minor, concentration, vocational.	VARCHAR2(63)	SORLFOS	SORLFOS_LFST_CODE	NO	NO
FIELD_OF_STUDY_TYPE_DESC	Field of study type description.	VARCHAR2(255)	GTVLFST	GTVLFST_DESC	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
LAST_ACADEMIC_PERIOD_DESC	Field of study last active academic period desc.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
LAST_ACTIVE_ACADEMIC_PERIOD	Field of study last active academic period.	VARCHAR2(63)	SORLFOS	SORLFOS_TERM_CODE_END	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Combination of the person's last, first, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
OUTCOME_NUMBER	Degree or award sequence number for this academic outcome for the student.	NUMBER	SORLFOS	SORLFOS_ROLLED_SEQNO	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SORLFOS	SORLFOS_PIDM	NO	NO
PRIORITY	Identifies the significance within ranking this field of study for a curricula.	NUMBER	SORLFOS	SORLFOS_PRIORITY_NO	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
PROGRAM	Student's program, curriculum or course of study. This may be Data Not Available when program codes have not been defined by the institution. The alternate curriculum identification is by a combination of college, degree and major codes.	VARCHAR2(63)	SORLCUR	SORLCUR_PROGRAM	NO	NO
PROGRAM_CLASSIFICATION	Classification of Instructional Program (CIP) codes assigned to an area of study and used for governmental reporting.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE	NO	NO
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
PROGRAM_DESC	Program or course of study description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_DESC	NO	NO
SOURCE	Administrative system source for this record. For example, recruiting, admissions, learner, academic outcome.	VARCHAR2(63)	SORLCUR	SORLCUR_LMOD_CODE	NO	NO
SOURCE_DESC	Student or learner source description.	VARCHAR2(255)	STVLMOD	STVLMOD_DESC	NO	NO
SOURCE_SEQUENCE_NUMBER	Sequence number of the source key record.	NUMBER	SORLCUR	SORLCUR_KEY_SEQNO	NO	NO
START_DATE	Date the student became active in this field of study.	DATE	SORLFOS	SORLFOS_START_DATE	NO	NO
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	SORLCUR	SORLCUR_LEVL_CODE	NO	NO
STUDENT_LEVEL_DESC	Student level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC	NO	NO

Ver: 9.2