Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD_GRADUATION	Academic period when graduation requirements were completed.	VARCHAR2(63)	SORDEGR	SORDEGR_TERM_DEGREE	NO	NO
ACADEMIC_PERIOD_GRAD_DESC	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ACADEMIC_YEAR_GRADUATION	Academic year associated with this graduation date.	VARCHAR2(63)	SORDEGR	SORDEGR_DEGC_YEAR	NO	NO
ACADEMIC_YEAR_GRADUATION_DESC	Academic year description.	VARCHAR2(255)	SORDEGR	SORDEGR_DEGC_YEAR	NO	NO
ADDITIONAL_MAJORS_IND	Indicates whether there are additional majors or subject areas for this academic outcome.	VARCHAR2(63)	FUNCTION	DECODE(SOKODSF.F_GET_SORMAJR_DATA)	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
ATTEND_FROM_DATE	Previous education first date of attendance.	DATE	SHRTRAM SORDEGR	SHRTRAM_ATTN_BEGIN_DATE SORDEGR_ATTEND_FROM	NO NO	NO
ATTEND_TO_DATE	Previous education last date of attendance.	DATE	SHRTRAM SORDEGR	SHRTRAM_ATTN_END_DATE SORDEGR_ATTEND_TO	NO NO	NO
AWARD_CATEGORY	Government reporting category that groups awards and degrees together to count students. For example, Less than 2 yr, 2 yr, Bachelor, etc.	VARCHAR2(63)	STVDEGC	STVDEGC_ACAT_CODE	NO	NO
AWARD_CATEGORY_DESC	Award category description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	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
COLLEGE	First level of the institution organization structure that owns the student or the academic instruction for a student course.	VARCHAR2(63)	SORDEGR	SORDEGR_COLL_CODE	NO	NO
COLLEGE_DESC	College, faculty or school name.	VARCHAR2(255)	STVCOLL	STVCOLL_DESC	NO	NO
CREDITS_ATTEMPTED	Sum of credits attempted by a student for this academic outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
CREDITS_EARNED	Sum of credits earned by a student for this academic outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
CREDITS_PASSED	Sum of credits passed by a student for this academic outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	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)	SHRTRAM SORDEGR	SHRTRAM_DEGC_CODE SORDEGR_DEGC_CODE	NO NO	NO
DEGREE_COMMENT	Free form text comments about this degree.	VARCHAR2(2000)	APRADEG	APRADEG_COMMENTS	NO	NO
DEGREE_DATE	Date the degree was awarded to the person.	DATE	SORDEGR	SORDEGR_DEGC_DATE	NO	NO
DEGREE_DESC	Description (for example, bachelor of business administration, master of arts, juris doctor, etc.) associated with the degree code.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_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)	STVDEPT	STVDEPT_DESC	NO	NO
DEPARTMENT_HONORS_COUNT	Count of all honors recorded for the student. Indicates the honor was approved by the department.	NUMBER	CALCULATION FUNCTION	DECODE(APRADEG_HOND_CODE_1) MSKFUNC.F_COUNT_HONORS	NO NO	NO
FIRST_CONCENTRATION	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used, or when the major does not have a concentration.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA	NO	NO
FIRST_CONCENTRATION_DESC	Description of the first concentration on the major.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA	NO	NO
FIRST_MINOR	Minor for the student within the academic study. This may be blank if no minor was specified.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA	NO	NO
FIRST_MINOR_DESC	First minor description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA	NO	NO
GPA	Grade point average or average calculated for this academic outcome.	VARCHAR2(63)	SORDEGR	SORDEGR_GPA_TRANSFERRED	NO	NO
GPA_CREDITS	Sum of credits used in the GPA calculation for this student for this academic outcome.	NUMBER	SORDEGR	SORDEGR_HOURS_TRANSFERRED	NO	NO
HONORS_COUNT	Count of all honors recorded for the student.	NUMBER	FUNCTION	DECODE(SORDEGR_HONR_CODE, NULL, 0, 1),	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
INSTITUTION	Institution at which the constituent earned the degree.	VARCHAR2(63)	SHRTRIT SORDEGR SORPCOL	SHRTRIT_SBGI_CODE SORDEGR_SBGI_CODE SORPCOL_SBGI_CODE	NO NO NO	NO
INSTITUTIONAL_HONORS_COUNT	Count of all honors recorded for the student. Indicate that the honor was approved at the institution level, including honors such as Cum Laude, Summa Cum Laude, First Class, etc.	NUMBER	CALCULATION FUNCTION	DECODE(APRADEG_HONR_CODE) MSKFUNC.F_COUNT_HONORS	NO NO	NO
INSTITUTION_CREDITS_ATTEMPTED	Sum of institution course credits attempted by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
INSTITUTION_CREDITS_EARNED	Sum of institution course credits earned by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
INSTITUTION_CREDITS_PASSED	Sum of institution course credits passed by a student for this academic outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
INSTITUTION_DESC	Name of the Institution.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
INSTITUTION_GPA	Calculated of institution course grade point average or average for the set of courses completed.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
INSTITUTION_GPA_CREDITS	Sum of institution course credits used in the GPA calculations for this student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
INSTITUTION_QUALITY_POINTS	Sum of institution course quality points used in the GPA calculations for this student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
INSTITUTION_TYPE	Identifies a type for the source/background institution to be used for reporting.	VARCHAR2(1)	STVSBGI	STVSBGI_TYPE_IND	NO	NO
INSTITUTION_TYPE_DESC	Type of institution description.	VARCHAR2(255)	CONSTANT	COLLEGE	NO	NO
INTERNAL_ACADEMIC_OUTCOME_IND	Indicates whether the award, degree, academic outcome was completed at a different institution as identified by the institution noted for this record. This will be set to Y when the award is from this institution and to an N when this is an external award.	VARCHAR2(1)	CONSTANT	N	NO	NO
MAJOR	Major subject area of the person's academic study.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	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 for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Person's name combining the last name, first name middle initial.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
OFFICIAL_DOCUMENT_NAME	Name of the person as it appears on the outcome document.	VARCHAR2(500)	SHBDIPL	SHBDIPL_NAME	NO	NO
OUTCOME_GRADUATION_DATE	Date for the formal completion or graduation in this academic outcome.	DATE	SORDEGR	SORDEGR_DEGC_DATE	NO	NO
OUTCOME_NUMBER	Degree or award sequence number for this academic outcome for the student.	NUMBER	SHRTRAM SORDEGR	SHRTRAM_SEQ_NO SORDEGR_DEGR_SEQ_NO	NO NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to the person.	NUMBER	SHRTRIT SORDEGR SORPCOL	SHRTRIT_PIDM SORDEGR_PIDM SORPCOL_PIDM	NO 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)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
PROGRAM_CLASSIFICATION_DESC	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
PROGRAM_DESC	Program or course of study description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_DESC	NO	NO
QUALITY_POINTS	Sum of the quality points used to calculate the grade point average for this outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
SECOND_CONCENTRATION	Second concentration or focus of study within the student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA	NO	NO
SECOND_CONCENTRATION_DESC	Student's concentration description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA	NO	NO
SECOND_DEPARTMENT	Department responsible for the second major or subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE	NO	NO
SECOND_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC	NO	NO
SECOND_MAJOR	Major subject area of the person's academic study.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
SECOND_MAJOR_CONC_1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used, or if the major does not have a concentration.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_1_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_CONC_2	Second concentration or focus of study within this student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_2_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_CONC_3	Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE	NO	NO
SECOND_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
SECOND_MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
SECOND_MINOR	Second minor for the student within this academic study. This may be blank if no minor was specified.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA	NO	NO
SECOND_MINOR_DESC	Minor area of study description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMINR_DATA	NO	NO
SECOND_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Programs (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
SECOND_PROGRAM_CLASSIF_DESC	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	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
SUB_ACADEMIC_PERIOD_GRAD	Graduation date within this sub academic period.	VARCHAR2(63)	NA	NA	NO	NO
SUB_ACADEMIC_PERIOD_GRAD_DESC	Sub academic period description.	VARCHAR2(255)	NA	NA	NO	NO
THIRD_CONCENTRATION	Third concentration or focus of study within the student's major. This may be blank if concentrations are not being used, or if the major does not have a concentration.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA	NO	NO
THIRD_CONCENTRATION_DESC	Student's concentration description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORCONC_DATA	NO	NO
THIRD_MAJOR	Third subject area or major focus recorded for the student's curriculum. This may not be blank.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
THIRD_MAJOR_DESC	Name of the student's major subject area.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
THIRD_PROGRAM_CLASSIFICATION	Program classification associated with the major subject area of study for this outcome. This may be the Classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(63)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
THIRD_PROGRAM_CLASSIF_DESC	Program classification description.	VARCHAR2(255)	FUNCTION	SOKODSF.F_GET_SORMAJR_DATA	NO	NO
TOTAL_TRANSFER_CREDITS	Number of transfer credits received from the previous post secondary institution.	NUMBER	FUNCTION	MSKFUNC.F_CALC_TRANSFER_CREDITS	NO	NO
TRANSFER_CREDITS_ATTEMPTED	Sum of transfer course credits attempted by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
TRANSFER_CREDITS_EARNED	Sum of transfer course credits earned by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
TRANSFER_CREDITS_PASSED	Sum of transfer course credits passed by a student for this academic outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
TRANSFER_GPA	Calculated of transfer course grade point average or average for the set of courses completed.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
TRANSFER_GPA_CREDITS	Sum of transfer course credits used in the GPA calculations for this student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
TRANSFER_QUALITY_POINTS	Sum of transfer course quality points used in the GPA calculations for this student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA	NO	NO
TRANSFER_WORK_EXISTS_IND	Indicates whether any transfer credits are recorded for the student that apply to this academic outcome.	VARCHAR2(1)	CALCULATION	DECODE(SORDEGR_SBGI_CODE)	NO	NO

Ver: 9.2