Target Column	Business Definition	Database Data Type	Source Name	Source Column
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.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
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 description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR_GRADUATION	Academic year associated with this graduation date.	VARCHAR2(63)	SHRDGMR	SHRDGMR_ACYR_CODE
ACADEMIC_YEAR_GRADUATION_DESC	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
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	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 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.	VARCHAR2(255)	STVACAT	STVACAT_DESC
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	Academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
CAMPUS	Campus associated to where the academic outcome requirements were completed.	VARCHAR2(63)	SORLCUR	SORLCUR_CAMP_CODE
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_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
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 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	Sum of credits passed by a student for this academic outcome.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
CURRICULUM_ORDER	Unique sequence number that identifies this academic study or program for the student.	NUMBER	CALCULATION	ROW_NUMBER
CURRICULUM_PRIORITY_NUMBER	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 responsible to verify that the academic outcome requirements have been completed.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE
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 name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
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	Concentration or study emphasis description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
FIRST_MINOR	Minor subject area of the person's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE
FIRST_MINOR_DESC	Minor subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
FOURTH_DEPARTMENT	Department responsible for this major subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE
FOURTH_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
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	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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_CONC_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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_CONC_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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
FOURTH_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
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	Minor area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
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	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
GPA	Calculated grade point average or average for the set of courses completed.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
GPA_CREDITS	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	Indicates whether the person has graduated or earned any degrees or other awards as academic outcomes to date from this institution.	VARCHAR2(1)	FUNCTION	DECODE(STVDEGS_AWARD_STATUS_IND,'A','Y','N')
GRADUATION_STATUS	Identifies that an academic outcome is completed or still being sought, etc.	VARCHAR2(3)	SHRDGMR	SHRDGMR_GRST_CODE
GRADUATION_STATUS_DESC	Current graduation status description.	VARCHAR2(255)	STVGRST	STVGRST_DESC
GRAD_AUTHORIZED_ADDS_CHGS	Identifies that the student is authorized to add or drop based on graduation requirements.	VARCHAR2(63)	SHRDGMR	SHRDGMR_AUTHORIZED
GRAD_REQ_COMPLETED_ACAD_PER	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	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HONORS_COUNT	Count of all honors recorded for the student.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_HONORS
ID	Student's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
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	Name of the student's major subject area.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
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 for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name of the student (Last name, First name Middle Initial format).	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
OFFICIAL_DOCUMENT_NAME	Name of the person as it appears on the outcome document.	VARCHAR2(500)	SHBDIPL	SHBDIPL_NAME
OUTCOME_APPLICATION_DATE	Date that the student applied for graduation in this academic outcome.	DATE	SHRDGMR	SHRDGMR_APPL_DATE
OUTCOME_AWARDED_IND	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	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	Degree or award sequence number for this academic outcome for the student.	NUMBER	SHRDGMR	SHRDGMR_SEQ_NO
PERSON_UID	System generated, unique, internal identification number assigned to the person.	NUMBER	SHRDGMR	SHRDGMR_PIDM
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. 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.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
PROGRAM_DESC	Program or course of study description.	VARCHAR2(255)	SMRPRLE	SMRPRLE_PROGRAM_DESC
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	Concentration or study emphasis attached to the major for the student's academic study.	VARCHAR2(63)	SORLFOS	SORLFOS_MAJR_CODE
SECOND_CONCENTRATION_DESC	Concentration or study emphasis description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SECOND_DEPARTMENT	Department responsible for the second major or subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE
SECOND_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
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	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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_CONC_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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
SECOND_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
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	Minor subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
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 reproting outcomes to the federal government.	VARCHAR2(63)	STVMAJR	STVMAJR_CIPC_CODE
SECOND_PROGRAM_CLASSIF_DESC	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
STATUS	Current status of the academic outcome. For example, pending, awarded, etc.	VARCHAR2(63)	SHRDGMR	SHRDGMR_DEGS_CODE
STATUS_DESC	Outcome or award status description.	VARCHAR2(255)	STVDEGS	STVDEGS_DESC
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
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 description.	VARCHAR2(255)	NA	NA
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	Concentration or study emphasis description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
THIRD_DEPARTMENT	Department responsible for the major or subject area of academic instruction.	VARCHAR2(63)	SORLFOS	SORLFOS_DEPT_CODE
THIRD_DEPARTMENT_DESC	Department name.	VARCHAR2(255)	STVDEPT	STVDEPT_DESC
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	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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
THIRD_MAJOR_CONC_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	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
THIRD_MAJOR_CONC_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
THIRD_MAJOR_CONC_3_DESC	Student's concentration description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
THIRD_MAJOR_DESC	Major or subject area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
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	Minor area of study description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
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	Program classification code description.	VARCHAR2(255)	STVCIPC	STVCIPC_DESC
TRANSFER_WORK_EXISTS_IND	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: 8.1