Target Column	Business Definition	Database Data Type	Source Name	Source Column
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)	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	Year associated with this graduation date.	VARCHAR2(63)	SHRDGMR	SHRDGMR_ACYR_CODE
ACADEMIC_YEAR_GRADUATION_DESC	Graduation year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC
ADMINISTRATIVE_GROUP	Administrative-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	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
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 with this record. Campus for the course section, student course, student, applied for on the admission application, etc.	VARCHAR2(63)	SORLCUR	SORLCUR_CAMP_CODE
CAMPUS_DESC	Institution campus name.	VARCHAR2(255)	STVCAMP	STVCAMP_DESC
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
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	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
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 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
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 earned this degree or other award from the 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	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
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	Sum of institution course credits attempted by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
INSTITUTION_CREDITS_EARNED	Sum of institution course credits earned by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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	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	Sum of institution course credits used in the GPA calculations for this student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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 subject area of the person's academic study.	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	NA SHRDGMR	SOKODSF.F_COUNT_COMPLETED_OUTCOMES 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	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
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
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	Major subject area of the person's academic study.	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 reporting 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	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, 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_CREDITS_ATTEMPTED	Sum of transfer course credits attempted by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
TRANSFER_CREDITS_EARNED	Sum of transfer course credits earned by a student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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	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	Sum of transfer course credits used in the GPA calculations for this student.	NUMBER	FUNCTION	SOKODSF.F_GET_DEGREE_GPA_DATA
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	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.1