Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period or time frame associated with this outcome or degree record.	VARCHAR2(63)		SHRDGMR	SHRDGMR_TERM_CODE_STUREC
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_PERIOD_GRADUATION	Academic Period Graduation	Academic period when graduation requirements were or will be completed.	VARCHAR2(63)		SHRDGMR	SHRDGMR_TERM_CODE_GRAD
ACADEMIC_PERIOD_GRAD_DESC	Academic Period Graduate Description	Academic period description.	VARCHAR2(255)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR_GRADUATION	Year of Graduation	Year associated with this graduation date.	VARCHAR2(63)		SHRDGMR	SHRDGMR_ACYR_CODE
ACADEMIC_YEAR_GRADUATION_DESC	Year Graduation Description	Graduation year description.	VARCHAR2(255)		STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
APPLIED_FOR_OUTCOME_IND	Applied For Outcome Indicator	Indicates whether the person has applied to officially receive this specific degree or award as an academic outcome.	VARCHAR2(1)		FUNCTION	F_APPLIED_FOR_DEGREE
AWARD_CATEGORY	Award Category	Award category associated with the outcome, degree or award. Category used to group outcomes for reporting similar awards together. For example, less than two year, two year and four year awards.	VARCHAR2(63)		STVDEGC	STVDEGC_ACAT_CODE
AWARD_CATEGORY_DESC	Award Category Description	Award category description.	VARCHAR2(255)		STVACAT	STVACAT_DESC
BULLETIN_YEAR	Bulletin Year	Academic year associated with the documented requirements to be completed for this academic outcome to be confirmed.	VARCHAR2(63)		SHRDGMR	SHRDGMR_ACYR_CODE_BULLETIN
BULLETIN_YEAR_DESC	Bulletin Year Description	Academic year description.	VARCHAR2(255)		STVACYR	STVACYR_DESC
CAMPUS	Campus	Campus associated to where the academic outcome requirements were completed.	VARCHAR2(63)		SORLCUR	SORLCUR_CAMP_CODE
CAMPUS_DESC	Campus Description	Institution campus name.	VARCHAR2(255)		STVCAMP	STVCAMP_DESC
COLLEGE	College	College, faculty or school to which the academic study for the student is associated.	VARCHAR2(63)		SORLCUR	SORLCUR_COLL_CODE
COLLEGE_DESC	College Description	College, faculty or school name.	VARCHAR2(255)		STVCOLL	STVCOLL_DESC
CREDITS_ATTEMPTED	Credits Attempted	Sum of credits attempted by a student for this academic outcome.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
CREDITS_EARNED	Credits Earned	Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
CREDITS_PASSED	Credits Passed	Sum of credits passed by a student for this academic outcome.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
CURRICULUM_ORDER	Curriculum Order	Unique sequence number that identifies this academic study or program for the student.	NUMBER		CALCULATION	ROW_NUMBER
CURRICULUM_PRIORITY_NUMBER	Curriculum Priority Number	Identifies the significanct ranking for a curricula.	NUMBER		SORLCUR	SORLCUR_PRIORITY_NO
DEGREE	Degree	Degree or award code associated with the academic study.	VARCHAR2(63)		SORLCUR	SORLCUR_DEGC_CODE
DEGREE_DESC	Degree Description	Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.	VARCHAR2(255)		STVDEGC	STVDEGC_DESC
DEPARTMENT	Department	Department responsible to verify that the academic outcome requirements have been completed.	VARCHAR2(63)		SORLFOS	SORLFOS_DEPT_CODE
DEPARTMENTAL_HONORS_COUNT	Departmental Honors Count	Count of all honors recorded for the student. Indicates the honor was approved by the department.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_HONORS
DEPARTMENT_DESC	Department Description	Department name.	VARCHAR2(255)		STVDEPT	STVDEPT_DESC
FIRST_CONCENTRATION	First Concentration	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
FIRST_CONCENTRATION_DESC	First Concentration Description	Concentration or study emphasis description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
FIRST_MINOR	First Minor	Minor subject area of the person's academic study.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
FIRST_MINOR_DESC	First Minor Description	Minor subject area of study description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
FOURTH_DEPARTMENT	Fourth Department	Department responsible for this major subject area of academic instruction.	VARCHAR2(63)		SORLFOS	SORLFOS_DEPT_CODE
FOURTH_DEPARTMENT_DESC	Fourth Department Description	Department name.	VARCHAR2(255)		STVDEPT	STVDEPT_DESC
FOURTH_MAJOR	Fourth Major	Subject area or major focus recorded for the student's academic study. This may be blank.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_1	Fourth Major Concentration 1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_1_DESC	Fourth Major Concentration 1 Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_CONC_2	Fourth Major Concentration 2	Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_2_DESC	Fourth Major Concentration 2 Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_CONC_3	Fourth Major Concentration 3	Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MAJOR_CONC_3_DESC	Fourth Major Concentration Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_DESC	Fourth Major Description	Major or subject area of study description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
FOURTH_MINOR	Fourth Minor	Fourth minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
FOURTH_MINOR_DESC	Fourth Minor Description	Minor area of study description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
FOURTH_PROGRAM_CLASSIFICATION	Fourth Program Classification	Program classification associated with the major subject area of study for this academic outcome. This may be Classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(63)		STVMAJR	STVMAJR_CIPC_CODE
FOURTH_PROGRAM_CLASSIF_DESC	Fourth Program Classification Description	Program classification code description.	VARCHAR2(255)		STVCIPC	STVCIPC_DESC
GPA	Grade Point Average or Average	Calculated grade point average or average for the set of courses completed.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
GPA_CREDITS	Credits for GPA or Average calculation	Credits used to calculate the average or grade point average for the courses used to complete the outcome requirements.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
GRADUATED_IND	Graduated Indicator	Indicates whether the person has earned this degree or other award from the institution.	VARCHAR2(1)		FUNCTION	DECODE(STVDEGS_AWARD_STATUS_IND,'A','Y','N')
GRADUATION_STATUS	Graduation Status	Identifies that an academic outcome is completed or still being sought, etc.	VARCHAR2(3)		SHRDGMR	SHRDGMR_GRST_CODE
GRADUATION_STATUS_DESC	Graduation Status Description	Current graduation status description.	VARCHAR2(255)		STVGRST	STVGRST_DESC
GRAD_AUTHORIZED_ADDS_CHGS	Graduate Authorized Additonal Charges	Identifies that the student is authorized to add or drop based on graduation requirements.	VARCHAR2(63)		SHRDGMR	SHRDGMR_AUTHORIZED
GRAD_REQ_COMPLETED_ACAD_PER	Graduate Req Completed Acad Period	Academic period when all graduation requirements were completed or will be completed.	VARCHAR2(63)		SHRDGMR	SHRDGMR_TERM_CODE_COMPLETED
GRAD_REQ_COMP_ACAD_PER_DESC	Graduate Req Comp Acad Period Description	Academic period description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
HONORS_COUNT	Honors Count	Count of all honors recorded for the student.	NUMBER		FUNCTION	MSKFUNC.F_COUNT_HONORS
ID	ID	Student's current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INSTITUTIONAL_HONORS_COUNT	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		FUNCTION	MSKFUNC.F_COUNT_HONORS
INSTITUTION_CREDITS_ATTEMPTED	Institution Credits Attempted	Sum of institution course credits attempted by a student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTITUTION_CREDITS_EARNED	Institution Credits Earned	Sum of institution course credits earned by a student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTITUTION_CREDITS_PASSED	Institution Credits Passed	Sum of institution course credits passed by a student for this academic outcome.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTITUTION_GPA	Institution GPA - Grade Point Average or Average	Calculated of institution course grade point average or average for the set of courses completed.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTITUTION_GPA_CREDITS	Institution GPA - Grade Point Average or Average Credits	Sum of institution course credits used in the GPA calculations for this student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTITUTION_QUALITY_POINTS	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
MAJOR	Major	First subject area or major focus recorded for the student's curriculum. This may not be blank.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
MAJOR_DESC	Major Description	Name of the student's major subject area.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Name of the student (Last name, First name Middle Initial format).	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICIAL_DOCUMENT_NAME	Official Name on Award	Name of the person as it appears on the outcome document.	VARCHAR2(500)		SHBDIPL	SHBDIPL_NAME
OUTCOME_APPLICATION_DATE	Outcome Application Date	Date that the student applied for graduation in this academic outcome.	DATE		SHRDGMR	SHRDGMR_APPL_DATE
OUTCOME_AWARDED_IND	Outcome Awarded Indicator	Identifies whether the academic outcome, award or degree has been officially awarded to the person.	VARCHAR2(1)		STVDEGS	STVDEGS_AWARD_STATUS_IND
OUTCOME_GRADUATION_DATE	Outcome Graduation Date	Date for the formal graduation for this academic outcome. This is the date that the completion of this degree or award is confirmed.	DATE		SHRDGMR	SHRDGMR_GRAD_DATE
OUTCOME_NUMBER	Outcome Number	Degree or award sequence number for this academic outcome for the student.	NUMBER		SHRDGMR	SHRDGMR_SEQ_NO
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to the person.	NUMBER		SHRDGMR	SHRDGMR_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PROGRAM	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	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)		STVMAJR	STVMAJR_CIPC_CODE
PROGRAM_CLASSIFICATION_DESC	Program Classification Description	Program classification description.	VARCHAR2(255)		STVCIPC	STVCIPC_DESC
PROGRAM_DESC	Program Description	Program or course of study description.	VARCHAR2(255)		SMRPRLE	SMRPRLE_PROGRAM_DESC
QUALITY_POINTS	Quality Points	Quality points used to calculate the grade point average for this academic outcome.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
SECOND_CONCENTRATION	Second Concentration	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
SECOND_CONCENTRATION_DESC	Second Concentration Description	Concentration or study emphasis description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
SECOND_DEPARTMENT	Second Department	Department responsible for the second major or subject area of academic instruction.	VARCHAR2(63)		SORLFOS	SORLFOS_DEPT_CODE
SECOND_DEPARTMENT_DESC	Second Department Description	Department name.	VARCHAR2(255)		STVDEPT	STVDEPT_DESC
SECOND_MAJOR	Second Major	Subject area or major focus recorded for the student's academic study. This may be blank.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_1	Second Major Concentration 1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_1_DESC	Second Major Concentration 1 Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_2	Second Major Concentration 2	Second concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_2_DESC	Second Major Concentration 2 Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_3	Second Major Concentration 3	Third concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
SECOND_MAJOR_CONC_3_DESC	Second Major Concentration 3 Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
SECOND_MAJOR_DESC	Second Major Description	Major or subject area of study description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
SECOND_MINOR	Second Minor	Second minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
SECOND_MINOR_DESC	Second Minor Description	Minor subject area of study description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
SECOND_PROGRAM_CLASSIFICATION	Second Program Classification	Program classification associated with the major subject area of study for this outcome. This may be the Classification of Program (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(63)		STVMAJR	STVMAJR_CIPC_CODE
SECOND_PROGRAM_CLASSIF_DESC	Second Program Classif Description	Program classification code description.	VARCHAR2(255)		STVCIPC	STVCIPC_DESC
STATUS	Status	Current status of the academic outcome. For example, pending, awarded, etc.	VARCHAR2(63)		SHRDGMR	SHRDGMR_DEGS_CODE
STATUS_DESC	Status Description	Outcome or award status description.	VARCHAR2(255)		STVDEGS	STVDEGS_DESC
STUDENT_LEVEL	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	Student level description.	VARCHAR2(255)		STVLEVL	STVLEVL_DESC
SUB_ACADEMIC_PERIOD_GRADUATION	Sub Academic Period Graduation	Graduation sub academic period or portion of the academic period when recorded for the student's completion.	VARCHAR2(63)		NA	NA
SUB_ACADEMIC_PERIOD_GRAD_DESC	Sub Academic Period Graduate Description	Sub academic period description.	VARCHAR2(255)		NA	NA
THIRD_CONCENTRATION	Third Concentration	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
THIRD_CONCENTRATION_DESC	Third Concentration Description	Concentration or study emphasis description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
THIRD_DEPARTMENT	Third Department	Department responsible for the major or subject area of academic instruction.	VARCHAR2(63)		SORLFOS	SORLFOS_DEPT_CODE
THIRD_DEPARTMENT_DESC	Third Department Description	Department name.	VARCHAR2(255)		STVDEPT	STVDEPT_DESC
THIRD_MAJOR	Third Major	Subject area or major focus recorded for the student's academic study. This may be blank.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_1	Third Major Concentration 1	First concentration or focus of study within this student's major. This may be blank when concentrations are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_1_DESC	Third Major Concentration 1 Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
THIRD_MAJOR_CONC_2	Third Major Concentration 2	Second concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_2_DESC	Third Major Concentration 2 Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
THIRD_MAJOR_CONC_3	Third Major Concentration	Third concentration or focus of study within this student's major. This may be blank when concentration are not being used or when this major does not have a concentration or emphasis.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
THIRD_MAJOR_CONC_3_DESC	Third Major Concentration Description	Student's concentration description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
THIRD_MAJOR_DESC	Third Major Description	Major or subject area of study description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
THIRD_MINOR	Third Minor	Third minor for the student within this academic study. This may be blank when no minor has been specified.	VARCHAR2(63)		SORLFOS	SORLFOS_MAJR_CODE
THIRD_MINOR_DESC	Third Minor Description	Minor area of study description.	VARCHAR2(255)		STVMAJR	STVMAJR_DESC
THIRD_PROGRAM_CLASSIFICATION	Third Program Classification	Program classification associated with the major subject area of study for this academic outcome. This may be the classification of Institutional Program (CIP) codes used for reporting outcomes to the federal government.	VARCHAR2(63)		STVMAJR	STVMAJR_CIPC_CODE
THIRD_PROGRAM_CLASSIF_DESC	Third Program Classification Description	Program classification code description.	VARCHAR2(255)		STVCIPC	STVCIPC_DESC
TRANSFER_CREDITS_ATTEMPTED	Transfer Credits Attempted	Sum of transfer course credits attempted by a student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_CREDITS_EARNED	Transfer Credits Earned	Sum of transfer course credits earned by a student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_CREDITS_PASSED	Transfer Credits Passed	Sum of transfer course credits passed by a student for this academic outcome.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_GPA	Transfer GPA - Grade Point Average or Average	Calculated of transfer course grade point average or average for the set of courses completed.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_GPA_CREDITS	Transfer GPA - Grade Point Average or Average Credits	Sum of transfer course credits used in the GPA calculations for this student.	NUMBER		FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_QUALITY_POINTS	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
TRANSFER_WORK_EXISTS_IND	Transfer Work Exists Indicator	Indicates whether any transfer credits are recorded for the student that apply to this academic outcome.	VARCHAR2(1)		FUNCTION	F_CHECK_FOR_TRANSFER_WORK

Ver: 9.0